SUMMARY

• Around 8 years of specialization in OLTP/OLAP/Data Warehousing, BI tools in the analysis, design, testing, development, and implementation of client - server applications.
• Full SDLC experience includes writing design documents, test plans and conducting unit and system testing.
• Extensive Knowledge in integrating the 3-tier architecture (Webserver, Application Server, DB server) which results in building IBM Cognos Connection and work on Cognos BI suite, including Business Insight & Advanced, Report Studio, Analysis Studio, Workspace Advanced, Cube Designer and Framework Manager.
• Extensive Knowledge on Cognos Architecture on the Application Server (Content Manager and Query Services).
• Developed Framework Manager Models (Layers, Relations, Query Subjects, Star-Schema and Packages) and published packages.
• Developed and maintained dashboards and apply data visualization best practices using Active Reports, dynamic cubes, Report Studio and Cognos Workspace Advanced.
• Generated dashboards on the existing reports to provide the end user for better Visualization and Analysis of the data.
• Worked on Multi-dimensional model, developed dashboards using cubes.
• Created Complex and statistical and financial reports, trend over time reports, ranking reports, Executive Dashboards using Report Studio.
• Extensive experience on production support and troubleshoot/test issues with existing reports and cubes.
• A major area of expertise in designing and developing Decision Support Systems (DSS) and Business Intelligence.
• Experience in understanding existing business processes, gathering business systems requirements analysis and design thereby converting into detailed reports for strategic decision making.
• Knowledge of data warehouse techniques and practices, including BI Reporting, relational modeling, OLAP, Star schema & Snowflake schema.
• Good working knowledge of Crystal reporting, creating Sub reports, dynamic display of columns etc.
• Strong experienced on creating complex reports with Report Studio to customize the functionality by using Filters, Prompts, Master Detail Relational ships, Drill through definition and Conditional Formatting.
• Performance tuning by analyzing and comparing the turnaround times between SQL and Cognos.
• Converted complex oracle queries into stored procedures and Views to improve the query performance.
• Experience in complex PL/SQL database stored procedures, packages and triggers to handle the complicated business logic for Warehouse Product Database Administration.
• Experience using various data sources such as Oracle, DB2, MYSQL, SQL Server, Tera Data and Access.
• Involved in design document creation, development, and UAT and post implementation validation of Cognos reports.
• Proven experience at building, motivating and leading professional teams & supporting client relationships.
• Preparation of Test cases and Conducted code and QA review sessions with development team.
• Demonstrated ability in analyzing complex business objectives & in keeping projects ahead of schedule, under pre-determined time while maintaining composure & meeting deadlines in a fast-paced environment.
• Excellent communication and interpersonal skills. Ability to work effectively in a team as well as individually.

TECHNICAL SKILLS

BI Tools: Cognos 10.2.X, Cognos10.1.X, Cognos Business Intelligence (8.1 to 8.4) (Report Studio, Query Studio, Analysis Studio, Cognos workspace, Cognos workspace advanced, Cognos Mobile, Cognos administration, Cognos Access Manager.

Modeling Tools: Cognos Cube Designer, Cognos Transformer & Cognos Framework Manager

Languages: SQL, PL/SQL, HTML, MDX, JavaScript, JSP

RDBMS: Oracle Exadata, Oracle 11g/10g/9i, Teradata, MS Access/Excel, DB2, and SQL Server, Toad, Cloudera Hive.

Operating Systems: Windows 2003/2008/2012 R2, UNIX.

PROFESSIONAL EXPERIENCE

Confidential, North Olmsted, Ohio

Sr. Cognos Developer

Responsibilities:

• Analyzed the reporting requirements, data sources and current systems that are used for modeling and reporting data.
• Worked with project lead and business users to understand requirements, conduct analysis and recommended BI.
• Created detailed Cognos technical documents based on Cognos architecture and Functional Requirement Specifications (FRS)/System Use Cases (SUC).
• Imported Metadata into the Framework Manager from different data sources like SQL Server and Oracle thereafter created a relationship between the dimensions and facts.
• Provide technical guidance and support for the development and troubleshooting of systems. Identify system data, hardware, and software components required to meet user needs.
• Designed and developed metadata model in Cognos Framework Manager and published packages.
• Created Dashboards in Report Studio to display the data interactively to the end users as per the business requirement.
• Developed and Published Packages using Framework Manager against relational and dimensional models.
• Developed new reports using functionalities like Layout Component Reference to reuse Report Header and Footer.
• Created drill-through reports from Dashboard to all summary/Trend reports, Trend reports to Summary reports and Summary reports to Detail Reports.
• Created complex reports with multiple queried using SQL, Master-Detail Relationships, Joins, Sub queried, Query references and Query Calculations.
• Created cubes in Transformer using Framework Manager IQD’s packages and report studio reports as a source.
• Designed and developed Power cubes for multidimensional analysis for Sales & Marketing and Forecast & Planning
• Modified power cubes by adding new dimensions, levels, measures, and custom dimensional views for security.
• Performed basic administrative tasks such as scheduling and delivering reports in different formats (for example HTML, PDF, and Excel)
• Scheduled reports to run on a monthly, weekly and daily basis using Cognos Connection and also implemented Administration, Architecture, Testing, Performance Tuning, and Triggers.
• Used Event Studio to create agents that monitored status changes and priority customers that were important for the Business users.
• Ensured that all assigned task were customer focused, results oriented, performance driven, and in compliance with all applicable internal and external requirements.
• Worked with deployment team to ensure a smooth transition from development to production, operation and support.
• Developed Complex dashboard reports for various reporting requirements and also created multi page reports by using Cascading prompts, conditional formatting and page rendering.
• Participate in daily /weekly status calls and meetings to discuss the project issues and work with all the teams to close the issues.

Environment: Cognos (Framework Manger, Report Studio, Workspace/Business Insight Advanced, Workspace/Business Insight, Query Studio, Analysis Studio, Cognos Connection, Lifecycle Manger), PowerPlay Transformer, Oracle 11g/10g, PL/SQL, Unix, Windows 7/Windows 2008/XP.

Confidential, Richmond, TX

Sr.Cognos Developer

Responsibilities:

• Involved with the entire life cycle of the project from the user requirement gathering to deployment stage.
• Reviewed annual business plans, promotional schedules and KPI's with business users.
• Involved in deployment process for all the reports and packages from development to production server.
• Generated various reports List Reports, Grouped Reports, Crosstab Reports, Chart Reports, and Drill-through Reports.
• Customized data by adding Filters, Calculations, Prompts, Summaries, and Functions.
• Added prompts and filters to modify existing reports to accommodate the change in user requirements.
• Used Analysis Studio to create Analysis from PowerPlay Cubes, and Power Cubes.
• Created complex multipage reports using multiple list reports and multiple queries to associate each of the list reports.
• Created Prompts with static choices and conditional variables for rendering the multipage reports.
• Used Filters for efficient retrieval of data and conditional variables for hiding summary totals for report.
• Performed scheduling and maintenance of reports using Cognos Connection and Microsoft SharePoint based support portals.
• Migrated various report from Cognos 8.4 to 10.0.
• Performed testing and troubleshooting for all developed reports and model built.

Environment: Cognos 10.0 &10.1(Report Studio, Query Studio, Analysis Studio), Cognos Connection, Framework Manager, Map Manager, PowerPlay Transformer, Microsoft Excel, IIS 7.0, Windows Server 2008/NT, SQL Server

Confidential - Detroit, MI

Cognos Developer

Responsibilities:

• Involved in gathering Business Requirements for New models.
• Interacting with Development and Management Teams.
• Built models using Framework Manager a tool of Cognos 8.4.
• Developed standard Templates, Reports, and Drill-through Reports using Report Studio and Query Studio, Drill through Definition.
• Created Query Prompts, calculations, Conditions & Filters, Developed Prompt pages and Conditional Variables.
• Scheduling and Distributing Report through Schedule Management in Cognos Connection
• Testing and improving Report Performance.
• Training Users on Query Studio for Ad-Hoc Reporting, assisted users in troubleshooting their reports.
• Created PowerPlay cubes using PowerPlay Transformer to permit multi-dimensional cross sectioning and drill down analysis.
• Built OLAP Cubes in Cognos PowerPlay Transformer by using Packages, Reports as a Data Source and analyzed the data by using Cognos PowerPlay Studio.
• Developed PowerPlay cubes which involved model definition in Transformer, used multiple queries, calculated measures, customized cube content and optimized cube creation time.
• Decreased the Cube build times drastically and increased runtime performance by tuning the SQL.
• Created complex mappings using Aggregator, Expression, Sequence Generator, and Joiner Update Strategy transformations
• Worked on different data sources such as Oracle, Flat files, MS Access, DB2.

Environment: Cognos 8.4 ( Framework Manager, Cognos Connection, Report Studio, Query Studio, IBM Cognos Transformer, PowerPlay Studio), Oracle 10g/9i, IBM DB2, Windows XP, and Erwin4.5 was used for database modeling, IIS 6.5, Windows 2003.

Confidential - Seattle, WA

Sr. Cognos Developer

Responsibilities:

• Designed complex Relational/DMR framework manager models for Forecast using all the best practices.
• Implement data level security in all the FM models using the security table and macros. Implemented Object-level Security based on AD Groups.
• Involved in Cognos prod support, Monitored Cognos jobs (Views Refresh) and performed trouble shooting.
• Developed complex reports, Charts, conditional formatting, block variables, Master- Detail relationships, Multi-page.
• Worked extensively on Active reports and developed various dashboards using Cognos 10.0 report studio.
• Responsible for developing the Cognos 10.0 analysis studio reports, query studio templates, report studio reports using tree prompts, value prompts, cascading prompts, drill up and drill down, advanced charts etc.
• Worked very closely with database team to analyze the requirements and implemented best practices with the DB team.
• Scheduled reports in Cognos Connection based on the reports to run Daily, Weekly or Monthly basis.
• Used TOAD to run SQL queries and validate the reports, performed Unit and system integration testing (SIT).
• Deployed reports (import-export) from development to QA and then Production servers.
• Responsible for writing various documentations like report specification document and user manual.
• Developed knowledge transfer documentation on various levels of the project phases.

Environment: Cognos 10.0 suite (Framework Manager, Report Studio, Analysis Studio, Query Studio, Cognos Connection, Cognos Configuration, Access Manager), Powerplay Transformer, Oracle, Toad, DB Visualizer 8.0.4.

Confidential, Boston MA

Developer

Responsibilities:

• Understanding of Data warehousing concepts and framework of BI Tools.
• Translate business requirements into technical specifications, involved in documenting the project, analysis, design and gathering of requirements for the project.
• Query from different database tables as per the requirement.
• Executed SQL commands, wrote PL/SQL commands, Stored Procedures for the existing intranet applications.
• Creation of procedures, views, tables and functions according to business requirements in Oracle.
• Implementing Data warehousing methodologies including star schemas and snowflake schemas for huge data warehouses. Worked on 3-tier metadata modeling in Framework Manager Built models containing query subjects, query items, and namespaces from scratch as well as from imported metadata and published multiple packages.
• Created Projects, Models (layers, relations, cardinality, Query subjects, star schema and packages) and Published Packages using Framework manager.
• Involved in Designing DMR models with Relational Data using Framework Manager and deployed packages to the Report Servers.
• Created Multiple Reports using Cognos 8.1 like the list, crosstab and section reports using report studio.
• Used conditional formatting, conditional styles and Style variables to render reports for different user needs.
• Extensively used Power Play Transformer to move relative data mart data into Power Cubes.
• Demonstrate the flexibility of Cognos using Cognos Report Studio, Analysis Studio and how Cognos could help them to meet their reporting needs.
• Tested reports by writing manual SQL and used excel for validating the reports.

Environment: Cognos 8.1 BI (Framework Manager, Report Studio, Analysis Studio, Query Studio, Metric Studio, Event studio, Metric Designer, Transformer), Oracle 9i, windows 2003.

Confidential 

Cognos Developer

Responsibilities:

• Created the design documents for the development of Cognos.
• Involved in creating the model and package using Framework manager.
• Created reports for various departments like HR, sales and production.
• Communicated with the business users to comprehend the requirements.
• Involved in the migration of catalogs from impromptu to Report Net using migration utility.
• Created customized BI reports linking various databases, to meet the user requirements.
• Developed numerous sophisticated drill-through Reports.
• Created standard and Ad-hoc reports using Cognos Query Studio (Simple List, Grouped List, Crosstab, and nested Crosstab) reports and represented data graphically by charts utilizing Query Studio.

Environment: Cognos Report Net, Cognos connection 7.1, Power play Enterprise Server 7.1, Oracle 9i, Windows XP, Windows NT, and Windows 2000.