Livecareer-Resume
Jessica Claire
  • Montgomery Street, San Francisco, CA 94105
  • Home: (555) 432-1000
  • Cell:
  • resumesample@example.com
Summary
  • 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 efficient database design & data modeling.
  • Have knowledge of development and testing in Teradata, UNIX, Oracle, Informatica, Business Objects, Perl, Java and Autosys.
  • Teradata Certified Technical Specialist.
  • Good analytical and problem solving skills and good communication skills.
  • Successful track record of efficiency & achievement in all assignments; consistently progressed 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.
Skills
  • Teradata
  • Informatica
  • SyncSort
  • Oracle
  • UNIX
  • Core JAVA
  • AWK, 
  • Business Objects
  • Big Data, Hadoop
  • Data Warehousing
  • ETL
  • Business Intelligence
  • Reporting
  • Advance SQL
  • Performance Tuning
  • Dimension Modeling
  • ​Strong analytical skills
Accomplishments
  • Successfully trained around 50 employees on Teradata 14. "Excellent" rating for the training provided.
  • ​Automated SCD Type 1, 2 script generation that helped in reducing development effort by 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 Certified Technical Specialist.
Awards
  • Third Prize in Mobile Application Development Competition 
  • Infosys Star Award 2012
  • FedEx On the Spot Award 2014
Experience
BI/ETL Lead, 02/2016 to Current
Marsh & Mclennan Companies, Inc.Walnut Creek, CA,
  • IHG has around 20 % booking revenue coming via reservation offices. The project's completion is dependent on successfully bringing all call related data in the warehouse.
  • Working as ETL and BI lead for the CRO projects (Call Reservation offices)
  • 6 different aggregates were created in EDW to support call, agent, Hotel and revenue performance reporting. 
  • Currently the direction from the client is to move towards big data. Ingesting all call data files into HDFS and creating HIVE tables. Currently, working on the design.
ETL Technical Lead, 11/2014 to 01/2016
Worldgroup Careers MwtDetroit, US-MI,
  • The project aimed at providing data from the following Disney Parks and Resorts lines of business transaction systems in a data mart for reporting and analytics purposes for Analytics and Sales Finance team. 
  • Understand the business requirement and work efficiently to deliver the tasks on time.
  • Work closely with the Up-stream Business analysts to understand data source and nature of data, how it is being captured and store in source systems. Work with Data Modeler to understand the Logical and Physical data models and set the rules, define any transformations or derivations that need to be performed to capture on this incoming information and help store in Data Warehouse, built over Teradata, along with capturing the history and maintain versions to help business users in their analysis.
  • Develop the objects; define 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 test procedure document. 
  • Extract data from different source systems (Oracle, Teradata, XML, Flat file) move them into the Warehouse.
  • Walk-through with the end business users /reporting teams after development to help them understand how data is being captured and how it can be queried for different reports and at what grain for different reporting needs.
  • Converted 16 Informatica Workflows (~ 750 mappings) to run using the ETL framework that follows the new reference Architecture guidelines. No change in the SLA.
Teradata technical Specialist, 02/2014 to 10/2017
Syntel Inc (Client FedEx)City, STATE,
  • 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 and meetings.
  • Prepared Source to Target mapping documents.
Technology Lead, 08/2008 to 01/2014
Infosys Ltd (Client Apple)City, STATE,
  • 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 & efficient BI solutions.
  • Understand the data and coordinate with upstream teams to induct data to EDW system (using in-house ETL framework) for business reporting.
  • Design, develop and test ETL and database models as per business requirements by applying performance optimization techniques.
  • Automation of data processing using Unix shell scripting & Autosys.
  • Design and provide architecture for dashboard reporting solutions by coordinating with UX designers & UI developers.
  • Lead the technical team of both database & UI developers and coordinate with team to ensure timely & quality delivery.
  • Help finance 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 Technology, Expected in 2008
Dhirubhai Ambani Institute of Information and Communication Technology - Gandhinagar, Gujarat
GPA:
  • Applied Statistics
  • Information Security
  • Computer Graphics
  • Algorithms
  • Graph Theory
  • Database
Technical Skills
Teradata Expert 9 2017
Oracle Good 9 2017
UNIX Good 9 2017
Business Objects Good 7 2017
Core Java Good 9 2017
AWK, PERL Good 9 2017
Tableau Basic 2 2017
Hadoop Basic 3 2017
SyncSort Basic 2 2017
Certifications
  • Teradata 12 Basics (TE0-121)
  • Teradata 12 SQL (TE0-122)
  • Teradata 12 Physical Design and Implementation (TE0-123)
Additional Information
  • Work Permit - H1B Visa
  • Citizenship - India
  • Gender - Male
  • LinkedIn Profile - https://www.linkedin.com/in/Jessica-Claire-a2a06367/

By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy

Disclaimer

Resumes, and other information uploaded or provided by the user, are considered User Content governed by our Terms & Conditions. As such, it is not owned by us, and it is the user who retains ownership over such content.

How this resume score
could be improved?

Many factors go into creating a strong resume. Here are a few tweaks that could improve the score of this resume:

70Average

resume Strength

  • Measurable Results
  • Personalization
  • Target Job

Resume Overview

School Attended

  • Dhirubhai Ambani Institute of Information and Communication Technology

Job Titles Held:

  • BI/ETL Lead
  • ETL Technical Lead
  • Teradata technical Specialist
  • Technology Lead

Degrees

  • Master of Science

By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy

*As seen in: