CAREER OBJECTIVE:

Being a self - motivated professional, I can work solo or as part of a team in delivering high quality solutions that are customer focused. I would like my career to advance parallel to my knowledge base and this evokes in me, a continuous stimulus to gradient my skills.

EXPERIENCE SUMMARY:

• 10.5 years of experience in IT Industry with 10+ years of experience in the field of Data Warehousing / Business Intelligence Technology encompassing Domain areas like Finance, Banking, Telecom, Retail, Insurance and Aviation.
• Exposed to all phases of Software Development and solution Architect life cycle including requirement gathering, analysis, design, development, testing, User acceptance and deployment.
• Strongly deadline driven, Strong Technical Knowledge, Analytical and Problem Solving skills, Communication skills, Exhibiting leadership qualities in a Team and ability to get on well with people including cross-cultural backgrounds.
• Expertise in the development and design of Data warehousing applications and Data modelling on both ETL & OLAP.
• Sound knowledge of Data warehousing products IBM Cognos 10.1,10.2, Dynamic Cubes, Cognos 8.4, Cognos SDK, Cognos 8.3, Cognos 8.2, Cognos Report net 1.2, Data Modelling on Framework Manager, DMR Model, Cube Designer, Power play Transformer and Map Manager, Business Objects (BODI & Xcelsious Dashboards), Cognos TM1, Micro Strategy, OWB, Netezza, SQL Server, Oracle Database and Erwin.
• Onsite and Offshore Implementation experience from USA, United Arab Emirates, Kingdom of Saudi Arabia and India.
• Certified on IBM Cognos 8 BI Metadata Modeller, Micro Strategy Project Designer and Teradata Basic Certification V2R5
• Having Experience on Solution Architect, Technical Team Management and Handling projects on ETL and OLAP Technologies.

CORE SKILLS:

