SUMMARY

• 6+ 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.
• Worked on C# in developing APIs for the source systems for integrating purpose.
• 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 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.
• Develop and maintain SQL Stored Procedures using MS Azure to integrate client data.
• 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, JDA, MS Office, Database Design and Management and crystal reports.

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, C# and python

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, Power BI

Testing: User Acceptance Testing

PROFESSIONAL EXPERIENCE

Confidential, Tulsa, OK

SQL Server Developer/ BI Developer

Responsibilities:

• Involved in loading the data from source tables to Enterprise Integration Hub (EIH) Tables using Transformation and Cleansing Logic.
• Responsible for developing source to target mappings
• Designed ETL (Extract, Transform, and Load) strategy to transfer data using OLEDB providers from the existing diversified data sources.
• Working on SSIS PowerPack ZappySys components to perform multi-functional transmissions in a single component ZappySys Task.
• Connecting Source systems though web services by using JSON and ODATA protocol.
• 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.
• Facilitate primary key rotation process to keep the connection to azure cosmos DB account secure.
• Performed in setting up SQL Server Agent Jobs for periodic Backups with backup devices, database maintenance plans and recovery.
• Daily job scheduling using ActiveBatch IT Automation which is advanced in job scheduling and saves time over the use of traditional date/time job scheduling.
• Provided User Acceptance Testing to respond business users regard their requirement.

ENVIRONMENT: T-SQL, MS SQL Server /2012/2014, SQL Server Integration Service (SSIS), SQL Server Reporting Service (SSRS), ActiveBatch v10, Windows Server 2008, Visual Studio 2016

Confidential, Las Vegas, NV

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.
• Use IBM DB2 database system to maintain, implement, and improve code/scripts.
• Deployed SSIS package into Production and used Package configuration to export various package properties to make package environment independent.
• Loading data from external source like db2, by connecting with Microsoft external connector called ‘Attinuty driver’ for SQL server which loads the data much faster that regular ODBC connector.
• Created reports utilizing SSRS 2012, Power BI and deployed them on SSMS as per business requirements.
• Prepared reports to highlight discrepancies between customer expectations and customer service efforts which involved in scheduling the subscription reports via the subscription report wizard.
• Worked on Integrating testing - Services testing using REST UI
• Developed Test Cases to test Web Services and RESTful calls using SOAPUI tool.
• Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources.
• 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 , IBM DB2, SQL Server Integration Service (SSIS), SQL Server Reporting Service (SSRS), Power BI, Microsoft Report Builder 3.0, ASP.NET, REST UI, Windows Server 2008, SQL Profiler, Teradata, Visual Studio 2008/2010/2012

Confidential

BI Developer

Responsibilities:

• Create, maintain and distribute complex analytic reports using SQL, Access and Excel
• Analyzed historical data to determine trends and generated statistical forecasts using JDA software
• Generate system-related reports to analyze data for ad-hoc reports and projects
• Investigate data quality issues to ensure accurate data for use by Science Marketing teams
• Observe existing business processes to develop and implement changes to increase efficiency.
• Collect data to create performance benchmarks and statistical forecasts to deliver business-strategic recommendations
• Develop actionable business intelligence using Data Analytic tools, including Tableau to make recommendations and identify approaches to improve Professional Membership, Science Marketing and Science Operations' digital portfolio

Confidential

SQL Developer

Responsibilities:

• Participated in Database design and query optimization.
• Monitoring SQL server performance using profiler to find performance Developed and optimized database structures, stored procedures, DDL triggers and user-defined functions. Backup and restore of databases.
• Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables and implemented triggers and stored procedures and enforced business rules via checks and constraints.
• Used T-SQL to develop Stored Procedures, User-Defined Functions (UDFs), Indexed Views, and DML Triggers to facilitate ETL processes in SQL server 2008.
• Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.
• 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.
• 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.