Career objective

To pursue a challenging and rewarding career in an esteemed organization and apply my skills and knowledge for the betterment of the company

Professional summary

• Over 7 years of IT experience in Design, Development, Testing, Administration and Implementation of Data warehousing applications for analysis and reports generation solutions using BI tools like Cognos 8.x series
• Expert in designing Business Models to meet the complex reporting requirements using, Cognos 10,Cognos 8.x Query Studio, Report Studio, Analysis Studio, Cognos Connection
• Worked on new feature in Cognos 10 like Model Design Accelerator MDA to create Models in less time and also used Dynamic Query Mode DQM for improved query performance.
• Extensively worked on developing various kinds of reports using Cognos 8 Report Studio, Analysis Studio, Query Studio and developed Dashboards using reports from report studio and Cubes
• Strong background in building relational and dimensionally modeled relational metadata models using Framework Manager
• Extensively worked on Framework Manager, Query Studio, and Report Studio for model design, ad-hoc reporting and advanced report authoring
• Extensively worked in creating complex reports using Report studio Master-detail reports, List reports, Cross-tab reports, Drill through reports, Summary reports and burst reports
• In-Depth knowledge of Cognos Migration and Deployment from one system to other.
• Exposure to Cognos SDK
• Expertise in querying and loading data on Oracle database systems. Excellent skill in building SQL queries using various joins and sub-queries on various databases, tuned for better performance and efficiency
• Extensively worked on Brio Reporting Tool
• Experience in using MS Access, Excel, SQL Server, and Oracle
• Worked on the Data Modeling tool Power Designer
• Hands on experience on DataStage, Informatica, Business Objects XI, QlikView
• Involved in gathering of business requirements, documenting them technically for all phases of Software Development Life Cycle. Sound knowledge on different phases of software development life cycle analysis, design, development, test for Business Intelligence solutions
• Exposure to client interaction and user-requirement analysis.
• Good analytical and logical skills. Experience in problem solving and delivering practical solutions
• Good communication, inter-personnel skills and good team player
• Proactive, Dedicated, and enjoy learning new technologies and tools
• Mentored and trained users for the successful execution of the project
• Experience of working in 2 real-time projects at a time.

• BI Tools : Cognos 10 BI, Cognos 8 BI, Cognos ReportNet 1.1
• Brio Reporting
• Business Objects XI
• OLAP Tools : QlikView
• ETL Tools : Informatica PowerCenter,DataStage
• Operating Systems : Windows 95/98/2000, Windows XP Professional, Windows NT, UNIX
• Languages : C, C , SQL, PL/SQL, HTML, JavaScript
• Databases : Oracle 8i/9i/10g/11g, SQL Server 2000/05, MS-Access
• Database Tools : TOAD, SQL Developer
• Data Modeling Tools: MS Visio, Erwin, PowerDesigner
• Other : Microsoft Office 2003 Word, Excel, PowerPoint, Project

WORK EXPERIENCE

Confidential

Role :Cognos BI Team Lead/Cognos Modeler

Confidential

Description : Totality is the mechanism used to gather Healthcare Professional/Provider HCP data, connect to Ariba GXRS and produce essential mandatory reports to the Federal Government. It is a centralized system used across the Pharmaceutical MD D Sectors that allows for review approval of projects that have a value exchange with HCPs, Customers and Medical Institutions. It provides a consistent process and compliance database for all Johnson Johnson operating companies.

Responsibilities

