SUMMARY:

• Nearly 9 years’ experience in analyzing, designing, tuning, and developing business intelligence (BI) applications utilizing MS SQL Server 2016/2012/2008 R2/2008 and SSDT tools such as SSIS/SSAS/SSRS. Collaborated in all phases of SDLC utilizing agile/scrum, waterfall, and spiral methodologies.

TECHNICAL SKILLS:

MS: SQL Server 2008, 2008 R2, 2012, 2016, Microsoft Dynamics 365

Data Modeling Tools: BIDS, SSDT, ER - win, MS Visio

Source Control: SharePoint, Team Foundation Server (TFS)

Power BI, Power Pivot, Power View, Performance Point Services

SQL Server 2008/2012 Integration Services SQL Server 2008/2012 Analysis Services (SSAS, MDX, OLAP Cubes), SQL Server 2008/2012 Reporting Services

SDLC: Agile, Scrum, Waterfall, and Spiral

PROFESSIONAL EXPERIENCE:

Confidential, NC

SQL/ETL Developer

Responsibilities:

• Created system requirement gathering documents based on extensive Project Scrum meetings.
• Created and managed schema objects such as tables, views, indexes, and referential integrity.
• Updated existing objects such as triggers, indexes, views, and UDFs to match the FRD.
• Created new stored procedures and functions based on the new functionality in the existing Application. Also updated existing functionality of similar objects based on new requirements.
• Performed Updates on the Slowey running stored procedure with Query optimization techniques.
• Implemented logging and error handling with the help of try catch block or throw statements to implement the system related errors return back to the front end applications.
• Created Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Have Experience in Planning the Complete Backing up of Database and Restored the Database from Disaster Recovery.
• Analyzed and enhanced the existing ETL strategies to populate the existing data warehouse with facts and dimensions based on new requirements in a multi-application environment.
• Designed SSIS packages to migrate the data from SQL Server to the staging area.
• Created SSIS Packages for ETL process to transform and load data from flat files to the data warehouse.
• Involved in implementing Incremental loading using CDC in SSIS.
• Performed data profiling, cleansing, validation, and verification with SSIS tasks. Implementing Event handlers, and Logging as necessary.
• Improved functionality of scripts utilizing C#.Net for a custom logging for ETL package.
• Converted the File Based SSIS Solution to the Project Based SSIS Solution for migration on the Catalog server.
• Involved in coordinating with source systems owners to fix issues in the daily ETL supporting multiple applications.
• Designed monthly, quarterly reports based on new requirements for Project Planning and Design with SQL report service (SSRS).
• Designed automated report deliveries to multiple recipients with subscriptions in SSRS.
• Created and formatted ad-hoc, parameterized, drill down, and drill through reports with parameters utilizing SSRS.
• Rendered SSRS reports to multiple formats per the business requirements utilizing subscriptions.
• Created a multitude of reports and dashboards with SSRS and Power BI.
• Incorporated Team Foundation Server for source control, check-in, and check-out.

Technical Environment: SQL Server 2012/2016, SSDT, SSIS, SSAS, SSRS, Microsoft Dynamics 365, SalesForce, Power BI, Power Pivot, Power View, TFS, SharePoint.

Confidential, WA

SQL/ETL Developer

Responsibilities:

