SUMMARY:

• 15+ years of experience in dealing application software in Health Care, Insurance, Banking & Financial, Credit Cards, Manufacturing and Sales domains.
• 15+ years of experience in IT includes extensive Functional and Technical experience in Data Warehousing, Data Modeling, Business Intelligence (BI), and Customer OLAP, ETL tools, application development and Reports Generation.
• Experience in full software development life cycle including Requirements analysis, design, development and implementation of Business Intelligence using Cognos Business Intelligence Tool suite.
• Experience in Cognos Configuration, Administration and Operational support activities.
• Experience working with Cognos 10.2.2, Cognos 10.2.1, Cognos 10.2, Cognos 10, Cognos 8/8.4 BI Suite (Cognos Connection, Query Studio, Report Studio, Frame work Manager, Analysis Studio, Metric Studio, Event Studio, Business Insight, Workspace) & Cognos Report net(Framework Manager, Report Studio, Query Studio, Cognos Connection, Report Migration, Cognos Configuration), Cognos 6/7EP Series Impromptu Administrator, Catalog, Powerplay Transformer, Powerplay Reporting, Powerplay Enterprise Server.
• Experience in Developing, Maintaining and Enhancing Reports for Business Users.
• Database Engineering - OLTP (Oracle, SQL Server, and DB2), MOLAP (Powerplay cubes) Data Warehousing (star schema, starflake and snowflake architectures) and Extraction/Transformation and Loading (ETL) Process & Performance Tuning.
• Sound knowledge of Oracle 10g, Oracle 9.x/8.x/7.x, DB2, PL/SQL, MS SQL Server 2000/2005/ 2008/2012/2014 (including stored procedures, database triggers and SQL programming).
• Involved with different data sources like Flat files, VSAM, XML files, and Databases.
• Excellent communication skills and efficient team player.

TECHNICAL SKILLS:

Operating Systems: Windows 95/98/NT/2000/2003/XP/7, UNIX, MS-DOS, MVS-ESA, RHEL 6.4.

BI Tools : Cognos 11.0/10.2/10.1/10/8.4/8.3/8.2/8.1/8.0, TM1(Applix),Report NET, Framework Manager, Transformer, Series 7 -Impromptu/IWR, Enterprise Planner (Analyst/Contributor),SSRS, SSIS, Tableau

Cognos: Cognos (Report Studio, Query Studio, Powerplay Studio,Analysis Studio, Framework Manager, Transformer, ActiveReports, Insight, Workspace)

Databases : HADOOP, DB2, Oracle 8i/9i/10g, SQL Server 7.0/2000, Sybase,Access

Languages : SQL, PL/SQL, T-SQL, COBOL, JCL, C, C++, JAVA .

ETL Tools : Informatica, Pentaho.

Scripting Languages : Cognos script, UNIX shell scripting.

Data Modeling Tools : ERWIN (3.5/4.0), TOAD, Rapid SQL, DBArtisan, PL/SQLDeveloper, DB2 Client, Hive, Impala.

Case Tools & Utilities : SPUFI, FILE-AID, ENDEVOR, INSYNC, VSAM, DOCUSHARE AND REMEDY USER 6.0.1, SVN, TWS

PROFESSIONAL EXPERIENCE:

Confidential, Washington, DC

Cognos BI/TM1 Technical Lead

Responsibilities:

• Working with Business Analysts (BA’s) to review requirements, determine gaps, design prototypes, and develop reports based reporting standards.
• Developing Dimensional, MOLAP Cube, and DMR based metadata solutions to meet reporting needs.
• Design, develop, and implement Cognos TM1and Cognos BI solutions for planning and budgeting using TurboIntegrator (TI) and complex business rules.
• Extensively used TI for loading data into Dimensions and Cubes, added new dimensions and cubes to existing environment.
• Mainly understanding of data warehousing methodologies in Informatica.
• Created ETL (Extraction, Transformation & Loading) processes in TM1 performing business rule mappings of relational data into dimensional model.
• Database Engineering - OLTP (Oracle, SQL Server, and DB2), MOLAP (Powerplay cubes) Data Warehousing (star schema, starflake and snowflake architectures) and Extraction/Transformation and Loading (ETL) Process & Performance Tuning
• Sound knowledge of Oracle 10g, Oracle 9.x/8.x/7.x, DB2, PL/SQL, MS SQL Server 2000/2005/ 2008/2012/2014 (including stored procedures, database triggers and SQL programming).
• Creating Project and Importing Meta data using Framework Manager.
• Enhancing the BI Dashboards and Reports using the TM1 packages.
• Involved in writing Complex SQL queries to improve the performance of the report.
• Write SQL queries to debug and test the Reports against DB data.

