EXPERIENCE SUMMARY:

• 10+ years of professional experience in diversified IT fields such as Data Warehousing, Data Modeling, Business Intelligence (BI), and Customer OLAP and Reports Generation.
• Experienced in installation and configuration of Cognos BI v8.3, Cognos BI v8.4 and v10.1 Suites on distributed environments
• Proficient in designing Multidimensional Models (DMRs) in Framework Manager in Cognos BI v8 and v10
• 8+ years of extensive experience in Framework Manager, Query Studio, Analysis Studio and Report Studio
• Strong Complex Reporting skills - - complex Drill-Through, Dashboards, Discontinuous Cross-Tabs, Summary Reports, Burst Reports, ad-hoc reporting and advanced report authoring.
• 7+ years of extensive experience in Cognos Transformer modelling (OLAP modelling) and creation of Cognos Cubes using Cognos Transformer v7.4/7.5/8.3/10.2
• Deployment of models and reports from Development - Test - Production environments
• 5 years of Cognos Administration experience in creating various Data Sources, Users, Security Groups and Roles coupled with BI server optimization and tuning
• Periodic backups of teh Content Store and server configurations
• Performance tuning of Cognos BI servers residing on single or multi-server architecture
• Migration experience from Cognos v8.3 to Cognos v10.1/v10.2
• 5+ years of experience in designing Relational and Multidimensional databases in Oracle 10g/11g
• 8+ years of experience in coding using SQL, Views, Materialized Views, Stored Procedures, Functions and Triggers
• Expertise in OLTP/OLAP System Study, Analysis and E-R modeling, developing Database Schemas like Star Schema & Snowflake Schema used in Relational, Dimensional and Multidimensional modeling.
• Mentor and Train Business Users on Cognos platforms for teh successful execution and business utilization of teh project
• Experience spans all teh phases of life cycle of software development such as Requirement Gathering, Requirement Analysis, Estimations, Planning, Coding, Testing and Post Production Support.
• 2+ years of project management experience with waterfall and agile methodologies (SCRUM).
• Experience in collaborating with various internal as well as external teams for teh successful and timely delivery of multiple projects
• Manage project teams of 5-15 members in an onshore-offshore model to successfully meet project deadlines and commitments
• Big Data project experience with installation and configuration of Greenplum DB v4.2.2.4 on RHEL v6.3

TECHNICAL SKILLS

BI Tools: Cognos 10, Cognos 8 Suite, Cognos 8 Transformer, Jaspersoft BI Suite v5.0.1, OBIEE, QlikView, Cognos 7.3.

BI Planning Tools: Cognos Planning v7.3, Cognos TM1, Hyperion Essbase.

ETL Tools: SAP BO Data Services, Informatica 9.1, Informatica 8.6

Databases: Greenplum (GPDB 4.2.2), PostgreSQL v8.2, Oracle 10g/11g, DB2, SQL Server 2000/2002, Teradata v7

Software Languages: C, C++, Visual Basic 6.0, ASP 2.0, JavaScript, VBScript

Internet Technology: HTML, XML

Environment: Windows 7, Windows XP, Windows Server 2003/2008, RHELv6.3

PROFESSIONAL EXPERIENCE

Confidential - Woodstock, GA

DWBI Architect/Lead

Responsibilities:

• Work closely with business end-users/Business Analysts for requirement gathering and impact analysis
• Design Data Marts and create detailed architecture documents
• Create Technical Design Documentation for Cognos Reports, Framework Manager Models and Transformer Models
• Create detailed design and cut-over document for ETL processes (Informatica).
• Prepare Unit and system test plans and test cases
• Develop teh Framework Models, Transformer Models, Reports and Stored Procedures as per teh Technical Design documents
• Carry out Unit/System/Regressing testing based on teh test plans and test cases
• Administer teh user base by adding/removing users, groups, roles
• Carry out performance tuning of teh Cognos BI server and provide preventive measure for possible server failures
• Take periodic backups of teh Cognos Content Store and server configurations
• Maintain teh Cognos BI server fail-over system by configuring fail-over properties over distributed environment
• Coordinate with teh offshore team for Knowledge Transitions of requirements and ensure timely completion of projects with high quality deliverables
• Design teh solution and support teh installation, customization, and integration of teh Greenplum solution
• Recommend tactical performance and tuning of teh Greenplum technologies
• Provide project team leadership
• Develop and document strategies, policies and best practices for teh customer
• Evaluate various open source ETL and BI tools dat complements Greenplum’s MPP technique for optimal and cost efficient DW solution
• Development of Business Analytics on Licensed as well as open source BI Analytical tools like Alpine Miner, Pentaho BI Suite, Jaspersoft BI Suite, etc.

Environment: Greenplum DB v4.2.2.4, RHEL v6.3, Oracle 10g, SQL Server 2002, Windows 7. Windows Server 2003, Jaspersoft BI Suite v5.0.1

Confidential, CA

Sr. Cognos Developer/Architect/ETL (Informatica) Programmer

Responsibilities:

