Milan Dholariya

adisi4@r.postjobfree.com

Mobile: 646-***-****

Professional summary

●Over 10 years of IT experience as a MS SQL Server/PowerBI Developer in various Industry verticals like Finance, Education, Retail, Insurance, Pharmaceuticals, Banking, Airline industry.

●Ability to deliver comprehensive Business Intelligence solution through integration of BI suite of products (SSIS, SSAS, SSRS) including MS solutions like MS EXCEL 2007/2010, Microsoft Office.

●Skilled in Data warehousing tools, Data Mapping, Unit Testing, Migration, Conversions, and Process Documentation.

●Expert in RDBMS concepts, Data warehousing concepts, OLTP & OLAP.

●Strong Experience in various Extracting, Transforming and Loading (ETL/SSIS) data flow and Low Latency ETL using SSIS.

●Excellent in writing T-SQL, working on DTS, SSIS, SSRS, SSAS, Data Cleansing, Data Scrubbing and Data Migration, Also created Indexed Views, complex Stored Procedures, CDC, Triggers, effective functions to facilitate efficient data manipulation and data consistency.

●Expert in T-SQL DDL/DML, perform most of the SQL Server Enterprise Manager and Management studio functionality using T-SQL Scripts and Batches.

●Good SQL Server Administration skills including, Backups, Restore, database maintenance, user authorizations and Database creation.

●Expertise in working on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using Bulk Copy Process (BCP), Data Transformation Services (DTS) and SSIS with MS SQL 2012/2008.

●Proficiency in creating many complex SSIS packages with complicated transformations using SQL Server Integration Services.

●Experienced in normalizing databases for OLTP environments and de-normalizing tables for use in OLAP environments.

●Experience of implementing applications in ASP.NET 2.0 and Visual Studio 2005, VB.NET.

●Strong knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, dimensional modeling and reporting tools, worked with high volume databases with partitioned data.

●Experience in using tools like Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.

●Thorough understanding of Kimball/Inman strategies, KPI, Data mining structures.

●Advanced extensible reporting skills using SQL Server reporting services (SSRS). Created & formatted Cross-Tab, Conditional, Drill-down, Top N, Summary, Form, OLAP, Sub reports, ad-hoc reports, parameterized reports, interactive reports & custom reports .

●Experience in providing SSRS server level, item level Security & Accessibility to various reports in multi-user environment.

Business/Technical skills

