Hemant Barot

Cell: 647-***-****

ad2rtr@r.postjobfree.com

Manager, Business Information and Analytics

SUMMARY OF QUALIFICATION

Over 11 years of IT experience in Database Development, Data Analysis, Design, Development and Support of MS SQL Server 2012/16

Experience with software development life cycle (SDLC), Agile/Scrum and Project Management Methodologies

Self-motivated individual with Good interpersonal, Analytical and Communication skills, Can-Do, Will-Do Attitude, Problem solving, Self-directed, Ability to learn new tools and use them

Ability to prioritize work and meet deadlines in a fast paced, results oriented environment

Ability to troubleshoot, diagnose and resolve complex issues

PROGRAMMING SKILLS

Involved in all phases of the SDLC software Development Life Cycle from analysis, design, development, testing, implementation and maintenance and Production support with timely delivery against aggressive deadline

Strong experience in data warehouse concepts, ETL

Gather business requirements and design improved data warehouse in SQL Server 2008/2012 environment

Automate and Administer ETL processes with SQL Server integration Services and SQL Server Agent

Involved in development, deployment and testing of ETL mappings and transformations

Developed packages, projects in SSIS and handled end to end releases in different environments

Expertise in writing T-SQL queries and complex joins for generating complex stored procedures, views etc.

EDUCATION

Computer Programmer

Sheridan College, Brampton, Ontario 08/2012

Bachelor of Science

Gujarat University, India 06/1995

EMPLOYMENT HISTORY

Manager, Business Information Management 10/2018 – to date

TD Bank, Canada

EPRF (Enterprise Protect Reporting Factory):

Lead the development team for SRR project to provide valuable insight in the form of analysis to understand various data sources

Actively mentored, trained, and supervised new hire database developers with Domain and technical knowledge sharing

Involved in interview process to hired new talent into the team

Helped during business requirements analysis including creating a prototype for new reporting solution and data warehouse architecture ahead of deadline

Documentation of data processing steps, reporting analysis, failures causes and resolutions which will be useful to the developers

Shared knowledge and helped new hires to get them up-to-speed with providing insightful knowledge of Domains/KRIs

Conducted research and gathers information regarding data quality issues and their business impact

Actively participated in Data Governance and Data Quality maintenance

Administered tableau server (created/managed AD groups, permissions etc.)

SRR (Strategic Risk Reporting) Project:

Actively participated and delivered 20M project

Reviewed data flow and provides experience insight and recommendations to improve timeliness and quality of information received

Extensively used SSIS transformation such as lookup, deriver column, data conversion, Aggregate, conditional split, SQL task etc.

Used CTEs, temp tables and effective DDL/DML to facilitate efficient data manipulation and data consistency as well as to support the existing applications

Successfully participated in creating configuration table and SDP (System deployment plan) for deploying SSIS packages across all the environments

Used sub-queries and joins to simplify complex queries involving multiple tables

Data Warehouse Developer 03/2015 – 10/2018

GS1 Canada, Toronto, Canada

Maintained and supported the SQL Server Database environments

Created and maintained different database environments for DEV, UAT and PROD to support development

Expert in transforming complex business logic into database design and maintaining it by using SQL tools like stored procedure, user define functions, views, T-SQL scripting and jobs

Worked with system administrator to keep the database and reporting service environments up to date and well maintained

Performed quality control on web pages to ensure functionality works and the proper written content and design is used

Investigated data and reporting anomalies, provided support for maintaining and modifying databases and reporting

Coordinated with Lead BA on detailed business requirements, identifying, planning, tracking and resolving business issues

Designed and created user friendly Dashboards for various teams and stakeholders using Tableau

Database Developer 01/2013 – 03/2015

Claimsecure Inc, Sudbury, Canada

Designed, built and implemented new report formats on customized basis for internal departments as well as for clients

Assisted with gathering and refining specifications and requirements based on business and technical needs

Resolved and supported production environment issues related to report access, report execution, scheduling and data source

Analyze data and design reports according to business logic

Designed, built and deployed actionable reporting solutions while following established standards

Administrative and Production support for various applications in all environments

Developer 09/2012 – 12/2012

CIBC, Toronto, Canada

Mortgages, Lending, Insurance and Deposit Products Technology

Supported performance testing of Web-based applications

Worked in Solaris Unix based Environment running Oracle Web Logic WLP 10.3.0 along with J2EE environment

Managed configuration and environment using MKS and Web Logic Portal and WLS 10.3.

Application Developer 01/2012 - 04/2012

VPI Inc, Toronto, Canada

Involved in complete Life Cycle including Analysis, Design, Development and Testing

Worked on design, code, implement and support SQL Server databases, generate reports, support internal development and application

Administrative and Production support for various applications in all environments

Created and maintained various databases for Production, Development and Testing using SQL Server 2008

Interact directly with the business users in gathering requirements

References: Available upon request

Contact this candidate