Kruti Thakkar

ad4w0p@r.postjobfree.com

224-***-****

Summary:

•Solid hands on experience of using MS SQL Server for Database Development and Administration.

•Skilled in Logical and Physical Database design and development, Data Conversion, Normalization, ER modeling, Dimensional Modeling, Relational Model, Object-Oriented Database Model and Star Schema.

•Demonstrated expertise utilizing ETL tools, including SQL Server Integration Services (SSIS), Data Transformation Services (DTS), Pentaho kettle, DataStage and ETL package design

•Expertise in using all BI tools including SSIS (Integration), SSAS (Analyses/Data warehouse) and SSRS (Reporting).

•Worked with all phases of Database Warehouse Development Lifecycle including Project Planning, Requirements Analysis, Logical Design, Physical Design, Data Staging, Data Analysis, implementation and testing software applications.

•Outstanding interpersonal communication, problem solving, documentation and analytical skills.

Technical Skills:

OS

Microsoft Windows XP, Windows 7, Windows Vista, Linux and UNIX

Database

SAP, SQL 2008, 2014 & 2017, DB2, Teradata-SQL, Progress, MS Access

Tools & Apps

Excel 2016, Visual Studio 2010 & 2015, Pentaho (ETL), MS-Project, Visio, Power BI, Dynamics CRM, Azure SQL, Azure SQL DW.

ETL

SQL Server Integration Services, SSDT, DataStage, Pentaho kettle

OLAP/

Reporting

SQL Server Analysis Services, SQL Server Reporting Services

Education:

DePaul University Chicago, IL

Master of Science in Information Systems

Concentration of Database Administration June-2018

DeVry University Addison, IL

Bachelor of Science in Business Administration

Concentration - Business Information System June 2007

Certification:

SQL SERVER Business Intelligence Program (SSIS, SSAS, SSRS)

BIG DATA AND NoSQL PROGRAM

Experience:

VigiLanz

BI Analyst 12/2022-08/2023

•Support operations and conducts data analytics projects to provide information and insights to stakeholders for decision-making or solution development

•Implement data standards and deploys automation tools to extract, synthesize, and validate data from different sources and transform data into usable metrics

•Construct data sets, monitors data quality, troubleshoots and resolves database issues to ensure data integrity

•Utilize scripting and querying tools like Python, R or SQL, data visualization/BI tools, statistical methods, and data modeling to produce reports, data files, and dashboards

•Collaborate with stakeholders to understand their needs, objectives, and requirements

•Use software and scripting, typically including SQL, to generate metrics and reports and synthesize them into actionable recommendations

•Responsible for management reporting, KPIs, or data QA

•Provide support to research teams or management by collecting and analyzing data and reporting results based on the needs of end users

•Collaborate with various function teams such as marketing, research, and IT to achieve business results

•Design and build visualizations and dashboards in collaboration with clinical teams to support product enhancement and development

•Develop ad-hoc reports and analysis to support operational and financial needs

•Assess trends and insight using multiple data sets and large amounts of data

•Analyze and determines project resource requirements and data needs

•Create and maintains documentation of processes

•Liaison with IT, Clinical and other internal teams for project requirements, support and data needs

Beeline

Business Systems Analyst III / Data Scientist

Client: - ComEd 02/2022- 06/2022

•Understand and perform of data design and architecture.

•Work with large volumes of data in corporate environments.

•Develop reports and dashboards within Power BI for corporate decisions.

•Facilitate Advanced Meter Infrastructure (AMI) Operations Team by pulling meter reading and customer usage information.

•Perform Data Analyses for AMI Meter usage after gathering information from SQL Server, Excel and internal databases.

•Use strong technical SQL expertise to gather meter reading and customer usage information for reporting purposes. Environment: SQL, EXCEL, G-SUITE, Power BI

Robert Half

Sr. Database Analyst/Developer 06/2021-11/2021

Client: - SEIU Local 1

•Lead project involving LIST MANAGEMENT.

•Clean up and automate technology and manual processes which govern their seniority lists. Seniority lists have information about members that are part of the Union.

•Manage people (via e-mail), lists, processes which have been defined and to define and implement technology and processes.

•Gathered, Analyze and Organize important information of employers in order to process Seniority Lists.

•Review inbound data and execute processes to scrub it by looking in the database and on the network for supporting documentation and files

•Perform ETL process to load Seniority List into UnionWare (the MS-SQL database).

•Troubleshoot errors as they come up while processing Seniority Lists.

•Implemented SSIS Integration package to automate Seniority List process.

Environment: SQL, EXCEL, G-SUITE, MS Office (UnionWare MS-SQL database), Excel, Word.

