We provide IT Staff Augmentation Services!

Architect / Design Lead Resume

2.00/5 (Submit Your Rating)

BentonvillE

SUMMARY:

  • 12+ years of total Information Technology experience in the areas of DW&BI, Data Integration and Data Migration projects, and played various roles in projects including Architect, Technical Lead, Developer and Onsite Lead.
  • Proficient in the areas of Data Warehousing and Business Intelligence, ETL tools like IBM Information Server (DataStage v 11.5 / 9.1), Teradata, Oracle, IBM DB2, MS SQL Server.
  • 7+ years of experience working in a Retail Replenishment project (Global Replenishment Systems) for Confidential and proficient knowledge about Retail Replenishment and Architecting and Designing custom solutions for Retail, Supply Chain Management.
  • Working knowledge in Big Data tools and technologies, Python, Java.
  • Proficient in Performance Tuning of DataStage jobs handling huge volumes of data; and extracting or loading to DB2, Teradata, Oracle, Complex Flat Files etc.
  • Extensive team leading experience of leading teams in onsite - offshore model and has over 6 years of onsite experience working at the client side as Onsite Tech lead/ Onsite Coordinator in USA and Australia.
  • High proficiency in working with clients, requirements capturing, analysis and design, presenting Architecture concepts and deliverables to Clients.
  • Proficient in producing all kinds of Architectural document including Architecture Overview, High Level design, technical design specifications.

PROJECT EXPERIENCE:

Confidential

Architect / Design Lead, Bentonville

Tools: DataStage 11, JDA, Teradata, Oracle, DB2, CA7

Responsibilities:

  • Performed multiple roles while working in this project - Architect, Technical Lead, Onsite Lead, ETL developer in the last 7 years.
  • Requirements gathering for the new projects and change requests from the Confidential Business Users and JDA Technical experts, and prepare Architecture Overview, High Level design, technical design specifications
  • Presenting the Design Solutions and High-Level Design in the design review meeting before the Confidential Technical Experts and other vendors like JDA.
  • Implementing and developing the ETL solutions using DataStage, Oracle, Teradata, DB2.
  • As part of Performance Engineering team, proposing and implementing various ideas to reduce the Batch run time, create performance products (tasks) to improve DataStage job performance to help achieve the processing of 600+ million SKUs.
  • Performance Tuning of DataStage jobs handling huge volumes of data and extracting or loading to DB2, Teradata, Oracle, Complex Flat Files etc.
  • Providing estimation for the Change Requests, enhancements and new projects using tools and processes used in IBM.
  • Providing expert advice and technical solutions to customer requirements and responsible for impact analysis, providing root cause analysis for critical support issues and to propose system and application enhancements.
  • Preparing, maintaining and updating the project wiki page regularly with project related knowledge documents to facilitate the onboarding of new members in the project.
  • Taking regular updates from the team, updating the team status document, and updating the higher management in Weekly review meetings.

Confidential

Onsite Tech nical Lead / ETL Developer, Boulder

Tools: DataStage 8.1, UNIX, Oracle, Siebel

Responsibilities:

  • Onsite Tech Lead and Onsite Coordinator - responsible for understanding the requirements from the customer and prepare the technical design documents.
  • Lead role in the Production Extract Management activity to deliver around 369+ extracts from 55 source systems in a short period of time. Production Extract management was an important activity where we extracted data from numerous source systems (DB2, Oracle, flat files, mainframe, legacy systems etc.) and loaded them into the staging tables before doing the transformations.
  • ETL developer - responsible for design, construction, testing of the DataStage jobs.
  • Responsible for the code review of the DataStage jobs developed from Offshore.
  • Using ProfileStage and QualityStage to do data profiling and data standardization.

Confidential

ETL Developer

Tools: Ab Initio, UNIX, Oracle

Responsibilities:

  • Understanding the requirement specifications, technical specifications and development plan.
  • Developing Ab Initio graphs for data extraction, transformation and loading.

Confidential

Onsite Coordinator / ETL Developer

Tools: DataStage 7.5 (PX), UNIX, Oracle

Responsibilities:

  • Performed the role of Onsite Coordination and Onsite Tech Lead while at onshore.
  • Design and development of the DataStage jobs as per the design document.
  • Preparing Unit Test Cases and Unit testing of the DataStage jobs.
  • Coordination with the offshore team and providing them with daily updates.
  • Code review of the DataStage jobs constructed by offshore.

Confidential

ETL developer

Tools: Ab Initio, UNIX, Netezza

Responsibilities:

  • Construction of Ab Initio codes using the Ab Initio GDE, and Unit testing of Ab Initio jobs.
  • Developing AutoSys scripts for Job Scheduling.
  • Post Production support and ticket resolution during the warranty period.

We'd love your feedback!