Summary:

• Around 8 years of information technology experience in the Design, Modeling, Development and Testing of database/Data warehouse applications.
• Involved in all phases of software development life cycle (Requirement gathering, Architecture, Design, Development, Implementation, Testing) for Business Intelligence solutions.
• Experience in understanding the Business requirements and designing Cognos applications.
• Expert in designing Business Models to meet the complex reporting requirements using, Cognos 8.x / 10.x (Report Studio, Query Studio, Analysis Studio, Cognos Connection).
• Worked on Cognos 8.x/ 10.x Framework Manager for creating Models for reporting.
• Strong understanding of Dimensional Modeling skills such as Facts, Dimensions, Star and Snowflake schemas.
• Experience in Data warehouse reporting with Cognos Impromptu 7.3, Power Play Transformer 7.3, and Cognos Power Play Enterprise Server 7.3.
• Good working experience in Dimensional modeling in Framework manager.
• Strong working experience in Oracle 9i/8i, SQL Server 2005/2008, PL/SQL.
• Expert in Publishing the Reports on Web and using Windows environment.
• Involved in creation of Excel, PDF, HTML, CSV outputs using Report Studio.
• Highly involved in the writing of Test Scripts for the testing of Cognos Reports.
• Have good understanding on Banking and Financial Services domain and Retail Business domain.
• Business goals oriented with strong commitment to deliver high quality solutions on time.
• Excellent written and communication skills, able to communicate effectively with all stakeholders, including customers, senior management, business partners, and technical staff.

Technical Skills:

Reporting Tools: Cognos 10.x (Report Studio, Query Studio, Business Insight and Business Insight advanced)
Cognos 8.x (Report Studio, Query Studio, Analysis Studio, Framework Manager, Cognos Connection, Go! Dashboard).
Cognos ReportNet 1.x (Report Studio, Query Studio, Framework Manager, Cognos Connection), Cognos Impromptu, PowerPlay Transformer, Cognos Data Manager, Business Objects 5.1.7, WebFocus 5.6.
ETL Tools: Informatica PowerCenter 8.6, Informatica PowerCenter 7, Informatica PowerCenter 6.2.1
Database Technologies: Oracle 8.x/9i,SQL Server 2003/2005, DB2, MS-Access.
Operating Systems: UNIX, Windows.
Languages: C, C++, SQL, PL/SQL, DOS, Shell scripting, Java Scripting.
Other: TWS Web Admin Scheduler 8.3, WebFocus Report Caster 7.6, Microsoft Office 2000 (Word, Excel, PowerPoint, Access), Toad 4.0, Lotus Notes 8.5

Professional Experience:

Confidential, Atlanta, GA Jun 12 - Till Date
Cognos Architect / Lead

The GPC (Genuine Parts Corporation) BI group currently receives data/information (store and DC-level) from multiple sources. Existing technology, tools, applications and systems are inadequate to manage/store this volume of data/information. The BI Group is looking to expand the set of data that it currently captures to encapsulate more of the enterprise\'s data; resulting in a centralized repository. The project involved using multiple products from the Cognos BI suite of products to be effectively used for implementing the reporting solution. Cognos Report studio reports were used to create complex reports which involved the use of multiple queries to attain a data view at different rolled up levels.

Responsibilities:

• Gather requirements , Analyze and Design templates.
• Develop new Cognos reports and Dashboards based on the requirement formulated by the business owners
• Developed and published models using Framework Manager on to Cognos Connection.
• Developed list, cross tab, nested cross tab, master-detail, chart and complex reports which involved multiple prompts, filters, calculations, multi - page, multi-query reports against multiple databases.
• Business data Analysis, design development of multidimensional OLAP Cubes and provided drill-through targets to another Cube, PowerPlay Portable reports.
• Involve in User interactive JAD sessions ( Joint Application Design sessions) to understand the exact requirement which serves their business need.
• Support the existing Reports and Cubes in Production
• Involve in performance tuning of existing Cognos reports.
• Suggest Report enhancements of the existing reports which would improve the readability of the reports to help the higher management for faster decision making.
• Involve in User Acceptance Testing of the created reporting objects
• Provide user training on the various reports created as part of the EDW Project.
• Work with the Client's infrastructure team to migrate the reports to production servers
• Actively involved in Quality assurance activities related to Project ensuring the delivery of quality process and adherence to client standards
• Install and Administer Cognos Environment and implement security.
• Work with ETL Architects/Developers to design database objects necessary for reporting needs.
• Create documentations of the reports and framework manager to be maintained as part of the project artifacts.

Environment: Cognos 10.1, Cognos 8.4 (Framework Manager, Report Studio, Query Studio, Cognos Connection), Oracle 9i, SQL Server 2005, Toad, Windows 7.

Confidential, Melville, NY Jun 11 - Jun 12
Cognos Lead

