Kunal Singh

About Kunal Singh

Data Architecture, Data Integration and Data Quality professional having 17 years of experience in IT with proven expertise in Solution Architecture, Requirements Analysis, Gap analysis, orchestration of enterprise data (EDM), Application Design, Development, Testing, project deliverables, Maintenance and Support•17+ years of work experience in Project Management, Client communication and management, Driving projects, Agile Methodologies & Development, Software Development Life Cycle(SDLC), Problem Solving, Quality Assurance, and End to end Project Delivery•17+ years of work experience in Banking, Financial, Compliance Risk & Surveillance domain and extensive experience in Data Warehousing and Business Intelligence•17+ years of work experience in Modern Data Architecture, Data modeling, OLTP, OLAP, Dimensional Modeling, Application Design, Implementation, Consulting, Data Conversion, Informatica Power center, Informatica Data Quality (IDQ), Data Integration Hub (DIH) PUB/SUB, Informatica Cloud, Azure Data Factory (ADF), AWS S3, SQL, PL-SQL, UNIX, Python and Oracle•Extensive experience in working with Business users and Product managers to understand data requirements and developed scalable solutions for event based integration (EDA), DI Portal, Collibra, EDM Portal, Liquidity Threshold & Alerts platform for business analytics, Compliance Surveillance and Data Repository (CSDR), and Audit & Balance Control•Salesforce Data Migration: Lead Salesforce data migration projects, leveraging tools like Databricks, SQL, Snowflake, Python, SAP, Salesforce, Jetstream, and Microsoft FabricTECHNICAL SKILLSETL/Data Integration: Informatica Power Center, Informatica Data Integration Hub (DIH), MSBI-SSIS,MSBI-SSASData Quality: Informatica Data Quality (IDQ), Data Quality Analyst ToolData Migration: Salesforce, Databricks, Snowflake, Microsoft FabricReporting/Data Visualization: MSBI-SSRS, Micro strategy (MSTR)Data Model/Analytics: Data Modeling, SQL, Erwin, Excel, OracleBusiness Analytics: Collibra, EDA, EDM, DI Portal, Liquidity Threshold and AlertsLanguages/Technologies: C#, ASP.NET,T-SQL, PL-SQL, Python, Jupyter Notebooks, UNIX ScriptCloud: Informatica Cloud, Azure Data Factory (ADF), AWS S3 DatalakeDomain: Banking, Financial, Compliance Risk & Surveillance, Telecom, Energy & UtilityProject Management: Project Management, Client Management, Agile Methodologies and Development, Software Development Life Cycle(SDLC), Problem Solving, Quality Assurance, End to end Project DeliverySource Code Control: Bit Bucket, SVNScheduling Tools: Autosys, Control M

Experience

1. Manager, Cloud & Digital - Analytics Insights

   PwC

   Oct 2022 — Present · Boston, MA, US

   1)Project Leadership and Management: Lead and manage data integration and Salesforce data migration projects, from planning to execution, ensuring timely delivery of high-quality solutions2)Data Integration and Architecture: Design and implement data integration solutions using tools like Informatica, Informatica cloud (IICS), SQL, SnapLogic, Databricks, Snowflake, and Microsoft Fabric3)Client Engagement and Communication: Establish and maintain strong relationships with clients and business teams, understanding their business requirements and providing strategic data integration recommendations4)Technical Expertise and Innovation: Enhance client solutions by utilizing data integration technologies such as SnapLogic, Databricks, Snowflake, and Microsoft Fabric. Efficiently develop data processes using tools like Informatica PowerCenter, Informatica Data Quality (IDQ), Data Integration Hub (DIH), Informatica Cloud (IICS), Azure Data Factory (ADF), AWS S3, SQL, PL-SQL, UNIX, Python, and Oracle5)Data Modeling and Analysis: Design and develop data models using ERWIN tool, including entity relationship diagrams and dimensional models, to support business intelligence and reporting needs. 6)Requirement Gathering and Data Process Orchestration: Develop the orchestration of data processes by meticulously gathering and analyzing requirements, crafting both functional and technical specifications7)Quality Assurance: Implement quality assurance processes, including the testing and validation of data integration workflows to ensure data accuracy and compliance with industry standards8)Salesforce Data Migration: Lead Salesforce data migration projects, leveraging tools like Databricks, SQL, Snowflake, Python, SAP, Salesforce, Jetstream, and Microsoft Fabric9)Training, Mentorship, and Leadership: Mentor team members, providing guidance in their professional development and conducting training sessions on data integration tools and best practices

Education

• Dr. A.P.J. Abdul Kalam Technical University

  Bachelor of Technology (BTech), Computer Science and Engineering

  2003 — 2007

Skills

• Autosys
• Data Warehousing
• Sdlc
• Agile Methodologies
• Microsoft Sql Server
• Databases
• Xml
• Database Design
• Requirements Gathering
• Msbi
• Informatica
• Ssis
• T-Sql
• C#
• Etl
• Pl/Sql
• Oracle
• Requirements Analysis
• Sql
• Unix
• Data Modeling