814-***-****

ado3v6@r.postjobfree.com

https://www.linkedin.com/in/nilesh-patil-

26a99076/

www.github.com/np007777

SUMMARY

Over 14+ years of Excellent IT Experience as SQL Server Developer in design, development and testing of business /commercial applications using MS SQL Server 2016/2014/2012/2008 R2/2008/2005 in healthcare, manufacturing and financial Sectors. AREA OF EXPERTISE

KEY SKILLS

• SSIS Pacakges deployments • SQL/Oracle to Oracle or AWS migration • Teradata Migration • SSAS cube analysis

• Dashboard Development • Data Visualization • User Assistance • Customer Service • Report Generation

• Data Collation • Data Analysis • Database Maintenance • Troubleshooting • Market Research • Auditing MS SQL Server, MS SQL Server Integration /Reporting/Analysis Service 2012/2008/2005, Amazon Redshift, EC2 with S3 bucket, DTS, MS Visio 2003, MS Access, FrontPage, Visual Basic 6.0, ERWIN, Windows 9x/NT/2000/XP/Server 2003, T-SQL, HTML, DB2, V10, XML, Cognos Report, VBScript, Data Model-logical/physical, adoNet Entity Framework, Share Point, MSAS, MDX Script, Oracle and DB2 Sources, Crystal Report, AWS, Scala, Spark, Python, Tableau TECHNICAL SKILLS

Profession Summary

Kumar

MS SQL BI (SSIS/SSRS/SSAS) Tableau Developer

SSIS /SSRS/T-SQL

Tableau LInux /Python

Data

Analysis/Complex

Queries

Data

Science/TeraData/AWS

Languages: SQL, VBA, Python, Linux, Java Basic, C# Database: RDBMS, Oracle, Teradata, EC2 to S3, Azure, Casandra, MongoDB, REDIS MS Excel, Power Query, MS Access Environment: Windows 2003/8/10, XP

Tools: SSIS 2014/16/17, Tableau Desktop 7.0 to 2020, SAP Business Explorer, MS Complex Query Designer Over 14+ years of Excellent IT Experience as SQL Server Developer in design, development and testing of business /Comercial applications using MS SQL Server 2016/2014/2012/2008 R2/2008/2005 in healthcare, manufacturing and financial Sectors. Excellent experience in migration from different T-SQL code to Tableau for report develop. Highly proficient in the use of T-SQL for developing complex creating Database, Tables, Indexes, Views, Triggers, Stored Procedure, User Defined Function, relational database models and data integrity, SQL joins and query writing. Extensive experience in Database Design, Normalization, Selective De-normalization, Forward/ Reverse Engineering of Applications, Conceptual, Logical and Physical data modeling using Erwin, E/R Studio and Sybase Power Designer. Good Experience in various packages of SSIS, SSRS and SSAS designing, constructing and deployment. Experience in Database Development, Modeling, Data Warehousing, Design and Technical Management. Good understanding of Normalization /De-normalization, Normal Form and database design methodology. Excellent experience in migration of data from Excel, Flat file to Microsoft SQL Server using SSIS and DTS utility. Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer. Experience in Data Modeling (logical modeling and physical modeling), Entity relationship diagram (ERD) development/normalization and physical database schema design using MS Visio and Erwin. Extensive experience of full software development cycle from analysis and design to test and release of the applications. Extensive experience in creating KPI’s, Aggregation, Perspectives in CUBE using SQL server Analysis. PROFESSIONAL EXPERIENCE

Data Analyst Aug '17 - Present

CHC part of United Healthcare /Innova Solutions

CHC provide solutions is a 24x7 service provider based in the US to help business establishments achieve their goals St. Louis, MO

Excellent knowledge of waterfall and spiral methodologies of Software Development Life Cycle (SDLC) and AGILE. Experience in OLTP & OLAP environment that includes Production (24x7), QA and Development databases in SQL Server. Using SSRS, Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports, Cross- Tabbed Reports.