• Created system requirement gathering documents based on extensive JRD and JAD sessions.
• Created and managed schema objects such as tables, views, indexes, and referential integrity.
• Developed and deployed database objects such as triggers, indexes, views, and UDFs
• Implemented system and user defined functions to improve the functionality of T-SQL code.
• Created and Updated Stored Procedure to implement business logic in loading the data and implementing constraints.
• Implemented logging and error handling with the help of try catch block.
• Designed Indexing Strategy and Managed Server space. Updated Statistics, Recompiling for Effective execution on the Server.
• Set up backups for the Existing Server for Restoring the Databases from Disaster Recovery.
• Created ETL Strategies to populate the data warehouse/data-mart with facts and dimensions.
• Followed Kimball methodology for creation of a DataMart from existing data warehouse.
• Involved in creating and connecting web UIs with the data mart utilizing ASP.Net web controls with C#.
• Designed SSIS packages to migrate the data from SQL Server to the staging area.
• Created SSIS Packages for ETL process to transform and load data from flat files to the data warehouse
• Involved in implementing Incremental loading using Checksum and CDC in SSIS.
• Performed data profiling, cleansing, validation, and verification with SSIS tasks and SQL stored procedures.
• Wrote scripts utilizing C#.Net for a custom logging for ETL package.
• Involved in coordinating with source systems owners, day-to-day ETL progress monitoring, Data warehouse target schema design and maintenance
• Involved in configuring and maintained Report Manager and Report Server for SSRS.
• Designed monthly reports and analysis to drive forecast production plan with SQL report service (SSRS).
• Designed automated report deliveries to multiple recipients with subscriptions in SSRS.
• Created and formatted ad-hoc, parameterized, drill down, and drill through reports with parameters utilizing SSRS.
• Rendered SSRS reports to multiple formats per the business requirements utilizing subscriptions.
• Created a multitude of reports and dashboards with SSRS and Power BI.
• Incorporated Team Foundation Server for source control, check-in, and check-out.

Technical Environment: ER-win, SQL Server 2012, SSDT, SSIS, SSAS, SSRS, Power Pivot, Power View, TFS, SharePoint.

Confidential, CA

SQL/SSRS Developer

Responsibilities:

• Collaborated with the project team to outline project requirements in JRD meetings.
• Created physical data model based on the requirements in the BRD.
• Created complex stored procedures to perform Index maintenance, data profiling, metadata search, critical staging procedures for loading data marts.
• Designed and implemented complex stored procedures with proper error handling.
• Involved in performance tuning and optimization on SQL queries, to improve the database performance.
• Experience in using DMV and dynamic management functions for finding out long running queries and Blocking Processes.
• Wrote T-SQL queries for data validation at staging and data warehouse tables.
• Extracted data from various source systems such as Excel, Flat files, SQL Server and loaded them into the SQL Server target-staging database utilizing SSIS.
• Developed various transformations in SSIS and supported Data warehouse design, development.
• Implemented error redirection in ETL packages to closely monitor failed records.
• Involved in making changes to existing data warehouse with fact and dimensions to hold current and historical data for reporting purposes
• Created KPIs to track the response and behavior of customers based on the project requirement documents.
• Generated parameterized, drill-down, and drill-through reports for business analyses utilizing SSRS.
• Generated a multitude of SSRS reports from cubes utilizing MDX.
• Created report models to create ad-hoc reports with report builder with SSRS.
• Implemented an interface to organize SSRS reports, sort data sources, schedule report executions, and track report history.
• Deployed multiple types of reports on Share Point and utilized dashboards with SSRS.
• Collaborated with team members on project updates by checking-in and checking-out on TFS.

Technical Environment: ER-win, SQL Server 2012, T-SQL, SSDT, SSIS, SSRS, MS Excel, MDX, SharePoint.

Confidential, CA

Industry: Healthcare

Responsibilities:

• Created System requirement-gathering document based on extensive JRD and JAD sessions that yielded the conceptual design.
• Developed a parent-child architecture on database objects including SPs, UDFs, and tables.
• Incorporated database objects with T-SQL such as stored procedures, UDFs, triggers, and Indexes to create complex scripts and batches.
• Wrote CTEs and ranked functions to remove duplicate records in OLTP tables.
• Worked on mapping documents creation as well as development for Data migration, data import, Initial and Incremental load.
• Created critical staging procedures to load data marts and report databases with multiple features.
• Performed database maintenance Using DMV’s and updated Statistic for the Enhanced Multi-Application environment Server.
• Created SSIS packages to load data into Data Warehouse utilizing various SSIS tasks such as execute sql task, bulk insert task, data flow task, etc.
• Created ETL package to load the monthly penalty processing data to centralized data warehouse.
• Optimized issue resolution procedures for large-scale production environments in SSIS.
• Deployed SSIS packages to the production server configured utilizing parameters into SSISDB Catalog.
• Implemented checkpoint, parallelism, delay validation in ETL logic for fast loading and processing.
• Created reports with multiple options with report designer and report builder in SSRS.
• Involved in analyzing data and clarified data outputs with reports and models in SSRS.
• Rendered reports to analyze multiple formats per the business requirements utilizing subscriptions in SSRS.
• Generated and scheduled on-demand reports for business analyses and management decisions with SSRS.
• Maintained version history of BI solutions within TFS.