MS SQL Server 2012/2008R2/2008/2005/2000, SQL Server Integration Services (SSIS 2005/2008/2010/20012), SQL Server Reporting Services (SSRS 2005/2008/2010/20012), SQL Server Analysis Services (SSAS 20052008//2010/20012), Data Transformation Services (DTS), MS Visual Studio 2008/2005, Microsoft Products MS Word, MS Excel, VSS,MS Power Point,MS Access 2007/2003, ERWIN 4.0/4.1/4.2/7.2, Microsoft Visio 10.0/11.0,MS VISIO,C#, VB.NET, MS office 2007/2003, Windows 2003/2000

Project Summary

Wells Fargo,Charlotte,NC

Nov-2018 to present

Lead SQL Server Database /SSIS /PowerBI Developer

Working on Project odyssey which includes adding more products to existing application called DOCD.

Responsibilities

Created complex database queries to meet the business requirement and generated reports.

Created Poweshell script for logging, Execute SSIS package and to run the job via Autosys.

Wrote stored procedure from scratch to add new products into DOCD application.

Used Event Handlers for Custom Logging using Complex Stored Procedures for various events On Warning, On Pre and Post Execution, On Task Failed. Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards

Worked on production issue and coordinate with business user and DBAs to identify and fix the issue.

Created stored procedures and used PL/SQL for building dynamic queries.

Deployed Poweshell code to push logs to splunk application.

Expert in Extraction, Transforming and Loading (ETL) data flows using SSIS; creating mappings/workflows to extract data from Oracle, SQL Server and Flat File sources and load into various Business Entities.

Hands on experience in maintaining code repositories in TFS. Expertise with DDL and DML statements, RDBMS's, data dictionaries and normal forms.

Estimate, schedule and track ETL projects throughout SDLC.

Built/created C# scripts for various ETL/SSIS development purpose.

Extensively done data scrubbing, data cleansing, data profiling and data transformation through SSIS packages.

Tools & Technologies

SQL Server 2014, Server Integration Services 2015,, Informatica, power BI, Oracle Microsoft Visual Studio, SQL Server Management Studio 2014, SSMS2017, Tableau, MS Excel, T-SQL, ERWIN 7.2, C# .Net, PL/SQL,VB, Poweshell, SharePoint, TFS, Splunk, Autosys, Azure

CIT Bank, Pasadena, CA

Nov-2015 to Oct-2018

SQL Server Developer/ Data Analyst /SSRS/PowerBI Developer

Worked on BDM (Banking data mart) enhancement project in cognizant team who is implementation partner.

Project was focused on merger of one west bank and CIT east coast.

Provided Solution and production support for SPA (Servicing Profitability analysis) and SDM (Servicing Data Mart) Mortgage Data Marts.

Responsibilities

Worked with Business Analysts to gather various business requirements and implemented them while designing various SSIS packages and SSRS reports.

Worked on designing, creating, deploying and troubleshooting SSIS packages for transferring data from flat files excel spreadsheets and Heterogeneous data sources to and from SQL Server using SQL Server data tools.

Used Event Handlers for Custom Logging using Complex Stored Procedures for various events On Warning, On Pre and Post Execution, On Task Failed.

Developed SSIS packages for Initial Data Loads and Incremental Loads.

Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Conditional Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.

Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions.

Experience in all phases of Data warehouse development from requirements gathering for the data warehouse to develop the code, Unit Testing and Documenting.

Extensive experience in writing UNIX shell scripts and automation of the ETL processes using UNIX shell scripting.

Automated Power Query refresh using power shell script and windows task scheduler.

Used various sources to pull data into Power BI such as Sql Server, SAP BW, Oracle, SQL Azure etc.

Installed and configured Enterprise gateway and Personal gateway in Power bi service.

Created Workspace and content packs for business users to view the developed reports.

Scheduled Automatic refresh and scheduling refresh in power bi service.

Proficient in the Integration of various data sources with multiple relational databases like Oracle11g /Oracle10g/9i, MS SQL Server, DB2, Teradata, VSAM files and Flat Files into the staging area, ODS, Data Warehouse and Data Mart.

Experience in using Automation Scheduling tools like Autosys and Control-

Created SSAS cube and calculated measures for Accounting and reconciliation.

Migrated all DTS packages to SQL Server Integration Services SSIS and modified the package according to the advanced features of SQL Server Integration Services.

Created jobs and scheduled SSIS packages to run automatically to import data from flat files to SQL Server.

Designed and implemented Cross Tab, Drill Down and Drill Through reports, Parameterized, Ad hoc, Sub-Reports and charts using SQL Server Reporting Services SSRS and configured them to send emails to users on weekly basis.

Responsible for Query optimization and Performance tuning, tuned SQL queries using Show Plans and Execution Plans.

Performed database backup and deployment to the production server.

Monitoring SQL Server logs to ensure the backup operations, batch commands, or other scripts and processes have completed successfully.

Involved in configuration of Team Foundation environment along with Share point Services and Reporting Services.

Responsible for creating Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers, Rules and Defaults

Exported and imported data from text files and Excel T-SQL Server database using bulk copy insert and BCP utility.

Troubleshoot system issues, monitored scheduled jobs and set up maintenance plans with SSIS for proactively monitoring the performance of SQL Server databases

Scheduled jobs for backup, and created alerts for error reporting.

Created UAT plan to test end to end of the new changes in objects and packages.

Tools & Technologies

SQL Server 2008, Server Integration Services 2008, Informatica, power BI, Oracle, SQL server reporting Service 2008, Microsoft Visual Studio, SQL Server Management Studio, MS Excel, T-SQL, ERWIN 7.2, C# .Net, PL/SQL,VB, SharePoint, TFS

Popcorn Indiana, NJ

June-2015 to October-2015

SQL Server Developer/SSIS Developer

Popcorn Indiana is major popcorn manufacturer and distributor all over USA.

Responsibilities

●Worked with business stakeholders, application developers, production teams and across functional units to identify business needs and discuss solution options.

●Agile methodology was used throughout the project, Performed pivotal role in planning and developing as well as aligning with the assigned sprints.

●Performed customization and configuration work on OLTP databases, tables, stored procedures, SSIS packages and other objects.

●Exceptional hands on working knowledge with SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS).

