SUMMARY

• 8+ years of MS SQL Server Development 2008/2008R 2/2012/2014/2016 suite of products in SSMS, SSIS, SSRS, Oracle 9i/10g, and Tableau.
• Involved in System Development Life Cycle (SDLC) from requirement analysis, system design, testing, to system deployment, maintenance in Waterfall development environment.
• Highly knowledgeable of Agile and Scrum.
• Highly proficient in T - SQL for developing Stored Procedures, Triggers, Views, User Defined Functions, CTE’s using dynamic-queries, sub queries, Relational Database models and Data Integrity, and SQL joins.
• Skilled in creating, documenting, and deploying Extract, Transform, and Load (ETL) packages under both Package Deployment Model and Project Deployment Model using SQL Server Integration Services(SSIS) to load data from homogenous and heterogeneous data sources into data warehouses and data marts.
• Adept in Data conversion, Normalization and Multi-Dimensional Modeling in Enterprise Data Warehouse design.
• Leading experience in Data Cleansing, Data Validation checks during Staging, before loading data into the data warehouse.
• Used ETL packages to apply control flow tasks and data flow tasks using various transformations, including Sort, Lookup, Conditional Split, Merge, and etc..
• Expertise experience in generating diverse types of routine and ad hoc reports based on the business needs using SSRS, Tableau, and MS Access, illustrated by interactive dashboards, sub-reports, parameterized reports and drill down, drill through reports.
• Expert in query optimization and performance tuning using performance monitoring tools such as SQL Server Profiler and Database Engine Tuning Advisor, analyzing Execution Plans, creating Clustered and Non-Clustered Indexes, performing Table Partitioning, and Data Modeling.
• Experienced with project management tool, source/version control including: Team Foundation Server, JIRA, SharePoint, and Team Track.
• Outstanding leadership, team-work, problem-solving, analytical and communication skills effectively to accomplish all works in a fast-paced environment.

TECHNICAL SKILLS

RDBMS/OLTP: MS SQL Server 2008/2008R 2/2012/2014/2016 , MySQL, Oracle 10g/11g, MS Access

ETL: SQL Server Integration Services (SSIS), Data Transformation Services (DTS), SQL Server Data Tools (SSDT), Business Intelligence Development Studio (BIDS), Data Quality Services (DQS), Data Profile Viewer

Data Warehouse/OLAP: SQL Server Analysis Services (SSAS)

Tools: Citrix, FortiClient, Visual Studio 2008/2010/2012 , SharePoint 2010, SPSS

Version Control System: Team Foundation Server (TFS) 2008/2010/2012 , GitHub

Language: Transact-SQL (T-SQL), MySQL, JAVA, C#

Reporting: SQL Server Reporting Services (SSRS),Microsoft Report Builder 3.0, Excel 2003/2007/2013/ office365, Tableau 8, Oracle PeopleSoft HCM 9.0/9.2, IBM Cognos BI 8/10, Power BI

Testing: User Acceptance Testing

.NET Technologies: ASP.NET, AJAX, JavaScript, CSS, HTML5, XML

PROFESSIONAL EXPERIENCE

Confidential, Jersey City, NJ

MS SQL Server Developer/ Database Developer

Responsibilities:

• Migrated data from heterogeneous data sources and legacy system (Access, Excel) to centralized SQL Server database using SQL Server Integration Services (SSIS) to overcome transformation constraints.
• Involved in loading the data from source tables to Operational Data Source (ODS) Tables using Transformation and Cleansing Logic.
• Responsible for developing source to target mappings
• Designed ETL (Extract, Transform, Load) strategy to transfer data using OLEDB providers from the existing diversified data sources.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL Joins and other T-SQL code to adept business logic.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Deployed SSIS package into Production and used Package configuration to export various package properties to make package environment independent.
• Developed reports specifications, created and modified reports using drill down, drill through, and sub-reports in SSRS 2012.
• Prepared reports using SSRS to highlight discrepancies between customer expectations and customer service efforts which involved in scheduling the subscription reports via the subscription report wizard.
• Performed in setting up SQL Server Agent Jobs for periodic Backups with backup devices, database maintenance plans and recovery.
• Generated daily tasks including backup and restore by using SQL Server 2012 tools like SQL server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Provided User Acceptance Testing to respond business users regard their requirement.

ENVIRONMENT: T-SQL, MS SQL Server 2008/2012/2014 , SQL Server Integration Service (SSIS), SQL Server Reporting Service (SSRS),Microsoft Report Builder 3.0, Windows Server 2008, SQL Profiler, Visual Studio 2008/2010/2012

Confidential, Hoboken, NJ

MS SQL Server Developer

Responsibilities:

