Jessica Claire
Montgomery Street, San Francisco, CA 94105 (555) 432-1000,
Professional Summary
Over 8.5 years of professional experience in software development and production support across various domains. Strong programming skills in UNIX, Windows- Batch scripting & Powershell scripting. Extensive experience with ETL tools like Ab Initio, Data Stage & Informatica Power Center. Currently working in Informatica Cloud, Data Stage and Veeva CRM as Data Integration Lead. Proficient in analyzing, design, development and translating business requirements to technical requirements. Worked as On-shore DI integration lead in two stints of a month each.
  • Operating System: HPUX, AIX, Windows
  • Languages: UNIX shell scripting, Perl, Windows Powershell & Batch scripting
  • Tools: WinScp, Tivoli, Control-M, Toad, Clarify, BMC Remedy, FileZilla, 7zip,
  • Winzip, Informatica Cloud
  • Databases: Oracle, Teradata, DB2, MySQL
Work History
01/2016 to 09/2016 Data Integration Lead Caci International Inc. | Aurora, CO,
  • Worked as a Data Integration Lead & ETL developer.
  • Requirement gathering, HLD & LLD, System Test Performance documentation.
  • Designed, built, tested and deployed scalable, highly available and modular software products.
  • Code review, Unit Testing.
  • Automation of the ETL processes- end to end.
  • Major skills involved- Informatica Cloud, Veeva CRM, Windows, MYSQL, Data Stage, Oracle DB 

02/2015 to 01/2016 Lead ETL Developer Adp | Fort Collins, CO,
  • Application Management & Support of Business critical Commercial Data Management Platform used by Sales & Marketing Teams at Otsuka.
  • Systems supported by Genpact included CRM Platform (Veeva) as well as backend MDM and DW systems and related interfaces (based on Informatica Cloud and Datastage)
  • Lead ETL developer handling Otsuka Atlas off-shore production support.3.
  • Enhancement of existing production support processes.
  • Automation of production support processes.
  • Environment : Informatica Cloud, Veeva CRM, Windows, MYSQL

09/2013 to 02/2014 Senior ETL Developer Epam Systems Inc | , ,
  • Informatica Project: ECCR-ECCA migration Description: The project involves migrating data from legacy ECCR systems to new normalized ECCA tables.
  • The project also involves third line support for producition and QA environment.
  • Role: 1.
  • Develop informatica mappings and sessions to retrieve data from various sources.
  • 2.
  • Apply business logic and transformations in the code.
  • 3.
  • Provide swift resolution to any production/QA issues with the help of the operations team.
  • 4.
  • Supervise code migration from dev to QA and production.
  • Environment : Informatica Powercenter 9.5, Unix, Oracle.
12/2012 to 08/2013 Senior ETL Developer | , ,
  • DS Compliance Reporting Description: The project invloves retrieving data from various sources(Tera Data, DB2, MYSQL etc) and developing an optimized ETL solution using Informatica to make data available for Business Objects processes which cater to the needs of the end clients.
  • These reports are either static or on demand.
  • The project also involves third line support for producition and QA environment.
  • Role: 1.
  • Develop informatica mappings and sessions to retrieve data from various sources.
  • 2.
  • Apply business logic and transformations in the code.
  • 3.
  • Provide swift resolution to any production/QA issues with the help of the operations team.
  • 4.
  • Supervise code migration from dev to QA and production.
  • Environment : Informatica Powercenter 8.6, Unix, Tera Data End Client: Western Asset Management.
01/2011 to 10/2012 Senior Ab Initio Developer | , ,
  • WAM ARM Offshore Development Description: ARM Offshore team supports Western Asset's global fixed-income operations by Headstrong Jessica Claire Page 2 of 5 receiving real time data from various sources like Bloomberg, Morgan etc.
  • using cutting edge ETL applications like Ab Initio Continuous flow graphs and BRE.
  • Role: 1.
  • Preparing LLD from HLD and requirement docs.
  • 2.
  • Development & maintenance of Ab Initio graphs.
  • 3.
  • Creating UNIX shell scripts.
  • 4.
  • Creating autosys jobs to schedule Ab Initio graphs & Psets.
  • 5.
  • Unit testing, defect resolution.
  • 6.
  • Third line Support.
  • Environment : Ab Initio, BRE, Continuous Flows, UNIX, Autosys, Oracle End Client: Standard Life PLC November.
to Data specialist | , ,
  • Standard Life Solvency II Description: The Solvency II Directive is an European Union directive that codifies and harmonizes the EU insurance regulation.
  • It is based around the need for European Insurers to calculate their solvency according to international rules, evaluate and manage their risk and report on solvency to the local regulators.
  • Standard Life Group along with other European Insurers will need to adhere to the Solvency II directive.
  • Role:.
  • Involved in the preparation of detailed design from functional specification.
  • Involved in the development and build.
  • Producing LLDs for each process, graph and psets created.
  • Manual testing of graphs and psets developed.
  • Creation of automated test harness using Ab Initio plan.
  • Providing weekly code walk-through to the clients.
  • Bring new team members up to speed with the project requirements and also from Ab Initio perspective.
  • Environment: Ab Initio GDE v3.0.2, co>op v3.0.1, Plan>IT, AIX, Oracle, DB2, HP QC.
