BHAVISHA PATEL

Sr. SQL Database Developer / BI Developer

Tel: 201-***-**** E-mail: adlj6p@r.postjobfree.com Address: 27 Gerry Drive, Hudson, MA-01749

Professional overview:

** ***** ** ** *xperience in MS SQL Server on Windows environment.

Experience in design, development, coding and testing of business/commercial applications MS SQL Server 2008/2005/2000.

A well-organized, goal-oriented, highly motivated and effective team leader/member with excellent analytical, troubleshooting, and problem solving Skill.

Extensive SQL Development experience in Banking, Law Firm and Healthcare industries with a strong understanding of data & analytics.

Experience in Application Development Analysis, Requirement Analysis, Scoping, Developing, Debugging, Testing and Documentation of various phases in a project life cycle of Client/Server Applications.

Good knowledge of Computer Science theory & strong in modern programming languages.

Ability to work in-groups as well as independently with minimal supervision.

Experience in creating database, tables, indexes, stored procedures, views, T-SQL, DTS/SSIS using MS SQL Server.

Experienced in creating Tables, Stored Procedures, Views, Indexes, Cursors, Triggers, User Profiles, User Defined Functions, Relational Database Models and Data Integrity in observing Business Rules.

Working knowledge of Software Development life Cycle (SDLC) including functional specification and design document.

Worked on MicroStrategy Developer version to create schemas and Web version to create reports and Documents.

Skilled in Business Intelligence tools like SQL Server Integration Services (SSIS)

Experience in MS SQL Server Migration from SQL Server 2000 to SQL Server 2005 and SQL server 2005 to SQL server 2008 by creating ETL package from Scratch.

Experience in Database Backup and Recovery.

Expert Experience in Normalization, De-normalization.

Worked on OLAP Data warehouse, Model, Design, and Implementation.

Experience in SQL Server Analysis Services (SSAS) for designing OLAP Cubes.

Good knowledge of Data Marts, Data warehousing, Operational Data Store (ODS), Data Modeling like Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables using MS Analysis Services.

Excellent knowledge in RDBMS concepts. Extensively worked in Data Modeling.

Experience in Data legacy mart with migrating data from the difference sources.

Extensively involved in data extraction and loading using DTS in MS SQL Server 2000 and SSIS in MS SQL Server 2005. Import Export data, Bulk Insert and BCP.

Experience in creating Jobs, Alerts on SQL Mail Agent, and scheduled DTS/SSIS Packages.

Experience in query optimization & performance tuning.

Created Database and Database Objects like Tables, Stored Procedures, Views, user defined data types, different kind of join to fetch the data from different server table And functions using T-SQL queries.

Scheduled and monitored all maintenance activities of SQL Server to meet business requirements activities including database consistency check, and data backup & restore strategy.

Experience in creation of Database authentication modes, configuring permissions and assigning roles to users.

Index creation, Troubleshoot Performances issues with cluster index because of leaf level.

24*7 Production support and NOC support Experience

TECHNICAL SKILLS:

Databases

MS SQL SERVER 2000/2005/2008, ORACLE 9i, MS Access

Database Tools

T-SQL, Enterprise manager, Query Analyzer, BCP, SQL

Agent, Performance Monitor, Client Configuration Utility, Server Configuration Utility, Profiler, Export & Import (DTS), Erwin.

Web Servers

IIS 4.0---7.0

Languages

T-SQL, PL SQL, VB.NET, C#.NET, Visual Basic 6.0, C, C++

ETL Tools

SSIS, DTS

Reporting Tools

MicroStrategy, SSRS, Crystal Reports

Operating System

Windows 2000/2003/XP/NT/Vista, Windows 2000Advanced Server, Windows 2003, 2008 Enterprise Server, UNIX.

Data Modeling

Microsoft Visio, DB Designer, Front Page, Erwin

Version Control

Team Foundation Server (TFS), Visual SourceSafe (VSS).

Packages

Microsoft Office 2010/2007/2003/2000

Education:

Bachelor’s in Information Technology. GPA : 3.99/4.0

Master’s in Computer Science. GPA : 3.36/4.0

Professional Experience:

Client: Ropes & Gray LLP, Boston, MA Aug ’14 - Present

Role: Sr. Business Intelligence Developer (SQL/DW/SSIS/SSRS/SSAS)

Project Description: Working with Ropes & Gray in Finance team with multiple projects (Billing Collections, Budget Manager, TPG reports, MicroStrategy, etc…). The scope of the project is to design and build data solution to fetch report data and builds reports out of that. The goal is to generate Finance reports to make job easier for Management.

Environment: MicroStrategy, MS SQL Server 2008, SQL Server integration Services, SQL Server Reporting Services, Visual Source Safe, and SQL Server Analysis Services, Master Data Management Profisee.

Responsibilities:

Designed ETL Process to transfer data from different servers, validate data during transferring, and archived source data using SSIS.

Experience in Delta load for Data warehouse after finish initially process full load using ETL process.

SQL Server 2008 RDBMS database development using T-SQL programming queries, stored procedures, views and ETL.