• Worked on Cognos 8.4,Cognos 10.1 with Framework Manager, Report Studio, Analysis Studio and Transformer.
• Translated reporting requirements and the business data model and to convert into a Framework Manager Model to meet reporting requirements.
• Actively involved in daily status meetings and meetings with Business for gathering requirements.
• Actively involved with the Admin team for migration from Cognos 8.4 to 10.1.
• Worked on Model Design Accelerator to reduce the overall time to build a model.
• Used Dynamic Query Mode to improve query performance and functionality.
• Designed the Logical/Physical/Database model that conforms to Star Schema concepts, different views Import, Business, External as per Business requirement.
• Created Database layer, Physical layer and Presentation layer, defining appropriate relationships between query subjects.
• Developed and Published Packages in Framework Manager - Connecting and testing the data source, created database layer, physical layer and presentation layer, defining appropriate relationship between query subjects.
• Worked on Report studio creating various reports ranging from Simple to Complex Reports.
• Created Active Reports and used Business Insights Advanced to create reports.
• Worked on security on Cognos 10.1 on Active Directory.
• Modifying the existing reports based upon the change requested by the user. Involved in resolving Performance issues with various reports.
• Developed List Reports, Bar Charts, Drill Through Reports, Master Detail Reports and Multilingual Reports using Report Studio and Query Studio.
• Designed Reports using most of the Report studio features Conditional Formatting, Conditional Page layout, Sections, Page Breaks, Master-detail, Drill Through, Drill Down, Drill Up, Expand-Collapse .
• Deployed the reports and package from Development to Testing and then Testing to Production environments.
• Developed Executive Dashboard reports using Cognos Report Studio.
• Unit testing, Integration testing and System testing of the reports in Development, Testing and Production environments.
• Worked on TOAD with ORACLE as a database
• Prepared User Documentation to train users and to explain functionality of each report.

Environment: Cognos 10, Cognos 8.4, Framework Manager, Cognos Connection, Report Studio, Query Studio, Analysis Studio, ORACLE 10g , Windows 2000

Confidential

Role :Cognos BI Team Lead/Cognos Modeler

Description : The ERP project will consolidate multiple ERP systems down to four Regional and one Bioscience manufacturing JDE instances. As a result of the Global ERP initiative, the regional reporting systems will have to be modified to source the data from the new GRDW. The consolidated ERP has also changed the data rules which will have an impact on the downstream application and reporting.

Responsibilities

• Worked at Client location Baxter, RoundLake, IL and Responsible for all the BI Reporting deliverables
• Involved in meetings with the Business users and Project Department. Interact with the client to understand the business requirements and to finalize the business requirements for the Cognos and Brio Reporting
• Involved in Requirement Gathering from Business Users and Developed Technical Documentations for the Business and IT Team.
• Translated reporting requirements and the business data model and to convert into a Framework Manager Model to meet reporting requirements.
• Created Model Query subjects, Data Source Query subjects, Stored Procedure Query subjects as per the business requirements in the Framework Manager.
• Designing the Logical model that conforms to star schema concepts, different views Import, Business, External as per Business requirement.
• Developed and Published Packages in Framework Manager - Connecting and testing the data source, created Database layer, Physical layer and Presentation layer, defining appropriate relationships between query subjects.
• Co-ordinate with the offshore team and help them understand the business requirements
• Prepare functional design specifications. Prepare test strategy plan for unit regression testing
• Involved in providing the security at the package level, report level for users accessing different projects.
• Create complex dashboards, simple list reports, Crosstab reports and various Drill-through reports according to the requirements.
• Create various reports which have multiple prompts, pages, filters, various HTML codes and conditional variables.
• Analyzed the DMR model and resolved Ambiguous relationships in model DMR .
• Analyzing the behavior of Slowly Changing Dimensions in the development of reports
• Involved in the development/remediation of various reports in Brio
• Involved in the User Acceptance testing of the Brio Reports
• Involved in the Data Model design through Power Designer

Environment: Cognos 8.4, Framework Manager, Cognos Connection, Cognos Administration, Report Studio, Query Studio, Analysis Studio, Brio Intelligence Explorer 6.6, Power Designer, ORACLE 10g , Windows 2000

Confidential

Role : Datastage Designer

Description : The objective of this project is to replace the legacy applications used by the Dealer

Products Services, SM P Canada and Car Care Plan business units for the administration of vehicle service contracts and F I related products

