SUMMARY:

• Over ten years of experience in IT industry, with over nine years of experience in Data-warehousing and OLAP tools.
• Certified IBM Cognos 8 and Cognos 10 BI Author.
• Cognos trained in Cognos 10 8 with three years of experience in Cognos 10.x, three years of experience with Cognos 8.x and three years of experience with Cognos ReportNet 1.x.
• Experience with Cognos EP Series 7 including Impromptu Administrator Impromptu Web Reports IWR , Analysis tools such as PowerPlay Transformer, PowerPlay Enterprise Server, Cognos Visualizer, Cognos Architect, Cognos Query, Cognos Security, Power Prompts, and Access Manager.
• Extensive experience in report development including standard reports, customized reports using embedded SQL or HTML scripts, drill-through reports, active reports, dashboards, etc.
• Extensive experience in creating publishing Relational, Multi-dimensional, Ad-Hoc packages in Framework Manager. Created maintained Catalogs in Impromptu Administrator and Cognos Architect.
• Extensive experience in Cognos administration including installation routine server maintenance, setting up user and object level security, creating data source connections, deployment, etc.
• Expertise in Scheduling reports via conventional scheduling methods, bursting or file transfer
• Extensive experience in SQL development for unit testing, custom Cognos reports, materialized views, summary tables, stored procedures, etc

TECHNICAL SKILLS

• Languages / Tools: C/C , XML, SQL, PL/SQL, TOAD, Shell, VBScript, VB.Net, Java
• Reporting BI Tools: Cognos 10.x, Cognos Series 8.x, Cognos ReportNet 1.02/1.1, Cognos 6.x/7.x Impromptu Administrator, PowerPlay, PowerPlay Transformer, PowerPlay Enterprise Server PPES , Impromptu Web Reports IWR , Upfront, Cognos Query, Cognos Visualizer, Cognos Metrics Manager, Scheduler, Cognos Architect, Power Prompts, Access Manager
• ETL Tools: Informatica PowerCenter 7.2/8.1, Informatica PowerMart 6.1
• Databases: Oracle 7.3/8.1/9.1/10.1/11.x, DB2, SQL7.0/2000, MS Access
• Enterprise Planning Software: TM1 9.1, SAP BW
• Web Servers: Java Web Server, IIS 4.0/5.0
• LDAP: Active Directory, Novell eDirectory ConsoleOne
• Others: SAS, SAP BW, MatLab, R, Jumpin Statistics, Minitab
• Operating Systems: HP-UX, AIX, NCR-UNIX SVR4, LINUX, Windows NT/2000/XP/7

EXPERIENCE:

Sr. Cognos Developer

• As part of the Strategic Sales and Marketing Services department, the U.S. Cellular Shared Analytical and Data Services team SANDS is comprised of highly technical resources with diverse backgrounds in data warehousing, business intelligence, analytics, forecasting, and CRM. The SANDS team is responsible for delivering data solutions, analytical tools, campaign execution, and business insights to our stakeholders in Marketing, Finance, Customer Service, and Sales Operations.
• Created summary, detail and drill-through reports in Cognos 10.1.1
• Wrote custom SQL to embed in reports when building FM package wasn't viable
• Performance Tuning of existing Cognos reports
• Collected report requirements
• Demonstrated finished reports to handoff reports for EUAT
• Created test scripts for UAT
• Actively involved in cycle testing of various internal schemas like RDH, DWIDL, etc.

Environment: Cognos 10.1.1, Oracle, TOAD.

Confidential

Sr. Cognos Developer/Administrator

Confidential

• As one of the largest privately owned distributor of healthcare products in the Midwest, H. D. Smith is in the midst of revamping its business intelligence system. The OPUS project involved integrating a traditional AS400 legacy system to SAP BW for Analytics and a relational database for operational reporting with a Cognos 10.2 frontend
• Cognos 10.1 production support
• Setup users on Active Directory
• Tuning of Cognos Framework Manager models
• Created active reports, dashboards, and drill-through reports in Cognos 10.2
• Performed BA related tasks as preparation to migrating to SAP BW
• Setting up test scripts for integration testing

Environment: Cognos 10.1.1, Cognos 10.2, DB2, TOAD, SAP BW.

Confidential

Sr. Cognos Developer

Confidential

• Pre-existing operational reports were data intensive rendering daily report analysis inconvenient for a majority of financial users. Summarized reporting using dashboard reports was identified as a feasible solution which instigated this phase of the project
• Created summary tables from transactions tables within the DB2 database
• Recreated viewpoint model using summary tables in Cognos Framework Manager
• Created dashboard and drill-through report by subject area
• Setup users on the LDAP through Console One
• Setup object level and data level security for dashboard report users
• Performance tuned, tested and deployed existing operational reports outside of previously identified subject areas
• Migrated reports and models from Cognos 8 to Cognos 10

Environment: Cognos Series 8.4.1, Cognos 10.1, DB2, Console One, AQT.

Confidential

Sr. Cognos Architect

• HAP Analytics is a centralized data warehousing and reporting system sourced from multiple legacy systems. The HAP reporting team was responsible for replicating the legacy reports using Cognos 10 sourced by an Oracle database
• Installed and configured Cognos 10 components
• Created and maintained user groups and roles
• Built summary tables to summarize large claims and membership tables
• Setup up data source connections in Cognos Connection
• Developed multiple ad-hoc, reporting and DMR models in framework manager
• Built and published cubes in Cognos transformer
• Developed complex list, crosstab and dashboard reports using summarized data while allowing users to drill through to a detailed report
• Setup data level and object level through framework manager and Cognos connection
• Setup Cognos configuration and Cognos administration to allow outputs to be saved to an external source
• Tested reports for end user acceptance

Environment: Cognos Series 10.1, Cognos Transformer 10.1, Oracle, TOAD, SQL Developer.

Confidential

Sr. Cognos Developer

Confidential

• Decision Support System DSS team supports business and organizational decision-making activities of Aon-Hewitt. The reporting segment of the DSS team is responsible for creating management and operational reports which is powered by Cognos TM1 and DB2 databases
• Created security and burst tables within the DB2 database
• Imported TM1 cubes into Cognos 8.4 using Cognos Framework Manager
• Create operational and management reports off TM1 cubes and Financial Data Warehouse FDW
• Setup users on the LDAP through Console One
• Setup up data source connections in Cognos Connection, catalogued databases on windows servers and set routing rules.
• Setup report level and data level security operational and management reports
• Setup reports for bursting
• Tested reports for end user acceptance
• Deployed reports to production

Environment: Cognos Series 8.4, DB2, Cognos TM1 9.1, Console One, AQT.

Confidential

Sr. Cognos Developer

Confidential

• The Supply Chain Information Network SCI NET forms the core of global information technology at Baxter. Comprising of a suite of data warehousing and business intelligence tools, this system is intended to support various global supply chain activities at Baxter across a range of businesses including BioScience, Medication Delivery, and Renal.
• Upgraded ReportNet reports and Framework Manager models from ReportNet to Cognos 8.3
• Tested upgraded reports against original reports before deployement to production
• Maintained and supported upgraded Cognos 8.3 reports and models
• Developed Framework Manager models BBR by implementing Active Directory security for regional based Cognos reporting
• Created report templates with built-in scripts to monitor database table load status
• Provided Framework Manager model improvements of the current Supply Chain Data Warehouse SCDW model
• Created new Framework Manager models including TRAX, FGRP, RENAL HP, JDE LIVE, APS NET REQ, etc.
• Created new Cognos 8.3 reports based on user requirements
• Created Cognos 8.3 reports with custom SQL and procedures for updating database columns
• Converted legacy system MY OPPI reports to Cognos 8.3
• Worked in the capacity of SME, taking sole responsibility of the migrating ReportNet report to Cognos 8 and creating new Framework Manager models

Environment: Cognos Series 8.3, Cognos ReportNet 1.1, VBScript, AS400, Oracle 10.1, PL/SQL,TOAD.

Confidential

Sr. Cognos Developer

Confidential

Pfizer's Manufacturing Accounting and Planning System MAPS is a suite of manufacturing applications that provide functionality for managing Pfizer's global manufacturing sites. The system is designed to enhance manufacturing efficiency across Pfizer's manufacturing sites. The MAPS reporting team was responsible for creating and maintaining materials management, production management, production planning, and finance reports to aid the MRP system.

Responsibilities:

• Extracted and transformed MAPS data using ETL tool - Informatica.
• Created and modified metadata models, with the appropriate join structure
• Created packages and published them to Cognos Connection
• Developed more than 200 reports against the published packages while maintaining/supporting existing reports
• Updated old reports to meet current reporting standards
• Migrated reports from Cognos ReportNet to Cognos Series 8
• Collected new report specifications, created design documents, tested reports, tested Framework Manager packages, tested DTS package and stored procedures
• Written VB macros to enable post execution calculations for end-users
• Created complex SQL and Framework Manager views to avoid complex modular joins within reports
• Actively involved in installing Cognos Series 8 software and peripherals
• Deployed packages and reports into production
• Created and maintained user groups and end-users access on the development and production servers
• Worked in the capacity of a Cognos Lead while guiding new developers hired to assist in the migration of Cognos ReportNet reports to Cognos 8 and EUAT testing

Environment: Informatica PowerCenter 8.1, Cognos Series 8.3, Cognos ReportNet 1.1, VBScript, AS400, Oracle 10.1, PL/SQL, SQL Server 2000, SQL Query Analyzer, MS-Access.

Confidential

Confidential is a new system developed to comply with the EPA, MDEQ, U.S. Department of Commerce, and Corporate EHS reporting requirements. The objective of EDBARS was to develop a database and a reporting tool to summarize and calculate the quantities of reportable materials at the Kalamazoo site from inventory, usage, storage, and manufacturing data maintained in the P-GEMS and MAPS systems. These objectives were previously met by legacy systems such as FCMS, BPCS, SOPHIE, ASDB, and MCP, which where scheduled to be decommissioned with the commencement of MAPS, P-GEMS and EDBARS reporting systems.

Responsibilities:

• Involved in Relational and Star schema database design and loading data
• Created metadata models, made appropriate Joins, organized Folders according to the Business view and published the packages using Framework Manager onto Cognos Connection.
• Created SQL and Framework Manager views.
• Developed standard Templates for various kinds of reports.
• Created complex reports using Report Studio and Ad-hoc web based reports using Query Studio.
• Interfaced ReportNet with a VB.Net front end to enable the end users to execute the reports from within the VB.Net application by passing parameters through an URL pointing to the location of the report.
• Created test scripts to conduct unit tests to test the functionality of Framework models and packages.
• Created test scripts to conduct unit tests to test the functionality of each report.
• Conducted integration tests to check the integrity between VB.Net and ReportNet.
• Involved in the documentation of user requirements, functional requirements, detail design requirements and training documents.
• Conducted end user training sessions to train the end users on how to execute the reports and view the report out from within the VB.Net application.

Environment: Cognos Reportnet1.1, VB.Net, SQL Server, SQL Query Analyzer, MS-Access.