Sql Server Data

Samit Shah

*s*** Olympia Ct, Naperville, IL - ***40 - 720-***-****, **********@*****.***

Professional Summary

A well-organized, goal-oriented, highly motivated and effective team leader/member with excellent analytical, troubleshooting, and problem solving Skill. Over 13 years of total IT experience in Design, Development, Implementation and Support of Database application. To seek a challenging role that will utilize my skills, education, and experience.

Areas of Expertise

Expertise in designing and implementing SSIS package.

Extensively worked on complex T-SQL, Stored Procedures, Triggers, Views, CTEs and UDF.

Hands on in performance tuning of Queries, Stored Procedures.

Hands on experience of creating different type of reports (Matrix, tabular reports) with Crystal Reports and SSRS.

Hands on Tabular Model

Hands on experience in Amazon Redshift and Informatica Cloud.

Hands on Power BI.

Worked on various methodologies of SDLC including AGILE SCRUM methodology.

Strong analytical, debugging and problem solving skills.

Ability to learn quickly and provide quick turn around on new technologies.

Technical Skills & Languages

System:

Databases SQL Server 2000 / 2005 / 2008 / 2008R2/2012/2014, MS-Access, Amazon Redshift

ETL Tool SQL Server Integration Services (SSIS), Informatica Cloud

Visualization Tool Crystal Reports (8.5, 11), SQL Server Reporting Services (SSRS), Power BI

Analysis Tool Tabular Model (SSAS)

Languages VB.net 1.1, ASP.net 1.1, VB-6.0, ASP-3.0, VB scripting

Source Control Tool Team Foundation Server (TFS), Visual Source Safe (VSS), Github, All Change, Subversion Net (SVN)

Professional Experience

iLink Systems, Inc.

Downers Grove, IL

Aug 2014 to Present

iLink integrates software systems and develops custom applications, components, and frameworks on the latest platforms for IT departments, commercial accounts, application services providers (ASP) and independent software vendors(ISV).

Client: Boys and Girls Club of America Jun 2016 to Present

Database Lead

Worked with Data Architect to build Enterprise Data Warehouse.

Understanding the system and creating data model for Phase-2 and Phase-3

Developed framework to load data from OLTP system to data warehouse using SQL Server Integration Services (SSIS).

Created Stored Procedures, User defined functions, Views for pulling the data from SQL Server OLTP system to Data Warehouse.

Build Tabular model for reporting need using SQL Server Analysis Services (SSAS)

Developed POC to build dashboard in Power BI.

Mentored team member to understand the requirement.

Technologies: SQL Server 2012, SSIS, SSAS (Tabular Model), Power BI

Client: Univar Jul 2015 to Jun 2016

Database Lead

Led team of 6 development engineers in building enterprise data warehouse using Amazon Redshift and Informatica Cloud.

Changed the existing Truncate and load process to incremental load for better performance of load process.

Involved in discussion during sprint planning meeting to take up the user stories for development and delegate work to different team members.

Discussed with technical manager on the approach of loading data from different sources to redshift.

Discussed with client on the technical design of dimensions and facts to build Enterprise Data Warehouse (EDW).

Worked closely with product owners to understand the reporting needs, and get it implemented in Tableau.

Discussed with architect and technical manager on performance improvement of overall load process.

Designed and developed Informatica cloud jobs to load the data from IBM DB2, SAP ECC, and Sales Force to Amazon Redshift.

Assisted team member in resolving technical issues.

Assisted downstream applications in getting the data from enterprise data warehouse

Involved in the post-production support and resolving issues, if any.

Technologies: Amazon Redshift, Informatica Cloud, Tableau

Client: Prolifiq Aug 2014 to May 2015

Sr. Software Engineer

Designed framework for loading data from OLTP system to Data warehouse. Developed complex T-SQL, Stored Procedures to cater the business needs.

Designed and build a framework to load the Data warehouse including Audit Logging, Error Logging. Incremental load of Data warehouse was implemented using Change Data Capture (CDC) feature of SQL Server.

Implemented dynamic SSIS package creation using Business Intelligence Markup Language (BIML).

Designed and developed SQL Server Integration Services (SSIS) to load data from CSV files to SQL Server, rendering report using SSIS.

Created SQL agent jobs to schedule and execute the SSIS packages. Email notifications send on failure of job.

Designed and implemented reports using SQL Server Reporting Services (SSRS) for management to analysis the data.

Developed Stored Procedures, views to meet the business needs.

Technologies: SQL Server 2012, SSIS, SSRS, BIML (Business Intelligence Markup Language)

Universal Business Consulting, Inc.

Westborough, MA

May 2013 to Jul 2014

