OBJECTIVE:

• To understand the business objectives of the customers and build BI/DW solutions that would help them plan and measure the performance of their businesses to drive desired outcomes.

SUMMARY:

• 14+ years of experience in implementing and managing the DW/BI solutions using bus and hub and spoke architectures
• Strong experience in logical and physical data modeling to design facts, (conformed) dimensions, summary tables, snow flake schemas and normalized models
• Proficiency in ETL design and development using Informatica Power center 10.1/9.6/8.x/7.x
• Extensive knowledge in Oracle 11g/10g/9i and application of SQL, PL/SQL in the design and implementation
• Hands on knowledge on the BI tools: Tableau, OBIEE and Business Objects XIR3/XIR4
• Hands on experience on data profiling, standardization, parsing, matching and consolidation using Informatica data quality tool
• Knowledge on MDM concepts and implementation using Informatica MDM tool
• Experience in designing and implementing the security requirements for cons user access
• Ability to create shell scripts for automating the ETL jobs
• Ability to create test scripts for the data validations and analysis
• Strong communication skills with the ability to concisely and effectively communicate across teams
• Very good at understanding requirements, planning work streams, monitoring the progress, driving the teams and managing the expectations of the stake holders.
• Gave internal s on Data modeling and Tableau, and groomed many team members while working along with them in the projects.
• Got trained on the Big data technologies:Hadoop,Pig,Hive,Hbase,Spark and MangoDB

TECHNICAL SKILLS:

Databases: Oracle 11g/10g/9i, DB2 UDB, Teradata (trained)

Data modeling tools: ER Studio, ERwin

ETL tools: Informatica Powercenter 10.1/9.x/8.x, OWB 10g, Informatica IDQ 9.6Informatica MDM 9.6

BI Tools: Tableau 10.x/9.x, OBIEE 10g, Business Objects XIR3/XIR4

Database access tools: SQL Developer, AQT, TOAD

Big data: Hadoop, Pig, Hive, Hbase, Spark, Mango DB (Trained)

Operating Systems: UNIX, Windows

Scheduling Tools: Control - M, Appworx

PROFESSIONAL EXPERIENCE:

Confidential, Schenectady, NY

Data architect

Responsibilities:

• HR Analytics provides with an up-to-date HR data to drive decision making and establish a single source of reliable HR dashboards to deliver consistent metrics quickly and have a better line-of-sight over the spend on Human Capital.
• Various metrics that HR Analytics supports are Headcount, Forecasted headcount, Churn, Attrition, Compliance, Diversity, Workforce summery, Spans Layers, and Finance planning and analysis.
• Requirements gathering, data modeling, ETL design, test cases preparation, Tableau data source creation / changes, security implementation, team coordination and user communication.

Environment: ER Studio 10, Informatica 10.1/9x, Tableau 10x/9x, Oracle 11g and UNIX

Confidential, Niskayuna, NY

Data architect

Responsibilities:

• GE GRC is research center for GE, which carries various research projects across different businesses. And they have Oracle apps (called FACTS) system for maintaining their finance data related to the various research projects.
• The data warehouse application consists of four data marts: BPM, Salestat, HR and CFOA. Except HR, other three data marts source data from FACTS and for HR the source data files are received from the Corporate HR data warehouse.
• The objective of all these data warehouse is to cater the reporting requirement for tracking various financial metrics like budget, funding, revenue, cost, cash flow, estaffing data, head count, etc. in various report forms in Business Objects: dashboards, project icons, and detailed reports.
• Requirements gathering, data modeling, ETL design, test cases preparation, handled the impact of database/OWB tool upgrades, team coordination and user communication.

Environment: ER Studio 8.5, Oracle 11g Oracle warehouse builder 11g, Business Object XIR3,WinScp,Putty,SQL developer

Confidential, MN

Data warehouse architect

Responsibilities:

• GE Fleet BI is a 6.5 Terabyte data warehouse catering the reporting needs of the GE Fleet internal and external customers. The main subject areas of this data warehouse include
• Fleet (Customer), Asset, Billing, Finance, Ordering, Sales, Supplier, Telematics, Personal mileage and Remarketing.
• The objective of this project is to baseline the existing data warehouse environment in terms of data modeling, ETL, Reporting and Infrastructure.
• The main focus is on documenting the existing system and providing the customer with recommendations that help them take decisions to improve their data warehouse environment.
• Worked with the data architect, ETL architect, BI architect to study of the existing system, document them and proposed solutions to address the pain areas.

