SUMMARY

• Around 8 Years of experience on Business Intelligence tools like IBM Cognos 10 BI, INFOR BI, ETL Tool and Relational Databases management systems like Oracle(SQL, PL/SQL), MS SQL SERVER.
• Extensively worked on Cognos 10 BI Framework Manager, Analysis Studio, Report Studio, Query Studio, Administration, Active Reports, Dashboards, Business Insight Advanced and Cognos Connection
• Built Framework Manager metadata models (Physical Layer, Business Layer, Packages) and developed complex Reports using Report Studio
• Develop and maintain reports, dashboards, KPIs and scorecards that track key operational metrics
• Collaborate with business and technology team members to understand reporting needs, ensuring that the BI solutions are an excellent fit
• Perform thorough testing and validation to ensure the accuracy of reports and transformations
• Collaborate in the planning, design, development, test, and deployment of new BI solutions
• Built Lists, Crosstab, Chart, Drill - Down, Drill-Through, Master detail, reports using Report Studio
• Worked on new developments, enhancements and maintenance of all older version cognos reports
• Had given cognos training, mentoring to other team members
• Involved in migration of Reports from impromptu to Cognos8.4
• Experience in upgradation of Cognos 8.5 Reports to Cognos 10.2.1
• Experience in developing reports using Tabular SQL method
• Experience on Converting Report Studio Reports to Active Reports
• Experience in Cognos Administration task like Installation and Configuration of different Cognos versions and data source creation, providing data level, object & Package level security in Framework Manager, Server Performance, User Management, Scheduling etc
• Involved in integrating Cognos BI to third party applications and developed customized security models using Cognos SDK.
• Achieved Certification in Cognos10 BI Reports
• Achieved Oracle Certification in SQL, PL/SQL
• Achieved certification on Infor BI Certified
• Successfully Completed Initial Learning Program from Genpact Nov 2007.
• Achieved Genpact internal certifications in DW/BI concepts
• Received Genpact's Excellence Outperform award in FY09 Q3

TECHNICAL SKILLS

Operating Systems: Windows 98,2000,XP,7

Languages: SQL, PL/SQL

Databases: Oracle 9i, Ms-Office, Oracle 10g, Oracle 11g, MS-SQL Server-2005

GUI: HTML,FRONT PAGE, Java Script

Web Related: HTML,DHTML, Java Script

Tools: & Utilities: Power Play, Power Play Transformer

Domain Knowledge: Health Care, Financial Services, Telecom and ERP-EAM

Certifications: Oracle Certified Associate 9i (OCA), Cognos 10 BI Report Author, Infor EAM

DW-BI tools: Cognos10.x Cognos8.x, Cognos Upgrade/Life Cycle Manager

ETL: Informatica(Exposure), Data Manager(Knowledge)

Reporting Tools: Cognos 10.x - Active reports, Business Insight Advanced, Report Studio, Analysis Studio, Event Studio, and Query Studio

PROFESSIONAL EXPERIENCE

Confidential, Greenville, SC

Software Engineer

Responsibilities:

• Knowledge on back end functionality of the Product
• Supported Global Customers of Infor EAM Product for Cognos Reports
• Fixed bugs/issues raised by customers
• Installed & Configured Cognos Server and Framework Manager for all versions(8.4.1,10.1,10.1.1,10.2,10.2.1,10.2.1 FP4) and integrated to the Product
• Deployed the Infor EAM Product along with the Cognos under local environment based on the requests
• Made Sure Cognos is up and running for both Oracle and SQL Server databases
• Created the Content Store, new datasources and publish the packages based on the incremental changes made to the Model & databases.
• Developed Cognos Reports for New Features like List of Kits, Expired Kits and Kit Template, Incident Request by Type, Status, Incident Request Status Summary by Type, Open Service Request of the product in Cognos10.1.1, Cognos 10.2.1 FP4 against Oracle and SQL Server databases
• Developed line, bar, pie chart report on Temperature Analysis for Regions, which contains Min, Max, and Avg Temperatures & Heating & Cooling Degree Days
• Upgraded existing Cognos8.4.1 to Cognos 10.1.1, Cognos 10.2, Cognos 10.2.1 FP4 Reports
• Added New layer called Functional in existing FM model by creating Data Source Query Subjects relevant to product Screens
• Designed new Report Template for the Product and used existing styles for headers, footers page body, lists header single row or multiple rows, table cells, summary Cells for Cognos Reports using Global Style Sheets Method
• Designed new Classes using Cascading Style Sheets
• Developed Active Reports and implemented drill through within the report using bookmarks, Master-Detail features for existing Cognos Reports
• Tested developed Reports by the peers against the Product
• Worked on report neutralization, performance tuning of the existing reports
• Converted Report studio Chart Reports to Active Reports included charts like Boxplot Chart, Gantt Chart etc and shared the .mht files to the users in Cognos 10.2
• Upgraded Reports, Framework Model from Cognos 10.1.1 to Cognos 10.2
• Changed the Reports as per the new template of Infor EAM 11 Version
• Successfully Completed Image Attachment support for the Product to display in Report output pages
• Upgraded Reports, Framework Model from Cognos 10.2 to Cognos 10.2.1, Cognos 10.2.1 FP4
• Developed Labor Productivity-HealthCare Report in Congos10.2.1

Confidential, Naperville, Illinois

Software Engineer

Responsibilities:

• Involved Evaluation, Design, Development and Deployment of end-user reports
• Generated SQL and PL/SQL scripts to create/drop database objects including: tables, views, primary keys, indexes, constraints, sequences, grants and synonyms
• Used Report Studio to develop various types of reports like list reports of customer and account information, cross-tab summary reports, charts/graphs to track the performance of geographical regions over various periods of time, and master-detail, drill-through reports
• Created prompts, calculations, conditions, filters and other metadata objects using Framework Manager
• Developed prompt pages and cascaded input prompts to filter reports on user specified criteria
• Understanding the business requirements and designing application to meet their needs.
• Creation of Query Calculations and Layout Calculations.
• Extensively used cascading prompts and Filters in Reports.
• Formatted the reports in order to improve the look and feel of the report
• Developed summary and detail reports for the Message labs Customers and Partners
• Co-coordinating the onshore and offshore resources to deliver the test deliverables in scheduled time duration.
• Organizing the weekly standup call with clients and offshore resources.
• Participate in Process Improvement efforts, Monthly and weekly status reporting.
• Reporting and tracking of defects till closure
• Documented the report design, Prepared the test scripts and end-user training on Query Studio for Ad hoc reporting
• Build dashboards using traditional andactivereportingtechniques
• Passing different parameters to the dashboard Reports and testing with respect to the requirement
• Implemented the changes made in Repositories at Dashboard level
• Resolved bugs raised by QA team with in the Project at UI level

Confidential

Software Engineer

Responsibilities:

• Performed Installation, Configuration and serveradministration, data management, security and content administration, activities management
• Created the repository, Perform backup and recovery, developing the user administration tuning the servers and deployment
• Added Users to the Group in Cognos Administration and assigned security at different level
• Involved with making changes in the reports generated as business requirements changed and carry out validation and verification of the reports.
• Performed data backups and moved packages to Production.
• Monitored data loads/process by verifying log files.
• Worked on the packages like Claims, Payments, and Loss etc
• Analyzed the Report specifications and Requirements to develop the Reports
• Developed Complex List Reports under Relational Packages
• Applied page break on data items, complex formatting like depicting the details of claimant per page and rendered the report in PDF
• Used inner & Outer Joins to the Queries to get relevant data to display in the report
• Developed Relative, from and thru prompts on Payment, Transactional, Reserve Change, Recovery dates in the Prompt page and filtered data accordingly.
• Rendered Parameter values to display in the Report Page header
• Used functions like cast timestamp, Maximum on Dates, Days between, Make timestamp, Add months, trim, substring etc.
• Analyzed Framework Manager Model to verify the joins between Query Subjects
• Tested the report output against the Sample data
• Updated the issue logs and attended day-to-day conversations with the client.
• Enhanced the performance of the reports by changing the properties of the Query such as Auto Group & Summarize, Processing, Execution Method and Use Parameter Info
• Working with various teams to collect project requirements and documented requirements for Cognos 10.1
• Write requirement specification for application development.
• Performed data loads, validation, build dimensions and attributes using Turbo Integrator Process.
• Developed cubes and performed data loads from text files.
• Performed Troubleshooting and debug logs to verify errors.
• Develop and maintains models and reports

Confidential

Software Engineer

Responsibilities:

• Conversion of Discoverer reports to Cognos Report Studio reports using Tabular SQL method
• Involved in the Enhancement of the Reports
• Validating the reports with the backend
• Designing Daily, Weekly Monthly reports with conditional color-coding.
• Created Prompts, calculations, Conditions & Filters.
• Developed Prompt pages and Conditional Variables
• Developed various standard reports like list reports, cross tab reports and Drill through reports using report studio.
• Developed reports using prompts
• Involved in unit testing.
• Prepared Technical Design Specifications for the Reports
• Performance tuning of the reports