●Understood the business requirements from FSDs provided by the Business Solution Team and developed ETL job, SSRS Reports and SQL Server Objects.

●Participated in reviews of issues related to SSIS Packages/SSRS reports and work in troubleshooting those issues, fixing, testing and re-deploying them.

●Experience in creating packages to transfer data between ORACLE, MS ACCESS and FLAT FILES to SQL SERVER using SSIS.

●Experience in enhancing and deploying the SSIS Packages from development server to production server.

●Working in the QA team as data analyst to help client synchronize their datasets

Tools & Technologies

SQL Server 2012, Server Integration Services 2012, SQL server Reporting Service 2012, Microsoft Visual Studio, SQL Server Management Studio, MS Excel, T-SQL,ERWIN 7.2, C# .Net, SharePoint, TFS

NYC DOE, Brooklyn, NY

Jan-2015 to May-2015

SSIS Developer/SQL Server Developer/PowerBI Developer

NYC DOE is the NY city dept of education who creates various educational programs for kids of NY City.

Responsibilities:

●Responsible for the development of ETL/SSIS Packages, SSRS Reports and T-SQL objects like stored procedures, triggers, indexes and functions.

●Worked with Business Solution team to understand and determine scope for different projects.

●Successfully implemented advanced ‘Archive and Purge’ process in SSIS for log tables.

●Extensively Implemented SSIS auditing, error handling, and email error messaging.

●Worked with Tabular reports, Matrix reports, Gauges & Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment using SQL Server Reporting Services(SSRS).

●Enhanced the reusability of the packages by making and deploying shared containers and

Multiple instances of packages.

●Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.

●Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPIs such as legal case matter, billing hours and case proceedings along with slicers and dicers enabling end-user to make filters.

●Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision makers for strategic planning.

●Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.

●Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.

●Extensively used dynamic approach to SSIS packages for the re-usability/modifications.

●Designed, built and deployed MOLAP cubes in SSAS.

●Supported 24/7 for the production system for OLTP and post deployment SSIS packages/ SSRS Reports on the server.

Deploy/Design cubes in SSAS environment, Star Schema Designs for data warehouse purposes.

Experienced in writing MDX queries for multidimensional Analysis.

Used Power Pivot in Excel to connect to the SSAS cube and created Dashboard Report to help understand user ongoing Business operation which helped them make better Decision.

●Deployed reports on Report Server and SharePoint Server also scheduled reports using SSRS to generate all daily, weekly, monthly and quarterly reports including current status.

●Strong understanding of developing N-Tier applications using C#.NET

●Scheduled ETL packages for Development and production environment with SQL Server Job Agent.

●Responsible for unit/integration testing of SSIS packages & SQL codes.

●Involved in creating detail design documents for ETL jobs.

●Tested new features of SQL Server 2012 for Dev Environment and provided recommendations.

Tools & Technologies:

SQL Server 2012, Server Integration Services 2012, SQL server Reporting Service 2012, Microsoft Visual Studio, SQL Server Management Studio, MS Excel, T-SQL,ERWIN 7.2, C# .Net, SharePoint, TFS

UPS, Louisville, KY

July-2014 – December-2014

Data Analyst/SSIS developer

United Parcel Service of North America, Inc. branded as UPS is the largest shipment and Logistics Company in the world.

