SUMMARY:

• IT Professional with an experience of 7 years in multiple domains including Banking, Financial, Healthcare.
• Experience in optimizing performance in relational and dimensional database environments by making proper use of indexes and partitioning techniques.
• Skilled in using SQL Server error logs and Data Viewer for troubleshooting issues.
• Merit of working on all activities related to the development, implementation, administration and support of ETL processes for large - scale data warehouses using SSIS.
• Proficient in building calculation, measures, and hierarchies to create detail level summary reports and dashboards using Power BI.

TECHNICAL SKILLS:

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

SDLC: Agile, Scrum, Waterfall, and Spiral

Data Modeling: Erwin, MS Visio

Database Programming: T-SQL, MDX, DAX

Development Tools: BIDS, SSDT, SSMS

Integration Tool: SSIS

Analysis Services: SSAS, Cubes, Tabular Models

Reporting Tools: SSRS, Power BI, Tableau, Desktop

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)

PROFESSIONAL EXPERIENCE:

Confidential, Richmond, VA

QL BI Developer

• Analyzed and documented business requirements by participating in JRD sessions.
• Defined relationships and constraints in logical/physical dimensional models of the data mart.
• Converted a complex business logic in OLTP system into stored procedures and user-defined functions.
• Redesigned existing stored procedures with efficient logic to improve the performance of queries.
• Managed SQL code with proper control flow constructs as required by the business logic.
• Implemented transactions with different isolation levels to avoid dirty reads and deadlocks.
• Built master-child package models to improve the performance of the complex ETL strategy.
• Resolved SSIS package errors utilizing error logs, breakpoints, checkpoints, and data viewers.
• Deployed SSIS packages to different environments using project deployment model.
• Automated the ETL process with scheduled SQL Jobs calling SSIS packages.
• Enhanced the performance of SSIS packages with proper usage of tasks and transformations.
• Altered existing SSAS cube to facilitate reporting for the business based on historical and current data.
• Utilized different transformations such as merge queries, append queries, and calculated column in Power BI desktop.
• Established hierarchies and utilized them with slicers for in depth analysis of data in Power BI.
• Implemented gateway to synchronize data between on premise systems and published Power BI reports.
• Generated and scheduled reports for business analyses and management decisions utilizing SSRS.
• Implemented role-based security for reports with report manager.

Tools & Environment: SQL Server 2016, T-SQL, SSIS, SSRS, SSAS, Management Studio, Data Tools, Power BI

Confidential, Irvine, CA

MSBI Developer

• Coordinated with business users and stakeholders in JRD sessions for gathering business requirements.
• Altered logical model as per changed requirements and defined various constraints utilizing Erwin.
• Wrote custom T-SQL stored procedures to improve performance, reusability, security and provide additional application functionality.
• Created user defined scalar functions to support common calculations used more frequently.
• Designed and implemented clustered and non-clustered indexes on tables ensuring the efficiency and latency of queries.
• Optimized the performance of T-SQL queries with industry standard techniques.
• Facilitated SQL scripts for testing SSIS packages and validating the data.
• Implemented logic for incremental load utilizing checksum and time stamp techniques.
• Incorporated multiple transformations within SSIS package to maintain historical data in the data mart.
• Parameterized properties that needs configuration in different environments and deployed packages.
• Configured partition for SSAS cubes for using different storage modes such as MOLAP, HOLAP, and ROLAP to improve performance.
• Developed various reports and dashboards using Power BI with import, direct query and live connection data access modes.
• Utilized active-inactive relationship, cardinality and cross filter between tables in Power BI desktop according to business analysis.
• Published Power BI reports to Power BI Services and shared them with other teams.
• Designed and implemented SSRS reports such as drill-down, drill-through, sub, and parameterized reports.
• Delivered reports with standard and data-driven (in multiple rendering formats) subscriptions.

Tools & Environment: SQL Server 2012, Transact SQL, SSIS, SSAS, SSRS, SSMS, SSDT, Power BI, MS Excel, TFS

Confidential, Plantation, FL

ETL/DWH Developer

• Collaborated in JAD sessions with design architects, and other team members to transform business requirements and specifications into functional/non-functional requirements.
• Designed database tables and created table and column level constraints using the suggested naming conventions for constraint keys.
• Wrote complex stored procedures, functions, and triggers to implement business logics in the OLTP database.
• Formulated a partition scheme and a partition function to improve the performance of queries and availability of data.
• Generated SQL scripts with Merge statement for syncing data between source and destination tables.
• Performed data profiling, cleansing, validation, and verification with SSIS packages and SQL stored procedures.
• Designed SSIS packages to migrate the data from SQL Server to the staging area.
• Extracted and loaded data from multiple sources such as Excel and SQL Server to the staging area.
• Deployed and configured SSIS packages to the production server with parameters in the SSISDB catalog.
• Created aggregations and user-defined hierarchies for SSAS cubes and KPIs.
• Developed drill through, drill down, linked, sub, and parameterized reports for improved analysis with SSRS.
• Created complex reports with multiple datasets and sources in SSRS.

Tools & Environment: SQL Server 2012, T-SQL, SSIS, SSAS, SSRS, SQL Profiler, Windows Server, Erwin

Confidential, Atlanta, GA

ETL Developer

• Converted business requirements into functional and non-functional requirements.
• Enhanced pre-existing physical database model with new tables and constraints.
• Maintained referential, domain, and user defined integrity utilizing available options.
• Assisted in preventing potential blocks and deadlocks within complex code.
• Developed code with respect to security vulnerabilities such as SQL injections.
• Developed stored procedures and functions to implement the business logic for interfacing with parameterized reports.
• Developed SSIS package with multiple transformations and tasks to implement complex business logic.
• Implemented check points to execute the packages from the last point of failure in case of any issue.
• Configured packages with parameters and deployed packages on the production server with package deployment model.
• Utilized MOLAP storage modes and proactive caching for SSAS cubes.
• Generated reports utilizing SSRS and Excel with Power Pivots and deployed reports in SharePoint integrated mode.
• Designed and created report templates, bar graphs, and pie charts based on data.

Tools & Environment: SQL Server 2008 R2, SSIS, SSRS, BI Development Studio, Management Studio, Excel, TFS

Confidential, Iselin, NJ

Database Developer

• Modified existing procedures to implement new requirements without altering existing logic.
• Recommended different types of indexes on tables and views as per queries.
• Formulated multiple complex queries for data profiling and auditing purposes.
• Created SQL scripts for modifying and inserting data to tables.
• Deployed reports to the Report Server in native mode and SharePoint integrated mode.
• Developed drill through, drill down, linked, sub, and parameterized reports for improved analysis.

Tools & Environment: SQL Server 2008, T-SQL, SQL Profiler, SSMS, BIDS, SSRS, DTA, Windows Server, TFS