Nikita Patel

adpjsb@r.postjobfree.com 917-***-****

PROFESSIONAL SUMMARY:

• Highly motivated technical professional with 5+ years of success driving full lifecycle design, development, and enhancement of database, data warehousing, and business intelligence solutions that heighten business performance.

• Well-qualified with background in SQL Server 2016/2008r2 Development (T-SQL, SSIS, SSRS) under OLTP and OLAP environments.

• Solid knowledge and expertise in Agile/Scrum methodologies. Adept at developing and supporting analysis solutions, data transformations, and reports. In-depth understanding of all stages of the software development life cycle (SDLC).

• Excessive experience in creating tables, views, user defined functions, cursors, derived tables, common table expressions (CTEs), complex Stored Procedures, ad-hoc SQL by utilizing Dynamic SQL & SQLCMD and Triggers to facilitate efficient data manipulation and data consistency.

• Experience in Extract Transform Load (ETL) between Homogeneous and Heterogeneous System as well as creating reports using SSRS, Power BI, and Excel Spreadsheet.

• Maintain positive communications and working relationships at all business levels.

• Experience in White Box, Black Box and Unit Testing in Various Modules in Database level and Application Level. TECHNICAL SKILLS:

Functional Areas: MS SQL, Oracle EBS, ERP, ETL, BI-DW, Order Management, Capital Market, Financial Management Methodologies/

Techniques/Framework: Agile, Scrum, Hybrid, Waterfall, SDLC Integration/Reporting

Tools:

SSIS, SSRS, Business Intelligence Development Studio, SQL Server Data Tool, Excel Power Pivot, Power BI, DTS, Import Export Utilities, Bulk Insert, SharePoint, MSOffice Analysis/Optimization

Tools: SSAS, Excel, SQL Server Profiler, Database Tuning Advisor, Execution Plan, Query Analyzer Databases / DB Tools: MS SQL Server 2016/2012/2008/R2, Oracle 10/11g, SQL Dev, TOAD, MSFT Access, SQL Server Management Studio, My SQL

Operating Systems: MSFT Windows, Windows 7/2008/2003/XP/2000/NT/98, Android, Apple iOS, Mac Programming

Languages: T-SQL, PL/SQL, Java, XML, MDX, HTML, XML, C, C++, Objective C Desktop / Other Tools: TFS-Team Foundation Server, Visio, SharePoint, Confluence, JIRA, Red Gate, Erwin, MS Visio, GITHUB, WAMP, AAMP

PROFESSIONAL EXPERIENCE:

BI Developer / Data Analyst

Rahi Systems Inc. April 2019-Present

The scope of the project was to integrate data and generate reports which provide a business 360 view into Policy, Billing, Claim, Quote and Agency data.

Technical Highlights:

• Developed and modified SSRS reports according to functional requirements provided by business users to provide them with the data with ease so that they can carry out their responsibilities efficiently.

• Researched to figure out a way to use Microsoft Excel – Pivot tables.

• Wrote complex SQL to validate data against different kinds of reports. Achievements:

• Involved in the proposed project spanned across teams to build Proof of Concept (POC).

• Wrote dynamic stored procedure, moving data between servers despite each table consisting of data with a varied number of columns.

• Attended regular meetings with business leaders and BI units to understand the requirements and gain insights about the pivotal role that business intelligence delivery plays into end-to-end business processes. Environment:

MS SQL Server 2016/2008r2, SQL Server Data Tool, Oracle 11g, PL/SQL, T-SQL, SQL Server Integration Service, SSAS, SSRS, Windows Server 2008/12, Windows 7, MS Excel 2013, BIDS, Bit Bucket, Power BI. SQL Developer July 17 – April 19

Geographic Solutions

Geographic Solutions specializes in developing and maintaining online SaaS solutions for the workforce development, economic development, education, corrections, human services, and unemployment insurance industries. Technical Highlights:

• Delivered project on time and within budget while driving substantial improvements in reporting efficiency, accuracy, and quality.

• Partnered with project lead and business users to define business processes, gather and document project requirements, and translating these into functional & non-functional specifications.

• Developed lightning fast SSIS packages to extract, transform and load data from heterogeneous systems into enterprise Data Warehouse

• Designed and developed dashboards for forensic level information that give stakeholders the ability to gain quick insights to make more informed business decisions.

• Wrote sleek SSRS reports for operations & other business units and create subscriptions to deliver information to business users at various levels in the organization

• Designed, coded, tested and debugged custom queries using Microsoft T-SQL and SQL Reporting Services.

• Created Views to reduce complexity of end users. Created and modified existing reports/processes to achieve new business requirements.

Achievements:

• Boosted performance by designing clustered and non-clustered indexes through T-SQL optimization using SQL profiler.

• Designed SCD1, SCD2, Conformed, Bridge and Fact (non-additive, semi, additive) tables with reporting metrics.

• Documented FRDs, TRDs, RUNBOOKs for ETL workflow and object definition and Data dictionary for the ease of Production Support team.

Key Challenge:

• Improved performance 75% on 15-18 tables with over 150M records within each table by working closely with Sr. DBA, successfully implemented table partition to manage large-scale performance issues. Environment: MS SQL Server 2016/2008r2, SQL Server Data Tool, Oracle 11g, PL/SQL, T-SQL, SQL Server Integration Service, SSAS, Windows Server 2008/12, Windows 7, MS Visio, Toad, MS Excel 2013, BIDS, Bit Bucket, Power BI. Teaching Assistant, Database Systems April 15 – June 16 Northwestern Polytechnic University

• Assisted in managing a course with a professor for 50 students with Object Oriented Programming with Java and Database systems by solving queries, grading practical assignments and projects. ACADEMIC PROJECTS June 09 – June 13

InterConnect-Social Application for Android Phones: (Java, TSQL, MS-Excel)

• Designed and Implemented Inter connect-Social application (Screen)

• Designed Database for Application using Server 2014 Developer Edition Hotel Management System: (Java, MS-Excel, GITHUB)

• Developed desktop application for managing records of customers in hotels.

• Tracked record for all employee customers in hotel requirements. Abrupt Motion Tracking Via Intensively Adaptive Markov Chain Monte C: (Java, MS SQL Server, SSDT)

• Developed desktop-based java program to handle the local trap problem.

• Designed database in 3rd normal form using SQL Server.

• Performed DDL and DML operations to create and alter objects and data respectively.

• Developed SSIS package to import data from CSV, TXT and Excel files. Retail Store: (JavaScript, WAMP server, XML)

• Retail shops provide customers to buy their products.

• Maintain login information for user and admin.

• Keep record of inventory and availability of items accordingly. Also, logged wish list of users upon their login. Chat Application: (Java, WAMP server)

• Designed a social networking website similar to Facebook and Orkut.

• Provided features like uploading his/her status, profile pictures, and some basic settings.

•

EDUCATION:

Master of Science, Computer Science (2016 / 3.61GPA), Northwestern Polytechnic University CA, USA Bachelor of Technology, Computer Engineering (2013 / 3.4 GPA), North Maharashtra University, India COURSES:

1. Software Engineering Advanced Database System

2. Database System Architecture

3. Principle of Operating System

4. Theory of Computation

5. Foundation of Computer Science

6. Principle of Computer Networks

7. Advanced topics of Algorithms

8. Advanced topics: Software foundations

Contact this candidate