HIRAL THAKKAR

ETL DATABASE DEVELOPER/ FULL-STACK SOFTWARE ENGINEER

adybrw@r.postjobfree.com

217-***-****

Cumming, GA

Profile

Solutions-oriented and self-motivated with notable success directing a broad range of IT initiatives while participating in critical designing, analysis, and implementation of IT solutions in direct support of business objectives.

Experience of full life cycle of software development (SDLC) including requirements definition, design, database architecture, coding, testing, implementation, and support.

8+ years of experience in MS SQL Server, Object Oriented Programming

4+ years of experience in DotNet, J2EE, Core Java and WebLogic server.

Adept at developing procedures, project and system documentation, technical and business specifications.

Grip on Relational Database Architecture, T-SQL and complex SQL scripts.

Proactive approach towards finding and fixing potential issues.

Strong leader with the ability to coordinate and direct all phases of project-based efforts while managing, motivating, and leading project teams to ensure solutions are delivered on time.

The combination of Business Management and IT education aids me to provide focused IT solutions while interacting with end clients.

Interviewed potential candidates for the team.

Good knowledge of Cloud technology AWS.

Worked with many ETLs and process automation, reporting and analytical services including SQL Server Data Tools like SSAS, SSRS and SSIS and Power BI.

Education/Certification

Master of Computer Applications, GLSICT - Gujarat University (India), 2003. Bachelor of Business Administration (Finance & Marketing), GLSIBA - Gujarat University (India), 2000. Employment History Experience 9+ Years

Disruptive Intelligence Feb 2020 – Jun 2023

ETL / SQL Developer Atlanta, Georgia

Designed and developed solutions regarding ETL with usage of integration services SSIS and VB.Net to create packages to automate the process for better performance.

Develop and maintain consistency and document the technical specifications of Reporting system and its discrepancies using complex SQL queries. Quarterly execution of the same using VB.net for Visual Studio 2012 and SQL server 2014.

• Create complex cubes in SSAS from SQL Server 2014 for data warehousing of OLAP application.

Generated reports using SSRS in SSDT 2014 and deploying the same using C#.NET Visual Studio 2012.

Responsible for maintaining and creating tables, procedures, constraints, views, triggers, indexing and SQL queries using various DDL and DML commands in T-SQL for SQL Server 2016.

• Test results to confirm data accuracy and got rid of ambiguous and unneeded data. Resolved major referential integrity issues and remapping the same.

• Experience with Cloud platform AWS. Hands on EC2, S3, RDS and integration using AWS CodePipeline and AWS CodeBuild.

Experience creating visualizations, reports, dashboards and KPI scorecards using Power BI. The Consultants Consortium. Jun 2014 – Dec 2017

Full - Stack Software Developer Indianapolis, Indiana

Create procedures, views and SQL queries for creating reports using SSRS (reporting service) for Visual Studio 2012 using ASP.NET for the Child Care System of Indiana.

Creating SSIS packages in MS SQL Server Data Tools 2012 to automate the processes for the upgrade of Child Care system of Indiana.

Query Performance Tuning.

• Write complex T-SQL Queries to perform data validation and to ensure it fulfills business requirements.

Extensive usage of TFS (Team Foundation Server) for version control. The Consultants Consortium. Dec 2006 – Dec 2012

Full-Stack Software Developer Indianapolis, Indiana

Maintenance, Monitoring and Reporting for Child Care System for the State of Indiana using ASP.Net and Ms SQL Server Reporting Services with an extensive usage of SQL and T-SQL.

Maintenance/upgradation of a Web based application while creating User interface for Child Care and Development Fund for the Indiana Bureau of Child Care (BCC). The application facilitates the Intake Agents all over the State of Indiana with detailed information regarding the applicants, Facility Providers, recipients, reporting the state government and the Contract Centers using SQL Server 2000/2005, Net Beans 5.0 IDE for Java/ J2EE, WebLogic Server 9.1, JSP and java scripts, BIDS 2005 for SSIS

Process Automation by developing and configuring SSIS packages with VB.Net.

Creation of physical Database objects and logical data models.

Performance tuning of existing Databases.

Maintaining and Optimizing Scheduled Jobs in SQL Server 2000 and 2005.

Responsible for Implementation plans, bug fixing and emergency fixes in production.

Code Migration and Data Migration across different environments using Redgate tool for version control and SQL Server Code management.

Creating charters for requirement approvals, release plans and emergency release for deployment.

Create back up plans to avoid risks in case of uncertainty of undoing the implementation.

Worked on WSDL and SOAP web services for Child Care web applikcati8on.

Normalized Database Design for OLTP systems.

Upgrading of SQL Server 2000 to SQL Server 2005.

Interact with the End Clients for training purposes and create training documentation for the same.

Testing, debugging, and troubleshooting all kinds of database and software related issues.

Create Design and Architectural diagrams (ERD, DFD, PFD) with a clear understanding of the system.

Worked on integrating the two systems (ICES & CCDF) through web service using SOAP and XML (Rid match process).

Hands on key stores using key tool while working with installing certificate for the web service into WebLogic 9.1.

Encryption of Data in SQL server 2005 Database to maintain security.

Enhancements, Technical support, Documentations and Quality Control Check on errors and Data management.

Software Engineer / Software Maintenance Indianapolis, Indiana

Responsible for developing a Child Care Administrative Tracking System (CCATS) which is a Web based application for the Maryland State Department of Education (MSDE) using Eclipse 3.2.2 IDE for Java/ J2EE, XML 1.0 and DB2 version 8.2.

JAXA INFOTECH PVT LTD. June 2004 - Dec 2005

Software Developer Ahmedabad, India

Maintained Data Security and Memory Usage Optimization of Medical Reports of large number of patients using VB.NET and Ms SQL Server 2000.

Responsible for efficient Development of user interface prototypes, Analysis, Design and Testing of the File Distribution System using Client/Server Architecture.

Designed and implemented the HR Management application using C#.NET.

Maintained a system for Quality Assurance of Files in C#.NET.

Successfully consulted a global client in Designing and creating a Photo Editing application with online storage collaboration and a built-in pyramid style incentive structure using File system in C#.NET. SYPHERTEC Aug 2003 - May 2004

Junior Software Developer Ahmedabad, India

Analyzed, Designed and Implemented a Class Scheduler with an exporting capability. Prepared specification documents, plans, and proposals to present ideas within and across functional areas.

Lead a team of 5 developers to ensure successful testing, communication and implementation of the Education System for Alpha education group.

(Tools: Vb 6.0, Crystal reports 7.0, Ms Excel 2000; Database: Ms Access 2000) Other Achievements

Projects Implemented

Gathered requirements, analyzed strengths and weaknesses, identified alternative solutions, and worked with teams to realize and develop Railway Ticket Booking System in C++ using OOP concepts

Implementation of Library Management System of St. Xavier’s Loyola School (VB 6.0 & Oracle 8.0)

Developed a project on 3D graphics of a Bowling Game using VRML

Submitted Change proposals for system enhancements, providing cost/benefit, impact, alternative and prioritization Analysis and Designing of Railway System and Leave Management System as a team

Implemented a POP Mail Client / Server & FTP Protocol in Java as a team project

Collaborated in the development of a 3-tier application on Enterprise Wide Information System at Net Vision for Vacunair Pvt. Ltd. (VB 6.0 & MS Sql Server) as a part time trainee

Analyzed, Designed and Developed in team a Web Enabled Services Management Application for Hospitals developed at Bitscape Solutions (VB.Net & MS SQL Server 2000) as a full-time trainee. It incorporates online medical help, Inventory status Reporting, User Management, Resource Inventory Management and much more.

Technical Seminars on

Deductive Database, Screen Saver and Registry, Windows NT/2000 Operating System, ISO 9001, Oracle 9i, Real Time Protocol & Control Protocol, Hacking & Hack Proofing, Fleet Management using GPS. Program Expertise & Skill Set

Operating System : Windows, Dos, Unix/Linux

Programming Language : C/C++, Java, COBOL, PL/SQL, ASP, VB Software Packages : Microsoft Office Suite, Ms Project 2000 Designing Language : UML for Use cases

R-DBMS : Ms SQL Server 2000/2005/2012/2014, MS Access, Oracle 8.0, DB2 8.2 Front-end Tools : Visual Basic 6, VC++, D2k, C#.NET, ASP.NET, VB.NET, Net Beans 5.0, Eclipse 3.2.2, Ms Visual Studio 2012, SSIS 2005 & 2012 Testing Methods : Unit, Integration, Regression

Internet Tools : HTML, Front page

Designing Tools : Ms Visio 2000, Erwin

Code Management Tools : Microsoft Visual Source Safe 6.0, CVS, Redgate, TFS Supporting Tools : JIRA, TFS, Redgate (SQL Code Comparison software) Reporting Tools : SSRS, Crystal Report 7.0, Reporting Services in MS Visual Studio 2012 Analytical Tools : SSAS

Others : Data Structures, Object Oriented Analysis and Design, System Analysis & Design, Database Designing, ER Model, Socket Programming, Programming on Stacks, Queue, Linked List, Tree, Encryption/Decryption Techniques for Data Security, CORBA, CGI, RMI, Java Servlets, Networking, VRML, REST

& SOAP web services, Parallel Processing Programs in UNIX, FTP, SLDC, OLAP, OLTP, Quality control & Testing techniques, DTS packages, SSIS packages, WSDL.

SKILLS EXPERIENCE

(YEARS)

SELF-RATING

(on a scale of 10)

SQL/T-SQL 8+ 8

SSAS 1+ 6

SSIS 5+ 8

SSRS 2+ 8

C# 1+ 6

ASP.NET/ VB.NET 3+ 8

Java/ J2EE 4+ 7

References available upon request.

Contact this candidate