SUMMARY:

• Certified Scrum Master (CSM), over 16+ years of extensive experience in Information Technology oriented to Retail, Finance, Tax and Telecommunications.
• Highly recognized expertise in Business Intelligence, System Analysis, development and design ETL processes, data modeling and data integrity.
• An energetic and innovative professional with exceptional troubleshooting skills, sense of team, and constantly producing awarded results.
• Managing multiple projects with competing priorities in a fast - pace innovative business environment.
• Gathering, interpreting & converting business requirements into creative solutions & tangible results.
• Hands-on consulting experience in project management; data, operations & technical analysis, technology implementations, change management, training & customer relations.
• 14+ years’ experience at Relational Databases and SQL Query language.
• 9+ years of combined experience designing & developing complex solutions utilizing InfoSphere Information Server version,7.5, 7.3, 8.1, 8.5and 8.7.
• 10+ Developing Global ETL interfaces
• 2+ years’ experience at SAP ABAP and SAP/R3 V. 6.5 & V. 7 to Datastage.
• 7+ years’ experience at Oracle,
• 4+ years’ experience at DB2,
• 2+ years’ experience at SQL-Server,
• 4+ years’ experience at Informix
• 3+ year experience at teradata.
• 1+ year experience at Cassandra
• 1 year experience at Data Integrator.
• 6+ years experiences at Waterfall Methodologies
• 4+ years experiences at Agile Scrum Methodologies

TECHNICAL SKILLS SUMMARY:

ETL Tools: Datastage 7.3, 7.5, 8.1, 8.5 & 8.7, Data Integrator

ETL Packs: SAP/R3 V. 6.5 & V. 7 to Data stage and Data Integrator.

Languages: SQL, PL/SQL, UNIX, Shell Scripting korn and bash, Perl, SAP ABAP, Datastage Basic, Stored Procedures

Database: DB2, Oracle, Informix, Teradata, SQL Server, MySql, SAP.

OS: Unix HP, Unix Solaris, Unix AIX, Linux Suse, Windows xp, vista, 7, NT, Server.

Tools: SQL*Loader, SQL * PLUS, SQL Developer, Workflow 2.6, SQL Developer, TOAD, PL/SQL DBvisualizerSAP GUI, Erwin4.0, Confidential -Tools (Lotus Note, Lotus Live, etc), Brio, Filezilla, Changeman, Version One.

Methodologies: ITIL, Scrum, Kanban, XP, POD & Waterfall.

PROFESSIONAL EXPERIENCE:

Scrum Master

Confidential, Pleasanton, CA

Responsibilities:

• Collaborated with worldwide virtual project team working in Canada, United States, Philippines & Mexico
• Developed and design ETL jobs in Datastage.
• Unblocked all impediments the team has
• Coordinated and review standards for the ETL jobs
• Implemented the test case to move a QA.
• Participated at the Development the IDD and IRD documents
• Identify risks that should be included at the backlog and sprint planning
• Maintain focus on priority goal of ensure projects are on time and the quality expected and meeting customer expectations each sprint.
• Identify risks that should be included at the backlog and sprint planning
• Involved at the code deployment to QA and Prod via Changeman.
• Agile tool has been used to monitor progress and take corrective action.
• Supervise a team of 5 direct reports.
• Used at Scrum Methodologies

Languages: SQL, Korn Shell, AWK.

Tools: Changeman, Version One, Informix, Oracle, Teradata, Filezilla, DataStage 8.7, Putty, Word, Power Point, Link Communicator, Windows 7.

OS: Windows 7, Confidential AIX.

Scrum Master

Confidential, Pleasanton, CA

Responsibilities:

• Collaborated with worldwide virtual project team working in Canada, United States, Philippines & Mexico
• Developed and design ETL jobs in Datastage.
• Unblocked all impediments the team has
• Coordinated and review standards for the ETL jobs
• Implemented the test case to move a QA.
• Participated at the Development the IDD and IRD documents
• Identify risks that should be included at the backlog and sprint planning
• Maintain focus on priority goal of ensure projects are on time and the quality expected and meeting customer expectations each sprint.
• Involved at the code deployment to QA and Prod via Changeman.
• Agile tool has been used to monitor progress and take corrective action.
• Supervise a team of 5 direct reports.
• Used at Scrum Methodologies

Languages: SQL, Korn Shell, AWK.

Tools: Changeman, Version One, Informix, Oracle, Teradata, Filezilla, DataStage 8.7, Putty, Word, Power Point, Link Communicator, Windows 7.

OS: Windows 7, Confidential AIX.

Scrum Master

Confidential, Pleasanton, CA

Responsibilities:

• Manage Multiple Projects that were focused on development of ETL, Java and Testing.
• Manage worldwide virtual project team working in Canada, United States, Philippines & Mexico implementing customer loyalty technology program for Confidential supporting the culture change to lean and agile engineering practices.
• Estimate work effort and calculate the resources needed for ETL work
• Lead reviews for non-functional requirements such as performance tuning and capacity
• Coordinated the migration of Data stage Job in Prod Server
• Unblocked all impediments the team has
• Coordinated and review standards for the ETL jobs
• Implemented the test case to move a QA.
• Participated at the Development the IDD and IRD documents.
• Identify risks that should be included at the backlog and sprint planning
• Maintain focus on priority goal of ensure projects are on time, within budget, to quality expected and meeting customer expectations.
• Utilize tools such as Microsoft Project Server & SharePoint web tools to monitor progress and take corrective action. Steer the project to motivate a successful agile team effort
• Participated in Coaching Agile
• Supervise a team of 22 direct reports at multiple scrum teams
• Agile Scrum, POD, XP & Kanban Methodologies

