SUMMARY

• Around 10 years of IT experience in database design and development in Microsoft SQL Server Database Products.
• Extensive experience in all phases of Project Development Life Cycle (SDLC) and SDLC methodologies including Waterfall, Agile.
• Strong understanding of Scrum concepts (e.g., user stories, managing the backlog, WIP)
• Experience working on JIRA, Scrum, Kanban as part of SDLC.
• Expert in working with the Business Intelligence Development Studio (BIDS)/SQL Server Development Tools (SSDT) which includes SSIS, SSAS and SSRS.
• Extensive experience in writing T - SQL, stored procedures/triggers, User Defined Functions(UDF), views, Relational Database Models, Data Cleansing, Data Scrubbing and Data Migration.
• Proficient in designing highly flexible Database Architectures and Data Modeling, Data Mapping, Optimization, Indexing and Tuning.
• Experienced in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance.
• Extracted and loaded data into the Data warehouse from Heterogeneous databases such as Oracle, MS SQL, Sybase, Excel, Flat Files and MS Access.
• Strong understanding of dimensional modeling, data warehousing concepts and methodologies.
• A key contributor in Data Warehousing solutions using Hashing, Partitioning, and Archive strategies in order to optimize performance.
• Expertise in working on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses.
• Expertise in developing and monitoring data flow tasks between increasingly complex and hybrid systems.
• Worked on Oracle DB. Worked on data migration projects form Oracle to SQL server.
• Experience upgrading SSIS Packages from BIDS 2008 to SSDT 2016.
• Experience in working with Facets, Nextgen and PEGA Systems.
• Expertise in administrative tasks of SQL Server of performing daily Backups and Recovery procedures.
• Experience working with production and 24 x 7 on call environments.
• Flexible, enthusiastic and project oriented team player with excellent written, verbal communication, analytical and interpersonal skills and leadership skills to develop creative solutions for challenging client needs.
• Excellent Troubleshooting, Analytical and Interpersonal skills.
• Open to take up challenging tasks.
• Ability to grasp new technology and tools quickly

TECHNICAL SKILLS

Operating Systems: Windows server 2012R2/2012, Windows 10/8.1.

Databases: MS-SQL Server 2019/ 2017/2016/2014/2012/2008 R2/2008, MS Access 2010/2007.

Database Technologies: Data Transformation Services (DTS), DTA, SQL Server Activity Monitor, SQL Server Logs, SQL Server Agent - Jobs, Alerts DB Mail and SQL Mail, SQL Server Management Studio, SSIS, SSAS, SSRS, BIDS, SQL Server Data Tools. SQL Query Analyzer, SQL Profiler, PL/SQL, T-SQL, Excel, Power BI, CozyRoc.

Reporting Tool: SQL Server Reporting Services (SSRS), Tableau.

Languages: C#, HTML, VB

Other Tools: Erwin, Microsoft Visio 2003/2000 Microsoft Project/Office 2013/2010/2007/2003 , Share Point.

PROFESSIONAL EXPERIENCE

Confidential, CA

Sr. MS SQL Server Developer Team Lead (SQL/ DW/ SSIS)

Responsibilities:

• Involved in all the phases of SDLC including Requirements collection, Design and Analysis of the customer specifications, Development and Customization of the application.
• Involved in the testing of the ETL processes in different environments.
• Worked extensively on provider, member, claims, Lab, Pharmacy, authorizations and clinical data in DW.
• Writing T-SQL scripts, complex stored procedures, functions, triggers.
• Build efficient SSIS Packages for processing Fact and Dimension tables with complex transforms.
• Implemented Complex business logic with User-Defined-Functions, Indexed Views and also created User Defined Data type, Clustered & Non-clustered Indexes and column store indexes.
• Designed & developed ETL procedures,data mappings involvingdata analysis,data validations anddata migrations.
• Extensively worked to Support Data warehouse for Source systems migration and Upgrades. (Facets, Nextgen (EHR), Authorization systems, Pega, EDW and others)
• Experience upgrading SSIS Packages from BIDS 2008 to SSDT 2016.
• Expensively provided 24/7 production support for the Data Warehouse.
• Experienced in Extracting, Transforming and Loading (ETL) of data from Heterogeneous data sources to MS SQL Server by using SSIS.
• Extensively worked providing production support and maintaining the data warehouse.
• Developed, monitored and deployed SSIS packages.
• Developed ETL process to transform the data from different systems using the ADF pipelines and used Data Lake process in-order to perform data massaging or conversions.
• Developed ETL to migrate data from Oracle to SQL server.
• Created POC and lead the team in implementing variety of projects:
• Data warehouses integration
• Nextgen Split vs. Copy.(EMR system)
• EDW Process improvements and Data monitoring systems.
• Recreated ODS Load process to cut the load time by over 75 % by incremental data load and parallel processing.
• Utilization management, Outreach and Pharmacy - OLTP Source systems migration and Upgrades. Updated and rebuilt the process.
• Updated EDW load process by creating a Control mechanism and making the processes table driven with Data validations.
• Created Data Archiving processes to purge old data on high volume data per business requirements.