08/2010 to 10/2011 Ab Initio Developer Epam Systems Inc | , ,
  • Project: ADIR Reporting Description: The project started off as a PoC in which it was required to prepare and provide business users with predefined and ad hoc reports from data that is stored in raw XML format in one of the Data warehouses.
  • The ad hoc queries would be submitted by the end user via a thin client and run against the normalized data stored in the form of ICFFs.
  • As part of the PoC the raw data is to be extracted from the native database and loaded to the test environment using Fast Export.
  • This is parsed to Ab Initio graphs which would prepare the ICFF database and also prepare the predefined and scheduled reports for business users.
  • Role:.
  • Involved in source to target mapping and the preparation of detailed design jointly with a team from Ab Initio Corporation.
  • Documentation of the end-to-end process.
  • Prepared housekeeping and scheduling scripts using Shell scripting to make the daily reports available to the business users.
  • Performed manual testing of the developed graphs and plans.
  • Performed code handover and transition to the development team at the completion of the PoC.
  • Environment: AbInitio (GDE version 3.0.2, Co>Operating System V3.0.2), AIX, TWS, Teradata, MS Access.
12/2009 to 05/2010 Production Support and Maintenance Executive Luxoft | , ,
  • CMLS Production Support and Maintenance Description: Visa Inc.
  • is the world's largest payments company, with more than US$3.34 trillion of business conducted on 1.4 billion cards as of March 2007.
  • Visa cards are accepted at more than 27 million merchant outlets and 1 million ATMs worldwide.
  • Visa facilitates global commerce through the transfer of value and information among financial institutions, merchants, consumers, businesses and government entities in more than 170 countries and territories.
  • CMLS is the core group entrusted with overseeing the batch load of data for all VISA transactions throughout the world.
  • Role:.
  • Worked as a Level 3 analyst in this project.
  • Responsible for enhancement and maintenance of production graphs and unit testing of the graphs before providing turnover to QA.
  • Responsible for running and monitoring daily production jobs through JCL and UNIX based upon various standard input files from different VISA groups/applications.
  • Running weekly cycle as well as monthly cycle jobs and generating daily and weekly reports covering the status of jobs.
  • In the event of a failure in production reporting, debugging and rerunning the job, fixing the issue by creating and running ad-hoc graphs maintaining the ticket SLA.
  • Coordinating during GIFS Maintenance window, Server upgrade activities during weekends.
  • Environment: AbInitio (GDE version 1.14, Co>Operating System V2.14p109), AIX, IBM Mainframe - JCL, DB2, IBM Rational ClearCase and ESP.
12/2009 to 05/2010 Production Support Executive & ASG Almo Corporation | , ,
  • Project: BATCH CMF TSR Migration Description: BATCH CMF TSR Migration, a strategic system for BT, which came into being as part of TSR Migration Ofcom's regulations to bring all Telecom Service at par as part of the EMP (Equivalence Management Platform) strategic platform.
  • It is entrusted with the migration of all BT data from old stack (legacy system) to new stack (normalized tables) to facilitate provisioning and raising orders.
  • As part of EMP strategic platform all of BT and its CPs are to be migrated from WLR2 to WLR3 to provide a common interface for placing orders and fault reports for all Openreach products.
  • This includes receiving data from other components and loading it to Siebel Databases as per the TSR mandate using UNIX shell scripts and Ab Initio graphs within a stipulated time window in batches.
  • Role:.
  • Analysis to find root cause for fall outs and failures.
  • Training new entrants in the team to get acquainted with the project.
  • Modifying existing graphs for performance improvement and to fix errors.
  • Developing ad-hoc Ab Initio graphs as per customer request and requirements.
  • Writing UNIX shell scripts for automating process, file system monitoring and smooth running of applications.
  • Ensuring deployment of new codes successfully in live by liaising with clients and development teams of all the interface systems.
  • User requirements understanding and analysis of the same for providing permanent solution.
  • Responsible for training new members of the team in Ab Initio and Unix.
  • Environment: AbInitio (GDE version 1.14, Co>Operating System V1.14), HPUX, Siebel, Clarify, Control-M.
11/2016 to Current Datawarehouse Support Lead Infosys Ltd | City, STATE,
  • Leading the Enterprise Data Ware house support team
  • Major technologies involved- Informatica, Teradata, Oracle, Unix, PL/SQL.
  • Data research and analysis for end-user issues.
  • Daily incident review to find permanent fix for recurring failures.
  • Drafted comprehensive reports to document bugs and design flaws.
  • Collaborated with developers and environment engineers to enhance supportability and identify performance bottlenecks.
  • Developed code fixes and enhancements for inclusion in future code releases and patches.

Expected in May, 2007 Bachelor of Engineering | Electrical and Electronics Manipal Institute of Technology, Manipal, GPA:
Electrical and Electronics
Additional Information
  • Excellent communication & interpersonal skills, self-motivated, quick learner, team player & problem solver. Holding H1B visa- valid till 22 August 2018.

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


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:


resume Strength

  • Length
  • Personalization
  • Target Job

Resume Overview

School Attended

  • Manipal Institute of Technology

Job Titles Held:

  • Data Integration Lead
  • Lead ETL Developer
  • Senior ETL Developer
  • Senior ETL Developer
  • Senior Ab Initio Developer
  • Data specialist
  • Ab Initio Developer
  • Production Support and Maintenance Executive
  • Production Support Executive & ASG
  • Datawarehouse Support Lead


  • Bachelor of Engineering

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

*As seen in: