Nutan Bodke

Email: adddup@r.postjobfree.com

Phone: 501-***-****

Professional Summary:

Around 7+ years of experience in Data Modeling, Database Design, Programming, Development and Implementation of Client-Server Applications & Database systems using 2008/R2, 2012,2014,2016 for both OLTP & Data warehousing applications in various business domains.

Experience with complete SDLC life cycle, which includes requirement gathering, analysis, design, development, maintenance and implementation.

Strong TSQL experience in creating database objects like Tables, Stored Procedures, DDL/DML Triggers, Views, Indexes, Cursors, Functions and User defined data types.

Involved in relational data modeling and multi-dimensional modeling using De-normalizations, Fact tables, Dimension tables, Star schema for OLAP systems.

Experience in SQL Server DTS and SSIS package design, development, and deployment using SQL 2017 in Control flow, Data flow, Error Handling and Event handling in different heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data).

Extensive experience in SSRS and proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down and Sub reports.

Experience in deploying created reports in various sources like Web browser, XML and PDF.

Worked on SQL BI solution integration with Microsoft Share Point Server (MOSS).

SSExpertise in Ad-hoc reporting, Parameterized, Custom Reporting using SSRS for daily reports and SSAS projects.

Worked on OLAP Data warehouses, Modeling, Design, cube development including KPIs, Data mining, working with changing dimensions.

Experience in OLAP cube partitions, aggregations, optimization as well as refreshing cube data.

Functional knowledge of C#, .Net, JavaScript, HTML, XML, RDBMS (Oracle, SQL Server), SharePoint Server, Communications protocols (TCP/IP)

Experience in developing web applications using ASP.Net, ADO.Net.

Worked very closely with Customers and End users, collect requirements and training or resolve any business process related issues.

Expert at understanding Business and transforming requirements into SSIS packages.

Self-Motivated with Excellent communication skills with a strong focus on Client oriented service and ability to work excellently as an individual and also as part of a team with minimum amount of supervision.

TECHNICAL SKILLS:

Operating Systems

MS DOS, Windows 10, UNIX V7

Databases

MS SQL Server 2016/2014/2012, Oracle 8i/9i, 10g, 11g, MS Access

ETL Tools

Data Transformation Services (DTS), SQL Server Integration Services (SSIS)

Analysis Tools

SQL Server Analysis Services(SSAS)

Database Tools

SQL Server Management Studio, Business Intelligence Development Studio, SQL Profiler, SQL Query Analyzer, Index Analyzer, DTS Import/Export, Backup Server, Replication server, SQL Agents, SQL Alerts, SQL Jobs, Bulk Insert and BCP

Languages

Transact SQL (TSQL), PL/SQL, C, C++, Java, C#, ASP.Net, VB Script,

DB Modeling Tools

MS Visio, Rational Rose, Erwin 4.0,Visual Paradigm for UML

Reporting Tools

SQL Server Reporting Services (SSRS), Report Writing in SSRS, MS Excel

.Net Frameworks

.Net Framework 1.0/2.0/3.0/3.5, Microsoft Office SharePoint Server

EDUCATION

Bachelor of Technology, Mumbai University, Mumbai, India

Professional Summary

Amerisource Bergen, Frisco, Texas Oct 2018 - Till Date

MS SQL Server/ BI Developer

Description: AmerisourceBergen Specialty Group's companies rank among the largest and most influential organizations in their respective markets. As a result of these relationships, the Specialty Group is able to bring its clients significantly greater access to the resources, processes and strategic relationships they need to succeed.

Responsibilities:

Designed and developed databases for OLTP and OLAP Applications.

Provided support to 50 database Servers. Support included Production, QA and Development

Upgraded database tables from 2008 to 2012 SQL environment.

Created complex Stored Procedures for data retrieval.

Created SSIS Packages using Pivot Transformation, Execute SQL Task, Data Flow Task, etc to import data into the data warehouse.

Created SSIS packages to transfer data across heterogeneous data sources.

Developed, scheduled and generated variety of reports like List, Matrix, Drill-Down, Chart and Sub Report and standardize company report by implementing SQL Server Reporting Services (SSRS)

Optimized performance of various SQL scripts, stored procedures and triggers by using embedded UDFs, CTEs and System stored procedures.

Created triggers, UDF, views, tables, and generated TSQL script for application.

Analyzed execution plan and optimized queries by creating indexes.

Created linked servers to fetch data from Oracle.

Created user defined functions in SSRS using VB script.

Deployed SSRS reports on Microsoft office SharePoint (Moss).

Wrote complex TSQL queries and Stored Procedures for the reports

Created Cubes in Analysis Services.

Created standard report Subscriptions and Data Driven report Subscriptions.

Tested the data with complex queries, joins and sub queries.

Used Execution Plan, SQL Profiler, and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.

Environment: SQL Server 2014/2016 Enterprise Edition, SQL Server Integration Services, SQL Server Reporting Services, SQL Server Analysis Services, Crystal Reports,SharePoint 2007, C#, TSQL, ODBC, Excel, Access, Windows.

Client: American Express, Phoenix, AZ Dec 2016 – Sep 2018

Title: MS SQL Server/ BI Developer

Description: American Express is an American multinational financial services organization which is primarily known for providing financial services such as Credit card, Charge card and traveler’s cheque. American Express shortly known as AMEX has been ranked the 22nd most valuable brand in the world estimating brand to be worth of US$14.97 billion.

Responsibilities:

Involved in Analysis, Planning and Defining data based on business requirements and provided documentation.

Extensively worked in analyzing Stored Procedures on Legacy Environment, produce documentation and re-create them on New environment

Created more than 1000 stored procedures using Common Table Expression (CTE) and various types of UDF functions

Generated multiple Enterprise reports from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports etc.

Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.

Designed and developed various Service Management Reports, utilizing Dynamic and Cascading Prompts, fund Reports, sub-reports, charts, Pie charts, conditional and dynamic reports using SSRS.

Worked on all types of report types like tables, matrixes, charts, sub reports etc.

Created Linked reports, Ad-hoc reports and etc based on the requirement. Linked reports are created in the Report Server to reduce the repetition the reports.

Used most of the controls and features in SSIS for transforming data from different sources.

Developed, monitored and deployed SSIS packages.

Scheduled and executed SSIS Packages using SQL Server Agent.

Working experience with in-memory concepts of OLTP databases in SQL SERVER 2014.

Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional, Split, Derived columns etc.

Identified duplicate data by using an Aggregate transformation that group’s data by contract id. An email task was used to point other team members and managers to the files with the unacceptable data and also state the data issues.

Programming & deployment of console applications using C# (.Net 3.5) to perform the ETL

Worked on .Net framework 4.0 and Asp.net as a programming part.

Implemented security to restrict the access to users and to allow them to use only certain reports.

Developed Cubes using SQL Analysis Services (SSAS) and Experience in Developing and Extending OLAP Cubes, Dimensions and data source view.

Involved in creating the Data Source Views (DSV) and Cubes using the identified Fact and dimension tables.

While developing reports from Cubes also used the KPI's for decision making, also implemented Cube Partitions and also debugged data connections, data sources and Data Source Views.

Environment: SQL Server 2014, Enterprise Manager, Management Studio, SQL Profiler, SQL Query Analyzer, MS SQL Server DTS, SSIS, SSAS, ASP.NET, C#.NET, SSRS, MS SQL Server Analysis Services(SSAS), VBA and VB Script.

Molina Healthcare, Herndon, Virginia Jan 2014 - Nov 2016

MS SQL Server Developer

Description: Molina Healthcare is an organization which has health plans, medical clinics and health information management solutions. It provides healthcare services to many families and individuals covered by government programs.

Responsibilities:

Gathering the requirements by interacting heavily with the business users, multiple technical teams to design develop the workflows for the new functional piece.

Experience in SQL joins, sub queries, tracing and performance tuning for better running of queries.

Responsible for installation of SQL Server, database design, and create schema objects like tables, views and indexes

Extensively used joins and sub queries for complex queries involving multiple tables from different databases.

Performance tuning of stored procedures and functions to optimize the query for better performance.

