SUMMARY:

• Around 8 years of extensive experience working as MS SQL/Business Intelligence Developer on full stack technologies such as SSIS, SSAS, SSRS,
• Power BI and Tableau environments. Designed and developed OLTPs, OLAPs (Decision Support Systems) as well as business
• Reports within various industries such as technology, healthcare technology, airline, financial investment, and healthcare.

TECHNICAL SKILLS:

Database: MS - SQL Server 2012/Azure SQL

T: SQL Programming, Dynamic SQL

Data Modeling: ER-win, MS Visio

Integration Services (SSIS)

Development Tools: BIDS, SSDT, SSMS

Source Control: Team Foundation Server (TFS)

SharePoint 2013/2010

SDLC: Agile, Scrum, Waterfall, and Spiral

Microsoft Azure: Cloud Services (PaaS & IaaS) PowerShell Azure SQL Database (PaaS) Azure Storages (Blobs, Tables, Queues) Backup/Recovery Azure Data Factory Azure Data Warehouse

PROFESSIONAL EXPERIENCE:

Confidential, Mesa, AZ

SQL BI Developer

Responsibilities:

• Interacted with the business users for ETL application enhancements by conducting several JAD sessions.
• Performed DML operations on the existing database model based on the new changes as proposed by the legal firms.
• Created triggers to update master tables to authenticate the transactions depending on business logics in T-SQL.
• Designed and implemented views in T-SQL encapsulating business logic for enhancement of functionality and to support front-end applications.
• Optimized query by removing bookmark/key lookups with Covering Indexes on OLTP tables and created Column Store indexes to improve the performance of read operation.
• Involved in analyzing and implemented tables, views, stored procedures, functions, indexes in support of multitude of databases and ETL applications
• Involved in writing various test cases for errors in SQL stored procedures by utilized try/catch, breakpoints and transaction.
• Identified slowly running SSRS reports from Execution Logs and optimized them utilizing caching and snapshots.
• Generated ad-hoc reports from cube utilizing Excel Power Pivots.
• Utilized bi-directional cross filters to handle many-to-many relationships in Power BI Desktop.
• Generated multitude of reports and dashboard utilizing Power BI for business decisions.
• Involved in configuring virtual machine on Azure cloud to migrate on-premises SQL database and set-up their permissions.
• Managed different versions of complicated code and distribute them to different teams in the organization utilizing TFS.
• Collaborated with team member for check-in, check-out, source and version control utilizing team foundation server.
• Performed Master Data Services(MDS) task to get data from various sources to a centralized location
• Generated multiple reports and dashboard utilizing Tableau for business decisions.

Confidential, Richmond, VA

SQL BI Developer

Responsibilities:

• Participated in JAD session to analyze BRD and designed Functional requirement specification document.
• Created Entity Relationship (ER) Diagrams to the proposed dimensional model for OLAP system.
• Was engaged in MDS task to move data into a centralized location.
• Designed and managed schema objects such as tables, views, indexes and referential integrity depending on user requirement.
• Wrote complex stored procedures to implement data profiling and incremental load in OLAP architecture.
• Implemented transactions with proper isolation level and locking mechanism to avoid problems such as dirty read and phantom read.
• Utilized SQL profiler, statistics and DMVs to monitor and diagnose health of SQL server database.
• Created data flow diagrams, data mapping documents indicating the source tables, columns, data types, transformations required and business rules to be applied.
• Extracted large volumes of data feed from different data sources, performed transformations and loaded the data into various targets utilizing SSIS packages.
• Implemented CDC (change data capture) for inserting and updating slowly changing dimension tables in target for maintaining the history data.
• Utilized checkpoints, and transactions in SSIS packages to better control execution environment during data transfer.
• Utilized SQL server job agent to automate the data load processes to the target database.
• Optimized the performance of slow running SSIS packages at control flow and data flow level utilizing optimized workflows, increasing the buffer size as well as working around with “maxconcurrent” executable property.
• Involved in analyzing, designing, building, and testing of OLAP cubes with SSAS, implemented named calculation and named query.
• Implemented various features such as bookmark, interactive sorting and document map in SSRS reports.
• Developed complex visualizations reports using data from relational and multidimensional databases utilizing SSRS.
• Utilized stored procedure, caching and checked query against execution plan to optimize performance of SSRS reports.
• Developed Dashboard solutions for reporting, as well as published the Dashboards onto Web pages using Power BI, and SharePoint.

Confidential, San Diego, CA

ETL/SSIS Developer

Responsibilities:

