Pankaj Sahani

317-***-****

ad4qen@r.postjobfree.com

Indianapolis, IN

Summary of Qualifications

Results-driven IT professional with over 14 years of experience in project management, ETL (Informatica PowerCenter

& IICS), Azure Data Factory, databases (Oracle, MongoDB, SQL server, Azure SQL), CRM (Salesforce.com & Veeva), and Business Intelligence (PowerBI, SiSense & Tableau). Proven expertise in data analysis, reporting, and successful project delivery. Adept at leading project teams through the entire lifecycle, from requirements gathering to implementation. Extensive experience in Informatica Cloud, Salesforce integrations, and database replication. Strong communication and problem-solving skills, with a track record of delivering projects on time and within budget. Recent certifications in Microsoft Power BI Data Analyst and Designing and Implementing a Data Science Solution on Azure. Key Strengths:

• Relationship Management between key stakeholders (customers, vendors, partners, subordinates)

• Guide the team in understanding the business functionalities and lead design effort to build data as a service.

• Lead, mentor and develop a team of 14 Data Engineers, Business Analyst and Prod Support Analysts to deliver new functionality on the data migration and analytics.

• Perform data analysis and data modeling (ERwin) for new data business functionalities.

• Review and revise existing data processing and code standards.

• Manage and resolve escalations for operational issues to ensure optimal performance of analytics systems.

• Collect, analyze, and evaluate data turning it into usable information that can be interpreted into business intelligence.

• Actively participate in continuous improvement activities to support business performance.

• Ensure appropriate reporting, metrics, and standards are followed by team.

• Collaborate with Business Partners to effectively run the operations.

• Experience of Death care industry, Healthcare, Pharma, Drug Manufacturing and Sales and Marketing domains.

• Experience in Informatica Cloud, Microsoft Power BI, Tableau, Salesforce, ETL and BI process. Data Warehousing and Data Analytics.

Technical Skills

• ETL: Azure Data Factory, Informatica (Power Center), Informatica Cloud Services

• BI: Power BI, SiSense, Tableau

• CRM Tools: Salesforce (Veeva), Apex jobs, Veeva Reporting, Veeva Configuration, Microsoft Azure

• Languages: SQL, PL-SQL, Spark SQL

• Databases: Azure SQL Database, SQL Server, Oracle, MongoDB, Databricks Certifications

• Microsoft PL-300 Certified: Microsoft Power BI Data Analyst

• Microsoft DP-100 Certified: Designing and Implementing a Data Science Solution on Azure

• PMElite (Project Management Certification from Infosys Ltd.)

• Information Security Management System (ISO 27001) from British Standard Institution Education

• Master of Science in Information Technology - Project Management, Purdue University Global, USA

• Bachelor of Technology in Biotechnology, Amity University, India Experience

Technology Lead - US

Infosys Ltd. December 2019 – Present

Technologies: Azure Data Factory, Databricks, Informatica Power Center, PowerBI, Oracle, SQL Server, SQL, PL/SQL.

Key Responsibilities:

• Managed data migration projects for Hillenbrand Inc., including requirements gathering, gap analysis, issue resolution, and documentation.

• Led project teams in resource planning, project scheduling, and quality assurance.

• Collaborated with onsite and offshore teams to ensure smooth project execution and customer satisfaction.

• Working closely with cross functional team in IT and business analytics partner to ensure the expectation are met and acting as a strong liaison between business and data engineering to resolve issues.

• Providing up-to-date resourcing and spending plans to properly manage the portfolio in terms of staffing and finances.

• Allocate work, track, and review the project scope, schedule, quality, resource requirements, costs, risks on a periodic basis and take corrective measures.

• Prepare resource plan including people, space, infrastructure, and liaison with required groups to fulfill the required project resource requirements.

• Product Management activities include but not limited to: o Analyze and elicit requirements from customer on new/existing project/incident activities. o Gap Analysis and Resolution Strategy

o Issue Resolution and Ticket Management for Business Issues o Documentation of Changes, Impact and Best Practices o Helping client(s) understand a specific functionality or area of work. o Onsite-Offshore Coordination - passing on requirements, clarifications, and documents to Offshore to get part of the work completed.

o Tracking assigned tasks to completion and reporting status to client. Data Architect

Visual IT Services June 2018 – November 2019

Technologies: Azure Data Factory, Informatica Power Center, DataStage, Tableau, Cognos, BIRT, Oracle, DB2 and Mongo database, Agile

Key Responsibilities:

• Developed ETL processes using Informatica and Azure Data Factory for the State of Indiana's Family and Social Services Administration.

• Created Tableau reports and Azure SQL Database pipelines to meet business requirements.

• Provided technical leadership throughout Azure-based data migration projects, including requirements analysis, design, and implementation.

• Architect and guide the project during full lifecycle project phases, going through requirements gathering, data analysis, data transformations, data modeling, Reporting/ Dash boarding - leveraging the appropriate data Integration, modeling, and Visualization tools.

• Created real time and historical Tableau reports using data from MongoDB and Oracle. Data Team Lead

Indecomm Global Services October 2014 – May 2018

Technologies: CRM Salesfore.com, IICS, Oracle, SQL, PL/SQL, Agile Key Responsibilities:

• Managed the integration of Informatica Cloud, Salesforce CRM, and SiSense BI for Advanced Health Media.

• Led the design and development of ETL processes, data models, and job notifications.

• Coordinated with onsite and offshore teams to deliver high-quality solutions on time and within budget.

• Architect and guide the project teams during full lifecycle project phases, going through requirements gathering, end user interaction, data analysis, data profiling, extraction and transformations, data modeling, Reporting/ Dash boarding - leveraging the appropriate data Integration, modeling, and Visualization tools.

• Own the technical delivery of a data project, manage technical tasks at a granular level, follow up with key stakeholders and client; proactively identify risks in delivery and manage.

• Run and manage governance calls with team and key stakeholders to ensure timely resolution of key escalations addressing concerns related to performance/timeliness/quality of the operations.

• Build synergetic relationships with key business partners, maintaining clear communication of progress through the delivery of project related deliverables.

• Manage and mentor team of direct reports by providing career path conversations and guidance and helping them achieve their goals through effective development and training plans.

• Create ETL load process and strategy as per technical requirements. Senior Software Engineer

Accenture Services Pvt. Ltd. June 2010 – July 2014 Technologies: CRM Salesfore.com (Veeva), Informatica Power Center, Autosys (Job scheduling), TOAD, Agile and UNIX shell Scripting

Key Responsibilities:

• Implemented Salesforce-Veeva integrations for AstraZeneca, including requirements analysis, solution design, and data migration.

• Developed SQL queries and PL/SQL procedures for data reporting and analysis.

• Provided production support and resolved issues in a timely manner to ensure business continuity.

• Designed complex mappings involving constraint-based loading, target load order.

• Created events and tasks in the workflows using workflow manager.

• Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target-based commit interval.

• Developed Informatica mappings and tuned them for better performance with PL/SQL Procedures/Functions to build business rules to load data.

• Create ETL load process and strategy as per technical requirements.

• Maintain high levels of client satisfaction and ensure customer delight and stickiness.

Contact this candidate