EXPERIENCE SUMMARY:

• IBM Certified Data Warehousing BI Consultant with around 10.8+ years of professional experience in the Information Technology industry with relevant experience in data Warehousing environment, coupled with extensive in Business Intelligence solutions
• Excellent working knowledge on Reporting tool Cognos 10.x/8.x BI (Report Studio/Query Studio, Framework Manager, Cognos Connection and Cognos Administration) and ETL tool DataStage 9.1/ 8.1 on Enterprise DW environment, Netezza, and UNIX
• Expertise on Power Play Transformer model design and Power play cube building.
• Understanding of Star Schema & Snowflake Schema, Fact & Dimension Tables, Physical & Logical data modeling
• Expertise in ETL Design and Development using IBM DataStage Designer and Director
• Excellent working knowledge of designing the Project Data Model and publishing the package created using Cognos Frame Work Manager
• Extensively worked on performance tuning of SQL Queries and gathering table statistics and Query optimization
• Expertise on creating Oracle PL/SQL stored procedures, functions, cursors, and materialized views
• Coded and optimized SQL Queries for data extraction, data integrity validation, data profiling, ad - hoc data analysis to serve service requests logged by business users
• Engaging and coordinating Business Analysis sessions for understanding client business processes and mapping them to required project management standards and supporting clients in attaining their business targets
• Experience in deployment of the ETL Jobs and Reports from development environment to SIT and UAT environments
• Experience in designing the Framework Manager models with BI industry standards such as Physical Layer, Business Layer, and Presentation Layers
• Designed and maintained TM1 hierarchical cubes and security procedures.
• Deft in creating pack of available reports in Cognos-based on user selection using Cognos SDK and defining security in FM using session parameters and mapping table
• Expertise in migrating Jasper Reports from Java iReport and SSRS Reports to Cognos environment
• Expertise in creating Drillthrough Reports, Burst Reports, and Dashboards
• Monitoring System Performance (identifying the no of items in the queue) using Metrics available in Cognos Administration
• Hands-on experience in creating Crosstab, Master/Detail reports using Cognos Report Studio
• Scheduled and Distributed 8/10 BI Reports using Schedule Management in Cognos Connection
• Expertise in designing and development of various dashboards reports utilizing various Tableau Visualizations like Dual Axis Bar Graphs, Pie Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualization and other making use of actions other local and global filters according to the business/client requirement
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse and data marts
• Develop reports using complex formulas and to query the database to generate different types of ad-hoc reports using SSRS
• Experience on various domains including Banking, Securities and Clearing Systems, and Pharmaceutical

TECHNICAL SKILLS:

BI Reporting Tools: IBM Cognos 10.x/ 8.x BI, Microsoft SSRS

ETL Tools: IBM DataStage 7.x / 8.x/9.x, SSIS

Data Modeling: Star-Schema Modeling, Snowflakes Modeling, FACT & Dimensions. Erwin 4.1.

Languages: SQL, PL/SQL, HTML, XML.

Versioning Tools: Motio CI

Databases: Oracle, Netezza, SQL Server 2008/2012

Operating Systems: Windows, Unix.

Other Tools: SQL* Loader, Developer 2000, i-report, Eclipse

Ticket Monitoring Tool: HP Quality Center 10

PROFESSIONAL EXPERIENCE:

Confidential, Irving, Texas

BI Lead

Responsibilities:

