尊敬的 微信汇率:1円 ≈ 0.046166 元 支付宝汇率:1円 ≈ 0.046257元 [退出登录]
SlideShare a Scribd company logo
Mukhtar Ahmed
1
SUMMARY
 Over 8 years of work experience in the field of Data Warehousing involving various ETL projects.
 All-round experience in design, build, deploy and support of DWH-ETL processes.
 In depth Knowledge and understanding of the DWHconcepts and Dimensional modeling.
 Highly specialized in working on IBM InfoSphere Datastage 11.3/8.x, Ascential Datastage 7.x/6.0
 Worked on Server/Parallel/Sequence Datastage jobs involving variety of different stages.
 Worked on File stages like CFF, Hash file, Flat file, Datasets, Sequential file stages
 Processing stages like Merge, Join, Lookup, Transformer, Aggregator, Sort, Remove Duplicate,
CDC, Funnel, Copy, Surrogate key Generator,
 Database Stages like ODBC, DB2-UDB, Oracle connector, Teradata stage, TPT connector
 Built Shared Containers, Basic routines, Multi-Instance jobs, Before/After subroutines
 Worked on multiple databases Teradata, DB2, Netteza, Oracle, SQL Server.
 Expert in working on Teradata Tools & Utilities (BTEQ/Fastload/Fast export/Multiload/TPT/Tbuild)
 Skilled in writing UNIX shell scripts and generic DS automation scripts to execute DS jobs.
 Worked on multiple scheduling/monitoring tools such as Tivoli Workstation, Control-m, Autosys.
 Specialized in dealing with massive Data-warehouse applications (larger than 100 Terabytes)
 Confident in building high Quality code including Performance tuning & Query Optimization
 Hands-on experience in Datastage/Teradata/AIX upgrade/migration projects.
 Good understanding of the reporting tools like Cognos, Tableau, Business Objects.
 Expert in Operations & Production support functions to resolve Datastage/Teradata job aborts.
 Worked on Tivoli storage management tools for archival and retrieval of the data files
 Well versed with all the AIX/UNIX commands required for performing ETL job.
 Gained knowledge on Health Care, Retail Banking, Mortgage, Insurance domain over time.
TECHNICALSKILLS:
ETL Tools : IBM Data stage 8.1/8.5/11.3, Ascential Datastage 7.5.
RDBMS : SQL scripting in TERADATA, DB2, ORACLE 8.1, MS-SQL Server 6.5/7.0
Teradata Tools: : BTEQ/FASTEXPORT/FASTLOAD/MULTILOAD/TPT/TPUMP
SQL Clients : Teradata SQL Assistant, DB2 Control Center, Toad, SQL Developer.
O/S : AIX 6.1/7.1 (UNIX scripting), Windows batch scripting, Mainframes Z-OS
Scheduling Tools : Control-M V6.3 & V7, Tivoli Workload Scheduler(TWS), Autosys.
Versioning Tools : MKS Source & Integrity, SVN Tortoise
Archive Tools : Tivoli Storage Manager(TSM)
QA Tools : HP QC & ALM
Document Tools : Microsoft Office Excel/Word/PPT/VISIO , Ultra Edit ,Text Pad
TRAINING & CERTIFICATION:
 Six Sigma –White belt trained professional.
 Company trained and certified on AIX, RDBMS and Data warehousing
 Passed the Data Stage Competency test conducted within the organization.
 Trained on Teradata database and utilities.
 Internally certified on global courses like Global Anti-Bribery, Anti Money Laundering, Information
Security Risk and Privacy/Data Protection Awareness
EDUCATIONAL BACKGROUND:
BE in Information Technology, Osmania University, 2004 – 2008
13800 ChestnutDrive, APT 208,
Eden Prairie, Minnesota 55344, U.S.A.
Email id:asad_3077@yahoo.com
Cell:+1-952-737-2060
Mukhtar Ahmed
2
PROFESSIONAL EXPERIENCE:
Optum Technology Inc. (UnitedHealth Group),
Sr. ETL Developer November 2014 - Present
Project: Normative Health Informatics, Adding Health care data of over 10 million members useful for
the research and analysis of Lifesciences.
 Build complex Data stage jobs to handle huge work load of data (100’s of billions of records).
 Utilize Teradata Tools and Utilities like BTEQ/Fastload/Multiload/Tbuild/TPT framework to load
large tables of over 2 terabytes.
 Build unique primary/secondary/join indexes on Teradata tables
 Worked on both Server and Parallel Datastage jobs involving all the different stages like
File stages (Sequential, Dataset, CFF, Hash files), Processing stages (Transformer, Sort,
Remove Duplicate, Aggregate, Copy, Merge, Join, Lookup, CDC, Funnel), Database Stages
(ODBC, TD enterprise, TPT Connector, TD Multiload, DB2, Oracle connector etc.,.)
 Develop Generic shell scripts on AIX server to execute thousands of Data stage & Teradata jobs.
 Create Tivoli workstation jobs to schedule and automate the execution of these jobs.
 Coordinate with teams across locations in smooth execution of ETL process & data deliverables.
 Build ETL metric solution for detecting monthly increase/decrease of data from source files.
 Take full ownership for proper functioning of application processes and maintaining Data quality.
 Re-designing and Optimizing the existing processes where required.
 Carrying out capacity planning and taking proactive measures to avoid production issues.
 Follow Agile methodology techniques for progressing and tracking day to day project tasks
Environment: AIX 7.1, Datastage 8.5/11,3, Teradata 14/15, TWS, HPSM, SVN.
Optum Technology Inc. (UnitedHealth Group),
Sr. ETL Developer September 2013 - November 2014
Project: Parallax-I and Humedica data integration, Integration of over additional 1 million members
Health Care data critical for analyzing and researching for UnitedHealth care business, this also involved
migrations/upgrades of the existing system.
 Develop load process for member data and generate rekey data for medical claims rekey.
 Create new File Watcher jobs to help receive thousands of files at landing path and properly move,
