PROFESSIONAL SUMMARY

• Over 6 years of IT experience in System Analysis, Design, Development, Data Modeling and Testing of various Business Applications on Client-Server environment.
• Extensive experience in BI tools like ReportNet, COGNOS Series 7.4(PowerPlay, Transformer, Enterprise Server, Architect, PowerPlay Connect, Access Manager, Impromptu Administrator, Cognos Query).
• Extensive experience on Cognos 8BI, ReportNet 1.1 with Framework Manager, Cognos Administration, Cognos Connection, Report Studio, Query Studio Analysis Studio and Metric Studio.
• Extensively used Cognos Migration Utility tool.
• Hands on experience migrating Impromptu/IWR reports to Cognos8.
• Experienced with Cognos Administration which involves Impromptu Administration, Access Manager, Cognos security administration to restrict the users.
• Experienced in Cognos 7 & 8 server administration by implementing security, configuring components, maintaining available services, statistic reporting and troubleshooting.
• Experienced in designing, developing and maintaining Cognos Impromptu and Cognos PowerPlay reports. Experience in creating Catalogs and implementing the Security using User Classes in Impromptu Administrator.
• Experienced in Requirement Gathering, Analysis, Design, Development, Testing, Documenting and Implementation of Business Applications.
• Proven expertise in analyzing the Business Intelligence needs of the enterprise and building the enterprise Reporting architecture.
• Solid analytical and dynamic troubleshooting skills. Experience in writing Business Specification documents.
• Interacted with customers for requirement gathering and effective analysis.
• Self-motivated and enjoy working in a technically challenging environment. Have excellent Communication and interpersonal skills.
• Excellent work ethics, quick learner and team oriented. Continually provided value added services to the clients through thoughtful experience and excellent communication skills.

TECHNICAL SKILLS

OLAP Tools: Cognos 8.3/8.2: Cognos Connection, Framework Manager, Query studio, Report Studio, Cognos Configuration, Analysis Studio.
ReportNet 1.1/Cognos 8: Cognos connection, Framework Manager, Query studio, Report studio, Management Tools, Server Administration Tools, Configuration Manager, Scheduler.
Cognos Series 7.x: Cognos Impromptu Administrator, Impromptu User, Impromptu Web Reports, COGNOS PowerPlay Transformer, PowerPlay User, PowerPlay Web Reports, PowerPlay Enterprise server, Upfront Administration, Access Manager, Configuration Manager, Scheduler.
Databases: Oracle 10g/9i/8i/7.3, PL/SQL, MS-SQL Server 2000/7.0, T-SQL, db2 RDBMS, MS Access 2000.
Languages: C, C++, JAVA 2.0, SQL, PL/SQL, Perl.
Web Technologies: Visual Basic 6.0/. Net, HTML, DHTML, XML, Java Script.
Other Tools : Erwin 4.0/3.5.2, TOAD, Deployment tool and Migration Utility, MS Office 2000, MS Project, SQL Analyzer, MS Excel.
Operating Systems: Windows NT 4.0/2000/XP/9x, Apache, Websphere.

EDUCATION

• Bachelor of Information Technology
• Cognos Certified BI Author

PROFESSIONAL EXPERIENCE

Confidential, Los Angeles, CA
Cognos Consultant
10/07 – 07/09

Colony Capital is a private equity firm and achieves attractive risk-adjusted returns by investing in real estate, non performing loans, distressed assets, real-estate-dependent operating companies, and select commercial and residential development opportunities throughout the world. Colony uses Cognos Business Intelligence Software for financial reporting.

Responsibilities:

• Involved in gathering Business Intelligence requirements, analyze source systems data, create and implement required metadata and define and implement business intelligence delivery mechanisms
• Involved in analysis of business and system requirements and documentation at every stage of the software development life cycle
• Involved in generating cognos reports for Fund Accounting as well as the Corporate Accounting team
• Used Cognos 8.3 to create financial statements like Balance Sheets, Income Statements and Cash Flow Statements
• Developed standard reports, drill through reports, master detail reports using Report Studio
• Worked on Cognos 8.3 framework manager to import metadata from multiple data sources and to create and publish packages to the Cognos 8.3 server
• Involved in installation and configuration of Cognos 8.3 modules
• Involved in the design and development of filters, prompts, conditional formatting, calculated columns, sub-reports and catalogs
• Created Cubes by using Impromptu Query Definition (IQD) in PowerPlay Transformer
• Used SQL Query Analyzer to analyze and test the SQL queries generated by the Cognos reports
• Used PowerPlay Enterprise Server to publish the cubes and Impromptu reports to Upfront
• Setting User Access to Cognos Products (Impromptu, IWR, Powerplay, PPES, & Upfront)
• Created Impromptu Catalog by adding tables and creating new joins

Environment: Cognos 8.3BI, Cognos Impromptu 7.4, Power Play Transformer, Access Manager, SQL Server 2000, PL/SQL, TOAD,

Confidential, Irvine, CA
Cognos8 BI Consultant/Business Analyst
10/06 – 09/07

Confidential manages product planning, marketing, sales accounts, service support and distribution of copiers, facsimiles, multifunction printing products, network controllers, and toner products throughout the United States, Mexico , Latin America, and the Caribbean . TABS has four divisions: the Electronic Imaging Division; the Toner Products Division; the Document Solutions Engineering Division; and TOPAC U.S.A., Inc., dba Toshiba Business Solutions (TBS), a wholly-owned subsidiary corporation of TABS, that operates a network of wholly owned office equipment dealers throughout the United States. The Sales Analysis System is designed for TABS using Cognos Business Intelligence Software.

Responsibilities:

• Involved in analysis of business and system requirements, development and implementation of new software, modifications to existing platforms, participation in production support for assigned application systems, and documentation at every stage of the software development life cycle
• Gathered requirements and prepared a comprehensive set of documents to define the specifications and business value of the system
• Prepared a detailed Business Requirement document
• Analyzed test strategies, test cases and test plans based on functional specification
• Collected, documented, and managed business requirements using MS Office
• Worked on Cognos8 framework manager to import metadata from multiple data sources and to create subject oriented Business models, create and publish packages to Cognos 8 server
• Customized data by adding filters at both the Framework level and Report level.
• Writing complex Cognos8 Report Studio reports, as well as the unit and system integration testing of those reports
• Created various reports using drill through, cascaded prompts, conditional formatting and master detail relationship
• Created organized and formatted reports, folders and other contents on Cognos Connection Portal
• Created customized BI reports linking various databases, to meet the user requirements
• Involved in Creating Content store, installation and Configurations of the ReportNet
• Created Models by using various data sources in PowerPlay Transformer
• Developed Standard Reports, Charts, Drill Through Reports, Master Detail Reports and Bursting Reports using Impromptu Administrator, Report Studio and Query Studio
• Built models using Framework Manager and developed Standard Templates
• Involved in Testing and Exploring Report Studio and Query Studio
• Worked on Cognos Security Administration to restrict the users
• Creating Query Prompts, calculations, Conditions & Filters and creating New Jobs using Cognos Connection
• Used PowerPlay Enterprise Server to publish the cubes and Impromptu reports to the Upfront

Environment: Cognos 8BI, ReportNet 1.1, Impromptu Administrator, ReportStudio, QueryStudio, Analysis Studio, Transformer 7.4, PowerPlay 7.4, PowerPlay Enterprise Server 7.4, SunOne Directory Server, Access Manager, Oracle 10g, TOAD, Erwin, MS-Excel, Shell Scripts Windows 2000 and Unix HP-UX.

Confidential, Foothill Ranch, CA
Cognos Developer
06/05 - 09/06

Confidential is the world’s largest producer of power tools, power tool accessories and security hardware and the third largest faucet manufacturer in the United States. Black & Decker is both a Fortune 500 Company and is ranked as one of Fortune’s Most Admired Companies. In 1999, Black & Decker joined Kwikset and Price Pfister to form the Hardware and Home Improvement Group (HHI) based in California. HHI Group added two additional powerful brands with the acquisition of Weiser Lock and Baldwin Hardware. The Sales Analysis System was designed for Black & Decker Hardware and Home Improvement (BDHHI) using Cognos Business Intelligence Software.

