SUMMARY

• Certified Cognos Report Author, / Cognos Administration/ with 16 plus years of IT experience and having excelled at major projects by implementing the Cognos software in areas such as the (US Government, Manufacturing, Insurance and Health care) involving different technological skills in Data Modeling Design, Development, Management and Administration.
• An Expertise in Cognos 7.x / 8.x/10.x Series and acquiring a sound knowledge in Data Modeling, Cognos environment setup, OLTP and OLAP, and problem solving of critical issues in the business environment. Acquire a strong understanding of Ralph Kimball methodology.
• Handled offshore clients.
• Cognos Environment Setup and the solution provider
• Cognos 10.x/ 8.4/8.3/8.0/7. x
• Design Reports as per Company’s Requirements.
• Cognos Environment Setup and the solution provider
• Environment upgrades, Model recovery /Backups and creating the BI environment Diagram.
• Cognos Administration - owing to the IT Standard
• Implementing New Technology and techniques in the BI Environment.
• Supporting Project Managers, Team Lead /developers and providing the solution to the critical problems with in the Cognos Environment.
• Cognos Security - Reports/Model /Data level Security
• Secured Framework Model, Catalogs and the reports as per keeping with pace of IT Standard.
• Supporting Database and the ETL team and resolve the critical issues.
• Optimization and the performance tuning with in the Cognos servers environment.
• Creating the System Design/Document for the BI environment
• Server level Tuning and the Capacity Management
• 24X7 Support to the users.
• Well Experienced in Cognos Reports/Cubes /Power Play Transformer.
• Oracle 10g /MS SQL server 2000/2008/Winodws 2008 R2 and 2000.X and UNIX

PROFESSIONAL EXPERIENCE

Confidential, Harrisburgh,PA

Responsibilities:

• Handled complex reports
• Designed and developed Actuarial Sub Ledger Cognos reports for various countries
• Handled Multiple Projects by providing solutions to the Business Users
• Designed Dashboard/Portal reports and implemented security for different country users.
• Cubes create using Frame work package.
• Created automated reports scheduled to reach users by Email.
• Handling Framework model and data level security implemented for various county users.
• System Administration for the multiple Cognos environment servers.
• Designed Framework Model and have created financial related reports
• Created security for the users
• System/Model /Report Design
• Managing Cognos Administrators.
• Production support to all European Countries
• Managed Multi server environment.
• Installed Cognos 10.2 for different environment.
• Providing technical solutions to the ETL /DB team and solving critical issues.
• Designed Cognos 10.2 BI Environment Setups which have been implemented In MetLife International.
• In charge of Development, UAT and the Production Server.
• Designed BI Environment Setups which have been implemented In MetLife International.
• Configured Cognos security for enterprise level
• Coordinate with international users
• Handling of Report /Model Deployment on a daily basis.

Environment: Cognos 8.3/8.4/10.2 Suite/ Meta Manager, Visio/ Excel, MS SQL, Windows XP, Windows 2003/2007/2008 R2 Servers.

Confidential

Sr.BI Consultant /Lead

Responsibilities:

• Prepared the Technical Documentation for the Developers.
• In charge of Production and UAT Servers
• Created security for the Users.
• Designed Framework Modeling for different applications
• Assess business user requirements and designed the Report Specifications.
• Maintained 15 Framework models in Confidential .
• Maintained dimensions, Fact and Created DMR in the Framework Manager.
• Prepared supporting documentation, such as metadata models, user guides, diagrams of entity relationships, business process and process flow
• Tested the quality data in the Test Environment using tode and moved the report to dev and Production environment.
• Maintained Daily Extract, Transform, staging DB (ETL Process)
• Maintained the entire FM model in VSS.
• Created different complex reports for Confidential .
• Designed Court Modules and integrated them with Confidential Reports.
• Tuned and Verified the SQL.
• Created different cubes at Confidential for their Management purposes.
• Created graph and comparison of the amount spending Reports
• Created Dashboard Reports.
• Wrote store procedures and generated reports using Framework manager.
• Designed Court modules and Confidential Service related Reports
• Maintained Cognos Environments in Confidential
• Created various cubes using IQDS and through the Framework models.
• Document created to minimize the risk and increasing the productivities for the management.
• Worked with budget analysis, estimated budget and generated Reports for them.
• Worked with Multiple skills like system side, admin, modeling, ETL process, cubes and reports
• Created Reports and integrated with .NET applications using Cognos SDK.
• Maintained Star Schema and avoided Snowflake Schema for better performance.
• SQL analysis done for OLAP and OLTP in Confidential
• Analyzed Data Quality for this environment
• Maintained Security, performance analysis and taking care of production issues
• Implemented new technology and techniques in the BI environment.
• Explained the business process to the Technical and non technical team.

Environment: Cognos 8.3/8.4/Suite/ Excel, PL SQL/Store procedures /Oracle 10g, Windows XP, windows 2003 Server

Confidential

BI Lead

Responsibilities:

• Generated Cognos Reports.
• Administrating (DW) OLAP Applications
• Maintenance of security
• Metadata modeling
• Collaborate with outside team members and management
• Manage process reboots, data source modifications, and perform upgrades as necessary
• Create and execute test plans/scripts to find errors and confirm reports/cubes meet specifications
• Supported technical issues
• Performance Tuning and applied Folder level Security to the package
• Developed report business document for Framework model and report specifications for each report
• Calculated time framework for framework model and Report development
• Act as primary technical contact to Cognos for support and enhancement issues