SUMMARY:

• Over six years of work experience in Database Design, Coding and Testing of various Microsoft Data Warehouse and Business Intelligence Projects.
• Complete understanding of Software Development Life Cycle (SDLC) and core area of experience in validating end - to-end business scenarios of B2B (Business to Business) applications and enterprise applications.
• Extensive experience in designing, implementing and optimizing data transformation processes in the Hadoop file system (HDFS).
• Consulted with business partners and made recommendations to improve performance of Big Data systems, improve analytics systems, and prescriptive analytics systems.
• Capable of extracting data from existing data warehouse system, design and implementation of data warehouse system by using Big Data technologies and tools.
• Extensive coding experience, including JAVA, SPARK, C#, POWSHELL, Shell Scripting, SQL.
• Advanced knowledge of Structured Query Language (SQL) including Data Manipulation Language (DML) and Data Definition Language (DDL).
• 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.
• Having over 8 years of strong ETL and data integration experience in developing ETL mappings and scripts using Microsoft SSIS.
• Extensive experience in MS SQL Server 2008R 2/ 2012/2014/2016 and solid hands-on experience in installing, configuring, managing, monitoring and troubleshooting SQL Server in Development, Testing and Production environments.
• Experience in writing parameterized queries for generating tabular reports, formatting report layout and sub reports by using Global Variables, Expressions, Functions, Sorting the data, Defining data source and subtotals for the reports through SSRS 2008R 2/2012/2014.
• Proficient with SQL Server Management Studio, SQL Server Business Intelligence Development Studio (BIDS)/SSDT, SQL Profiler, Performance Monitor.
• Experience with the creation of SSIS packages in Data Extraction, Transforming, and Loading (ETL) from various sources using SQL Server Integration Services, Bulk Insert, and Bulk Copy Program (BCP).
• Strong experience with SQL Server performance monitor and performance tuning, maintenance and SQL Server version upgrade.
• Extensive knowledge in core RDBMS - tables, indexes, partitions, DB links, and experience in Advanced Pl/SQL - Procedures, Packages, Triggers.

TECHNICAL SKILLS:

DATABASE: Microsoft SQL Server 2012/2014/2016, Oracle, MySQL, HBase, HDFS, Postgres, Hive, Teradata, DB2, NoSQL

PROGRAMMING: T-SQL, C/C++/C#, PowerShell, Java, HTML5/CSS/JavaScript, Sparksql, Scala, JDBC,Python, Perl

MS BI STACK: SSIS, SSRS, SSAS

DEVELOPMENT: MS VSTS 2013/2015, Agile/Scrum, JIRA/Railly, SVN, Git/Github

PLATFORM: Windows 2012R2/2016, CentOS/Redhat Linux

PROFESSIONAL EXPERIENCE:

Confidential, Pittsburgh, PA

Sr. Database Engineer

• Designed and developed Big Data analytics platform for processing structured and unstructured data using Spark, JAVA, Hadoop, Hive and Pig
• Performed code reviews, analyzed execution plans, and re-factor inefficient code following data standards, resolved data issues, completed unit testing and completed system documentation for ETL processes.
• Created Spark ETL jobs to load Big Data into Hadoop File System (HDFS) and aggregated and integrated into Postgre database system.
• Integrated Hadoop into traditional ETL jobs, accelerating the extraction, transformation, and loading of massive structured and unstructured data.
• Lead several data extraction, warehousing design and analytics initiatives that enhance ETL progresses and performance.
• Extensive experience in writing T-SQL Scripts, Stored Procedures, Triggers and Functions, creating SQL Server Jobs/Alerts, and Scheduled Tasks to automate tasks.
• Experience with monitoring, troubleshooting and resolving database issues in 24×7 production environment.

Sr. MS SQL Server and SSIS Developer

• Responsible for working with business analysts and business users to gather and interpret business requirements for multiple financial and healthcare systems including large data warehouses.
• Developed accurate and scalable data models that can be successfully implemented for optimal production use.
• Worked closely with Enterprise Architecture on data architecture standards and conventions to ensure that data architecture standards and conventions are appropriately applied within application development solutions.
• Created technical designs within the existing architecture and developed complex T-SQL query logic to accomplish the task.
• Designed and developed Microsoft SQL Server 2014 database applications using SQL Server Integration Services, TSQL, Stored Procedures, UDF and Triggers.
• Primary technical resources in SQL tuning in SQL Server Production and Performance Testing environments by using statistics, hints, SQL tuning set etc.
• Transferred data from various data sources/business systems including MS Excel, MS Access, Flat Files, and Oracle etc. to SQL Server using SSIS.
• Performed code reviews, analyzed execution plans, and re-factor inefficient code following data standards, resolved data issues, completed unit testing and completed system documentation for ETL processes.
• Collaborated with business analysts, source system experts, and other team members to determine data extraction and transformation requirements.
• Collaborated with IT operations and testing organizations to ensure timely releases of projects and database environments sustainable.
• Collaborated with IT operations for support in problem resolution and root cause analysis. Supported IT staff and business users in the development, usage and troubleshooting of database-driven applications.
• Participated in special projects as needed and performed other duties as assigned.
• Provided on-call assistance as needed to ensure development follows the SDLC process.

Microsoft SQL Server and SSIS Developer

• Worked as a key contributor to the design, development and implementation of critical projects within the Application Delivery organization.
• Worked closely with the Data Architect, business users, application architects, and other developers to model, implement and improve databases used in mission-critical applications within the organization.
• Responsible for the overall data architecture within the Application Delivery area.
• Enabled/performed consistent development and maintenance of Microsoft SQL Server 2012 database designs for custom business applications in accordance with business, regulatory, and security requirements.
• Transformed business requirements into logical and physical data models by conducting data profiling/analysis. Maintained and published data mappings of data elements across systems, created and maintained relevant architecture artifacts.
• Created automated processes for the activities such as database backup processes and SSIS packages run sequentially using SQL Server Agent job.
• Created complex analytic queries on very huge data set; developed T-SQL Stored Procedures, Triggers and User Defined Functions.
• Utilized software development principles and experiences to develop within the full life-cycle of the mission critical production application.
• Managed MSSQL data warehouse, wrote SSIS for ETL tools, and SSRS for reports.
• Provided data services to the support team (data scrubbing, inserting and updating customer data).

Microsoft SQL Server Developer

• Consulted with the business analysts and business users to determine logical design for new business solutions according to existing data architecture.
• Designed and maintained invoice extract applications and file matching applications using T-SQL language following the client software development lifecycle.
• Developed complex Stored Procedure, Views and User Defined Functions on MS SQL Server; identified weaknesses in T-SQL code and then improved those weaknesses for future release.
• Collaborate with developers and QAs. Set up SQL/database mails to produce database health reports and other alerts.
• Created and maintained documentations for all related projects; performed detailed code reviews, and created automated build and deployment scripts.
• Analyzed and Developed Complex Stored Procedures, Functions, Index, Triggers, Cursor, Table, Constraints, Joins, Subquery and CTE in SQL to facilitate efficient data manipulation and data consistency.
• Set up SQL/database mails to produce database health reports and other alerts on the production environment; monitored production databases for performance, availability and data integrity.
• Coordinated and scheduled changes to database based on specific requirements.
• Responsible for all version control of code and technical documentations.
• Provided support to team member on a daily basis.