Extensively worked in SQL server Reporting services (SSRS) to create reports that draw content from a variety of data source. Expertise in designing ad-hoc reporting for different level of end user. Experience in administrating the created reports and assigning permission to the valid users for executing the reports. Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS). Experience in creating KPI's, Aggregation, Perspectives in CUBE using SQL Analysis Services. Expert in transforming complex business logic into Database design and maintaining it by using SQL tools like Stored Procedures, User Defined Functions, Views, TSQL Scripting, DTS and Jobs. Excellent communication and interpersonal skills, self-motivated, quick learner and determination to learn new technologies, strong troubleshooting skill and good Team player with excellent interpersonal and team work skills Created highly complex SSIS packages using various Data transformations like conditional splitting, Fuzzy Lookup, For Each Loop, Multi Cast, column conversion, Fuzzy Grouping, error handling. Generated Custom ETL scripts using SSIS and develop and unit test SSIS load processes for performance check. Expert in Tableau, SQL Server, T-SQL and whole suite of products like SSIS. Deployed Google Analytics on gathered data to execute traffic analysis and websites Performed data visualization via Tableau and evaluated available data from online sources Compiled analyzed collated data to assist 10+ clients with designing campaigns for marketing and research. Responsible to ensure the accuracy of the information that is being provided by carefully and continually scrutinizing the data to ensure the right information is portrayed in the reports being delivered Communicates findings to senior management via formal presentations, standard management reporting artifacts on periodic/quarterly/annually

Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases and data mart databases.

Worked on failure mechanism to keep logs in case of data migration fails. Developed complex T-SQL queries and designed SSIS packages to load the data into warehouse. Created/Updated Stored Procedures, Triggers, Functions, Views, and Indexes with extensive use of T-SQL in SQL Server with destination AWS, Azure.

Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load. Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into UL Database and DB2 Billing Systems and developed, deployed, and monitored SSIS Packages. Responsible for database, ETL development activities and handling production support for the operational data loads utilizing SQL Server, Oracle, SSIS and SQL Agent.

Experience working with Azure SQL Database Import and Export Service. Experience in deploying DAX query in SQL SQL Databases in cloud (AZURE) Worked on AWS and AZURE storage systems with backup and copy Responsible for designing complex SSIS packages for performing ETL operations as per the need and scheduling the jobs on the agent using configurations. Maintain interchange database integrity across multiple platforms, including SQL Server 2012 and Oracle 11g.

Design and implement data warehouses by creating table/tables in SQL Server 2012 and populating it with several other tables to create the warehouse. Then use SSIS to perform the ETL and automate the process from that point forward. Develop automation processes using SQL Server Integration Services (SSIS) 2012, T-SQL and other tools that assist team members in acquiring, processing, or finding accurate interchange information. Developed Tableau visualizations and dashboards using Tableau Desktop. Experience including modelling, design and development of managing codebases using Visual Studio- GIT Extensive experience in Tableau Desktop, Tableau Reader, and Tableau Public in various versions of Tableau. Experience in configuration of backgrounds jobs, scheduling of the extract refresh activity, troubleshooting failed refresh activity, monitoring dashboards performance on tableau server. Implemented ETL operations using Big Data platform and AWS source targets. Designed the reporting application that uses the Spark SQL to fetch and generate reports on HBase. Exposure in working with data frames and optimized the SLA's. Good experience in analyzing data using Hive Query Language, Pig Latin and custom MapReduce programs in SQL BI /Tableau Developer Feb '14 - Feb '17

Zodiac Aerospace/ BDSN International INC.

One of the best management service providers in the US to assist both large scale and small scale business in 30+ countries Gainesville, TX

Java along with using User Defined Functions .Proficient in Performance Tuning, Query Optimization and running Database. Highly proficient in the use of T-SQL for developing complex Stored Procedures, Triggers, Tables, User Defined Functions, Views, Indexes, User profiles query writing and SQL joins. Solid knowledge of Relational Database Management System (RDBMS), Data Warehouse Concepts, OLTP and OLAP and experience with Working on SSIS, SSAS, SSRS, Data Analysis, and Data Migration. Deliver new and complex high quality solutions to clients in response to varying business requirements and Creating and managing user accounts.

Work with other teams and team members in zodiac to resolve issues related to data. Interact with clients to understand requirements. Maintain proper documentation of the various process and code. Extracted data from various source systems like Teradata, AWS, Azure, Cloud hive, Sql Server and flat files. Created and reviewed the conceptual model for the EDW (Enterprise Data Warehouse) with business users. Worked and the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.

Worked on Dax query and TSQl query and managing codebases using Visual Studio, Python, Unix & Git Preparing Dashboards using calculations, parameters in Tableau. End to end experience in designing and deploying data visualizations using Tableau. Worked on building queries to retrieve data into Tableau from SQL Server 2008 and Oracle SQL Developer, and developed T-SQL statements for loading data into Target Database.

Developed various interface webpages for incoming files for the Vendor Interfaces including service invoice, repair order, finance and insurance, vehicle inventory tracking, parts order using C# and job claims with stored procedures. Have hands on experience in Data migration, Analysis, Validations and Reconciliation. Used VB Script for validating client side data entry screens in SSIS Packages. Designed and developed business components using C#.Net 2. Expertise in Microsoft Integration Services SSIS (Control Flow tasks, Data Flow tasks, Transformations, Database administration tasks)

Successfully extracted Data from Different Databases like Oracle, DB2. Expert in Migrating DTS Packages to SSIS.

Created SSIS Packages to import and export data from Excel Spreadsheets, Text files and CSV files Created packages in SSIS with error handling as well as created complex SSIS packages using various Data transformations like conditional splitting, Fuzzy Look Up, For Each Loop, Multi Cast, column conversion, Fuzzy Grouping, Script Components. Created Teradata External loader connections such as MLoad, Upsert and Update, Fastload while loading data into the target tables in AWS, Azure and Teradata Database.

Involved in development and implementation of SSIS and SSRS application solutions for various business units across the organization.

Consulted on Tableau server performance enhancements; upgrades from version 8.0 to 8.1.5 and server reconfiguration based on workbook complexity and data extraction.

Customized the Tableau landing page with site listing as icons and descriptions. Constructed the reports page for internal strategy group with standardized custom within Tableau Formulated and documented ETL process design based on business requirements and system specifications including source to target mappings, data dictionaries and transformations. Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse. Used SSIS for ETL processes, SSRS & Tableau for Reporting needs and SSAS for Analytics reporting including SharePoint integration.

SSRS and Tableau used for report development for monthly, quarterly and yearly basis. Created highly complex SSIS packages using various Data transformations like conditional splitting, Fuzzy Lookup, For Each Loop, Multi Cast, column conversion, Fuzzy Grouping, error handling. Generated Custom ETL scripts using SSIS and develop and unit test SSIS load processes for performance check. Worked and the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.

Created Tabular reports, Matrix reports, List & Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, Drill down reports as well as interactive reports according to business requirements Designed SSRS Report Model Projects in BI studio and created, modified and managed various report models with multiple model objects, source fields and expressions.

Highly involved in creating, structuring, formatting using Report Designer and Report Builder. Wrote and integrated stored procedures to generate the special reports according to client’s need. SQL/Tableau Developer/Jr. DBA Apr '12 - Aug '13

GE / Satyam Technologies Inc

One of the best management service providers in the US to assist both large scale and small scale business in 45+ countries Tableau Developer Jun '11 - Sep '11

BD /Adecco USA

One of the best management service providers in the US to assist both large scale and small scale business in 25+ countries Erie, PA

Franklin Lakes, NJ

Worked on various complex requirements of developing monitoring dashboards with multiple KPIs in Performance Point Monitoring Server 2007, Share point.

Created SSIS Packages by using advanced tools (i.e. pivot Transformation, Derived Columns, Condition Split, Term extraction, Aggregations, Multicasting).

Created SSIS packages for data Importing, Cleansing, and Parsing. Extracted, cleaned and validated. Kimball Data ware house by ETL tool extract Data modeling in Star schema also work on full life-cycle BI implementation and Teradata.

Created SSIS Packages to integrate data coming from Text files and Excel files. Designed and developed Data Marts by following Star Schema and Snowflake Schema Methodology, using industry leading Data Modeling tools like ERWIN and EMBARCADERO ER Studio. Created SSIS packages to validate, extract, transform and load data to data warehouse databases. Wrote stored procedures & User Defined scalar Functions (UDFs) to be used in the SSIS packages & SQL script. Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user. Tested, Cleaned & Standardized Data meeting the business standards - Fuzzy /exact lookups using SSIS tasks. Data management & data processing solutions using SSIS includes Error Handling & Slowly Changing Dim. End to end experience in designing and deploying data visualizations using Tableau. Experience scripting Disaster Recovery Plan, testing, analyzing and continuously updating it with documentation. Migrated on premises SQL databases to Azure, AWS, SQL Cloud. Extensive Tableau Experience in Enterprise Environment and Tableau Administration. Experience includes technical support, troubleshooting, report design and monitoring of system usage. In-depth knowledge on Tableau Desktop, Tableau Reader and Tableau Server. Configured report builder and trained business users so that they could create reports from the report models. Prepared the Layouts by placing the fields to the appropriate place of the final Report. Developed ETL, using SQL Server 2008 R2/2012 Integration Services to migrate data from Oracle data source into a SQL Server 2008 database and creating complex SSIS packages, DTS Packages. Wrote T-SQL queries, Store Procedures and used them to build packages and maintain the history of the data. Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily. Worked as a developer in creating Complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.

