SUMMARY

• 6 years of experience in analysis, design, development, implementation and supporting of Client Server & Data Warehousing Applications.
• 3 years experience in transformers Cubes, Dashboards, Framework manager
• Extensive experience in OLAP tools like Cognos 10 & Cognos 8 BI Suite (Business Insight Advance, Report Studio, Query Studio, Analysis Studio, Powerplay Studio, Event Studio, Powerplay Studio,Framework Manager and Cognos Connection.).
• Experience with COGNOS EP Series 7 (Impromptu Administrator, Impromptu Web Reports (IWR), PowerPlay, Transformer, Enterprise Server, Access Manager, Server Administration, Report Administration, Upfront, Visualize, Architect, Cognos Query & Cognos Scheduler).
• Experience in Cognos BI Server Installation and Configuration, Configuring database server and web server connectivity for use with Cognos.
• Experience in setting up Security prototype for Cognos business intelligence environment incorporating row level, object level, data level, and package level and report level security.
• Have a clear understanding of building Dimensional Models, Data warehouse architecture.
• Adept at using relational databases like DB2, MS SQL Server 2000 and 2005 and Oracle with Cognos
• Experience in Upgrade the reports from Series 7 to Cognos 8.3.
• Hands - on experience in moving the data from DB2 to SQL using SSIS.
• Expertise in developing and testing Complex reports (List, Cross tab, Charts, Maps, Drill through, Master-Detail, and Cascading) and Dashboards using Report studio.
• Adept at creating metadata from data marts using Framework Manager.
• Have Strong Knowledge in creating Multi-dimensional Cubes for corporate data using Power Play Transformer and developed custom reports using Power play Client.
• Experience in gathering of end-user business requirements and the ability to understand the functionality.
• Interacted with Management to identify key Dimensions & Measures for business Performance.
• Ability to contribute significantly in all phases of the Development Life Cycle.
• Strong Knowledge of Data Warehousing, OLTP, OLAP concepts.
• Strong communication skills, problem solving skills and ability to adapt to new technologies and professional in interaction with all levels of users.
• Motivated team player and can adapt and learn new tools and applications

TECHNICAL SKILLS

BI Tools: COGNOS 10/8.4/8.3/8.2/8.1, Impromptu 7.x/6.x, Power Play Transformer 7.x/6.x

ETL Tools: COGNOS Decision Stream and Informatica.

Databases: MS SQL Server 2000/2005, Oracle 8i/9i/10g, SAP BW, MS Access, DB2.

Testing Tools: HP (Mercury) Win Runner, TestDirector (Quality Center), Rational ClearQuest, Requisite Pro, ClearCase, Rational TestManager, Functional Tester

Applications and OS: MS Office Suite (Word, Excel, Access, Visio), Windows 95/98/2000/2003/ XP/7

PROFESSIONAL EXPERIENCE

Confidential, SFO, CA

Cognos Developer

Responsibilities:

• Involved in Requirement gathering and Analysis for developing OLAP analysis, Dashboards, Complex Reports, Data mapping using Reports Studio and Query Studio.
• Analyzed the business requirements and developed a model using Cognos framework manager and published packages for reports development.
• Developed list reports, crosstab reports and chart reports using report studio.
• Customized data by adding Filters, prompts, Calculations, Summaries and Functions using Cognos 8 Report studio, scheduling report on Cognos Connection.
• Developed complex report using Cognos 8 Report/Query Studio and create Logical and Physical design in Frame work Manager.
• Scheduled Reports through Schedule Management in Cognos Connection.
• Developed Standard Reports, Charts, Drill Through Reports and Bursting Reports Using Report Studio.
• Defined, stored and maintained security information using Access manager.
• Coordinated all communications with the Database Management team.
• Unit testing of the reports to ensure the correctness of the data and responsible for resolving issues after QA testing.
• Performed Unit testing on reports & cubes using SQL in SQL Server 2008.
• Testing and improving Report Performance.

Environment: Cognos 10, Report Studio, Query Studio,Frame work manager, Event Studio, Cognos

Confidential, Grapevine, TX

Cognos Developer

Responsibilities:

• Worked on Cognos 10 (Business Insight and Active Reports) for two demo projects to demonstrate the End-User the new features available in Cognos 10.
• Worked closely with Clients and Business Users to analyze and understand business requirements and Participated in requirements gathering meetings / Sessions.
• Worked on technical design specs for Framework manager, and reporting per the requirements.
• Created project, namespace (Database View, and Business View), and folders and imported required metadata in Cognos Framework Manager.
• Created model query subjects, Data source query subjects, stored procedure query subjects as per the business requirements in the Framework Manager
• Created standard reports in Cognos Report Studio, and Analysis Studio.
• Responsible to build the Framework Manager Models and packages as per the business requirements.
• Worked on various reports like, List, Crosstab, drill-thru, multi-query, master/detail, prompted, dashboards, portlets, and tabular reports.
• Designed complex reports with union queries, and SQL queries
• Designed transformer models, and powerplay cubes using transformer.
• Worked on powerplay studio to slice/dice Cognos cubes,
• Provided customer training in Report Studio, and Query Studio.

Environment: Cognos 8.4 Framework Manager, Report Studio, Query Studio, Event Studio, Cognos Connection, SQL Server 2008.

Confidential, CA

Cognos Developer

Responsibilities:

• Developed business focused technical solutions using Cognos 8 as enterprise reporting standard for Sales, marketing and Supply Chain Planning Departments.
• Used Framework Manager to create query subjects from different sources and publish packages to the Cognos Server.
• Created highly complex form reports that required precise formatting based on business requirements.
• Created Reports (Simple & Complex) using QueryStudio and ReportStudio.
• Created, organized and formatted reports, folders and other contents on Cognos Connection portal.
• Created joins with queries in Report Studio to generate the required Report queries.
• Generated various reports List Reports, Grouped Reports, Cross-tab Reports, Chart Reports, and Drill -Through Reports.
• Developed reports using Cognos ReportNet according to Business user requirements.
• Created several different types of Professional Reports (Mailing Labels, Web Page Style, Cascading, Linked / Drill Through, Production, Business, Ranking, etc…) with complex formatting utilizing Report Studio.
• Worked on Dashboards using report studio including complex drill-through, master-detail relationships, prompts, layout component reference and formatting the objects within report design.
• Created Model Filters, Query Filters, User Access Filters, Detail Filters and Summary Filters.
• Created Ranks and conditional formatting in reports and enabled multilingual feature.
• Scheduling, Distributing Reports and Administering Reports. Bursting Reports and Multilingual Reports Using Report Studio and Query Studio, Event Studio.
• Reporting included the development of flexible scorecards, dashboards.
• Applied Security and User Authentication to the various User Groups.
• Involved in setting up Groups/Roles to secure the Models and Packages
• Upgraded Cognos 8.2 to 8.3 version of Cognos.
• Deployed the Sample, Tested the Server and Managed Cognos Connection Portal.
• Evaluated Report Performance upon completion of the reports and validated output data.
• Worked extensively in Informatica and MS DTS Services. Used Informatica Designer to create complex mappings using different Transformations to extract transform and load data from multiple source databases to target databases.

Environment: Cognos BI 8 Suite of Products (Data Manager, Report Studio, Planning, Framework Manager, Query Studio, Cognos Connection, DB2, Oracle9i, PL/SQL Developer.