Database Developer, ETL Developer

Overview

A highly motivated and solid skilled Microsoft T-SQL developer and Microsoft Business Intelligence developer (ETL) with proven expertise in using new tools and technical developments to drive improvements throughout an entire software development lifecycle. Having extensive industry and full life cycle experience in a MS BI based environment, along with exceptional analytical, design and problem-solving capabilities. Excellent communication skills and able to work alongside support teams and the MS SQL/BI community to define and refine new functionality. Looking for an ambitious company which will challenge my developer and problem solving skills and allow me to continue to develop my knowledge and potential.

Objectives

Microsoft SQL Server Developer (T-SQL).

Oracle PL/SQL Developer

Microsoft Business Intelligence Developer (SSIS/SSRS, ETL)

Business Analyst (MS-ACCESS, ER-WIN, MS-VISIO, SQL PROFILER, BRD(Business Required Document), FRD(Functional Required Document, AGILE) )

Script language (C#, PHP, JAVASCRIPT, HTML, PowerShell)

Professional Summary

Over five years of solid experiences in Database Development, System Analysis, Design, Development and Supporting in Microsoft SQL Server 2008/2012, Microsoft SSRS Reporting fields and SSIS ETL process.

Designed and created Data Mapping Document (DMD) by analyzing various data sources and mapping it to the data mart schema using timestamp and hash bytes incremental load techniques

Used ER-Win toll for dimensional modeling (Star Schema). Forward Engineered data model of staging database to SQL Server.

Involved in the creation of Data Mart by taking into various business process by identifying different dimensions and facts.

Experience in developing high performance data integration solutions with SSIS, including extraction, transformation, and load (ETL) packages for data warehousing.

In-depth knowledge of complex T-SQL. Power user of advanced SQL queries with multi-table joins, group functions, sub-queries, set operations and functions.

Expertise in creating and optimizing T-SQL store procedures using indexes, UDFs, joins, error handling, views as well as with use of execution plan, SQL profiler and Extended Events.

Worked on business requirements gathering from end users and converting them into functional requirements and creating documentations, design and development on those requirements.

Expert in creating indexes, views, complex triggers, effective functions and stored procedures to facilitate efficient data manipulation and data consistency.

Great understanding of delivery modes that compliment business polices and needs like push delivery, pull delivery of reports using Standard/Data Driven Subscription in SSRS.

Experienced in writing Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, defining data source and subtotals for the reports using SSRS 2008/2012/2014.

Sufficient skills of monitoring and optimizing system performance by optimizing SQL queries, using report cache and snapshot.

Solid skills in designing and implementing data warehouses and data marts using components of Kimball Methodology, like Data Warehouse Bus, Conformed Facts & Dimensions, Slowly Changing Dimensions, Surrogate Keys, Star Schema, Snowflake Schema, etc.

Solid knowledge and experience of Agile/Scrum software development life cycle and project management methodology.

Results-Driven with ability to take initiatives and meet deadlines in a fast paced changing environment; Strong analytical and communication skills with the enthusiasm to learn new technologies.

Rewrite existing code and add new code to the top of existing code.

Technical Skills

Database:

MS SQL Server 2008R2/2012/2014, MySQL 5.x, Oracle 11g/12c

Microsoft BI:

SSRS/SSAS/SSIS, Visual Studio 2010/2012/2013, SharePoint

Software Methodology:

Agile/Scrum/Waterfull, Rally, JIRA, Git/Github, Subversion, Sublime

Platform:

Windows 2008/2008R2/2012/2012R2, CentOS Linux

Work Experience

08/2016 – 10/2016 Sharp HealthCare San Diego, CA

Position: Database Developer (Oracle 12c)

1.Involved in various business requirement gathering process by attending JRD (Joint Requirement Definition), Interacted with the end users and Subject Matter Experts, talking to the clients and preparing different documents according to the business requirements

2.Produced valuable documentation throughout the project assignment to facilitate easy take-overs and for future reference

3.Created Narrative Use Cases, User Stories, Use Case Diagrams, Activity diagrams, Data/Flow/Navigational flow diagrams using UML Tool.

4.Configure and manage database maintenance plans for database integrity check, backup operations and update statistics.

5.Written test scripts in Oracle to validate data staging tables and data warehouse tables to validate the data results on DEV/QAT/Prod environment

6.Created partitions on tables, indexes and index views as well as querying and managing partitions from optimization point-of-view according to the business criteria.

7.Excellent Communication, interpersonal, analytical skills and strong ability to perform as part of a team

02/2015 – 07/2016

Bank of America Headquarter Charlotte, NC

Position: Database Developer (Oracle 12c), Business Intelligence (ETL)

1.Senior database developer responsible for data warehouse ETL development and maintenance, SSRS report creation, and SQL query performance tuning.

2.Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines

3.Worked on all possible database objects including Tables, Views, Stored Procedures, User-Defined Functions, Triggers, Indexes and Cursors and optimized them to the fullest depth by following Practices.

4.Good Knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Index.

5.Experience with Performance Tuning for Oracle RDBMS using explain plan and HITNS

6.Managing Oracle using PowerShell scripts

7.Interacted with the data owners and business partners, presenting reports and suggesting actions on dirty data

8.Developed, enhanced, and supported processes using SQL and SSIS which moved data from the Oracle system and other sources into the SQL Server warehouse. Assisted in conversion of ETL processes from Oracle to SQL stored procedures.

9.Performed data profiling of the source systems that are required for data mappings and migration. Responsible for collecting and analyzing data and identifying areas and methods for improvement.

10.Developed SSRS reports and complex stored procedures for real-time benchmark and scoreboard display at Enterprise monitor dashboard. These reports retrieved data from OLTP SQL production databases and required extensive stored procedure tuning for rapid display.

11.Investigated nightly ETL data integrity issues for business intelligence reporting. Corrected job errors, data access issues, and platform data type conversion conflicts.

12.Used data analysis techniques to validate business rules and identify low quality missing data in the enterprise data warehouse (EDW) and reported those to developers for cleansing purpose.

13.Worked closely with end-users to collect requirements and test processes. Analyzed data and designed databases for importing data.

14.Gathered and organized data in order to track, report, and monitor effectiveness of key controls. Involved in data mining, code review, and automated reporting.

08/2012 - 11/2014

U.S. Cellular Bensenville, IL

Position: T-SQL Developer, Business Intelligence (ETL)

1.Working as the key role in maintaining and enhancing key back office financial applications originally developed using SQL Server2012.

2.Utilized the Agile Scrum software development principles and experiences to develop within the full life-cycle of the mission critical production application.

3.Gathered and analyzed technical information and created clear, readable documents, in the form of user manuals, end-user training materials, reports.

4.Investigate application anomalies to determine root cause. Resolve data issues per business needs. Perform ad hoc queries as needed. Develop and maintain general and online program reports.

5.Translated Business Requirements into Web analytical technical documentation

6.Assist application developers in designing program enhancements, database backup and recovery. Perform performance monitoring on database.

7.Identify and analyze expensive T-SQL stored procedure by using the SQL Profiler, Extended Events, SQL analyzer, create the necessary indexes and SQL hints to improve query performance.

8.Debugged and trouble shoot JAVASCRIPT codes using tools such as FireBug and Fiddler

9.Devised solutions to expedite the procurement of required data for unique website architectures comprised of XHTML, JAVASCRIPT, CSS and PHP.

10.Perform user acceptance testing of new changes before production release. Ensure program/data integrity. Contract Experience - Write and manage contracts. Review and approve vendor invoices.

11.Maintained data load operations using T-SQL procedures, SSIS packages and .Net applications; optimizations of data load operations; maintaining daily / weekly / monthly data loads and data distribution operations; troubleshooting of the existing code issues, data issues to meet data load SLAs as defined by the client.

12.Maintained and enhanced the existing Data Warehouse, exports and reports; developed vendor and client exports that meet provided specifications.

13.Schedule and manage daily / weekly / monthly sales and operational reports based on the business requirements.

14.Performed quality checks on reports and exports to ensure exceptional quality; monitored jobs and transfer queues to ensure they were functioning as expected.

15.Created unit test cases and technical documentation, performed detailed code reviews, and created automated build and deployment scripts.

2/2011 - 08/2012

Comcast Cable Englewood, CO

Position: T-SQL Developer

1.Participated in the full life-cycle development process from definition and design to production delivery.

2.Responsible for requirements gathering, status reporting, creating various metrics, project deliverables.

3.Provided functional and technical development support for comprehensive report development from various data sources.

4.Generated variety of business reports using SQL Server 2008R2 SSRS including matrix report, parameter report, dashboard with charts and drill down function; built reports from Analysis Services cube using MDX query designer; configured report server and deployed reports on web server and SharePoint, built Performance Points Dashboards in SharePoint.

5.Developed basic cubes, reports and dashboards (created reports from report packages with multiple data sources, used calculations and data aggregations, created list and crosstab reports, incorporated charting features, created drill-through reporting) and ensured they were tested in the development and test environments before being moved to production.

6.Produced, maintained, enhanced, and updated technical and non-technical software development program documentation.

7.Developed complex T-SQL stored procedure, views and user-defined functions on SQL Server (2008R2 and 2012); identified weaknesses in T-SQL code and then improved those weaknesses for future release.

Education

Master Degree of Information Science

Indiana University Indianapolis, IN

Bachelor Science Degree of Computer Science

University of Wisconsin Milwaukee, WI

Contact this candidate