SUMMARY

Please use this table to list the skills noted in the Required/Desired section of the requirement. In addition, please respond with the years of experience for each skill and the last time each skill was used. Add or delete rows as necessary.

Employment History

Confidential

Data Warehouse /BI Architect

Data Warehouse Project

Satellite Healthcare has dialysis centers throughout US. It maintains a data warehouse that caters to reports like Facility Report card, Quarterly report trend, Quality Management Reports, Hemo treatment log, Patient Hospitalization details. SSIS packages load data from SPIN application to data warehouse. Reports are generated using SSRS. T-SQL stored procedures are used to refresh data warehouse and supply data to SSRS reports.

Responsibilities

• Responsible for Data Architecture, Data Model
• Responsible for ETL development/maintenance using SSIS, SSAS
• Responsible for development of SSRS reports including Facility Report Card
• Responsible for development of SSAS cubes and Excel Reports using SSAS
• Had Comprehensive knowledge and experience in process improvement, normalization/de-normalization.
• Responsible for development/maintenance of T-SQL stored procedure to refresh SQLServer database and supply data to SSRS Reports
• Develop and deploy SSRS reports to Report Server
• Migrate Visual Studio, Sql Server, BI to 2012 from 2008

Environment: Visual Studio 2012, BIDS, SSIS/SSAS/SSRS 2012/2008, Sql Server 2008, Oracle, MS Office.

Confidential

Data Warehouse /BI Specialist

Data Warehouse Project

• To create a new reconciliation tool and process to replace the current AGREE reconciliation process which will be discontinued.
• Exposures in FSA databases SMI and CORBIII are equal to balances in the local General Ledger as of month end reporting date. This will be referred to as Reconciliation 1 in this BRD. This reconciliation should be produced daily beginning on BD1 and ending on BD 20, with the option of producing it intraday.
• Exposures in FSA databases are equal to balances in the Group's Statutory and Regulatory Account Consolidation Engine SARACEN as of quarter end reporting date. This will be referred to as Reconciliation 2 in this BRD. This reconciliation should be produced daily beginning on BD1 and ending on BD 20, with the option of producing it intraday.

Responsibilities

• Had Comprehensive knowledge and experience in process improvement, normalization/de-normalization.
• Responsible for Data Architecture, Data Model
• Responsible for ETL using SSIS packages
• Responsible for building OLAP cubes using SSAS
• Responsible for Performance Tuning of SSAS Cubes
• Responsible for Requirement gathering and Analysis
• Responsible for Stored procedures using T-SQL

Environment: MSBI, SSIS/SSAS/SSRS, Sql Server 2008, Oracle, MS Office.

Confidential

Data Warehouse /BI Specialist

Data Warehouse Project

The CAO forecast data and POS actuals data already exist in the Teradata environment. The ERO forecast data must be collected from the ERO system and moved to the Teradata platform for the forecast comparisons to occur. Once the data is all on the Teradata platform, the Daily Error and Profile Accuracy will be determined using these three data sources: POS Actuals, ERO Forecast, and CAO Forecast a.k.a. SAS Returns and SAS Returns Hist .

Responsibilities

• Develop SSIS packages for ETL purposes
• Develop SSAS cubes and SSRS Reports
• Develop Data dictionaries and database schemas
• Responsible for Requirement gathering and Analysis
• Develop Stored procedures using T-SQL

Environment: MSBI, Sql Server 2008, SSIS/SSAS/SSRS, Teradata, Oracle, MS Office.

Confidential

Data Warehouse /BI Architect

Data Warehouse Project

As a Business Intelligence BI Engineer for Client, I am focused on designing, supporting the data warehouse and data marts leveraging DataStage ETL tools and Microsoft SSIS, SSRS and SSAS. I am responsible for providing escalated support, working on enhancements, fixing defects and working on projects related to client's Data Warehouse environment. To fulfill this role I collaborate with analysts, project managers, DBAs, and others across client's organization. I am required to: develop and support extract, transformation and load ETL processes using Assential Datastage, performance tune ETL including SQL , understand data models, business rules, and methods for source systems, work closely with business to define technical requirements and to understand the business and/or manufacturing processes surrounding data warehouse, ensure data quality through good design, development procedures and adequate testing, adhere to standards and recommendations and facilitate design and code walkthroughs.

Responsibilities

• Had Comprehensive knowledge and experience in process improvement, normalization/de-normalization.
• Developing ETL/BI solutions as identified by the Business.
• Working with the Business to resolve project and operational Issues
• Develop, Test and Maintain SSIS, SSAS Packages, T-SQL stored Procedures
• Develop and Support SSIS Jobs to load dimensions, facts into data warehouse using Error Handling, Auditing, Slowly changing dimensions, Data Profiling, Data Cleansing
• Responsible for developing KPIs using Performance Point
• Responsible for developing reports using Power Pivot
• Develop and Support SSAS cubes,

