PRASHANTH KRISHNAKUMAR

Database/ETL Analyst ac7xww@r.postjobfree.com +1-815-***-****

SUMMARY

• Proficient Database/ETL Developer with over 2.5 years of experience in Data Warehousing domain and worked on multiple end-end Database/ETL development and Production Support projects TECHNICAL SKILLS

• T-SQL (Microsoft Certified Professional ‘Querying Data with TSQL 70-761’), tSQLt, SQL Server 2016, Oracle, MySQL, Informatica Power Center, DataStage v9.1(Certified), SSRS, PowerBI, C, Unix, PL/SQL, Visual Studio 2017, Team Foundation Server, Power Pivot, Red Gate Sql Tools EXPERIENCE

Aztec Technologies - Chicago, IL

Database Developer Intern

Feb 2018 to Present

• Design, develop and maintain commercial software product database, applying principles and knowledge of computer science and engineering

• Working extensively with SQL Server 2014, 2016 in the areas of database design, development and optimization.

• Proficient in creating optimized Stored Procedures, Views, Functions

• Performance tune slow running queries in SQL Server by analyzing the query plans

• Involved in writing unit test cases for the existing stored procedures using tSQLt framework

• Involved heavily in performance tuning and recommended various options such as Index tuning and query optimization techniques to fine tune the application and improve the application throughput.

• Create SSRS reports as per requirements

• Work closely with team members to develop and maintain database artifacts, identifying areas for database schema and coding improvement

Sri Lakshmi System Products – Chennai, India

ETL/Database Analyst

June 2013 to June 2015

• Responsible for maintaining data integrity in the company’s database

• Designed and developed the ETL processes in Informatica PowerCenter to load and cleanse data from SQL Server, Oracle 10g, Flat Files, XML Files and Excel files to target database.

• Implemented various transformations such as Source Qualifier, Expression, Filter, Router, Update strategy, Sorter, Lookup, Aggregator, Joiner and Sequence Generator in the mappings

• Have created CA7 jobs to schedule workflows in Informatica

• Wrote perl/shell scripts to trigger Informatica Workflows

• Enhanced ETL algorithms, Data extraction processes via automation using Shell Scripting

• Maintained/processed Master data for my client ‘Anglo American Corp’ in SQL Server

• Designed ER Diagrams in SQL Server using Erwin tool based on client requirements

• Created jobs using Datastage v9.1 which processed and cleansed data

• Ensured data quality in the inbound/outbound transmissions in the SQL Server EDUCATION

Northern Illinois University

MS in Management Information Systems (August 2015-December 2017) CEG, Anna University

BE in Computer Science Engineering (June 2008- May 2013)

Contact this candidate