*

JAHANVI PATEL

ac8h69@r.postjobfree.com

Work • Experience Expertise: in complete Software Development (862)232-Life 3363 Cycle (SDLC) processes including Analysis, Design, Programming, Testing and Documentation.

• Excellent skills in writing complex SQL queries involving multiple tables(Join), ability to develop and maintain views, stored procedures, triggers and user defined functions.

• Experience in database modeling and database architecture based on functional requirements and system design of the client using RDBMS concepts.

• Expertise in implementing complex ETL packages to extract data from various sources (SQL Server, Oracle, Excel file, DB2, SharePoint lists and Flat File) and load into various destinations.

• Effectively used Normalization and De-Normalization techniques for both OLTP and OLAP systems in creating database objects like tables, constraints and indexes.

• Created SQL server analysis projects and created multi-dimensional databases and OLAP cubes and dimensions for the analysis of capacity planning task in specific areas for departmental manager using SSAS.

• Strong experience in creating various reports like drill through, drill down and Ad-hoc per the user requirement using SQL Server Reporting Services (SSRS).

• Ability to work in environments with fluctuating priorities and deadlines, foresight to handle upcoming issues and dedication to solve complex problems with experience and research.

• Fast learner who also adapts quickly new technologies with the ability to take new roles in minimum time with Professional Ideology little training. Info Experience Solution June 2017 to Current MS Environment: SQL Server Developer / Database Developer MS SQL Server 2008/2008R2/2012/2014/16, Windows 2003/2007/2010/2012R2 Servers, IIS, MS Access, ETL

• Developed different types of tabular reports, matrix reports, chart and graphs, reports that aggregate data using SQL Server Reporting Services.

• Documented the physical ETL process design based on business requirements and system specifications with strong ETL design skills, including source to target mappings, transformations, lookups, aggregations, expressions.

• Have used SQL Server 2012 Integration Services (SSIS) transformations in the data flow of a package to aggregate, merge, distribute, and modify data.

• Developed SQL triggers and master tables for automatic creation of primary keys.

• Wrote SQL programs required to retrieve data using cursors and exception handling.

• Developed complex programs in T-SQL, wrote Stored Procedures, Triggers, Views and Queries with best execution plan.

• Database Administrative skills including, backups, recovery, database maintenance. 2

Ideology Info Solution January 2017 to March 2017

MS Environment: SQL Server Developer (Internship)

MS SQL Server 2000/2005/2008/2008R2/2012/2014, Windows 2003/2008/2012 Servers, T-SQL, SSAS, SSIS (ETL), SSRS

• Extracted data from various locations such as excel and flat files to SQL server 2012/2008.

• Created database objects like views, index and procedures.

• Developed SQL queries and stored procedures to fetch data from tables in remote databases using joins.

• Database development experience with Microsoft SQL server in OLTP/OLAP environments using integration services (SSIS) for ETL (Extraction, Transformation and Loading).

• Performed various data transformations using conditional split, data conversion, derived columns and lookups to source data to transfer data in a format as per organization needs. B.S. • Soft Have used different monitoring and troubleshooting tools for query optimization. June 2013 to April 2014 Database Environment: Developer (eBook Reader Project) MS SQL Server 2005/2008/2008 R2/2012, Windows 2003/2008R2/2010 Servers, SSRS, SSIS

• Created stored procedures, user defined functions, views and wrote T-SQL codes maintaining query standards for the project.

• Created Entity Relationship diagrams.

• Extensively used joins and sub-queries to simplify complex queries involving multiple tables, added columns, triggers and configured IIS and Worked on Index tuning, stored Procedure tuning.

• Involved in optimization and normalization of database and tables.

• Developed stored procedures, triggers and functions and added/changed tables for data extraction and transformation, and data loading (ETL)

• Created new database objects like functions, packages, triggers, indexes and views using T-SQL in development and production environment for SQL Server 2000.

• Designing and building data load procedures, using MS SQL Server

• Involved in analysis and tuning complex queries/stored procedures in SQL server 2000 for faster execution Education and developed Qualifications: database structures

• Master’s in Computer Science (GPA – 3.9, based on 4.0 scale) May 2017

• Certification in PHP (APTECH Computer Education) Jan 2015

• Bachelor’s in Computer Science (GPA - 7.6, based on 10.0 scale) Jun 2014

Contact this candidate