**** ****** ** ************ * N 408-***-**** / https://goo.gl/JRaRFN

Apt 235, Fremont CA- 94555 acue8r@r.postjobfree.com An experienced Big Data Engineer, ETL architect and DWH Consultant with 9+ years of experience in various Data Warehousing engagements across Technology and Retail domains

Robust work expertise in architecting end-to-end solutions with flair in designing DWBI engagements

Utilized the following Big Data technologies for Usage and Fraud Data Warehouse: Hadoop (Pig, Oozie), AWS - S3 and Redshift

Experience architecting highly scalable, distributed systems using different tools as well as designing, optimizing processes in the Hadoop and Informatica ecosystems

Excellent understanding of database concepts and writing PL SQL, SQL query tuning and performance tuning of queries

Explored most of warehouse tools like Informatica Power center, SSIS, SSAS, SSRS, ODI, OBIEE

Most of data exercise has been pulling data from XML and JSON events to SQL Server, Oracle and DB2 sources

Experience in Parsing XML and JSON events, APIs to flat DB tables in Oracle/AWS - S3 using Python libraries/modules

Explored most of UNIX commands and python libraries/modules which helps to automate DB tables archival to AWS - S3

Proficiency in SDLC and Agile processes and act as scrum lead to deliver user stories Employment

Senior Software Engineer 2 Citrix Systems Inc, CA Feb'14 – Present Mobility Apps - Data

Automated of Commerce engine jobs which was great milestone for Citrix online division which adds value to track KPIs daily instead of monthly - Reports were delivered to Executives and Sr Staff on Net New business on every day

Architectured, designed and Implemented Customer care data mart

Implementing Hadoop ecosystem for large warehouse using Hadoop (Pig, Oozie), AWS - S3 and Redshift

Parsing XML and JSON events using RabbitMQ, APIs to flat DB tables in Oracle/AWS - S3 using Python libraries/modules

Working on redesign and feature enhancements

ETL Architect and Developer Cox Communications, GA Oct'13 – Jan'14 One Cox BI

Impact analysis and created technical specifications document based on the functional specifications

Designed and implemented Informatica jobs

Performance optimization solutions for Oracle DB and ETL – Informatica for efficient data loading and data retrieval strategies

Developed UNIX Shell Scripting for File handling like archival, purging and processing using SFTP protocol Solutions Architect McAfee Inc, CA Oct'12 – Oct'13 McAfee Data Platform

Performance optimization solutions for Oracle DB and ETL – Informatica for efficient data loading and data retrieval strategies

Creating technical specifications document based on the functional specifications

Acted as an Onshore Team Lead for Migration Project DB2 to Oracle

Worked on impact analysis, design and implementation for source migration project

Involved in implementing MDM BI for McAfee warehouse system and data integrating with SAP through SAP connectors Sr ETL Consultant and Admin McAfee Inc, India Jan'10 – Sep'12 McAfee Data Platform

Identified design issues and bugs in the Informatica jobs and recommended fixes and solutions

Worked on Integration, Platform testing and provide support for QA Developed DDL for table partitions (dynamic), views, materialized views, stored procedures and DML for data correction and historical Loads

Prepared technical specification documents based on functional requirements

Worked on Administering Informatica, DAC, OBIEE like Installations, configuration and security accesses

Provided conceptual, logical and physical data model solutions for the data warehouse model

Developed UNIX Shell Scripting for File handling and SFTP file transfers

Worked in DAC scheduler for Informatica jobs and PL\SQL procedures

Fine tuned the complex ETL’s to minimize overall ETL load timings

Designed and developed Informatica ETL and PL/SQL procedures, Unit Testing of Informatica ETL’s and PL/SQL procedures

ETL Developer Wal-Mart, India Dec'08- Dec'09

Wal-Mart Enterprise BI

Analysis of the existing DW model and requirements gathering about the new products Designing of the solutions and creating design documents

Designed and developed of SSIS Jobs and Created Oracle store procedures/packages and PL\SQL Scripts

Provided Technical and Design solutions and created Technical Specifications Documents to the developers Successfully implemented the changes and showed significant performance Improvements ETL Developer Kohl’s Corporation, India Apr'07 – Nov'08 Kohl's DWBI Platform

Worked in Dimensional modeling for a new customer centric data mart for business reports in SSRS

Maintenance of existing data warehouse, data marts and enhancements to business processes

Analyzed data for validation and inconsistencies and suggest changes and provide solutions for process and query optimization

Developed SSIS Jobs and create Oracle store procedures and PL\SQL Scripts, Bug fixes issue resolution & Enhancements Skill Set

Databases: SQL Server 2005, 2012, Oracle 10g and 11g, Oracle PL/SQL, DB2, Postgres, Redshift

Programming Languages and Scripting: Python, Core Java, UNIX scripts

Big Bata: Hadoop, Pig and Hive

Data Warehousing Expertise: Informatica Power Center 8.x, 9.x, DAC, OBIEE, MSBI – SSRS, SSAS, SSIS, ODI 11g

Source control and Methodologies: GIT, SVN, Agile & Waterfall model. Academics

Kongu Engineering College Anna University Tamil Nadu, India (2002 - 2006) Bachelor of Engineering

Achievements

Above And beyond Award’ in Q1 2011 for outstanding performance in Cognizant India.

Best project of Year award while working as a Cognizant Consultant in McAfee Inc.

Standing Ovation award for successful of Commerce Engine Automation process in Citrix Systems Inc. References

Available on request

Contact this candidate