We provide IT Staff Augmentation Services!

Data/ Etl Architect Resume

3.00/5 (Submit Your Rating)

Atlanta, GA

SUMMARY

  • Around 8 years of professional experience in IT service industry, software development, analysis and design of complex BI and database architecture and problem analysis using various technologies. Experience encompassing a wide range of skill set, roles and industry verticals.
  • Extensive experience with consulting, analysis, design, development, customizations, production support and implementation of projects using ETL tools, Databases DB2/Teradata/SQL Server/Oracle, Unix - AIX, Reporting tools Micro strategy/Cognos and scheduling Control-M/ CA-7/ Autosys
  • Proficient in ETL Architecture, Design & Implementation (i.e. designing, developing, and maintaining the ETL landscape, delivering timely and quality data). Providing expertise, mentorship, and solution reviews to multiple groups of ETL developers and will provide standards, procedures, and best practices for data integration as per industry standards.
  • Proficient in understanding data requirements, full software development lifecycle of the ETL solutions leveraging different ETL tools, requirements definition, analysis, design, development, and support of testing and migration to production.
  • Strong database skills, knowledge of reporting tools and developing strategies and framework.
  • Experience in leading and managing teams, working in offshore onsite model. Handled multiple roles - Data/ETL Architect, Consultant, Tech Lead /Onsite Co-ordinate
  • Actively involved in Confidential ’s recruiting process for hiring employees for both On-site and Offshore positions, On-boarding and off-boarding.
  • Experience in mentoring the team and fresh hires. Helping them in understanding functional and technical aspects, come up to speed and be productive in time
  • Handled multiple projects and teams at a given time, ability to work alone as well as with the team.
  • Involved in providing technical and functional training to the team. Within Confidential provided trainings to multiple account’s on different tools /software’s and processes, and help them setting up new projects.
  • Good communication, interpersonal skills, self-motivated, quick learner, team player, dedicated and takes ownership

TECHNICAL SKILLS

Development Tools: Ab-initio v3.1.x, GDE, EME Datastage 8.1 Cognos, Microstrategy, Workday, Talend, Big Insight/Hadoop

Functional Modules: Banking, Data warehousing, Reporting, BI, EDW, Big Data, HDFS

RDBMS: Confidential DB2 UDB V9.x, DB2EE, DB2EEE,Teradata, V8.x, Oracle V10.X, SQL Server 2000/2005

Languages: Shell Scripting, PL/SQL, SQL, C, Python, Basic Java

Operating systems: Windows NT/2000 Server, HP-UX 11.1, Confidential -AIX, Linux

Scheduling: Ca-7, Control-M, Autosys

Modeling Tools: Erwin, MS Visio

Processes: Confidential ’s QMS (Quality Management System)

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Data/ ETL Architect

Responsibilities:

  • Provide a fact based confirmation related to data / ETL / Process complexity
  • Collect representative sample from application both (Data and ETL graphs)
  • Template driven process to capture the relevant details
  • Quick and effective solution to optimize ETL processes and long term solutions on creation of Data Lake
  • Drive collaboration checkpoints with the Confidential -SunTrust resources to maximize knowledge transfer and continuity
  • Defining Due Diligence Process framework
  • Application Template creation and Defining optimization matrix, daily trackers and targets
  • Provide Solutions for EDW using Big-Insight/Hadoop, Ab-initio, Talend

Environment: Hadoop, HDFS, Ab-Initio, DB2, Mainframe Ca-7,Shell Script, Unix, Sql-Server, Oracle, Talend

Confidential, Atlanta, GA

ETL Project lead

Responsibilities:

  • Gathering requirements for different Workday integrations.
  • Designing Workday integrations ETL processes which takes data from Workday, process them and send it to downstream and outside venders
  • Responsible for full software development lifecycle of the Workday ETL solutions which includes requirements definition, analysis, design, development, and support of testing and migration of all the integrations to production.
  • Helping in decommissioning the PeopleSoft environment and cut over to Workday.
  • Help BA’s is creating source to target mapping.
  • Get the development work done by the offshore team. Involved in testing and the integrations.
  • Conducting client meetings, sharing results and updates with the business team.
  • Production implementation and warranty support

Environment: Ab-Initio, DB2, Mainframe Ca-7,Shell Script, Unix, Sql-Server, Oracle, PeopleSoft, Basic Workday, Quality Center

Confidential

ETL Architect

Responsibilities:

  • Rationalize reporting and establish standard reporting packages for Mortgage BIO reporting.
  • Develop and implement scorecard and tactical dashboards.
  • Consolidate core Mortgage system data sources on the BI Appliance.
  • Migration of data sources that support the Mortgage Business Segment on the BI Appliance
  • Implementation of the “Single Version of the Truth for Data” to support the Mortgage business processes.
  • The Single Version of Truth is the data foundation layer that serves the operational reporting, dashboards, scorecards, and analytic needs.
  • Decommission of the Legacy BDE database.
  • Implement a Data Governance program for the Mortgage Business Segment.
  • Creation and implementation of the required Policies and Procedures to in corporate standard controls and checklists.
  • Responsible for full software development lifecycle of the ETL solutions which includes requirements definition, analysis, design, development, and support of testing and migration to Production.
  • Maintain consistent ETL standards, configuration management strategies and production deployment standards.
  • Responsible for ETL technical design, perform design/code reviews and work with ETL developers to deliver an efficient ETL solution
  • Work with developers to build ETL workflows, sessions and source-to-target mappings including error-handling and audit processes.
  • Troubleshoot, optimize and tune ETL processes

Environment: SSIS/SSRS,SAS,Ab-Initio, DB2, Mainframe Ca-7,Shell Script, Unix, Sql-Server, Oracle, SAS, Cognos

Confidential, Atlanta, GA

ETL Project lead

Responsibilities:

  • Setting up the new environment with latest and upgraded tools and software’s
  • Implementing failover and workload balancing for the servers and database
  • Increase capacity and storage
  • Testing the new environment
  • Migrating all the projects/Applications from old to new environment
  • Connection of third party application’s /software in the new environment
  • Decommissioning the old environment

Environment: Ab-Initio, DB2, Mainframe Ca-7, Shell Script, Unix, Sql-Server, Oracle

Confidential, Atlanta, GA

ETL Tech Lead

Responsibilities:

  • Gather and analyze the requirements
  • Interact with the Client on daily basis to define the scope of the project and finalize the requirements.
  • Design high quality solutions and do correct time and cost estimation
  • Provide most appropriate technical design and solutions
  • Work assignment and tracking to completion of activities and different phases of development
  • Provide assistance in reviewing the quality deliverable
  • Will be communicating team on each updates and changes happening in the application.
  • Provide ongoing surveillance, tracking, escalation, resolution, and reporting of application problems during development and warranty support
  • Performance enhancements to application functionality
  • Support the End users by providing the faster solution to their request
  • Work on the break fix and continuous development and review and inspection for the production changes
  • Work on the schedule changes and harvest deployment processes
  • If required, simulate the solution and explain the same to customer before actual implementation. Co-ordinate with customer to ensure the issues is resolved at the earliest
  • Test the proposed solutions before delivering to client and obtain signoff.
  • Follow up with the off shore and on-site team on a daily basis, tracking the progress of tasks and communicate the status to the clients.
  • Write New/Update the Business/Technical requirement documents
  • Work with the various other groups - DBAs, Server Engineer Team, Middleware Group, Citrix Group, Network Group, data transmission .etc to resolve the performance related/integration related issues
  • Spend time on debugging the issues logged on a daily basis as part of the warranty support and issues logged by users.
  • Creating and tracking all change requests, work orders incidents related to project
  • Working with client to drive upcoming projects, timelines resource allocation etc.
  • Develop and maintain professional relationship with client and ensuring client satisfaction.

Environment: Ab-Initio, DB2, Mainframe Ca-7, Shell Script, Unix, Sql-Server, Oracle

Confidential, Jacksonville, FL

Team lead /Onsite co-ordinator

Responsibilities:

  • Work with Business Analyst in translating business requirements into Functional Requirements Document and to Detailed Design Documents
  • Lead analysis sessions, gather requirements and write specification and functional design documents for enhancements and customization. Analyze product impact .
  • Handling Production Support
  • 24 * 7 support, Job Monitoring and abend handling
  • Gathering daily/weekly/monthly job statistics and presenting the same to client, also looking into opportunities for performance improvement and working with offshore team to reduce the job abend.
  • Supporting weekly maintenance and bank's major hardware and software upgrades
  • Communicate activities/progress to project managers, business development, business analysts and clients

Environment: DataStage, TeraData, Autosys, Unix, Oracle, Ab initio

Confidential, Foster City, CA

ETL Developer / consultant

Responsibilities:

  • Production support, job monitoring and job failure resolutions.
  • Ownership of different applications and actively monitoring the status of the application jobs.
  • Worked on CRQ, PMX Incidents and various maintenance tasks.
  • Supporting and guiding the team to handle different server and software upgrades.
  • Debugging and resolving all types of severity issues in job abends on time to meet the SLA’s.
  • Identified and worked on various bugs in the production and provide better solution to the client, also involved in performance tuning if database loads to reduce the execution time.
  • Enhancements and implementation in the production system.
  • Worked on different adhoc requests and research requests.
  • Involved in various documentation like Application Information documents, and Design documents.
  • Creating and managing reports on performance, Sla’s hit, job failures, infrastructure issues and shared with the client on weekly basis.
  • Supporting software upgrades and maintenance activities for databases and servers.
  • Development of ETL code to load the data into DB2 database as per the requirement specifications.
  • Developed code to automate some of the manual processes
  • Coding for technical validations for different source system to ensure data quality.
  • Involved in work order for EME Cleanup, EME Dependency Analysis and New Framework Changes.
  • Unit Testing, Create, Execute, and Review the Test Cases.
  • Debugging and resolving the issues of different applications

Environment: Ab-Initio, DB2, Mainframe, Contro-M, Shell Script, Unix, Sql-Server, JCL, Microstrategy

Confidential

ETL Developer

Responsibilities:

  • Development of ETL code to load the data into DB2 database as per the requirement specifications.
  • Developed code to automate some of the manual processes
  • Coding for technical validations for different source system to ensure data quality.
  • Involved in work order for EME Cleanup, EME Dependency Analysis and New Framework Changes

Environment: Ab-Initio, TeraData, Mainframe, Control - M, Shell Script, Unix

We'd love your feedback!