The project involves building Cognos reports for the Corporate management group (Project managers and Resource managers) as part of the GPD (Global Product Development) department to provide an at-a-glance view of the operational data. It also involves providing a Dashboard experience of the operational data and matrices for the executive management team. The reports provide snapshots of Resource Demographics, Vendor Demographics, Platform Demographics, Project Details and Utilization Details of resources.

Responsibilities:

• Create planning and estimation documents for the enhancements/projects and present it for approval to the project manager.
• Involved in the development of new Cognos reports, cubes and dashboards based on the requirements given by the corporate management group. Support the existing reports in Production
• Provide options on enhancement of the reports, which would make it easier for the higher management to look at the data in new and better way.
• Involved in performance tuning of some of the Cognos reports.
• Deploy the enhancements in staging servers for Acceptance Testing by the end users; and get sign-offs from necessary business partners
• Migrate the enhancements/project to production environment, adhering to FDC standards
• Work with the Client's infrastructure team to migrate the changes to production servers
• Actively involved in Quality assurance activities related to Project ensuring the delivery of quality process and adherence to standards
• Developed reports with filters, calculations, cascading prompts and conditions using Report Studio.
• Created complex master detailed reports with complex formatting.
• Experience in generating Burst Reports to user's folders.
• Involved in tuning of the reports to improve the performance.
• Created various Dashboards using Cognos Go! Dashboard.
• Implemented portal communication, sliders and check boxes with report items in the Cognos Dashboards.
• Involved in the formatting and conditional formatting of the reports.
• Established drill through reports and bookmarks based on end user needs.
• Ran reports in various outputs such as PDF, HTML, Excel and CSV.
• Populated all the dimensions and facts of the database with sample data.
• Scheduled the reports on daily and monthly basis to ensure successful execution of reports with model changes.

Environment: Cognos 10.1,Cognos 8.4 (Report Studio, Query Studio, Framework Manager, Go! Dashboard), Oracle 9i, Toad, Windows 7.

Confidential, Springfield, MA Apr 09 - May 11
Lead Developer

Confidential, has different applications that provide functionalities in the areas of Loan processing, Derivative processing, Trade management, Securities reference data, Investment accounting, Mortgage assets processing etc. Cognizant has undertaken to transition Babson's nine applications under the Asset management domain. One of these applications being Murex.

Responsibilities:

• Involved in learning domain level knowledge, which is critical to the project execution.
• Actively involved in the Development & Unit Test of Informatica PowerCenter mappings, Execution of Informatica scripts to migrate data to System testing environments and Validation of migrated data, Review the design and code of the Informatica Scripts to be migrated.
• Involved in the development of new Cognos reports based on the requirements given by the business partners, Debug issues in existing Cognos reports and provide fixes.
• Communicate with the internal business users to gather and document the requirements for Cognos reports in version 8.4 BI.
• Developed and Published Packages in Framework Manager.
• Created database layer, physical layer and presentation layer, defining appropriate relationship between query subjects.
• Maintained Content Manager for Cognos8.4.
• Created calculations and filters in the Framework manager model.
• Modified packages to generate reports for better analysis.
• Create Drill through and Master Detail reports using Conditional Formatting, Conditional Page layout, Sections, page Breaks.
• Scheduled bursting reports and distribution of Cognos 8 reports using portal administration.
• Created appropriate dimensions and manual levels in the Transformer model.
• Optimized the cube performance by partitioning and caching.
• Modified existing Cubes as per requirement.
• Created multiple cube groups using Transformer.

Environment: Cognos 8.3 (Cognos Connection, Report Studio, Framework Manager), Informatica Powercenter 8.6, Oracle 9i, SQL Server 2005, Windows XP.

Confidential, Cleveland, OH Apr 08 - Feb 09
Cognos Lead Developer

Confidential, is Confidential, The application is used for tracking all the fraudulent activities happening in any banking related transactions for KeyBank, like ATM Card fraud, Anti-Money Laundering, Check fraud, etc. The system captures the occurrence of any suspicious activity, which triggers an Alert and then a Case created is investigated by Keybank investigation unit and finally the system generates a report called SAR or Suspicious Activity Report (Cognos Report).

Responsibilities:

• Expertise in creating multiple drill-through, and master-detail reports.
• Building nested child tabular, tabular set, tabular SQL and tabular model Reports.
• Created variables for conditional formatting the report to highlight the deviation of data.
• Involved in support, design, validation, and testing of reports.
• Scheduling reports and ensures periodic tests are performed.
• Responsible for all the Reporting activities in the project which includes design, development, testing and support.
• Interacted with clients and worked on understanding the business requirements.
• Involved in Sprint planning, scope and execution
• Involved in trouble shooting the issues and bug fixes.
• Involved in the development of custom ETL program to update the Reporting datamart with the application transaction data from Filenet Content Engine(CE).
• Involved in the scheduling of ETL program to run daily to update the reporting datamart with the day to day transaction data.
• Frequent code reviews done with the Cognos Business Intelligence COE.
• Ensuring quality standards for the deliverables.
• Involved in rigorous testing for ensuring the Data Integrity.
• Involved in creation of documentation of the processes, bug fixes and reports.
• Involved in support of User Acceptance Testing (UAT)
• Reporting and Updating the status of the work to the Project Manager on daily/weekly basis.

Environment: Cognos 8.2 (Cognos Connection, Report Studio, Framework Manager), Oracle 9i, SQL Server 2005, Windows XP.

Confidential, Cleveland, OH Jan 08 - Mar 08
Developer, Onsite Co-ordinator

Confidential, has many applications using the Cognos 7 environment for building the cubes for several analysis, decision making and reporting purposes. In an effort to streamline and automate the process of cube build, there was a need to migrate it into Cognos 8. This effort also ensures that there will be a central repository instead of a distributed environment. There were 5 cubes which were successfully migrated in this process, which are DDA, TDA, CPM, and Media Marketing Actuals & Mains. Responsibilities: Responsible for migration of cubes Involved in Batch scripting and Process-automation. Involved in sprint planning and execution Interacted with clients and worked on understanding the business requirements Delegated jobs to offshore for a smooth transition. Involved in trouble shooting the issues Ensuring quality standards for the deliverables. Involved in support of User Acceptance Testing (UAT) for all the completed applications. Involved in the creation of documentation of the overall process. Reporting and Updating the status of the work to the Project Manager on weekly basis

Environment: Cognos 8 (Framework Manager, Cognos Connection, Analysis Studio, Cognos Powerplay Transformer), SQL Server, Batch Scripting, Mainframe, Windows

Confidential, Cleveland, OH Oct 05 - Dec 07
Cognos Developer

As part of consolidating the existing Reporting infrastructure running on various products from different BI vendors, Key intends to convert its Business Objects Applications to Cognos 8. The objective of this project is to migrate all the reports in the identified applications - FIR, CLA, IWA, PXE, SLE, DCG, SBU, KCO, GTM, CCR, AML, CIU, CTM, LDB, FIM, TIV, PWL, PRC, IAG, ERC, PNA, HRS, GLJ, PGN and OLM from Business Objects v 5. 1. 7 to Cognos v8
Responsibilities:

• Responsible for migration of reports.
• Involved in conversion and testing.
• Analyzing the functional requirement from BO reports for model and report generation.
• Built Model, created new joins, built filters, prompts, merge query subjects in to new query subject, determine hierarchy and dimension information in Framework Manager.
• Published packages from Framework Manager to Cognos connection for report creation in Report Studio and Query Studio.
• Created various list, grouped list, crosstab, and nested crosstab reports using ReportNet Report Studio and used Query Studio to create ad-hoc reports.
• Implemented filters, calculations, prompts, conditions, and created various reports using Report Studio.
• Developed calculated columns to focus on summarized data.
• Expertise with creating page breaks, drill-through, and master/detail reports.
• Scheduling and distributing reports in Cognos connection.
• Involved in support of User Acceptance Testing (UAT) for all the completed applications.
• Involved in generating load runner scripts
• Involved in support of Load Testing and UAT
• Reporting and Updating the status of the work to the Project Manager on daily basis

Environment: Cognos 8.x (Framework Manager, Report Studio, Query Studio, Cognos Connection), Business Objects 5.1.7, Oracle, DB2, Load Runner, Windows.

Confidential, CSO, Chennai, India Oct 04 - Sep 05
Project Developer

Confidential, originates from the need to migrate the existing survey-processing systems in the CSO (Central Statistics Organization, Ireland) from the VMS-based environment to a client/server environment. It is currently estimated that within the CSO, there are approximately 150 applications/systems written and maintained by central IT and a further 250 end-user applications written and maintained locally.

Responsibilities:

• Development & Unit Testing of Informatica PowerCenter mappings for the selected set of surveys to implement suggested changes in the mappings of Metadata tables.
• Execution of Informatica scripts to migrate data to System testing environments and Validation of migrated data.
• Involved in requirements gathering , Data Analysis and Assessment.
• Review the design and code of the Informatica Scripts to be migrated.
• Actively involved in Quality Assurance activities related to Project
• Data validation of migrated data in the UAT environment.
• Involved in trouble shooting and Debugging of issues.
• Involved in ensuring the quality process and adherence to standards
• Reporting and Updating the status of the project to the Project Manager on weekly basis

Environment: Informatica 7, Informatica 6.2.1, Sybase ASE 12.5, Sybase IQ 12, WebLogic 8.1, Windows.