Introduction:

I have 15 years of experience in Data Warehousing and Business Intelligence as a Sr. DW Business Intelligence Consultant, in verticals like Health Care, Retail, Marketing, Pharma, Accounts, Finance, Banking and Telecom etc. I have good understanding of ETL and BI Architecture. I worked in DW Development, Maintenance and Production Support Projects. I have worked in various roles such as ETL/BI Developer, DW Architect, Data Modeler, Project Manager and have good understanding of many business processes and technical fields. I have keen eye to Detail and focused on the objectives of client. I have 5 years of experience working in USA and more than 10 years of experience working with USA based clients. I am Oracle Certified and PMI Certified Project Management Professional PMP

Technical Skills:

Confidential

Data Architect/DBA

DW Project

HCSC does the Invoice Billing Process for its Insurance Clients in Illinois, Texas and other states. The process involves getting billing entities, checking eligibility coverage, billing period, billing entity holds, retro census, continuing census, Subscribers and dependents, medical and dental, posting the invoice to GL, posting cash transactions. This process gets all the billing entities to be billed and its corresponding bill start and end date, also identifies whether current census to be computed for the identified billing entities. Invoice Billing transactions are then loaded into Billing data mart using SSIS packages. Reports are developed using SSRS.

• Design and Development of RMAS Schema , logical and physical
• Design and Development of Billing Data Mart
• Development of T-SQL Stored Procedures
• Monitoring of Sql Server database
• SQL Query Tuning, Optimization, Execution Plan
• Use of DMV queries for SQL Server Diagnostic Services
• Index design, Clustered/ Non-Clustered, Covering / Filtered Indexes
• Use of Temp tables in Stored Procedures
• Use of Sql Server Profiler for Monitoring
• Monitoring Locks, Blocking, Waits, running SPIDS,
• Long Running Queries and it Tuning
• Unused Indexes, Missing Indexes
• Monitoring CPU Pressure, Available Memory, Paging, Buffer Pool, Logical/Physical Reads
• Monitoring Available space in File groups
• Monitoring Stale Statistics, Update Statistics
• Responsible for Data Architecture, Data Model
• Responsible for ETL/BI Architecture
• Responsible for ETL development/maintenance using SSIS
• Responsible for Report development using SSRS

Environment: Visual Studio 2012, BIDS, SSIS/SSAS/SSRS 2012, MDS, DQS, PDW, Share Point, Power Pivot, SSAS, Sql Server 2012

Confidential

Data Architect

DW Project

Fuzion Analytics gets Long Term HealthCare data from its clients. The data Includes Policy, Coverage, Claim, EOB, Payment Request Person data. The data goes through the ETL processes to Teradata Warehouse Repository. Data Marts are developed for Reporting purposes, and Reports using Qlick View.

Responsibilities

• Responsible for Data Architecture, Data Model
• Responsible for ETL/BI Architecture
• Responsible for ETL development/maintenance using SSIS
• Responsible for Maintenance of Teradata Warehouse
• Responsible for Test Plans
• Responsible for moving the data to Prod from Dev environment
• Responsible for Tabular Reports using PDW
• Responsible for Data Mart development
• Responsible for BigData Development using Informatica 9.5 and Hparser

Environment: Visual Studio 2012, BIDS, SSIS/SSAS/SSRS 2012, MDS, DQS, Teradata v13, PDW, Share Point, Power Pivot, SSAS , Informatica 9.5

Confidential

ETL/BI Architect

DW 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
• 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
• Responsible for Analysis Services in Tabular Mode
• Responsible for Reports using Power Pivot
• Migrate Visual Studio, Sql Server, BI to 2012 from 2008
• Responsible for BigData using Hadoop/Hive

Environment: Visual Studio 2012, BIDS, SSIS/SSAS/SSRS 2012/2008, Sql Server 2008, MDX, SharePoint, Power Pivot, C , .NET, MDS, DQS, Hadoop, Hive, SSAS

Confidential

ETL/BI Specialist

DW 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

• 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
• Responsible for development of Reports using SSRS
• Responsible for Big Data using Hadoop/Hive

Environment: DataStage 8.x, Oracle 11g, SSIS/SSAS/SSRS, Sql Server 2008, Sharepoint, Power Pivot, Visual Studio, C , .NET, Hadoop, Hive, MongoDB,

Confidential

ETL/BI Specialist

DW 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, Informatica 9.1, Sql Server 2008, SSIS/SSAS/SSRS, Teradata, Netezza

Confidential

ETL/BI Architect

DW 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

• 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,
• Develop SSRS Reports

Environment: Microsoft SSIS/SSAS/SSRS 2008 , Performance Point, Power Pivot, Sql Server 2008, Share Point 2010, SQL, PL/SQL, UNIX.,

Confidential

DW 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
• Responsible for Java Development

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

Confidential

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

DW/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

Confidential

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.
• Lead internal customers with Requirements definition, Project definition and Project Planning
• Gather Business Requirements
• 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

Confidential

Metrics Data Warehouse

Metrics data Repository is the data warehouse that is built from different applications like SSP, REMEDY, 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
• 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

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
• Responsible Java Development for ETL

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

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
• 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, 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
• 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.

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
• Responsible for Java Development

Environment: O/s: Windows 2000, Windows NT S/w: SQL, PL/SQL, UNIX Shell Script

Confidential

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

Confidential

Role and Responsibility:

• 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.