SUMMARY:

• Ability to understand complex business problems and to multitask, managing and prioritizing multiple projects in a cross functional environment to assure high value business results on a time and cost - effective manner.
• Ability to evaluate opportunities in the context of the requirements and recommending solutions that enable the organization to achieve its short and long-term goals.
• Ability to continually push for higher quality and value while delivering innovative solutions for customers’ growing business needs.
• Proven track record of being able to successfully deliver Data Platforms and Business Intelligence solutions against extremely demanding budgets and schedules
• More than 15 years of senior Data Warehouse lead experience, with strong analytical skills and a board range of IBM info Sphere Data Stage expertise.
• Specialist in the development of various reporting platforms such as short Term loans, Credit reporting, Collection reporting and agent reporting
• Excellent understanding of Data Stage Parallel Runtime Engine architect
• Active in hiring data warehouse and ETL developers.
• Participating on company Enterprise architectures.
• Exemplary problem-solving skills, able to identify problems and implement corrective processes.
• Skilled in cultivating positive relationships with clients and colleagues; particularly adept at communicating with clarity and diplomacy to individuals from diverse cultural and organizational backgrounds.
• Strong leadership skills, able to prioritize, delegate tasks, and make sound decisions quickly while maintaining a focus on the bottom line.

TECHNICAL SKILLS:

Languages: IBM Info Sphere (Data Stage 8.5/ 9.1), Toad, Oracle PLSQL, Visual Basic Development Tools

Software: IBM Info Sphere Data Stage, SQL Navigator, Erwin, MS Visio

Databases: Oracle, Teradata V2R5, Sybase, Access

Systems: UNIX, Windows

PROFESSIONAL EXPERIENCE:

Senior ETL Developer Lead

Confidential

Responsibilities:

• During last three years, solely responsible to operated and maintained Data Warhorse and ETL platforms. Including -- initial requirements, design, launch, implementation and support production. Sounds expertise and reputation for team work, high--energy work ethic and the ability to deliver large, complex ETL platform on-time and on budget.
• Design, developed and implemented Credit Report platform which generated and increased in collection revenue by 30%. Maintain daily follow up with Quality Assurance, resulting in %100 accuracy of deliverable data. Rewarded to complete this project before deadline.
• Designed, developed and implemented Trade Line Reporting (Score Model) Platform to keep customer data up-to date and accurate to make lending decisions. Achieved award for completion of this complex project 3 weeks ahead of deadline.
• Support and maintain production for over 15 ETL Projects which loaded close to 1 terabyte data every night to support various departments such as Accounting / compliance /collection and marketing.
• Achieved reward for outstanding team player and assisting other involved teams to train Data stage tool to perform Data Stage administrative tasks due to resource constraint at cash America. The administrative tasks include, creating user/Import and export ETL Jobs, Start up and shot done Data stage engine, create project and connectivity to various databases.
• Optimizing Lost Prevention Reporting ETL platform to decrease execution time from 8 hours to 2 hours by redesigning platform.
• Organized daily meeting with Business Intelligent Vice president to inform him of nightly progress, issues and new projects.

ETL Data warehouse Manager

Confidential

Responsibilities:

• Active member of data rollout from legacy POS system to New POS system
• Reduced the ETL run time from 5 hours to 20 minutes by discovering the root cause of the slowness and optimizing ETL jobs in more efficient manner. The customer rollout was the first step of data conversion, since this process was very slow the entire rollout took 6 to 8 hours. With the changes that I made the entire data conversion reduce to 2 hours.
• Leading ETL team staff of 3 developers in producing high quality technical designs and deliverables. Meet with business stakeholders to ensure the designed solution meets business goals. Reduced run time for all the ETL jobs to meet SLA.
• Achieved reward with high performer for meeting Operational Data store (ODS) and Enterprise data to meet users SLA’s. Reducing run time from 8 hours to 2 hours.
• Rewarded for ETL design to convert historical data in ODS and data mart. Reducing days of run times to 4 hours.
• Redesign ETL jobs to load operational data store by reducing number of ETL Jobs: 100 ETL jobs to 12 jobs utilizing my skill of understanding Data Stage Engine architect, which was used to design new ETL Frame work.
• Consistently exceeded goals for deliverable and maximizing customer’s satisfaction.
• Define ETL project scope, provide sizing and estimates for development and production support projects
• Reviewed and approved ETL solution designs, data mapping and design functional specifications and transformation rules to ensure high quality of deliverables.
• Coordinated work flow among five consultants and supervised three support staff. Prioritized and delegated tasks, provided motivation and direction to create positive work environment and ensured accurate, on time completion.
• Utilized clarity, humor, well defined goals, and a positive work ethic to establish a spirited organizational culture throughout the company.

