SUMMARY

• 8 years of IT experience in analysis, design, development, deployment, testing and support of Business Intelligence Applications.
• Over 6 years of working experience with Cognos 10, 8 BI Suite (Framework Manager, Cognos connection, Report Studio, Metric Studio, Analysis Studio and Query Studio)
• Expertise in gathering business requirements and creating models &reports to meet the requirements.
• Handling complete range of BI capabilities: reporting, analysis, dashboards and business event management.
• Expertise in developing and testing Complex reports (List, Crosstab, Charts, Maps, Drill - through, Master-Detail, Cascading prompts, Filters, Calculations) using Report studio
• Experience building interactive Workspaces(Dashboards) using Cognos Workspace (formerly Business Insight) by bringing together report components and using Widget features to interconnect them.
• Hands on Experience with Framework Manager Modeling (Physical Layer, Business Layer, Packages) and Complex Report building with Report Studio
• Experience and expertise in understanding existing business processes, data analysis requirements, business systems analysis and design, converting requirements specifications into functional specifications.
• Extensive experience in Multiple Relational Databases including SQL Server, Oracle & DB2
• Experience with writing SQL queries, Oracle PL/SQL Stored Procedures, Functions, Cursors and Triggers.
• Have clear understanding of Business Intelligence and Data Warehousing concepts with emphasis on ETL and Life Cycle Development
• Involved in training end users and providing technical support and documentation
• Ability to adapt and learn new technologies and to get proficient very quickly with them
• Experienced in PowerPlay Transformer and client to design models and analyze the Power Cubes.

TECHNICAL SKILLS

BI tools: Cognos 10.2/10.1/8.4/8.2 (Report Studio, Framework Manger, PowerPlay Transformer, Analysis Studio, Query Studio, Business Insight\Workspace, Business Insight Advanced\Workspace Advanced, Data Manager, Administration, SDK), SAS 9

ETL Tools: Data Stage 8.7, SSIS, DMExpress

Databases: Oracle 9i/10g/11g, SQL Server 2000/2008/2014 , DB2 V9, Teradata 12

Languages: C#.NET, VB.NET, VB 6, C++, COBOL, PL/SQL

DB Tools: SQL *Plus, SQL *Loader, BTEQ, SQL Assistant, TOAD

Other Tools: CA Easytrieve, ASG ViewDirect, DocumentDirect, VPSX, IBM File-Aid

PROFESSIONAL EXPERIENCE

Confidential, Pennington, NJ

Sr. Cognos Developer

Responsibilities:

• Involved in business requirements gathering, data modeling and database design, report development, performance tuning, and data delivery mechanisms
• Created Metadata Models using Framework Manager with relational data and deployed packages to Cognos Content Store
• Worked jointly with the data management team members to understand data domains, values, cardinalities and other dimensions of data, needed to support BI solutions
• Designed and developed Dimensionally Modeled Relational models (DMR) from a relational data source by creating regular & fact dimensions, specifying scope relationships in Framework Manager
• Implemented data level security filters, object level and package level security in framework manager to achieve highly complex security standards
• Implemented Database Layer, Intermediate layer and Presentation Layer, defining appropriate relationship between dimension query subjects and fact query subjects in Framework Manager
• Created advanced Workspaces/Dashboards in Cognos Workspace/Business Insight for commercial loan line of business users, by adding report objects authored in Report Studio to present critical company data in a single view
• Developed list, crosstab, drill-through, master-detail, chart and complex reports which involved multiple prompts, calculations, filters, HTML items in Report Studio
• Created JavaScript solutions in Cognos reports to enhance the capabilities like doing post validations on prompts, dynamically change report content
• Designed Reports using Boolean and String variables to conditionally format and conditionally render report items
• Implemented Report Bursting by defining burst groups, report recipients and specifying master-detail relationships to distribute segments of reports to different users
• Developed dimensional models in Transformer, built and published PowerPlay cubes to Cognos Portal, created batch scripts to automate cube refresh process
• Worked with Session parameters, parameter maps and macros to add dynamic behavior to metadata models in Framework Manager
• Coordinated with functional users for User Acceptance Testing prior to releasing system changes in production
• Created documentation for the complete project life cycle and mentored the End Users and Provided the Technical Support