UBCI has provided software engineering services on an outsourced basis to Fortune 1000 firms and other technology innovators. It focuses exclusively on providing software product engineering services to its clients.

Client: Healthways Intl.

SQL Server Developer

Designed packages to extract, transform and load data from various sources to SQL Server which involved creation of complex stored procedures.

Designed and developed SQL Server Integration Services (SSIS) to load data from fixed length files to SQL Server.

Hands on involvement in developing reports using SQL Server Reporting Services (SSRS).

Developed complex database queries, Stored Procedures, and triggers to meet the business needs.

Involved in performance tuning of views, which significantly reduced execution time in production.

Co-ordinated with offshore team to implement the data exchange project, which was used for syncing the data in all the environment.

Technologies: SQL Server 2008 R2, SSIS, SSRS, XML

Intersoft Data Labs Inc.

Broomfield, CO

Jan 2012 to May 2013

Intersoft Data Labs provides flexible software services and solutions on various domains in banking and finance sector, healthcare, pharmaceuticals, foods and beverages.

Client: Lender Processing Services (LPS).

SQL Server Developer / Lead

Designed packages to extract, transform and load data from various sources to SQL Server which involved creation of complex stored procedures. Post deployment provided support to UAT and QA to solve issues.

Designed flow diagram for migration of data from legacy system to new system using Visio.

Designed and developed SQL Server Integration Services (SSIS) to load data from flat files, CSV files, and Excel file to SQL Server.

Hands on involvement in developing reports using SQL Server Reporting Services (SSRS).

Implemented dynamic package creation using Business Intelligence Markup Language (BIML).

Developed complex database queries, Stored Procedures, and triggers to meet the business needs.

Assisted team members in solving technical issues.

Participated in providing support to UAT and QA.

Involved in performance tuning of Stored Procedures and queries.

Technologies: SQL Server 2008 R2, SSIS, SSRS, VB Scripting

Webvisible Technology

Mumbai, India

Mar 2011 to Jan 2012

Webvisible provided local online marketing products and services for the use of search as reliable measurable avenue to connect directly with a buyer’s needs.

Product: Geneva

SQL Server Lead

Requirement gathering and delegating work to team members had been the day-to-day activity. Providing assistance to team member by solving technical issues and suggests better approach if needed.

Understand the requirements from onsite coordinator and delegate work to team members.

Assist with the design and development of a centralized datawarehouse to be used as a basis for ad hoc and scheduled production reports. Datawarehouse to serve as single source of truth to eliminate any data inconsistencies in reporting across the company.

Work closely with users to design and develop reports in the proper context and assist with data auditing to identify anomalies.

Provided technical guidance to team members.

Designed and developed packages using SQL Server Integration Services (SSIS)

Reviewed code and provided suggestions to improve SQL queries.

Technologies: SQL Server 2008 R2, SSIS, Crystal Reports 8.5

Mastek Ltd

India / UK / USA

Feb 2007 to Mar 2011

Mastek provides business and technology services of Application Development, Systems Integration, Data Warehousing and Business Intelligence, Application Security, CRM services, Legacy Modernization and Data Migration.

Client: Provident Financial (UK), Microsoft Corp.

Senior Software Engineer

Gather requirements from client to develop packages using various SSIS components and Stored Procedures. Designed cubes for management to analyze the data of enterprise by displaying it in excel and SSRS report.

Interacted with client to understand requirements and providing knowledge to team members.

Developed SQL Server Integration (SSIS) packages to extract, transform and load data from various sources to the Finance Datamart (FDM)

Created complex Stored Procedures, Triggers and UDF to meet the business needs.

Worked on SQL Profiler and Estimated Query plan to optimize the performance of SQL queries and stored procedures

Created and executed Test plans for functionality testing

Technologies: SQL Server 2005, SSIS, SSRS, Visual Basic, ASP.net, Octopus

Tandon Information Solutions (TIS)

Mumbai, India

Oct 2004 to Feb 2007

TIS provide solutions for intelligent Software development, software customization, and implementation of fully integrated business management software, ERP solutions.

Client: Dakota Services Inc.

Senior Software Engineer

Developed complex T-SQL, Stored Procedures, UDF and Triggers to cater the business needs. Build test plan for functionality testing. Post deployment provided support to system testing team to solve technical issues.

Requirements gathering, analysis and implementation.

Responsible for business class and business logic design.

Designed and generated Reports with Crystal Reports

Developed Stored Procedures, User Defined Functions and Triggers on SQL database

Created and executed the Integration and Unit test cases.

Technologies: VB.net, SQL Server 2005, Crystal Reports

Education & Certification

University of Mumbai, Mumbai, India

Bachelor of Engineering (Electronics) June – 2001

Certification

MCP – Querying Microsoft SQL Server 2012

Contact this candidate