SUMMARY:

• Over 16 Plus years of extensive experience in the Design, Development, Testing, Implementation and Administration of integrated application software using Cognos 11.x/10.x/8.x,Cognos Planning Analytics 2.0/ Cognos (7.x/6.x), Cognos TM1 10.x, Qlikview and ETL tools (Datastage, Informatica) in Data warehouse.
• Extensive experience in managing the BI intelligence portfolio as portfolio/Tech lead and managing various delivery teams located across the globe as delivery responsible from Apps
• Project manager for Financial reporting projects which includes TM1, DW, Cognos and Qlik view as the components
• Responsible for leading various Cognos projects as Systems Architect with Hands on development from Cognos 7.x/8.0 to Cognos 10.x/11.x and Qlik view Platform
• Responsible for leading Migration of Enterprise Planning applications (Budget and Estimate) from Cognos planning to Cognos TM1
• Extensive experience in using Qlikview, Cognos Framework Manager 11.0/10.2/ 8.4, Reports, Data modules, Dashboards, Workspace Advanced, Cognos Transformer 8.x, Event Studio, Metric Studio, Cognos Connection, Cognos TM1, Cognos Impromptu 7.x/6.x, Qlikview, Cognos Enterprise planning, and Cognos TM1
• Involved individually as well as with the team in the complete life cycle of various projects starting from gathering requirements, Design, Development and deployment using Cognos 11.x/10.x/8.x/7.x/6.x.
• Extensive knowledge in various Internet related platforms with specialization in Cognos 11.x/10.2 suite, Cognos TM1 for Budgeting and Forecast.
• Excellent communications and Interpersonal skills.
• Energetic, hardworking, responsible individual capable of performing under extreme pressure and time constraints.

TECHNICAL SKILLS

Languages: SQL, PL/SQL, UNIX SHELL SCRIPTS, HTML

Databases: Oracle 8/9i/10i/11g,12g, Teradata, SQL Server 7.0/2000, DB2 UDB, MS Access

O/S: Solaris, UNIX, WINDOWS, LINUX

Software: Cognos 11.x/10.x, Cognos Framework Manager 11.x/10.2/8.4/ 8.x, Report Studio 10.2/8.4/8.x, Query Studio 10.x, Analysis Studio 10.x, Event Studio 10.x, Cognos Connection 10.2/8.4/8.x, Cognos Server Administration 10.2/ 8.4/8.x, Cognos TM1, Cognos Impromptu 7.x/6.x, IWR 7.x/6.x, ETL Informatica, Data Stage, Cognos Contributor, Cognos TM1, Data Modules 11.x, Data Sets 11.x, Qlik View, Qlik sense, Tableau, Cognos Planning 2.0

Tools: Quest TOAD, SQL Navigator, PLSQL Developer, Rapid SQL, MS Outlook, MS Office, Lotus Notes, Crystal reports, Oracle Applications 11i, Motio, VSS

PROFESSIONAL EXPERIENCE

Confidential

BI Project lead

Responsibilities:

• Leading the end to end implementation of the project for reporting deliverables
• Providing the architecture and technical design for the team for modelling and reporting
• Resolving the technical issues for the development team along with providing required guidance
• Implementing the security from Cognos based on the user’s profiles
• Designing the dashboards and reports and Data modules using new features of Cognos.
• Managing the report developers and supporting the development team with Frame work model related changes
• Working on required white paper, Presentations and design documents for the project along with required Demos
• Working on providing support for the operations team for bug fixes, fix pack testing etc.
• Hands on Framework model development, Report and Power cube development
• Working with business and end users to provide UAT support
• Support the division based users with Linking the FM Model and support as required based on their development needs.

Software: Cognos11.9/11.x, Framework Manager 11.0, Reports, Dashboards, Data modules, Cognos Analytics portal administration, Teradata, Cognos planning

Confidential

BI Project lead

Responsibilities:

