SUMMARY

• IBM Certified Business Intelligence Professional with over 9 years of IT experience in analysis, design, development, deployment, testing and support of Business Intelligence Applications
• Strong experience on Cognos 10.2/10.1/8. x BI Suite (Framework Manager, Report Studio, Transformer, Analysis Studio, Query Studio and Data Manager)
• Experience and expertise in understanding existing business processes, data analysis requirements, business systems analysis and design, converting requirements specifications into functional specifications
• Have clear understanding of Business Intelligence and Data Warehousing concepts with emphasis on data modeling and reporting
• Hands on experience with Relational Metadata Modeling using Framework Manager and Dimensional Modeling using Transformer
• Design metadata models, create and publish packages - Identify data sources, import query subjects, organize into layers, define appropriate relationship between query subjects
• Experience developing complex reports using drill through features, cascading prompts, dashboards, master detail, burst reports, conditional rendering and dynamic filtering in Cognos
• Experience building interactive Workspaces (Dashboards) using Cognos Workspace by bringing together report components and using Widget features to interconnect them
• Involved in designing and implementing ETL jobs using Cognos Data Manager (formerly DecisionStream)
• Extensive experience in Multiple Relational Databases including Netezza, SQL Server, Oracle & DB2
• Experience working with administrative features like package and report deployment, Cognos report scheduling, Cognos security
• Experience writing complex SQL queries and Oracle PL/SQL procedures
• Provide best practices for day to day operations, performance analysis, tuning and capacity planning
• 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

TECHNICAL SKILLS

BI tools: Cognos 10.2/10.1/8. 4/8.1 Suite (Framework Manager, Report Studio, Transformer, Analysis Studio, Cognos Connection, Query Studio)

ETL tools: Cognos Data Manager 10.2, DecisionStream 7.1, SSIS

Databases: Oracle 9i/10g/11g, IBM Netezza, SQL Server 2000/2008, Teradata, DB2

Database Tools: SQL *Plus, TOAD, IBM Data Studio, Aginity Workbench for Netezza

Scripting: JavaScript, HTML, CSS, Korn Shell Scripting

Operating Systems: Windows server 2008, Unix AIX, LINUX

PROFESSIONAL EXPERIENCE

Confidential - Plano, TX

Sr. Cognos Developer

Responsibilities:

• Interact with users to understand reporting needs and involved in data modeling and report development
• Involved in reengineering DecisionStream jobs and modified the builds to use incremental load approach in place of truncate and load to improve performance
• Created metadata models using Framework Manager with relational data and deployed packages to Cognos Content store
• Authored canned reports using lists, crosstabs, cascading prompts, conditional rendering, master detail relationships, drill through features available in Cognos Report Studio
• Designed and developed DecisionStream ETL jobs to replace SQL scripts
• Dimension lookups that are not performing because of 2 Gig limitation in Cognos DecisionStream are replaced with Merge/Join SQL builds
• Performance tuning by analyzing and comparing the turnaround times between database queries and Cognos DecisionStream jobs
• Involved in scheduling/monitoring DecisionStream jobs/builds and generating reports after successful job completion
• Wrote SQL queries to extract data for validating DecisionStream outputs
• Tested/Validated the load process and target Data mart tables
• Coordinated with functional users for User Acceptance Testing prior to deploying changes to production
• Prepared training materials and trained users in Query Studio according to their specific needs and requirements
• Documented the job flow and created mapping documents to support DecisionStream ETL process

Environment: Cognos 10.2 (Framework Manager, Report Studio, Query Studio, Cognos Connection), Cognos Data Manager 10.2, Cognos DecisionStream 7.1, Oracle 11g, SQL Server, Control-M

Confidential - Plano, TX

Sr. Cognos Developer

Responsibilities:

• Interact with business users for requirement gathering and Involve in data modeling, report development, performance tuning, and data delivery mechanisms
• Used Framework Manager to build models, packages and publish packages to Cognos Content Store
• Designed and developed dashboard style reports (Outpatient Analytics, IDTF Analytics, Case Management, ED dashboard, OR dashboard, Quality, Risk readmission) using Cognos Report studio
• Created List, Cross tab, Chart, Master Detail reports, drill through and custom prompting reports, worked with HTML items/Java Script in Cognos Report Studio to customize reports
• Implementedfilters, calculations, conditional formatting and prompts in various reports created usingCognos Report Studio
• Created reports using Query Unions to merge multiple Query Items into one for reporting purpose
• Build and publish interactive dashboards utilizing filters, parameters and calculated fields
• Created reports using Native SQL in Cognos Report Studio
• Developed Dashboard reports to display information related to environment using Summary reports
• Implemented data level security in framework manager to achieve highly complex security standards
• Performance tuning by analyzing and comparing the turnaround times between database queries and Cognos reports
• Created documentation for the complete project life cycle and provided Technical Support
• Deploying models and reports from Development to Production and administering users/groups/roles

Environment: Cognos 10.2, 10.1 (Framework Manager, Transformer, Report Studio, Query Studio, Analysis Studio, Cognos Connection), IBM Netezza, Aginity Workbench for Netezza, JavaScript, SSIS, Cognos Data Manager.

Confidential, Yardley, PA

Sr. Cognos Developer

Responsibilities:

• Enhance fulfillment maintenance application by authoring new reports for tracking unit redemption trend analysis and LIT packages
• Built POC reports to showcase how to achieve client needs using real time scenarios
• Demonstrate the flexibility of Cognos using Cognos Report Studio, Analysis Studio and how Cognos could help them to meet their reporting needs
• Fact and Dimension tables were used in the Cognos FM model for Package building
• Built new packages using Cognos Framework Manager and converted the existing reports from Excel to Cognos reports using Cognos Report Studio
• Used ROLAP and OLAP models as source to create reports using Report Studio
• Created complex calculations, various prompts, conditional formatting and conditional blocking etc., accordingly
• Deployed the Cognos Content from Development environment to UAT/Production environments
• Closely worked with Cognos Support team for troubleshooting complex issues
• Responsible for creating the Cubes and Reports and scheduling them accordingly
• Extensively used PowerPlay Transformer to move relative data mart data into PowerCubes
• Maintained users, groups, and roles and assign them respective privileges as per business needs

Environment: Cognos 10.2, Framework Manager, Transformer, Report Studio, Query Studio, Oracle 11g, SQL Server 2008, TOAD, PL/SQL, JavaScript, Linux.

Confidential, Pennington, NJ

Cognos Developer

Responsibilities:

• Involved in all phases of the data warehouse project lifecycle, which includes assessment, business requirements gathering, data modeling and database design, ETL/BI architectures, Reporting Model and report Development, performance tuning, and data delivery mechanisms.
• Created metadata models using Framework Manager with relational data and deployed packages to the Cognos Reporting Servers
• Designed and Developed DMR models using regular & fact dimensions in Framework Manager
• Implemented data level, object level and package level security in framework manager to achieve highly complex security standards
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts in Report Studio
• Developed Reports using Conditional Formatting, Cascading Prompts, optional prompts and Report Bursting
• Developed dimensional models in Transformer, built cubes and published cubes to Cognos Portal
• Involved in Upgrading Cognos reporting application from Cognos Version 8.4 to 10
• Created, refreshed and supported Cognos Transformer OLAP models and Power Play cubes
• Developed Dashboard reports to display all the information related to environment using Summary reports
• Coordinated with functional users for User Acceptance Testing prior to releasing system changes in production

Environment: Cognos 10.1.1/8.4, Framework Manager, Transformer, Report Studio, Query Studio, Oracle 11g, SQL Server 2008, TOAD, SQL Navigator, PL/SQL, Java Script, Informatica 9, AIX

Confidential, Horsham, PA

Cognos Developer\Admin

Responsibilities:

• Developed and implemented information management solutions as a part of Business Intelligence Organization
• Involved in all phases of the data warehouse project lifecycle, which includes assessment, business requirements gathering, data modeling and database design, ETL/BI architectures, Reporting Model and report Development, performance tuning, and data delivery mechanisms
• Participated in the design, development, deployment and support of Reporting solutions in the areas of Sales & Marketing, Forecast & Planning and Supplier Performance
• Assisted and worked with ETL developers and data modelers to make sure that model being developed is according to the business requirements
• Used Data Source Query Subjects, Model Query Subjects and Stored Procedure Query Subjects in Framework manager
• 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.
• Administered Cognos BI Server Environment
• Managed Data Sources, run activities, user accounts and permissions

Environment: Cognos 8.4, Transformer 8.2, Report Studio, Query Studio, Metric Studio, Oracle 10g, DB2 7, Erwin 4.0, TOAD, PL/SQL, UNIX, Cognos 8 SDK

Confidential

SQL Developer

Responsibilities:

• Involved in designing of Conceptual Logical Model and Physical Model
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs
• Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data
• Involved in performance tuning and monitoring of both T-SQL and PL/SQL blocks
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures
• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs
• Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data.

Environment: SQL Server 2000/7.0, Oracle 8i, Windows, C++, HTML, T-SQL