Environment: Cognos 10.2.2,TM1, Framework Manager, Report Studio, Powerplay, Analysis Studio, Query Studio, Cognos Workspace, Cognos Connection, Oracle, Windows 7, Toad.

Senior Programmer Analyst

Responsibilities:

• Extensively Worked with Business Analysts (BA’s) to review requirements, determine gaps, design prototypes, and develop reports based on government reporting standards.
• Served as Design Lead for all Cognos Reports to develop solutions and meet aggressive client deadlines.
• Worked hand-in-hand with DB Architects and ETL team to design and model Oracle schemas to help support reporting requirements and address performance issues.
• Involved in writing Complex SQL queries to improve the performance of the report.
• Designed Database Tables, Indexes, Keys, Database Triggers and Stored Procedures in Oracle.
• Helped to design test scripts and worked with QA team to ensure reports were accurate, both in data validation and Layout and look and feel.
• Led UAT sessions after each development cycle, reviewing current deliverables and ensuring a high level of customer satisfaction.
• Worked with BA’s to understand the business requirements and create the report technical specifications.
• Designed models using Impromptu Query Definition (IQD), created OLAP Cubes in Cognos Transformer, and analyzed the data using Cognos PowerPlay.
• Developed Dimensional, MOLAP Cube, and DMR based metadata solutions to meet reporting needs.
• Implemented advanced security configuration and subject area dashboards to meet client requirements.
• Design, develop, and implement Cognos TM1and Cognos BI solutions for planning and budgeting using TurboIntegrator (TI) and complex business rules.
• Extensively used TI for loading data into Dimensions and Cubes, added new dimensions and cubes to existing environment.
• Created ETL (Extraction, Transformation & Loading) processes in TM1 performing business rule mappings of relational data into dimensional model.
• Created interactive US State map reports, that provided high level visibility along with drill through capability to get down to low level details.
• Developed Cognos Workspace and Cognos Workspace Advanced interactive Active Report Dashboards.
• Developed Active Report Dashboards to allow users to perform detailed analysis on several KPI’s.
• Manually modified the SQL in ReportStudio to tune and/or to write complicated reports. Used union/Join objects in Report Studio.
• Administered by setting up User and Group level Cognos Security settings for the users to access Cognos Dashboards/Portals and published Cognos packages in Query studio and Analysis studio.
• Worked with DBA’s in devising back up strategy for the Cognos Content store database.
• Troubleshooting the environment in case the BI server goes down or contact the DBA in case of the down time of the content store database.
• Worked on Deployments in different environments and Performed Admin task on Imports, Exports and Scheduling the Jobs and Reports. Deployed the TM1 data into production environment.
• Created Datasource connections and Created user audit reports for account maintenance.
• Upgraded multi server environment from 10.2.1 to 10.2.2 FP3.
• Start/Stop Cognos services in Linux servers and update DB Password changes in Configuration and Administration for Audit DB, Content store, DS signon.
• Adopted best practice approach for Cognos BI development, deployment and security.

Environment: Cognos 10.2.2, Framework Manager, Informatica, Report Studio, Analysis Studio, Query Studio, Cognos Workspace, Cognos Connection, SQL Server 2008/2012/2014, Oracle, Windows 7, Toad, CALT, SVN, WinSCP, Hive, Impala, Pentaho, TWS, RHEL 6.4.

Development Lead

Responsibilities:

• Extensively worked on understanding the business requirements.
• Design Lead for all Cognos reports for the Insight project.
• E2e ownership of design, development and test coordination of all Cognos reports.
• Understand the business requirements and create the report technical specifications.
• Wrote some complex SQL queries to enhance the performance of the cognos reports.
• Creating Project and Importing Meta data using Framework Manager.
• Created the DMR.
• Create Packages and Publishing packages to Report net server.
• Create Data source query subjects, Model query subjects and stored procedure query subjects.
• Developed advanced dashboards in business insight.
• Create Report Studio reports.
• Manually modified the SQL in ReportStudio to tune and/or to write complicated reports. Used union/Join objects in ReportStudio.
• Create Conditional formatting in reports.
• Create Variables and Conditional blocks in Report studio.
• Create Calculations, Prompts, Parameters and Conditions using Report studio.
• Generating various List Reports, Cross tab Reports and Drill -Through Reports.
• Best practice approach for Cognos BI development, deployment, security.
• Created Packages and Publishing packages to Report net server.
• Created Data source query subjects, Model query subjects and stored procedure query subjects.
• Worked on Report design and development.
• Created personalized pages in Cognos Connection.
• Consolidated set of reports from the retiring systems that will provide complete coverage whilst avoiding duplication.
• Worked on data mapping from the retiring systems to GACDW.