• Participated in JAD session to analyze BRD and designed Functional requirement specification document.
• Created Entity Relationship (ER) Diagrams to the proposed dimensional model for OLAP system.
• Created and managed schema objects such as tables, views, indexes and referential integrity depending on user requirement.
• Wrote complex stored procedures to implement data profiling and incremental load in OLAP architecture.
• Implemented transactions with proper isolation level and locking mechanism to avoid problems such as dirty read and phantom read.
• Utilized SQL profiler, statistics and DMVs to monitor and diagnose health of SQL server database.
• Created data flow diagrams, data mapping documents indicating the source tables, columns, data types, transformations required and business rules to be applied.
• Extracted large volumes of data feed from different data sources, performed transformations and loaded the data into various Targets utilizing SSIS.
• Implemented CDC (change data capture) for inserting and updating slowly changing dimension tables in target for maintaining the history data.
• Utilized checkpoints, and transactions in SSIS packages to better control execution environment during data transfer.
• Utilized SQL server job agent to automate the data load processes to the target database.
• Deployed SSIS packages onto target server utilizing project deployment model with appropriate configuration option utilizing project level parameters.
• Collaborated with cross functional development and testing teams through TFS (Team Foundation Server).
• Implemented data factory solution including linked services and datasets to migrate data over the cloud per defines schedule.

Confidential, San Diego, CA

SQL ETL Developer

Responsibilities:

• Documented user requirements, translated requirements into system solutions and develop implementation plan and schedule.
• Aided in the design and development of the logical and physical data models, business rules and data mapping for the proposed OLAP architecture.
• Created database objects such as tables, views, triggers as well as custom stored procedures tailored to business requirements.
• Created different indexes such as clustered, non-clustered and covering indexes according to execution plan analysis.
• Optimized SQL queries and performed refinement of the database design leading to significant improvement in system response time and efficiency.
• Implemented effective error handling with try-catch, system variables and error functions in T-SQL scripts and stored procedures.
• Migrated data from Oracle, Flat file, Excel to Microsoft SQL Server by using different SSIS components such as data flow task and bulk insert task according to ETL strategies.
• Utilized script task and script component to design C# script to deal with the flat files and Excel sheets.
• Developed ETL Packages implementing stored procedures, dynamic variable expressions, sequence containers, conditional precedent constraints and transformations such as merge, union all and fuzzy grouping.
• Optimized the performance of slow executing SSIS packages by making changes in Control Flow and Data Flow like avoiding blocking transformations, increasing buffer size and property values.

Confidential, Denver, CO

ETL/Data warehouse Developer

Responsibilities:

• Collaborated with business users to document and implement business requirements in JAD and JRD sessions.
• Utilized ER-Win to represent attributes, entities and the relationship between the entities with Chen’s notation.
• Created views to simplify the results of complex queries including joins, group by and aggregate functions.
• Wrote CTEs to find and delete the duplicate records and utilized recursive CTEs to implement hierarchical operations in OLTP tables.
• Implemented complex stored procedures to write business logic with saved execution plan to improve the performance.
• Designed OLAP architecture with fact and dimension tables utilizing star schema for new data mart.
• Migrated data from legacy database and relational database to staging area utilizing SSIS for analysis and report creation.
• Eliminated inconsistencies and data issues with various SSIS transformations such as derived column, lookup, data conversion and conditional split.
• Utilized audit transformation in SSIS to store run time information about SSIS packages for later analysis.
• Migrated SSIS packages from development to production environments with package configurations (XML and SQL Server).

Confidential, Denver, CO

SSIS Developer

Responsibilities:

• Involved in data modeling, designing and building relational databases and OLAP architecture.
• Ensured data consistency by creating primary key, foreign keys and appropriate constraints.
• Altered and debugged some of the existing Stored Procedures to implement new execution plan according to changed architecture.
• Analyzed index performance on tables and implemented different kind of indexes and solved fragmentation problems.
• Designed and implemented ETL process and loaded data to data mart in order to server reporting requirements.
• Implemented slowly changing transformation utilizing SSIS, to maintain historical data in data mart.
• Used SSIS transformations such as conditional split, derived column and merge for data scrubbing and data validation.
• Implemented transactions at package and task level, to meet the business requirements, and better controlling the execution.

Confidential, Aurora, CO

SQL Developer

Responsibilities:

• Worked on stored procedures and complex queries for achieving the business logic and reporting.
• Analyzed the historical data and extracted required data to support the management decisions.
• Facilitated data retrieval and manipulation through implementation of Views, Procedures, Triggers and loops.
• Wrote complex TSQL stored procedures and scripts for the ETL process as well as for generating data sets for business reports.
• Worked extensively on different types of transformations by using SQL server stored procedures & SSIS packages
• Tuned and monitored the performance of T-SQL queries and SSIS packages.