• Understood the business requirements, report specification and engaged in requirement analysis
• Prepared Technical Requirement Specification Documents, Technical Design Specifications, Mapping Documents, Test Scenarios and Test Results for the Cognos Reports
• Developed different types of reports (List, Crosstab, and Charts) according to the business user requirements
• Used JavaScript for customizing Cognos reports to achieve out of the box functionalities
• Analyzed technical specification documents and checked feasibility and provided timelines
• Cognos Report Developer (Created Reports using report studio, Query Studio)
• Performed various Analytical Reports in Dashboard Format
• Wrote SQL Server Queries and used them in Cognos Reports
• Generated new reports by formatting, sorting, and applying calculations to the data in the reports
• Used regular prompts, cascading prompts, detailed filters, summary filters, conditional styles, conditional blocks, static headers, Drill Through, and master-detail reports for users in Report Studio
• Developed the Best Practices method for Creating Report Template, Report Prompt Page, Governor Settings, and Report Naming Conventions
• Created and managed sections and page breaks in the reports
• Prepared reports with prompts and conditional formatting
• Scheduled the reports using Schedule Management tool in Cognos Connection
• Used Cognos Bursting to send statements to every Employee and Manager
• Used Active Reports to generate customized Dashboards having user interactivity
• Used Master Detailed Relationship and drillthrough features of Cognos
• Quality Assurance of data using free hand SQL
• Participated in Client meetings to gather requirements and prepared high level documents
• Used various stages of DataStage like Transformer, sort, Join, lookup, copy, filter etc.
• Created DataStage Jobs to load files to SQL Server and Netezza
• Created various DataStage Jobs to automate various file loads that are required for daily processes
• Involved in testing of ETL jobs

Environment: Cognos 10.2 BI (Report Studio, Query Studio), Netezza, MS SQL Server 2012, Framework Manager, DataStage 9.1, SSIS

Confidential, Irving, Texas

ETL Lead

Responsibilities:

• Understood business requirements, and engaged in requirement analysis
• Prepared technical requirement specification, low level design, and mapping documents
• Contributed towards ETL batch application architecture and low level design to include Capture source and Target related information and created Data Flow Diagram (DFDs) of various DataStage jobs for better understanding of the requirements
• Implemented business logics and design DataStage jobs in DataStage 9.1 PX
• Engaged in unit testing, performed code reviews, and created/ updated UTP review checklists
• Educated QA and Operation teams regarding the new application designed
• Responsible for deployment planning and coordination
• Mentored junior team members to create SMTD document at the end of release
• Utilized capabilities of parallel edition, proposed the solution that pulls up all the logic implemented in Source Queries to be implemented using DataStage
• Worked on preparing template design/jobs for standard job implementations (various SCD types)
• Prepared design documentation including Source-to-Target Mapping Design for over 25 jobs
• Development of jobs to implement data replication between source and staging area using DataStage
• Facilitated migration of jobs to UAT and Production
• Resolved data discrepancies and performed root cause analysis for the production issues

Environment: DataStage 9.1/ 8.1, UNIX, MS SQL Server 2012, Netezza

Confidential, Irving, Texas

ETL Developer

Responsibilities:

• Gathered business requirements and prepared Low Level design document for migration of set of server jobs to parallel jobs
• Developed various DataStage jobs using the stages like Transformer, Lookup, Join, and Change Capture Stage
• Performed validation of DataStage jobs and various transformations
• Involved in testing of new and modified ETL jobs
• Analyzed existing server jobs to understand functionality and document any challenges that might arise during migration to DataStage 9.1; the proposed migration strategy was to move the jobs using .dsx files
• Understanding existing stored procedures in the system and preparing data flow diagrams and mapping documents from those stored procedures
• Prepared DataStage development standards document for all new development using parallel edition
• Prepared template design/ jobs for standard job implementations
• Involved in Preparing design documentation for the Jobs that were developed
• Developed jobs to implement data replication between source and staging area using DataStage
• Created migration plan for promoting jobs from Development environment to UAT and production environments

Environment: DataStage 9.1 / 8.1, UNIX, MS SQL Server 2008

Confidential, Irving, Texas

Report Developer

Responsibilities:

• Understood the business requirements and report specification
• Documented the SSRS reports to identify the unique features, parameters, grouping, and sorting
• Created technical specification documents
• Created sophisticated Active Reports
• Analyzed the reports requirements and transformed the functional specification documents into technical specification documents for reports development
• Developed different types of reports according to the business user requirements
• Used JavaScript for customize Cognos Reports to replicate the same SSRS features into Cognos Reports
• Understood the business requirements and transformed them into technical specifications
• Analyzed technical specification documents and checking feasibility and giving timelines
• Cognos Report Developer (Created Reports using Report Studio and Query Studio)
• Worked on various Analytical Reports in Dashboard Format
• Interacted with client on constant basis for clarification on new requests and CRs, and addressed monthly CRs
• Modified MS SQL Server stored procedures, views, and tables to in corporate the new change request
• Created Cognos Framework Manager Models and packages that can be used enterprise-wide for all reporting solutions
• Coordinated with onsite team and provided feedback about proceedings and activities done at offshore
• Designed the Framework model as per Cognos best practices
• Applied performance-tuning techniques to enhance the performance
• Ensured that the existing reports were running fine without any errors
• Quality Assurance of data using free hand SQL
• Studied existing SSRS environment to identify facts, measures, and their aggregation rules
• Built various line and bar graphs to show trends in Lead Time with the ability to drill across to different dimensions and look at the underlying data
• Set up the reporting infrastructure to effectively group reports to use Query or Report Studio as per functionality, and user and security requirements
• Prepared unit test cases and performance test cases

Environment: Cognos 10, Netezza, MS SQL Server 2008, SSRS

Confidential

Team Lead

Responsibilities:

• Understood ETL and reporting requirements from business users and prepared overall data warehouse framework
• Created required Projects, Name Spaces, Data Sources, Query Subjects, and Packages and published the Packages for the sake of Report Authors
• Developed complex ETL jobs using stages that includes Aggregate, Lookup, Join, and Change Capture Stage
• Set Governors on the different projects
• Modified existing queries to switch tables based on user selection
• Defined security in framework manager using session parameters and mapping table
• Involved in validation of DataStage jobs and transformations developed by ETL team to find any issues before promoting to higher environments
• Archived/ purged source files, cleaning-up intermediate datasets
• Involved in unit testing of ETL jobs and Reports
• Educated QA and Operation teams regarding the new application designed
• Resolved data discrepancies and performed root cause analysis on the issues raised by production support team

Environment: DataStage 8.1, Cognos 10.1/8.4.1 Report Studio, Framework Manager, Query Studio, UNIX

Confidential

Team Lead

Responsibilities:

• Integrated data flow from several source systems, spanning a multitude of data formats and conventions, and customized flat file formats.
• Participated in development and testing of ETL jobs for minor enhancements.
• Creating ad-hoc reports using Report Studio and Query Studio.
• Used Report Studio & Query Studio to develop various types of reports including List Reports, Crosstab Reports, Chart Reports, and Master Detailed reports.
• Used Cognos SDK in order to customize reports and integrated with Portal.
• Developed reports using Cognos SDK by java scripts and Eclipse at the back end.
• Used Java.util.zip API for Zipping and Unzipping of files.
• Used different prompt API’s to achieve user required functionalities like clearing prompt selections, preset date prompts, limit time between two dates etc.
• Used Cognos SDK to rename the excel tabs by appending current date or date selected through parameters as per the user requirement.
• Developed a renaming utility using SDK to rename the reports for better distribution of the reports to various user groups.
• Set Governors on the different projects.
• Created Mailing labels using the Repeater table template in Report Studio.
• Involved in migration of existing Jasper Reports in the system to Cognos.
• Engaged in unit testing, performed code reviews, and created/ updated UTP review checklists.
• Worked on production support and escalated any critical issue as required.
• Mentored associates in the team to develop core competency.

Environment: DataStage 8.1, Cognos 8.4.1 Report Studio, Framework Manager, Cognos SDK, Oracle 10g, Eclipse, i-Reports, UNIX

Confidential

Developer

Responsibilities:

• Created required Projects, Name Spaces, Data Sources, Query Subjects, and Packages and published the Packages for the sake of Report Authors
• Developed complex reports by using various query calculations, calculated fields and data item level calculations in Report Studio
• Used Report Studio and Query Studio to develop various types of reports such as List Reports, Cross-tab Reports, Chart Reports, and Master Detailed reports
• Set Governors on the different projects
• Created Query Prompts, Calculations, Conditions, and Filters in the Reports
• Used Drillthrough reports to link multiple reports
• Created condition palettes for effectiveness of the Reports
• Created Mailing labels using the Repeater table template in Report Studio

Environment: Cognos 8.3 BI (Report Studio, Query Studio), Siebel CRM, MS Access, Oracle 9i/ 10g, PL/SQL, MS Windows NT