Prabhakar Dukka

ac4ozq@r.postjobfree.com

647-***-****

Professional Summary and Objective:

Over 16 years of strong experience in IT Industry with Development, Maintenance, Testing, Design and Leadership expertise on Data Warehouse & Client/Server applications. Involved in implementing End to End data warehouse projects using Water-fall, Agile, ITIL and KANBAN methodology of project delivery. Well versed with Data-Modeling, Data Migration and Pre-sales (POC) related activities. Looking for a challenging opportunity within an organization that allows professional & personal growth.

Summary:

12 years of strong Data Warehouse experience as an Informatica Developer and Tech/Team Lead positions.

Experience in performing ETL design and development for clients across Insurance, Telecommunication, Retail, Health Care, Manufacturing domains/industries and populating Data Marts and Data Warehouse using Star, Snowflake and Data Vault models with in EDW environment.

Highly Skilled in Informatica versions 8.x, 9.x (Power center and Power exchange), Database, UNIX, ETL & BI.

Strong experience in performance optimization of code with in Informatica and Oracle implementing best practices, also involved in data profiling related activities.

Good working knowledge on Oracle, SQL server and DB2 databases and having experience of writing SQL and PL/SQL blocks including stored procedures, functions, triggers etc.

Involved in Informatica / DB version migration project deliveries and productions support activities.

Strong knowledge on all frequently used Informatica transformations used to prepare ETL load strategy of delivery.

Experienced in Agile-KANBAN/Waterfall & ITIL model to deal with the development and change managements.

Skilled on scheduling tools like Control-M, Tidal and Informatica scheduling etc.

Experienced in reporting tools such as Business Objects and Cognos.

Experienced in Versioning tools like WinCvs, Informatica version control.

Expertise in analytical, reasoning, problem-solving and communications skills.

Experienced with preparing and putting documentation together for implementation plans for projects and provided analysis and production support documents, TDD, BRD, SRS for business etc.

Demonstrate strong leadership’s skills by successfully leading medium scale teams and projects.

Knowledge on BIGDATA analytics and Bigdata tools.

4+ years of experience in Client/Server technology area with Oracle and Visual Basic 6.0 technologies.

Technical Skills:

ETL Tools : INFORMATICA (8x/9x), Datastage 9.1, Tableau (Knowledge), SSIS-2012

Modeling Tool : ERWIN

OLAP : Business Objects/Cognos/MSOLAP, SAP-BI 7.1(Knowledge)

Scheduling Tools : Tidal, Control-M

Databases : Oracle –11c/12c, SQL Server-2000, DB2

Languages : C, C++, SQL, PL/SQL, Visual Basic-6.0

Testing Tool : HPQC – ALM (Application lifecycle management)

Others : HPSM (HP Service Manager Incident Management), Leankit (Kanban process flow)

Employment History:-

Intact Financial Corporation (Insurance) Mar 2015 – Till date

Intact Insurance is the largest provider of property and Auto insurance in Canada with close to $8.0 billion in annual premiums. Formerly an ING Group subsidiary, ING Canada, Intact became a widely held Canadian company and changed its name from ING Canada to Intact Insurance in 2009.

Title: Sr. Informatica Developer/Tech Lead (Development & Production Support)

Being a consultant and Independent contributor, my responsibility at Intact is to deliver the projects with quality involving the followings such as part of core Informatica Development, production support, and Analysis team, taking additional responsibilities and initiative to be part of technical review board, performance improvement, estimations, deliver and priority of small scale projects as a Business Analyst, QA strategies, mentoring junior/new team members to help them up to the speed to deliver the project with quality. Responsible for preparing design and support documents to help smooth transition to other teams.

Responsible for loading data to Intact Enterprise Data Warehouse (EDW) through intermediate staging tables reading source data from Guidewire in the form of XML messages, Halcion, Classic claim source systems, Intersystem DB for telephony data, flat files etc. Also responsible for loading Dimension & Fact tables and generate external feeds for business purpose & fraud detection vendors like CANATICS, NET-REVEAL etc.

Loading claims data using Data Vault model implementing complex business logics and harmonization of data to tables like (Hub, Links, Satellites, Business Data Vault tables) using Informatica power center. Creating new Informatica mappings/reusable objects to load these tables implementing complex business rules.

Responsible for end to end delivery of Backlog defect tickets (includes design BRD, SRS, development, unit testing - Test Driven Development approach, code review, QA review, deployment of code to different lower/QA environments, Preparing support documents) also runs Scrum meeting updating KANBAN board on daily basis.

Acting/Interacting as/with Business Analyst, Architects, design and reviewing QA strategies on regular basis to gather the requirement and preparing the mapping specs to code the business logics efficiently to deliver quality code.

Working on delivery Process improvement and also involved in performance tuning of existing & new ETL objects.

Ownership of code promotion in lower environments and responsible for providing data to QA person by running daily and monthly end to end data load cycles for each release.

Working with Support team to analyze the backlog tickets and to resolve the same as part of performance improvement. Provide business support on systems releases, project implementations and project warranty support.

Worked on Stabilization project to simplify the Business Data Vault tables Sources from oracle views. This in turn uses Hubs, Satellites, and Link tables Business rules have been re-performed keeping in mind resolving many production issues.

Responsible for end to end software testing life cycle for selected projects like Functional, Regression, SIT, UAT.

Technology: Informatica Power Center 9.6.1, Oracle 12c, Control M, UNIX, HPSM, ALM, Leankit,

Allstreeam (Telecommunications) Aug 2014 – Dec 2014

Title: Sr.Informatica/Datastage Consultant

Interacting with business to gather requirements and to propose the effective and efficient ETL design and solution.

Developed extracts for Vendors based on the Building master and Customer data.

