Summary:

8 years of experience in the IT arena as a Data analyst and BI analyst.
6 Years of hands-on experience on Cognos BI/EP.
Have experience with BI, Planning, Database and web tools.
Have Extensive experience in creating DMRs using Cognos Framework Manager.
Have hands-on experience in creating Analysis Studio reports.
Experience in creating portal using Cognos connection
Expertise in creating complex reports using Cognos Report Studio.
Have hands on experience in maintaining/supporting the security using Cognos Access Manager.
Excellent background in full life cycle project planning and implementation
Has sound domain knowledge on Banking and Insurance Industries.
Have strong communication skills, well organized, and able to work independently as well as a team member.

Applications/Tools:

• Cognos BI
• Cognos Planning Analyst
• Cognos Planning Contributor
• Cognos Dashboards
• Cognos Report Studio
• Cognos Query Studio
• Cognos Analysis Studio
• Access Manager
• Cognos Portal
• Cognos Even Studio
• Microsoft SSIS
• Oracle PL/SQL
• SQL Server
• HTML
• DHTML
• XML

Client: Confidential, Washington DC Jan ’08 to current
Role: BI/EP Analyst
Cognos 8.4 upgrade:

• Attended kick off meetings and upgrade status meetings to go thru the tasks to achieve the upgrade with in the time line.
• Analyzed new functionalities of 8.4 version as part of upgrade project.
• Modified the existing reports in report studio to resolve the unsupported functions in 8.4
• Worked closely with QA team to test and verify the results.
• Worked with application administrators to migrate the modified/updated applications from DEV to QA to PROD.
• Post production support after upgrading to 8.4
• Designed and developed reports in 8.4 version as part of new enhancements.

Cognos BI 8.3 Development/support.

• Created various reports as per the business requirements.
• Developed Technical design documents as part of project development.
• Designed and developed several cross tab reports using Report Studio.
• Created several Framework Manager Packages that can be leveraged for the BI analysis.
• Created various cross tab reports based on the business requirements.
• Designed and developed portal structure with in the Cognos Connection.
• Designed custom home page in Cognos connection using Cognos portlets and pages.
• Updated the security in Cognos portal as per the business requirements.
• Created/Updated the user accounts as per the Access Requests.
• Created transformer models to create power cubes out of the models.
• Designed and developed DMR’s and Power cubes for the BI Analysis.
• Worked with QA team to test the reports/Power cubes as per the business requirements.
• Create new or make changes to existing Cognos 8.x analysis models and power cubes.
• Updated the Change Request system as part of the production support.
• Provided support to the system from a technical and security stand point.
• Resolved user access issues as part of production support.
• Updated portal security as per the requirements in Cognos Connection.
• Created several types of data sources to create reports and power cubes.
• Created D-Lists, D-cubes, D-Links, libraries in Cognos Analyst as per the business requirements.
• Designed and developed budget models in Cognos Contributor.
• Experience with Cognos 8.x security and Cognos 8.x Access Manager a plus.
• Be able to describe and accomplish requirements gathering, creating Cognos 8.x Framework Manager packages, create reports using Cognos 8.x Report Studio and Cognos 8.x Analysis Studio, create Cognos 8 cubes, validate data, and create test reports
• Define and create packages in Framework Manager
• Resolved the issues related to Purchase Order process.
• Created/updated elists and rights to maintain security in Cognos Planning models.
• Provided production support to the Planning and BI applications
• Gathering the Report requirements.
• Worked with DBA’s to resolve issues related to database.
• Designed and Developed TGS Scorecard applications using Metrics Studio.
• Gather user requirements and turn them into system specifications/requirements for coding
• Created/updated service requests in the Service requests system.
• Have strong analytic, problem-solving, troubleshooting, and collaborative skills.
• Worked with Cognos support team to resolve issues.
• Coordinated with EDW team to resolve data related issues in the reports.
• Designed and developed complex Framework Manager Packages to implement departmental security in the packages that can leverage in the reports.
• Working closely with EDW team to understand the data elements and data structure in EDW environment.

EDW:

• Involved in designing the roadmap to implement DW and BI environment to cater the needs of IMF budgeting and Finance departments.
• Designed the DW and BI environments as per the IMF standards from the data and security perspective.
• Gathering the reporting requirements from Business users, analyze the requirements and develop the technical specs for EDW jobs.
• Working closely with business users, source IT teams to discuss the data items that need to bought over to EDW.
• Involved in developing data models for FACTS, TRS and TIMS applications.
• Updated the access, resolved production issues in TGS Scorecard applications using Metrics Studio.
• Developed various architecture blue prints for different subject areas including data sources, data flow, data cleansing, data validation, data loads etc.
• Designed and developed multi-dimensional data models.
• Designed and developed data marts as per the business requirements including star schemas, snow flake modeling, fact and dimensional modeling.
• Working with Ascential Data stage team to develop new ETL jobs and modify the existing one.
• Working with EDW team to develop the batch files using TIDAL. This will help to run all the Data stage jobs, Kalido jobs and Cognos jobs based on job dependency rather than time dependency.
• Identified, Tested and resolved performance issues in the data base environment and suggested best practices to avoid performance issues.
• Extensively worked on data validation and data cleansing.
• Created data mapping documents for the implementation of Travel and Budgeting applications in EDW system.
• Design and development of supporting oracle or multi-dimensional cube databases
• Designed and developed several Data models in the EDW environment to cater the needs of various BI reporting requirements.
• Designed and developed data marts as per the business requirements.

Environment: Cognos BI (Report Studio, Analysis Studio, Query Studio, Event Studio and Metrics Studio) 8.4/8.3/8.2, Cognos EP 8.3 Contributor,

Analyst, Access Manager, EDW, Data Stage , DataOracle 10g,Windows XP (client), Windows 2003 server and UNIX.
Client: Confidential, NY. Dec ’04 to Nov ‘07
Role: Cognos BI Analyst

• As part of Cognos implementation, gathered report requirements from business users and developed Technical design documents.
• Designed and developed Report studio reports and Analysis studio reports as per the requirements.
• Heavily worked on SQL and PL/SQL to troubleshoot the data discrepancy.
• Designed and developed Framework manager packages.
• Expert experience with Cognos 8 reporting from metadata to report development.
• Created a process in Cognos to burst the reports and rename is accordingly and then place it in the appropriate folders on the server, where the security has been incorporated. This will cater the needs of different departments to access the reports from their respective folders
• Updated security settings in Cognos connection depending upon the access request.
• Customized Cognos connection as per the requirements.
• Designed and developed new portal objects in Cognos connection.
• Created Power cubes as part of Risk Management application to analyze the various risks associated to the banking products.
• Created reports for banking products, Risk Management products and customer segmentation models.
• Designed Framework manager models to incorporate security to the data at region level and department level.
• Assisted users in creating queries using query studio.
• Created PL/SQL store procedures and used them in Framework Manager to generate reports using Report Studio.
• Logged the change requests in Change Management system and updated the tickets as per the progress.
• Participates in all aspects of project development including; analysis, development, testing, documentation and deployment.
• Heavily worked on Access manager to updated/create users and user classes to maintain the security in Cognos environment.
• Developed DMRs using Framework Manager Packages as per the business requirements.
• Resolved various performance issues related to reports and DMR’s in Cognos connection.

Environment: Cognos BI (Report Studio, Analysis Studio, Query Studio, Event Studio and Metrics Studio) 8.1, Access Manager, Oracle 9i/ Oracle 10g,Windows XP (client), Windows 2003 server and UNIX.

Confidential, AP, India. Mar ’02 to Nov ’04
Role: IT developer
Insurance portal:

• As part of the team member, involved in development of Insurance portal product developed by ICBM.
• Involved in gathering and analyzing the requirements of the client.
• Interacted with client as part of design, development and deployment of product.
• Created web pages using HTML, DHTML and JavaScript.
• Designed and developed reports using Oracle Forms.
• Designed and developed the home page, reference page, claims pages, products information pages etc.
• Developed the role based home page security, where the homepage will display based on the user profile.
• Created the relevant tables to store the insurance information.
• Performed the updates based on the requirements.

Product development for Hospital Management:

• Involved in design and development of Hospital Management product that was developed by ICBM.
• Analyzed the client requirements and developed the product design documents.
• Modified the product based on the client requirements.
• Designed and developed reports using Oracle Forms.
• Tested the applications based on the test scenarios.
• Created PL/SQL procedures to perform the business logic.
• Designed and developed the table structures as part of application design.
• Troubleshooting Database and application Problems.
• Extensively used SQL for creation of various database objects like tables, views and sequences.
• Involved in fine tuning the applications to resolve the performance issues.
• Interacted with users to resolve post production issues.
• Involved in post production support.

Environment: Oracle 8i, HTML, DHTML, XML, JavaScript, Windows XP (client) and Windows 2000 server.

Education:
PGDCA (Post Graduate Diploma in Computer Applications)