Prashant Khadapkar

** ******* ********, *********, **, L4J2X1 437-***-**** addwzd@r.postjobfree.com

PROFESSIONAL PROFILE

Worked as Senior IT professional with more than 14 years of experience in software development, with focus on DBMS, Data Warehousing, ETL and Reporting. Also, worked in several areas of Data Warehouse development including Business Analysis, Requirement Gathering, Design, Development, Testing, Training, and Implementation. Experienced in successfully delivering many projects in retail, supply chain and finance domain. Experienced as onsite coordinator and mentored team of more than 5 members.

WORK EXPERIENCE

TalentNet Inc Nov 2017 to Oct 2019

[Staffing supplier]

Held position as Technical System Analyst:

Roles and responsibilities:

Worked as individual contractor for client (Royal Bank of Canada) on a complex Data warehousing requirement, which need good knowledge of multiple technologies like Teradata, DataStage, Mainframe, UNIX and Hadoop. Worked as lead on ESN Daily development Project. Also, worked on IFRS9 Data lineage, Pillar-3 and Mapador projects. Code development using Agile methodology. Coordinate with different group to move code to Production environment using Endevor system. Use AR (Activity record) portal to move code to production and getting signoff from all stakeholder. Prepare Operational Manuals (OMS) document for any change in job schedule or any new job schedule. Providing maintenance and support for reporting tool “ESN (Enterprise Single Name) Daily” and Operational metadata repository (OMDR).

Teradata India Pvt Ltd, Mumbai, India Nov 2011 to Oct 2017

[Leading end-to-end service provider in data warehousing, big data and marketing application]

Held position as Senior Technical Consultant:

Roles and responsibilities:

Worked as onshore coordinator and lead. Worked on a complex Data warehousing requirement, which need good knowledge of multiple technologies like Teradata, DataStage, Mainframe, UNIX. Interact and understand requirement from client (Royal Bank of Canada) and convert into technical requirement for mentors at offshore. Active participation in estimation and deciding project timelines. Analyze existing system to determine impact to existing system. Code development and unit testing to ensure solution is delivered as per requirement with quality. Coordinate with offshore and onshore team members for analyzing and providing technical solutions. Exposure to finance domain. Coordinate with different group to move code to Production environment using Endevor system. Use AR (Activity record) creation for steps to move code to production and getting signoff from all stakeholder. Developed complex reporting tool “ESN (Enterprise Single Name) Daily” which provides risk and profits margins to Royal bank of Canada due to its wholesale and retail clients. Worked on optimization of Teradata proprietary tool like Datamover which is most efficient tool to copy data between two Teradata systems. Also, worked on some of the RBC initiatives like Risk Enablement, Credit Card Adjudication, eStatement Migration, Business risk rating, DMTI - Historical Address Clean Up etc.

Prashant Khadapkar Page 2

Tata Consultancy services Limited, Mumbai, India Apr 2011 to Nov 2011

[India’s largest and leading IT services, consulting and business solutions provider organization]

Held position as I. T. Analyst:

Roles and responsibilities:

Involved in development and maintenance of datawarehouse for US client “Avery Dennison”. Worked as acting lead during datawarehouse development. Extensively worked on performance tuning of datastage code and Oracle queries. Also, delivered more than 20 defects free production code releases in one month time. Experienced in retail domain.

Capgemini India Private Limited, Mumbai, India Oct 2007 to Apr 2011

[India’s leading software consulting organization]

Held position as Senior Consultant:

Roles and responsibilities:

Majorly worked in supply chain domain for client like Corporate Express and Schneider electric. Also, worked for retail domain client like Marks works warehouse for its data migration activity and JDA integration project. Worked on job scheduling using Datastage designer. Worked in various phases of SDLC I,e, Requirement gathering, Analysis, Design, Development and Testing. Heavily worked on query tuning and creation of Datastage parallel jobs and sequences.

Tata Consultancy services Limited, Mumbai, India Oct 2006 to Oct 2007

[India’s largest and leading IT services, consulting and business solutions provider organization]

Held position as Assistant system engineer:

Roles and responsibilities:

Gained experience in supply chain domain by working for renowned client like Cisco for building their datamart. Responsible for requirement gathering, analysis, creating functional and Technical specification documents related to critical and highly visible project like “Global Supply Management Tool”. Designed Oracle Packages, Procedures, Functions, Triggers and UNIX scripts. Also, worked for leading global investment firm to build reporting tool for business decision making.

TeamLease services private limited, Mumbai, India Jun 2005 to Oct 2006

[India’s leading human resource organization]

Held position as Application engineer:

Roles and responsibilities:

Worked for Reliance Petroleum which is India’s biggest supplier of petroleum products. Responsible for requirement gathering, analysis, creating functional and Technical specification documents. Designed and developed Integrated business solution (IBS) tool which provides reports of transactions done at reliance gas stations across India.

Prashant Khadapkar Page 3

SKILL SETS

Operating Systems:

Windows NT/200x Server and Unix (AIX).

ETL Tools:

IBM DataStage, QualityStage, Information analyzer datastage

Reporting Tools:

Hyperian SQR

RDBMS:

Teradata, Oracle 10g, DB2, MySQL

Other Languages/ Technologies

PL/Sql, Unix Shell Scripting, DataMover, Python, Sqoop

CERTIFICATIONS

Oracle certified associate, v9i

IBM certified datastage developer, v8.1

EDUCATION

Bachelors of Electronics Engineering, Mumbai University

1998-2002

Contact this candidate