PROFESSIONAL SUMMARY:

Versatile BI developer with more than 8 years of experience in development and maintenance of business intelligence applications. Proficient with SQL Server, MS BI Stack, and Azure within complex environments within multiple industries.

TECHNICAL SKILLS:

Database: SQL Server 2016/2012, 2008/R2, Azure SQL, T - SQL Programming, Dynamic SQL

Data Modeling: ER-win, MS Visio

BI Tools: Power BI, Tableau, Integration Services (SSIS), Analysis Services (SSAS, OLAP Cubes), Reporting Services (SSRS, Report Builder)

Development Tools: BIDS, SSDT, SSMS

Microsoft Azure: Cloud Services (PaaS & IaaS), Azure SQL Database (PaaS), Azure Storages (Blob, Tables, Queues) Backup/Recovery

SDLC: Agile, Scrum, Waterfall, and Spiral

Collaboration Tools: SharePoint, JIRA

Source Control: Team Foundation Server (TFS), GIT

WORK EXPERIENCE:

Confidential, Walnut Creek, CA

SQL/SSIS Developer

• JRD Meeting with clients to gather business requirement.
• Turning Business requirements into complex SQL Store procedures.
• Functional and Stress testing of Store procedures.
• Using SSIS package to Extract, Transformation and loading into shared network location.
• Automation of SSIS package using SQL job agents.
• Created complex SQL to for improving Performance of the Database.
• Created Confluence page for daily reports.
• Trained in EPIC system (Clarity).

Confidential, Ontario, CA

SQL/ETL Developer

• Participated in JRD sessions to gather requirements and outline functional requirements.
• Defined multiple constraints in logical phase of the data modeling life cycle.
• Created data mapping document (DMD) by analyzing data sources and mapping to data mart schema.
• Formulated SQL scripts to analyze historical data and extracted the required data to support management decisions.
• Transformed a complex business logic into SQL stored procedures and user-defined functions.
• Optimized queries by modifying T-SQL queries and eliminating redundant data.
• Prepared the complete data mapping for all the migrated jobs using SSIS.
• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming, and loading data into data warehouse.
• Designed complex SSAS cubes with fact measures groups and multiple dimension hierarchies.
• Managed report delivery schedules by configuring standard/data driven subscriptions within report manager.
• Delivered on-demand and scheduled reports for business analyses in SSRS.

Confidential, Encino, CA

SQL/ETL Developer

• Created technical design documents for existing SQL procedures and ETL processes.
• Developed Store Procedures and user defined functions to implement business logic and calculations.
• Wrote SQL code with complex logic utilizing multiple temp tables and table variables.
• Created SQL scripts with looping constructs for row by row operations as required.
• Handled runtime errors with try-catch and other error functionality.
• Created SSIS package to import data into SQL tables from multiple Excel files with multiple sheets.
• Utilized script tasks in SSIS packages to make customized Excel reports.
• Scheduled SSIS packages utilizing job agent during off hours.
• Developed SSRS reports with drill down functionality to provide required info.

Confidential, Enon, OH

SQL Developer

• Participated in daily scrum meetings to update the status of the tasks.
• Configured SQL database from scratch and to receive requests form Front-end.
• Provided documented solutions to the team related to design and development.
• Developed well-designed procedures to manipulated data from front end applications
• Added error handling techniques in procedures utilizing @@error and try catch blocks.
• Debugged procedures utilizing TSQL debugger and scalar and table variables.
• Created SSIS packages to pull data from multiple sources and loaded it to SQL Server Database.
• Handled runtime errors in SSIS packages for OnError and OnTaskFailure events utilizing event handlers.
• Developed SSIS packages to use logging with text and SQL table providers to ease debugging.
• Designed different reports in SSRS with appropriate formatting according to business requirement.
• Checked In/Checked out SQL code and other DB objects in TFS.

Confidential, Scottsdale, AZ

SQL Database Engineer