Healthware Systems

Jr SQL Database Developer 02/2021-04/2021

•Help write and optimize in-application SQL statements.

•Ensure performance, security, and availability of databases.

•Prepare documentation and specifications.

•Handle common database procedures such as upgrade, backup, recovery, migration, etc.

•Write TSQL scripts and objects such as stored procedures, user-defined functions, views, indexes per business requirements.

•Create ETL SSIS packages to migrate data from OLTP sources to OLAP destinations through available tasks and transformations in SSIS.

•Design and create user-interactive reports in SSRS, Power BI, and Tableau.

•Collaborate with other team members and stakeholders.

Environment: SQL-2018, Power-BI, Excel, SSIS, SSRS, Tableau

Robert Half

Data Analyst/Developer 02/2018-12/2018

Client: - Smithfield Foods

•Build daily fill rate report in Excel using complex formulas/functions

•Create SQL SSIS package to load fill rate report results into Smithfield databases.

•Generate and publish reports on Power BI and SSRS for stakeholders to review daily and weekly profit, loss and revenue.

•Execute weekly and monthly SQL ETL jobs in SAP.

•Import SAP jobs results into targeted databases by creating SSIS packages.

•Generate and Document Data Migration project requirements. Prepared in-depth database design document to gain proper understanding of databases and database objects.

•Gather requirements and design of data warehouse and data mart entities.

•Successfully completed data migration project between legacy and One SAP systems.

Environment: SAP, SQL-2014, Power-BI, Excel, SSIS, SSRS

Robert Half: - Sugar Grove, IL

Sr. Database Analyst 06/2016-08/2016

Client: - Ispera Government and Network Systems

•Managed Sql 2012/2014 and progress database.

•Created SSIS package to extract data from SQL and Progress Database.

•Wrote complex SQL DDL & DML queries to gather required information.

•Performed ETL jobs, data mapping, analysis, validation, transformation and cleansing.

•Crated Pivot Tables and Charts by using advanced filters, formulas to achieve analytical goals in Excel.

•Prepared SSRS status reports and generated dashboards to present real time information to the managers and decision makers.

Environment: Sql 2012/2014, progress database ODBC, i-dashboard, Excel2016, SSIS, SSRS

Experian: Schaumburg, IL

Sr. Database Analyst 04/2013-1/2014

•Monitor the quality and timeliness of all deliverables as it pertains to the update process.

•Generate m-load scripts to load data into Teradata-SQL on UNIX platform.

•Create BTEQ, Fast export, multiload, fast load scripts.

•Created ETL transformations using DataStage to load clients’ relevant information to Experian Databases.

•Leverage knowledge of different technical platforms such as Unix, Teradata, Data Stage.

•Reviewed, wrote and updated Business Requirements document, Software Requirements Document, Detailed Design Document, Data Dictionary, Data Model and Process flow.

Environment: UNIX, Teradata, DataStage (ETL tool), ControlM (Scheduler), Service Manager, Mainframe, WinSCP, Edit Pad Lite, Microsoft Office

DISYS: Oakbrook Terrace, IL

Database Analyst 08/2012-12/2012

Client: Sears Holdings Corp: Hoffman Estates, IL

•Perform data analysis and mapping to validate accuracy of stored data.

•Review requirements, design documents, develop and Test cases

•Create and maintain DB2 database, users, tables, views, and macros.

•Conduct code reviews and write, analyze and optimize Db2 queries (DDL and DML) to improve performance.

•Design and Implement ETL solutions in Pentaho (integration tool).

•Wrote transformations to automate the process of loading data into DB2 from Flat file, CSV, MS Excel and Access.

•Created ETL jobs using Pentaho Data Integration to handle the maintenance and processing of data.

•Generated SSIS Packages, SQL JOBS, and scripting to automate daily processing.

•Utilized statistical methods within data analysis to produce actionable reports.

•Developed and published reports using SSRS and Business Objects to present performance metrics. Environment: DB2, SQL, UNIX, Pentaho kettle (ETL tool), MS Excel, Access

Motorola Solutions: Schaumburg, IL Database Developer. 08/2007 06/2012

•Used relational database design process by gathering requirements and performing data analyses.

•Organized and created tables, specify the primary key, relationships among tables and Normalize the design.

•Create and modify database objects such as Tables, Views, Stored Procedures and Index. Maintain SQL Server Database integrity and security.

•Create Ad hoc reports and dashboards to provide on demand and scheduled updates to vendors, team members and upper management.

Environment: Oracle, SQL 2005/2008, MS Excel, Access

Contact this candidate