Created simple/complex Informatica mappings to load dimension and fact tables.

Created/enhanced project templates for the technical requirements and design and testing documents.

Actively involved in the code review for ETL code and to give sign off.

Developed scheduling using Tidal and Informatica for informatica workflows.

Assist and support team members in performance tuning activities in Informatica and DB.

Technology: Informatica PowerCenter 9.5.1, Datastage 9.1 Quality Stage, Oracle 11g, DB2, SQL Server 2005, Tidal, UNIX.

CGI Group Inc. (IT Consulting) June 2012 - Aug 2014

Title: Sr. Informatica Developer / Technical Lead

Developed Data warehouse for a leading Health Care/Insurance Provider and Oil and Gas Manufacturer using Informatica as ETL tool.

Lead a team of 5 Informatica team and was responsible for near shore deliverables.

Interacted with Client and business to gather requirements and actively involved in the design phase of the projects.

Implemented CDC using Informatica Power Exchange

Developed extracts for Vendors based on the Enterprise data and sourcing data from web-based UI more real time data process source system.

Provide efficient suggestion and solutions to client on delivery. Developed many complex mappings and also involved in performance tuning of mappings and Database objects. Suggested proper new ETL for all data warehouse operations with proper analysis and selection.

Created/enhanced project templates for the technical requirements and design and testing documents.

Created standards and best practices for Informatica Coding.

Used WINCVS as Version control tool.

Actively involved in the code review for ETL code and to give sign off.

Developed scheduling using TIDAL for informatica workflows.

Created Informatica mapping to load fact and dimension tables.

Assist and support team members in performance tuning activities in informatica.

Deployment admin for deploying the ETL and DB code to QA, UAT environments for Tufts Client.

Technology: Informatica Power Center 9.5.1, Informatica Power Exchange CDC, Oracle 10-11g, Tidal, UNIX.

KPIT Cummins Infosystems Ltd. (IT Consulting) April 2007 - May 2012

Title: Technical Project Manager

Developed Data warehouse for a leading Retail giant, manufacturing clients using Informatica as ETL tool.

Lead a team of 8 members and was responsible for onshore- offshore deliverables, coordination etc.

Involved in annual evaluation process for the team members and also conducted appraisal meetings.

Responsible for conducting weekly review meetings with client managers and presenting the status of deliverables.

Using PRISM/ITIL process to prioritize the production tickets.

Created a supply chain management application for a manufacturing client by creating a data mart.

Deployment admin for deploying the code to QA, UAT and Production environments.

Created standards and best practices for Informatica Coding.

Actively involved in the code review for ETL code and to give sign off.

Created Informatica mapping to load fact and dimension tables.

Involved in QA testing and UAT testing to interact with QA team and business to requirement analysis and to fix the defects.

Received appreciation awards from Client for on time Delivery of the project.

Created POC using Datastage and Informatica as data quality tool for a Telecommunication and Health care client.

Technology: Informatica 8.6.1, Oracle 10g, Quality Center 9.2, UNIX, Business Object, CONTROL+M.

MindTree Consulting Ltd (IT Consulting) April 2006 – March 2007

Title: Consultant / Informatica Developer

Developed Data warehouse for a leading Insurance clients in US.

Team Member for various data warehousing projects and successfully implemented the DW concepts.

Designed and automated Rejection Handling System for the Project which receives source files and bad records are sent back to business automatically.

Involved in QA testing and UAT testing to interact with QA team and business to requirement analysis and to fix the defects.

Handled independent Modules for on-time delivery with minimal defects and involved in data modeling.

Received appreciation awards from Client for on time Delivery of the project.

Technology: Informatica 7.1, Erwin, ORACLE-9i, UNIX, Tidal, Flat files, Siebel

Tecnovate eSolution Pvt.Ltd (IT Consulting) Aug 2005 – March 2006

Title: Technical Consultant / Informatica Developer

Developed Data warehouse for a leading Travel and Insurance clients in UK and Europe

Team Member for various data warehousing projects and successfully implemented the DW concepts.

Designed and automated Rejection Handling System for the Project which receives source files and bad records are sent back to business automatically.

Involved in QA testing and UAT testing to interact with QA team and business to requirement analysis and to fix the defects.

Handled independent Modules for on-time delivery with minimal defects and involved in data modeling.

Received appreciation awards from Client for on time Delivery of the project.

Technology: Informatica 6.2, Erwin, SQL Server, UNIX, Control M.

FORE (Software Development Center) (Education & Research) Jan 2001 – July 2005

Title: System Analyst cum Programmer

Developed In-house projects on different modules (HR, Accounts, Admin etc.).

Technology: Oracle, Visual Basic.

Education:

Masters of Computer Application from Maharishi Dayanand University.

Bachelor of Science from Sambalpur University.

Training Courses undergone:

5 Days Full time corporate PMP (PMBOK) Workshop

5 Days Full time corporate SAP BI (SAP Net viewer) Workshop.

4 weeks of part time training on BIGDATA methodologies and tools (HIVE, Map-reduce, PIG)

Trainings Provided:-

5 Days full time Training on Informatica 8.1 to 2007 Campus selection batch at Mind Tree Bangalore.

5 Days full time Training on Hospital Management system to Fortis Hospital staff (New Delhi).

Mentored junior team members on their projects at Mind Tree, KPIT, and CGI.

Achievements:-

Received “Cheers Award” at KPIT while worked for Unilever client-site for stabilize the project.

Received “SPOT AWARD” From SONY working at client-site on a tight deadline to deliver the project single handed, on-time and best of quality.

Received “Thank you” award from client Tufts Health plan, CGI, Intact Financials to deliver the project on time, Quality with in the process inline.

References:- Available upon request.

Contact this candidate