Data Information Technology

Shilpa Shivram Naik ******.****.***@*****.***

New York City, NY, USA +1-201-****-***

Title

Sr. ETL Developer

Primary Skills

Informatica Power Center, Oracle-PL/SQL, Unix Shell Scripting.

Location

US-NY-NYC (will consider relocating)

Posted

Jun-26-2017

Profile Summary

• 7 years of IT experience in software analysis, development and implementation of ETL applications using Informatica Power Center, Oracle – PL/SQL, Unix Shell scripting, Control-M.

• Strong understanding in Banking, Finance and Securities domains.

• Profound knowledge in complete life cycle development of Data Warehouse: Data Analysis, Design, Development, Implementation and Testing using Data Extraction, Transformation and Loading (ETL)

• Working Experience in Waterfall model as well as Agile model.

• Expertise in design and implementation of SCD - slowly changing dimensions types (1, 2 and 3), CDC -- Change data capture

• Knowledge in Database architecture for OLAP and OLTP applications to model the snowflake and star schema's and report delivery methodologies.

• Expertise in coding, testing and implementation of SQL Queries and PL/SQL Objects like triggers, stored procedures, functions, packages.

• Experience in UNIX shell scripting and automation of jobs

• Worked with scheduling tools like Control-M

• Hands on experience in Business Objects Reporting Tool.

• Hands on experience in Generating Reports using Excel supported VBA Macros.

• Documentation on Detailed Technical Design, Migration process, Test cases and ETL Run Book.

• Strong experience in Tuning both ETL and Database Objects for better performance.

• Experience in coordinating with cross functional teams and project management.

• Excellent analytical and logical programming skills with a good understanding at conceptual level and possess excellent presentation, interpersonal skills with a strong desire to achieve specified goals.

• Hands on experience in software upgrade projects.

• Hands on experience SCM tools like SVN.

• Strong analytical skills with a knack for problem solving.

• Highly skilled, motivated team player with excellent communication and inter-personal skills

• Ability to work well under pressure and meet deadlines.

• Always ready to do POC’s and Learn new technologies.

Technical skills:

OS : Windows, UNIX,

Languages : SQL, PL/SQL, Perl, Unix Shell scripting, VB scripting

ETL Tools : Informatica Power Center 9.x/8.x

Data Modeling : Dimensional Data Modeling, Star Schema and Snowflake Schema, Erwin

Reporting Tools : Business Objects

Databases Oracle : 11g/10g/8i/9i

DB Tools : Toad, SQL*plus, PL/SQL Developer

Scheduling Tools : Control-M

SCM Tool : SVN, Basic knowledge of GitHub

Professional Experience:

Client: Credit Suisse, New York City, NY

LCDB – Legal and compliance Data-warehouse

Senior ETL Developer

Date: Oct – 13 to till date

Project Description:

Legal and Compliance Database (LCDB) is a data repository, serving data needs for multiple applications in L&C department of bank. The aim of this consolidated database is to provide single repository of transaction and reference data for surveillance, reporting and litigation (legal process activities).

Roles and Responsibilities:

• Responsible for developing and leading team in designing, developing, implementing ETL solutions.

• Created conceptual, logical and physical data models

• Understanding Business Requirements and translate into Technical Specifications for Informatica ETL team.

• Provide technical strategies and suggestion to team on different ongoing developments.

• End to End working and handling of project deliverables

• Understanding Legacy system and providing solutions around implementing strategic solutions.

• Designed, Developed and Tested ETL's using Informatica Power Center 9.5.0 to extract data from the different types of upstream sources, perform operations on data and load the data in warehouse to be distributed to downstream applications.

• Active Involvement in code reviews, process improvements, solution reviews etc.

• Working with Release Management Team / Environment Team for all release related activities.

• Worked along the Informatica version upgrade

• Developed ETL's for masking the data when made available for the Offshore Dev team.

• Developed UNIX scripts for dynamic generation of Parameter Files & for FTP/SFTP transmission

• Resolved many Production issues in an abrupt & timely manner and provided support for the ETL jobs running in Production to meet the SLA's whenever required.

• Analyzed Perl code and translated into Unix shell scripting as per requirements.

• Active Involvement in performance tuning.

• created macros to validate Control-m XML’s for environment specific values.

• Coordinated and interacted with other teams to maintain integrity in performing the tasks and execution of the loads appropriately in a timely manner.

Environment: Informatica Power Center 9.5.1/8.6.0, Oracle 11g/10g, UNIX (Sun Solaris 5.10), Toad 10.0, PL-SQL Developer, Control-M, Excel Macros (VBA code)

Client: Credit Suisse, Pune, India

EXCALIBUR – BI (E2E)

ETL Developer

Date: Feb – 11 to Oct - 13

Project Description:

Excalibur-BI (E2E) addresses the needs of Expense Management group providing detailed information on BC&E (Brokerage, Clearing and Exchange) expenditures at various granularities such as the legal entity, book or business unit, etc. and provides proper accounting and control of BC&E.

Roles and Responsibilities:

• Understanding Business Requirements and translate into Technical Specifications.

• Created High Level, Low Level Design documents, Technical documents for production support team

• Actively Involved in technical strategies and solution designing.

• End to End working and handling of project deliverables

• Active Involvement in code reviews, process improvements, solution reviews etc.

• Worked along the Oracle version upgrade

• Extensively worked on Informatica power center designer, Workflow designer & Monitor and Repository Manager

• Hand’s on experience on complex transformations like handling XML files, Web Services, Normalizer etc.

• Developed UNIX scripts for dynamic generation of Parameter Files & for FTP/SFTP transmission

• Resolved many Production issues in an abrupt & timely manner and provided support for the ETL jobs running in Production to meet the SLA's whenever required.

• Extensively worked on ETL performance tuning for tune the data load using partitions, pushdown optimization. Also, worked with DBAs for SQL query tuning etc.

• Fair amount of knowledge in Business Objects suite like Designer, Web Intelligence, Info View and Desktop Intelligence.

• Coordinated and interacted with other teams to maintain integrity in performing the tasks and execution of the loads appropriately in a timely manner.

Environment: Informatica Power Center 8.6.0, Oracle 11g/10g, UNIX (Sun Solaris 5.10), Toad 10.0, PL-SQL Developer, Control-M, Erwin Data Modelling Tool, Business Objects Reporting Tool

Education / Certification:

Master of Technology (Information Technology), BITS PILANI, India - 2014

B.Sc. (Computer Science), Mumbai University, India - 2010

Thank You.

Contact this candidate