• Carry out inbound and outbound process in Cognos Planning after teh business users contribute their Plan/Forecast data in teh contributor interface of Cognos Planning
• Create map objects in Cognos Planning to translate teh lower level granularity of data in teh datamart to dat of teh Planning level which is usually at a higher granularity.
• Create Contributor UI for business users with necessary business calculations
• Prepare project plan based on waterfall or agile methodology or a combination of both
• Create Technical Design Documentation for Reports, Framework Manager Models, Transformer Models and Stored Procedures
• Create detailed design and cut-over document for ETL processes.
• Prepare Unit and system test plans and test cases
• Develop Informatica jobs for data migration across heterogeneous databases.
• Develop teh Framework Models, Transformer Models, Reports and Stored Procedures as per teh Technical Design documents
• Migrate around 35 Cognos v8.3 reports to Cognos v10.1
• Carry out Unit and System tests based on teh test plans and test cases
• Create of Test strategy and Test Data for carrying out teh thorough testing of teh tool
• Carry out Peer Review of Informatica job to check teh proper implementation of Business rules and train new resources on Informatica
• Manage teh deliverables to teh client
• Take periodic backup of teh deployment files for recovery purposes, in case of any failures
• Plan and allocate tasks and delegate responsibilities to teh team members for teh successful execution of teh project
• Carry out daily reviews and status monitoring of teh project with Steering Committee
• Conduct Defect Prevention meetings every month and address teh issues related to defects in teh ongoing releases and device action items
• Conduct Team Meetings and address teh issues faced by teh Team Members and come up with solutions for teh same

Environment: Cognos 10 Suite (v10.1.1), Cognos 8 Suite (v8.3), DB2 (v9.1), Hyperion/Essabase, Windows XP. Windows Server 2003, Cognos Planning v7.3, Cognos TM1, Informatica v9.1

Confidential, WA, USA

Sr. SAP BODS programmer

Responsibilities:

• Profiling of source data for carrying out cleansing activities
• Development of Conversion objects using SAP Business Objects Data Services (BODS) / Business Objects Data Integrator (BODI) for Order To Stock (OTS) module of teh business
• Working with teh SAP functional experts in developing data cleansing rules
• Working with teh SAP functional experts in processing inputs/outputs within teh SAP BODS functionality reflecting clean data and data exceptions.
• Ensure dat teh proposed data cleansing technical solution and associated business processes meets business expectations for improving and enhancing data quality
• Interact with teh key Business Associates for understanding teh as-is process flow and new business requirements or enhancement activities
• Document teh Business Requirements for report development, coding and passing it to Client Review
• Analyze teh Business/Functionality as provided in teh requirements of teh Business Stake holders
• Carry out Feasibility study of teh requirements within teh scope of teh project and creation of Feasibility Study documents
• Allocate tasks and delegate responsibilities to teh team members for teh successful execution of teh project
• Daily reviews and status monitoring of teh project
• Conduct Defect Prevention meetings every month and address teh issues related to defects in teh ongoing releases and device action items
• Conduct Team Meetings and address teh issues faced by teh Team Members and come up with solutions for teh same
• Coordinate with onsite/offshore team for teh day-to-day activities including status reporting with teh Client
• Plan and Create project estimates and detailed task work flows
• Develop teh Framework Models, Transformer Models, Reports and Stored Procedures as per teh Technical Design documents
• Carry out Unit testing based on teh unit test plans and test cases
• Create Technical Design Documentation for Reports, Framework Manager Models, Transformer Models and Stored Procedures.

Environment: Cognos 8 Suite (v8.4), Teradata (v7), Windows XP. Windows Server 2003

Confidential

Cognos Developer

Responsibilities:

• Provide extensive training on Cognos v8.3 to teh business end users and Management Executives with emphasis on Cognos Cubes using Analysis Studio
• Provide working sessions to teh business end users on creating ad-hoc reports using Report Studio and Query Studio
• Implement security features to packages, report objects and reports by adding/creating Users, Groups and Roles
• Interact with teh key Business Associates for understanding teh as-is process flow and new business requirements or enhancement activities
• Document teh Business Requirements for report development, coding and passing it to Client Review
• Analyze of teh Business/Functionality as provided in teh requirements of teh Business Stake holders
• Carry out Feasibility study of teh requirements within teh scope of teh project and creation of Feasibility Study documents
• Coordinate with onsite/offshore team for teh day-to-day activities including status reports
• Create of project estimates and detailed task work flows
• Prepare project plan based on waterfall or agile methodology or a combination of both
• Create Technical Design Documentation for Reports, Framework Manager Models, Transformer Models and Stored Procedures
• Prepare Unit and system test plans and test cases
• Develop Framework Models, Transformer Models, Reports and Stored Procedures as per teh Technical Design documents
• Carry out Unit testing based on teh unit test plans and test cases
• Create of Test strategy and Test Data for carrying out teh thorough testing of teh tool
• Create common, reusable source code for carrying out specific functionalities
• Carry out exhaustive code review for any non-conformance in teh coding standards
• Enumerate teh review comments and provides alternatives for better performance and quality of teh tool
• Carry out teh final Verification Testing of teh tool after teh review comments have been worked upon and before delivery to teh client

Environment: Cognos 8 Suite (v 8.3), HiRDB (v8.2), OLAP, Windows XP. Windows Server 2003

Confidential

Responsibilities:

• Develop teh Framework Models, Transformer Models, Reports and Stored Procedures as per teh Technical Design documents
• Carry out Unit testing based on teh unit test plans and test cases
• Create Test strategy and Test Data for carrying out teh thorough testing of teh tool
• Peer Review of Informatica job to check teh proper implementation of Business rules and train new resources on Informatica.
• Defect Analysis/Fix, raised during UAT/SIT
• Deploy teh developed objects from DEV-QA-PROD environments
• Migrate teh Framework Manager Models, Packages and Reports from Cognos 8.2 to Cognos 8.3
• Manage issue tracker and functionality change documents
• Identify and define support processes for teh project

Environment: DB2, SQL, Cognos Impromptu and Power Prompt reports, JavaScript, VBScript, Visual Basic, ASP, IIS Web Server