Improved Performance of the database by creating Clustered and non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler.

Maintained Data Model and synchronized it with the changes to the database. Involved with all the phases of Software Development Life Cycle (SDLC) methodologies throughout the project life cycle. Created Packages by testing and cleaning the Standardized Data by using tools in Data Flow Transformations (Data Conversion, Export Column, Merge join, Sort, Union all, Conditional Split and more) for existing/new packages and huge CSV file import to Sale Force from different data sources and ongoing tasks for mapping. Used multiple join statements to retrieve data from multiple tables. Deployed and configured reports in SharePoint Server. Developed collaboration and digital asset management system based on SharePoint and SQL Reporting service Created standard & Data driven report subscriptions. Snapshots report and cache for better performance. Creating Logical, Physical data model using SQL server, Erwin, MS Visio. Involved in code reviews meetings and designing sessions and get mentored from the tech leads. Strong experience in Database design and multi-dimensional modeling (star schema and snowflake schema), data cleansing, scrubbing and integration.

Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports. Deployed and scheduled Reports using SSRS and Tableau to generate all daily, weekly, monthly and quarterly Reports including current status, MIS reporting & MDX Scripting experience with SSRS Gathered user requirements and analyzed and designed software solution and database. Updated functional specification and technical design documents. Created complex Stored Procedures, DTS packages, triggers, cursors, tables, views and SQL joins. Worked with project lead and business users to understand business processes. MS SQL Server Developer/Back END Jan '06 - Mar '08 Tech Process (Finex

One of the best management service providers in the US to assist both large scale and small scale business in 25+ countries EDUCATION

Master Of Science in Engineering Aug '08 - Dec '10 University Of Bridgeport

Bridgeport University is one of the top 10 universities in the US CERTIFICATIONS

India

Bridgeport, CT

Involved in Data mapping, logical data modeling, created ER diagrams in ERWIN/Studio and used SQL queries to filter data within the database.

Created complex ETL strategies to extract, clean and deliver data to OLAP environment. Extensive experience in Extracting, Transforming and Loading (ETL tools) using SSIS, DTS Import/Export Data, Bulk Insert, BCP, DTS Packages and SSIS packages in AWS, Azure and hive enviroment. Migrated data from SAS environment to SQL Server 2005 with SQL Server Integrated Services (SSIS). Experience in creating SSIS packages using different type’s task, with Error Handling, log particular event by creating logging and worked on package configuration to run package on different server. Implemented OLAP Cubes, Facts, and Dimensions for providing summarized and aggregate views Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2008 Generated Sub reports, Drill down reports, Tabular Report and list reports using SSRS and publish PDF Managed, monitored the system utilization by using the query optimizer, checking the execution plan. Extensively used Profiler to identify and repair database lockups, deadlocks, and other issues. Established a sound backup and recovery policies and procedures. Created and maintained various databases for production, development and testing using SQL Server Created packages, procedures, functions, and triggers. Created the structure of the model and cube in SSAS and reviewed Cube with end user and changed the cube and documentation according to their requirements.

Successfully installed and configured MS SQL Server 2005. Upgraded the database from MS SQL Server 7.0 to MS SQL Server 2005. Transferred logins and users information using the DTS object transfer task Imported data from text files and excel sheets into SQL Server database using DTS package. Created reports from database onto excel spread sheet using DTS. Assisted in designing and creating user Interface and Handled database performance tunings. Working on Relational and Dimensional Data modeling for creating Logical and Physical Design of Database and ER Diagrams using multiple data modeling tools like ERWIN, ER Studio. Implemented in writing client side validations using JavaScript and VBScript. Developed packages to handle data cleansing, loading multiple files and executing tasks multiple times Wrote various Stored Procedures for the purpose of application development. Performed Database backups (operating system, flat file backups & export/import). Performed everyday backup and developed recovery procedures. Worked on Migration techniques across different databases and servers. Creation of new database, planning-location of data, index and transaction log files on the disks. Created Users and Roles, and managed security and permission of database. Involved in analyzing SQL Server Storage Structure, Index and Security Architecture Worked on DTS Package, DTS Import/Export for transferring data from oracle Database to SQL Server. GPA: 3.4/4

SQL Server ®2008, Implementation and Maintenance (Microsoft 072-432) SQL Server ®2008, Database Development (Microsoft 072-433) SQL Server ®2008, Business Intelligence Development and Maintenance (Microsoft 072-448) SQL server 2012 Administration (DBA) and Advance T-SQL Training (Performance tuning) (Impire data System LLC, USA)

Contact this candidate