Preethi Mohankumar

Address: **** ******** ***** ****** *-mail Address: acfxqo@r.postjobfree.com

Cary, North Carolina - 27513 Phone Number:+1-919-***-****

SUMMARY

Over 4.5 years of professional experience in the IT industry with a strong background in all the stages of Data

Warehousing and Business Intelligence.

Strong hands on experience using ETL tools and methodologies, automation using UNIX shell scripting,

scheduling using Autosys and reporting using Crystal Reports.

Experience in scripting file transfer schedule and writing test cases for Unit and System Integration tests for

ETL environments.

Experience as an SME responsible for liaising in an offshore/onsite business environment and assisting the

development teams with requirement gathering, system analysis, finalizing technical and functional

specifications.

Experience coaching and leading a team of 7, providing a thorough knowledge transfer with clarity and

patience required in a varied onsite/offshore environment.

EDUCATION

Bachelors in Information Technology, Anna University, India Grade: 78% May 2009

TECHNICAL SKILLS

Informatica Power Center 8.6 and 9.0.1, IBM Infosphere DataStage 7.5 and 8.5, Crystal

Tools

Reports 2008, SQL Developer, PL/SQL Developer, WinSCP, Putty

Databases SQL, PL/SQL and Oracle 9i,10g

Scripting UNIX shell Scripting.

Programming C, C++, Java

Testing Unit tests, System Integration tests and User Acceptance Tests.

Operating Systems Windows XP, Windows 7 and UNIX

Other Skills Script File transfer using delivery methods including FTP, SFTP

WORK EXPERIENCE

ADM Architecture - ETL March 2012 – Till Date

Optimized ETL performance by analyzing query performance and debugging the design.

Used shell scripts to automate monitoring and reporting on the health and performance of the ETL servers.

Provide support to ETL application development, UAT and production teams on ETL performance and

environment issues.

Assisted Support, development and application teams in understanding and troubleshooting file transfer

methods like FTP, SFTP and NDM.

Provided support with issues on version compatibility during migration from DataStage 7.5 to DataStage 8.5.

Scheduled DataStage jobs using autosys by invoking the shell scripts written to trigger them.

Provide off-hour support on weekends to backup projects and other components.

Create knowledge base by recording and maintaining ETL software and operational procedures for use during

knowledge transfer.

Responsible for co-ordination and maintaining communication channels between all responsible teams during

feature upgrades and patch installation.

Asset Servicing Technology Reconciliation – Reporting June 2011 – Feb 2012

Developed reconciliation reports using Crystal Reports 2008

Developed SQL queries, packages, functions and procedures in PLSQL Oracle 10g

Developed reusable report templates to standardize and optimize reporting

Involved in optimizing the performance at crystal report end and oracle end as well

Performed unit and system integration test

Provided integrated production support.

Document HLD, LLD and UTC

Asset Servicing Technology Reconciliation - ETL June 2010 – May 2012

Developed Informatica mappings to validate, capture exceptions, enrich and cleanse the data from different

types of sources namely CSV, COBOL, ORACLE, XML and Flat files.

Developed Mapplets to implement business rules that involves complex logic.

Used Informatica Debugger to troubleshoot the correctness of data flow.

Wrote UNIX Shell Scripts to automate file transfers.

Optimized the performance by debugging and eliminating performance bottlenecks.

Perform unit, system integration test and User acceptance testing.

Contact this candidate