Data Management

Harsha Vardhan Thenral, P A G E * O F *

Harsha Vardhan Thenral LinkedIn Profile

1111s Laflin Street, #612, Chicago, IL 60607 +1-312-***-**** ********@***.***

SUMMARY

Solutions focused Management Information Systems professional with nearly 5.5 years of Systems/Data Analysis and Global Consulting experience in Healthcare and Finance industry. Proven track record in development and management of projects, collaborating effectively with diverse groups of people, leading and executing various projects.

EDUCATION

Loyola University Chicago, Chicago, MBA (Information Systems and Data warehousing), Aug 2016(Exp), GPA: 3.6/4.0

Anna University, India, Chennai, B.E (Electronics and Communication Engineering), Apr 2010, GPA: 3.97/4.0

QUALIFICATIONS

I.Strong in ETL Informatica / Data stage (v7.5, 9.1), Sequencer, Data analysis, Data mapping development who is dependent and strong in analytic, problem solving, logical reasoning, financial, interpersonal skills with 4 years of work experience in business application analysis and project management

II.Exceptional communication skills feeding an ability to understand, interpret the technical and operational needs of businesses at all levels. Keen attention to detail in the identification of potential glitches and threats to performance and security for new applications

III.Proficient in ETL processes dealing with multiple sources such as Flat Files, XML Schemas, DTDs and Excel workbooks and Experience implementing Rapid Marts and developing Slowly Changing Dimension logic including Type 1 and Type2

SKILLS

Platform: Windows XP/2003/98, Windows NT Server, UNIX, Exchange Server, Lotus Notes Server

Technical: ETL(Ascential Data stage 7.5.2, 8.5 (Server and Parallel), Azure, HD Insight ERP (Oracle and PeopleSoft), SQL development, Advanced MS Excel, Word, Access, Visio, Tableau, Putty, Aqua, ERM, Lync,R Studio, Informis

Management Tools: SharePoint, Jira, Report Generation, Competitor Analysis, Customer need assessment, User Interview, Effective presentation, Client Workshops, Qualitative and quantitative data analysis.

Analyst Competencies: Client Needs Fulfilled, Project Development, Quality Control and Code process improvements, Systems Integration and Migration, Documentation Review, training and Supporting Tools, Project Administration

Domain experience: Banking and Financial Services, Manufacturing, Life sciences and healthcare

PROFESSIONAL EXPERIENCE

Evive Health LLC (ETL Analyst) Jun 2016- Jul 2016

I.Developed confidence and sensitivity in working closely with clients to clearly define operational needs and potential solution by Developed many automation and infrastructure systems as solution for many critical problems existed in the project and gained client appreciation for reducing the defect ratio by 89%. Created infrastructure to support the file validation systems of the financial services division by replacing the manual process to automation process by Unix and ETL within short span of three days

II.Enhanced the existing application created before 15 years and replaced the systems with latest change without any change to the existing flow and thus eliminating future failure of the systems

Harsha Vardhan Thenral, P A G E 2 O F 3

Chicago Transit Authority Chicago, USA

Ridership Analytics and Reporting Intern Jan 2016- June 2016

I.Manage the data stage IT jobs in Performance Management Department and to effectively calculate the ridership data and optimize the systems for a particular work week.

II.Responsible for working developing staff operating procedures for new mobile ridership collection system and Analyze rail ridership data to determine the need for rail ridership factors for the systems (Buses and Trains).

III.Planned, organized and calculated the efficient ETL data available on a day-to-day basis using analyzing tools and optimized it.

TATA Consultancy Solutions Chennai, India

Systems Developer ETL/BI – (BOFA Merrill Lynch) Apr 2013– Dec 2013

I.Excelled in business work flow & task flow analysis, AS-IS/TO-BE process mapping, business gap analysis and automation of complex business applications and converted the recommendations into business solutions by consistently coordinating the activities with various business stakeholders/teams

II.Gathered and analyzed customer requirements with SQL query development, framed impeccable user stories and modeled automation tool to validate input file and spearheaded the entire process life cycle in Data stage ETL, Shell Script. Knowledge in all active and passive stages in both Parallel and Server versions

III.Effectively handled ERP package solutions such as Oracle and PeopleSoft for gathering requirements, data analytics and providing implementation of business solutions. Excelled in ETL automation and functional design of complex business applications

Team Lead (Finance and Cards team) Jan 2014- Jul 2014

I.Analyzed the mainframe applications including PHDB & SB from their IMG Guidelines to understand the Source Tables, Source systems, File Formats, Data Types, Column Names, Field Lengths & export frequency improving the work flow efficiency by 10% also conducted Job Validation, Auditing and Syntax checks to evaluate for errors, execution time and bottlenecks and Performed Data Profiling did Column Analysis and Relationship analysis on DB tables to analyze the data integrity

II.Profiled the test data, tested jobs using this data to evaluate the Referential Integrity & Performance Statistics and incorporated the Performance Optimization and Tuning techniques to Push Down operations to DB for Resource-Intensive operations like Sort by, Group By, Lookups, and Joins etc. Performed Debugging utilizing the Breakpoints, Try/Catch, Auto-Correct Load and Auto-recovery mechanisms

Cognizant Technology Solutions Chennai, India

Project Analyst–(Aetna) Jul 2010– Sep 2012

I.Effectively led the base ETL data stage team to coordinate with Reporting team and documented all the vital information and managed the version control tool, thereby reducing code efficiency by 85% and decreasing the defect rate by 80%

II.Proactively led business initiatives in ETL, Agile (Scrum Master) and SDLC life cycle management starting from indentation, analysis, design, build and test phases of emerging business accelerators in financial services and health care domain.

III.Proactively identified function/technical issues across all projects and suggested best coding practice for improving the same. SPOC for Production code support and performance tuning for the entire team and played a pivotal role in project life cycle right from the developing the codes in Various Data stage versions, scheduling and testing the codes in QA environments and finally migrating the code to Production “GOLIVE” and supporting them

Programmer Analyst (Corporate and Pharmacy team) Oct 2012- Mar 2013

I.Examine and Integrate three disparate report DB in SQL and Mainframe for improving efficiency and created an alternative DB using Data stage and Oracle improving the run time & space efficiency by 27%.

Harsha Vardhan Thenral, P A G E 3 O F 3

II.Identified business requirements and analytic needs after collaboration of mined data with SME and compiled and documented and provide analytic support to the process design teams, including definition, planning, and implementation of various initiatives to achieve process design goals and Planned, organized, lead and facilitated cross-functional project teams by successfully managing the relationship within them, while measuring performance against process requirements.

COLLEGE EMPLOYMENT- RA:

Research Assistant, FSBA Department: Loyola University Chicago Chicago Sep 2014 – Jan 2016

Supervisor: Prof. Fady Harfoush (http://tinyurl.com/n6x5qp5)

This Particular role is to assist the FSBA lab with respond to inquiries on tools on FSBA services. Conduct integrity checks of apps and DB and also create test cases to be used in teaching. Provide support in lab usage, on-line information dissemination and also follow-up with internal IT on arising issues.

SKILLS USED:

1.Data Bases: DB2 9.5, Oracle 10g, Sybase, Teradata

2.Scripting Language: JavaScript, HTML

3.ETL Tools: Ascential Data stage 7.5.2, 8.5(Server and Parallel), Training on SAS and Informatica

4.Other Tools: Putty, Aqua, Microsoft Visual Studio 2010, Toad, SQL Plus, MS-Office tool

5.Programming Language: C and basics of C++ and Java

6.Operating System: Windows (XP, Vista, Windows 7)

Contact this candidate