Hemant Sainathan

**** ***** **, ***********, **, L5E 3E1

Mobile: 647-***-****, Home: 905-***-****

Email: acr01v@r.postjobfree.com

SUMMARY

A multifaceted professional with 5 years of cumulative experience in Information Technology and Customer Service industry. Experienced in implementing project management & business methodologies in start-up projects. Have extensive experience in testing Data Warehouse, Database (ETL & BI), Mainframe, Web and Client-Server Systems applications for Banking and Finance domain. Received commendation for creative and critical thinking based initiatives. Possess strong Analytical, leadership, negotiation and communication skills.

Major Strength : SQL, UNIX and solid understanding of Data warehousing concepts, Team player, Research, Communication & Customer Relations.

TECHNICAL SKILLS

Methodologies

Waterfall, V-model

Test Management Tool

ALM 11.0, Quality Center 9.0,

Tools/Utilities

SSIS, SQL developer, SQL Plus, TOAD

Database

Oracle 11g, DB2, Microsoft SQL Server

Operating Systems

Windows 2000 professional/NT, Windows 7, UNIX

EDUCATION & TRAINING

Bachelors in Science – Computer Science

Laurentian University (2014)

Completed Foundations in Business Analysis & Project Management

University of Toronto

Currently Pursuing via PMI

CAPM (Certified Associate in Project Management)

PBA (Professional Business Analyst)

EMPLOYMENT EXPERIENCE

ETL Tester Feb 2015 – Present

MetaMast Inc, Mississauga, ON

Oracle, UNIX, SSIS

Preparation of test scripts include validations for Data Accuracy, Data content, Data Completeness, Data Aggregation, Data cleansing and Complex transformations

Writing complex SQL queries using Case Logic, Intersect, Minus, Sub Queries, Inline Views, and Union in Oracle

Experience in Business Intelligence Report testing using Business Objects XI

Troubleshooting, resolving and escalating data related issues and validating data to improve data quality

Ability to schedule and execute daily pre prod batch during SIT

Participating in meetings with Finance IT team, on daily incident review meeting, which involves stakeholders from various teams

Co-ordinate with the developers and Change Management to promote the code in Pre & Prod environment.

Experienced in writing SQL loader scripts to load data from Mainframes to Oracle DB

Support UAT testing resolving the queries with Test data, Test conditions, Incidents identified & Requesting for ad-hoc job runs

Performed end-to-end testing by cross verifying the data entered on front end and the files received from the 3rd party system

Attend the daily conference call to update the testing progress and discuss any roadblocks

Prepare weekly status report presentation to be discussed between offshore/onshore management team

Prepare the Test completion report with all the test evidence and business sign off details

Analyzed and evaluated the requirement specification documents designed by business users

Translated the business user requirements into IT requirement specification document

Reviewed the IT requirement specification doc with the technical architecture to obtain sign off

Application Support Analyst Apr 2011 – Oct 2013

Teletech Inc, Sudbury, ON

Preparing Test cases and executing Test Cases

Analyzing Test Cases Execution Results and compare expected Result.

Raise defect in HP Quality Centre

Testing data form source file to Landing, Staging and Target Table.

Check Final data loaded in target tables

Check functionality of the application

Write Layout test cases and executed in HP(Quality Centre)

Reviewed Plan and Forecast report write test cases

Prepare test plan, test cases and test data

Collaborate with cross functional teams to maintain efficiency, consistency and achieve successful implementation of application

Analyze and review enhancements for compatibility, adhere to operating guidelines and perform integration testing.

Analyze system capacity and modify procedures to solve interface problems.

Monitor application for compliance to IT standards and policies.

CAPSTONE PROJECT & THESIS PAPER

Project Manager, Foundations of Project Management,

Infrastructure & Service Upgrade, Ministry of Education Ontario

University of Toronto

We created the Project charter, Requirements Documentation, Project scheduling, Cost analysis, Vendor analysis, Human resources management, Schedule management

(milestones and deliverable)

Proposed a project that covers 25 offices for a budget of $500,000 and offered 1 month additional maintenance & support and stop-gap mitigation process.

Team Lead, Foundations of Business Analysis,

Reduce Patient Wait times, Ministry of Health Ontario

University of Toronto

We planned a business proposal to address the excessive patient wait times at hospital emergency centres by performing Gap analysis, Swot analysis, Traceability Matrix, BRD, SRS and used various other tools and techniques.

We created an optimal Standard operating procedure, Real-time data maintenance and process flow.

Reduced Wait-times by 30% and projected increase in efficiency.

Team Lead- Human Computer Interaction, Sept 2013 – Dec 2013

Personalized Virtual Assistance, Project DAVE,

Laurentian University

NACHOS Operating System, Jan 2013 – May 2013

Building a thread system & Multiprogramming

Laurentian University

Thesis Paper : Unobtrusive measures of collecting data ( HCI)

Evolution of Computing In Space (Systems Organization)

OTHER WORK EXPERIENCE

IT Consultant (Volunteer- online), Cync-Up LLC, Apr 2011 – Oct 2013

Web Promotions Consultant, SRO lounge May 2010 – Jun 2012

Front Desk Services, Best-Western Group, Feb 2010 – Dec 2010

Contact this candidate