Environment: Microsoft SSIS/SSAS 2008 , Performance Point, Power Pivot, ORACLE 10g/9i, Share Point 2010, SQL, PL/SQL, UNIX. MS Office.

Confidential

Data Warehouse Architect

Lowes MDM Project

It is desired to load all Gold level customer and Lowes Prospect Records into the Hub. About 200 Million records to be extracted from Teradata for Initial Data Load. The Single Value of Customer SVOC Solution needs to be integrated with daily customer name and extract file. Integration is required between SVOC and RMK Processes using NADR required for Post Parallel Period. The extraction logic, data flows, data conversion and mapping logic, procedures for validating data, trapping and handling errors needs to be addressed.

Responsibilities

• Responsible for Performance Tuning of their ETL Process in their MDM
• Responsible for Preparing Project Plan
• Responsible for converting the DataStage code from Server to Parallel
• Worked on Single View of Customer or MDM
• Worked with Quality Stage, Performance tuning of DataStage Jobs, Server Jobs to Parallel jobs conversion
• Worked with Testing of MDM features like Suspect Duplicate Processing, Ever greening
• Develop SSIS packages, SSAS Cubes and SSRS Reports
• Worked with Data Quality, Data Cleansing, Data Enrichment,
• Manage quality through best practices, development standards

Environment: DataStage 8.x, Teradata V12, Sql Server 2008, ORACLE 10g/9i, SSIS/SSAS/SSRS, SQL, UNIX.

Pfizer Pharmaceuticals, Peapack, NJ September 2009 August 2010

Data Warehouse Architect From Offshore in India

Insight Global Data Warehouse

The Pfizer Insight Data Warehouse has experienced issues with accuracy and availability of data. This is due to external Data Source changes and internal factors. It is desired to analyze the ETL code and do the Performance Tuning. It is also desired to ETL development for the new functionalities.

Responsibilities

• Responsible for Gathering Requirements
• Responsible for Performance Tuning of their ETL Process
• Responsible for Study and Recommendations
• Responsible for Production Support of ETL Process
• Responsible for ETL/BI minor Enhancements
• Coordinate with offshore PASCI team at Chennai
• Responsible for Minor Enhancements in SSAS cubes
• Responsible for developing KPIs using Performance Point

Environment: SQLServer 2008, ORACLE 10g/9i, SSIS/SSAS/SSRS, SQL, PL/SQL, UNIX.

Confidential

Data Warehouse /BI Practice

Responsibilities:

• Working in Centre of Excellence for BIDW department
• Responding to RFP, POC , Effort Estimation, Presales for Clients
• Working on Data Warehouse Architecture initiative for building expertise
• Working towards competency development and environment set up
• Manage quality through best practices, development standards
• Responsible for developing SSIS packages, SSAS cubes, SSRS Reports

Environment: BO XI R2, Excelcius, MS BI, Informatica 8.x, DataStage 8.x, Teradata v9

MFX Fairfax, Morristown, NJ August 2007 December 2008

Data Warehouse Architect /BI Architect

Insurance Data Warehouse

CVSTARR is an interface to the Corporate Booking System which will be completed When a Policy transaction is booked. Transactions include new business, endorsements, cancellations, reinstatements and renewals.

Responsibilities:

• Lead internal customers with Requirements definition, Project definition and Project Planning
• Gather Business Requirements
• Had Comprehensive knowledge and experience in process improvement, normalization/de-normalization.
• Responsible for Installation and configuration of Informatica 8.1.1 client tools, Informatica Server and Repository Server, Migration of Informatica from 7.1 to 8.1.1
• Responsible to Migrate the mappings from Development to Test and then to Production environments.
• Responsible to Design, Develop mappings, Process Flows, Packages using SSIS
• Responsible for Designing Business Intelligence using Business Objects Reporting.
• Responsible to Create Universes, Generate reports using Web Intelligence, Desktop Intelligence, Publish reports to Repository, Schedule Reports, Use Crystal Reports
• Responsible for developing SSAS cubes
• Responsible for developing SSRS Reports
• Responsible for building and maintaining SAP Business Intelligence using Info Cubes, Info Objects
• Responsible for developing Dashboard Reports using Siebel Analytics

Environment: INFORMATICA 8.1.1, SSIS, SSAS, SSRS, Business Objects,, MS Project, SAP BI, Teradata v9, Oracle 10g/9i, Sql Server 2005, MS Office.

Confidential

Metrics Data Warehouse

Metrics data Repository is the data warehouse that is built from different applications like SSP, REMEDY, and VIPR etc. ODS is populated first and DWH is then populated. Feeds are generated from ODS and DWH. These feeds give input to Verizon Dashboard. Daily metrics like DSL/FTTP Sales, DSL/FTTP Billing are generated.

Responsibilities

• Coordinate with Business Analysts and Business users, to gather requirements.
• Experience in process improvement, normalization/de-normalization.
• Identify gaps in data requirements between ODS and Target Applications
• Identifying Risks, prioritizing them and develop Risk Response Plans
• Managed Vendor Interface, Oversee development team and Business analysts and report progress to Senior Management
• Responsible for running the batches to run on Daily, Weekly and Monthly basis using UNIX CRON.
• Responsible to Create and maintain schema for Microstrategy like facts, attributes, project source, projects, metrics, prompts, filters etc.
• Responsible for Security, Scheduling and Performance Tuning for Microstrategy Reports
• Responsible for Logical and Physical models for the Data Warehouse.
• Responsible for maintaining Data Warehouse in SSIS/SSAS/SSRS environment
• Responsible for developing Reports using Siebel Analytics
• Worked with BTEQ, MLOAD, Fast Export, TPUMP utilities of TERADATA
• Provided 24x7 Production Support and Maintenance for the applications

Environment: INFORMATICA 7.x/8.x, MicroStrategy 7.x ,Siebel Analytics, SQLServer 2005, Teradata V2 R5 , ORACLE 10g/9i, SQL, PL/SQL, UNIX, MS Project , SSIS, SSAS, SSRS, MS Office.

Confidential

Marketing Data Warehouse

Avon Inc is a supplier of Beauty Products. Avon Products are marketed throughout the world. It is desired to populate Latin America ODS to support regional data requirements. First Phase of ODS construction will primarily focus on serving Southern Cone MAPS requirements. Informatica is upgraded from 5.1 to 7.1.1.

Responsibilities

• Conduct the initial system study and prepare the High Level Design.
• Prioritize Business/Technical requirements
• Participate in client meetings, to review Integrated data approaches and interpret results
• Communicate Project findings, Conclusions and Recommendations with peers and clients
• Conduct the initial system study and prepare the High Level Design
• Define Requirements by understanding Business needs by interacting with key business Representatives, Prepared ETL requirement documents to transfer data from Central Master to MAPS and ODS
• Responsible for Logical and Physical models for Data Warehouse.
• Responsible to Design and Run Datastage parallel jobs
• Use Framework Manager to create project, develop and publish package to Reportnet Server,
• Use Cognos Connection to access Corporate Data and Schedule reports, Use Query studio to generate ad-hoc reports, Use Report studio to generate managed reports.
• Designing Business Intelligence using Business Objects Reporting.
• Create Universes, Generate reports using Desktop Intelligence, Publish reports to Repository, Schedule Reports
• Responsible for building and maintaining SAP Business Intelligence using Info Cubes, Info Objects

Environment: O/s: Oracle 9i, Data Stage 7.x, SAS, SAP BW, Business Objects 6.x, Cognos ReportNet, Oracle Applications , MS Project, MS Office.

Confidential

Retail Data Warehouse

Supervalu is the country's largest food distributor to supermarkets and one of the largest food retailers. The company serves app 5000 stores in 48 states. It also operates food retail stores principally under the names Cub Foods, Shop 'n save, Save a lot, bigg's, scott's foods, Laneco, Hornbachers etc. SUPERVALU IS/IT group offers its users automation, advanced decision-support systems, consulting services, systems engineering, data center management, and communications network and desktop computer support. In recent years, SUPERVALU IS/IT have build and supported data warehouse for merchandising systems and has plans in the near future to include wholesale group and undertake activities such as increasing subject areas to be covered as well as integration with POS system

Responsibilities

• Work closely with Business Analysts and Business Users to gather Requirements
• Had Comprehensive knowledge and experience in process improvement, normalization/de-normalization.
• Responsible for coordinating between Client and Offshore development team.
• Work closely with Business Analysts and Business Users to gather Requirements
• Responsible for coordinating between Client and Offshore development team.
• Responsible for Designed and Developed additional modules in Data Warehouse
• Responsible for Data modeling is done using Star Schema
• Define logical and Physical models for Data Warehouse.
• Get the change Requests from onsite, Analyze them with the team, do time/cost Estimation
• Prepare test plans and test cases
• Defect tracking and Monitoring
• Created and maintained schema for Microstrategy like facts, attributes, project source, projects, metrics, prompts, filters etc ...
• Maintained Security for users
• Coordinated and deployed Microstrategy report changes
• Done Performance Tuning for Microstrategy Reports
• Define Logical and Physical models for the Data Warehouses
• Worked with BTEQ, MLOAD, Fast Export, TPUMP utilities