Environment: Cognos 10.2/10.1.1 (Framework Manager, Transformer, Report Studio, Query Studio, Business Insight/Workspace, Business Insight Advanced/Workspace Advanced, Cognos Connection and Administration), Oracle 11g, SQL Server 2008, TOAD, PL/SQL, IBM Datastage 8.7, Korn Shell Scripting,VSAM, IBM File Manager, ASG Document Direct

Confidential - Gaithersburg, MD

Cognos Developer

Responsibilities:

• Worked with business users, functional lead to understand and document the Business requirements
• Designed Functional Requirement Specifications for report development, modified relationships between different database tables and building models using Framework Manager
• Migrated reports built in SAS to Cognos by building metadata models and authoring report specs using Report Studio
• Created Metadata Models by using multiple data sources in Cognos Framework Manager, published Packages to Cognos Content Store
• Created Dashboards using Business Insight to bring together report components and linking them together using widget control features.
• Created Complex Reports in Report Studio using Cascading prompts, Dynamic columns, Conditional rendering and master-detail relationships
• Extensively used PowerPlay Transformer to build Dimensional Models and created PowerPlay reports using Analysis Studio
• Developed List, Crosstab, drill-through and complex reports which involved multi-queries
• Deployed Packages and Reports from DEV Environment to UAT and PROD Environments
• Did Unit Testing for all reports and packages validating report outputs by comparing against query outputs from database
• Creating report views with saved prompts and schedule according to the business requirement
• Personalized Cognos Connection, Specified display options, regional options and personal information
• Created ETL mapping documents and built SSIS, DMExpress jobs to migrate data from Mainframe platform to AIX

Environment: Cognos 10.1 (Transformer, Framework Manager, Report Studio, Query Studio, Metric Studio), Oracle 11g, DB2, SQL Server, Erwin 4.0, TOAD, PL/SQL, UNIX (AIX), DMExpress, SSIS

Confidential - Minneapolis, MN

Cognos Developer

Responsibilities:

• Developed and implemented information management solutions as a part of Business Intelligence Organization
• Participated in the design, development, deployment and support of Reporting solutions in the areas of Sales & Marketing, Forecast & Planning and Supplier Performance
• Collaborated with business to develop high-level designs including logical models and functional specification documents
• Assisted and worked with ETL developers and data modelers to make sure that model being developed is according to the business requirements
• Developed complex Reports using different features like slice & dice, Drill capabilities, queries, Master detail and cross tab tables with multiple breaks
• Designed and developed Powerplay cubes for multidimensional analysis for Sales & Marketing and Forecast & Planning users
• Assisted in Batch processes using Fast Load, BTEQ, UNIX Shell and Teradata SQL to transfer cleanup and summarize data
• Created BTEQ scripts to extract data from warehouse for downstream applications
• Wrote SQL scripts and developed audit reports to compare warehouse data with the staging and source data
• Administered Cognos BI Server Environment, managed Package Migrations and Deployments from one Environment to another, defined Data Sources, run activities, user accounts and permissions

Environment: Cognos 8.4 (Framework Manager, Transformer, Report Studio, Query Studio, Administration), Teradata 12, Oracle 10g, DB2 v9, Erwin 4.0, TOAD, UNIX, Cognos 8 SDK, SQL Assistant, BTEQ, Data stage 7.5

Confidential

Cognos Developer

Responsibilities:

• Analyzing the specifications provided by the client and developing the specification document for the reports as per client requirements
• Designed and Implemented metadata models in Framework Manager and PowerPlay cubes in Transformer
• Collaborated with business to develop high-level designs including logical models and functional specification documents.
• Developed complex Reports using different features like slice & dice, Drill capabilities, queries, Master detail and cross tab tables with multiple breaks
• Developed multiple page reports with page-breaks based on the first page of the report using Master-detail relationship
• Designed and developed PowerPlay cubes for multidimensional analysis for Sales & Marketing and Forecast & Planning users
• Wrote SQL scripts and developed audit reports to compare warehouse data with the staging and source data
• Scheduled reports using Cognos scheduler and emailed to various recipients as required
• Worked on TOAD for Oracle database systems for creation of ad-hoc queries and for improving various performance issues

Environment: Cognos 8.4 (Framework Manager, Transformer, Report Studio, Query Studio), Oracle 10g, PL/SQL, TOAD, AIX, Korn Shell Scripting