PROFESSIONAL SUMMARY:

• 12 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.
• 9 Plus years of IBM COGNOS BI, COGNOS ANALYTICS, and WATSON experience with various domains and Integrated with ETL and other BI/Data Warehousing technologies.
• 4 Plus Years Hands on Experience in Tableau Desktop, Tableau Server, Tableau Reader import Data source/Data and Develop Reports/Scorecards.
• 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 COGNOS BI 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, DMR, Relational Models and Data cubes, Data Summarization, 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 (Teradata 12,13, 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 Stored Procedures, PL/SQL, T SQL.
• Exposure in SDLC (Software Development Life Cycle), AGILE Methodology, JAD and handling the projects in both offshore and On-site developments and Strong organization skills.
• Knowledge in Domains Health Care, Home Finance, Insurance, FSSA State (Eligibility modernization, Family welfare Etc.) Warehouse Management System, Material Management system, Inventory Control systems etc.

TECHNICAL SKILLS:

BI & Reporting: IBM COGNOS Analytics V11.0.X, IBM COGNOS BI 10.2.2, 10.2.1, 10.0.1, 8.X, COGNOS 7.X, Cognos Ms Go Office 8.X, 10.2, Tableau 9.3, 10.0.(DTP/Server).

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

RDBMS: Oracle 12c, 12g, 11g, 10.X, 9.X, DB2/400, SQL Server 2008 R2, Teradata 13.0, 12.0

Programming: RPG IV, CLLE, JAVA2, C, C++, VB Scripting, PL/SQ, Stored Procedure.

Other Utilities: Rational Rose, People Soft CRM, Peregrine CRM, HP Quality Center.

Operating Systems: Windows Series, Windows Server, UNIX, 0S/400, S/390.AIX.

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

PROFESSIONAL EXPERIENCE:

Confidential, Wooster, Ohio

Senior BI Developer/Architect

Responsibilities:

• Responsible for Design, Develop and Deployment Reports/Dashboards and Corresponding Drill through 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.
• Created /Designed Dimensions/Measure and Levels for Power Cubes MDX/ DMR and relational packages in Framework Manager.
• Create and Deploy/Publish the Power Cubes MDX for the users.
• Created SSIS Packages/Jobs to extract, Transform and load the Data to support the reporting needs.
• Define and develop the relationships in the model between the fact and dimension table on Report studio Level and Framework Manager Level.
• Created Reports and score cards using the MDX Source and MDX Functions for the reports.
• Created multiple layers in the Framework Model to make understand the fields and columns for the Business users and Development purposes.
• Designed and Developed Multiple Graphs, crosstabs and Dashboards on V11.
• Hands on Cognos Administration define security/Groups, Scheduling and Managing the Cognos Reports and jobs, Migrations from one environment to another one.
• Created Reports Score cards / Dashboards with DMR, Relational Packages in Cognos.
• Developed Reports/Scorecards Using Tableau Widows Desktop version.
• Create and publish the packages in the Cognos portal and restrict the security on the packages.
• Written Complex SQL’S for Unit Testing and report and reporting purpose.
• Performance tuning for the status Boards and Reports.
• Installed / configured Cognos Analytics V11 and Explored the Modern dash boarding options.
• Limited Cognos Administration work and successfully migrated the version from 10.2.1 to 10.2.2.
• Worked with Business users/Adjuster/ Management Report Users and BA Team for the Understand the business, Requirements gathering and to define Business Metrics.
• Trained users on Cognos Utilities and Developed Packages, Cubes and Analytics V11 (User Training).

Technical Environment: IBM COGNOS Analytics V11.0.X, IBM COGNOS 10.2.2, 10.2.1. Suit (Transformer, Framework Manager, Cube Designer, Workspace, Configuration, Administration), Tableau 9.3(Windows Edition), Framework Manager 10.2.2, SSIS, SQL Server 2012, Oracle 12c, SQL Stored Procedures (PL/SQL), Server Management Studio, Microsoft Visual Studio 2010, MS Access.

Confidential, Savana, GA

Senior BI Developer

Responsibilities:

• Requirements gathering from the Users directly and thru Business Analysts.
• Import the tables and views to the Tableau create a Data source
• Designed and Developed Reports and Dashboards using Worksheets and Dashboards and Stories.
• Designed and Developed Status cards.
• Used the features like Parameter, Calculated fields, Global Filters and calculated measures Etc.
• Used Parameterized Global filters for the Dashboard wise.
• Extensively used Quick Filters, Context Filters and Calculation on various Dashboards.
• Created Data visualizations with various types of charts, crosstabs and Lists.
• Used Pass through custom SQL Options to bring the data to the Tableau Server.
• Experienced with Tableau Installation, Version upgrade, Tableau repository maintenance and backup’s etc.
• Unit Tested the Reports, Dashboards and Status cards.
• Provided support once the dashboards were published if there were any data changes, system changes, or requirement changes.
• Involved in trouble shooting of performance issues which were associated with Tableau reports.
• Utilized Tableau server to publish and share the reports with the business users. Also involved in administration tasks such as providing access to the users and adding them to the specific group
• Maintaining User Administration, User Training on the Tableau Server Side.
• Developed report using multiple data sources (Excel, Database, Flat files)

Technical Environment: Tableau 10.0, Tableau 9.0, Tableau 8.1 Windows Version (Worksheet, Dashboards, Story), SQL Server 2012.

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 and Developed DMR/Relational Packages in FM.
• 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 with DMR enhanced packages.
• Defined and creates New Query Subjects and Query items using User defined calculation/Measure and filters.
• Written Java Scripts to enhance the Dashboards with Hide and see the prompts and prompt pages to select the particular prompts to use in the dashboard.
• Build the MS office Integrated reports /dashboards on the Office Suit.
• 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.

Technical 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. IBM Cognos 10 Go Office

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 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.).

Technical 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.
• Worked on the Java Code the burst the reports based on the Regions by creating different folders updated the Oracle Drivers/Connection strings with SQL Server Drivers embedded in the Java Code.
• 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.

Technical 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.
• Design and Develop the Details / Summary reports based on the requirements from the business and the management people distributed the people on the Distribution list by Daily / Weekly / Monthly / Yearly based on the requirement.
• 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 with DMR’s and Relational Models.
• 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/Implemented Go office for the Cognos BI Suit 10.1 for the user based operations.
• Used Conditional styles / coloring /Prompting and Static Datasets.
• Created automatic SLA alerting system using the burst options.
• Used HTML/Java script to format the Data contents and dynamic sorting orders.
• 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.

Technical Environment: IBM COGNOS 10.0.1,COGNOS 8.4.1,MS Go Office 10.x, 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.
• Used event studio to schedule the agent and job for monitoring the events to trigger the report.
• 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.

Technical 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:

• 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.
• 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.

Technical 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, White House 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.

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

Confidential, Houston, TX

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.

Technical 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

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.

Technical 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.
• This package kept track of all material indents, checked the requirement with the available stock in stores and released the purchase orders on approved vendors for the non-available items in the stock.
• Worked on the part of analysis, design development, testing
• Designing database in DB2/400 and Designing screens in SDA and DDS.
• Programming in CL/400, RPG/400 and Sub-File Programming.
• Utilities like SDA, DFU, and RLU were extensively.

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