Sanchit Pahuja
[email protected] | +91-798-880-5450 www.linkedin.com/in/sanchit-pahuja
Summary • • • • • • • •
6+ years of experience in IT industry comprising of development using Mulesoft Anypoint, Informatica PowerCenter and MSBI-SSIS. Good knowledge while building reusable api’s following Mulesoft API Led methodology. Experience with Data integration between CRM systems while managing data security, required transformation and cleansing of data. Driving a team of 4 resources and delivering skill up trainings on Mulesoft. Expertise building REST api specification structures using RAML. Hands-on expertise while designing and developing api’s following Agile methodology of SDLC. Proactively involved in sprint meetings for business knowledge of project, technical design sessions to develop requirements document and api design specifications. Proficiency while creating technical design documentation and API reference materials.
Technical Skills •
Primary Mulesoft Anypoint Platform, Mule 4, Dataweave 2.0, Munit, Salesforce Admin, SQL Database: Oracle 9i/ 11g, MS SQL Server 2008/ 2012/ 2014
•
Secondary Informatica 9.6/ 10.2, MSBI-SSIS, Pl/sql coding, Toad for Oracle/ Sql server, AQT, Tableau Server 8.3, Tableau Desktop 9.1, Jira, Confluence, BitBucket, SourceTree, Jenkins, Bamboo, XLDeploy, AutoSys, CA Workload Automation
Certifications • • •
MuleSoft Certified Developer - Level 1 (Mule 4) Salesforce Certified Administrator Dell Boomi Associate Developer
Educational Qualification •
2015: Bachelor’s Degree in Computer Science with aggregate 8.1 CGPA
Work Experience Latest Designation
Company
Tenure
•
Application Development Specialist
Accenture
Sep 2021 – till date
•
Senior Integration Developer
Traction on Demand
Dec 2019 – Sep 2021
•
Technology Analyst
Infosys Ltd
Aug 2015 – Dec 2019
Project Experience 1. Role: Mulesoft Developer/ Team Lead Tenure: October’2021 – present Description: Data Integration between multiple systems to handle health care data Responsibilities: • Leading a team on offshore while having daily standups with onshore to gather information for requirement analysis and building forward to finalize Design and Development. • Current projects consists integration between Salesforce Health Cloud, Salesforce Sales Cloud, flat files, sftp servers and amazon S3. • Hands on experience while designing, developing and managing api’s. • Experience in integrating api’s using api led methodology and implementing error handling for the integration. • Expertise while working with Mule connectors, scopes, loops and data payload transformations using dataweave.
2. Role: Mulesoft Integration Specialist Tenure: January’2019 – September’2021 Description: Data Integration between CRM systems to handle financial data Responsibilities: • Leading a team with direct interaction with Client to gather information for requirement analysis and building forward to finalize Design and Development. • Following SDLC approach of Mulesoft API Led methodology. • Experience in designing and developing RAML based APIs using Anypoint API Platform. • Hands-on with Mule 4 and Anypoint Platform to work on API development lifecycle • Experience in building complex Mule Flows, Scopes, Error Handling strategies, Validation and transforming data using dataweave 2.0 • Developing api’s to build integration between CRM Salesforce, Oracle Netsuite and Sql Servers while following api layers approach of experience, process and system. • Experience with creating MUnits to automate testing.
3. Role: Tenure: Description:
ETL Developer at Offshore January’2019 – December’2019 Data warehousing and migration project to maintain historical tables to analyze retirement plans trends of customers
Responsibilities: • Leading a team as a team lead and direct interaction with onshore team. • Parsed high-level design specification to simple ETL coding and mapping standards. • Worked on Informatica Power Center tools - Designer, Repository Manager, Workflow Manager, and Workflow Monitor. • Developed informatica data pipelines and its corresponding sessions and workflows while working with various sources i.e. flat files, excel sheets, Oracle/ MS Sql Server Db Tables. • Proficiency in writing complex sql queries to be used in source Qualifier. • Experience developing reusable transformations and mapplets. • Proactively involved in unit testing phase and knowledge transfer sessions with testing team. • Experience with deployment phase of SLDC using tools i.e. Jira, Confluence, SourceTree, BitBucket, Jenkins, Bamboo, XLDeploy, AutoSys, CA Workload.
4. Role: Tenure: Description:
Oracle Plsql, ETL Developer at Offshore August’2017 – December’2018 Business Intelligence Project that is doing business analysis of historical businesses to do projection for future business i.e. Forecasting
Responsibilities: • Leading a team as a Senior resource and direct interaction with onshore team being proactive part of sprint and daily stand-up meetings for requirements gathering. • Responsible for ETL Design, development, testing, documentation and review of code. • Experience building ETL processes to reconcile, standardize, cleansing and eliminate redundant data to process incoming data sources. • SQL Server Integration Services (SSIS) experience to load and transform data from various sources into a database staging environment. • Experience with various transformations of SSIS such as Multicast, Merge Join, Lookup, Fuzzy • Lookup, Conditional Split, Aggregate, Derived Column and Data Conversion Transformations. • Proficiency with writing Oracle Plsql procedures, packages, functions, indexes, dynamic sql’s. • Following Two Stage ETL approach of BI while working with multiple incoming data sources i.e. • flat files, Excel sheets, SQL Server/Oracle Db tables. • Creating generic historical tables with slow changing dimensions type 2, incremental load and applying cleansing transformation as per business requirements. • Created Tableau Dashboards from multiple data sources using Data Blending with interactive views, trends and drill downs along with user level security. • Created action filters, parameters and calculated sets for preparing Tableau dashboards. • Proactively involved with testing team to provide unit test documents and make them understand the workflow of data for better integration testing. • Responsible for deploying SSIS packages/ Oracle procedures and packages to their respective environments and creating scripts for triggering and scheduling of packages.