SUMMARY:

• Proficient IT professional with an experience of more than 7 years and currently working as a SQL Developer.
• Successfully implemented system and user defined functions to improve the functionality of T - SQL code
• Experience in the implementation and delivery of MSBI platform solutions to develop and deploy ETL, analytical, reporting on SQL Server using SSIS.
• Gained experience in SDLC for the design, development and staging phases of the projects with extensive knowledge of data-flow, process models, and ER diagrams.
• Skilled professional with excellent work ethics and ability to work in fast paced environment with small/large teams in minimal supervision.

TECHNICAL SKILLS:

Data Modeling: Erwin, MS Visio

Database Programming: T-SQL, Dynamic SQL, MDX, DAX

Development Tools: BIDS, SSDT, SSMS

Integration Tool: SSIS

Analysis Services: SSAS, OLAP Cubes, Tabular Model

Reporting Tools: SSRS, Power BI, Excel Power BI

Source Control & Collaboration Tool: Team Foundation Server (TFS), SharePoint

Cloud Experience: MS Azure (IaaS, PaaS, SaaS), Azure SQL, Azure Data Warehouses, Data Factory, PowerShell, Azure Storage (BLOB, Tables, Queues, and File Share)

Database: SQL Server 2016, 2014, 2012, 2008/R2

SDLC: Agile, Scrum, Waterfall, and Spiral

PROFESSIONAL EXPERIENCE:

Confidential, Richmond, VA

SQL Developer

Tools & Environment: SQL Server 2016/2012, SSIS, Power BI, Erwin, MS Azure, TFS

Responsibilities:

• Collaborated with the project team and business users to gather business requirements.
• Participated in enhancing and implementing pre-existing logical and physical dimensional model.
• Worked closely with the application developers to help determine any issues with SQL script, SQL server performance, normalization, security and database/server connectivity.
• Developed a multitude of database objects in T-SQL
• Created multitude of SQL Server objects such as stored procedures, user-defined functions, indexes as well SQL logics which includes Joins, Sub-Queries, CTEs, cursors per business requirements.
• Designed complex stored procedure to enforce data profiling on data at Staging database to analyze data distribution extracted from multitude of OLTPs.
• Optimized the performance of queries with modifications to the existing index system and the reconstruction of indexes.
• Created multiple complex queries for data profiling and auditing purposes.
• Used ETL (SSIS) to develop jobs for extracting, cleansing, transforming and loading data into data warehouse.
• Designed complex SQL statements with joins, sub queries, and correlated sub queries.
• Designed an ETL architecture for data migration from the OLTP to OLAP with the help of SSIS.
• Designed user interactive dashboards, multiple charts types, trends, and KPIs utilizing Power BI.
• Build calculation, measures, and hierarchies to create detail level summary reports and dashboard using Power BI.
• Developed donut charts and implemented with customized tooltip in Power BI reports.
• Utilized Azure Data Factory to perform Azure-SSIS integration and deployed SSIS packages to cloud.

Confidential, San Francisco, CA

SQL/SSIS Developer

Tools & Environment: SQL Server 2016/2012, SSIS, Power BI, Erwin, MS Azure, TFS

Responsibilities:

• Analyzed business, system requirement specifications and responsible for documenting functional requirements.
• Created new database objects (such as tables, procedures, functions, indexes and views) utilizing T-SQL
• Designed the technical specifications document for ETL processing of data into data mart and strategized the integration test plan with implementation.
• Optimized the performance of slow running SQL queries by analyzing the execution plans, converting scans into seeks, re-compiling stored procedures, and creating indexing/partitioning strategies
• Utilized SQL Profiler and Database Engine Tuning Adviser (DTA) to generate trace information (file) to further get advice on performance optimization.
• Created complex ETL packages utilizing SSIS to extract data from staging tables to destination tables with initial and incremental load.
• Extracted business sensitive data from text files into SQL Server using SSIS DFT, Bulk Insert Task and BCP (bulk copy program)
• Designed Parent-Child packages as project architecture to support modular approach as ETL framework.
• Performed all activities related to the development, implementation, administration and support of ETL processes for large-scale data warehouses utilizing SSIS.
• Implemented pro-active caching as automatic way to refresh cube structure based on ETL timelines for DWH.
• Utilized Power BI to create various analytical dashboards that depicts critical KPIs along with slicers and dicers enabling end-user to make filters.
• Successfully integrated custom visuals based on business requirements in Power BI desktop.
• Participated in the configuration of on-premises Power BI gateway to refresh datasets of Power BI reports and dashboards.
• Identified performance, connectivity and other issues for the applications hosted in Azure platform.
• Utilized TFS as central repository to deploy and publish enterprise level documentation.

Confidential, Richmond, VA

SQL OLTP Developer

Tools & Environment: SQL Server 2014/2012, SSIS, SSMS, MS Excel, Tableau, TFS

Responsibilities:

• Gathered and analyzed business requirements and translated the same into system / technical specifications.
• Created Logical Data Model (LDM) for the project including documentation of all entities, attributes, data relationships, primary and foreign key structures, allowed values, codes, and business rules.
• Formulated functions to provide custom functionalities in T-SQL.
• Optimized queries by modifying T-SQL queries and eliminated redundant data.
• Wrote complex SQL queries using scalar and table variables which held user inputs and perform business logic.
• Designed and optimized dynamic SQL batches to perform bulk operations in the OLTP environment.
• Utilized temporary objects and query result place holders such as sub-queries, derived tables, table variables, temporary tables, cursors, CTEs to store data temporarily for ETL processing.
• Designed and developed SSIS packages to extract data from various data sources into SQL Server for further data analysis and reporting by utilizing multiple transformations and tasks.
• Wrote multitude of stored procedures to encapsulate ETL business logic including SQL structures for data transformations and executed them through Execute SQL Task from SSIS.
• Configured designed SSIS packages using parameters at project level and deployed them onto target test servers utilizing project deployment model.
• Utilized data blending, filters, actions, and hierarchies feature in Tableau.
• Analyzed the data using statistical features in Tableau to develop trend analysis.
• Published the developed dashboard and reports on the Tableau Server so that the end users having access to the server could view the data.
• Reviewed changes in packages, reports, and database objects with Team Foundation Server (TFS).

Confidential, New York, NY

SQL Server Developer

Tools & Environment: SQL Server 2012, TSQL, SSIS, SSRS, SSMS, Visual Studio, Report Manager

Responsibilities:

• Created system requirement gathering documents based on extensive JRD and JAD sessions with the users.
• Developed views, stored procedures, functions, triggers, and CTEs to assist efficient data manipulation and data consistency.
• Enforced keys and constraints on existing OLTP and newly created data mart to maintain data integrity/consistency as per company standards.
• Implemented error handling in T-SQL scripts utilizing try…catch blocks, @@error, throw and various error handling system functions.
• Created clustered, non-clustered, covering and filtered indexes to improve the performance of slow running T-SQL queries by replacing scans with seeks and analyzing the execution plans.
• Designed optimized ETL strategies to migrate data from various heterogeneous sources to be integrated into centralized dimensional data mart.
• Created SSIS packages to implement ETL strategies and performed data transformation utilizing SSIS transformations such as merge join, derived column, conditional split, lookup etc. per requirements.
• Utilized breakpoints, watch windows, data viewers, checkpoints and error logs for debugging SSIS packages on production servers.
• Created reports with analysis services cube as the data source utilizing SSRS as reporting tool.
• Formulated reports such as ad-hoc, drill-down, drill-through, cross-tab, sub-reports, pivot, tabular, parameterized reports and cascade parameterized reports using SSRS.
• Performed end-to-end SSRS report lifecycle with report authoring, report management, report delivery and report security.

Confidential, Newark, NJ

SQL/SSIS Developer

Tools & Environment: SQL Server 2012, T-SQL, SSIS, SSRS, SSDT, SharePoint

Responsibilities:

• Conducted JAD sessions with stakeholders, business partners, end users for gathering requirements.
• Heavily involved in business requirements gathering, GAP Analysis, Data Modeling, Development, Testing, Implementations and Documentation phases.
• Analyzed query plans utilizing stored procedures, managed indexes and locks, with deadlocks issues.
• Wrote stored procedures to assist the DBA with auditing; utilizing DMV functions and system objects.
• Designed customized stored procedures for data profiling and data cleansing as a part of ETL framework.
• Implemented master-child package models to improve the performance of the complex ETL strategy.
• Optimized SSIS packages with non-blocking/synchronous transformations and task/transformation properties as well executing control flow components in parallel when functionally independent of each other.
• Enabled loggings on ETL SSIS packages on executables at control flow level for package debugging purposes.
• Created variety of reports using SSRS including matrix report, parameter report, dashboard, charts, drill-down, drill- through, cascade parameterized report, configured report server and deployed reports on report server.
• Deployed and uploaded the SSRS reports to SharePoint server utilizing Share Point integrated mode.

Confidential, New York, NY

SQL/Database Developer

Tools & Environment: SQL Server 2008 R2/2012, SSMS, T-SQL, SSIS, SSRS, Windows Server

Responsibilities:

• Collaborated in JAD sessions with project managers, developers, QA Team, design architects, and design modelers to outline business requirements and specifications into functional / non-functional requirements.
• Defined multiple constraints in logical phase of the data modeling life cycle.
• Designed and optimized complex stored procedures to perform data profiling and auditing in the pre-staging database.
• Conceptualized data migration strategy to populate the data-mart with facts and dimensions.
• Developed stored procedures and functions to implement the business logic for interfacing with parameterized reports.
• Scheduled packages through SQL server agent and implemented shared schedules.
• Configured packages with parameters; deployed packages on the production server assisting DBA with project deployment model.
• Created sub, drill-down, summary, and matrix reports in SSRS.

Confidential, San Diego, CA

SQL Developer

Tools & Environment: SQL Server 2008 R2, Management Studio, T-SQL, SSIS, SSRS

Responsibilities:

• Coordinated planning and implementation phases of the data mart by analyzing business requirements.
• Wrote stored procedures, T-SQL, functions, and SQL queries to fetch and manipulate data from OLTP and OLAP databases.
• Assisted new and existing clients with integration and data conversion activities utilizing cast/convert functions in SQL Server and data conversion/derived column in SSIS.
• Documented and maintained database system specifications, diagrams, and connectivity charts.
• Utilized complex expressions to calculate, group, filter, parameterize, optimize, and format custom reports.
• Developed prototype views and reports of the data and worked with business users (both internal and external to refine their requirements)