Professional Summary

• 9 years of IT experience with sound knowledge and experience in different phases of software development life cycle (SDLC) including requirement, analysis, design, development, testing, deployment and support.
• 7+ years of experience in building Business Intelligence applications using Cognos BI tools
• Extensive experience with the Cognos series 8 suite (Framework Manager, Cognos Connection, Report Studio, Query Studio, Analysis Studio, Event Studio, Transformer, PowerPlay).
• Strong experience in interacting with and gathering the design requirements from the end users in order to develop the reports.
• Extensive experience in modeling metadata in Framework Manager and developing complex enterprise reports, dashboards, ad hoc reports using Report Studio and Query Studio respectively and OLAP Cubes development using Powerplay Transformer.
• Strong experience in Upgrade of Cognos Report Net and Cognos 8 Reports, Packages and Data Source Connections.
• Strong programming and debugging skills on SQL, PL/SQL and Experienced in Database Optimization and SQL tuning.
• Excellent knowledge of Business Intelligence principles, dimensional and relational data modeling, relational database structures and SQL queries.
• Strong troubleshooting and production Support skills to lodge, maintain and resolve the trouble tickets raised by the end users.
• Mentored and trained users for the successful execution of the project.
• Highly motivated, ability to multi-task, work independently and in a team environment with excellent communication skills.

Educational Qualification

Masters in Computer Science
Bachelors in Computer Science

Professional Experience

Confidential,Wilmington, DE Oct’10 – Till Date
Sr. Cognos Developer

ALICO / MetLife is one of the world’s largest global life insurance companies, combining industry leading strength and local know how to better serve 90 million customers worldwide. The Cognos application developed for project ‘Atlas-Prophet valuation system’ which spans reporting for over 40 countries is the most prestigious data-warehousing implementations for the company.

Responsibilities:

• Extensively involved in requirement gathering and data warehouse designing.
• Interacted with end users to understand data domains, values and other dimensions of data needed to support BI solutions.
• Modeled metadata in Framework Manager to support the complex reporting needs
• Designed developed and implemented Financial/Acturial Valuation reports for project ‘Atlas-Prophet Valuation System’
• Created complex regression reports spanning multiple databases to test the different runs of the Prophet models
• Created multi query reports with unions. Intersections and joins at the report level.
• Created multi page and multi prompt page reports using render variables, conditional formatting and cascading prompts
• Created Month to date, Quarter to date and Year to date reports which compare Historical Actuals with Projections.
• Created reports based on Stored Procedures
• Created Dashboard reports, region wise, country wise
• Updated the Framework manager model and reports as per the changing database structure.
• Acted as a primary technical contact for support and enhancement issues
• Supported Power Users during quarter ends with Ad-Hoc requests and on demand query generation
• Extensively involved in Performance Tuning of Reports to reduce report execution time
• Scheduled Quarterly and Monthly Reports and saved them for a period of one year from the time they are created.
• Coordinated with data warehouse developers, ETL team for creating objects required for report development
• Created and executed test cases/scripts to test the reports
• Deployed the reports and packages from Development to UAT and to Production environments.
• Created Design Documents, User Guides
• Provided Demos and Trainings to the end users

Environment: Cognos 10.1.1/8.4/8.3, Framework Manager , Cognos Connection, Cognos Administration, Report Studio, Query Studio, BSP Meta Manager, SQL Server 2008/2005, T-SQL, Windows XP, MS Office.

Confidential,MD Mar’10 – Oct’10
Sr. Cognos BI Developer

Maricom Systems is into providing expert services and solutions that allow clients to achieve maximum value and efficiency from their systems and most importantly, the information contained within. The scope of this project is to provide the key decision makers and business users appropriate reports and analysis in order to aid them in handling the growth of the company by making proper decision.

Responsibilities:

• Involved in planning and implementation of Cognos8 BI Suite.
• Extensively involved in requirement gathering with end users.
• Created Requirements, converted them into technical specifications and conducted walkthroughs
• Imported metadata from legacy systems and ERwin data model via CA ERwin MIMB bridge into the Cognos Framework Manager.
• Modeled metadata in Framework Manager by creating required joins, aliases and shortcuts to query subjects as needed.
• Created new relationships and redesigned existing query items in the model to meet the revised reporting requirements in Framework Manager.
• Created and published packages from Cognos 8 BI Modeling.
• Developed multiple complex reports involving Drill-Troughs, Render variables, Conditional Formatting, Prompts, Charts, Filters and complex calculations
• Generated reports based on advanced conditional rendering/formatting to enable hide and show functionality based on prompts.
• Involved in enhancing and maintaining the existing reports.
• Created a History table at the database level and developed Stored Procedure and Trigger to populate data into History table
• Using Transformer Created Power Cubes and cumulative reports and graphs with dril downs in Powerplay
• Upgraded Reportnet Reports, Packages and Data Source Connections into Cognos 8 BI.
• Created Documentation and Training material for the end users

Environment: Cognos 8.4.1/8.4/8.2/ReportNet, Cognos Connection, Cognos Administration, Framework Manager , Report Studio, Query Studio, Transformer, PowerPlay, Analysis Studio, Upgrade Manager, Oracle 10g, SQL, PL/SQL, TOAD 9.6, CA ERwin Data Modeler 7.3, Windows XP, MS Office

Confidential,MD Sep’09 – Mar’10
Sr. Cognos BI Developer

