Seema Lal

LinkedIn- https://www.linkedin.com/in/seema-lal-6563b714/

SENIOR ETL CONSULTANT

Saint Louis, MO 63132, US

213-***-****

adjkie@r.postjobfree.com

PROFESSIONAL SUMMARY

Technical Lead with 12+ years of industry experience in Data Warehousing, ETL, Informatica PowerCenter 9.6 and 10.1, Oracle PL/SQL and UNIX shell scripting.

Oracle Certified Associate (OCA) in PL-SQL/SQL. Worked with Cursors, triggers, procedures, functions, packages, bulk load, handling exceptions, autonomous transactions along with performance tuning (using partitioning and materialized views).

ETL designer and developer for data load scripts for Datamart using Informatica PowerCenter. Performed ETL testing, data load monitoring and performance tuning for loads.

Worked on UNIX scripts to automate the data loads.

Data modelling using Erwin tool and change tracking using JIRA.

Agile development experience in the team as a developer and Scrum master. Worked on estimating requirements, tracking sprint progress and delivering to product owners with retrospective meetings.

Exposure to SAFe methodology and CI/CD development.

Have working experience in geographical regions UK and India and with US clients.

EXPERIENCE

NorthWest Mutual, USA Infosys Technologies — ETL Dev Release Lead

Dec 2016 – July 2017

Worked as Technical lead and Scrum Master for ETL application development and managing a team of 8 developers.

Moderator for Sprint planning, daily stand up and Sprint Retrospective meetings.

Tracked the sprint progress with burndown charts and sprint backlog.

Responsible for Sprint Release and Sprint reviews with team.

Informatica Technical Lead for the team.

Worked on informatica xml transformations to parse and load data in datamarts.

Analysis for bottlenecks in data loads and performance tuning for work load and mapping.

British Petroleum, Infosys Technologies, UK — Senior ETL Consultant

Jul 2013 – Nov 2016

Worked as ETL Consultant for supporting BAU enhancements for ETL applications for finance department of Integrated Supply & trading department within BP.

Business analyst for few datamarts designed to maintain the data quality across different systems in organization.

Involved in technical design sessions with business and technical staff to develop data model & ETL specifications using Informatica PowerCenter.

Involved in Regulatory reporting and publishing of required data through web service transformation of Informatica to regulatory organization (ICE).

Underwriters Lab (UL), Infosys Technologies, Bangalore — Technology Lead

May 2009 – Jun 2013

Worked as ETL Consultant for UL Datawarehouse and Tech lead for development of Engineer Scheduler Engine, work assignment tool for UL.

Involved in business analysis to gather requirements.

Define Architecture approach & created Integration Strategy based on the Requirements.

Involved in technical design sessions with business and technical staff to develop data model & ETL specifications.

Involved in providing technical guidance and direction for ETL (Extract, Transform, Load) project design to the development team and ensure documentation is produced using defined methodologies.

Involved in Organization’s Data Warehouse Performance Improvement Initiatives.

Extensively worked in PLSQL for designing and development of Engineer Scheduler Engine, work assignment tool for UL.

Elsevier, Infosys Technologies, Bangalore — PLSQL Consultant

Jul 2008 – Apr 2009

Worked as PLSQL Consultant for data migration and ETL scripting along with Unix scripting and data loads using Oracle external tables,

LexisNexis, Infosys Technologies, Bangalore — Analyst

Feb 2008 – Jun 2008

Worked as analyst for Website development. Page Designer application is used to handle the request for lawyer’s website from lawyers’ firms using HTML, CSS and JavaScript.

Xoserve, Wipro Technologies, UK, Bangalore — Analyst

Mar 2004 – Jan 2008

Worked as Java and PLSQL Analyst in UK and India to develop and support the gas transmission system application in UK.

Developed complex PLSQL scripts to handle the huge number of transactions using cursors and Bulk load methods.

Performance tuning for PLSQL scripts.

Support for Java/J2EE application and oracle database

SKILLS

Agile Development

Data Modelling

Data Transformations & Cleansing

Process Improvement

Strong Client & Stakeholder Management

Team Leadership

Training & Mentoring

INDUSTRIES

Utilities – Gas, Petroleum

E-publishing

TECHNICAL SKILLS

Highly proficient in SQL, PLSQL, Informatica PowerCenter

Experience of working with data quality tools like Dataflux

Exposure with Erwin for data modelling

Hands on experience with Unix scripting and task commands.

Worked in Oracle Reports, Oracle Advanced Queuing, Oracle External tables.

Exposure to JIRA and Autosys

EDUCATION

Bachelor of Technology – Information Technology 1999-2003, Guru Gobind Singh Indraprastha University (Delhi, India)

CERTIFICATIONS

Oracle Certified Associate (OCA) with 96%

Contact this candidate