• Collaborated in JRD sessions with project manager and business analyst to analyze the project-goals and prepare BRD documents.
• Created stored procedures, triggers, user-defined functions, and views for newly added OLAP data.
• Utilized joins, subqueries, temporary objects temporary tables, table variables, and CTEs in writing complex queries and storing data.
• Implemented business in TSQL query through case statement and looping structure.
• Optimized TSQL stored procedure by recompile and fix parameter sniffing issue with variable.
• Utilized explicit transactions to maintain ACID properties for queries and procedures.
• Created a partition scheme to improve performance of queries, reduced contention and increase data availability.
• Implemented appropriate error handling techniques such as try…catch blocks, raise error and various other system functions to robustly handle errors per business requirements.
• Created clustered, non-clustered indexes including covering and filtered index by analyzing execution plans to further improve the performance of slow running SQL statements.
• Designed dimensional model architecture identifying required dimension and fact tables.
• Implemented packages in SSIS to extract data from source systems and resolved issues associated with finding data.
• Performed data cleansing operations during ETL process utilizing transformations such as derived column, data conversion and fuzzy lookup.
• Utilized event handlers to handle errors and implemented logging in SSIS to store detailed information.
• Implemented Team Foundation Server TFS as Version Management for Microsoft Technologies.

Confidential, San Diego, CA

SQL SSIS Developer

• Provided technical and functional support for project team and participated in documentation reviews.
• Conducted design reviews with the business analysts and ensured the feasibility of the logical and physical design models.
• Redesigned and tuned stored procedures, triggers, UDF, views, indexes to increase the performance of the slow running queries.
• Configured join statement in TSQL code combining data from numbers of data sets.
• Wrote While statement in TSQL to loop through a table on a row-by-row basis per business requirements.
• Developed SQL scripts and stored procedures with multiple JOINs and SET operators per business requirements.
• Identified and removed duplicates from tables utilizing ranking functions and CTEs.
• Created DDL statements for index rebuilds and reorganized to relief influence from index fragmentation.
• Created source-to-target data mapping documents to streamline the transfer of data from logical to physical data model.
• Designed dynamic SSIS packages to transfer data across multiple platforms; and performed data profiling to validate data.
• Utilized different SSIS properties to optimize the ETL process both in data flow and control flow level.
• Implemented different strategies to control errors in data flow and control flow level during ETL process utilizing precedence constraints and event handlers.
• Implemented TFS for BI application and SQL code source control.

Confidential, Atlanta, GA

SQL Server Developer

• Identified technical and function specifications based on project requirements in JRD meetings.
• Performed dimensional modeling with ER-win; designed and built relational data mart.
• Constructed T-SQL statements to fetch data from company OLTP and performed various DML operations.
• Created triggers on tables to audit DML operations and store transaction details.
• Built user defined function in SQL Server to calculate complex business formula.
• Optimized existing stored procedures by evaluating indexing and partitioning large tables.
• Developed and implemented capacity expansions to ensure scalable production databases.
• Implemented slowly changing transformations with SSIS to maintain historical data in the data mart
• Created SSIS packages to pull out the data from different sources and uploaded it to SQL Server Database.
• Designed SSIS packages utilizing various transformations such as multicast, merge join, lookup, fuzzy lookup, and fuzzy grouping.
• Utilized script task with C# programming heavily to extend the SSIS functionality.
• Collaborated with team members on project updates by checking in and checking out on TFS.

Confidential, New Orleans, LA

Database Developer

• Collaborated with the business users for ETL application enhancements with JRD sessions to capture, document the BRD and transform the relevant /approved BRD into SRS/FRS.
• Created the T-SQL script to generate all the tables and relationships based on the finalized ER-Diagram.
• Implemented error handling techniques such try catch blocks, error functions in T-SQL scripts to fine-tune query performance.
• Implemented CTE in SQL script to simplified main SQL query logic helping debug.
• Utilized SSIS transformations for data scrubbing and validation checks prior to loading into the data mart
• Debugged SSIS packages with features such as breakpoints, data viewers, and checkpoints.
• Mapped documents and developed logic for data migrations, data imports, initial loads, and incremental loads.
• Monitored and configured SSIS packages for dynamic execution; deployed packages to the testing environment.
• Collaborated with cross functional teams with multiple versions of database applications utilizing Team Foundation Server (TFS).

Confidential, Mobile, AL

SQL Developer

• Modified existing databases with tables and relationships and applied necessary constraints according to requirement.
• Created complex stored procedures to read data from multiple sources in multiple databases/servers.
• Created complex SQL statements with joins, sub queries, and correlated sub queries.
• Utilized BCP and Bulk Insert command to transfer business related data between SQL server and flat files.
• Created T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs.
• Involved in improving performance of slowly running queries utilizing multitude of optimization techniques such as indexing/partitioning strategies, re-structuring the existing SQL code and analyzing the execution plan.
• Supported DBA activities such as back-up operations including full backup, differential and log backup along with setting up appropriate Isolation.