• Leading the end to end implementation of the migration project from Cognos 7.x to Cognos 10.2
• Created the BI layer based on the impromptu catalogs for various Business areas of the project such as Data management and Data Acquisition
• Analyzed the old reports and worked with business to redesign the reports based on current requirements
• Had worked with the Data warehouse team to have the necessary changes in tables and stored procedures to support the project.
• Designing the dashboards and reports using new features of Cognos.
• Managing the report developers and supporting the development team with model related changes

Software: Cognos 10.2/8.4, Framework Manager 10.2/8.4, Report Studio 10.2/8.4, Analysis Studio 10.2/8.4, Query Studio 10.2/8.4, Cognos Connection 10.2/8.4, Event Studio 10.2/8.4, Cognos 10, Impromptu 7.x

Confidential

BI Project lead/SMR

Responsibilities:

• Interacting with business at the initial stages of requirements and acting as a liaison between business and On - site team.
• Help business in formulating initial requirements.
• Working as delivery manager for BI projects such as Cognos Migration/ Cognos Enterprise planning to TM1 migration, Qlikview-Concord Financial reporting project,
• End to end Implementation of TM1 Budget, TM1 estimate application
• End to end Implementation of Main trade TM1 Application
• Participate in demand supply meetings and help business in consolidating / prioritization of the requirements
• Balance workload of off-shore team with the priorities set by Business.
• Follow up with on-site coordinator for timely delivery of requirements.
• Escalate issues to business/management in timely manner.
• Analyze and Provide Support to SOR for infrastructure changes like Server changes, software updates etc.
• Off-shore Review meetings, and managing the work load between resources based on priorities
• Prepare Production Deployment check list, review with SOR, SBR and On-site coordinator to finalize the plan.
• Implementing new technologies such as Qlik view, TM1 and Analytics
• Providing technical support to the team in Modeling /reporting and to check if the requirements can be achieved within the scope of software.
• Planning for handling the Production Incidents raised within the given timelines based on urgency to avoid business impact
• Dealing with transition between consultants/vendors to bring them up to speed in taking up their responsibilities

Software: Windows 7 Enterprise, Qlik view 11, Cognos 10.2/8.4, Cognos Planning, Cognos TM1 10.x, Quest Toad, SQL, Oracle 11g

Confidential, Piscataway

BI Systems Architect

Responsibilities:

• Involved completely in gathering the requirements with the business.
• Help the business with requirement specifications and FRS documents.
• Analyzed the requirements and designed the Reports and the power cubes.
• Had worked with the Data warehouse team to have for the necessary changes in tables and stored procedures to support the project.
• Created Framework model to support the Cube built and reports.
• Created the cubes based on the model
• Created calculated Measures as per the requirements.
• Automated the cube built process.
• Published the cubes and reports to cognos connection.
• Created default cube views for the users to facilitate their analysis.
• Applied report level Security based on user groups.
• Providing the documentation of the developed source code.
• Providing Production Support to the Domestic and International Users.

Software: Windows XP, Cognos 8.4, Framework Manager 8.4, Report Studio 8.4, Analysis Studio 8.4, Query Studio 8.4, Cognos Connection 8.4, Event Studio 8.4, Quest Toad., SQL, PLSQL, Oracle 11g

Confidential, NYC

BI Systems Architect

Responsibilities:

• Involved completely in gathering the requirements.
• Designed the reports for Report studio based on the user requirements
• Creating the Framework Models and publishing them to Cognos connection.
• Creating a business layer in FM and publishing it to Cognos connection to use with Query studio and report studio
• Creating multidimensional reports in Analysis studio.
• Developing Templates for Query Studio and Report Studio.
• Working extensively with the SQL generated by Cognos to perform unit testing.
• Scheduling and monitoring reports.
• Worked extensively in applying conditional formatting for reports as well as prompt pages in Report Studio.
• Created reports with hidden prompts in prompts in prompt pages.
• Created reports using text, List, Cascading, Tree, Search and Select prompts in Report studio.
• Implemented model level security and has set security filters on query subjects.
• Created Dashboards for end users.
• Created Multiple Page reports with bookmarks in Report Studio.
• Deploying the reports developed in Test and Production environments.
• Creating complex prompt pages to provide wide selection criteria.
• Worked on providing optional columns for selection.
• Providing the documentation of the developed source code.
• Providing Production Support to the Domestic and International Users.