OLAP Tools: IBM Cognos 10.1,10.2, 8.4, 8.3, 8.2, 8.1(All Suites Including Administration, Data Modelling (FM, DMR, Cube Designer and Power play Transformer and Security), Dynamic Cubes, Cognos SDK, Cognos Report Net 1.2, Cognos Power play 7.3, BOXI Xcelsious, Cognos planning, Cognos TM1, Metric Studio, Micro strategy, MS-OLAP and MS Reporting Services

ETL Tools: Business Objects Data Integrator (BODI), Data Transformation Services (SQL Server 2000), OWB, Hummingbird Genio

Databases: Netezza, Oracle 9i, 10g, 11g, SQL Server2000, MS Access2000 and Teradata, Sybase

Verticals: Finance, Banking, Telecom, Aviation, Insurance and Retail

Other Tools: C, C++ and Robo Help

PROFESSIONAL EXPERIENCE:

Confidential, NJ

Cognos Senior Onsite Lead cum Solution Architect

Operating System(s): Linux

SKILL:Cognos 8.4,10.2, Cognos SDK, Oracle 11g, Sybase, Java

Environment: Cognos, Oracle

Responsibilities:

• Involving Day to day interactions with client and business stake holders and Single point of contact to the client on all Cognos project deliveries and Production related issues.
• Responsible for BRD Analysis, Estimation, Designing, Testing and Delivery for Assignments
• Responsible for preparing Functional Specification Document, Non-Functional Requirement Document, Approach Paper, Design Specification Document, Test Cases Document, Testing & Code Review Document, Delivery Release Notes, Deployments, etc.
• Managing Onsite and Offshore Cognos team on work allocation and their deliverable.
• Maintaining and Reviewing the Issues, clarifications Trackers, design and Coding.
• Enhancing the existing set of 300+ reports
• Creating new set of Reports
• Created POC on Cognos 10.2 functionality and use cases specific to EPAS application
• Creating Active reports and Dashboards.
• Working on release management and familiar on JIRA, HP Quality, Team Track, Application Release, SNOW applications.

Confidential, New Jersey

Cognos Senior Consultant

Operating System(s): Windows

SKILL: Cognos 10.2.1, Cognos 10.1, Dynamic Cubes

Environment: Cognos, Teradata

Responsibilities:

• Involving Day to day interactions with client and business stake holders, requirement gathering and Technical design document preparation.
• Created POC Reports using DMR, Relational and TM1 Cubes.
• Created POC on Dynamic Cubes
• Designed and created DMR Modelled Framework Manager
• Created Finance related complex reports, Dashboards using DMR Model
• Created Reports using TM1 Cube.
• Created Active Reports, Work space reports and Advanced Workspace reports.

Confidential, NJ

Cognos Senior Onsite Lead cum Associate Solution Architect

Operating System(s): Linux

SKILL: Cognos 8.4,10.2, Cognos SDK, Oracle 10g, Sybase, Java

Environment: Cognos, Oracle

Responsibilities:

• Provided the Technical solutions to the team and client on major issues on the Confidential Cognos Application and providing the implementation approach
• Worked on Cognos SDK to integrate Cognos application to Java web based client specific application.
• Worked on Complex reports with huge data sets and providing the technical solutions on complex issues.
• Implemented the Burst concept on large volume of data and re designing the project to improve performance of the reports.
• Involved Day to day client and business interactions, requirement gathering and design document preparation.
• On site coordination and work allocation to the team
• Maintained and Reviewed the Issues, clarifications Trackers, design and Coding.
• Managed the Team and project on Cognos Stack of Technologies.
• Implemented the multiuser FM model approach and execution.
• Actively Involved in KT Transition and Worked on KOP document deliverables.
• Involved on Multiple phases of project execution (Replication, Transition, Absorption and Steady State)

Confidential

Cognos COE Senior Technical Lead

Operating System(s): Windows

SKILL: Cognos 10.1,10.2, Cognos 8.4, Oracle 10g, Cognos TM1, SQL Server 2008

Environment: Cognos, Oracle

Responsibilities:

• Worked on POC Implementations (Victoria Roads) more on to the Map reports and integration with Google maps.
• Worked on Map manager and Geo set manager to get interaction with TAB files.
• Prepared Industry solutions, Knowledge Management, Case Studies, Technical white papers, Methodologies and Best Practice Documents
• Worked on RFCs, Preparing Estimations based on RFCs for the clients Boots, Interacted with Pre-sales and Multiple COE Heads, Prepared Questionnaires
• Involved in Due Diligence with presales team. Involved in multiple projects by providing the Technical solutions to the team on request by online /offline.
• Handling COE operations for the Cognos stack of technologies.

Confidential

Senior Technical Lead

Operating System(s): Windows

SKILL: Cognos 10, SQL SERVR 2008, Oracle 10g

Environment: Cognos, Oracle, SQL Server

Responsibilities:

• Created Cross Database (Oracle, SQL server) access for Single FM and reports based on user selection.
• Developed the Dimensional Framework Manager Model, Report studio Reports and Business Insight Dashboards.
• Created the security at FM level and report level for Bank Hierarchy.
• Created set of Oracle stored procedures based on SQL server views and procedures to support multi database for Cognos reports.
• Involved in Design Document and Unit test cases preparation.
• Managed the project from cognos front.
• Installations and configuration of Cognos 10

Confidential

Technical Lead

Operating System(s): Windows

SKILL: Cognos 8.3, oracle 10g

Environment: Cognos, Oracle

Responsibilities:

• Analysis business requirement, design and implementation of Cognos Solution.
• Developing the Framework Manager Model and Report studio Reports.
• Creating set of Oracle stored procedures for Cognos report based.
• Involved in Design Document and Unit test cases preparation.
• Preparing test cases and testing the Reports.
• Managing the project from Cognos front.

Confidential

Cognos COE Technical Lead

Operating System(s): Windows

SKILL:Cognos 10 Beta Version, Cognos8.4

Environment: Cognos, Oracle

Responsibilities:

• Worked on POC Implementations( BO to Cognos Migration, Cognos 8.4 to Cognos 10 Migration, Solvency II)
• Prepared Industry solutions, Knowledge Management, Case Studies, Technical white papers, Methodologies and Best Practice Documents
• Prepared Cognos Deck, Cognos Capability and Migration Methodology Presentations.
• Worked on RFCs, Preparing Estimations based on RFCs for the clients IKEA, BCBS, Kodak, ITERGO, Merck, RBS, UBI, NCB, HKHA, MYSIS and CDI
• Interacted with Pre-sales and Multiple COE Heads, Prepared Questionnaires for IKEA, BCBS, Kodak, ITERGO, Merck, RBS, UBI, NCB, HKHA, MYSIS and CDI.
• Involved in Due Diligence with presales team.
• Involved in multiple projects by providing the Technical solutions to the team on request by online /offline.
• Handled COE operations for the Cognos stack of technologies.

Confidential

Project Lead

Operating System(s): Windows

SKILL: Cognos 8.1

Environment: Cognos, Teradata

Responsibilities:

• Involved in project kick off and Project Initiation
• Preparation of dPMM model based documents.
• Preparation of TDD and TAD Documents.
• Preparation of LLDs for Cognos Reports.
• Handing a Team of 5 members
• Working on global delivery model(Onsite & Offshore)
• Developed Reports in Cognos Report Net with conditional renders.
• Preparing the WSR and Work allocation to the Team
• Reviewing the developed ETL jobs and OLAP Reports.
• Prepared the UTCs and User Acceptance Test cases.
• Preparation of Performance Test Cases.
• Prepared the User manual on Cognos Reports.
• Handling all project related information in Quality Site - Manage Me (Igate Internal)

Confidential

OLAP & ETL Lead

Operating System(s): Windows

SKILL:Cognos 8.4

Environment: Cognos, Oracle

Responsibilities:

• Managed the project as Lead from onsite
• Requirement Gathering and Analysis
• Interacting with client on requirements
• Preparation of System Requirement Specification Document
• Getting the sign offs on requirements by module wise.

Confidential

OLAP Lead

Operating System(s): Windows, Linux

SKILL: IBM Cognos BI 8.4

Environment: IBM Cognos BI, DB2

Responsibilities:

• Single point of contact on OLAP related queries
• Installation and Configuration of IBM Cognos BI
• Single Sign on Security implementation on LDAP server integrated with IBM Web Server
• Analysis of POC Business Requirements
• Created the Framework Manager Model for Form 700 Reports
• Created the Form 700 Reports

Confidential

ETL Lead

Operating System(s): Windows, Unix

SKILL: Business Objects Data Integrator, Netezza and Teradata.

Environment: BODI, Netezza

Responsibilities:

• Analysis of Business Requirements
• Preparing the Design Document for the MSC CDR, SMSC, MMSC, VAS, GPRS, Interconnect and Bill Rated systems.
• Implementing the Dimensions thru BODI.
• Created the Netezza Stored Procedures to load the Fact Data. With complex key generations.
• Managing the project as ETL Lead with 5 Members of Team.
• Reviewed the Implementations and prepared the review records as per Quality Standards
• Preparing the Release manual.
• Created the Xcelsious Dashboards.
• Schedule Management.
• Reviewed the Test cases and Tested the Dimensions and Facts
• Performance tuning and Trouble Shooting.
• Integrated the multiple source systems data load and automated the process.
• Implemented the Source File Management system to load the files on daily and periodic basis by using NZ Utility.