• Created SSIS packages to extract data from various sources from diverse locations and loaded data into SSMS for further tuning.
• Developed Stored Procedures, User Defined Functions(UDFs), Indexed Views, and DML Triggers to facilitate ETL processes using T-SQL.
• Assisted in design and data modeling efforts of Data Marts and Data Warehouse.
• Generated ETL packages in SSIS to ensure data quality and data consistency using Lookup, Execute SQL Task, Sequence Container, Breakpoint, and Checkpoint.
• Performed incremental loading from source systems, like SQL Server, into data warehouse & data marts using a combination of techniques including T-SQL, Slowly Changing Dimensions, and Change Data Capture.
• Designed the reports using T-SQL and SSRS, illustrated by interactive dashboards, linked reports, sub-reports, parameterized reports and drill down, drill through reports using Tableau.
• Involved in generating and deploying various reports using global variables, expressions and functions using SSRS.
• Prepared ETL Log Reports and ETL Audit Reports in SSRS for project manager to check run status of ETL packages such as ETL name, Data flow type, start time, finish time, status and error message.
• Communicate effectively with internal business users to develop UAT / Testing Plans, discuss defects and implement resolution.

ENVIRONMENT: T-SQL, MS SQL Server 2012/2014, SQL Server Management Studio (SSMS), SQL Server Integration Service (SSIS), SQL Server Reporting Service (SSRS),Tableau 8, Windows Server 2008 R2, Visual Studio 2010, SharePoint 2010, Team Foundation Server (TFS) 2010

Confidential, Gainesville, FL

MS SQL Server Developer/ BI Developer

Responsibilities:

• Worked with project lead and business users to understand business processes, gather and document project requirements and translate into specifications for BI reports and applications
• Created database objects, such as views, stored procedures, functions, etc.using T-SQL to store data and maintain database efficiently.
• Developed ETL to implement the SCD transformation, to maintain historical data in data warehouse, and applied various data transformations like Data conversion, Multicasting, Condition Split, Derived Column in SSIS.
• Involved in developing initial load/incremental load ETL packages, Staging Data ETL packages, Package Test Script, and Report Requirements/Unit Testing through UAT Document and synchronized these packages/documents onto Team Foundation Server (TFS) and SharePoint.
• Implemented of data viewers, SSIS Logging, error configurations for error handling the packages.
• Created complicated reports including sub-reports, graphical reports, drill down/through reports, and formula-based/well-formatted reports according user requirements with cascading parameter in SSRS (2008/2012)
• Exported the data mart data to the SQL Server Analysis Services (SSAS) server to make resources available to the users for as hoc report needs and created reports containing all the information regarding the publishers, distributors and retailers using SSRS for internal and external use.

ENVIRONMENT: T-SQL, MS SQL Server 2008/2012, Salesforce, MS Access, SQL Server Management Studio (SSMS), SQL Server Integration Service (SSIS), SQL Server Reporting Service (SSRS), SQL Server Analysis Services (SSAS), Microsoft Report Builder, Windows Server 2008, Visual Studio 2010, SharePoint 2010, Team Foundation Server (TFS) 2010

Confidential, Philadelphia, PA

BI Developer

Responsibilities:

• Integrated and Extracted Source Data using SSIS ETL tool and stored procedures from SQL Server. Developed transformation logic and designed various ETL packages.
• Troubleshot and debugged pre-existing ETL packages using breakpoint and checkpoint to facilitate stability and reusability; used XML configuration and SQL Server table configuration to prepare deployment-ready packages.
• Optimized the performance of queries with modification in SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes wherever necessary.
• Worked as a developer in creating complex Stored Procedures, CTE, tables, views, joins and other statements for application.
• Managed the Metadata associated with ETL processes used to populate the Data Warehouse.
• Published high-level technical documentation to set standards, guidelines and best practices for SQL Server Installation, Administration, Backup, SQL Database Development, and Access database upgrades across the enterprise.

ENVIRONMENT: T-SQL, MS SQL Server 2008, SQL Server Management Studio (SSMS), SQL Server Integration Service (SSIS), SQL Server Reporting Service (SSRS), Windows Server 2008, SharePoint 2010

Confidential

BI Developer (SSMS/SSIS/SSRS)

Responsibilities:

• Used T-SQL to develop Stored Procedures, User-Defined Functions(UDFs), Indexed Views, and DML Triggers to facilitate ETL processes in SQL server 2008.
• Extracted, reviewed and transformed historical data from various data sources (Excel, CSV, SQL, Flat File) using OLE DB connection by creating various SSIS ETL packages.
• Performed performance tuning on existing stored procedures/queries by analyzing execution plans, logs/statistics, and traces in SQL Server Profiler/Database Engine Tuning Advisor.
• Created and maintained all types of database backup and recovery strategies and set up jobs to automate maintenance jobs to run daily.
• Utilized ETL tools including SSIS to implement process chain which automates data cleaning and loads data from staging database into PeopleSoft and Cognos BI.
• Built efficient SSIS ETL packages for processing fact and dimension tables with transforms and Slowly Changing Dimensions (SCD) to ensure the database platforms are configured, and maintained to capture record changes.
• Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis, working in conjunction with the data warehouse architect on the development of logical data models.
• Participated in meetings, reviews, and user group discussions as well as communicating with management and business groups.

ENVIRONMENT: T-SQL, MS SQL Server 2008, SQL Server Management Studio (SSMS), SQL Server Integration Service (SSIS), SQL Server Reporting Service (SSRS), Windows Server 2008, SharePoint 2010, PeopleSoft HCM 9.0, IBM Cognos BI 8