Software: Cognos 8.4, Framework Manager 8.4, Report Studio 8.4, Analysis Studio 8.4, Query Studio 8.4, Cognos Connection 8.4, Event Studio 8.4Quest Toad, SQL, Oracle 11g

Confidential, NJ

BI Systems Architect

Responsibilities:

• Involved with the business to gather the reporting requirements.
• Developed mockup reports in excel to get the signoff from business.
• Designed the reports for Report studio based on the user requirements
• Creating the Framework Models and publishing them to Cognos connection.
• Creating a business layer in FM and publishing it to Cognos connection to use with Query studio and report studio
• Creating multidimensional reports in Analysis studio.
• Developing Templates for Query Studio and Report Studio.
• Working extensively with the SQL generated by Cognos to perform unit testing.
• Scheduling and monitoring reports.
• Created complex reports using joins, Sets and also writing SQL for various queries in Report Studio.
• Implemented model level security and has set security filters on query subjects.
• Created Dashboards for end users.
• Created Multiple Page reports with bookmarks in Report Studio.
• Set security for the reports based on user class.
• Providing Support to users in creating reports in cognos 8 environments.
• Worked with the team and individually based on the assigned projects.
• Deploying the reports developed in Test and Production environments.
• Providing the documentation of the developed source code.
• Providing Production Support to the Domestic and International Users.

Software: Windows XP, Cognos 8.4, Framework Manager 8.4, Report Studio 8.4, Analysis Studio 8.4, Query Studio 8.4, Cognos Connection 8.4, Event Studio 8.4Quest Toad, SQL, Oracle 11g

Confidential, NJ

Sr.Cognos Developer/Architect

Responsibilities:

• Creating the Framework Models and publishing them to Cognos connection.
• Setting ROLAP models in Framework manager from RDBMS for dimensional analysis in Analysis Studio and in Report studio.
• Creating multidimensional reports in Analysis studio.
• Creating Reports from Stored Procedures in Report Studio.
• Developing Templates for Query Studio and Report Studio.
• Working extensively with the SQL generated by Cognos in order to upgrade the Reports and Cubes as per the changes in the database.
• Developing complex reports in report studio, which will replace the reports created in impromptu using hot files.
• Scheduling and monitoring reports.
• Created Multiple Page reports with bookmarks in Report Studio.
• Interacted with users and management to gather requirements and to provide a design for development.
• Helped the QA Team when required in testing the output of the reports.
• Actively Involved in migration of Cognos Impromptu reports from Cog 6.x/7.x to Cognos 8.x
• Created new Impromptu Reports with cascading prompts and publishing to IWR
• Creation of Catalogs and implementing the catalog level Security.
• Implementing the Security in Access Manager as well as to News boxes in Upfront.
• Creation of Power Cubes with multiple Dimensions and implementing the User Class security.
• Enabling Drill through facility from Cube to Cube and to reports.
• Publishing the cubes to Enterprise Server.
• Providing Production Support to the Domestic and International Users.

Software: Windows XP, Cognos 8.4, Framework Manager 8.4, Report Studio 8.4, Analysis Studio 8.4, Query Studio 8.4, Cognos Connection 8.4, Event Studio 8.4, Metric Studio 8.4, Cognos Go Office, Cognos Impromptu 7.x/6.x, Cognos Power Play 7.x, Configuration Manager7.x, Deployment Manager 7.x, Macros and Cognos Script Language, Rapid SQL.SQL, RDBMS: DB2 UDB, MS SQL Server