Languages: SQL, Korn Shell, AWK.

Tools: Changeman, Version One, Informix, Oracle, Teradata, Filezilla, DataStage 8.7, Putty, Word, Power Point, Link Communicator, Windows 7.

OS: Windows 7, Confidential AIX.

Scrum Master

Confidential, Pleasanton, CA

Responsibilities:

• Collaborated with worldwide virtual project team working in Canada, United States, Philippines & Mexico
• Estimate work effort and calculate the resources needed for ETL work
• Lead reviews for non-functional requirements such as performance tuning and capacity
• Coordinated the migration and conversion of ETL scripts to Datastage.
• Unblocked all impediments the team has
• Coordinated and review standards for the ETL jobs
• Implemented the test case to move a QA.
• Identify risks that should be included at the backlog and sprint planning.
• Participated at the Development the IDD and IRD documents.
• Maintain focus on priority goal of ensure projects are on time and the quality expected and meeting customer expectations each sprint.
• Involved at the code deployment to QA and Prod via Changeman.
• Agile tool has been used to monitor progress and take corrective action.
• Worked hand to hand with the customer at the backlog reviewing and to the primary goals to develop each sprint.
• Supervise a team of 5 direct reports
• Agile Scrum & Kanban Methodologies

Languages: Informix SQL, Shell Scripting, AWK.

Tools: Visio; Changeman, Version One, Informix, DataStage 8.7, Filezilla, Putty, Word, Power Point, Link Communicator.

OS: Windows 7, Confidential AIX.

Sr. BI Specialist

Confidential, Bentonville, AR

Responsibilities:

• Developed Global Interface Metrics
• Developed Global Interface Log Remedy
• Developed Global Quick Reference Guide
• Developed a new FTP script to send files to server TW
• Used Data Stage Designer components extensively to design the Parallel jobs in accordance with business specs
• Developed the test case documentation
• Created a complex script shell to extract the log of Datastage
• Created a system control to validate the status of process and rerun the interface
• Gave Unix Training for Walmart Latam.
• Used Full Life Cycle development
• Used at Waterfall Methodologies

Languages: SQL, Korn Shell, Perl, Basic Datastage.

Tools: Teradata, Confidential DB2, DataStage 8.1, Putty, Word, Power Point, Filezilla, Microsoft offices communicator 2007, Reflection FTP, DbVisualizer 8, Citrix, Windows 7.

OS: Windows 7, Linux Suse.

ACCOMPLISHMENT:

• Implemented Metric global interface & handle a huge data for Walamart Latam to US, MEX, CL, ARG, CN & BR.
• Implemented Employee and Employee Transfer Global interface.
• Implemented Log Remedy Global Interface.

Senior ETL Developer / Datastage

Confidential, Arkmon, NY

Responsibilities:

• Involved in Extraction Transformation and Loading (ETL) processes using Confidential DataStage (Parallel) DB2 Tables
• Participated in the optimization and troubleshooting ETL
• Developed routines according to the requirement of the process
• Set global variables in the new servers
• Used Datastage Designer components extensively to design various Parallel jobs in accordance with business specs
• Worked with SAP ABAP stage for the extraction and processing of data
• Developed Test case and documentation
• Participated in forums Liquid Player
• Reverse engineering of code Acta to DataStage
• Gave training in Datastage for Team India and New York
• Used Agile Scrum Methodologies.

Languages: SQL, SAP ABAP, Acta Script, Basic Datastage.

Tools: DB2 7.2 SQL; DataStage 8.5 & Datastage 8.7, B.O. Data Integrator, SAP/R3 V. 6.5 & V. 7, Filezilla, Word, Power Point, Confidential -Tools (Lotus Note, Lotus Live, etc), Brio.

OS: Windows 7, Linux Suse, Windows Server.

Senior ETL Developer / Datastage

Confidential

Responsibilities:

• Participated in the optimization and troubleshooting ETL
• Developed shell scripts to validate, automate and schedule
• Used Datastage Designer components extensively to design various Parallel jobs in accordance with business specs
• Developed PL/SQL for implementing Complex business rules and loaded data more of 1000 million rows
• Developed shell scripts to run in parallel to rebuild indexes
• Designed table structure for Oracle and developed Source to target Mappings
• Used FTP stages to send files between servers, applying all the rules of information security
• Used Waterfall Methodologies

Languages: Oracle PL/SQL, SQL, Shell Scripting, Basic Datastage

Tools: MS-Project; Visio; Oracle 9i and 10g; PL/SQL; Stored Procedures and Triggers; Packages; DataStage 7.5 Server, Shell scripts, Toad for oracle, SSH.

OS: Windows XP, Unix Solaris.

Tech Lead ETL / Datastage

Confidential

Responsibilities:

• Involved in Data Modeling activities
• ETL tool developing (DataStage)
• Prepared Integration and system level testing scenarios
• Developed, executed, monitored and validated Unix ETL jobs
• Completed documentation of analysis and project plan
• Developed shell scripts to run in multiple interface.
• Involved in Data model activities to Oracle
• Involved in process automatization of multiple ETL, related to homologate the fields that comes from different data source.
• Using Shared Container to repeat some business rules required in various processes.
• Used Waterfall & Scrum Methodologies
• Supervised a team of 5 direct reports

Languages: Oracle PL/SQL, SQL, Shell Scripting

Tools: MS-Project; Visio; SQL Server 2008, Oracle 9i/10g; PL/SQL; Datastage 7.5 Server and 7.5 Enterprise, Shell scripts, SSH.

OS: Windows XP, HP-UNIX, Linux SUSE.