Prathamesh Desai

• Working on a finance project with an investment management company.
• We have our own trade processing system which has a sql database.
• Interact with traders directly in case of issues and have tight deadlines to resolve issues.
• Championed the data flow of the system within few months after joining the project.
• I spearheaded the successful migration of trade processing system during the joint venture of the client without compromising functionality or data integrity.
• Discussed project progress with customers, collected feedback on different stages and directly addressed concerns.
• Handled more than 30 devop stories along with ~10 bugs and random tasks every sprint.
• Authored code fixes and enhancements for inclusion in future code releases and patches.
• Easily managed both user/trader support along with code development and debug issues.

Experience in analyzing BI needs, interpreting business user requirements and translating them into Reports/Dashboards and SSRS Reports.

• Experience on building ADF (Azure Data Factory) pipelines based on user requirement.
• Experience on building API that is accessible over Internet. Interested in Learning Angular and move towards Full Stack.
• Extensive knowledge in Designing SSIS Packages, Interactive dashboards/Reports and Data Modelling of Star and Snowflake Schema patterns.
• Well acquainted with Software Development Life Cycle and Software Testing Life Cycle. Expertise in SQL Server, Data Warehousing concepts, Data Loading & handling large databases. Flexible enough to adapt new environments.
• Sound knowledge in analysis of functional issues .
• Heavily worked on SSIS and SQL which is a forte and strong point as I am able to understand data.
• Learnt and worked on building ADF pipelines and guided colleagues in learning the same.
• Learnt and worked on building API for business by using .NET and completed successfully.
• Coordinated efficient large-scale software deployments.

• Played major role in project Fortification (performance improvement) by reducing overall timing of end to end autonomous data processing by more than 50 minutes
• Created procedures and SSIS package to automatically partition existing data(1.5 TB) onto new partition scheme
• Investigated issues by reviewing/debugging code, studying execution plans, providing fixes and workarounds, and made technical changes without disturbing functionality of existing code
• Worked closely with business analysts, other developers and infrastructure specialists to deliver high availability solutions for mission-critical deployments
• Entrusted directly by skip leader to perform POC on sensitive and business critical HR data, for performance improvement
• Reviewed SQL code that included database objects like Tables, Views, Common Table Expressions (CTEs) and SQL Queries, Dynamic-queries, Sub-queries, Grouping sets, Indexes and complex Joins for generating Stored Procedures and User-defined Functions and worked with development point-of-contact to correct problems, run test scenarios and prepare for deployment
• Designed and Implemented Data Warehousing and Data Mart concepts like Facts, Dimensions and Fact Less Facts
• Helped software development initiative leads as subject matter expert in many modules and acted as primary point-of-contact for business users
• Documented software design, detected faults, project planning discrepancies and other vital data
• Suggested improvements to team and project workflow
• Checked other application's code for bugs and weaknesses using approved troubleshooting methods
• Trained and mentored junior developers and engineers, teaching skills in SQL,SSIS, SSRS and working to improve overall team performance.

• Spearheaded small code development team for major Functional change in Accenture, that included more than 200 components and was to be created, merged , tested and deployed in short time span
• Formulated new code from scratch that was based on dynamic query features of SQL, to apply GDPR features in project
• Played major role in building SSIS packages while working in downstream application (MD dashboard), which dealt with complete sensitive data and data processing can only be done during transaction using SSIS
• Created excel macros that included writing VB code.

• Exercised DDL, DML, DCL & TCL statements for defining, accessing and manipulating transactional systems
• Automated reports involving complex computations using Pivots and Dynamic SQL
• Built SSIS Packages using transformations like Conditional Split, Aggregate, Union, Merge, Sort, Multi Cast, Copy, Derived column, Data conversion, Lookup, Execute SQL task, Checkpoints, Breakpoints, Data Flow task, Containers, Precedence constraints, Error Handling and Cozy Roc components
• Developed ETL workflow to implement incremental load packages using Changed Data Capture (CDC) and Slowly Changing Dimensions (SCD)
• Used third party Job Scheduling Tool Control-M to perform data load using SSIS packages
• Developed Tabular, Parameterized, Drill-down, Drill through and Linked Reports, Charts, Graphs, Conditional formatting and demand-based Subscription using SSRS.