SUMMARY

• Having 8 years of IT experience in analysis, design, development of ETL Jobs and technical support.
• 5 years in total of Data migration such as B2B and ETL practices.
• 5 years total of automated process migrations: Shell Scripting to Datastage, Java to shell scripting, Informatica to Datastage, Excel Macros to Datastage, SAP BO to Datastage.
• Expert in developing Datastage jobs in Infosphere Information Server Datastage Designer.
• Experience in developing jobs on SAP Business Objects and Informatica Power Center.
• Good Knowledge on Oracle, Netezza, Mongo and Hadoop database.
• Good working knowledge on 3 - tier architecture, Entity architecture and distributed architecture.
• Extensive experience in DB2 Database design, Database maintenance, developing SQL queries, stored procedures, triggers, cursors, indexes, views etc. using Confidential DB2.
• Good working knowledge with designer tools such as Microsoft Visio.
• Good working knowledge in designing Use Case, Class, Sequence diagrams using UML.
• Experience in debugging an application using the debugging tools provided by the Visual Studio and Eclipse.
• Functional domain experience involves Sales & Service and Telecom.
• Good working experience in the life cycle of Software Engineering - Requirement Analysis, Design, Development and Unit Testing.
• Good working experience in the life cycle of Agile & Scrum Development - Requirement Analysis, Design, Development and Unit Testing.
• Worked as customer support for technical troubleshooting and Lead technical customer support teams.
• Effective in communication skills, working independently and collaboratively in teams and meet tight deadlines.

TECHNICAL SKILLS

Databases: DB2, Oracle, Netezza, MongoDB, Hadoop, and SQL

Operating Systems: Windows 7, Windows Xp, Windows 10, Unix, Linux distributions, and AIX

Programming: C, C++, Visual Basic, and Java.

Designing Tools: MS Visio

ETL: DataStage, Informatica Power Center, SAP Business Objects,

B2B Technologies: XML, Rosetta, WebMethods

Methodologies/Tools: Visual Studio 2005, Eclipse, Rational Team Concert, Confidential Data Architect, FIlezilla, Putty,, and Control - M

PROFESSIONAL EXPERIENCE

Confidential, Plano, TX

Squad Lead / Subject Matter Expert / Technical Coordinator

Responsibilities:

• Analyze new requirements provided by the Confidential Global Credit Solution’s team to integrate new processes into the Data Warehouse.
• Plan and create design documents using the Agile tool Rational Team Concert, in order to facilitate reviews and approvals.
• Code requirements using Infosphere Information Server DataStage Designer, the tool also allows code documentation and user control.
• Test the code and document results in Rational Quality Manger validate acceptance criteria.
• Promote jobs to testing and production environments after proper approvals.
• As a Subject Matter Expert, it is important to review developers work in each phase of development. Also serves as a guide for questions answers for specific technologies.
• Investigate impacts on infrastructure changes, for example DB2 Upgrades or DataStage Upgrades.
• Participate and review developers work (design documents, code, Test Cases, and Test execution records).
• Story writer - During some time, I was also required to assist the business team to write stories based on product owner requirements.
• Investigate impacts on infrastructure changes.
• Review and approve data request these are changes to the databases we own.
• Review and approve support request to changes on our ETL framework.

Environment: AIX, Infosphere information Server 11.3, Datastage, DB2 v 9.7 & v11, Shell scripting, SAP Business Objects, Data Integrator Design, Rational Team Concert, Data Studio

Confidential

ETL -Datastage Developer

Responsibilities:

• Analyze and document the current ETL framework in Informatica Power Center for future migration into the Information Server DataStage Designer.
• Analyze new requirements provided by the USAA Property and Casualty team to integrate new processes and previous ETL Informatica processes into the Data Warehouse.
• Plan and create design documents using the Agile tool Rational Team Concert, in order to facilitate reviews and approvals.
• Code requirements using Infosphere Information Server DataStage Designer, the tool also allows code documentation and user control.
• Test the code and document results in Rational Quality Manger validate acceptance criteria.
• Promote jobs to testing and production environments after proper approvals.
• As a Subject Matter Expert, it is important to review developers work in each phase of development. Also serves as a guide for questions answers for specific technologies.
• Investigate impacts on infrastructure changes.

Environment: AIX, Infosphere information Server 9.5, Datastage, DB2 v 9.7 & v11, Shell scripting, SAP Business Objects, Data Integrator Design, Rational Team Concert, Squirrel, Control - M

Confidential

Datastage Developer

Responsibilities:

• Analyze and document the current ETL framework Information Server DataStage Designer for future optimization
• Analyze new requirements provided by the Confidential Revenue and Sales team to integrate new processes into the Data Warehouse.
• Plan and create design documents for the improvements that were found in the previous framework and store these documents using the Agile tool Rational Team Concert in order to facilitate reviews and approvals.
• Code new improvements based on the documented designs using Infosphere Information Server DataStage Designer, the tool also allows code documentation and user control.
• Test the code and document results in Rational Quality Manger validate acceptance criteria.
• Promote jobs to testing and production environments after proper approvals.
• Investigate impacts on infrastructure changes.

Environment: AIX, Infosphere information Server 11.3 - 11.5, Datastage, Governance Catalog, DB2 v 9.7 & v11, Shell scripting, Rational Team Concert, Data Studio, Confidential Data Architect