SUMMARY

• 11 Plus Years of overall experience in IT industry with Application development, maintenance, Business Intelligence and Reporting Data warehousing, ETL and other Technologies with development and have an exposure to Architecture, Design, Development, Deployment, Reporting and Production support for all applications.
• 8 Plus years of IBM COGNOS BI experience with various domains and Integrated with ETL and other BI/Data Warehousing technologies.
• Expertise on Modeling and generating reports using COGNOS Frame work manager, Query Studio, Report net and Report Studio, Power Play for various domains.
• Worked on Query Studio, Report Studio, and Analysis Studio, Transformer and business insight for Report design in COGNOSBI version 8.X, and 10.2, 10.0.1.
• Fine - tuned the performance of the various Report, Jobs, and Queries on COGNOS.
• Built Framework Manager Models, and Data cubes, established the cardinalities to suit the business needs.
• Worked on the Datastage Manager, Designer, and Administrator and Director
• Designed Job Sequencers, Batch Jobs and Parallel jobs using DataStage ETL.
• Designed Parallel jobs using various stages like join, merge, lookup, remove duplicates, filter, dataset, lookup file set, modify and aggregator.
• Experience in integration of various data sources (DB2-400, SQL Server, Sybase, Oracle, and MS-Access) into data staging area.
• Application Development with Technologies with AS400 (RPG IV, CL LE AND DB2/400), JAVA, JAVA Scripts, JSP, and Hands on experience in developing Application in C, C++.
• Exposure in SDLC (Software Development Life Cycle), AGILE Methodology, handling the projects in both offshore and On-site developments and Strong organization skills.
• Knowledge in Domains Home Finance, Insurance, FSSA State (Healthcare, Eligibility modernization, Family welfare Etc.) Warehouse Management System, Material Management system, Inventory Control systems etc.

TECHNICAL SKILLS

BI & Reporting: IBM COGNOS BI 10.2, 10.0.1, 8.3, 8.4, COGNOS 7.X.

ETL Tool: Datastage Infosphere 9.1, Datastage 8.X,7.X/6.X, Ab Initio 1.12

RDBMS: Oracle 12g, 11g, 10.X, 9.X, DB2/400, SQL Server 2008 R2, Stored Procedures, TOAD, Terra Data 13.10.

Programming Languages: RPG IV, CLLE, JAVA2, C, C++, VB Scripting.

Modeling Utilities: Rational Rose, People Soft CRM, Peregrine CRM.

Operating Systems: Windows 9X, 2000, XP, UNIX, 0S/400, S/390.AIX.

Web Technologies: JAVA Script, HTML and Servlets, JSP1.2, Web Sphere 5.1. Apache 2.0.52.

PROFESSIONAL EXPERIENCE

Confidential, Westfield Center, Ohio

Senior Cognos BI Developer

Responsibilities:

• Primary responsibilities in this project a Design, Develop and deploy the MIS Status Boards and Corresponding Drill through Reports.
• Effectively used the Report Studio to develop the Dashboards and other reports.
• Creating the Data sources in the cognos connections and make them to use it in frame work to import the metadata.
• Imported the Metadata, Table definitions from the Data warehouse into the Framework Manger.
• Define and develop the relationships in the model between the fact and dimension table on Report studio Level and Framework Manager Level.
• Created multiple layers in the Framework Model to make understand the fields and columns for the Business users and Development purposes.
• Achieved Dynamic Headers and footer links and conditional colorings.
• Writing Drilldown definitions and toot tips on the dashboards on Graphs.
• Defined and creates New Query Subjects and Query items using User defined calculation/Measure and filters.
• Create and publish the packages in the Cognos portal and restrict the security on the packages.
• Created views on Netezza Database based on the requirements.
• Written Complex SQL’S for Unit Testing and report and reporting purpose.
• Performance tuning for the status Boards and Reports.
• Interacted with business users and BA Team for the Requirements and Cognos Training stuffs.

