SUMMARY:

• Over 15 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 (7.x/6.x), Cognos TM1 10.x, Qlik View and ETL tools (Datastage, Informatica) in Data warehouse.
• Extensive experience the BI intelligence portfolio as portfolio/Tech lead /systems Architect and senior developer
• 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.0 Platform.
• Responsible for leading Migration of Enterprise Planning applications (Budget and Estimate) from Cognos planning to Cognos TM1
• Extensive experience in using Cognos Framework Manager 10.2/ 8.4, Report Studio, Query Studio, Analysis Studio, Cognos Workspace, Cognos Workspace Advanced, Cognos Transformer 8.x, Event Studio, Metric Studio, Cognos Connection, Cognos TM1, Cognos Impromptu 7.x/6.x, Qlik view, Cognos Enterprise planning, Cognos TM1 and Qlikview
• 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 10.x/8.x/7.x/6.x.
• Extensive knowledge in various Internet related platforms with specialization in Cognos 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, SQL Server 7.0/2000, DB2 UDB, MS Access

O/S: Solaris, UNIX, WINDOWS, LINUX

Software: Cognos 10.x/11, Cognos Framework Manager 10.2/8.4/ 8.x, Report Studio 10.2/8.4/8.x, Query Studio 8.4/8.x, Analysis Studio 8.4/8.x, Event Studio 8.4/8.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, Cognos Power Play 7.x/6.x, IWR 7.x/6.x, ETL Informatica, Cognos Contributor, Cognos TM1, Qlik View

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

Others: IIS, HTML, DHTML, ASP, Netscape Directory Server

PROFESSIONAL EXPERIENCE

Confidential

BI Systems Architect

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.
• Maintaining the security along with Cognos portal administration.
• Managing the report developers and supporting the development team with model related changes

Special 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 Developer/ Architect

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, 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.
• Catching up with new technologies used to support the portfolio (TM1,Qlik view, 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
• Operating System: Windows 7 Enterprise
• Special 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, Cognos Planning, Cognos TM1

Confidential, Piscataway

BI Developer/ 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.
• Built the report studio reports with parameters.
• Implemented the model level security for the users
• Built in the security in the Cube.
• 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.
• Operating System: Windows XP

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.
• Created complex reports using joins, Sets and also writing SQL for various queries in Report Studio.
• Created drill down 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.
• 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.
• 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.

Confidential, NJ

BI Developer

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.
• Created drill down reports.
• Created complex Crosstab reports based on user requirement.
• Trained end users on Query 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.

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.
• Converting Cognos impromptu reports to Cognos 8.x
• Created Reports in Report Studio based on end user reports in Impromptu.
• Created Top 10, Top5 reports based on Credit Quality for Domestic as well as International users in Report Studio and in Impromptu.
• Created complex reports using joins, Sets and also writing SQL for various queries in Report Studio
• Created complex Crosstab reports based on user requirement.
• 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 to conditionally display columns based on prompt values selected by users in Report Studio
• Created reports using text, List, Cascading, Tree, Search and Select prompts in Report studio.
• 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 environment.
• Interacted with users and management to gather requirements and to provide a design for development.
• Worked with the team and individually based on the assigned projects.
• 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.
• Customization of upfront and setting the News Item properties.
• 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.
• 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.

Confidential. NJ

Sr Cognos Developer

Responsibilities:

• Upgrading all the existing source code as per the database changes from people soft 8.0 to people soft 8.8
• Working extensively with the SQL generated by Cognos in order to upgrade the Reports and Cubes as per the Database Changes as there was no Documentation.
• Providing Production Support to the Domestic and International Users by monitoring the Cases logged in Vantive and troubleshooting the issues reported.
• Creation of agents for Notice Cast and providing adhoc Reporting using CQ.
• Developing Complex Visualizations and publishing to web using Visualizer for web.
• Documented TIS and LAAP from the start, as there was no documentation maintained earlier and checked in to Documentum.
• Checking the Source Code to clear case each time the changes are made to the source code.
• Moving the Projects from Development to test and test to production. Trouble shooting the issues raised doing so.
• Trouble shooting the issues in IWR and PPES especially the security issues which are reported mostly.
• Creation of Stored procedures and views to facilitate creation of reports.
• Constantly used Configuration and Deployment managers to Manage and Maintain Cognos Environment.

Confidential, TX

Cognos Developer

Responsibilities:

• Creation of Master Catalog, Management and updating of Master Catalog.
• Creating user classes and Publishing IWR reports, Power play Cubes & Reports and Visualizer for web Reports to Upfront Portal.
• Creating and updating users in Access Manager and Assigning Privileges and Permissions.
• Creating Multi-Dimensional cubes and publishing to PPES.
• Generated Macros for updating and scheduling the Power Play Cubes.
• Developing Complex Visualizations and publishing to web using Visualizer for web.
• Constantly used Configuration and Deployment managers to Manage and maintain cognos Environment.
• Using Server administration for publishing IWR, Power Play & Visualizer Reports and cubes to upfront News Boxes.
• Creation of agents for Notice Cast, which will transpire when the event fires as a result the user, will be notified by his wireless or Email.
• Providing adhoc Reporting using CQ.
• Interacting with Client and users for gathering the Requirements.
• Updating from cognos 7.0 to 7.1