Sr. Data Platform Developer Resume Houston, Texas - Hire IT People

SUMMARY:

Oriented professional with a deep understanding of business and IT data elements who excels at providing comprehensive data modeling, system analysis, ETL solutions and mining of business data.
Able to coordinate and take control of all phases of project - based efforts while delivering assigned projects within established deadlines.
Cloud Computing (Azure).
Shell Scripting (Bash, KSH)
Implementation of automated sign/pricing system to deliver promotion information which saved company millions of dollars in printing and shipping expenses.
Development of automated reporting solutions aimed to facilitate business decision making and data reconciliation.
Development of several reporting tools to quickly diagnose and cleanse rejected data during company-wide database migration.
Development of shell scripts and ETL jobs as library templates for less experienced ETL developers.

TECHNICAL SKILLS:

Database systems: Oracle, Teradata, Microsoft SQL Server, DB2, Netezza.

BI/ETL tools: Datastage, SSIS, Microstrategy.

Development methodologies: Agile, waterfall.

Languages: Bilingual (100 % proficiency in written and spoken English and Spanish languages)

Business: Retail Management, Sales, E-commerce, inventory management.

Issue tracking: Jira, Confluence, ServiceNow.

Data Modeling tools: ERwin data modeler, SQL developer.

DB- Big Data: SQL DB language, HQL

Tools: Microsoft office suite, MS Project, MS Visio, Automation tools (UC4, Control-M)

EXPERIENCE:

Sr. Data Platform Developer

Confidential, Houston, Texas

Responsibilities:

Apply complex data transformation solutions (ETL and ELT) using IBM Datastage for a worldwide oil commodities client.
Conversion of business requirements from source to target using requirements documents and data mapping documentation in an Agile methodology environment.
Development, testing and validation of interfaces to convert data from SQL Server DB to Teradata using ETL tools, SQL queries and stored procedures.
Key participator in all phases of SDLC development and instrumental in root cause analysis, code debugging, data cleansing and data defect resolutions.
Development of reusable interface templates for use in multiple instance developments.

Confidential, Katy, TX

Sr. ETL Data Warehouse Developer

Responsibilities:

Lead and participate in the application of technical design processes in all SDLC phases.
Training and mentoring of Jr. Developers as well as supervision of contract developers for projects I was the ETL lead.
Ensure interface designs are aligned with business requirements through appropriate documentation and requirements mapping.
Complete LOE estimates for design, development, implementation, enhancements, defect resolution and rollout tasks.
Develop shell scripts in Unix/AIX environment, ETL solutions using IBM Datastage and source data analysis from data warehouse system and relational databases (Netezza, Oracle, MS/SQL Server, DB2).
Key achievement: Implementation of reconciliation reporting solutions based on the analysis of BI data and retail merchandising systems for replenishment and warehouse management business units.

ETL Developer

Confidential

Responsibilities:

Writing, troubleshooting and performance tuning of SQL queries in several databases including SQL server, Netezza and Oracle.
Development and unit testing of ETL processes for optimal performance using IBM Datastage.
Development of source to target data mapping solutions for ETL processes
Key achievement: completion of assigned company wide database migration milestones ahead of established deadlines.

Data Profiling Analyst

Confidential

Responsibilities:

Drafted detailed technical documents, including Functional Design Specifications and High Level Design documents.
Organized data mapping sessions and data analysis meetings with stakeholders, contractor teams and business units.
Developed a communication plan between business units and data migration team members to ensure data met system requirements.
Key Achievements: Instrumental in developing and implementing a successful data cleansing plan for data not meeting system requirements.

E-commerce Inventory coordinator

Confidential

Responsibilities:

Analyzed sales, profit performance, inventory position and replenishment.
Monitored product levels and fulfillment center capacity to ensure proper space utilization based on sales trends.
Key Achievements: Creation of a data management database for executive reporting previously computed via Excel into a localized Microsoft Access database.