Responsibilities:

• Involved in User Requirements, Analysis and Gathering
• Worked on Cognos8 framework manager to import metadata from multiple data sources and to create subject oriented Business models, create and publish packages to Cognos 8 server
• Writing complex Cognos8 Report Studio reports, as well as the unit and system integration testing of those reports
• Prepared financial information and generated reports using Cognos Impromptu tools querying database
• Processed and matched invoices to corresponding purchase orders
• Provided proper supporting documentation for business transactions and also contributed to the month end close and account reconciliations
• Worked with Project Manager to determine the best methodology for the project and approach to gather the requirements
• Followed the Waterfall method
• Collected, documented, and managed business requirements using MS Office
• Manually modified the SQL in Report Studio to tune and/or to write complicated reports. Used subsets to write union/subtract queries in Report Studio
• Created Models by using Impromptu Query Definition (IQD) in PowerPlay Transformer
• Migrated several existing Cognos Impromptu Catalogs into XML files and importing them into ReportNet
• Installed ReportNet Migration Tool and migrated Impromptu catalogs using impcat2xml command
• Migrated Impromptu reports to ReportNet using migratetocrn command and deployed migrated reports to ReportNet using deploytocrn command
• Assigning support group to set up users to user classes, data sources, database signons, and architect models
• Setting User Access to Cognos Products (Impromptu, IWR, Powerplay, PPES, & Upfront)
• Created Impromptu Catalog by adding tables and creating new joins
• Used PowerPlay Enterprise Server to publish the cubes and Impromptu reports to the Upfront
• Analyzed the data and extracted the data from the existing database
• Developed Standard Reports, Charts, Drill Through Reports, Master Detail Reports
• Created Query Prompts, calculations, Conditions & Filters
• Developed Prompt pages and Conditional Variables

Environment: Cognos 8BI, Framework Manager, Report Studio, Query Studio, Cognos Connection, Impromptu 7.4, Transformer 7.4, PowerPlay 7.4, PowerPlay Enterprise Server 7.4, ReportNet 1.1, Access Manager, SQL Server 2000, Erwin 4.1, MS-Office, Shell Script, UNIX and Windows NT.

Confidential, Mill Valley, CA
Cognos Developer/Administrator
09/04 - 05/05

Confidential is an Internet based, technology enabled, full service Marketing Research Company focused on primary marketing research—concept tests, product tests, sorts (alternative tests), advertising research, trackers and a lot more. Zoomerang is an ASP online survey research tool, provides users with simple web based tools to build, customize, and send surveys via email and then quickly analyze the survey results. zTelligence is a user-friendly Internet based application, based on the Application Service Provider (ASP) model. Market Tools hosts zTelligence on their servers, and the clients can access the product over the Internet.

Responsibilities:

• Involved in User Requirements, Analysis and Star Schema design
• Involved in Installing, Configuring, Customizing and Maintaining Cognos Products
• Created Models by using Impromptu Query Definition (IQD), Hot files in PowerPlay Transformer
• Created Impromptu Catalog by adding tables and creating new joins
• Analyzed the data and extracted the data from the existing database
• Setting User Access to Cognos Products (Impromptu, IWR, Powerplay, PPES, & Upfront)
• Tested the queries in Oracle using PL/SQL and analyzed the results. Also used SQL Tuning for query optimization in Oracle
• Used Decision Stream 7.1 for Extraction, Loading and Transformation (ETL) of data in the Data warehouse.
• Developed Standard Reports, Charts, Drill Through Reports, Master Detail Reports and Bursting
• Involved in Testing, improving Report Performance and Exploring Impromptu Reports
• Worked on Cognos Security Administration (Access Manager) to restrict the users
• Created Prompts, Calculations, Conditions & Filters and creating New Jobs using Impromptu Administrator
• Administration involved Installation and configuration of COGNOS servers, implementing security, managing users, usergroups and roles in the organization
• Created Models by using various data sources in PowerPlay Transformer
• Created User Classes and users in Access manager and provided the user credentials
• Created extremely big OLAP cubes
• Used PowerPlay Enterprise Server to publish the cubes and Impromptu reports to the Upfront

Environment: ReportNet 1.1, Report Studio, Query Studio, Impromptu Administrator, Transformer 7.3, PowerPlay 7.3, PowerPlay Enterprise Server 7.3, Access Manager, Oracle 9i, SQL Server 2000, DTS, Visio, MS-Excel, Windows 2000 and UNIX

Confidential, Dallas, TX
Cognos/SQL Developer
09/03 - 08/04

Confidential units rely on SBC Laboratories to provide creative technology solutions that are necessary to gain a competitive advantage in the marketplace. SBC Labs collaborates with other technology industry leaders and premier universities and assists with internal and customer field trials. SBC Labs focuses its research and development efforts on the following key areas:
Broadband Internet, Network Services, Enterprise Information Technology, Wireless Systems.

Responsibilities:

• Involved in User Requirements, Analysis and Star Schema design
• Involved in Installing, Configuring, Customizing and Maintaining Cognos Products
• Created the Stored Procedures and Views.
• Involved in Query Optimization and UAT Test Plans on all the user reports
• Defined and manually created Metric Studio objects (Scorecards, Metric Types, Metrics and Qualifiers) and identify data sources, load data using Cognos Metric Designer
• Analyzed the data and extracted the data from the existing database that is involved in query optimization
• Built models using Framework Manager and developed Standard Templates
• Developed Standard Reports, Charts, Drill Through Reports, Master Detail Reports and Bursting Reports using Report Studio and Query Studio
• Involved in Testing and Exploring Report Studio and Query Studio.
• Created Pointer files using PowerPlay Connect and published the Hyperion Essbase cubes into the Cognos Connection
• Worked on Cognos Security Administration to restrict the users
• Creating Query Prompts, calculations, Conditions & Filters and creating New Jobs using Cognos Connection
• Scheduled and Distributed Reports through Schedule Management in Cognos Connection
• Tested and improved Report Performance
• Created Models by using various data sources in PowerPlay Transformer
• Created User Classes and users in Access manager and provided the user credentials
• Created extremely big OLAP cubes
• Used PowerPlay Enterprise Server to publish the cubes and Impromptu reports to the Upfront
• Written macros and scheduled the Power Cubes

Environment: ReportNet 1.1, ReportStudio, QueryStudio, Impromptu 7.1, Transformer 7.1, PowerPlay 7.1, PowerPlay Enterprise Server 7.1, IWR, Access Manager, Toad 8.2, Oracle 9i, SQL Server 2000, MS-Excel, Shell Scripts Windows 2000 and UNIX.

Confidential, San Diego, CA
Software Engineer
06/02 - 07/03

Confidential is the leading provider of search and enhanced directory assistance solutions featuring their patented voice and text based user interface technology offering the fastest search available in the mobile environment. V-ENABLE's patented voice search allows mobile users to simply input / search using their voice and receive personalized content and information in a visual format on their mobile phone.

Responsibilities:

• Developed multimodal applications using C/Java that makes use of VeClient which serves as an API to the underlying networking protocol to connect to the server called VeGateway which displays the information that the user requested on the mobile phone
• Successfully tested the application on various mobile phones with BREW/Java platform by displaying a list of songs pertaining to the artist which the user requested
• Designed a server that would synchronize with the VeGateway and would restrict direct access to VeGateway without authoritative rights. Once a user is authenticated then depending upon his role he can update or modify the resources in the resource manager module on VeGateway
• Designed and implemented a Java based GUI which shows information about objects on map using spatial SQL queries run on Oracle 8i

Environment: Java, UNIX, Brew, Windows, C, C++, SQL, Oracle 8i.