Transformed complex business logic into database design and maintaining it by using Sql objects, stored procedures, user defined functions, views, TSQL scripting and jobs.

Successfully implemented indexes on tables for optimum performance.

Developed complex stored procedures using TSQL to generate Ad-hoc reports within SQL Server Reporting services.

Created Sub Reports, Parameterized and Drill down Reports based on the requirements provided using SSRS.

Worked on COSMOS Workgroup Feed Import. The Automated feed will update tables from COSMOS Data.

Created various SSRS reports such as Multi-valued reports, Parameterized, Linked reports, Drill down reports, Tabular Matrix reports and Chart diagrams.

Scheduled SSRS reports for end users and managed the security of the reports.

Exported SSRS reports to various formats like PDF, Word and Excel and scheduled to reports to send as an email body.

Strong analytical and problem solving skills coupled with interpersonal and leadership skills.

Interaction with the clients to gather out the requirements and assist them in immediate workarounds for the issues with the application.

As SSRS developer, working closely with Business Analysts gathering and clarifying data reporting requirements

Environment: MS SQL Server 2012, SSRS, DTS, TSQL, Oracle 10g, PL/SQL, TOAD, TSQL, Mainframes, C#. NET, VB.NET, Windows Sever, SQL Server Management Studio, SQL Profiler, Query Analyzer, Erwin 7.0

Client Name: Copart Inc, Dallas, TX Sep 2013 - Dec 2014

Title: SQL Server/ BI Developer

Description: Copart sells vehicles for a variety of consignors including finance companies, banks, dealers, fleets, rental car companies, and the insurance. Copart also sells vehicles for the public through its fast, easy service called CopartDirect, and for franchised and independent auto dealers through its Copart Dealer Services (CDS)

Responsibilities:

Developed the Functional specification documentation for the modules to be developed.

Worked with SQL and PLSQL to create Tables, Views, and Triggers and stored Procedures.

Created various database objects (tables, indexes, views, stored procedures and triggers) and implemented referential integrity constraints for enforcing data integrity and business rules

Responsible for tuning TSQL procedures, triggers and other database objects

Designed and developed DTS packages for transferring data from flat files and Access files

Created linked servers between different SQL Servers and also created linked server with different access files used across various departments

Used informatica for ETL process.

Extensive use of TSQL DDL and DML commands for various applications.

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.

Expert in implementing an extra level of security by creating views and creating stored procedures to query the confidential data.

Increased performance necessary for statistical reporting by 25% after performance monitoring, tuning and optimizing indexes.

Generated the various kinds of reports using Graphs and Images.

Migrated some Crystal reports to SSRS reports

Created Parameterized reports and linked reports using Bookmark links, Drill through links and Hyperlinks.

Environment: TSQL, SQL Server 2012, Crystal Reports 9.0, Windows 2000 Server, MS Access, Oracle, VB.Net, Erwin Data Modeler.

Client: Infotech, Hyderabad, India Oct 2012– Aug 2013

Title: MS SQL Server Developer

Description: It is a multinational provider of Information Technology (IT) and Knowledge Process Outsourcing solutions, with global development centers. This project is providing support and modernization services for the client's web site.

Responsibilities:

Involved in writing TSQL programming for implement Stored Procedures and Functions for different tasks.

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

Optimized the performance of queries by modifying the existing index system and rebuilding indexes.

Wrote complex queries, triggers and stored procedures, views and user defined functions.

Design and implement database logical and Physical Schemas.

Responsible for database tuning using normalization and application tuning.

Used C# to modify and Add Server Controls for Dynamic Server-Side Code.

Maintenance of Development, System test, Assemble test and Integration Servers and databases.

Query tuning, Index Tuning and performance tuning.

Creation and maintenance of databases, objects.

Users and user group creation and maintenance.

Extensively used Enterprise Manager, Query Analyzer, and SQL Server Profiler.

Created custom and standard reports using Crystal Reports.

Developed parameterized crystal reports existing reports for presentations using cross-tab reports, running totals, and alerting.

Created and modified stored procedures to Create Reports.

Environment: SQL Server 2012 Enterprise Edition, MS PowerPoint, MS Access & Windows 2K platform

Contact this candidate