process and archive them for future usage.
 Build complex data stage jobs to cleanse, transform and de-identify the source data
 Build Load scripts using TPT framework for parallel loading millions of records in tables
 Define unique primary indexes/secondary indexes/Join indexes on the tables
 Create different views on top of the tables to de-identify and showcase only the relevant data.
 Create new Unix shell scripts for running hundreds of DS jobs using automated scripts
 Build new TWS scheduling jobs to execute the newly build processes in proper order.
 Work on BA request to perform detailed impact analysis on application design issues/changes.
 Write Technical specification documents and flow diagrams and keep them up to date.
 Build healthy relationship with project stakeholders/ business partners.
Environment: AIX 6.3, Datastage 8.5, Teradata 14, TWS, HPSM, SVN.
Mukhtar Ahmed
3
HSBC Software Dev. Pvt. Ltd, Sr. ETL Developer, Nov 2012 – Sep 2013
Project: Mortgage Transformation Program, tracking and storing every single event that happens
during the lifecycle of the mortgage application required for research.
 Lead projects though all SDLC phases, utilize team & ensure timely delivery as per release plan.
 Interact with the Business Analysts to understand ETL requirements
 Understanding the Mortgage Application journey in terms of different Milestones
 Design complex ETL processes, Basic server routines, Teradata Sql Scripts(BTEQ)
 Build data cleansing, validation and DSJOB scripts using UNIX shell scripting
 Build multiple instance jobs to run the same process for 72 different sites
 Utilize Run time column propagation to deal with multiple set of files
 Use Import/Export commands for migrating the data stage code across the projects
 Developed Datastage jobs involving Join/lookup/merge/transform/remove duplicate/funnel stages
 Recommendations for new data mart design as well as improvements in current data warehouse
 Act as a reviewer on Technical review panel and review code created by other team members
 Ensure compliance with organization and project defined standards and processes
 Follow and enforce best practices, framework processes, standards and conventions.
Environment: AIX 6.3, Teradata, HP-QC, Datastage 8.1, Trillium server, Control-M.
HSBC Software Development Pvt. Ltd, ETL Developer, Jul 2011 – Nov 2012
Project: Liquidity Management Program, Project was about gathering and storing details about all the
liquidity assets and liabilities held by HSBC UK business critical for calculating the liquidity risk.
 Understand the business requirement and functional specifications documents
 Create Technical design documents and Data model documents
 Build sequencers to run datastage jobs, Routines, shell scripts in loops as per requirement
 Develop parallel jobs involving stages like transformer,sort, Remove Duplicate, aggregator, merge,
join, Lookup, change capture, change apply, peek stages.
 Create Basic routines to generate and allocate new ID for different source files received.
 Explain plan verification and optimizing SQL query by building join/secondary/primary indexes.
 Execute the System integration, User acceptance test as per plans
 Create DDL for several tables and define proper indexes, datatypes, compression.
 Use MKS Integrity code versioning tool for checking in/out the code components.
 Verify crystal reports on Cognos framework to track and test the mortgage application status
 Provide secured data access to the users as per Compliance requests.
 Ensure compliance with organization and project defined standards and processes
Environment: IBM Information server Datastage 8.0, Teradata, Sql Server, UNIX/AIX,
Control –M, MKS Integrity, ERWIN 4.1.
HSBC Software Development Pvt. Ltd, ETL Developer, Apr 2010 – Jun 2011
Mukhtar Ahmed
4
Project: Global Analytics & Integration Project, Integration of multiple sources data into a single
warehouse.
 Involved in Integration of several modules in the Global Analytics across different Regions
 Build/Amend, Test and Deploy Datastage Jobs and DB2 SQL scripts
 Build jobs to read source files using CFF stage/Hash file/Dataset/Sequential files
 Carry out Server to Parallel code changes, test and deploy it to Production.
 Build UNIX/AIX shell script for archival and retrieval of the source files
 Creating Control-M 6.3 Batch scheduling drafts and migrating them to production environment
 Coordinate with QA test team and fix the pending Defects.
 Undertake Productivity and Quality assurance initiatives across the team
Environment: Unix, DB2, Oracle 10g/9i, Control-M 6.3, Datastage 7.5
HSBC Software Development Pvt. Ltd, ETL Developer, Jun 2008 – Mar 2010
Project: Teradata Migration, Project was about migrating an existing UK data warehouse platform from
DB2 database to the Teradata database.
 Run Datastage server/parallel/sequence jobs on both DB2 and Teradata environment in parallel
 Build new BTEQ scripts, fast load/fast export scripts, TPT scripts for loading and extracting data.
 Utilize Control-M scheduling tool to run Datastage jobs on top of DB2 and Teradata
 Utilize Golden gate tool to identify any mismatch during data reconciliations
 Capture test results and perform the reconciliation between the data
 Raise any defects identified during the test run and reconciliations
 Perform root cause analysis and apply fixes for the defects
 Extensively use the Quality center to log and track the defects till closure
 Attend Daily status calls and update the run progress
Environment: AIX 6.3, Datastage 8.0, Teradata, DB2, Control-M, Golden Gate.
Achievements:
 Sustaining Edge Award, Excellence at Workplace & Remarkable Contribution.
 Above & Beyond Award - Best Quality Deliverables.
 Long Service Award: 4 years of Excellent Service to the organization.
 Reuse & Innovation Award - Most Productive Initiation.
 Pat on a Back Award: Awarded for Hard work and Dedication.
PROFESSIONAL SUMMARY:
Software Engineer, HSBC Software Development Pvt. Ltd. June 2008 - September 2013.
Senior Software Engineer, Optum Services Inc. (UnitedHealth Group), September 2013 - Present.
References: Available upon request

More Related Content

What's hot

Pradeep_resume_ETL Testing
Pradeep_resume_ETL TestingPradeep_resume_ETL Testing
Pradeep_resume_ETL Testing
Pradeep Reddy Amanaganti
 
Mani_Sagar_ETL
Mani_Sagar_ETLMani_Sagar_ETL
Mani_Sagar_ETL
Mani Sagar
 