Lead ETL Team

Confidential

Responsibilities:

• Performed the role of ETL lead and involved in conducting design sessions and evaluating tools for the application development. Co-ordinate infrastructure/business analyst groups meeting with development teams.
• Reduced label cost by 40% by retiring 10 ETL consults.
• Initiated project kick-off meetings with several stake holders involved in application development (Carried out time/cost/person estimation for design/development/implementation of data warehouse/ETL applications development
• Performed the role of technical lead by guiding designs and setting up the development environment to the team Identified time delay bottlenecks and eliminated them for projects completion well below allocated budget by 40%.
• Effectively utilized team budget by guiding sub-ordinates to undergo technical trainings beneficial for performing organization's data-to-day tasks
• Reduced production support cost by introducing tighter quality control during development phase Carried out technical interviews, and reduced person cost to the organization by selecting right candidates
• Set up weekly/monthly/quarterly meetings with superiors to keep them aware of team achievements and activities
• Identified bottlenecks in BI reporting and introduced solutions in ETL to overcome those issues (Lead the effort from front to upgrade infrastructure and applications at same time without cost/time overheads

Senior ETL consultant

Confidential

Responsibilities:

• Designed and developed automated generic ETL job which loaded 400 tables into data warehouse.
• Designed and developed Generic Lookup process for ETL process.
• Designed and developed custom lookup process for ETL process.
• Designed and developed Generic Surrogate Key process.
• Developed requirements and data mappings for data conversions
• Developed data conversion specifications, programmed data conversions using Ascential Data Stage and unit tested programs.
• Trained and worked with client on design and coding process using Ascential Data Stage.

Application Manager, Enterprise Data Warehouse Department (EDW)

Confidential, Dallas, TX

Responsibilities:

• Reduced cost by 40% thru working with the operation business units to develop strategies and operational plans to maximize the business value of the information produced by the EDW by setting up logical communication between development and the user community
• Reduce time spent on ETL development 30% by reorganizing team member Scheduled and ETL team coaching sessions during life cycle of projects
• Led day-to-day operational management and change control. This includes project plan development, resource management, and cost analysis that ensure IT Service Level Agreements (SLA’s) are met on schedule and within budget guidelines.

Lead ETL Specialist

Confidential, Dallas, TX

Responsibilities:

• Increased Productivity for sales and marketing departments by developing automated ETL process which utilizing Data Stage v6.1 to convert CDR (Call Detail Data) from binary to ASCII format in near real time.
• Designed and developed conversion of dimensional data model into relational data model using Teradata RDBMS.
• Partnered with business to gather requirements and develop reporting solutions through BI tool
• Documented all ETL requirements, data mart mapping and reports as they were released
• Developed requirements and data mappings for data conversions
• Developed data conversion specifications, programmed data conversions using Ascential Data Stage and unit tested programs.
• Developed analytic server Metadata using Data Stage Metadata tool.
• Identified necessary aggregations and defined aggregate requirements and strategy
• Developed requirements and data mapping for data conversion
• Translated logical business dimensional /relational model in physical model
• Designed and developed data warehouses and ETL programs for creating all data warehouse tables. Supported initial load, refresh and on-going update strategies using Ascential Data Stage (v7.0)
• Led team to convert and upgrade Data Stage (7.1) projects to UNIX platform