SUMMARY

• 10 years of IT experience as Data Engineer in Data - Modeling Architecture (OLTP, OLAP), Confidential Web Services, Big Data (using AWS, Hadoop, Hive), Cloud (Workday, Aws, ADP), DataWarehousing ETL, and BI Reporting.
• Certified Project Management Professional (PMP), Lean Six Sigma Yellow Belt (LSS YB), Scaled Agile Framework (SAFe) Practitioner (SP), Oracle Certified Specialist (OBIEE Architect), with over 10 years of extensive experience in implementing Enterprise scale Programs and Projects for Big 4 and Fortune 50 companies (IT Services, HealthCare, Banking domains) and various State Clients.
• Expert in Big Data technologies using Confidential S3 file-system, Confidential Web-Services (AWS), Elastic Map-Reduce (EMR), Hive, Elastic Data Exchange (EDX) manifests, Redshift, and Oracle. Implemented Big Data Platform using all the above technologies at Confidential in the Big Data Technologies (BDT) team.
• Extensive competency on Data Architecture patterns (Logical, Physical, Conceptual data-models for Star-Schema/Snowflake), Data-Warehousing, BI Reporting Platforms, and Workday HCM Architecture.
• Integration of complex data-models with Enterprise data-models adhering to Organization Standards.
• Expert in designing various transaction-based, and analytical-based data-models, and designing the conceptual and logical models to business stakeholders, and management, and physical data-models for the database and datawarehouse implementations.
• Expert in designing data-security, Slowly Changing Dimensions (SCD), and historical data storage.
• Expert in preparing the Data-Dictionary for any RDBMS in Erwin or Embarcadero (ER Studio).
• Established various Metadata management, Data Quality (Cleansing) and Data Governance Patterns for various State, External, and Internal-IT Clients.
• Proficiency in HCM and Payroll Cloud using Workday SaaS (Software-as-a-Service) and Reporting in Workday/Workday Studio, and WD RaaS (Reports-as-a-Service).
• Worked closely with DBA’s in deploying the physical data-models, and various ETL, BI, and MDM teams in implementing the DataWarehousing, Reporting, and Master Data Management solutions.
• Designed various OLAP Cube structures, tabular data-models, Power Pivot, Power BI Reports, and Dashboards.
• Expert in Project Management, Change/Release Management (Request for Change processes), Cut-Over planning, UAT Lead including Sign-offs/Release communications.
• Expertise in Software Development LifeCycle (SDLC), and expert use of Agile and Traditional Waterfall methodologies for various project and business environments.
• Expertise in working with Project Sponsors, and various Key stakeholders at various Organization levels.

TECHNICAL SKILLS

Big Data: Confidential Redshift, Confidential S3, Confidential Web Services AWS, HadoopEnterprise Data Lake, Hive, EMR (Elastic Map Reduce), Elastic Data Exchange

Data-Modeling: ERWin 8.1/7.3.2, OLTP, OLAP, Star-Schema/Snowflake Modeling

BI/Reporting: OBIEE 11.x/10.x, QlikView, Tableau, Cognos, SSRS, Workday Reporting

Informatica: Master Data Manager, Data Quality/Cleansing, PowerCenter - R, D, W, M

ETL: Informatica 9.6.1/9.5/9.1/8.6 , MS SSIS

RDBMS: SQL Server 2012/2008/2005 , Oracle 11g/10g/9i, Teradata, SQL*Plus, SQL, PL/SQLSQL*Loader, Toad, ANSI SQL

Microsoft Technologies: SSRS, SSIS, ASP.NET 3.5, VB.NET, SSAS

Cloud: Workday HCM, Payroll (Reporting, Integrations), Benefits, Compensation

Programming Languages: VB.NET, C, Java, Prolog, Scheme, Lisp

Scripting, Tools: HTML, XML, XSD, WSDL, SOA, UML, Canonical design, NoSQL

Integrations: MuleSoft, Workday, ESB (Enterprise Service Bus)

