Close to 9 years of experience as ETL/EDW/BI Developer and Lead.Strong SQL & PL/SQL skill.Profound knowledge of Query performance tuning techniques and ef*cient databasedesign & data modeling.Have knowledge of development and testing in Teradata, UNIX, Oracle, Informatica,Business Objects, Perl, Java and Autosys.Teradata Certi*ed Technical Specialist.Good analytical and problem solving skills and good communication skills.Successful track record of ef*ciency & achievement in all assignments; consistentlyprogressed to positions of increasing responsibility. Motivated to learn new concepts and technologies.Have domain experience in Manufacturing, Logistics, Entertainment and hospitality.Teradata trainer for North America region.
Successfully trained around 50 employees on Teradata 14.
Excellent" rating for thetraining provided.Automated SCD Type 1, 2 script generation that helped in reducing development effortby 75%.
Published as white paper for the organization.Introduced design patterns to achieve Push down optimization in ETLs.Served as a leader of Teradata Coding standards and Query optimization team.Teradata Certi.
ed Technical Specialist.
03/2016 to Current
BI/ETL Lead Cognizant Tech Soln － Atlanta, GA
IHG has around 20 % booking revenue coming via reservation of.
The project'scompletion is dependent on successfully bringing all call related data in the warehouse.Working as ETL and BI lead for the CRO projects (Call Reservation of.
ces)6 different aggregates were created in EDW to support call, agent, Hotel and revenueperformance reporting.
Currently the direction from the client is to move towards big data.
Ingesting all calldata.
les into HDFS and creating HIVE tables.
Currently, working on the design.
12/2014 to 02/2016
ETL Technical Lead
Orlando, FLCognizant Tech Soln (Client Disney The project aimed at providing data from the following Disney Parks and Resorts linesof business transaction systems in a data mart for reporting and analytics purposes forAnalytics and Sales Finance team.
Understand the business requirement and work ef.
ciently to deliver the tasks on time.Work closely with the Up-stream Business analysts to understand data source andnature of data, how it is being captured and store in source systems.
Work with DataModeler to understand the Logical and Physical data models and set the rules, de.
neany transformations or derivations that need to be performed to capture on thisincoming information and help store in Data Warehouse, built over Teradata, alongwith capturing the history and maintain versions to help business users in their analysis.Develop the objects; de.
ne logic for Extraction Transformation Load (ETL) process,whether being Teradata objects like (Views, Queries) and Informatica Mappings.
Preparation of the various documents like High Level Analysis and Approach document,High Level Design Document, Detailed Design Document, System test plan and testprocedure document.
Extract data from different source systems (Oracle, Teradata, XML, Flat.
le) move theminto the Warehouse.Walk-through with the end business users /reporting teams after development to helpthem understand how data is being captured and how it can be queried for differentreports and at what grain for different reporting needs.Converted 16 Informatica Workflows (~ 750 mappings) to run using the ETL frameworkthat follows the new reference Architecture guidelines.
Lead Teradata/ETL projects for Subsidiary and Buyouts data integration in FedEx EDW.Performance tuning of legacy ETLs.Automation of data ingestion error restart process.Worked as Techno functional lead, attended Requirement gathering sessions andmeetings.Prepared Source to Target mapping documents.
09/2008 to 02/2014
Technology LeadCupertino, CAInfosys Ltd
Played major role in migration of Apple iTunes reporting from legacy systems (Oracle)to Enterprise Data warehouse (Teradata).Lead the ETL projects in the Sales and Finance area.Worked as BI lead for campaign management.Gather and review requirements with Business users and provide robust & ef.
cient BIsolutions.Understand the data and coordinate with upstream teams to induct data to EDWsystem (using in-house ETL framework) for business reporting.Design, develop and test ETL and database models as per business requirements byapplying performance optimization techniques.Automation of data processing using Unix shell scripting & Autosys.Design and provide architecture for dashboard reporting solutions by coordinating withUX designers & UI developers.Lead the technical team of both database & UI developers and coordinate with team toensure timely & quality delivery.Help.
nance and operations customers group with ad hoc reporting solutions.Implement enhancements for existing applications.Provide warranty support for developed applications.
Education and Training
Master of Science: Information and Communication TechnologyDhirubhai Ambani Institute of Information and Communication Technology － Gandhinagar, Gujarat, IndiaInformation and Communication Technology