Abdul ETL Resume
Abdul ETL ResumeAbdul ETL Resume
Abdul ETL Resume
Abdul mohammed
 
Resume
ResumeResume
RamMohan_Testing_8Exp_Resume
RamMohan_Testing_8Exp_ResumeRamMohan_Testing_8Exp_Resume
RamMohan_Testing_8Exp_Resume
rama mohan reddy palle
 
ETL Testing Resume @ venkatesh
ETL Testing Resume @ venkateshETL Testing Resume @ venkatesh
ETL Testing Resume @ venkatesh
Venkatesh Vulli
 
Basha_ETL_Developer
Basha_ETL_DeveloperBasha_ETL_Developer
Basha_ETL_Developer
basha shaik
 
Munir_Database_Developer
Munir_Database_DeveloperMunir_Database_Developer
Munir_Database_Developer
Munir Muhammad
 
ChandraShekhar_5.11_yrs_exp
ChandraShekhar_5.11_yrs_expChandraShekhar_5.11_yrs_exp
ChandraShekhar_5.11_yrs_exp
Chandra Shekhar
 
Resume - Deepak v.s
Resume -  Deepak v.sResume -  Deepak v.s
Resume - Deepak v.s
Deepak V S
 
Himel_Sen_Resume
Himel_Sen_ResumeHimel_Sen_Resume
Himel_Sen_Resume
himel sen
 
Renu_Resume
Renu_ResumeRenu_Resume
Renu_Resume
renu lalwani
 
Nitin Paliwal
Nitin PaliwalNitin Paliwal
Nitin Paliwal
Nitin Paliwal
 
Sreekanth Resume
Sreekanth  ResumeSreekanth  Resume
Sreekanth Resume
srikanth gorantla
 
Sudeshna Ghosh Dastidar-Resume
Sudeshna Ghosh Dastidar-ResumeSudeshna Ghosh Dastidar-Resume
Sudeshna Ghosh Dastidar-Resume
Sudeshna Ghosh Dastidar
 
Resume_PratikDey
Resume_PratikDeyResume_PratikDey
Resume_PratikDey
Pratik Dey
 
ShwetaKumar_ETLBITesting_3.7yr_faridabad
ShwetaKumar_ETLBITesting_3.7yr_faridabadShwetaKumar_ETLBITesting_3.7yr_faridabad
ShwetaKumar_ETLBITesting_3.7yr_faridabad
shweta kumar
 
Shane_O'Neill_CV_slim
Shane_O'Neill_CV_slimShane_O'Neill_CV_slim
Shane_O'Neill_CV_slim
Shane O'Neill
 
Resume_Gulley_Oct7_2016
Resume_Gulley_Oct7_2016Resume_Gulley_Oct7_2016
Resume_Gulley_Oct7_2016
William (Bill) Gulley
 
Informatica_Rajesh-CV 28_03_16
Informatica_Rajesh-CV 28_03_16Informatica_Rajesh-CV 28_03_16
Informatica_Rajesh-CV 28_03_16
Rajesh Dheeti
 

What's hot (20)

Pradeep_resume_ETL Testing
Pradeep_resume_ETL TestingPradeep_resume_ETL Testing
Pradeep_resume_ETL Testing
 
Mani_Sagar_ETL
Mani_Sagar_ETLMani_Sagar_ETL
Mani_Sagar_ETL
 
Abdul ETL Resume
Abdul ETL ResumeAbdul ETL Resume
Abdul ETL Resume
 
Resume
ResumeResume
Resume
 
RamMohan_Testing_8Exp_Resume
RamMohan_Testing_8Exp_ResumeRamMohan_Testing_8Exp_Resume
RamMohan_Testing_8Exp_Resume
 
ETL Testing Resume @ venkatesh
ETL Testing Resume @ venkateshETL Testing Resume @ venkatesh
ETL Testing Resume @ venkatesh
 
Basha_ETL_Developer
Basha_ETL_DeveloperBasha_ETL_Developer
Basha_ETL_Developer
 
Munir_Database_Developer
Munir_Database_DeveloperMunir_Database_Developer
Munir_Database_Developer
 
ChandraShekhar_5.11_yrs_exp
ChandraShekhar_5.11_yrs_expChandraShekhar_5.11_yrs_exp
ChandraShekhar_5.11_yrs_exp
 
Resume - Deepak v.s
Resume -  Deepak v.sResume -  Deepak v.s
Resume - Deepak v.s
 
Himel_Sen_Resume
Himel_Sen_ResumeHimel_Sen_Resume
Himel_Sen_Resume
 
Renu_Resume
Renu_ResumeRenu_Resume
Renu_Resume
 
Nitin Paliwal
Nitin PaliwalNitin Paliwal
Nitin Paliwal
 
Sreekanth Resume
Sreekanth  ResumeSreekanth  Resume
Sreekanth Resume
 
Sudeshna Ghosh Dastidar-Resume
Sudeshna Ghosh Dastidar-ResumeSudeshna Ghosh Dastidar-Resume
Sudeshna Ghosh Dastidar-Resume
 
Resume_PratikDey
Resume_PratikDeyResume_PratikDey
Resume_PratikDey
 
ShwetaKumar_ETLBITesting_3.7yr_faridabad
ShwetaKumar_ETLBITesting_3.7yr_faridabadShwetaKumar_ETLBITesting_3.7yr_faridabad
ShwetaKumar_ETLBITesting_3.7yr_faridabad
 
Shane_O'Neill_CV_slim
Shane_O'Neill_CV_slimShane_O'Neill_CV_slim
Shane_O'Neill_CV_slim
 
Resume_Gulley_Oct7_2016
Resume_Gulley_Oct7_2016Resume_Gulley_Oct7_2016
Resume_Gulley_Oct7_2016
 
Informatica_Rajesh-CV 28_03_16
Informatica_Rajesh-CV 28_03_16Informatica_Rajesh-CV 28_03_16
Informatica_Rajesh-CV 28_03_16
 

Viewers also liked

Teradata - Hadoop profile
Teradata - Hadoop profileTeradata - Hadoop profile
Teradata - Hadoop profile
Santosh Dandge
 
Aprimo /teradata CIm and DMC profile
Aprimo /teradata CIm and DMC profileAprimo /teradata CIm and DMC profile
Aprimo /teradata CIm and DMC profile
Shiva Kumar Reddy Pocha
 
Prashanth Kumar_Hadoop_NEW
Prashanth Kumar_Hadoop_NEWPrashanth Kumar_Hadoop_NEW
Prashanth Kumar_Hadoop_NEW
Prashanth Shankar kumar
 
JosephRPetroResume2016Q4-2.docx
JosephRPetroResume2016Q4-2.docxJosephRPetroResume2016Q4-2.docx
JosephRPetroResume2016Q4-2.docx
Joe Petro
 
Eric_Valle_Resume(revised)
Eric_Valle_Resume(revised)Eric_Valle_Resume(revised)
Eric_Valle_Resume(revised)
Eric Valle
 
Manual de serviço turuna82 embreage
Manual de serviço turuna82 embreageManual de serviço turuna82 embreage
Manual de serviço turuna82 embreage
Thiago Huari
 
2-page Resume ICO Jared Thibou
2-page Resume ICO Jared Thibou2-page Resume ICO Jared Thibou
2-page Resume ICO Jared Thibou
Jared Thibou
 
Tarun_Medimi
Tarun_MedimiTarun_Medimi
Tarun_Medimi
Tarun Medimi
 
7
77
Lesson2CraftingYourResume
Lesson2CraftingYourResumeLesson2CraftingYourResume
TARIFARIO
TARIFARIOTARIFARIO
TARIFARIO
Stefhany Tapia
 

Viewers also liked (12)

Teradata - Hadoop profile
Teradata - Hadoop profileTeradata - Hadoop profile
Teradata - Hadoop profile
 
Aprimo /teradata CIm and DMC profile
Aprimo /teradata CIm and DMC profileAprimo /teradata CIm and DMC profile
Aprimo /teradata CIm and DMC profile
 
Prashanth Kumar_Hadoop_NEW
Prashanth Kumar_Hadoop_NEWPrashanth Kumar_Hadoop_NEW
Prashanth Kumar_Hadoop_NEW
 
JosephRPetroResume2016Q4-2.docx
JosephRPetroResume2016Q4-2.docxJosephRPetroResume2016Q4-2.docx
JosephRPetroResume2016Q4-2.docx
 
Eric_Valle_Resume(revised)
Eric_Valle_Resume(revised)Eric_Valle_Resume(revised)
Eric_Valle_Resume(revised)
 
Manual de serviço turuna82 embreage
Manual de serviço turuna82 embreageManual de serviço turuna82 embreage
Manual de serviço turuna82 embreage
 
2-page Resume ICO Jared Thibou
2-page Resume ICO Jared Thibou2-page Resume ICO Jared Thibou
2-page Resume ICO Jared Thibou
 
Tarun_Medimi
Tarun_MedimiTarun_Medimi
Tarun_Medimi
 
7
77
7
 
Lesson2CraftingYourResume
Lesson2CraftingYourResumeLesson2CraftingYourResume
Lesson2CraftingYourResume
 
TARIFARIO
TARIFARIOTARIFARIO
TARIFARIO
 
app
appapp
app
 

Similar to Mukhtar resume etl_developer

Saranteja gutta wells
Saranteja gutta wellsSaranteja gutta wells
Saranteja gutta wells
ramesh5080
 
Resume ratna rao updated
Resume ratna rao updatedResume ratna rao updated
Resume ratna rao updated
Ratna Rao yamani
 
Resume_Ratna Rao updated
Resume_Ratna Rao updatedResume_Ratna Rao updated
Resume_Ratna Rao updated
Ratna Rao yamani
 
Informatica,Teradata,Oracle,SQL
Informatica,Teradata,Oracle,SQLInformatica,Teradata,Oracle,SQL
Informatica,Teradata,Oracle,SQL
sivakumar s
 
SivakumarS
SivakumarSSivakumarS
SivakumarS
sivakumar s
 
DS_Sreeram_7
DS_Sreeram_7DS_Sreeram_7
DS_Sreeram_7
sreerampratap
 
Shrikanth
ShrikanthShrikanth
Shrikanth
Shrikanth DM
 
RajeshS_ETL
RajeshS_ETLRajeshS_ETL
RajeshS_ETL
Rajesh Sundaram
 
Mohamed Mahgoub_CV
Mohamed Mahgoub_CVMohamed Mahgoub_CV
Mohamed Mahgoub_CV
Mohamed Mahgoub
 
WhatIsData-Blitz
WhatIsData-BlitzWhatIsData-Blitz
WhatIsData-Blitz
pharvener
 
Mahesh_Resume
Mahesh_ResumeMahesh_Resume
Mahesh_Resume
Mahesh B
 
Jacob Keecheril
Jacob KeecherilJacob Keecheril
Jacob Keecheril
Jacob Keecheril
 
Shivaprasada_Kodoth
Shivaprasada_KodothShivaprasada_Kodoth
Shivaprasada_Kodoth
Shivaprasada Kodoth
 
r4
r4r4
Richa_Profile
Richa_ProfileRicha_Profile
Richa_Profile
Richa Sharma
 
Eric Stone's Resume
Eric Stone's ResumeEric Stone's Resume
Eric Stone's Resume
Eric Stone
 
Veera Narayanaswamy_PLSQL_Profile
Veera Narayanaswamy_PLSQL_ProfileVeera Narayanaswamy_PLSQL_Profile
Veera Narayanaswamy_PLSQL_Profile
Veera Narayanaswamy M
 
Eric stone's resume
Eric stone's resumeEric stone's resume
Eric stone's resume
Eric Stone
 
Chandan's_Resume
Chandan's_ResumeChandan's_Resume
Chandan's_Resume
Chandan Das
 