Operating Systems: Windows 7/VISTA/XP/2003/2000, Linux.

MS OFFICE: MS Project, MS Excel, MS Word, MS PowerPoint, MS OneNote

PROFESSIONAL EXPERIENCE

AWS Data Consultant

Confidential, Seattle, WA

Responsibilities:

• Implemented the Andes Big Data Platform at Confidential to migrate all BOOKER tables (2000 e-Commerce tables that contain all of Confidential ’s data in Enterprise DataWareHouse) using Confidential S3 file-system, Elastic Map-Reduce (EMR), Elastic Data Exchange (EDX) manifests, Redshift, and Oracle.
• The Enterprise Data Lake EDL in Andes being the Source of record now handles ~10k Downstream feeds to various customers.
• Migration of legacy Oracle tables to a massively parallel processing columnar-based Confidential Redshift platform.
• Migration of Load and Extract Profiles in ETL Manager ( Confidential ’s Internal ETL Tool) to move all the ETL Batch Processing from Oracle to EDX (Elastic Data Exchange).
• Implementation of Enterprise Data Lake using Confidential S3 file-storage system, and data-delivery through Subscription based delivery model to customers/users.
• Implemented the Andes Big Data platform (robust metadata platform for analytics experience for customers) to provide rich metadata to various Confidential Internal Business Customers.
• Enabled Subscriptions to the datasets available in Andes that provides real-time updates to the datasets as soon as they are made available.
• Responsible for the maintenance of BOOKER Schema in Oracle and Redshift, that is the driving dataset for Confidential ’s analytics and derivative dataset production.
• Provided a secure way of storing bulk datasets across Confidential in Confidential S3-backed storage system called EDX (Elastic Data Exchange) that provides fast and easy management of data-storage, access, and movement.
• Design and development of various Workflows among data sources supporting Oracle, Redshift, and EDX.
• Used Datanet (ETL Manager) to create various ETL Workflows, dependency management, and Alerts to extract and load data from/into Oracle, Redshift, and PostgresSQL.
• Developed technical design documentation for all the above design and architecture principles related to Oracle, Redshift, Andes platform, EDX, and migration from Oracle to Redshift Program.

Sr. Big Data Engineer/Technical Project Manager

Confidential - Plano, TX

Responsibilities:

• Data Architect at Confidential Enterprise Services (HP ES) for two of the most significant IT Assets - Cloud Workday SaaS and hpHUB (HCM, Payroll).
• Design and documentation of Logical and Physical Enterprise Applications (OLTP design), and DataWarehouses (OLAP design), deployment of physical data-models in Oracle, SQL Server, Teradata (depending on the application) and creating the ETL Design Specifications documents.
• Used Informatica Data Quality for Data-Profiling, Cleansing, and Standardization activities. Developed various Workflows and Mappings for Data-Quality, and designed RESTful Web-Services (API’s) to expose HR Data.
• Communication of various OLTP, OLAP designs to a range of technical, non-technical, and third-party stakeholders.
• Designed the end-to-end architecture for transaction-based model HR Data Delivery (HRDD), a subscription-based online data ordering system.
• Expertise with Big Data (Hadoop Data Lakes), Master Data Management MDM, Data Visualizations, ETL, and OLAP for structured, and unstructured data.
• Designed the logical and physical data-models for HRDD+, and deployed the physical models to SQL Server 2012 to prepare the schemas for the data-loads.
• Publication and distribution of HR and Payroll data-models and Data-Dictionary to various stakeholders, and integration of the Cloud data-model changes into Enterprise data-models.
• Expert in dimension-modeling (Star-Schema, Snowflake), along with Slowly Changing Dimensions (SCD’s).
• Performed a wide variety of in-depth data-analysis, data modeling on complicated datasets with complex data integration scenarios.
• ETL Operations lead managing daily/weekly/monthly data-loads from Workday-to-OLTP Data Store-to- OLAP DWH’s.in Oracle and Teradata for various modules.
• Exceled as Liaison among the Biz, Technical, and Shared Services Platform teams.
• Created Schemas and taxonomies for maintaining quality master data reference after identifying data from various sources, cleansing, transforming, and repairing the data (through quality thresholds) using Informatica MetaData Manager, and Data Quality.
• Used various Oracle and Teradata System tables and logs to retrieve the metadata stored in the schemas.
• Identified various Source Systems (Workday, Fieldglass, Polaris, BIW, etc.) that provide master data for the Operational Data Store, and designed processes to produce One version of Master Data truth.
• Successfully migrated from Legacy Global Payroll to ADP for various countries (others in progress now as per Waves) after obtaining functional requirements, and translating functional requirements into technical requirements, Design, Development, SIT, UAT, successful MtP (Move to Production), and Support.
• Modules migrated include OTP (One-Time Payments), eAwards (from BIW to ADP), eBenefits, WDMD (Workday Master Data), etc.
• Successful delivery of various Inbound, and Outbound Integrations to-and-from Workday to various HP Internal (Global Real Estate, BI WorldWide, ADP, Freedom, Taleo) and External (ADP, Polaris, Fragomen, BIW, GRE) Vendors using Data Stores created in Oracle and Teradata.
• Data Analysis of HR data using Tableau for analytical reports and dashboards. Created Dashboards in Tableau for HR Business Partners on Workforce Management, Taleo Reporting.
• Led and managed globally dispersed HP ETL Development and testing teams of 25 people based in US, Mexico, India, Malaysia, China, and Singapore.