Environment: O/s: Informatica Power Center 6.x, MicroStrategy 6.x, Cognos Impromptu, Power Play 6.x, TERA DATA V2R4, MS Office.

Confidential

SPX Data Warehouse

• SPX Corporation is a Fortune 500 company. It has many business units. The Data center at Horsham, Pennsylvania maintains the databases of these business units. It is desired to develop e-commerce site, through which automobile parts dealer can sell his product. Responsibilities
• Gathered Requirements from Business users to prepare Requirement document
• Designed and developed standards for overall architecture of data warehouse systems
• Had Comprehensive knowledge and experience in process improvement, normalization/de-normalization.
• Designed and develop Star Schema based on Kimball's Methodology involving Facts, Conformed dimensions, Surrogate keys and Aggregate tables.
• Developed complex mappings for loading data from source tables to staging tables and then to target tables using transformations like Source Qualifier, Expression, Filter, Aggregator, lookup, Update Strategy, Sequence Generator, Router and Joiner.
• Created UNIX Shell scripts for Pre-Session and Post-Session runs in Workflow Manager
• Direct project team on Standards and Architecture
• Used Informatica Debugger to apply break points while session is running
• Worked with multiple sources such as Relational Tables, Flat files, Excel Sources, ERP Sources for Extraction using Source Analyzer and Source Qualifiers
• Worked with Mapping Variables and Mapping Parameters
• Designed and Populated Aggregate tables
• Setup folders, groups, users, permissions and Performed Repository
• Administration using Repository Manager.
• Tuned the Mappings and Sessions for better Performance
• Created Test cases, Test Reports and supported users during User Acceptance Testing

Environment: O/s: UNIX SOLARIS S/w: SQL, PL/SQL, UNIX Shell Script Tools: Informatica PowerMart / Power Center 5.1, DTS, Oracle 8i/9i, ERWIN 3.x, BUSINESS OBJECTS 5.X, MS Office.

Confidential

Click Stamp Online Project

• Click Stamp Online allows users to print US postage directly on envelopes and labels using their own PC and printer. This method of printing postage is regulated by the United States Postal Service USPS under its Information Based Indicia Program IBIP . The PSD Postal Security Device major functions include Initialization, Authorization, Meter refill and Dispense. Responsibilities
• Installed and Configured Oracle databases for Click Stamp Online
• Owned and Maintained Oracle Schema for Click Stamp online
• Developed PL/SQL Procedures
• Developed and Maintained UNIX Shell Scripts

Environment: O/s: Windows 2000, Windows NT S/w: SQL, PL/SQL, UNIX Shell Script Tools: Oracle 8i, ERWIN 3.x, MS Office.

Michigan Dept of Transportation, Lansing, MI January 1999 January 2000

Consultant

MDOT Financial Obligation System

MDOT Financial obligation System MFOS provides a method for MDOT to manage the financing of approved MDOT Job Phases. The major functions provided by MFOS include Coordination of Federal fund Obligation and Disbursement, Communication between Program Management, Program Control, Project Initiation, Project Accounting, and the Federal Highway Administration, Report generation to facilitate monitoring of MDOT Phase funding Changes.

Responsibilities

• Worked with Business Analysts and Business users to get the Requirements
• Developed and maintained the MFOS Application using Power Builder
• Analyzed and Estimated Change Requests
• Developed and Maintained PL/SQL Procedures, Packages and Triggers
• Developed and Maintained UNIX Shell Scripts
• Owned and Maintained Oracle Schema for MFOS

Environment: O/s: UNIX SOLARIS S/w: SQL, PL/SQL, UNIX Shell Script Tools: Oracle 8i/9i, ERWIN 3.x, Power Builder 6.x, MS Office.

Tata Consultancy Services January 1996 December 1998

Responsibilities:

• Prepared Software Requirement Specification and Software Development Specification
• Designed the Physical model of database after translation from logical model.
• Develop Logical data model
• Developed PL/SQL Procedures, Packages and Triggers.
• Developed Oracle Forms and Reports
• Converted code from IBM COBOL to TANDEM COBOL
• Done data modeling using ERWIN
• Database Backup/Restore is done using Export/Import, Tar and CPIO
• Developed UNIX Shell Scripts

Environment: O/s: UNIX SOLARIS S/w: SQL, PL/SQL, UNIX Shell Script Tools: Oracle 5.x/6.x, ERWIN, ORACLE FORMS, REPORTS, MS Office.