Sql Server Data

VISHAL KUMAR C: 951-***-**** E: ************@*****.*** LinkedIn: linkedin.com/in/vishal--kumar

DATABASE/ETL DEVELOPER

A performance oriented Database/ETL Developer experienced in design, development, implementation and maintenance of various Databases in various domains like Banking, Healthcare, Telecom, Capital Market, and Marketing Solutions, and E-Commerce. Proven ability and expertise in processing big data, performance tuning, automation of data processing, as well as, developing and automating ETL processes. Developed competencies in:

Relational Database Management and Data warehouse systems

Data analysis, logical, physical and dimensional data modeling techniques

Developing ETL processes in Informatica, Talend and PL/SQL.

Developing Database Applications with various software development techniques such as; SDLC, Waterfall, Agile (SCRUM, Kanban)

TECHNICAL SKILLS

Languages: PL/SQL, SQL, PERL, JAVA, UNIX, C, C++, C #, VB.NET, HTML

Databases: Oracle, MySQL, PostgreSQL, MongoDB, Vertica, SQL Server & MS-Access

ETL Tools: Informatica, Talend

Data Modeling: Physical, Logical, Relational and Dimensional Modeling

Operating Systems: Unix, Sun Solaris, HP-UX, Windows

Scripting: Shell Scripting & PERL scripting

Reporting tools: Crystal Reports, Oracle Reports

File Transfer tools: Filezilla, Winscp

Job Scheduler tools: Automic, Control M

Tools/Utilities: TOAD, Putty, SQL Developer, Eclipse, Aqua Data Studio, SQL*LOADER, IBM rational clear quest, BMC Remedy, ERWIN, Tableau

PROFESSIONAL EXPERIENCE

HBC Digital – New York, NY July 2016 – Present

Database Developer

Develop various SQL scripts to create various database objects and to implement complex business logic.

Develop various Shell scripts to automate and process complex business logic.

Optimize the SQL queries by using explain plan, partitions and indexes.

Analyse the data requirements for the customized reports, identify the mappings and generate reports by creating various Stored Procedures, Functions and Packages.

Develop and automate ETL processes using Informatica & PL/SQL.

Work on analysis, design, development, implementation and support of the enterprise data warehouse.

Scheduled and monitored jobs in Automic.

Environment: Oracle 11g R2, SQL Developer, Shell Script, SQL Loader, Informatica, MongoDB, Automic, JIRA

INFOGROUP -- Burlington, MA February 2016 – June 2016

Database Developer

Developed and automated ETL processes using Talend ETL tool.

Processed huge sets of data using set based approach for faster execution.

Extensively used Partitions & Hints and created materialized views for faster data retrieval.

Used advanced features of Oracle in the code developed.

Developed various Shell scripts & SQL scripts to automate data processing.

Environment: Oracle 10g/11g, Windows, PL/SQL, SQL Loader, Batch Scripting, PL/SQL Developer, Toad, SQL Developer, UNIX, Talend.

VONAGE – Holmdel, NJ December 2012 – February 2016

Database Developer

Gathered business requirements and various developed logical, physical and dimensional models.

Created Packages, Procedures, Functions, Triggers and other Database objects.

Developed various SQL & Shell scripts to automate data processing.

Developed PERL scripts to cleanse, validate data in flat files and extract data from XML files.

Developed & Automated complex ETL processes in INFORMATICA.

Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.

Worked on database migration from MySQL to Oracle.

Tuned SQL & PL/SQL code using enhanced features of Oracle.

Created and maintained various database objects in various databases like Oracle, Mysql, PostgreSQL and SQL server.

Environment: Oracle 11g, Teradata, PGsql, Mysql, SQL Server, Java, HP-Unix, Toad for Oracle 11.6, SQL server management studio, Eclipse, Putty, VSS, SQL*Plus, Toad Data Modeler, Aqua Data Studio, Tortoise SVN, UNIX Shell Scripting.

FANNIE MAE -- Reston, VA November 2011 - November 2012

Database Developer

Gathered business requirements and developed various Packages, procedures, triggers and other database objects.

Developed shell scripts to automate repetitive database tasks.

Developed, tested and plugged in SQL queries in the UNIX framework to generate ad hoc reports.

Used SQL*LOADER to load data into database.

Extensively used bulk SQL, REF cursors, Records and Collections to process large amount of data.

Developed complex ETL processes in INFORMATICA.

Environment: Oracle 11.2g/10.2g, HP-Unix, TOAD 10.6, Putty 0.62 ERWIN-R7, ASP.NET 2.0, Microsoft Clearcase 8.0, IBM rational clear quest 7.0.0, BMC Remedy 7.6.04, Share Point.

COMMONWEALTH OF PENNSYLVANIA – Harrisburg, PA November 2010 – October 2011

Database Developer

Gathered business requirements and developed various packages, procedures, functions, triggers and other database objects.

Modified existing PL/SQL code to make enhancements in the application.

Created data models of various schemas in the application by using reverse engineering feature of ERWIN.

Tuned SQL queries and PL/SQL code by using Explain Plan, Auto Trace and DBMS_PROFILER to optimize the subprogram units.

Debugged various program units by using DBMS_OUTPUT oracle supplied package.

Used dynamic SQL to develop flexible programs.

Developed test plans and technical documents related to the code developed.

Environment: Oracle 11.2g/10.2g, HP-Unix, TOAD 10.6, ERWIN-R7, ASP.NET 2.0, VSS 2005, IBM rational clear quest 7.0.0, BMC Remedy, Visual Studio 2005, Share Point

HDFC Bank, India May 2005 – July 2008

Database Developer

Created various tables, procedures, functions and packages and other database objects to implement business logic.

Created various SQL & Shell scripts for automation.

Used collections, records and Ref cursors to process large amount of data.

Involved in the optimization of SQL queries using Oracle Hints, Explain Plan and Auto Trace.

Created materialized views for faster data retrieval.

Developed technical documents and test plans.

Performed unit testing of the code written.

Environment: Oracle 9i, Windows NT, VSS, Serena Mover, TOAD, SQL *PLUS, Unix

EDUCATION

MASTER’S IN COMPUTER SCIENCE

Stratford University – Falls Church, VA

Bachelor’s of Science, Electronics and Communication Engineering

Punjab Technical University - Jallandhar, Punjab, India

CERTIFICATIONS

1Z0-147: Program with PL/SQL

1Z0-051: Oracle Database 11g: SQL Fundamentals I

Contact this candidate