Data-Architect/Integrations Workstream Lead

Confidential - Plano, TX

Responsibilities:

• Lead Data-Architect for HR/Payroll IT team, and designed and implemented the Subscription-based Data-OLTP Ordering System called HRDD (HR Data Delivery).
• Lead Data-Architect in the design of OLTP DB’s for HRHUB and PayrollHUB, and OLAP Data-marts/DWH for HRBI (HR Business Intelligence).
• Design, development, and maintenance of Confidential - Confidential ’s Human Resource and Payroll Domain Enterprise Data Models (HR EDM).
• Led and managed team of Data Experts in integrating the Workday Data-Models into HP Enterprise Data-Models.
• Design of various data-models for Oracle as well as Microsoft BI Stack, and deployment of Physical models into various RDBMS’s.
• Developed and presented training materials - dataflow diagrams, conceptual data-models, UML diagrams, Entity Relationship (ER) diagrams to a wide variety of stakeholders.
• Single Point of Contact on the IDS (Integrated Data Store) PeopleHUB OLTP architecture and data-loads done using SSIS and Informatica.
• Expert in design and development of various HR Self-Service and Manager based eLetters using WD Reports, RaaS, and Workday Studio.
• Expert Hands-On experience on Workday Reporting, Inbound/Outbound Integrations and WD RaaS (Reports-as-a-Service).
• Successful implementation of Workday at HP for 270k+ employees, HCM data replacing the legacy PeopleSoft HR systems.
• Led the Cross Workstream (Workday, Integrations, Analytics, respective Business teams) meetings and resolved issues and ensured smooth transitions among the AMS/EMEA/APJ teams during Workday Cut-Over activities.
• Partnered with various Business (HCM, Compensation, Benefits, Talent Management, and HRIS teams), Technical, Functional teams and experts to derive viable solutions for the WD implementation.
• End-to-end knowledge on PeopleSoft HR Systems that include ADP, Payroll, One-Time Payments, SCS Locations, Account Codes, Cost-Centers, etc.

Environment: Workday HCM SaaS, Erwin 8.1, SSIS, Informatica 9.6.1/9.1, OBIEE 11.1.1.3, Oracle 11g, TOAD, Tidal, SFTP, Workday Studio, EIB’s, Scrum methodology, Agile Manager, HP ALM (Application Life-Cycle Management), DB2

Confidential, Trenton, NJ

Sr. Data Engineer (OBIEE, Informatica)

Responsibilities:

• Design of various transaction-based and analytical-based data-models for various Customer, Vehicles, Titles, Registrations (CVTR) modules for the State of New Jersey.
• Designed the Master Data Schema for Master Data Management of Dimension tables for the State of NJ.
• Proficient business knowledge in DMV’s Legacy systems and the new application and data modules.
• Designed processes for Master Data Management (MDM), and Data-Governance.
• Developed Project plans for Data/ETL design and development deliverables and schedules using MS Project.
• Managed and planned project budgets and schedules by laying out On-site/Off-shore Resource models.
• Successfully planned, managed, and delivered various project deliverables to meet and release significant pay-points from the client.
• Developed various Informatica Workflows and Mappings to load data into Oracle DataWareHouse and Data-Marts, and designed various RPD’s and Reports (with drilldown capabilities) in OBIEE for various customer requirements (on Customers, Vehicles, Titles, Registrations modules)
• Implemented Data-level (row-level) Security for various Users on various OBIEE Reports.
• Expert in Change management and Risk management processes by following RFC’s (Request for Change) and Risk/Issue logs.
• Responsible for the development of complex data-models for the implementation of transaction processing and data-warehouse in Oracle 11G for various MVC modules.
• Responsible for the migration of Customer data from Legacy Mainframes to Oracle 11G Dev/UNT/Prod database schemas using Informatica 9.1.0
• Responsible for designing master data management processes for maintaining the reference value data in tables by maintaining the same in a master schema in Oracle.
• Responsible for forward and reverse engineering of different logical/physical data-models and databases.
• Responsible for the modification of different data-models for performance optimization.

Environment: ERWin 7.3.2, Oracle 11G, Toad, SSIS, SQL Server 2012, Informatica 9.1.0, OBIEE 10.1.3.3, IBM CQ, IBM QuickPro, Java/JSF, Hibernate, Spring, Webflow, DB2.

Confidential

ETL Lead/Architect

Responsibilities:

• Responsible for the migration of data from Legacy New-Mexico database to the target SQL Server 2008 database of the modernization project.
• Development of various mappings and workflows in Informatica for the migration of data from Legacy to the SQL Server 2008 target database depending on the transformations involved for various DMV modules.
• Database Design: Responsible for the design of Database (tables and their associations, Stored-Procedures) for various DMV transactions (List Sales transaction, National Motor Vehicle Title Information System (NMVTIS) Unsolicited, and NMVTIS General Inquiry transactions, etc).
• Expertise in using SQL Server Profiler tool on the developed transactions for the analysis of Target (SQL Server 2008) tables and developing Scripts for migration accordingly.
• Responsible for the development of Re-conciliation scripts to check the count of migrated records from the Source in the Target using SSRS.

Environment: Microsoft Visual Studio 2008, Sequel Server 2008, OBIEE 10g, Sequel Server Integration/Reporting Services (SSIS/SSRS), Business Intelligence Development Studio, JIRA, Windows XP/2003.

Confidential, Jacksonville, FL

Oracle Business Intelligence Consultant

Responsibilities:

• Performed Dimension modeling, identified Fact & dimension Tables to store business attributes.
• Analyzed, designed and developed Analytical metadata repository as per data requirements.
• Developed various interactive Dashboards/Reports with drill-down.
• Imported various Sources, created Targets and Transformations using Informatica Power Center Designer.
• Configured & published Delivers/iBots to deliver analytics content based on schedule, automated iBot queries to obtain daily & weekly transactions by Emails.
• Developed many Mappings using various Transformations (Update Strategy, Router, Expression, and Aggregator) for extracting, transforming and loading the data.

Confidential

ETL/BI Analyst/Developer

Responsibilities:

• Involved in gathering and analyzing the user requirements in coordination with the business.
• Developed analytical repository using Siebel Analytics Admin Tool (importing database object into physical layers, defining logical objects that includes dimensions & facts in BMM layer and presentation catalog in Presentation Layer).
• Developed many Reports using different Analytics views (Pivot Table, Chart, and Column Selector), dynamic/interactive Dashboards with drill-down capabilities, charts, and tables using global and local filters.