Introduction:

I have 15 years of experience in Data Warehousing and Business Intelligence as a Sr. DW Business Intelligence Consultant, in verticals like Retail, Marketing, Pharma, Accounts, Finance, Banking and Telecom etc. I have good understanding of ETL and BI Architecture. I worked with Business Objects and other BI tools. I worked in DW Development, Maintenance and Production Support Projects. I have worked in various roles such as 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 am Oracle Certified and PMI Certified Project Management Professional PMP

Technical Skills:

Confidential

Big 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 Hadoop Connectors to Informatica
• Getting Data from Hive tables using Informatica
• Responsible for BigData development using Hive with Hadoop

Environment: Informatica 9.5, Teradata v13,Erwin, Hadoop, BigData, Hive, MongoDB

Confidential

Big Data 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

Responsibilities

• Responsible for Data Architecture, Data Model
• Responsible for ETL development/maintenance
• Responsible for development of SSRS reports including Facility Report Card
• Using Informatica Hparsor Big Data in Amazon Cloud
• Responsible for BigData development using Hive with Hadoop

Environment: Informatica, SSIS, Oracle 11g, Hadoop, BigData, Hive

Confidential

BI Architect / Solution Architect

Responsibilities

• Responsible for Data Architecture, Solution Architecture, Data Model
• Responsible for Business Objects Reports design
• Responsible for Scheduling jobs using Control M.

Environment: Data Stage 8.5, BO XI R3, Control M, IBM DB2, Hadoop

Confidential

BI Architect/ Solution Architect

Responsibilities

• Load Teradata using Mload
• Develop Scripts to load Teradata database using Teradata Utilities
• Develop Reports using Business Objects

Environment: Informatica 9.1, Erwin, Teradata v13, Teradata Utilities, BO XI R3, OBIEE, Hadoop, Netezza

Confidential

BI Architect

Responsibilities

• Developing BI solutions as identified by the Business.
• Working with the Business to resolve project and operational Issues
• Develop, Test and Maintain SSAS Packages, T-SQL stored Procedures
• Develop and Support SSAS Packages to load dimensions, facts into data warehouse using Error Handling, Auditing, Slowly changing dimensions, Data Profiling, Data Cleansing
• Develop and Support SSAS cubes,
• Develop/Support OBIEE Reports, Dash Boards

Environment: Microsoft SSIS/SSAS 2008 , DataStage 8.x, ORACLE 10g/9i, Share Point 2010, Business Objects BO XI R3, SQL, PL/SQL, UNIX.,, Web Services, OBIEE

Confidential

BI Architect

Responsibilities

• Responsible for Performance Tuning of their BI Process in their MDM
• Responsible for Preparing Project Plan
• 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
• Worked with Data Quality, Data Cleansing, Data Enrichment,
• Manage quality through best practices, development standards
• Develop Cognos Project, publish packages using Frame work Manager
• Develop Cognos Reports / Dashboards using Report Studio

Environment: DataStage 8.x, Teradata V12, Erwin, Netezza, ORACLE 10g/9i, Cognos 8.4, SQL, PL/SQL, UNIX., Web Services

Confidential

BI Architect

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
• Develop Reports/Dashboards using Business Objects

Environment: DataStage 8.x, ORACLE 10g/9i, SSAS/SSRS, BO XI R3, SQL, PL/SQL, UNIX.,

Confidential

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

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

Confidential

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.
• Lead internal customers with Requirements definition, Project definition and Project Planning
• Gather Business Requirements
• 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 development of Multi Dimensional Applications and Databases using Hyperion Essbase cubes,
• Responsible to Create Standard Dimensions and attributes, Design outline, Load dimensions and data using Rules File, Calc Scripts, Work with Report Scripts, Backup and Restore data
• 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, Business Objects, BOXI R2, Hyperion Essbase 9.x,, MS Project, SAP BI, Teradata v9, Oracle 10g/9i, Crystal Reports, ERWIN

Confidential

ETL/BI Specialist

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 developing Reports using Business Objects
• 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 ,BO XI R2, SqlServer 2005, Teradata V2 R5 , ORACLE 10g/9i, SQL, PL/SQL, UNIX, MS Project

Confidential

ETL/BI Consultant

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
• 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, Oracle Applications , MS Project, ERWIN

Confidential

ETL/BI Specialist

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, PowerPlay 6.x, TERA DATA V2R4

Confidential

ETL Specialist

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

ETL Specialist

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.