ETL Lead/Architect Resume Plano, TX - Hire IT People

EXPERIENCE SUMMARY:

An Accomplished technical lead, ETL architect and developer. Extensive work done in Data warehouse and business intelligence, supporting traditional and modern analytics.
Strong skills in systems analysis, design, development, testing and implementation of Data warehouse projects.
Delivered Key performance indicators, Quality metrics for actionable insights in Shipping, E - Commerce operations for generating value for the Organization.
Extensive experience in Physical and logical data modeling, Architecture of data transformation process (ETL) and development with focus on reliability, quality and performance.
6 years of experience in lead role managing ETL projects.

TECHNICAL SUMMARY:

Ab Initio
Power Apps
Power BI
Websphere DataStage
DataStage Enterprise
DataStage Parallel Extender
SAP Business Objects
Crystal reports
Platinum Erwin, ER Studio
Oracle Manufacturing applications (Inventory, Purchasing and Order entry modules)
Oracle
MS SQL
UniData
DB2
MS Access
UNIX
LINUX
Windows
TOAD
SQL Developer
Oracle Database Administration
Symphony suite
Unix shell
Test Director
Clear Case
Star Team (Source code management tool)
Autosys
One Automation
PPM
PDSM

PROFESSIONAL EXPERIENCE:

Confidential, Plano, TX

ETL Lead/Architect

Responsibilities:

In a lead role, I have implemented Express and Ground operational metrics to measure compliance and performance . These metrics helped in earning customer loyalty and improved center and team members’ accuracy and consistency in operations
In the Architect role, I have standardized ETL process designs, surrogate key generation, changed data capture mechanisms and re-startable job sequence designs. Documented architecture and standards for ETL design.
Developed ETL processes to measure revenues by channels and customer, which helped in formulation of marketing strategies. Provided capabilities for business to include or exempt specific data scenarios from measuring metrics.
With high data quality and integrity, I have developed ETL processes for service quality Index. This index allowed business to derive accurate bonus amounts for the team members for meeting their goals. This also allowed FedEx Office to fix bonus anomalies and earn team member’s satisfaction.
Delivered several ETL key initiatives such as Order to pay, Shipping Key Performance Indicators, E-Commerce, Account access (Customer account master) and DocStore. These projects allowed business in making data driven decisions for superior quality and performance of the business
Leading onshore/offshore engagements, making sure that the solution architecture aligns with BI roadmap, are additional responsibilities while collaborating with cross functional teams and business stakeholders
Developed standards, frameworks for sustainable ETL processes with adoption of Enterprise best practices for complete software development life cycle.

ETL Developer/Lead/Architect and BI Manager

Confidential

Responsibilities:

Lead or developer on projects implementing Data warehouse, Operational data store and Data Marts.
I have been an architect for ETL process standardization, change data detection and common utility framework.
My responsibilities include gathering business requirements, project estimation with respect to resources, translating these complex requirements into technical solutions, collaborating with business and technical teams for planning and executing integration/user acceptance testing.
Data modeling and designing Star and Snow Flake schemas are added skills.
Extensive work experience with tools such as DataStage, Ab Initio, Business Objects, self-serve analytic tools, Oracle applications (ERP - IMS, Purchasing, Sales), Databases such as Oracle, Teradata, MS Sql in windows, Unix and Linux operating systems.
Good knowledge with source code management, process flow, scheduling, and Defect tracking tools are added assets.

We provide IT Staff Augmentation Services!

Etl Lead/architect Resume

Plano, TX

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship