SUMMARY:

• Over Twelve Years of comprehensive and in - depth experience in Information Technology (IT) industry with specialization and expertise in Data Modeling, Normalization, Database Design/Development for OLTP applications and Dimensional Modeling, Data Warehouse Architecture, Data Integration, Data Vault for OLAP / Business Intelligence (BI) applications including Project and People Management.
• Architected Data Warehouse from requirement gathering to conceptualization to creation of data marts using Inmon (Top-Down) and Kimball (Bottom-Up) methodologies.
• Expertise in Data Modeling (Conceptual, Logical and Physical) for OLTP systems using Erwin Tool.
• Expertise in Dimensional Modeling (Star-Schema, Snowflake-Schema), Enterprise Data Modeling, Enterprise Data Warehouse Design, Datamart Design for OLAP systems using Erwin tool.
• Good working knowledge on Metadata, Data Quality, Master Data Management and Data Vault methodologies.
• Strong experience using ETL tools Informatica PowerCenter 9.6, Informatica Data Replicator and DataStage for OLAP cube creation.
• Experience in database programming using Oracle SQL, PL/SQL (Stored Procedures/Functions, Triggers and Packages) and Netezza.
• Worked on data extraction, transformation and loading data from various sources like Relation Database, Saleforce.com and Flat files.
• Implemented Type1, Type2 and Type3 SCD Design Template using Informatica Mapping Visio which reduced the overall development for staging Layer by 60%.
• Worked on Informatica Data Replication (IDR) tools for real time data load between Transactional System and Operational Data Store (ODS).
• Experience in BI tool QlikView for Analytics and Reporting perspective.
• Well versed in implementing the Complex business rules by creating transformations.
• In depth experience in handling Performance and Code Optimization for Informatica and Oracle PL/SQL code.
• Knowledge on Big Data Platform (Hadoop, Sqoop, Hive, Pig).
• Possessing Strong leadership qualities, good influencing, communications, interpersonal, analytics and problem solving skills.
• Proficient in SEI-CMMI and Agile Framework with SCRUM methodologies.
• Excellent team players, ability to work with staff at all levels within an organization.
• Excellent knowledge on Onshore-Offshore model.
• Experience in Software Size Estimation using Function Point, Snap Point & CBE technique.

TECHNICAL SKILLS:

DWBI Tools: Informatica Power Center 9.x, DataStage, QlikView.

Programming Languages: SQL, PL/SQL, C, C++, Java, UNIX Scripting and Python.

Databases: ORACLE 11g/12c, Netezza, MS SQL Server 2005, MS Access.

Big Data Platform: Hadoop, Sqoop, HIVE, PIG, Neo4J Graph Database.

Continuous Integration: Gits, Jenkins, Source Tree, TFS.

Operating System: Windows XP/7, UNIX.

Tools/Utilities: ER-Win, TOAD, Aginity, MS VISIO, MPP, Rally, Remedy, Caliber, Control-M, Cron.

Domain Knowledge: Telecom, Health-Insurance, Manufacturing, Compliance, Finance.

Software Architecture: Object Oriented Design (UML), Data Warehouse Bus Architecture, Agile Technologies, Master Data Management, Data Vault, Metadata Management, Data Modeling, Dimensional Modeling.

PROFESSIONAL EXPERIENCE:

Confidential, Seattle, WA

Lead DWBI Consultant

Environment: and Tools: DataStage, Netezza, VB Scripting, Autosys

Responsibilities:

• Responsible for enhancement of Claim Mart.
• Involved in business analysis and technical design session with business and technical staff to develop requirements document and ETL specifications.
• Working on processing enhancement and redesign for Medicare Advantage ETL process.
• Acquiring New FEP (Federal Employee Program) Data Set for the Integration Layer.

Confidential, Monroe, LA

Project Lead / DWBI Architect

Environment: and Tools: Informatica PowerCenter 9.6, Oracle SQL & PL/SQL, UNIX Scripting, QlikView, Control-M, Erwin

Responsibilities:

• Lead project at various stage from requirement gathering and business rules analysis to creating the Logical data model and physical model, Qlikview reporting
• Developed the Data Warehouse Architect and Dimensional Modeling (Star-Schema) for Revenue Mart, Fleet Management Mart, Provisioning Mart, Dispatch Integration Mart and Call Centre Mart
• Design process flows, deploying and populating staging area objects defining and populating the Enterprise Model Warehouse.
• Developed the different Dimension and Fact related to Service Delivery and Assurance subject area using Informatica Power Center ETL tools.
• Responsible for developing complex mapping (using transformation such as joiner, router, normalizer, sorter, filter, transaction control), Workflow and session.
• Involved in business analysis and technical design session with business and technical staff to develop requirements document and ETL specifications.
• Provided technical team leadership support for the full systems development life cycle (SDLC) Data Warehouse.
• Developed, modified and optimized complex queries for data retrieval and modification
• Responsible for developing and review the BI reports with Business Partner,

Confidential

Environment: and Tools: Informatica PowerCenter 9.1, Oracle SQL & PL/SQL, UNIX Scripting, QlikView, Control-M, Erwin

Responsibilities:

• Architected and implemented facts and dimension for data mart.
• Creation of technical design approach and implementation of data staging
• Developed the High Level, Low Level Design and Data Modeling using ERWIN.
• Used Informatica Mapping Visio to develop the standard ETL template which is reusable for different Mapping, Session and Workflows development.
• Responsible for mentoring and providing solution to the team.

Confidential

Environment: and Tools: Informatica PowerCenter 8.6/9.1, Oracle SQL & PL/SQL, UNIX Scripting, QlikView, WebFocus, Erwin

Responsibilities:

• Architected Prism Warehouse and Data Mart using Top-Down Approach.
• Involved in business analysis and technical design session with business and technical staff to develop requirements document and ETL specification
• Used transformations like Aggregator, Expression, Lookup, Router, Filter, Sorter, Update Strategy and Joiner to transform the source system data as per the business requirements.
• Responsible for creating Business Intelligence report around Cancelled Reason, Disconnect Reason, Call Matrix by age chart using webfocus.

Confidential

Senior Software Engineer

Environment: and Tools: Informatica 8.6, Oracle SQL & PL/SQL, Control-M

Responsibilities:

• Created package, procedure & functions for Data extraction from Eclipse source using Oracle PL/SQL
• Created Informatica Mapping/Session/Workflows for data extraction from VISTA and GYPSY sources using Informatica PowerCenter.

Confidential

Member of Technical Staff

Environment: and Tools: Oracle SQL & PL/SQL, Java Scripting, EPM Platform 3.7

Responsibilities:

• Created Forms and Templates for design module using Java Script.
• Developed workflow for assessment and improvement modules.
• Developed Packages, procedures, functions for all modules using Oracle PL/SQL.

Confidential

Environment: and Tools: Oracle SQL & PL/SQL, Java Scripting, EPM Platform 3.5

Responsibilities:

• Created Forms and Templates for design module using Java Script.
• Developed Informatica Mappings/Sessions/Workflows.
• Developed Packages, procedures, functions for all modules using Oracle PL/SQL.