Environment: ERstudio 8.5,Oracle 10g, Informatica 7.1.3, Business Object 6.5

Confidential, Shelton, CT

Data warehouse architect

Responsibilities:

• Confidential DWH has a loading instance (for loading the data) and a reporting instance (for reporting) and follows a database swapping mechanism for refreshing the reporting instance from loading instance.
• This demands to load two days’ worth of data and limits the ability to load a source multiple times and is inflexible to load any source any point of time.
• The objective of this project is to re-architect the existing DWH application to overcome the limitations (Loading two days’ worth of data for the incremental loads, not having the flexibility to refresh the reporting area from the loading area, etc.).
• The customer is looking for a solution that will make their DWH application flexible and scalable for the future addition of sources and data growth.
• Evaluated various options to refresh the data in reporting instance from the loading instance with a flexibility to refresh the data subject area wise without down time to other subject areas, executed POCs and proposed the best out of the evaluated options.

Environment: ERstudio 8, Oracle 10g, Informatica 8.6, Business Object XI R2, UNIX

Confidential, Shelton, CT

Data modeler / Project lead

Responsibilities:

• The objective of this project is to establish a reporting mechanism for the North American EUS (End User Services) program by integrating the level-2 data from all the GE helpdesk systems (There are total 5 helpdesks systems in GE).
• This data is necessary to build a baseline of consumption as well as provide opportunities for service improvements.
• Requirement analysis, data modeling, ETL designing, BI design, Security implementation, unit testing, UAT support and user communication

Environment: ERstudio 7.6, Oracle 10g, Informatica 8.6, Business Object XI R2, UNIX

Confidential, Shelton, CT

Data modeler / Project lead

Responsibilities:

• This project is to re-design the existing data warehouse and enhance by integrating the GE help desk data of its various businesses like Healthcare, Commercial finance, etc.
• This involves the reporting and dashboard metric interface for analyzing the helpdesk incident data in the data warehouse.
• Resolving the data issues, load performance and designed the solution for integrating the data from other sources.

Environment: ERstudio 7.6, Oracle 10g, Informatica 8.6, Business Object XIR1, UNIX

Confidential, St. Louis, MO

Onsite Team lead

Responsibilities:

• This project is for building and maintaining the data warehouse for Confidential health networks, which is a health insurance organization. This houses the data related to the, Claims, Provider, Capitation and Revenue subject areas.
• The main sources for this warehouse include mainframe and oracle. The data from the mainframe and oracle sources is extracted to files. These files are loaded to the data warehouse through the ETL process.
• Incorporating the data model and ETL changes/enhancements to implement the new requirements. Addressing the data issues and load performance issues.

Environment: DB2 UDB, Informatica 7.1.1, ControlM, AIX and AQT

Confidential

Team lead

Responsibilities:

• The project is to build a process for processing and storage of the files received from BP's ERPs covering 80 countries and 4 types of feeds: invoices, AR, master data and un-invoiced deliveries.
• The target files are transmitted to the eBilling application (Optus).
• The system is implemented to have the facility for updating the control information with status of the various tasks in the system Error capturing and reporting, Backing out the data and purging the data.
• Designed and implemented the ETL code for invoice subject with error capturing and reporting capabilities.

Environment: SQL Server 2000, Informatica 7.1.3, Windows 2003

Confidential, Atlanta, GA

Developer

Responsibilities:

• Confidential BI Data warehouse consists of 85 data marts, each for different subject areas that provides required information to the Confidential management for decision-making.
• Around 10000 users access this data warehouse. This project is one of the few data warehouse implementations that have won the by TDWI for the best practices followed.
• ETL code development, ETL load monitoring, BO reports refreshing and publishing, User communication in case of any load or report refresh issues.

Environment: Oracle 8i, Business Objects 5.1, Informatica 6.2.2, Windows 2000 Professional, Sun Solaris