Kamal Kakkar

Experience

• 

  Tata Consultancy Services

  Jul 2003 - Sept 2006

  Software Enggineer

  Primary Role: ETL Developer/LeadClient: Agilent Technologies, USA• Led a team to create audit reconciliation process between balanced sheet and General Ledger to improve performance by 50% and change frequency from daily to every 10 mins.• Developed Business Analytics reports and programs to provide managerial accounting reports.• Extensively used Informatica PowerCenter 7.1.4 for Extracting, Transforming, and Loading into GDW.• Worked on Informatica Power Connect 7.1 to work on SAP and Oracle Apps Sources.• End-to-End data validation for CRM (Customer Relationship), SCA (Supply Chain) and Financial modules.• Extensive knowledge of data warehousing Development Life Cycle• Worked on SOX (Sarbanes–Oxley) and Six Sigma audit projects.Underwent Induction Training Program conducted for trainees and attended various courses like Software Development process, Requirement analysis, system design. Concepts of UNIX, Oracle, C and C++, Object Oriented Methodology, UML, Soft Skill and Two Dummies project in C, C++ on UNIX Environment.Achievements: Oracle Certified (OCA), Informatica v6 certification, TCS Star of Month Show less

• 

  West Bend Insurance Company

  Sept 2006 - Aug 2007

  Sr. Informatica Developer

  • Performed end to end implementation (requirements, design, development, testing) of new Claims Datamart to change the reporting from weekly to every 30 mins. (Near real time)• Managed a team of ten onshore and offshore developers for implementation of new policy administration tool, and decommissioned old mainframe PAS to add scalability. • Worked with business to gather the requirements and business rules.• Designed, developed and tested different ETL codes, according to the requirements.• Created necessary test plans and design documents for the mappings.• Integrated various sources into the staging area in Data Warehouse.Achievements: AINS (associate in insurance), Informatica v7 consultant level certified. Show less

• 

  Informatica

  Aug 2007 - Jun 2008

  Sr Consultant

  Primary Role: ETL Designer/Architect/Lead DeveloperClients: AmericanExpress/Safeco/Avaya/Barclays/AAA• Led team to completely overhaul ETL architecture and best practices for Fortune 50 clients (ex. AMEX).• Designed architecture to remove any SPOF and helped with 35% of performance improvements.• Expert on Informatica products responsible for architecture/design/build of solution based on customer needs and Informatica products. • Managed and Trained Informatica consultants and other resources during the design, development, and testing of the solution. • Provided single point of contact for communication with the client before, during, and after engagements. Show less

• 

  TD

  Jun 2008 - now

  • Lead projects to implement various complex data feeds (RDBMS, files, VSAM) into Star Schema• Lead Admin team to execute upgrades and to Implement data profiling, metadata manager, DQ services and trained analysts to save more than 4 FTEs of manual effort.• Setup and Led an offshore operations team –to move the overnight support and saved 60% project cost, added 25% resources, and helped onshore team to focus on critical initiatives such as knowledgebase creation and performance improvements. Show less

  • Sr. IT Development Mgr.

    Aug 2018 - now

  • Sr. IT Data Specialist

    Jun 2014 - Jul 2018

  • Principal Consultant

    Jun 2008 - Sept 2014
• 

  Indiana University - Kelley School of Business

  Jan 2018 - Nov 2020

  * Help with Student leadership team that acts as a liaison in aligning the goals and needs of the students with those of the MBA and MS (Analytics) program. * Help students to enroll and understand business analytics* Help expose other students to products and tools that enable data-driven decision-making.

  • President, Kelley Direct Business Analytics Association (KDBAA)

    Dec 2018 - Nov 2020

  • VP of Technology, Kelley Direct Business Analytics Association (KDBAA)

    Jan 2018 - Dec 2018