ViPS, a General Dynamics Information Technology Company, is a leading provider of healthcare data management, analytics, decision support, process automation and related information technology solutions that help governmental and commercial healthcare payers improve patient outcomes, enhance market position and reduce costs. The scope of this project was to upgrade, create and enhance reports to aid end users in maintaining part D Medicare and Medicaid data.

Responsibilities:

• Involved in gathering requirements from business users and created new reports and did enhancements to the existing reports.
• Involved in upgrade of Cognos version 8.2 to version 8.4. Upgraded Reports, Packages and Data Source Connections into Cognos 8.4 BI.
• Unit tested Reports and Packages using Upgrade Manager. Involved in Fixing and enhancing reports after upgradation.
• Collected stats on reports to check the performance before and after Cognos 8.4 upgrade
• Involved in performance tuning of reports
• Created Complex Reports in Cognos 8BI Report Studio using Tabular SQL. Checked several SQL possibilities and used best performing SQL
• Customized Cognos connection to suit users needs by creating new pages in Cognos connection and used portlets to create several different views in a page
• Generated Simple List, Cross tab and Sub reports and customized them by the addition of filters, calculations, prompts and conditions as required by the end users
• Created Prompt pages which contained Value Prompt, Select and search prompt, cascading prompts.
• Developed multiple page reports with page-breaks based on the first page of the report usingMaster-detail relationship.
• Involved in Harmonizing reports in accordance with the database changes
• Involved in implementing security, created users, groups and roles
• Created Scheduled Jobs by scheduling multiple reports in a job.
• Deployed Packages and Reports from DEV Environment to TST and PRD Environments.

Environment: Cognos 8.4/8.2 BI Suite, Cognos Connection, Cognos Administration, Report Studio, Query Studio, Framework Manager, Upgrade Manager, Teradata V2R6.2/12, DB2, SQL, TOAD 9.6, Windows XP, MS Office.

Confidential,CT Jan’08 – Aug’09
Sr. Cognos Report Developer

UBS is an international provider of financial services and investment resources that help individuals and institutions meet their financial objectives. As a member of BI Team, responsibilities were to work in production environment to Maintain, Optimize and Develop reports in Cognos 8.3 and metadata model in Framework Manager..

Responsibilities:

• Imported Metadata into Framework Manager, set properties, created Joins and organized the metadata for standard and Ad-hoc reporting.
• Developed Standard List Reports, Cross-tab Reports, Charts and Drill through Reports using Report Studio.
• Created reports containing variables, cascading prompts and created multiple prompt pages to support the complex user requirements.
• Scheduled and Distributed Reports through Schedule Management in Cognos Connection.
• Worked with Master-Detail reports, complex Calculations, Formatting, Conditional Formatting and Multi-query reports.
• Used the Transformer models to create Power cubes and generated PowerPlay reports.
• Scheduled Reports on weekly basis.
• Created Analysis Studio Reports using Power play cubes
• Developed Combine Filters, User-Defined Filters and Custom Ranking using Analysis Studio.
• Created several detailed Dashboard for the business users to make strategic decisions.

Environment: Cognos Report Net 1.1/ 8.3, Report Studio, Query Studio, Analysis Studio, Event Studio, PowerPlay, Transformer, Cognos Connection, Framework Manager, SQL Server 2000, Toad, Oracle9i, MS Word, Excel, Access, Windows 2003.

Confidential,CT Aug’05 – Dec’07 Cognos Developer

Purdue Pharma L.P, a privately held pharmaceutical company founded by physicians, is focused on the needs of patients. The objective of this project was to support Business Executives to take quick decisions. Generated and analyzed reports based on buyers, representatives and marketing specialists that focus on market performance in different locations.

Responsibilities:

• Worked on Cognos Framework Manager to import data from heterogeneous data sources and to create metadata models and packages.
• Enhanced existing reports and created new list, crosstab, charts, maps and repeaters in Report Studio.
• Developed reports with filters, prompts, exceptional highlighting, static choices, summary and detail reports
• Helped the users in creating ad hoc reports using Query Studio.
• Created Report Templates adhering to corporate standards.
• Configured Cognos to perform Report Bursting.

Created and scheduled monthly reports for the management

• Optimized the performance and performed the user acceptance testing on the reports.
• Developed PL/SQL procedures, triggers and functions.

Environment: Cognos 8.1 (Framework Manager, Report Studio, Query Studio), Cognos ReportNet 1.1 MR3, Cognos 7.4, Windows XP, Oracle 9i, SQL, Windows, TOAD

Confidential,India June’03 – Jul’05
VB Developer

Designed and developed an inventory management system using VB, Crystal Reports & Cognos Impromptu..

Responsibilities:

• Interacting with customer to understand the requirements well and preparing the technical specifications
• Developed reports to find the amount of stock available for production at any point of time, what are the minimum and maximum stock levels and how to maintain them.
• Developed daily, weekly, monthly, quarterly and yearly reports for inventory.
• Developed reports which tell how many cylinders are used for a particular job and which ones are being used.
• Developed reports for maintaining stock levels of different raw materials and also lists of cylinder manufacturers.
• Developed test scripts and tested the reports for validity.
• Resolved programming and technical issues.
• Involved in testing and maintenance of the code.

Environment: VB 6.0, Crystal Reports, Oracle, Cognos Impromptu 7.1, Windows, MS Office tools.