Praveena-Resume-Lead
Praveena-Resume-LeadPraveena-Resume-Lead
Praveena-Resume-Lead
praveena wts
 

Similar to Mukhtar resume etl_developer (20)

Saranteja gutta wells
Saranteja gutta wellsSaranteja gutta wells
Saranteja gutta wells
 
Resume ratna rao updated
Resume ratna rao updatedResume ratna rao updated
Resume ratna rao updated
 
Resume_Ratna Rao updated
Resume_Ratna Rao updatedResume_Ratna Rao updated
Resume_Ratna Rao updated
 
Informatica,Teradata,Oracle,SQL
Informatica,Teradata,Oracle,SQLInformatica,Teradata,Oracle,SQL
Informatica,Teradata,Oracle,SQL
 
SivakumarS
SivakumarSSivakumarS
SivakumarS
 
DS_Sreeram_7
DS_Sreeram_7DS_Sreeram_7
DS_Sreeram_7
 
Shrikanth
ShrikanthShrikanth
Shrikanth
 
RajeshS_ETL
RajeshS_ETLRajeshS_ETL
RajeshS_ETL
 
Mohamed Mahgoub_CV
Mohamed Mahgoub_CVMohamed Mahgoub_CV
Mohamed Mahgoub_CV
 
WhatIsData-Blitz
WhatIsData-BlitzWhatIsData-Blitz
WhatIsData-Blitz
 
Mahesh_Resume
Mahesh_ResumeMahesh_Resume
Mahesh_Resume
 
Jacob Keecheril
Jacob KeecherilJacob Keecheril
Jacob Keecheril
 
Shivaprasada_Kodoth
Shivaprasada_KodothShivaprasada_Kodoth
Shivaprasada_Kodoth
 
r4
r4r4
r4
 
Richa_Profile
Richa_ProfileRicha_Profile
Richa_Profile
 
Eric Stone's Resume
Eric Stone's ResumeEric Stone's Resume
Eric Stone's Resume
 
Veera Narayanaswamy_PLSQL_Profile
Veera Narayanaswamy_PLSQL_ProfileVeera Narayanaswamy_PLSQL_Profile
Veera Narayanaswamy_PLSQL_Profile
 
Eric stone's resume
Eric stone's resumeEric stone's resume
Eric stone's resume
 
Chandan's_Resume
Chandan's_ResumeChandan's_Resume
Chandan's_Resume
 
Praveena-Resume-Lead
Praveena-Resume-LeadPraveena-Resume-Lead
Praveena-Resume-Lead
 

Recently uploaded

An Introduction to All Data Enterprise Integration
An Introduction to All Data Enterprise IntegrationAn Introduction to All Data Enterprise Integration
An Introduction to All Data Enterprise Integration
Safe Software
 
Session 1 - Intro to Robotic Process Automation.pdf
Session 1 - Intro to Robotic Process Automation.pdfSession 1 - Intro to Robotic Process Automation.pdf
Session 1 - Intro to Robotic Process Automation.pdf
UiPathCommunity
 
DynamoDB to ScyllaDB: Technical Comparison and the Path to Success
DynamoDB to ScyllaDB: Technical Comparison and the Path to SuccessDynamoDB to ScyllaDB: Technical Comparison and the Path to Success
DynamoDB to ScyllaDB: Technical Comparison and the Path to Success
ScyllaDB
 
Facilitation Skills - When to Use and Why.pptx
Facilitation Skills - When to Use and Why.pptxFacilitation Skills - When to Use and Why.pptx
Facilitation Skills - When to Use and Why.pptx
Knoldus Inc.
 
ScyllaDB Leaps Forward with Dor Laor, CEO of ScyllaDB
ScyllaDB Leaps Forward with Dor Laor, CEO of ScyllaDBScyllaDB Leaps Forward with Dor Laor, CEO of ScyllaDB
ScyllaDB Leaps Forward with Dor Laor, CEO of ScyllaDB
ScyllaDB
 
Day 2 - Intro to UiPath Studio Fundamentals
Day 2 - Intro to UiPath Studio FundamentalsDay 2 - Intro to UiPath Studio Fundamentals
Day 2 - Intro to UiPath Studio Fundamentals
UiPathCommunity
 
Mutation Testing for Task-Oriented Chatbots
Mutation Testing for Task-Oriented ChatbotsMutation Testing for Task-Oriented Chatbots
Mutation Testing for Task-Oriented Chatbots
Pablo Gómez Abajo
 
QA or the Highway - Component Testing: Bridging the gap between frontend appl...
QA or the Highway - Component Testing: Bridging the gap between frontend appl...QA or the Highway - Component Testing: Bridging the gap between frontend appl...
QA or the Highway - Component Testing: Bridging the gap between frontend appl...
zjhamm304
 
MongoDB to ScyllaDB: Technical Comparison and the Path to Success
MongoDB to ScyllaDB: Technical Comparison and the Path to SuccessMongoDB to ScyllaDB: Technical Comparison and the Path to Success
MongoDB to ScyllaDB: Technical Comparison and the Path to Success
ScyllaDB
 
CTO Insights: Steering a High-Stakes Database Migration
CTO Insights: Steering a High-Stakes Database MigrationCTO Insights: Steering a High-Stakes Database Migration
CTO Insights: Steering a High-Stakes Database Migration
ScyllaDB
 
Chapter 5 - Managing Test Activities V4.0
Chapter 5 - Managing Test Activities V4.0Chapter 5 - Managing Test Activities V4.0
Chapter 5 - Managing Test Activities V4.0
Neeraj Kumar Singh
 
Introduction to ThousandEyes AMER Webinar
Introduction  to ThousandEyes AMER WebinarIntroduction  to ThousandEyes AMER Webinar
Introduction to ThousandEyes AMER Webinar
ThousandEyes
 
Cyber Recovery Wargame
Cyber Recovery WargameCyber Recovery Wargame
Cyber Recovery Wargame
Databarracks
 
ThousandEyes New Product Features and Release Highlights: June 2024
ThousandEyes New Product Features and Release Highlights: June 2024ThousandEyes New Product Features and Release Highlights: June 2024
ThousandEyes New Product Features and Release Highlights: June 2024
ThousandEyes
 
intra-mart Accel series 2024 Spring updates_En
intra-mart Accel series 2024 Spring updates_Enintra-mart Accel series 2024 Spring updates_En
intra-mart Accel series 2024 Spring updates_En
NTTDATA INTRAMART
 
Demystifying Knowledge Management through Storytelling
Demystifying Knowledge Management through StorytellingDemystifying Knowledge Management through Storytelling
Demystifying Knowledge Management through Storytelling
Enterprise Knowledge
 
Elasticity vs. State? Exploring Kafka Streams Cassandra State Store
Elasticity vs. State? Exploring Kafka Streams Cassandra State StoreElasticity vs. State? Exploring Kafka Streams Cassandra State Store
Elasticity vs. State? Exploring Kafka Streams Cassandra State Store
ScyllaDB
 
An All-Around Benchmark of the DBaaS Market
An All-Around Benchmark of the DBaaS MarketAn All-Around Benchmark of the DBaaS Market
An All-Around Benchmark of the DBaaS Market
ScyllaDB
 
Call Girls Kochi 💯Call Us 🔝 7426014248 🔝 Independent Kochi Escorts Service Av...
Call Girls Kochi 💯Call Us 🔝 7426014248 🔝 Independent Kochi Escorts Service Av...Call Girls Kochi 💯Call Us 🔝 7426014248 🔝 Independent Kochi Escorts Service Av...
Call Girls Kochi 💯Call Us 🔝 7426014248 🔝 Independent Kochi Escorts Service Av...
dipikamodels1
 
From NCSA to the National Research Platform
From NCSA to the National Research PlatformFrom NCSA to the National Research Platform
From NCSA to the National Research Platform
Larry Smarr
 

Recently uploaded (20)

An Introduction to All Data Enterprise Integration
An Introduction to All Data Enterprise IntegrationAn Introduction to All Data Enterprise Integration
An Introduction to All Data Enterprise Integration
 
Session 1 - Intro to Robotic Process Automation.pdf
Session 1 - Intro to Robotic Process Automation.pdfSession 1 - Intro to Robotic Process Automation.pdf
Session 1 - Intro to Robotic Process Automation.pdf
 
DynamoDB to ScyllaDB: Technical Comparison and the Path to Success
DynamoDB to ScyllaDB: Technical Comparison and the Path to SuccessDynamoDB to ScyllaDB: Technical Comparison and the Path to Success
DynamoDB to ScyllaDB: Technical Comparison and the Path to Success
 
Facilitation Skills - When to Use and Why.pptx
Facilitation Skills - When to Use and Why.pptxFacilitation Skills - When to Use and Why.pptx
Facilitation Skills - When to Use and Why.pptx
 
ScyllaDB Leaps Forward with Dor Laor, CEO of ScyllaDB
ScyllaDB Leaps Forward with Dor Laor, CEO of ScyllaDBScyllaDB Leaps Forward with Dor Laor, CEO of ScyllaDB
ScyllaDB Leaps Forward with Dor Laor, CEO of ScyllaDB
 
Day 2 - Intro to UiPath Studio Fundamentals
Day 2 - Intro to UiPath Studio FundamentalsDay 2 - Intro to UiPath Studio Fundamentals
Day 2 - Intro to UiPath Studio Fundamentals
 
Mutation Testing for Task-Oriented Chatbots
Mutation Testing for Task-Oriented ChatbotsMutation Testing for Task-Oriented Chatbots
Mutation Testing for Task-Oriented Chatbots
 
QA or the Highway - Component Testing: Bridging the gap between frontend appl...
QA or the Highway - Component Testing: Bridging the gap between frontend appl...QA or the Highway - Component Testing: Bridging the gap between frontend appl...
QA or the Highway - Component Testing: Bridging the gap between frontend appl...
 
MongoDB to ScyllaDB: Technical Comparison and the Path to Success
MongoDB to ScyllaDB: Technical Comparison and the Path to SuccessMongoDB to ScyllaDB: Technical Comparison and the Path to Success
MongoDB to ScyllaDB: Technical Comparison and the Path to Success
 
CTO Insights: Steering a High-Stakes Database Migration
CTO Insights: Steering a High-Stakes Database MigrationCTO Insights: Steering a High-Stakes Database Migration
CTO Insights: Steering a High-Stakes Database Migration
 
Chapter 5 - Managing Test Activities V4.0
Chapter 5 - Managing Test Activities V4.0Chapter 5 - Managing Test Activities V4.0
Chapter 5 - Managing Test Activities V4.0
 
Introduction to ThousandEyes AMER Webinar
Introduction  to ThousandEyes AMER WebinarIntroduction  to ThousandEyes AMER Webinar
Introduction to ThousandEyes AMER Webinar
 
Cyber Recovery Wargame
Cyber Recovery WargameCyber Recovery Wargame
Cyber Recovery Wargame
 
ThousandEyes New Product Features and Release Highlights: June 2024
ThousandEyes New Product Features and Release Highlights: June 2024ThousandEyes New Product Features and Release Highlights: June 2024
ThousandEyes New Product Features and Release Highlights: June 2024
 
intra-mart Accel series 2024 Spring updates_En
intra-mart Accel series 2024 Spring updates_Enintra-mart Accel series 2024 Spring updates_En
intra-mart Accel series 2024 Spring updates_En
 
Demystifying Knowledge Management through Storytelling
Demystifying Knowledge Management through StorytellingDemystifying Knowledge Management through Storytelling
Demystifying Knowledge Management through Storytelling
 
Elasticity vs. State? Exploring Kafka Streams Cassandra State Store
Elasticity vs. State? Exploring Kafka Streams Cassandra State StoreElasticity vs. State? Exploring Kafka Streams Cassandra State Store
Elasticity vs. State? Exploring Kafka Streams Cassandra State Store
 
An All-Around Benchmark of the DBaaS Market
An All-Around Benchmark of the DBaaS MarketAn All-Around Benchmark of the DBaaS Market
An All-Around Benchmark of the DBaaS Market
 
Call Girls Kochi 💯Call Us 🔝 7426014248 🔝 Independent Kochi Escorts Service Av...
Call Girls Kochi 💯Call Us 🔝 7426014248 🔝 Independent Kochi Escorts Service Av...Call Girls Kochi 💯Call Us 🔝 7426014248 🔝 Independent Kochi Escorts Service Av...
Call Girls Kochi 💯Call Us 🔝 7426014248 🔝 Independent Kochi Escorts Service Av...
 
From NCSA to the National Research Platform
From NCSA to the National Research PlatformFrom NCSA to the National Research Platform
From NCSA to the National Research Platform
 

Mukhtar resume etl_developer

  • 1. Mukhtar Ahmed 1 SUMMARY  Over 8 years of work experience in the field of Data Warehousing involving various ETL projects.  All-round experience in design, build, deploy and support of DWH-ETL processes.  In depth Knowledge and understanding of the DWHconcepts and Dimensional modeling.  Highly specialized in working on IBM InfoSphere Datastage 11.3/8.x, Ascential Datastage 7.x/6.0  Worked on Server/Parallel/Sequence Datastage jobs involving variety of different stages.  Worked on File stages like CFF, Hash file, Flat file, Datasets, Sequential file stages  Processing stages like Merge, Join, Lookup, Transformer, Aggregator, Sort, Remove Duplicate, CDC, Funnel, Copy, Surrogate key Generator,  Database Stages like ODBC, DB2-UDB, Oracle connector, Teradata stage, TPT connector  Built Shared Containers, Basic routines, Multi-Instance jobs, Before/After subroutines  Worked on multiple databases Teradata, DB2, Netteza, Oracle, SQL Server.  Expert in working on Teradata Tools & Utilities (BTEQ/Fastload/Fast export/Multiload/TPT/Tbuild)  Skilled in writing UNIX shell scripts and generic DS automation scripts to execute DS jobs.  Worked on multiple scheduling/monitoring tools such as Tivoli Workstation, Control-m, Autosys.  Specialized in dealing with massive Data-warehouse applications (larger than 100 Terabytes)  Confident in building high Quality code including Performance tuning & Query Optimization  Hands-on experience in Datastage/Teradata/AIX upgrade/migration projects.  Good understanding of the reporting tools like Cognos, Tableau, Business Objects.  Expert in Operations & Production support functions to resolve Datastage/Teradata job aborts.  Worked on Tivoli storage management tools for archival and retrieval of the data files  Well versed with all the AIX/UNIX commands required for performing ETL job.  Gained knowledge on Health Care, Retail Banking, Mortgage, Insurance domain over time. TECHNICALSKILLS: ETL Tools : IBM Data stage 8.1/8.5/11.3, Ascential Datastage 7.5. RDBMS : SQL scripting in TERADATA, DB2, ORACLE 8.1, MS-SQL Server 6.5/7.0 Teradata Tools: : BTEQ/FASTEXPORT/FASTLOAD/MULTILOAD/TPT/TPUMP SQL Clients : Teradata SQL Assistant, DB2 Control Center, Toad, SQL Developer. O/S : AIX 6.1/7.1 (UNIX scripting), Windows batch scripting, Mainframes Z-OS Scheduling Tools : Control-M V6.3 & V7, Tivoli Workload Scheduler(TWS), Autosys. Versioning Tools : MKS Source & Integrity, SVN Tortoise Archive Tools : Tivoli Storage Manager(TSM) QA Tools : HP QC & ALM Document Tools : Microsoft Office Excel/Word/PPT/VISIO , Ultra Edit ,Text Pad TRAINING & CERTIFICATION:  Six Sigma –White belt trained professional.  Company trained and certified on AIX, RDBMS and Data warehousing  Passed the Data Stage Competency test conducted within the organization.  Trained on Teradata database and utilities.  Internally certified on global courses like Global Anti-Bribery, Anti Money Laundering, Information Security Risk and Privacy/Data Protection Awareness EDUCATIONAL BACKGROUND: BE in Information Technology, Osmania University, 2004 – 2008 13800 ChestnutDrive, APT 208, Eden Prairie, Minnesota 55344, U.S.A. Email id:asad_3077@yahoo.com Cell:+1-952-737-2060
  • 2. Mukhtar Ahmed 2 PROFESSIONAL EXPERIENCE: Optum Technology Inc. (UnitedHealth Group), Sr. ETL Developer November 2014 - Present Project: Normative Health Informatics, Adding Health care data of over 10 million members useful for the research and analysis of Lifesciences.  Build complex Data stage jobs to handle huge work load of data (100’s of billions of records).  Utilize Teradata Tools and Utilities like BTEQ/Fastload/Multiload/Tbuild/TPT framework to load large tables of over 2 terabytes.  Build unique primary/secondary/join indexes on Teradata tables  Worked on both Server and Parallel Datastage jobs involving all the different stages like File stages (Sequential, Dataset, CFF, Hash files), Processing stages (Transformer, Sort, Remove Duplicate, Aggregate, Copy, Merge, Join, Lookup, CDC, Funnel), Database Stages (ODBC, TD enterprise, TPT Connector, TD Multiload, DB2, Oracle connector etc.,.)  Develop Generic shell scripts on AIX server to execute thousands of Data stage & Teradata jobs.  Create Tivoli workstation jobs to schedule and automate the execution of these jobs.  Coordinate with teams across locations in smooth execution of ETL process & data deliverables.  Build ETL metric solution for detecting monthly increase/decrease of data from source files.  Take full ownership for proper functioning of application processes and maintaining Data quality.  Re-designing and Optimizing the existing processes where required.  Carrying out capacity planning and taking proactive measures to avoid production issues.  Follow Agile methodology techniques for progressing and tracking day to day project tasks Environment: AIX 7.1, Datastage 8.5/11,3, Teradata 14/15, TWS, HPSM, SVN. Optum Technology Inc. (UnitedHealth Group), Sr. ETL Developer September 2013 - November 2014 Project: Parallax-I and Humedica data integration, Integration of over additional 1 million members Health Care data critical for analyzing and researching for UnitedHealth care business, this also involved migrations/upgrades of the existing system.  Develop load process for member data and generate rekey data for medical claims rekey.  Create new File Watcher jobs to help receive thousands of files at landing path and properly move, process and archive them for future usage.  Build complex data stage jobs to cleanse, transform and de-identify the source data  Build Load scripts using TPT framework for parallel loading millions of records in tables  Define unique primary indexes/secondary indexes/Join indexes on the tables  Create different views on top of the tables to de-identify and showcase only the relevant data.  Create new Unix shell scripts for running hundreds of DS jobs using automated scripts  Build new TWS scheduling jobs to execute the newly build processes in proper order.  Work on BA request to perform detailed impact analysis on application design issues/changes.  Write Technical specification documents and flow diagrams and keep them up to date.  Build healthy relationship with project stakeholders/ business partners. Environment: AIX 6.3, Datastage 8.5, Teradata 14, TWS, HPSM, SVN.
  • 3. Mukhtar Ahmed 3 HSBC Software Dev. Pvt. Ltd, Sr. ETL Developer, Nov 2012 – Sep 2013 Project: Mortgage Transformation Program, tracking and storing every single event that happens during the lifecycle of the mortgage application required for research.  Lead projects though all SDLC phases, utilize team & ensure timely delivery as per release plan.  Interact with the Business Analysts to understand ETL requirements  Understanding the Mortgage Application journey in terms of different Milestones  Design complex ETL processes, Basic server routines, Teradata Sql Scripts(BTEQ)  Build data cleansing, validation and DSJOB scripts using UNIX shell scripting  Build multiple instance jobs to run the same process for 72 different sites  Utilize Run time column propagation to deal with multiple set of files  Use Import/Export commands for migrating the data stage code across the projects  Developed Datastage jobs involving Join/lookup/merge/transform/remove duplicate/funnel stages  Recommendations for new data mart design as well as improvements in current data warehouse  Act as a reviewer on Technical review panel and review code created by other team members  Ensure compliance with organization and project defined standards and processes  Follow and enforce best practices, framework processes, standards and conventions. Environment: AIX 6.3, Teradata, HP-QC, Datastage 8.1, Trillium server, Control-M. HSBC Software Development Pvt. Ltd, ETL Developer, Jul 2011 – Nov 2012 Project: Liquidity Management Program, Project was about gathering and storing details about all the liquidity assets and liabilities held by HSBC UK business critical for calculating the liquidity risk.  Understand the business requirement and functional specifications documents  Create Technical design documents and Data model documents  Build sequencers to run datastage jobs, Routines, shell scripts in loops as per requirement  Develop parallel jobs involving stages like transformer,sort, Remove Duplicate, aggregator, merge, join, Lookup, change capture, change apply, peek stages.  Create Basic routines to generate and allocate new ID for different source files received.  Explain plan verification and optimizing SQL query by building join/secondary/primary indexes.  Execute the System integration, User acceptance test as per plans  Create DDL for several tables and define proper indexes, datatypes, compression.  Use MKS Integrity code versioning tool for checking in/out the code components.  Verify crystal reports on Cognos framework to track and test the mortgage application status  Provide secured data access to the users as per Compliance requests.  Ensure compliance with organization and project defined standards and processes Environment: IBM Information server Datastage 8.0, Teradata, Sql Server, UNIX/AIX, Control –M, MKS Integrity, ERWIN 4.1. HSBC Software Development Pvt. Ltd, ETL Developer, Apr 2010 – Jun 2011
  • 4. Mukhtar Ahmed 4 Project: Global Analytics & Integration Project, Integration of multiple sources data into a single warehouse.  Involved in Integration of several modules in the Global Analytics across different Regions  Build/Amend, Test and Deploy Datastage Jobs and DB2 SQL scripts  Build jobs to read source files using CFF stage/Hash file/Dataset/Sequential files  Carry out Server to Parallel code changes, test and deploy it to Production.  Build UNIX/AIX shell script for archival and retrieval of the source files  Creating Control-M 6.3 Batch scheduling drafts and migrating them to production environment  Coordinate with QA test team and fix the pending Defects.  Undertake Productivity and Quality assurance initiatives across the team Environment: Unix, DB2, Oracle 10g/9i, Control-M 6.3, Datastage 7.5 HSBC Software Development Pvt. Ltd, ETL Developer, Jun 2008 – Mar 2010 Project: Teradata Migration, Project was about migrating an existing UK data warehouse platform from DB2 database to the Teradata database.  Run Datastage server/parallel/sequence jobs on both DB2 and Teradata environment in parallel  Build new BTEQ scripts, fast load/fast export scripts, TPT scripts for loading and extracting data.  Utilize Control-M scheduling tool to run Datastage jobs on top of DB2 and Teradata  Utilize Golden gate tool to identify any mismatch during data reconciliations  Capture test results and perform the reconciliation between the data  Raise any defects identified during the test run and reconciliations  Perform root cause analysis and apply fixes for the defects  Extensively use the Quality center to log and track the defects till closure  Attend Daily status calls and update the run progress Environment: AIX 6.3, Datastage 8.0, Teradata, DB2, Control-M, Golden Gate. Achievements:  Sustaining Edge Award, Excellence at Workplace & Remarkable Contribution.  Above & Beyond Award - Best Quality Deliverables.  Long Service Award: 4 years of Excellent Service to the organization.  Reuse & Innovation Award - Most Productive Initiation.  Pat on a Back Award: Awarded for Hard work and Dedication. PROFESSIONAL SUMMARY: Software Engineer, HSBC Software Development Pvt. Ltd. June 2008 - September 2013. Senior Software Engineer, Optum Services Inc. (UnitedHealth Group), September 2013 - Present. References: Available upon request
  翻译: