PROFESSIONAL SUMMARY:

• Over 15 years of experience in Information Technology with over 12 years of Data Warehouse experience.
• Over 12 years of Cognos (Framework Manager, Report Studio, Query studio, Event Studio, Analysis Studio, and Connection) experience.
• Mentoring junior developers and supporting business in adhoc reporting
• Lead Cognos migration from 8 to 10.1 and 10.1 to 10.2
• Extensive experience in Analyzing, Designing and Performance Tuning COGNOS cubes.
• Experienced in troubleshooting Cognos Environment setup including Cognos 8, Cognos 10.1.1 and Cognos 10.2.2.
• Experienced in Relational Databases like DB2, Oracle Database design and SQL.
• Knowledge of ETL tools like Microsoft SSIS, Informatica and Abinitio
• Proven Experience in Analyzing Requirements, Data Architecting and Modeling Large Data Warehouses and Data marts.
• Experienced with the following data modeling tools: ERWIN, Embarcadero ERStudio 7.5
• Extensive experience in Analysis, Design and Development of Intranet and Client Server based applications
• Excellent Working knowledge of Transaction Processing Application Design and Development
• Excellent Communication skills and user interaction.

TECHNICAL SKILLS:

Hardware: Windows Desktops / Servers, IBM AIX, RS 6000, HP 9000 (UNIX), SUN SOLARIS, DRS 6000(RISC based system)

Operating Systems: UNIX, AIX, HPUX, Windows XP, 7, NT, HICIX, MVS, OS2, VME

DW Tools: COGNOS 10.2.2/10.1.1/8.4 Framework Manager / COGNOS Connection / Report Studio / Query Studio / UNIX Transformer / Windows Transformer, COGNOS 7 Transformer, Powerplay, Impromptu, IWRMS SQL Server Integration Services V 9.0, DTS

Data modeling tools: ERWIN, Embarcadero ERStudio 7.5TOAD, SQL Management Studio, SQL, Unix Shell, Windows Scripting, TIDAL, VB 6.0, C, UNIX SQR, ASPCOBOL Project, Visio, SSADM Tools, Structured Methodologies, Object Oriented Methodology

Databases: SQL Server, ORACLE, SYBASE, MS ACCESS, INFORMIX, INGRES, IDMSX

PROFESSIONAL EXPERIENCE:

Sr Cognos Developer/Architect

Confidential, Washington DC

Responsibilities:

• Responsible for development, support and maintenance of the Cognos Reporting Applications based on various subject areas including Claims, In Confidential t Stays, Care Management, Market Research, Fraud Information, Performance Measurements
• Mentoring junior developers and supporting business in adhoc reporting
• Lead the effort of migrating the Cognos applications from a Cognos 10.1.1/DB2 9.7/CQM ISAS environment to a Cognos 10.2.2/DB2 10.5/DQM Pureapp environment
• Design development and maintenance of the COGNOS Framework models
• Maintained data delivery standards to ensure consistent information delivery methods across projects.
• Worked with the various project teams in support of client Reporting
• Guide and mentor junior team members responsible for COGNOS report development and administration
• Develop, write and test queries using SQL to ensure accuracy of information leveraged through COGNOS
• Participate and contribute to the other DW functions including Data modeling and ETL
• Lead the effort of migrating the Cognos applications from a Cognos 8 to Cognos 10.1.1

Sr. COGNOS Developer/Analyst

Confidential, Fairfax VA

Responsibilities:

• Responsible for the Design and Maintenance of COGNOS Cubes and Reporting
• Responsible for defining COGNOS Server specifications and migrating from a COGNOS 8.1 to a 8.4 environment with multiple server configuration
• Responsible for design and development of Summary tables used in PRAS Reporting
• Participate in the design and development of ETL procedures using Microsoft SSIS (SQL Server 2005/2008) to load Information into the Warehouse

Confidential, Wilmington DE

Responsibilities:

• Architecting and designing the legacy Marketing Code assignment process to use the new Data Warehouse
• Analyzing and creating necessary reporting information on Mortgages for external auditors
• Re architecting and tuning the cube build process for better performance and quicker turnaround times
• Redesigning and Automating COGNOS 7 Cube Build process on Tidal Scheduler
• Designing Cube build, audit tracking and posting process on COGNOS 8.4 using UNIX Transformer, Unix shell scripts, Windows Batch and COGNOS Utilities.
• Oracle 10G database

Confidential, Harrisburg PA

Responsibilities:

• Analyze, Design Enterprise Level, District and Interchange Level Dashboards showing key metrics identified from the TOLL Information maintained on SQL Server and HR information maintained in SAP
• Identify the KPIs and present and review the solution design with an selected pilot group from Enterprise, District and Interchange Managers of Fare Collection
• Interact with SAP developers by providing Design specifications for SAP Cube requirements
• Define COGNOS 8.4 Server Architecture and configuration. Review the Architecture and identify COGNOS software components to be installed
• Set up the development environment.
• Develop and enable PTC Fare Collection Owners with an understanding of navigation in COGNOS Connection using the COGNOS 8 portal access to Multi Dimensional BI Models
• Knowledge transfer / on how to use the COGNOS 8 Platform

Reporting Infrastructure Team Lead

Confidential, Wilmington DE

Responsibilities:

• Provided technical leadership to the development team to deliver quality B.I. and reporting solutions.
• Designed and developed a common web - based Reporting portal to provide one-stop secured and reliable access to information in the corporate data warehouse.
• Supported design and development of management dashboards and key performance indicators for decision support and exceptions management.
• Actively participated in performance tuning of COGNOS Cubes by reviewing the architecture and the Cube Design
• Lead the effort of migrating the Cognos applications from a Cognos Report net to Cognos 8 environment
• Used ERWIN 3.5 data modeling tool.
• Worked closely with business leaders, data modelers and data warehouse developers to ensure consistent and accurate reporting across the business
• Worked closely with business and IT team members to turn raw data from production systems into useful strategic information
• Participated in Integrating fragmented reporting data sources into the corporate data warehouse

Data Architect/Technical Lead

Confidential, Milwaukee WI

Responsibilities:

• Management Reporting using COGNOS Cubes and Reports
• Wholesale Compensation and Service Reporting using COGNOS Cubes and Reports
• Marketing based Reporting
• Sales Integration with ONYX (CRM application) and transfer between Servers using DTS
• Designed and managed an online Record Keeping System for Managed Accounts another new product line that the Intermediary team manages
• Lead the Conversion of COGNOS series 6 to COGNOS series 7
• Designed and Lead the Development of the Sales Flows and Assets Reporting System including Data Loaders, Custom Data Scrubbing tool, COGNOS Cubes and Reports
• Hardware: SUN Solaris, Windows 2000, Windows NT

Data Warehousing project

Confidential, Chicago IL

Responsibilities:

• The MRO Distribution Company moved their Sales and Distribution Applications from Legacy to SAP. The Financial Applications continued to be Legacy Applications. The Customer felt a need for Data Warehouse encompassing information from all sources to meet their reporting needs
• My responsibility included the following activities
• Lead the Requirement Analysis of over 2000 reports, conducting JAD Sessions architected and designing the logical and physical Data model consisting of different Subject Areas like Sales and Marketing, General Accounting including Chart of Accounts, Cost Accounting, Inventory Management and Product Management
• Lead the Design of the Logical and the Physical Data Warehouse.
• Analysis of Information in SAP (SD and MM Modules), Oracle Financials and other mainframe based legacy systems
• Design Process to load meta data from the modeling tool to INFORMATICA
• Design the Extraction data elements from legacy system database sources and populate the data warehouse using the ETL tool - INFORMATICA Power Mart (both mainframe and ORACLE).
• Lead the Design of the data marts and the process to load the data marts
• Train end users with the information available in the warehouse
• Hardware: IBM Mainframe, IBM RS 6000, IBM PCs
• SOFTWARE: COOL Product Suite (Modeling tool), Word, Power Point, MS Access, EXCEL, VISIO, INFORMATICA POWERMART, INFORMATICA MX2 bridge, VB 6.0, Business Objects, ORACLE Financials, IMS, DB2

Confidential, Grand Rapids MI

Responsibilities:

• As a Project lead involved in the analysis, design and development of the Customer Profile System. Responsibilities included preparing and finalizing the application design, preparing audit control procedures and backup/recovery plan, participating in test plan preparations, monitoring and controlling development. Designed and reviewed the front end specifications, program specifications and application flow. Developed the application and prepared unit and system test plans. Implemented the system and offered Technical support for the system, until the system was handed over to the Client.
• As a lead member of the BASE (Business Automation Support Environment) project I was involved in computerizing the competitive price checking activities for the Corporate Retail Stores. Responsibility included understanding the user requirements, preparing the system requirement specifications, determining work flows, analyzing the business functions and processes, developing process and data models, designing and developing the system in a 3 tier Client Server environment with Visual Basic, ENTERA (Middle Ware) and Informix.

Confidential, Southbend IL

Responsibilities:

• Responsibility included understanding Customer modification requirements, designing functional and Technical specifications, development of INGRES ABF code and testing. Some of the modifications involved interface to a scheduling package FMMS. Additional responsibilities included database administration activities like setting up a development environment and upgrading product to its current version