Sharad Patil

• Design enterprise data models and create scalable data platforms (Cloud / On-prem / Hybrid)
• Led enterprise data integration and data migration using Azure Data Factory, PySpark achieving seamless migration across systems with 99.9% data accuracy. ·
• Developed and automated interactive Power BI dashboards, enabling real-time analytics and reducing reporting turnaround by 37%. ·
• Expertly utilized DAX, Power Query, and M Language to build advanced data models, custom calculations, and optimized ETL processes in Power BI.
• Optimized SSIS ETL workflows, reducing load time by 21% and improving SLA adherence. ·
• Designed and optimized enterprise data warehousing solutions to support reporting, analytics, and historical data analysis. ·
• Designed dimensional data models using Star Schema and Snowflake Schema to support high-performance reporting and analytics. ·
Worked with Azure Synapse Analytics for analytical querying and performance evaluation in Azure-based data platforms.

Working as Technical Project Manager.

with 99.9% data

generation and analytics processing by 20%.
• Implemented data governance frameworks, improving data quality by 33% and
reducing redundant data by 21%.
• Designed and deployed custom SSIS packages for data extraction, saving 19 hours
per month of manual processing.

• Enhanced SQL Server database schemas, improving data retrieval performance
by 15% for high-demand applications.
• Automated ETL workflows with SSIS, reducing manual data handling by 40% and
improving process reliability.
• Developed dynamic SSRS reports for financial analysis, enabling stakeholders to
access real-time insights.
• Maintained data integrity across multiple systems, ensuring zero data loss during
migrations.

Fulcrum September 12 - March 2013
Stroz Friedberg, Operational Support System
Sr.Software Engineer (Database Developer)

Description: Stroz Friedberg helps clients manage their digital risks and delivers unassailable results in the areas of digital forensics, data breach & cybercrime response, electronic discovery, business intelligence & investigation, and security risk consulting. Strategy and risk management in the form of sound,
ethical consulting advice is the foundation of everything they do: it provides the context in which they deploy unparalleled investigative skills and proprietary technologies and cost-effectively resolve their clients most pressing matters. Corporations, law firms, government agencies, and the courts rely on them for their objective and thorough analyses and solutions that invariably withstand the scrutiny of opposing counsel and their experts. They successfully operate at the intersection of technology, law, investigations, and behavioural science: they uncover key digital evidence; they ensure compliance; they provide assurance to all parties; they identify and protect against the malicious acts of real adversaries.

Hands on Development Skills: • Responsible for overall database related activities.
• Work with the development team to provide data model/ER diagram for the project using MS Office Visio.
• Creation of database objects like tables, user defined procedures, functions, triggers using MS SQL Server 2008 R2.
• Responsible for database performance tuning and database query optimization.
• Responsible for creation of reports Using SSRS.

Environment: MS SQL Server 2008 R2, SSRS, MS SharePoint 2010, .Net4.0 and MS Office Visio.

Paramatrix Technologies Nov 11 - Feb 12
FINO, Operational Support System
Software Engineer (Database Developer)

Description: With over 49 million customer base and a force of 31000 transaction points in 424 districts across 26 states, FINO is the market leader in delivering products and services to the first and last mile. They enable sourcing and acquiring of micro transaction customers at their doorstep. Their model is built to offer bouquet of products to clients and their customers at affordable prices across channels as compared to traditional infrastructure based delivery models. The advantage of using their solutions are end to end technology and services bundled offering, enabling delivery at scale through secure transaction mechanisms to reinforce trust and enhance user experience.


Hands on Development Skills: • Responsible for overall database related activities.
• Creation of database objects like tables, user defined procedures, functions, triggers using MS SQL Server 2008.
• Responsible for database performance tuning and database query optimization.
• Responsible for making insert/update script and Packages to deploy on production server using SSIS.
• Responsible for creation of reports Using SSRS.

Environment: MS SQL Server 2008, SSIS, SSRS, .Net4.0.