Analyst

SUBHASHREE BALU *****, Kittridge street, Reseda-**335

**************@*****.***

Contact No: +1-747-***-****

PROFESSIONAL ABRIDGEMENT

6+ years of Experience in IT Industry.

4+ years of relevant Healthcare experience.

Scaled up as a Lead in short span.

Provided solutions to technical issues, and are responsible for meeting development schedules and ensuring the delivered solution meets the technical specifications & design with quality and also a Mentor to junior team members.

Experience in handling resource scheduling, planning, change and project initiatives.

Strong analytical, problem solving & organizational abilities.

Sound knowledge in the DW/BI development projects which involves Analyzing Business Requirements/Functional Specifications, coding, testing and implementation of projects with full Software Development Life Cycle.

Experience in Agile and Waterfall methodology

Proficient in ETL Design and Development using Informatica, Teradata, Netezza, Oracle, IDQ.

Solid Experience in code optimization to increase the Informatica performance.

Good knowledge in tuning SQL queries to increase the DB performance.

Experienced in creating, maintaining and executing Test plans, Test cases, and defect tracking.

Conducted training sessions on Informatica, IDQ, Teradata and Netezza.

Completed World-Class Infosys Training in Business Intelligence (MSBI), SQL server and Oracle with a CGPA of 4.97 out of 5.

A dynamic, innovative, reliable, self-motivated person and a good team player who is passionately committed to produce best results

EXPERIENCE

Cognizant Technology Solutions 05/14 - 02/17

(Associate)

Project:

ROLE : Technical Lead

CLIENT : BCBS- New Jersey (Horizon)

TECHNOLOGIES : Informatica 9.6, Teradata, UNIX

This project involved Member, Provider and Pharmacy Claims where I led few modules.

Took the primary responsibility of understanding the project requirements, designing the project according to business requirements, implementing the decided design, Unit testing for implemented code according to the business test cases and reviewed code

Worked on optimizing the implemented code to process huge volumes of data by tuning queries and using Push down optimization

Used various scripts, look up transformations and different data flow tasks in designing the ETL packages.

Responsible for the Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse.

Proactively did a POC on HL7 file conversion to XML using Informatica B2B and implemented in project.

Published white paper on the topic ‘HL7 file understanding and its conversion using Informatica.

As part of Innovation, created a Data validation framework using IDQ and added Business Value to my project by presenting it in front of clients.

Infosys Limited 12/10 - 05/14

(Senior System Engineer)

Project#2 (Jul’12-May’14):

ROLE : Sr. ETL Developer

CLIENT : Bank of America.

TECHNOLOGIES : Informatica 9.1, Netezza, Oracle, Autosys

Worked as a Lead and drove the team to constantly evolve and use latest business logics to meet the client expectations.

Interacted directly with client for requirement gathering and Analysis.

Developed ETL and IDQ code for Quality checks of the data.

Had an experience in Informatica code migration from 9.0 to 9.1.

Developed Netezza and Oracle scripts for enhancement.

Project#1 (Dec’10 – Jul’12):

ROLE : ETL Developer

CLIENT : WellPoint Inc.

TECHNOLOGIES : Informatica 9.1.0, Teradata 12.0.1, UNIX, WLM

Worked in the development part of Provider area.

Extensively learnt and worked on ETL coding and BTEQ scripts as a beginner.

EDUCATION

GRADUATE:

California State University, Northridge, CA. GPA :4

Master of Engineering Management (from Spring’17)

UNDER GRADUATE:

Sona College of Technology, Anna University, India May 2010 GPA : 4.2

Bachelor of Engineering in Electronics and Communication Engineering

TECHNICAL SKILLS:

ETL Tool

Informatica 9.1/9.6, Informatica Data Quality, Informatica B2B, SSIS

Database

Teradata, Netezza, Oracle

Reporting

SSRS, Tableau

Scheduler

WLM, Autosys

CERTIFICATES

Microsoft BI SQL server and .net.

Big Data certification offered by IBM.

Tableau 9.0 (from Lynda)

ACHEIVEMENTS

Rank holder both during my high school and college.

Received ‘Quick learner of the year’ award at Business Unit (Analytics & Information Management) level in Cognizant.

Received Excellence award at Business Unit level during my tenure in Infosys.

Got various appreciations from client delivery leads for the excellent & on time project delivery.

Published White papers and innovative ideas in I-space

Winner of Hackathon competition where we were asked to display various Innovation Projects.

Have implemented innovative ideas in project which was considered as Business value adds and in turn helped to get new projects from client.

Contact this candidate