Responsibilities:

Good experience in data modeling and Metadata services. Extract Transform Load (ETL) development using SQL Server Integration Services (SSIS).

Implemented a mid-size Ware house/data mart Inbound Visibility Application solution with 5 facts and 12 dimensions for analyzing Inbound Visibility application using SQL Server Integration Services (SSIS) and SQL Server Analysis Services (SSAS).

Designed and supported a scalable ETL process for the Inbound Visibility data mart using SQL Server Integration Services (SSIS) and T-SQL Stored Procedures.

Streamlined data imports for Inbound Visibility data mart by re-designing existing legacy ETL Structure using SQL Server Integration Services (SSIS)for various data feeds such as Sql Server, MS Excel.. Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages.

Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).

Handled monthly Database Refresh in QA-Test environment for testing of new Deployments and Build.

Sound Knowledge and experience in SharePoint 2010.

Administration functions including deploying code solutions (.wsp), Power Shell scripts, server optimization, server management, content deployment, and web and service applications in Central Administration.

Responsible routine DBA jobs like Backups and Restores.

Good experience in data modeling and Metadata services. Extract Transform Load (ETL) development using SQL Server Integration Services (SSIS).

Implemented a mid-size Ware house/data mart Inbound Visibility Application solution with 5 facts and 12 dimensions for analyzing Inbound Visibility application using SQL Server Integration Services (SSIS) and SQL Server Analysis Services (SSAS).

Designed and supported a scalable ETL process for the Inbound Visibility data mart using SQL Server Integration Services (SSIS) and T-SQL Stored Procedures.

Streamlined data imports for Inbound Visibility data mart by re-designing existing legacy ETL Structure using SQL Server Integration Services (SSIS)for various data feeds such as Sql Server, MS Excel.. Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages.

Tools & Technologies:

SQL Server 2012, Server Integration Services 2012, SQL server Reporting Service 2012, Microsoft Visual Studio, SQL Server Management Studio, MS Excel, T-SQL,ERWIN 7.2, C# .Net, SharePoint, TFS

Verizon, Waltham, MA

Jan2011 - June - 2014

SQL Server Database Developer

The Project was to do ETL and generate report for clients so that it can be used by clients to analyze growth and determine future strategy.

Responsibilities:

●Worked with business stakeholders, application developers, production teams and across functional units to identify business needs and discuss solution options.

●Agile methodology was used throughout the project, Performed pivotal role in planning and developing as well as aligning with the assigned sprints.

●Developed and deployed SSIS packages for ETL from OLTP and various sources to staging and staging to Data warehouse using Fore Each Loop Container, Execute Package task, Execute SQL Task, Sent Mail task, Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Slowly Changing Dimension and more. Performed ETL mappings using MS SQL Server Integration Services.

●Involved in implementation of data mart and OLAP cubes using SSAS and extensively used SSIS Import/Export Wizard for performing the ETL operations.

●Involved in creating Multidimensional cubes and designing DW schemas using SSAS

●Assisted the lead Application Analyst in creating small application projects in ASP.NET Visual Studio 2012 VB.NET, ADO.NET, applying SQL queries over server databases using SQL Server 2012 and updating HTML files.

●Involved in monitoring and tuning report performance by analyzing the execution plan of the report.

●Generated Drill down, Drill through, Matrix Reports, parameterized reports, cascading parameterized Reports using SSRS.

●Designed and developed monthly, quarterly and yearly reports at branch and bank level.

●Used SQL Server Profiler to trace the slow running queries and the server activity.

●Worked 24/7 production Environment with thorough understanding of Standard Operation Procedures (SOP) and Service Level Agreements (SLA).

Tools & Technologies:

SQL Server 2012/2008R2/2012, Server Integration Services 2008, SQL server Reporting Service 2008, Microsoft Visual Studio, SQL Server Management Studio, C#,.Net, PL/SQL,MS Excel, T-SQL,ERWIN 7.2,

Contact this candidate