Sr Developer & Analyst

KeerthiKiran 972-***-****

Email: ************.*@*****.***

Objective: Looking for the greatest opportunity to work as a Datastage developer for a reputed company.

Summary

Highly motivated and dedicated Datastage Developer with more than six years of experience in providing technical assistance to the development team within a company, who has a deep knowledge of the methods and techniques used in the industry.

Skills:

• Bachelor's degree in computer science.

• Able to communicate effectively regarding to datastage technology concepts.

• Able to work with technical staff, business community and independently also.

• Excellent communication and writing skills.

• Strong multi tasking skills.

• Excellent troubleshooting and analysis skills.

• Able to write SQL loader scripts and UNIX shell scripts.

• Able to handle large volumes of data.

• Excellent ability in designing, testing and coding.

• Able to do various other duties as needed.

• Worked on all phases of data warehouse development lifecycle, from gathering requirements to testing, implementation, and support.

• Exceptional background in analysis, design, development, customization, and implementation and testing of software applications and products.

• Demonstrated expertise utilizing ETL tools, including SQL Server Integration Services (SSIS), Data Transformation Services (DTS), and DataStage and ETL package design, and RDBM systems like SQL Servers, Oracle, and DB2.

• Strong leader with experience training developers and advising technical groups on ETL best practices.

• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.

• Team player with excellent communication and problem solving skills.

• Excellent organizational and communication skills

• Deep knowledge of the methods and techniques used in the industry

• Solid knowledge of data warehousing and ETL processing

• Ability to analyze and design complex data warehouse solutions

• Strong analytical and problem-solving skills

• Ability to work under pressure

• Experience with Oracle, SQL Server, Sybase database systems

Work Experience:

Datastage Developer, Deloitte, Atlanta( Mar 2010-present )

Duties and responsibilities

• Responsible for providing technical assistance to the development team within the company

• Assessed and evaluated computer codes

• Prepared and developed tests on Datastage jobs

• Monitored Datastage jobs

• Provided production support to Datastage jobs

• Designed and analyzed ETL jobs

• Applied a wide variety of complex working techniques and methods

• Analyzed and evaluated the working activities of the company's employees

Datastage Developer, The Fountain Group, Boston(Dec ‘08- Oct 10)

Duties and responsibilities

• Provided technical assistance to the development team within the company

• Collaborated in an efficient manner with the company's staff

• Scheduled and planned Datastage duties

• Responsible for reviewing and analyzing business applications

• Designed block diagrams and flowcharts

• Prepared and implemented creative computer software designs

• Prepared and performed a wide variety of tests of various products

• Handled and maintained data warehouse

• Prepared ETL associate procedures

• Analyzed the performance of the company's programs and applications.

Work Experience

Lead Developer, Broadlane, Oakland, CA ( Feb 2007- Nov2008 )

Reponsibilites

• Design and develop SSIS packages, store procedures, configuration files, tables, views, and functions; implement best practices to maintain optimal performance.

• Train and manage developers, advising other groups in organization on SSIS development, data warehouse development, and ETL development best practices.

• Conduct code walkthroughs and review peer code and documentation.

• Build efficient SSIS packages for processing fact and dimension tables with complex transforms and type 1 and type 2 changes.

• Created system for capturing, reporting, and correcting error data.

• Work with developers, DBAs, and systems support personnel in elevating and automating successful code to production.

• Provide on-call support to production system to resolve any issues.

• Gather requirements and design of data warehouse and data mart entities

Work Experience

Datastage Developer, Common Wealth Bank (Oct 2005-Dec 2007)

Responsibilities:

• Training new PSS team members

• Identify the priority( Critical/High/Low)

• Identify the error using DataStage director

• Involved in find the root cause of the issues to the development team

• Escalation and follow-ups until issue is closed.

• Involved in maintaining and updating the issues in the Run book.

• Resetting the job sequences.

• Find the servers space capacity.

• Prepare Weekly status reports, MOM’s and involved in review of status call

• Involved in Quarterly review of SLA

• Update Issue tracker by daily basis and discuss with application owner if any new issues.

• Create the metrics based on data collected and send it to client.

WORK AUTHORIZATION:

U.S. Citizen

Contact this candidate