Responsibilities

• Analyzing and understanding Source System and Requirements Document.
• Understanding of data models and Warehouse Architecture
• Developed Ascential ETL Jobs to load Operational data from Manual files and CSV files to Oracle tables.
• Used stages like Aggregator, Sort, Transformer, Sequential File,Lookup,Join,etc,

Environment: Data Stage 7.5, ORACLE 10g , Windows 2000

Confidential

Role : Cognos BI Developer

Confidential

Description : Support and Enhancement of existing Ap2ple is an initiative for better visibility in Johnson Johnson's procure-to-pay process for both direct purchase SAP application and indirect purchase ARIBA application in EMEA region. Ap2ple delivers information like utility payments, procuring fixed assets, purchase of standard goods and services. Ap2ple broadly suffices following purposes: Procurement Process, Payables Process, Exceptions, Compliance, Validation sourced from Ariba or SAP P2P Process Management.

Responsibilities

• Development/Change of IBM Cognos 8.4 based reporting solution for any new and existing reports
• Test case Preparation and Report Testing
• Root Cause Analysis Erroneous data identification in ARIBA VIEWS, ARIBA STAGING, SAP STAGING, CS STAGING, AP2PLE
• VIEWS databases and informing respective business owners
• Ensure smooth report deliverables in critical quarter end period
• Ensure proper process followed for SOX critical and non-SOX reports
• Raising request to ITS-SUPPORT for DEV -> QA QA -> PROD movement with predefined template and co-ordination.
• Confirmation to Application Managers for QA PROD migration with evidence
• Managing Mapping documents for every changes in the reports
• Maintenance of Report Versions in Tortoise SVN configuration management tool
• Ensure valid process and documentation availability in eRoom portal, Tortoise SVN applications
• Developed complex period to date reports with various calculations and sub-queries.
• Deployed Cognos reports and folders in content administration from development to test environments and also test to production.
• Provided technical support for Cognos 8.4 applications including report analysis, design, maintenance and configuration.
• Involved in scheduling the reports based on the data getting refreshed either weekly or monthly using Cognos Scheduler.

Environment: Cognos 8.4, Framework Manager, Cognos Connection, Cognos Administration, Report Studio, Query Studio, Analysis Studio, ORACLE 10g , Windows 2000

Confidential

Role : Cognos BI Developer

Confidential

Description : The USROTC Region Order To Cash ROTC DW project will collect supply chain data from the USROTC Sales Order Management system to support Perfect Order, Sales Order Management, and Accounts Receivable reporting

Responsibilities

• Analysis of the Functional Specification documents.
• Preparation of Technical Specification Documents.
• Ensure valid process and documentation availability in SharePoint
• Developed stored procedures and triggers, functions and materialized views.
• Responsible for providing a complete range of BI capabilities: reporting, analysis, score carding, dashboards.
• Documented the Metadata Models, canned reports and the Ad-Hoc reporting process.
• Created new jobs and scheduled reports using Cognos Connection
• Responsible for providing a complete range of BI capabilities: reporting, analysis, score carding, dashboards.
• Involved in creating/updating relational and DMR models, applying security and publishing packages using Framework Manager

Environment: Cognos 8.4, Framework Manager, Cognos Connection, Cognos Administration, Report Studio, Query Studio, Analysis Studio, ORACLE 10g , Windows 2000

Confidential

Role : Cognos BI Developer

Confidential

Description : The Training Plan Administration System TPAS is an electronic infrastructure designed built to support the Training and Development Planning Process TDPP . TDPP was designed and approved for the purpose of implementing, planning, tracking and reporting jointly agreed upon training for UAW-GM employees. Relevant training data is moved into TPAS from other databases, including CTIS and HIS and /or other appropriate corporate systems. In addition, some information is manually added to the database to reflect the local site requirements.

Responsibilities

• Involved in gathering business specifications and prepared technical specifications by closely working with BUCs Business User Coordinates
• Involved in meetings with the Business users and Project Department.
• Developed standard reports, ad hoc reports, for the end users.
• Experience with Cognos 8.3 Framework model development.
• Developed reporting and dash-boarding capabilities of various Cognos studios of applications: Report Studio ,Query Studio
• Involved in extensive use of conditional formatting while developing reports in Report Studio.
• Validated reports for data using Pl/SQL.
• Responsible for bug fixes and report deliverables and active in User Acceptance Training UAT .
• Utilized Framework Manager to import the data from stored procedures, create a Transaction Business model and published packages.
• Development of 24 Reports using Report Studio. Have worked on list, crosstab and graph
• reports
• I have extensively used Conditional Styles, Conditional Variables, and Page sets, Grouping, Section Headers and Footers, Filters.
• Developed and Published Packages in Framework Manager by creating database layer, physical layer and presentation layer, defining appropriate relationships between query subjects
• Involved in improving the performance of the reports by tuning the SQL queries, removing the unnecessary filters.
• Involved in interacting the data modelers to improve the performance of the reports.
• Involved in the deployment of packages from development to test and then to production environment.
• Trained and demonstrated the procedure of using the Query Studio and Analysis Studio to the business users.

Environment: Cognos 8.3, Framework Manager, Cognos Connection, Cognos Administration, Report Studio, Query Studio, Analysis Studio, ORACLE 10g , Windows 2000

Confidential

Role : Cognos BI Developer

Confidential

Description : The project involves in the design and development of reports for all the modules and the sub modules of the entire enterprise system ES2 This project includes both the OLTP and OLAP reports for the development which includes the requirement gathering, framework manager design, and development of the reports using report studio and testing the reports. The reports are developed by using the Business Intelligence tool Cognos8

Responsibilities

• Analyze the reports for the feasibility.
• Design of report packages in Framework manager
• And developing reports in the Report Studio .I have worked on List and Crosstab reports.
• Have Used Unions in Framework Manager.
• I have extensively used Conditional variables, Page Sets, Sections
• Fix problems in code during development and maintenance phases and modify corresponding documentation.
• Work out a detailed plan on the task assigned and reviewing detailed designs and testing reports.
• Involved in design and development of filters, calculations and session parameters in Packages within Framework Manager.
• Created complex reports using union queries, conditional formatting and prompting, drill-through and HTML items.

Environment: Cognos 8.2 ,Framework Manager, Cognos Connection, Cognos Administration, Report Studio, Query Studio, Analysis Studio, ORACLE 10g , Windows 2000

Confidential

Role : Cognos BI Developer

Description : The project involves in the design and development of reports for all the modules and the sub modules of the entire enterprise system ES1 . This project includes OLTP reports for the development which includes the requirement gathering, framework manager design, and development of the reports using report studio and testing the reports. The reports are developed by using Cognos8 BI Tool

Responsibilities

• Analyze the reports for the feasibility
• Design of report packages in Framework manager and developing reports in the Report Studio. I have worked on List and Crosstab reports.
• I have extensively used Conditional variables, Page Sets, Sections
• Work out a detailed plan on the task assigned and Reviewing detailed designs and testing reports
• Cognos and WPS Integration through Cognos SDK
• Testing and improving Report Performance and performing Query optimization.
• Involved in design and development of filters, calculations and session parameters in Packages within Framework Manager.
• Created complex reports using union queries, conditional formatting and prompting, drill-through and HTML items.
• Extensive unit and performance testing for the reports and fixing report bugs
• Resolved ambiguous, hierarchical and recursive relationships in the Framework Manager Model.
• Testing and validating the reports with custom SQL on toad.

Environment: Cognos 8.1,Cognos 8.2, Framework Manager, Cognos Connection, Cognos Administration, Report Studio, Query Studio, Analysis Studio, ORACLE 10g , Windows 2000