Created statics reports and dynamic reports as per user’s requirements.

Created Drill thru and Drill- Down reports using SSRS as per requirements.

Created report subscription for users to refresh reports or send out email to their inbox and save on shared location.

Worked on Discover, Design, Development and Deploy for Data warehouse cycle.

Worked on schedules job using SQL Agent.

Created summary and details reports using SSRS, deployed them on report server for Users.

Worked on Visual Source Safe to store reports, proc and T-SQL.

Created joins and sub-queries for complex queries involving multiple tables.

Understanding about execution plan and estimated execution plan for poor performance query.

Created MDS solution using Profisee for users so that users can add/update the data which can feed directly to the backend database and see the results in report for the next day.

Worked on MicroStrategy developer tool to build the schema objects (Attributes, Facts).

Created Filters, Prompts, Metric to support report creation in MicroStrategy.

Created report dataset, dossier and document in MicroStrategy.

Client: Beacon Health Strategies, Boston, MA Oct ’13 – Aug’14

Role: Database Developer (SQL/DW/SSIS/SSRS)

Project Description: Working with Beacon Health Strategies on Member Utilization Management project. The scope of the project is to design and develop Data warehouse to build new BI Solutions. The goal of the project is to create reports for different clients to take management decision on members and Clinician data. Develop enterprise data warehouse and load data from different sources using ETL process as per business requirement.

Environment: MS SQL Server 2008, SQL Server integration Services, SQL Server Reporting Services, Crystal Report, Team Foundation Server, and Business Objects

Responsibilities:

Experience in Extracting, Transforming and Loading (ETL) data from Flat file, excel (spread sheet), MS SQL to MS SQL Server database by using SSIS services, BCP utility.

SQL Server 2008/2005 RDBMS database development using T-SQL programming queries, stored procedures, views and ETL.

Experience in creating SSIS packages using different type of task, with Error Handling on control flow task and dataflow task, use logging to log the events and worked on package configuration to run package on different server.

Sound Experience in creating static Dimensions called look up tables and dynamic Dimensions.

Experience in Error handling on Control flow task by using Send email task to send particular developer and Users and on data flow task putting default dimensions in measures and have them to load on enterprise data warehouse.

Used different transformation like Look up, Conditional split, data conversion, Aggregation, Merge, Merge join, union all, Multicast, sort, OLE DB command etc.

Experience in Delta load for Data warehouse after finish initially process full load using ETL process.

Worked on development and deployment of reports using SSRS.

Designed data model for data warehouse (logical and physical model) using star schema and snowflake schema.

Worked on tracking all data load by using truncation audit tables within SQL server.

Worked on deploying SSIS packages on Dev to QA to UAT to Production by using Manifest file and DTExecUI.

Created joins and sub-queries for complex queries involving multiple tables.

Created multiple temporary physical tables to get faster and efficient way data out of multiple tables.

Worked on Microsoft team foundation server to store ETL packages, proc and T-SQL.

Created date driven subscription and started subscriptions for users to refresh reports or send out email to their inbox.

Client: ikaSystems, Southborough, MA Oct ’11 – Oct’13

Role: Software Engineer (SQL Developer)

Project Description: I worked with ikaSystems on Medicare Automation Project. The goal of the project is to create and manage RDBMS Database for Medicare Member and Applicant data for different HealthCare Providers and automates the process of CMS data Exchange, delivers accurate result and speed to member enrollment.

Environment: MS SQL Server 2008, .NET, Visual source Safe, Team Foundation Server

Responsibilities:

Designed ETL Process to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.

Designed Data Validation scenarios and generated control reports once loads data into the system.

Deployed ETL Process on different servers including QA, UAT, PRODuction.

Extract the data from the different file format and Executed data cleaning process.

Participated in Databases Architecture and data Modoling design for enterpise database system.

Worked on installing, configuring and supporting database systems.

Involved in Import/Exporting of Data to/from SQL database.

Involved in Database Analysis.

Wrote SQL store procedures to accomplish daily basis data transactions.

Created Indexes and involved in Performance tuning.

Responsible for writing SQL queries, stored procedures, views, T-SQL.

Created well-formed reports for Member details and applications.

Created report for daily basis file Process system to monitors the Files.

Used Different software in order to safe the source Code.

Experience in creating jobs, SQL Mail, Alerts and schedule SSIS Packages using SQL Server Agent.

Created reports using Microsoft SQL Server SSRS based on parameter section and using Email Subscription and Data Driven Subscription.

Worked with different source safe techniques to keep safe all SQL scripts in server and manage all the version changes.

Experience with 24x7 Production support.

Client: Bank of America, Boston, MA Aug’11– Oct’11

Role: SQL Data Consultant (SSIS)

Project Description: I worked with Bank of America on Spend Management System project. The scope of the project was to design and develop Data Warehouse using Ralph-Kimball methodology for Reporting purpose which helps company to control and optimize money it spends.

Environment: MS SQL Server 2008, SQL Server Reporting Services, SQL Server Integration Services, OLAP.

Responsibilities:

Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.

ETL implementation using SQL Server Integration Services (SSIS), Applying some business logic and data cleaning in staging server to maintain child and parent relationship.

Worked on different task on control flow like Data flow task, Execute SQL task, for each Loop container, sequence container, FTP task, File system task, Send email task to let user Know about job status and Analysis services processing task to run Cube dynamic.

Experience in Delta load for Data warehouse, meaning initially process full load to the date

Sound Experience in creating static Dimensions and dynamic Dimensions.

Experience in load data in dynamic Dimensions by using slowly changing dimension Type I and Type II.

Create joins and sub-queries for complex queries involving multiple tables.

Created configuration files for SSIS packages and migrated on \Dev, \QA, \UAT and Prod environment.

Generated database monitering and data validation reports.

Deployed SSIS packages to Production Servers.

Migrated data using ETL Tool in SSIS.

Generated chart reports based on different spend category and difference spend sources.

Created partition table for very large database for good performance.

Participated Databases Architecture and data Modoling design for enterpise data warehouse.

Worked on Audit log SSIS packages to maintain tracks on success, failure, and execution process.

Wrote and integrated Stored Procedures to generate the Reports.

Provided 24x7 supports and ensure that all critical database problems are resolved in timely manner.

Client: CareerBuilder LLC, Norcross, GA Mar ’11 – July’11

Role: SQL Developer/ BI Developer (SSIS, SSRS, SSAS)

Project Description: CareerBuilder provides Business Solutions with data analysis, comprehensive partner network and superior customer service to match the right people with the right jobs. Provide customer solution by following Lean principles.

Environment: SQL Server 2008 R2, SSIS, SSAS, SSRS, SharePoint Services 3.0

Responsibilities:

Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file (CSV), XML, and Oracle to MS SQL Server by using BCP utility, SSIS services.

Created SSIS Packages to migrate data from SQL 2005 to 2008 and worked on slowly changing dimensions.

Worked on SCD Type-1, 2 in order to keep historical data in enterprise data ware house.

Worked on staging database, data clean up, data cleansing and concatenate of data in staging environment through ETL process and T-SQL queries.

Created configuration files for SSIS packages and migrated on \Dev, \QA, \UAT and \Prod environment.

Responsible for Deploy ETL packages on Development environment, QA, UAT and production.

Worked on OLAP Data warehouse, Model, Design, and Implementation.

Responsible to create job on SQL server agent and have them to run by using batch command.

Created Cube on top of enterprise data warehouse.

Worked on partition of cube in order to pull data very efficient way and for better performances.

Worked on Excel pivot functionality to pull Cube data and Responsible for to show how to pull data in Excel in Demo.

Worked on process full for measure group and process update for Dimensions in cube.

Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, user defined data types and functions.

Creation of schema objects, rules and granting of roles to the users.

Worked and coordinated with developers in writing and tuning new stored procedures.

Write T-SQL statements for retrieval of data and Involved in performance tuning of TSQL queries and Stored Procedures.

Involved in developing E-R diagrams, logical & Dimensional Modeling, development and implementation of Enterprise data warehouse project.

Create joins and sub-queries for complex queries involving multiple tables.

Developed complex stored procedures to create various reports.

Used DDL and DML for writing triggers, stored procedures, and data manipulation.

Optimized query performance by creating indexes.

Created summarized and details reports as per business requirements.

Created different kind of reports for internal and external users as per the Business Analysts requirement.

Created drill through reports for getting more information about the product at detail level.

Deployed reports on Report Server as well as Share point Environment.

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

Control source code of database, reports and packages using Visual Safe Source control.

Worked with different team to finish a given business requirement earlier than deadline, because of changing priorities of project.

Created design and technical document at the end of Project for users with Data model.

Client: Maruti Machines Pvt. Ltd., Gujarat, INDIA July’05 – July’08

ROLE: Database Developer

Project Description: Maruti Machines provides supplying of Turn key projects commissioning, erection and installation. Had analyzed inventory data and provides a Business reports on daily basis. Build up a database model from scratch to maintain all machine parts, clients and employee information.

Environment: SQL Server 2000, MS Access, Erwin 4.1, SQL Query Analyzer, Crystal Report.

Responsibilities:

SQL Server 2000 RDBMS database development including T-SQL programming.

Designed logical / physical data models and defined primary key, foreign key using Erwin tool.

Developed stored procedures, functions, views and triggers.

Actively participated in gathering of User Requirement and System Specification.

Created new database logical and physical design to fit new business requirements, and implemented new design into SQL Server 2000.

Identified, tested, and resolved database performance issues (monitoring and tuning) to ensured database optimization by using Index Tuning Wizard, SQL Profiler and Query Analyzer (execution Plan).

Generated dynamic stored procedures, xml stored procedures, triggers for the database development.

Create joins and sub-queries for complex queries involving multiple tables.

Created Users and Roles, and managed security and permission of database.

Created stored procedures for Automatic Scripting to backup transaction logs, log files, maintain archive of objects.

Contact this candidate