SUMMARY

• Over 8 years of experience in IT Industry on Cognos suite of products which includes Cognos 10, Cognos 8, Cognos Impromptu, Power Play 7.4, Transformer, Impromptu Web Reports, and Report Net 1.1.
• Extensively worked on developing various kinds of reports in Cognos 10 and 8 Report Studio, Analysis Studio and Query Studio.
• Strong background in building Metadata models using Framework Manager and Dimensional Modeling.
• Strong understanding of dimensional modeling of Star Schemas, Snow - Flake Schemas Methodologies for building enterprise data warehouses.
• Possess extensive experience with Cognos Framework Manager including importing Metadata Source, Modeling and applying table level, and data level security.
• Strong experience in performing installation, configuration and upgrade of Cognos environments.
• Expertise in OLTP/OLAP system study, developing models and publishing packages using different schema concepts.
• Extensively worked on and understand the business requirements of Cognos applications. Install and troubleshoot the systems.
• Experience on Conditional Formatting, Complex Filters, Report Bursting, Scheduling, Event Conditions.
• Extensively worked in the analysis, modeling and the development of Data Warehouse, with a good understanding of schemas, fact tables, and dimension tables.
• Created Multidimensional Models & Cubes using Power Play Transformer for generating various reports.
• Created various kinds of Ad-hoc and Standard reports as per user requirements using Query Studio and Report Studio.
• Supplemented regular prompts, Cascading prompts, detailed filters, summary filters, conditional styles, conditional blocks, static headers, Drill Through, master-detail, Self-Drill Through reports for users in Report Studio
• Experience in developing end to end reporting from development, testing and production deployment.
• Expert in all stages of Software development life cycle (SDLC) which includes requirement analysis, Installation, design, development, testing and documentation.
• Proficient in designing relational, dimensional and DMR models using Cognos Framework Manager, multi-dimensional OLAP models using transformer.
• Excellent Communication, Leadership and Interpersonal skills and Demonstrated ability to quickly grasp new concepts, both technical and business related and utilize as needed.

TECHNICAL SKILLS

BI (OLAP) Tools: COGNOS 8.2/8.4/10.1/10.2 BI Suite (Framework Manager, Report Studio, Query Studio, Analysis Studio, Event Studio, Metric Designer, COGNOS Connection, Cognos Content store, Report Net 1.1. LDAP Server, COGNOS Impromptu 7.3, Power Play 7.2.

SDLC Methodologies: Agile, Scrum, and Waterfall Method

ETL Tools: Knowledge of SSIS, Informatica, Data Stage

Data Base Tools: Toad, Sql server Management studio

Databases: Oracle 11g/10g/9i, SQL Server 2000/2005,Teradata, DB2, MS Access

Programming Skills: C, C++, Java, SQL, PL/SQL

Operating System: MS-Dos, Windows, Unix, Linux, Sun-Solaris.

PROFESSIONAL EXPERIENCE

Confidential, St. Louis, Missouri

Sr. Cognos Developer

Responsibilities:

• Generated Complex reports in Cognos 10.1 and 10.2 report studio including Drill Down reports from DMR model.
• Involved in analyzing, documenting functional and technical requirements for developing packages and reports.
• Generated various List Reports, Cross tab Reports, Chart Reports, Drill-Down and Drill-Through Reports.
• Developed Multidimensional cubes using Cognos Power Play Transformer and develop reports using Power Play Studio, Analysis Studio and Report Studio.
• Experience in developing Framework Manager Models and analyzed those models in analysis studio.
• Created Database layer, Business layer, and Presentation layer in the model by defining appropriate relationship between query subjects.
• Proven experience building ad-hoc and complex reports using prompts and parameters in Report Studio and Query Studio. .
• Customized data by adding Filters Prompts, Calculations, Summaries and Functions.
• Deployed Reports & Dashboards from Development to QA and QA to Production using export and import options.
• Developed security for reports, bursting the reports and Scheduling and Distributing Reports through Cognos Connection.
• Created Multi-dimensional reports by implementing Multi-Dimensional Cubes using Power Play and Transformer.
• Designed models &cubes in Cognos7.2 Transformer using existing IQD's from Framework Manager.
• Involved in Designing and developing power Play transformer model (Creating dimension maps, Levels and calculated measures for generating power cubes (OLAP Cubes)).
• Maintained Dimension level Security for Cubes in Power Play Transformer.
• Experience in developing active reports using visualization tools.
• Published the Power play cubes using Power play Enterprise server.

Environment: Cognos10.2 (Framework Manager, Report Studio, Query Studio, Analysis Studio), Cognos 7.2 (Impromptu, Power Play, Transformer Model), Oracle 11g, Windows 7/XP Professional.

Confidential, Warren, NJ

Sr. Cognos Developer

Responsibilities:

• Developed various complex and customized (Inserting tables and Blocks) reports using prompts like value prompt, date prompt, type in, Select & Search Prompt and conditional formatting.
• Created Framework packages with various security settings and published onto Cognos connection.
• Developed complex reports like multipage reports with master detail relationships, Prompts, Calculations and Conditions using Cognos report studio
• Created custom prompted reports in Report Studio, Bursting reports to different user groups.
• Administering user access to reporting applications which includes setting up Cognos security by assigning users to the groups and roles defined in the Cognos Namespace.
• Scheduled and distributed reports using Schedule Management in Cognos connection
• Involved in analyzing, documenting functional and technical requirements for developing packages and reports.
• Built metadata models, modified, and published several packages using Framework Manager according to the business needs.
• Created average Summary and Percentage and user defined Calculations, user friendly Filters, Prompts, Cascading Prompts, Conditions & Bookmarks.
• Worked with Aggregator, Sorter, Router, Filter, Join, Expression, Lookup and Update Strategy, Sequence generator transformations.
• Developed Standard Reports, Charts, advanced Drill Through Reports, Bursting Reports using Report Studio and Query Studio
• Trained end users with Query Studio in making Ad-hoc reporting.
• Designed hierarchies for various dimensions as part of DMR modeling and also developed multi star and snowflake schemas.
• Developed power cubes for inventory and sell through by using transformer with multiple fact tables.

Environment: Cognos 10.1/8.4 BI, (Framework Manager, Report Studio, Query Studio, Analysis Studio, Transformer Model), Informatica Power Center 7.1, Oracle 10G, Windows, Microsoft Excel.

Confidential, Woodbridge, NJ

Cognos Developer

Responsibilities:

• Developed complex reports with joins, unions, SQL, calculations, and conditional formatting, drill troughs.
• Built multi-dimensional models and cubes in Transformer using IQDs.
• Involved in basic administrative tasks like giving access privileges, setting up connections and audit databases.
• Documented the FMW design, Report design and uploaded them to the team site and also documented the unit test cases.
• Worked on unit testing of the reports and also on system testing.
• Prepared the backups of data stores, report stores in the servers.
• Created reports using functionalities like slice and dice, drill down, cross tab, master detail, sub reports, mailing label, Alerts, tables and formulas, etc.
• Maintained the key Data Dimensions and hierarchies across the organization using the master dimension management.
• Worked on different levels of security and even with the permissions of various users and user classes.
• Created Teradata model using framework manager, created packages and published the packages.

Environment: Cognos 8.4(Report Studio, Framework Manager, Cognos Connection, Query Studio, Analysis Studio, Cognos scheduler), MS SQL Server 2008. Oracle 10g.

Confidential, Detroit, MI

SQL / Cognos Developer

Responsibilities:

• Created complex dashboards using gauges, maps, charts and other graphical elements to show multiple results together.
• Interpreted complex business specifications and generated cubes and reports to meet customer specifications.
• Updated & administered the security privileges at folder level, table level, and data level for the user profiles.
• Created stored procedures and triggers in the back-end, created users and user classes in Access manager.
• Created complex calculations based on ODS data to handle complex functionality for measuring Application Portfolio metrics like Complexity, Maintainability, Skill Set Availability etc.
• Coordinating with Database team in setting up the required Materialized views, Aggregated and De-Normalized tables for the Reporting and Analysis needs.
• Worked extensively on Plan view PPM application database and data marts to develop reports and Framework Manager Model.
• Created Risk Management Dashboard that implements Basel II principles.
• Administered tasks such as scheduling reports to auto generate mails to the Users, deployment, and security.

Environment: Cognos 8.4 (Framework Manager, Report Studio, Query Studio, Analysis Studio, Transformer Model), Cognos 7.2 (Impromptu, Power Play, Transformer Model), SQL Server 2005, Oracle 10g, Windows XP Professional.

Confidential

SQL Server Developer

Responsibilities:

• Implemented physical design by DDL scripts including tables, views, and changed existing objects to synchronize with changing business rules.
• Involved in performance tuning activities like Optimizing SQL queries, explain plan, creating indexes.
• Design and Implement Database Backup Restore Strategy Support.
• Created logical design, ER diagrams in Visio and mapping the data into database objects.
• Tuned the store procedures that were identified as bottle neck in application and used SQL Profiler for activity monitoring to debug the application.
• Modified existing objects and removed redundant object to complement new business process and improve system performance.
• Developed and implemented database and coding standards, improving performance and maintainability of corporate databases.
• Modified database structures as directed by developersfor test/develop environments and assisted in coding, design and performance tuning.

Environment: SQL Server 2005, Windows Server2003, Management Studio, Profiler, Visual Studio 2005 Team System, MS Office 2007 & Visio, SharePoint.