Computer Science Manager

SRAVANTHI DONTU

ETL Developer

+1-551-***-**** *********.*******@*****.***

CAREER OBJECTIVE

I intend to establish myself as ETL Developer with an integrated business solution provider contributing to the company's growth and in-turn ensuring personal growth within the organization.

TECHNICAL SKILLS

Technical skills

:

Informatica Power Center 8.x/9.x, DataStage 8.5, SQL, PL/SQL, UNIX/Linux, C/C++, JAVA/J2EE, JSP, XML, HTML, UML, Data Mining, Agile/ SCRUM, Apache TOMCAT

Tools

:

Informatica Power Center 8.x/9.x, DataStage 8.5, SAP Business Objects XI R2, Tableau 10, Eclipse, NetBeans, RationalRoss, Toad, MS Excel, Access

Databases

:

SQL Server, Sybase, Oracle, Netezza, MySQL, DB2, TeraData

RELEVANT EXPERIENCE

Data consolidation for specialized analytics, NYIT Sep 2015 – Dec2016

Research Assistant

Implemented restart strategy and error handling techniques to recover failed sessions.

Used Unix Shell Scripts to automate pre-session and post-session processes.

Did performance tuning to improve Data Extraction, Data process and Load time. Wrote complex SQL Queries involving multiple tables with joins.

Capital Blue Cross, BCBSA, Pennsylvania, Cognizant Chennai, India

ETL/Reporting Developer, Performance rating- 1st Nov 2013- July 2015

Gathering the requirements as per the design documents & mapping documents given.

Design appropriate Extract, Transform and Load (ETL) strategy to load the data from source to target tables using complex data transformations.

Design and Development of Informatica Workflows in order to migrate and transform the data across various servers (Databases) based on business rules or constraints.

Extensive work on Source Analyser, Mapping Designer, Workflow Manager and Repository Manager.

Implementing the logic of Change Data Capture (CDC) and loading the Staging tables.

Support documentation and perform unit testing.

Defense Research & Development Laboratory Hyderabad, India

Intern(Web Usage Mining) Oct 2012 – Nov 2013

Used Agile Software Development for developing the application and developed Use case diagrams, Object diagrams, Class diagrams, and Sequence diagrams using UML.

Implemented Connection pool object for database connectivity. Worked extensively on regular expression and generated dashboard to view and analyse data.

Used JSF standard validations & JavaScript for client-side validations.

EDUCATION

New York Institute of Technology New York, NY

Master of Science in Computer Science Dec 2016

GPA: 3.52

JNTUH Hyderabad, India

Bachelor of Technology in Computer Science Aug 2009 - May 2013

GPA: First Class with distinction

Achievements: College President

Awards Honors and Certifications

Member of Alpha, Sigma, Pi- The National of Society of Leadership & Success- NYIT, New York

Certificate in Web Component Development Using JAVA Technologies- National Institute of Information Technology

Contact this candidate