Environment: Cognos 8.3,8.4 BI Suite, Framework Manager, Report Studio, Analysis Studio, Query Studio, Business Insight, Cognos Connection, SQL Server 2008/2012/2014, DB2, Windows XP, Informatica, Lotus Notes TeamRoom.

Cognos Developer

Responsibilities:

• Modeling metadata tables for REQST application.
• Creation of Cognos framework manager packages.
• Created Query Studio and Report Studio reports.
• Created Data source query subjects, Model query subjects and stored procedure query subjects.
• Created personalized pages in Cognos connection.
• Created conditional formatting in reports.
• Created calculations, Prompts, Parameters and conditions using Report studio.
• Generating various List Reports, Grouped Reports, Cross tab Reports, Dashboard Reports, Chart Reports, and Drill -Through Reports.
• Designed models using Impromptu Query Definition (IQD), created OLAP Cubes in Cognos Transformer, and analyzed the data using Cognos PowerPlay.
• Manually modified the SQL in ReportStudio to tune and/or to write complicated reports. Used union/Join objects in ReportStudio
• Created Scorecards and Metrics using Metric studio.
• Deployment of Cognos reports.
• Involved in server security mechanism, server performance tuning and tracking.
• Best practice approach for Cognos BI development, deployment, security.
• Used Quality Center for defect tracking.

Environment: Cognos 8.3 BI Suite, Framework Manager, Report Studio, Query Studio, Cognos Connection, Event Studio, Metric Studio, Oracle, Windows2003server, SQL Server 2008/2012/2014, Cognos 8 SDK, J2EE, Informatica, Web Services, Solaris, ESB.

Business Intelligence Analyst

Responsibilities:

• Involved in Report design and development.
• Analyzing existing transactional database schemas and designing star schema models to support the users reporting needs and requirements.
• Created Project and Importing Meta data using Frame work Manager.
• Developed packages using Frame Work Manager and published them to Report net server.
• Created Query Studio and Report Studio reports.
• Created Data source query subjects, Model query subjects and stored procedure query subjects.
• Created personalized pages in Cognos connection.
• Created conditional formatting in reports, enabled multi lingual feature.
• Created calculations, Prompts, Parameters and conditions using Report studio.
• Generating various List Reports, Grouped Reports, Cross tab Reports, Chart Reports, Dashboard Reports and Drill -Through Reports.
• Involved in writing Complex SQL queries to improve the performance of the report.
• Designed Database Tables, Indexes, Keys, Database Triggers and Stored Procedures in Oracle.
• Wrote some complex SQL queries to enhance the performance of the cognos reports.
• Manually modified the SQL in ReportStudio to tune and/or to write complicated reports. Used union/Join objects in ReportStudio.
• Used Remedy user for defect logging and tracking.

Environment: Cognos 8 BI Suite, Cognos ReportNet, Framework Manager, Report Studio, Query Studio, Cognos Connection, PowerPlay Transformer, Oracle, SQL Server 2008/2012/2014, Informatica, Windows 2003 server, Remedy user 6.0.1, Docushare.

Cognos Report Net Consultant

Responsibilities:

• Involved in creation of technical specifications based on functional specifications.
• Involved in Report design and development.
• Developed packages using Frame Work Manager.
• Created Query Studio and Report Studio reports.
• Created Projects and Importing Meta data using Frame work Manager.
• Created Data source query subjects, Model query subjects and stored procedure query subjects.
• Created Packages and Publishing packages to Report net server.
• Created personalized pages in Cognos connection.
• Created calculations, Prompts, Parameters and conditions using Report studio.
• Generating various Dashboard Reports, List Reports, Grouped Reports, Cross tab Reports, Chart Reports, and Drill -Through Reports.
• Created Scorecards and Metrics using Metric studio
• Created conditional formatting in reports, enabled multi lingual feature.

Environment: Cognos 8 BI Suite (Report Studio, Query Studio, Framework Manager, Cognos Connection, Analysis Studio, Metric Studio), Windows XP, Oracle 9i, SQL, DB2.

Cognos Consultant

Responsibilities:

• Understanding the business requirements and report specifications.
• Involved in building models, packages using Framework Manger and published the packages to ReportNet Server.
• Used Cognos Connection to administer Reports as well as the ReportNet Server.
• Created professional reports in Report Studio and ad hoc reports in Query Studio.
• Modified packages to suit the business needs and to improve the performance of the reports by defining filters and adding calculations.
• Created list reports, crosstab reports, chart reports and reports with lot of conditional formatting using Report Studio.
• Developed Catalogs and created reports using Cognos Impromptu.
• Designed models using Impromptu Query Definition (IQD), created OLAP Cubes in Cognos Transformer, and analyzed the data using Cognos PowerPlay.
• Creation of standard filters, prompts, calculations, and conditions in catalog.
• Created various reports such as List reports, Cross-Tab reports, and Drill through Reports using Impromptu.
• Creation and maintenance of multiple shared catalogs using Cognos Impromptu.
• Involved actively in training sessions and demonstrated use of Cognos tools to End-users.

Environment: Cognos ReportNet 1.1, Framework Manager, Report Studio, Query Studio, Cognos Connection, Impromptu 7.3, PowerPlay Transformer 7.3, Oracle, Windows 2003 server.

Cognos Consultant

Responsibilities:

• Designed the Model according to the Business Requirements.
• Built the Model using Framework Manager and published the package to Cognos Connection for Reporting purposes.
• Created filters within the Model for improving the performance of the Model.
• Modified packages to improve the performance of the reports by defining filters and adding calculations.
• Created reports in Report Studio and Query Studio.
• Developed standard Templates, Standard Reports, Charts, and Drill through Reports, Master Detail Reports and Bursting Reports Using Report Studio.
• Created list reports, crosstab reports, chart reports and reports with lot of conditional formatting using Report Studio.
• Created Query Prompts, calculations, Conditions & Filters.
• Developed Multi Page Reports, Prompt pages and Conditional Variables.
• Maintenance of multiple shared catalogs using Cognos Impromptu.
• Assisted users in troubleshooting their reports.
• Trained Users on Query Studio for Ad-Hoc Reporting.
• Created Stored Procedures for Updating and Inserting data into the database.

Environment: Cognos ReportNet 1.0,1.1, Framework Manager, Cognos Connection, Report Studio, Query Studio, DB2, Impromptu 7.2, PowerPlay Transformer 7.2, Informatica, Oracle, Windows 2003 server.

DW Consultant

Responsibilities:

• Created reports in Cognos Impromptu by developing catalogs, OLAP cubes in Cognos Transformer and analyzed the data using Cognos PowerPlay.
• Created standard filters, calculations, prompts and conditions in catalog.
• Created List Reports, Cross Tab Reports and Drill Through reports.
• Published IWRs, PowerPlay cubes and PowerPlay reports on the portal using Cognos IWR administration and PowerPlay enterprise server.
• Extensively worked on understanding the business requirements and was involved in performance tuning of Impromptu Reports.
• Worked on PowerPlay Enterprise Server for cube deployment on the web.
• Coordinated training sessions and demonstration of Cognos tools to end-users.
• Assisted users in accessing their reports.

Environment: Cognos Impromptu 7.0 EP Series, Cognos IWR, PowerPlay Transformer, PowerPlay, PowerPlay Enterprise Server, Upfront, Oracle 8.0 and Windows 2000, UNIX.

Rockwell Automation DW Consultant Mequon

Responsibilities:

• Developed several forms and reports in the process. Also converted several standalone procedures/functions in PL/SQL to packaged procedure for code reusability, modularity and control
• Developed Low stock notice inventory and Back order reports which were generated on monthly basis. and half-yearly basis from report to report interface
• Designed tables, indexes and constraints using SQL*Plus and loaded data into the database using SQL*Loader.
• Developed Stored Procedures and functions to accomplish several computations.
• Helped in identifying the Key Performance Indicators of the Business.
• Worked with layers and Exception highlighting, sorting, ranking etc.
• Created Catalogs, Reports and tuned categories to accessible model.

Environment: Oracle 7.1 using UNIX, Windows NT, and Windows 95, Cognos Impromptu & PowerPlay Transformer 6.0(6.1, 6.6), Cognos PowerPlay EP Series, Oracle.