Environment: IBM COGNOS 10.2.1,10.2.2. Suit, Framework Manager 10.2, Netezza 6.0.8, DB Visualizer, Oracle 11g, JAD, HP Quality Center 10.0.

Confidential, Gastonia, North Carolina

Senior BI Architect Cognos Cubes

Responsibilities:

• Primary responsibilities in this project a Design, Develop and deploy the multidimensional cubes using Cognos Frame work Manger and Transformers.
• Created and modified the tables in the Data warehouse to build the Data Mart and to create schemas in the Database level.
• Added the constraints on the table and define the keys in the table to make relations with other tables.
• Creating the Data sources in the cognos connections and make them to use it in frame work to import the metadata.
• Imported the Metadata, Table definitions from the Data warehouse into the Framework Manger.
• Define and develop the relationships in the model between the fact and dimension table.
• Created multiple layers in the Framework Model to make understand the fields and columns for the Business users and Development purposes.
• Defined and creates New Query Subjects and Query items using User defined calculation/Measure an filters.
• Create and publish the packages in the Cognos portal and restrict the security on the packages.
• Developed Query, Data source for Cubes using different data sources the Transformer and Deployed in the server.
• Created Dimension and Measures, Defined properties for the all the elements in the Cube, Setting up the properties.
• Publish the cubes for user to use with different utilities in the Cognos connection (Analysis Studio’s, Report Studio, Workspace ETC.).

Environment: IBM COGNOS 10.2.,IBM Framework Manager 10.2, IBM Transformer 10.1, Teradata 13.10, Oracle 12c, Oracle 11g, IBM Info sphere Data stage/Quality Stage 9.1, SQL Developer Suit, Unix, AIX, MDX SQL..

Confidential, Bloomfield Hills, Michigan

Senior BI Analyst

Responsibilities:

• Actively involved in the Converting the whole Dataware house from Oracle to SQL Server.
• Decomposing the FM packages and Report and updated, modified according the SQL Server standards.
• Modified the Schema and the models and Denormalised couple of tables in the model/schema.
• Change the Data Sources from Oracle to SQL Server/ Added New Data Sources.
• Updated and modified the Functions which is not supported by SQL Server in the report studio and FM.
• Developed lot of Complex Queries with multiple joins on Oracle and Sql side for testing.
• Designed and Developed couple of Reports and Score Cards.
• Documentation of the Reports and Ad Hoc Reports and the Packages for the conversion support.
• Regression Testing on the Reports and Query Studio reports and validated packages.

Environment: IBM COGNOS 8.4.1, SQL Server 2008 R2, Teradata12,Oracle 11g, IBM Datastage 8.0, Oracle Query builder, MS Share Point, MS Visual Studio for Agile Methodology.

Confidential, Columbus, Ohio

Senior Cognos BI Developer

Responsibilities:

• As a part of SLA AOM Team my responsibilities includes mainly on development and Productions support as well.
• Developed/Derived the Business KPI’s and Metrics with List, Crosstabs and graphs.
• Analyzed the Incident management system / Centralized production Reporting system and its databases, schemas to create a models and Schema’s in the framework manager level.
• Integrating the new databases into the existing package and Created new packages based on the requirements.
• Designed Schema and joins over the tables in Oracle and SQL Server Databases.
• Designed / Developed the Dashboards for the managers to monitor the workflow for their teams and the performance using KPI’s.
• Created prompt based dashboard to generate the reports interactively by prompting/choosing the values interactively and export it in to Excel/PDF/CSV formats.
• Used the Drill through options in the dashboard to generate the reports from summary to detailed report.
• Used Conditional styles / coloring /Prompting and Static Datasets.
• Created automatic SLA alerting system using the burst options.
• Extensively worked on report studio to develop the reports.
• Developing SQL’S based on the requirements of the user.
• Unit testing and integration testing for the developed products.
• Documentation for Technical Design and functional requirements.
• 24X7 Production Support for the reports and Dashboards running in production.
• Designs and schedule the Sequence and parallel jobs for Dashboards and Reports.
• Scheduling and maintaining the reports in production and support the users in cognos environment.

Environment: IBM COGNOS 10.0.1,COGNOS 8.4.1, Oracle 11g, SQL Server, DB2, Peregrine 6.5.1, MS Share Point, Business Insight.

Confidential, Indianapolis, IN

Senior Cognos/ETL Consultant

Responsibilities:

• Responsible for Technical Analysis, Application Design, Coding, and Debugging &Unit Testing new programs and modifying the existing programs in accordance with the business functions and comply with the application standards using.
• Worked on developing standard list Reports, Charts, Cross tab Reports, Drill-Through and Master Detail Reports enabling to understand and monitor current performance while planning future business strategies.
• Prepared technical design/specifications for data Extraction, Transformation and Loading for the developers.
• Created Dashboards for the business need using Drill through, cross tab report, Chart and Maps.
• Created Multi Dimensional Cubes
• Created and busted reports to Email and Web.
• Designed and generated Cubes and reports as per the requirement and user needs using COGNOS.
• Standard templates were made; multilingual reports were also generated using Report Studio
• Migrated Impromptu catalogs to Framework manager models.
• Scheduling reports through Schedule Management in COGNOS Connection.
• Mapping Data Items from Source Systems to the Target System.
• Involved in Dimensional Modeling and created Star Schema for the FDW (Financial Data Warehouse).
• Worked on Data stage Utilities - Source Analyzer, Warehouse Designer, Mapping Designer, and Transformation Developer.
• Designed to automate the process of rebuilding the indexes on monthly basis and send the reports to the Functional mailbox.
• ETL development and automation of complete process.
• Various kinds of the transformations were used to implement simple and complex business logic.
• Transformations used are: stored Procedure, connected & unconnected lookups, Router, Expressions, source qualifier, aggregators, filters, sequence Generator, etc.

Environment: COGNOS 8.4, 8.X, COGNOS SDK, DATASTAGE EE 8.X, 7.X, VB Scripting, UNIX, AIX, DB2,TOAD, Clear Quest, Clear Case, CA7, I3.

Confidential, Columbus, Ohio

Senior Cognos BI Consultant

Responsibilities:

• Created Dashboards for the business need using Drill through, cross tab report, Chart and Maps.
• Created Multi-Dimensional Cubes
• Created Ad hoc Reports using Query Studio.
• Created and busted reports to Email and Web.
• Designed and generated Cubes and reports as per the requirement and user needs using COGNOS.
• Migrated Impromptu catalogs to Framework manager models.
• Scheduling reports through Schedule Management in COGNOS Connection.
• Mapping Data Items from Source Systems to the Target System.
• Prepared technical design/specifications for data Extraction, Transformation and Loading.
• Involved in Dimensional Modeling and created Star Schema for the FDW.
• Worked on Data stage Utilities - Source Analyzer, Warehouse Designer, Mapping Designer, and Transformation Developer.
• Created Ad hoc Reports using Query Studio.

Environment: IBM COGNOS 8.4, 8.3,COGNOS SDK, DATASTAGE 7.XUNIX,DB2/400, OS/400, Oracle 9.x, 10.x, 11G, Stored Procedures, Autosys.

Confidential, WhiteHouse Station, NJ

Senior Cognos Architect/Consultant

Responsibilities:

• Business Analysis and Requirement gathering.
• Created list, cross tab, repeater, Drill through, master-detail, chart and complex reports which involved multiple prompts, filters, reports against multiple databases.
• Responsible for cleansing the source data.
• Created Multi-Dimensional Cubes using Power play Transformer.
• Creating relationships among the tables in Framework Manager. Creating Namespaces, Folders and Packages.
• Generating the reports and data cubes based with various databases.
• Working on Dimensional modeling to Design and develop STARSchemas.
• Writing documentation to describe program development, logic, coding, testing, changes and corrections.
• Optimizing the mappings by changing the logic to reduce run time.
• Automation of the process using autosys

Environment: COGNOS8.X,7.X,Cognos SDK,MS SQL Server,Main frames,DB2, AIX, People Soft CRM, Control-M.

Confidential, Houston

Senior Cognos Consultant

Responsibilities:

• Interfaced with Business users for gathering the business requirements and designed user-friendly templates to communicate any further enhancements needed.
• Creating the report based one the user requirements.
• Worked on Framework manager to import metadata from multiple data sources.
• Developed various complex reports in Report Studio.
• Created list, cross tab, repeater, Drill through, master-detail, chart and complex reports which involved multiple prompts, filters, reports against multiple databases.
• Created OLTP reports in COGNOS impromptu by Developing Catalogs.
• Generated OLAP Cubes in COGNOS Transformer and analyzed the data using COGNOS PowerPlay.
• Generated various kinds of reports (daily, monthly etc) in ReportNet.

Environment: COGNOS 8.0, 7.X, DATASTAGE 7.5.x2, Erwin 4.0, AS/400, Oracle 8i, SQL* Loader, TOAD, Windows2K, Sybase 12.x, DB2 7.x, Sun Solaris 7.0, Teradata, IBM Web Sphere v5.1 Express, JSP, Servlets, EJB, JDBC.

Confidential

Data ware House Consultant

Responsibilities:

• Responsible for understanding the code, creating the algorithms and peer reviewing other team member’s algorithms from Assembly Language.
• Involved in development, review and testing the Ab Initio graphs. Extensively worked with highly complex logic done with efficient methods in forms of Ab initio graphs.
• Involved in developing template Ab Initio graphs, which proved to be of great use in reducing development time activity.
• Process Graphs are using components like Input File, Output File, Lookup File, Join, Normalize, and Read Raw, Reformat, Filter by Expression, and Replicate.
• Implemented phasing and checkpoint approach in ETL process to prevent data loss and to maintain uninterrupted data flow against process failures.
• Developed and tested ETL applications for the warehouse application according to functional specifications using AbInitio, UNIX scripts, and Oracle PL SQL and SQL and also developed scheduling scripts.
• Performed Transformation and Validation process.
• Uploaded the output file to Mainframe and Match data against output in M/F.

Environment: Ab Initio EME, Ab Initio Co>Operating system 2.12.1, Ab Initio GDE 1.12.1, COGNOS 7.X,Oracle 8i, PL/SQL, SQL, SQL*PLUS, TOAD, Unix Shell Scripting, Assembler, Mainframe.

Confidential

Software Engineer (BI)

Responsibilities:

• Responsible for Business Analysis and Requirements gathering.
• Reports have been created using COGNOS 6.x and 7.X reporting tool.
• Developed Impromptu Web Reports (IWR) and published on web upfront using Report Administrator.
• Created and published packages in framework manager from various sources like IQD’s and Erwin models.
• Created and busted reports to Email and Web.
• Worked on Power play Enterprise server for Cube Deployment in Web
• Cubes designed with Frame work manager and query manager.
• Coordinating with source system owners, day-to-day ETL progress monitoring, worked on Datastage7.1/6.2 tool - Source Analyzer, Data warehousing designer, Mapping Designer and Transformations.
• Designed Sources to Targets mapping from primarily Flat files to Oracle using Datastage.

Environment: COGNOS 6.X, COGNOS 7.X, Impromptu 7.0, COGNOS Power Play Transformer7.0, Oracle 9i, UNIX, Windows 2000.

Confidential

Software Engineer

Responsibilities:

• Designed and developed a materials management system application in the client-server environment by utilizing on AS/400.
• Worked on the part of analysis, design development, testing
• Designing database in DB2/400.
• Designing screens in SDA and DDS.
• Programming in CL/400, RPG/400 and Sub-File Programming.
• Utilities like SDA, DFU, and RLU were extensively.

Environment: AS/400,RPGIII, RPG ILE, CL/400, DB2/400, SQL/400and Query/400