Ankur Shah

ac6u2x@r.postjobfree.com

347-***-****

PROFSESSIONAL SUMMARY

Senior SQL Developer specialized in database design, development and maintenance in a SQL Server environment (2016/2014/2012/2008/2005/2000).

Strong background in E-R modeling and Relational & Object Relational Database concepts.

Hands on experience creating TSQL queries with Joins, Cursors and Triggers.

Advanced experience writing stored procedures, functions, Cursors, views, DDL and DML.

In depth SQL Server Reporting Services (SSRS) experience, leveraging to create, deploy, and manage reports.

Proficiency with SSIS (SQL Server Integration Services), DTS (Data Transformation Services) as well as some exposure to Ab Initio.

Hands on experience developing and deploying OLAP Cubes.

Intermediate TSQL experience, including creating queries with Joins, Cursors and Triggers

Full SDLC (Software Development Lifecycle) project experience, requiring detailed cross functional team collaboration throughout all phases, including: analysis, design, development, testing, implementation, production support.

Results oriented team player, able to manage multiple tasks by priority to ensure the timely satisfaction of required project deliverables.

Effective communicator, able to clearly articulate pertinent project information to technical and non-technical audiences.

Proficient in creating, maintaining and scheduling Power BI Reports and Dashboard including tabular reports.

Extract and analyze data using Power Query, PivotTables, MS Excel, POWER BI and SSAS. Thereby migrate existing data into the Power BI.

TECHNICAL SUMMARY

ETL Tools: SQL Server 2000-DTS, SQL Server

2005/2008 R2-SSIS, Ab-Initio.

OLAP Tools: SSRS, SSAS, Power BI.

Databases: Oracle 8i/9i/10g, MS SQL Server

2000/2005/2008/2008 R2/2012/2014/2016,

DB2, MS Access

Others: VSS, TFS, RED GATE, SQL-Navigator,

Test Director, Win Runner

Database Skills: Stored Procedures, Cursors,

functions, Database Triggers and packages

Languages: VB 6.0, Visual Studio.NET, SQL,

PL/SQL, C, C++, UNIX shell scripts,

XML, HTML, .NET Framework 2.0/3.5

Operating Systems: Windows NT, Windows

2003/2008/2010, Windows 2000, XP, Windows

7, UNIX

EDUCATION:

Masters of Science in Computer Management: University of Pune; Pune, India Bachelors of Science in Chemistry: University of Pune; Pune, India. Ditech Holding Corporation, Jacksonville, FL January 2017 – Present Developer

Coordinating with business users in analyzing business requirements and translating them to technical specifications.

Translated business needs into data analysis, business intelligence data sources and reporting solutions for different types of information consumers.

Created complex SQL stored procedures, Triggers, Functions, Views, Indexes in SQL Server 2016 and used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables & calculations from different databases.

Designed SQL SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL Server 2016 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.

Scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks.

Using SSIS Package identified the Up-streams and imported the required tables into intake- database, Store Procedures are created in staging database using the intake-database tables & views.

Checking the code into TFS (Store Procedures, Views, Tables, Schema) for the deployment process for the production environment.

Designed and implemented SSAS Tabular Cube as the reporting layer. And Used DAX scripting to access data from Tabular Model.

Designed and implemented Row Level Security & Roles for SSAS Tabular Model. And deployed into SQL SERVER ANALYSIS SERVER 2016.

Created complex SSAS Cubes with multiple fact measure groups and multiple dimension hierarchies based on the OLAP Reporting needs.

Created KPI's, Partitions, Perspectives, and Calculated Measures, used DAX queries, Roles.

Create reports in Power BI preview portal utilizing the SSAS Tabular Model via Analysis connector.

Created different visualization (Stacked bar Chart, Clustered bar Chart, Scatter Chart, Pie Chart, Donut Chart, Line & Clustered Column Chart, Map, Slicer, Time Brush etc.) in Power BI according to the requirements.

Created Page Level Filters, Report Level Filters, and Visual Level Filters in Power BI according to the requirements.

Used One Drive for storing different versions of Power BI report.

Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients and mobile apps.

Created Dashboard and the Content Pack for the originations to get the updated Power BI Reports. And added the refresh time for each tile in the dashboard.

Used JIRA for Version Control needs, task check-ins.

Responsible for complete maintenance and delivery of scheduled releases. HSBC, NY June 2012 – December 2016

Developer

Collaborated with cross functional team and with users throughout to fully understand the impact of the requirements on the system.

Worked with data flow from source files like Excel and flat files into SQL server with proper mapping and high volume of data.

Developed complex T-SQL queries using DDL, DML, DQL and designed SSIS packages to load the data into warehouse.

Designed SSIS Packages to perform Data Cleansing and Data Profiling using several transformations like Data Conversion and Derived Column.

Utilized several transformations in Data Flow and control flow including Derived-Column, Script, Slowly Changing Dimension, Data Conversion, and Conditional-Split for implementing the Transformation Logic in the Packages.

Scheduled Packages using SQL Server Management Studio for the daily, weekly and monthly Load.

Created SSIS packages with package configurations, error handling and logging.

Developed, deployed and monitored SSIS Packages on daily, weekly and monthly basis in Development, Staging and Production environments.

Created and maintained setup log files and email notifications to monitor jobs in a real time production and Staging environments.

Used SSIS to import, export and transform the data between the linked servers and Involved in day-to-day database maintenance operations.

Migrated SSIS 2005 packages to SSIS 2008R2.

Created Alerts for successful or unsuccessful completion of Scheduled Jobs.

Created complex Stored Procedures, Triggers, User Defined Functions, CTE’s, Cursors, Views using TSQL to implement complex business logic.

Created tables, indexes and constraints using TSQL.

Tuned complex SQL Queries using SQL Profiler, Estimated Query Plan and Index Tuning Wizard.

Wrote Joins and sub-queries for complex queries involving multiple tables from different databases.

Developed report specifications, creating and modifying reports using SSRS 2005/2008R2.

Migrated SSRS2005 reports to 2008R2 reports using SSRS.

Migrated Crystal reports to 2008R2 reports using SSRS.

Created reports subscriptions using SSRS to send data in PDF, Word and Excel format on Daily, weekly, monthly and yearly basis via emails and sending to shared folders. TRISTAR INVESCO INC., FL January 2010 – March 2012 SQL Server Developer

Used SSIS for data flow from source files like Excel, flat files, Tables and External Database Servers with mapping of data by using multiple transformations.

Wrote SSIS Packages to transform daily, weekly and monthly jobs, to transfer data from SQL server to different files and external databases.

Created master and child packages, package configurations, error handling and logging.

Participated in the development, implementation, administration and Support of ETL processes for Data Warehouses using SQL Server 2008 SSIS on daily, weekly and monthly basis.

Used SSIS to import, export and transform the data between the linked servers.

Involved in troubleshooting and fixing the loading issues with ETL packages and files.

Creating and maintaining databases, tables, views, Indexes, check constraints, and business rules using T-SQL. Responsible for Performance tuning the queries, stored procedures and tables by using SQL Profiler, Execution Plans and Index Tuning Wizard.

Wrote complex SQL queries using joins, sub queries, common table expressions (CTEs) and Functions in T-SQL to retrieve data from multiple tables.

Developed stored procedures as well as created variables and expressions using VB script.

Created and Modified Triggers and Cursors in T-SQL for maintaining SQL server databases.

Involved in data capture and slowly changing dimensions to modify and insert data into existing tables and capturing the corresponding changes in History tables.

Developed Custom Reports using SSRS.

Involved in Creating Datasets, stored procedures in T-SQL for SSRS.

Worked on Developing, Deploying and Scheduling Complex Reports using Sal server reporting Services (SSRS) to generate daily, weekly, monthly and quarterly Reports.

Designed and Deployed Tabular, Matrix, List and Chart reports with Drill Down, Interactive sort, Drop down menu option, Parameterized and Sub reports.

Scheduled and deployed reports and uploaded files to a share point and report servers.

Created standard report Subscriptions to export report into required formats and placing them on shared folders to load again into Database using SSIS packages.

Contact this candidate