SUMMARY:

• Data warehousing and Integration Analyst with a total IT experience of 9.2 years. Strong working knowledge on ETL, Database, and UNIX concepts.
• Widespread experience in SDLC. Right from Requirement gathering, worked in all phases of a project such as Design, Development, Testing, Deployment, Support and Maintenance.
• Business experience with Automobile, Retail, and Banking domains.
• Very good design and development experience in Data warehousing and integration projects.
• Skilled to design the code to deliver high performance, to Improvise ETL job designs, and to tune the SQL queries.
• Worked in multiple versions of ETL datastage (v7.5, 8, 8.5, 8.7, 9.1, & 11.5).
• Got version migration experiences. Worked on 7.5 to 8.5 and 9.1 to 11.5 migration plan.
• Hands on experience in working with IBM CDC, IBM build forge, and samba tools.
• Good experience in creating/documenting data modeling/ER diagrams.
• Apart from IBM DS Client components (Designer, Director, Administrator, & Manager), Used IBM Infosphere Information Server for promoting the code to higher environments.
• Using ETL, handled the data from multiple source systems such as, Oracle, DB2, Teradata, MS SQL, Flat files, Complex flat files, mainframes, SAP, Message queues, excel files, XML files, & etc.
• Created ETL jobs using EoW, and DTS stages that reduces number of jobs and multiple transactions can be committed at once.
• Worked in partitioning oracle tables to handle the huge volume of data processing.
• Got experience in NAS mounting activities at unix server.
• Worked with multiple version control tools like CVS, SVN, MS TFS.
• Got experience with oracle version upgrade activities.
• Followed best practices to monitor the health of the environments by creating PLSQL blocks and purge/compress old or unwanted files using shell scripts.
• Followed best practices in the team such as Peer review, brainstorming sessions to take deep dive on technical concepts, provide/receive suggestions on code designs. Dynamic team player.

TECHNICAL SKILLS:

Tools: /rdbms/gui IBM Infosphere Datastage and Quality stage 11.5, Ascential datastage 7.5, Oracle 12c, Teradata, DB2, MS SQL.

Operating system: Windows & Unix.

Languages: SQL, PLSQL, COBOL, JCL.

Scripting: UNIX Shell Scripting, DataStage Basic Scripting.

Scheduling tools: Control - M, Autosys, CA7.

Other tools: IBM CDC, IBM build forge, and samba.

PROFESSIONAL EXPERIENCE:

Data warehousing and Integration Analyst

Confidential, Dallas, Texas

Tools: IBM Infosphere Datastage 9.1 and 11.5Oracle, Unix, MQ, IBM CDC, IBM Build forge, Samba, Autosys, JIRA

Responsibilities:

• Gathering requirements by meeting up with the business team.
• Discuss the business needs in detail, analyze, and provide estimation for the development.
• Design the datastage jobs to meet the business output in optimized way, using Datastage 11.5, Oracle 12C, MQ, and Unix scripting and load the data from various sources to NAV database.
• Split the activities between onshore and offshore team and discuss the progress, issues, and challenges on daily basis.
• Provide dev team’s update to business team in the scrum call every day.
• Review the code, perform User Acceptance Testing with the business users. Plan and install the changes in production.
• Monitor all data stage jobs and provide production support. Defect fixing and maintain the durability.
• Document all program level and user level processes. Analyze performance and monitor work with capacity planning.
• Coordinate with team members at offshore.

Confidential, Kansas City, Missouri

Tools: IBM Infosphere DataStage 8.7Oracle, Teradata, Unix, DB2, Mainframe, CVS, CA7.

Responsibilities:

• Application works on pure Agile methodology where all the team members works in a same place so that the collaboration between Designers, developers, testers and business team are very high.
• Get the requirement to convert the inventory process from legacy systems (mainframe) to SAP.
• Design the jobs to pull the mainframe data, refer DB2, Teradata databases and create populate data to SAP IDOCs.
• Review, Test, Promote the code to higher environment.
• Do the assessment and get sign off from business to deactivate the legacy process and deploy ETL datastage code in production.
• Provide warranty support. Take care of the deliverables.

Confidential

Hardware IBM Unix Server Operating Systems Windows & Unix

Tools: IBM Infosphere DataStage 8.5Oracle, MS SQL, Unix, Control-M, MS TFS

Responsibilities:

• Understanding Integration Requirements of the customer, developing sample codes, test cases and creating patterns out of them.
• Implementing pattern based development in real time integration project requirements.
• Reviewing patterns and updating with lessons learnt to avoid repeating mistakes.
• Get the requirement from onsite coordinators, work on the changes, split the activities between the team and lead.

Confidential

Hardware IBM Unix Server Operating Systems Windows & Unix

Tools: IBM Infosphere DataStage 8.1, Oracle, DB2, Unix, Autosys, SVN.

Responsibilities:

• Understand the business need to create CRM application.
• Design the ETL jobs for the Data warehouse, and special data mart for ranking the customer of Renault.
• Provide transition to offshore team and assign the activities.
• Explain the various datastage solutions that can solve the business problem and identify the best from alternatives.
• Managing the deliverables. Production deployment. Provide support.

Confidential.

Tools: Ascential Datastage 7.5, Oracle, DB2, Unix.

Responsibilities:

• Understanding the mapping document, creating low level design document
• Developing ETL datastage jobs to pick the data from AS400, Oracle, and file system and to populate the data into new set of Confidential tables.
• Writing unit test cases and test the code.
• Managing the deliverables.