Jitendra Patel Email & Phone Number

Pune, Maharashtra, India

• Currently working on multiple data migration projects in salesforce environment and a custom application.• Our team follows the agile methodology for project management.• Leading a team to drive the project. Have managed project timelines, delegated tasks, reviewed and approved individual tasks, maintained planner to track tasks and status of the project. • Utilized ETL tools such as Alteryx and Tableau to filter and analyze data for qualification.• Created scripts in Python to scrape data from existing environment to build further logic in Alteryx workflows.• Designed SQL scripts to pull data from SFDC environment for further processing.• Migration project deals with moving the customer data between two different SFDC environments.• Actively lead all production deployments for migration activity to make sure deployment happens smoothly and successfully.• Constructed Alteryx workflows for various tasks under each of the extraction, transformation and loading scenarios.• Scheduled workflows in Alteryx gallery for daily automated runs and report generation.• Optimized existing workflows to cut down migration timelines significantly as more products were included in the migration.• Highly skilled in all Alteryx tools including advanced tools such as Macros and dynamic tools.• Proficient in skills such as Data Analysis, Data Mapping, ETL, Data management, Data Architecture and have operated on complex systems with enterprise data.

Bengaluru Area, India

• Worked on data migration and remediation project for a telecom client.• Constructed new and optimized existing Alteryx workflows for various business requirements such as report generation, analysis, etc.• Implemented reconciliation process between two environments to check for discrepancies and assist RCAs.• Conceptualized reusable workflows and macros while having a modular approach in mind such that future changes can be easily accommodated and implemented across the project.• Designed Workflows and macros under the simplicity and readability principle wherever possible and documented accordingly enabling others to understand and make updates and changes easily in future.• Conducted investigative steps under remediation activities to fully identify the issues with the data, provide quick RCAs and engineer a solution to remedy the same.• Ensured identified risks and/or problems are clearly documented.• Provided final resolution to the client and ensured proper deployment to production.• Learnt various aspects of SFDC environment which has helped me gain insight in yet another skillset.

Mumbai Area, India

• Part of Treasury Planning and Analysis team.• Prepared and analyzed firm’s liquidity risk reporting models and MIS.• Key reports produced were MCO (Maximum Cumulative Outflow) model for region and global, Box report, LTD issuances, daily and weekly reports.• Played a critical role in publishing accurate and timely MIS / analytics around Liquidity reporting for facilitating strategic decision by the Global team.• Leveraged data to drive insights across treasury reports helping the team take timely decisions.• Leveraged advanced knowledge in Macros, VBA, Access, scripting to enhance reporting and analytical efficiency across the team.• Constructed custom analytics apps on Alteryx which helped to cut down time spent on data preparation and allow further time for data analysis and other activities.• Removed manual intervention with the help of Alteryx while preparing data by developing workflows for end-to-end processes including control checks to ensure user was notified in case of any issues enabling quicker actions.• Utilized technical expertise to build custom scripts and macros in VBA and Java to help reduce the overall time required for reporting and analysis for multiple processes cutting down as much as 80% time in some scenarios.

Mumbai Area, India

Conducted analysis for the company with regards to the current trend of the technologies in the industries and which are highly preferred by investors. The five sectors which were analyzed were digital marketing, e-commerce, customer experience management, business analytics and cloud business

• Part of an Insurance company project for claims handling• Worked in production support as a Technical Business Analyst• Interacted with the client to resolve incidents by being the link between the client and the development team.• Implemented changes in ASP.Net, HTML, CSS, JavaScript as a designer and constructor as per client requests• Created SQL batch scripts to implement various back-end updates for claims records.• Performed regression testing as part of BA testing• Part of the release management team which was responsible for upgrading the web servers to the latest version of the ASP.NET code every quarter of the year• Automated the daily source code build and minimized interaction time required between the process and the resource by approximately eighty percent• Developed a deeper understanding of Software change management and software release management.

Master Of Business Administration (Mba), Finance, General

Bachelor Of Engineering (B.E.), Computer Engineering