Environment: SQL Server 2008R2, 2014, 2016,2019, SSDT, SharePoint, Business Intelligence Development Studio (BIDS), Data tools, TFS.

Confidential, Phoenix, AZ

Data Warehouse Developer (SQL/SSIS)

Responsibilities:

• Involved in gathering business requirements as endeavor that will facilitate the planning and the implementation phase of a data warehouse.
• Ensuredata warehouse anddata mart designs efficiently support BI and end user
• Designed and developed database models for the operationaldata store,data warehouse, and federated databases to support client enterprise Information Management Strategy
• Designed dynamic SSIS Packages to transferdata crossing different platforms, validatedata during transferring, and archiveddata files for different RDBMS.
• Created maintenance plan for reorganizing Indexes and scheduling jobs.
• Written T-SQL queries including Stored Procedures, Indexed Views, User Defined Functions, CTE and Distributed Transactions.
• Design and developed data warehouse, data marts and business intelligence using multi-dimensional models - star schema and snow-flake schema.
• Create and edit alerts on Reports, as per User request.
• Created Lists and views in share point and used them as the source in SSIS.
• Experienced in Extracting, Transforming and Loading (ETL) of data from Heterogeneous data sources to MS SQL Server by using SSIS.
• Performance Tuning of Stored Procedures and SQL queries using SQL Profiler and Index Tuning Wizard in SSIS.
• Created packages in SSIS with error handling and Worked with different methods of logging in SSIS.
• Developed, monitored and deployed SSIS packages.
• Provided 24*7 supports to SQL application developers in implementing the applications on production server.

Environment: SQL Server 2012 SSIS, SSRS, SharePoint, TFS, Business Intelligence Development Studio (BIDS), Visual Studio 2012, MS Visio 2013/2010, MS Access.

Confidential, VA

MS SQL Server Developer(SSIS/SSAS/SSRS)

Responsibilities:

• Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis, working in conjunction with the data warehouse architect on the development of logical data models.
• Created the Multi-Dimensionaldata model (STAR Schema) and enhanced it to meet the growing requirements due to various corporate groups accessing thedata.
• Written T-SQL queries including Stored Procedures, Indexed Views, User Defined Functions, CTE and Distributed Transactions.
• Created configuration files to deploy SSIS packages across all environments.
• Interacted with various upstream and downstream customers in interfacing various systems fordata extractions, ETL, Analytics and Reporting needs.
• Identified the dimension, fact tables and designed the data warehouse using star schema.
• Identified and Defined Fact relationships in SSAS.
• Created OLAP models based on dimension and facts for efficient loads of data based on star and snowflake schema structures.
• Developed OLAP cubes using SSAS (SQL Server Analysis Services) and calculated the metrics that were revealed in the functional analysis.
• Worked on AgileMethodology.
• Provided 24*7 supports to SQL application developers in implementing the applications on production server.

Environment: SQL Server Business Intelligence Development Studio, SQL Server 2012, SSIS, SSAS SSRS, Microsoft Visual Studio 2013/2010, ASP.NET, ER Studio, Share point, T-SQL, XML, MS Excel.

Confidential

SQL/ Report Developer

Responsibilities:

• Involved in complete Software Development Life Cycle (SDLC).
• Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non-clustered indexes.
• Involved in upgrading from MS SQL Server 2008 to MS SQL Server 2012.
• Performed ETL of Data from Various Data Sources and loaded into different destinations using BIDS.
• Configured the loading of data into slowly changing dimensions using slowly Changing Dimension Wizard. Also implemented checksum SCD method to load the data into date warehouse
• Involved in designing Parameterized Reports and Report Models for generating Ad-Hoc reports as per the client requirements.
• Defined Key Performance Indicator metrics to create Power BI scorecards.
• Involved in creating report models and applying row level security filters for report model.
• Developed complex Stored Procedures to generate various Drill-through reports, Parameterized reports, Tabular reports, Matrix reports and linked reports using Power BI.
• Written T-SQL queries including Stored Procedures, Indexed Views, User Defined Functions, CTE and Distributed Transactions.
• Used Microsoft Power BI Power Query to extract data from external sources and modify data to certain format as required in Excel.
• Developed yearly and quarterly company expense reports using Power BI.

Environment: SQL Server 2008/2012, SQL Server Business Intelligence Development Studio (SSAS, SSIS, SSRS), .Net framework, Microsoft Office Share Point 2007, XML, Power BI