PROFILE:

• Knowledgeable Senior Lead ETL Developer skilled in data collection, analysis, management, technical leadership, communication and presentations.
• Self - directed leader who fosters a collaborative and supportive team environment.
• Works well under pressure and consistently meets deadlines and targets while delivering high quality work.
• Experienced in full project life cycle from design to implementation to integration.

TECHNICAL SKILLS:

• IBM DataStage(ver9.1, ver 11.5)
• Agile Methodologies
• Control-M
• Unix
• DB2
• Oracle
• SQL Server
• Teradata
• Business Objects Data Integration
• Business Objects Universe and Web Reports
• Test Drive Automated ETL Testing
• Hadoop BigInsights and Hortonworks
• E3 Framework
• RTC(Rationale Team Concert)
• Urban Code Deploy
• GitLab

PROFESSIONAL EXPERIENCE:

ETL Technical Lead

Confidential

Responsibilities:

• Utilizing technical expertise on DataStage; creates system requirements, performs design and analysis, and coding and unit testing of complex to highly complex system functionality and/or defect correction across multiple platforms
• Identifies ideas to improve system performance and impact availability. This includes revisiting old DataStage code to refactor them to the new standards.
• Acts as a technical resource throughout the development life cycle. The resource is responsible for completing the end to end ETL(Extract, Transform and Load) process using DataStage. Maximizing the Unix environment for job configuration, using Control - M to schedule the job flows and making sure all the required access/requirements to different Database platforms are in places before production migration.
• Facilitates root cause analysis of system issues to minimize impact and future occurrences. The resource is expected to fix issues in production which means resources will be given production access to the DataStage Environment, Unix and Databases. The resource is expected to have a good understanding on how to use PasswordSafe since the company is utilizing this to control how the Production environment is being utilized.
• Keeps managements appropriately informed of progress and issues. The resource is expected to have knowledge on how to use RTC(Rationale Team Concert) which the company is currently utilizing to monitor resource tasks/deliverables.
• Typically serves as a resource to the business. The business partners are the one that determines what needs to be delivered to support the analysis/reporting/production environment of the company. They identify the priority of deliverables.
• Coordinates system application transition from development teams to maintenance and production teams, and/or constructs implements necessary controls to assure system/application traceability. The resource is expected to know how to create wikis/documents on the code they are delivering to make sure that support team have all the necessary information regarding that code
• Utilize the company s tool for automating the testing of ETL DataStage code. The company is currently utilizing TestDrive to automate the testing of DataStage code.
• Works closely with the Financial Crimes Investigation team to identify new Business Objects Reports to be developed for case building purposes.
• Collaborates with the Anti-Money Laundering team to identify databases and tables that needs to be migrated/upgraded to a newer version to ensure all the data needed are always available.
• Monitors and ensures that offshore team deliverables are all completed on time and reviewed before being presented to the client.
• Act as SME for reviewing all the codes developed by both the client and 3rd party consultant to ensure that it meets the USAA standard and to mitigate production issues during code production releases.
• Works closely with the support team to ensure that all the daily batch jobs are all completed and validated. This ensures that when the Fraud Business team starts their work, they have the data/information they need to perform their work.
• Collaborated with the Product Owner to ensure that all the works are being prioritized properly. This will result to team being aware of what are the priorities and when it is expected to get completed.
• Works closely with the Scrum Master to ensure that all work-related statuses and concerns are being document.

Technical Representative

Confidential

Responsibilities:

• Works with business partnets to gather business requirements and translate into a techincal specification documents that will be used as basis for development.
• Responsible for completing the end to end ETL(Extract, Transform and Load) process using DataStage.
• Maximizing the Unix environment for job configuration and for creating scripts4. Creates Control - M folder to control the flow of job execution.
• Creates automated ETL test validation using Test Drive.
• Works on RTC(Rationale Team Concert) to make sure the tasks/deliverables are updated daily so the team is well informed on the current status or if there are any issues or impidements that will prevent the code from being delivered on time.
• Creates Roll-Out plan to make sure that all points are covered during production code migration
• Provide production analysis after code is released to make sure that the code is working as expected.
• Facilitates root cause analysis of system issues to minimize impact and future occurences. The resouce is expected to fix issues in production which means resources will be given production access to the DataStage Environment, Unix and Databases. The resource is expected to have a good understanding on how to use PasswordSafe since the company is utilizing this to control how the Production environment is being utilized.
• Coordinates system application transition from development teams to maintenance and production teams, and/or constructs implements necessary controls to assure system/application traceability.
• The resource is expected to know how to create wikis/documents on the code they are delivering to make sure that support team have all the necessary information regarding that code
• Maximing the use of different Database Platforms like DB2, Oracle, Netezza and SQL Server as either source/target for the data needed by the business partners.

Senior Technical Consultant

Confidential

Responsibilities:

• Responsible for completing the end to end ETL(Extract, Transform and Load) process using DataStage.
• Maximizing the Unix environment for job configuration and for creating scripts4. Works on RTC(Rationale Team Concert) to make sure the tasks/deliverables are updated daily so the team is well informed on the current status or if there are any issues or impidements that will prevent the code from being delivered on time.
• Creates Roll - Out plan to make sure that all points are covered during production code migration
• Provide production analysis after code is released to make sure that the code is working as expected.
• Facilitates root cause analysis of system issues to minimize impact and future occurences.
• The resouce is expected to fix issues in production which means resources will be given production access to the DataStage Environment, Unix and Databases.
• The resource is expected to have a good understanding on how to use PasswordSafe since the company is utilizing this to control how the Production environment is being utilized.
• Coordinates system application transition from development teams to maintenance and production teams, and/or constructs implements necessary controls to assure system/application traceability.
• The resource is expected to know how to create wikis/documents on the code they are delivering to make sure that support team have all the necessary information regarding that code
• Maximing the use of different Database Platforms like DB2, Oracle, Netezza and SQL Server as either source/target for the data needed by the business partners.

Technical Representative

Confidential

Responsibilities:

• Understood functional requirements and created technical specification documents based on client requirements in order to start development.
• Collaborated with developers and performance engineers to enhance supportability and identify performance bottlenecks.
• Implemented end to end ETL development from requirements gathering until production deployment and support.
• Maintained existing applications and designed and delivered new applications.
• Developed code fixes and enhancements for inclusion in future code releases and patches
• Performed regression and system-level testing to verify software quality and function before it was released.
• Stress-tested ETL code to validate code changes and ensure that code is working as expected.

Software Engineer

Confidential

Responsibilities:

• Understood functional requirements and created technical specification documents based on client requirements in order to start development.
• Collaborated with developers and performance engineers to enhance supportability and identify performance bottlenecks.
• Implemented end to end ETL development from requirements gathering until production deployment and support.
• Maintained existing applications and designed and delivered new applications.
• Developed code fixes and enhancements for inclusion in future code releases and patches
• Performed regression and system-level testing to verify software quality and function before it was released.
• Stress-tested ETL code to validate code changes and ensure that code is working as expected.