Technical Environment: SQL Server 2012, BIDS, Transact-SQL, SSIS, SSAS, SSRS, ER-win, TFS.

Confidential, CA

SQL/SSRS Developer

Responsibilities:

• Collaborated with the project team and business users to gather business requirements.
• Performed data modeling (Star Schema) with ER-win for the ETL strategy.
• Designed the Relational data mart project approach, based on source data, requirement as well as infrastructure.
• Created functions to provide custom functionalities according to the requirements.
• Implemented error handing techniques such as 'Try Catch' to create robust T-SQL code.
• Implemented multiple isolation levels with lock mechanisms to avoid deadlocks.
• Optimized performance of slow running queries by analyzing the execution plans.
• Enforced business rules by creating constraints in both the production and relational data warehouse databases.
• Implemented slowly changing transformations with SSIS to maintain historical data in the data mart.
• Created ETL package to load the monthly claims processing data to centralized data mart.
• Created packages with multiple transformations to cleanse data and apply business rules.
• Scheduled SQL Server Agent job files to initiate SSIS package execution and report generation.
• Analyzed source OLTP systems and created data mapping documents for the ETL process.
• Developed SISS packages to extract, transform, and load data from OLTP servers to the OLAP database.
• Developed multiple reports in SSRS with features such as document maps, actions, conditional formatting
• Designed various dashboards with Power BI for better improvement in analysis and decisions with SSRS.
• Managed SSRS report delivery schedules by configuring standard/data driven subscriptions within report manager.
• Developed multiple reports in SSRS with features such as document maps, actions, conditional formatting.

Technical Environment: SQL Server 2008, BIDS, ERwin, SSIS, SSRS, MS Excel, TFS

Confidential, San Francisco, CA

BI/SSRS Developer

Responsibilities:

• Organized JRD meetings to gather business requirements from business users and SMEs.
• Designed and developed logical and physical database models with ER-win.
• Modified temporary tables, indexes, and lookup techniques to optimize stored procedures.
• Prevented potential blocks and deadlocks with complex code.
• Developed code with respect to security vulnerabilities, such as SQL injections.
• Designed mappings between sources and operational staging targets utilizing star schema.
• Designed and optimized complex stored procedures to perform data profiling and auditing in the pre-staging database.
• Created stored procedures for index maintenance, profiling data, searching metadata, staging procedures, and reporting databases.
• Created packages to cleanse data with fuzzy lookups/groupings, derived columns, and condition splits utilizing SSIS.
• Implemented an incremental load strategy with checksum and CDC techniques with SSIS.
• Repaired SSIS packages with checkpoints, breakpoints, and data viewers.
• Improved ETL package performance with the implementation of multiple properties.
• Created reports with multiple options with report designer and report builder in SSRS.
• Deployed SSRS reports to the reporting server and assisted in troubleshooting deployment problems.
• Worked on Team Foundation Server to synchronize the data with different-2 sources as well.

Technical Environment: SQL Server 2008, BIDS, T-SQL, BCP, Flat File, Excel

Confidential, San Diego, CA

SQL BI Developer

Responsibilities:

• Interacted with the business use and analyst for gathering the requirements for ETL enhancement Applications.
• Participated into various JAD sessions regarding the structure of the data warehouse requirement of the company.
• Created OLAP Data Models for loan processing system utilizing ER-Win.
• Collaborated with the senior architect and DBA to develop data validation procedures.
• Wrote complex SQL queries utilizing scalar and table variables, which hold user inputs and perform business logic.
• Developed a multitude of database objects in T-SQL.
• Enhanced the functionality and performance of various SQL scripts and stored procedures by utilizing UDFs, CTEs and System stored procedures along with usage SQL Profiler and DTA.
• Involved in creating complex ETL Strategies utilizing SSIS Packages that extracted the data from different heterogeneous sources.
• Implemented full and daily loads (incremental) with timestamp and checksum techniques in SSIS.
• Optimized cubes by assigning appropriate storage modes to partitions, and optimizations for better query performance.
• Created several calculated members, measure groups, aggregations, KPI’s as well as perspectives in support of analytical applications and dashboards.
• Designed and created report templates, bar graphs, and pie charts based on financial data.

Environment: SQL Server 2012, SSDT, SSIS, QRM Application, Toad, Power Pivot, Team Foundation Server (TFS), Flat files, Excel

Confidential, Pasadena, CA

BI Developer

Responsibilities:

• Interacted with the business use and analyst for gathering the requirements for Database Enhancement Applications.
• Used Erwin tool for the database depending on the requirements of the company.
• Created stored procedures, Triggers, User-defined Functions, Views for both Online and Batch requests handling business logic and functionality of various modules.
• Designed entire OLTP security practices by securing data utilizing appropriate server roles & database roles.
• Optimized the performance of queries with modification in TSQL code, removed unnecessary columns.
• Eliminated redundant and inconsistent data, normalized tables, established joins and created indexes wherever necessary.
• Worked on index analysis for tables and came up with more efficient solutions to use clustered and non-clustered indexes for significant performance boost.
• Created a partition scheme, partition function to improve the performance of queries, reduce contention and increase the availability of data.
• Designed CTEs for code management in complex stored procedures.
• Generated test data and tested the database to meet the functionality deliverables in the project documentation and specifications.
• Created ad hoc/managed reports utilizing report designer for analysis and to validate the information inserted to the warehouse.

Environment: SQL Server 2008R2, BIDS, DTA, Profiler, Team Foundation Server (TFS), Power Pivot, Flat files, Excel.

Confidential, San Diego, CA

SQL BI Developer

Responsibilities:

• Used Erwin tool for dimensional modeling according to the requirements from business users and analysts.
• Forward Engineered Data Model of Staging Database to SQL Server 2008R2.
• Followed Microsoft best recommendation for designing OLTP utilizing conceptual, logical and Physical Design by making use of Normalization techniques such as 1NF, 2NF & 3NF.
• Handling Query Optimization and Performance Tuning utilizing SQL profiler and Database Tuning Advisor (DTA).
• Handled complex errors on OLTP Transactional level by appropriately making use of TRY…CATCH Blocks, @@error system variable along with different System Error related functions.
• Performed Database performance tuning, performance monitoring and optimization utilizing Oracle Hints, Explain plans and Table partitioning.
• Created multiple overnight applications to assist various users in daily tasks.
• Backed up master & system databases and restored them when necessary.

Environment: ERWIN 4.0, SQL Server 2008R2/2008, DTA, Profiler, Team Foundation Server (TFS), Flat files, Excel, Oracle.

Confidential, San Diego, CA

SQL BI Developer

Responsibilities:

• Actively involved in gathering system specification requirements for the project.
• Developed and created logical and physical Database architecture utilizing ER-Win Data Modeler.
• Created new database objects such as Procedures, Functions, Indexes and Views utilizing T-SQL.
• Utilized Dynamic SQL for user customizable queries to be answered by the SQL Server.
• Created and maintained various star and snowflake schemas following the best design practices to assure the effectiveness and consistency.
• Optimized slow running TSQL complex OLTP queries by proper indexing strategies, partitioning strategies, utilizing joins instead of sub-queries, understanding execution plans, updating statistics and by applying Microsoft Best Practices.
• Created several materialized views, stored procedures, and UDF’s which are used by the front end development team.
• Redesigned and tuned existing stored procedures, triggers, UDF, views, indexes and was successfully able to increase the performance of the slow running queries.
• Wrote complex store procedures for data profiling process needed to define the structure of the pre staging and staging area.
• Used notification services to generate error messages and send them to the user through e-mails.
• Used Profiler to find badly performing queries and deadlocks.

Environment: SQL Server 2008/R2, T-SQL, DTA, Profiler, MS Excel, ER-Win, MDX, Windows Server, SP