SUMMARY

• Proficient and motivated ETL/BI/DW developer with 7 years of experience in development of back - end applications using MS SQL server, Oracle and various BI tools such as Power BI, Tableau and Looker.
• Strong experience in Database Design, Development and business intelligence of Microsoft SQL Server 2016/2012/2008 (R2) in Development, Test and Production Environments with various business domains.
• Expertise in Integration Services (SSIS), Analysis Services (SSAS) and Reporting Services (SSRS).
• Highly proficient in Development, Implementation, Administration and Support of ETL processes for Large-scale Data warehouses using SSIS.
• Strong SQL database experience in a high transaction and multi-server production environment
• Experience in Installing, Configuring, Managing, Monitoring and Troubleshooting SQL Server.
• Expert in creating SSAS cubes and creating dashboards in PPS (Performance Point Server) using Business Modeler.
• Developing reports on SSAS & SSRS on SQL Server; sound experience and understanding of SSAS, OLAP cube and Architecture.
• Experience in deploying created reports in various sources like Web browser, XML and PDF.
• Experience in Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS).
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using DTS and SSIS services.
• Extensively worked on Python (NumPy, Pandas, Matplotlib, NLTK and Scikit - learn).
• Worked on different data formats such as JSON, XML and performed machine learning algorithms in Python.
• Developed JSON Scripts for deploying the Pipeline in Azure Data Factory (ADF) that process the data using the Sql Activity.
• Developed complex calculated measures using Data Analysis Expression language (DAX).
• Strong experience in building OLTP/OLAP databases through ERD, planning or implementing ETL process, creating reports and performance tuning.
• Proficiency in development that includes data integration, conversion, migration.
• Experience in developing T-SQL stored procedures, functions, ETL processes and reports.
• Good knowledge in Normalizing and De-normalizing the tables and maintaining Referential Integrity by using Triggers and Primary and Foreign Keys.
• In-depth understanding of Data Warehousing and Business Intelligence concept
• Designed and developed efficient Error handling methods and implemented throughout the mappings in various projects.
• Good knowledge of Master Data Management concepts.
• Responsible for interacting with business partners to identify information needs and business requirements for Reports.
• Participation in conducting JAD sessions with business users, development and QA teams.
• Excellent analytical, coordination, communication and interaction skills with an aptitude to learn.
• Experience in multiple industries such as healthcare, supply chain, insurance and finance.

TECHNICAL SKILLS

Databases: SQL Server (2008, 2008R2, 2012, 2014, 2016), MySQL, Oracle, MS Access, Postgres

BI tools: SSIS, SSRS, MS Dynamic 365, Power BI, Tableau, Looker, DBT, SSDT, Informatica, Matillion, DataStage, Report Builder, ER-Win, MS Visio, TDM

DWH: Kimball, Inmon, Star Schema, Snowflake Schema

Languages: T-SQL, Python, R, Hadoop, Spark, HIVE, Scala, C#, JavaScript

Big Data Architectures: Hadoop, Spark, Hive, Pig

Data Analysis Tools: SAS, SPSS, Arena, Minitab, SAS Enterprise Miner, @Risk

Cloud services: AWS Redshift, Azure (Cloud Data Factory, Azure SQL database), Snowflake

Platforms: MapReduce, HDFS, TensorFlow

Environment: s: Agile, Scrum

Collaboration Tool: SharePoint

Version control: Jira, TFS, GIT, Linters

PROFESSIONAL EXPERIENCE

Confidential, Cary, NC

Senior SQL/BI Developer

Responsibilities:

• Implemented large Lambda architectures using Azure Data platform capabilities like Azure Data Lake, Azure Data Factory, HDInsight, Azure SQL Server, Azure ML and Power BI.
• Created stored procedures, CTEs, and dynamic SQL per business requirements to build and implement business logic.
• Developed views, temp tables, table variables to facilitate efficient data manipulation and data consistency.
• Used aggregate function, window function, analytic function, ranking function, data and type function, and string function to fit complex business calculation.
• Performed index analysis for tables and came up with more efficient solutions to use clustered and non-clustered indexes for significant performance boost using index tuning wizard.
• Added key constraints, not null constraints, default constraints and check constraints to keep data integrity.
• Implemented transaction statements on DML activities and performed locks (exclusive lock, shared lock, etc.) to improve performance.
• Optimized the performance of slow running SQL queries utilizing appropriate changes in the code structure, utilizing indexing and partitioning strategy as well as making use of SQL Profiler and Database Engine Tuning Advisor.
• Built SSIS parent-child packages and leveraged a variety of other methods to import/ translate/ manipulate healthcare data.
• Analyzed and worked with multiple data sources (MSSQL, Flat file, EDI communications, etc.) to meet business rules and support analytical needs.
• Created highly complex SSIS packages using various Data transformations like conditional splitting, script components, lookup, sort and for each loop container.
• Wrote C# scripts to send emails to inform users about data cleansing and to create XML destination.
• Handled incremental load using checksum and timestamps methods.
• Applied various slowly changing dimensions (SCD), such as Type 2 and Type 4 to different dimension tables.
• Developed Logical data model, contributed to ETL work-flow and constructed Star-Schema dimensional model.
• Supported reporting applications for Cash Management, transfer agents and mutual fund management and drove continual improvement by re-engineering legacy code.
• Restricted data for users using Row level security and User filters.
• Developed Tableau workbooks from multiple data sources using Data Blending.
• Provided 24/7-production support for Tableau & Looker users on Ad-Hoc basis.
• Developed effective and interactive Dashboards using Parameters and Actions.

Environment: MS SQL Server 2019, MS Visual Studio 2019, SSRS, SSIS, Azure, Power BI, Tableau, Looker

Confidential, Flowood, MS

Senior SQL/BI Developer

Responsibilities:

• Produced complex web reports using extensive HTML/CSS.
• Remediated reports with DB2 and Netezza data sources as required.
• Coordinated with QA testers from end-to-end.
• Coordinated migration of several WebFocus Reporting applications from version7.7x to version 8.103 with offshore team.
• Developed IBIEE BI Metrics for Security Pricing Business Process Work-Flow monitoring, and Security -Level System Support Processes.
• Developed Logical data model, contributed to ETL workflow and constructed Star-Schema dimensional model.
• Supported reporting applications for Cash Management, transfer agents and mutual fund management and drove continual improvement by re-engineering legacy code.
• Transitioned from SDLC Methodology to Agile Methodology incorporating LEAN Practice especially as it applies to BI development.

Environment: Webfocus, DB2, Netezza, MS Excel

Confidential, Lincoln, NE

Senior SQL/BI Developer

Responsibilities:

• Performed component and data architecture design, technology planning, and testing for Applications Development (AD) initiatives to meet business requirements.
• Provided input and support of full systems life cycle management activities, such as writing documents, designing, testing, implementing, maintaining, and controlling NDE ETL processes.
• Designed an end-to-end analytical landscape involving Power BI dashboards connected to backend SQL Server 2016 system on Azure to enable a government infrastructure agency to analyze/detect fraud in over Rs 4.6 Billion worth of annual Tenders. This included conceptualizing the architecture from the Govt RFP, sizing the Azure Cloud infrastructure, designing, and setting up Power BI connectivity all the way up to building the actual Tender dashboards for the paid PoC.
• Designed and built a Data Discovery Platform for a large system integrator using Azure HdInsight components. Used Azure data factory and data Catalog to ingest and maintain data sources. Security on HdInsight was enabled using Azure Active directory.
• Designed end to end Azure cloud-based analytics dashboard for a state government for showing real time updates for the recent their state assembly elections 2016. Solution utilized Power BI, Enterprise Gateway and Azure SQL Server.
• Used Dynamic SQL to load more than 30,000 tables with complicated table relationships, created data models and assigned table retention criteria rules, and translated between ER model and ELT/ETL implementation.
• Analyzed data, built solutions, automated processes, and created virtual agents on Citizen development through Power platform by using Power BI, PowerApps, Power Automate and Power Virtual Agents.
• Developed Python scripts to connect NDE production servers and databases to migrate call and survey data from various sources (flat files, SQL Server, Access, Oracle databases), performed data profiling, cleansing, transformation, validation and loading into database/ flat files.
• Developed over 10 SSIS packages to perform data transformation in data mappings and incremental loading with sources like CSV, XML and strategies such as row version, checksum, CDC using script task, data flow task, for each loop container, etc., for transaction loading.
• Implemented slowly changing dimension type 2 using SSIS for initial load and incremental load.
• Worked on customer segmentation using an unsupervised learning technique clustering.
• Validated and select models using k-fold cross validation, confusion matrices and worked on optimizing models for high recall rate.
• Visualized case related data by Python matplotlib library like bar chart, heat map, and histogram.
• Wrote C# script task and script component in SSIS to fill purposes such as sending notification emails in HTML format, renaming file names with timestamp, and extracting data from XML files.
• Performed unit testing on SSIS packages and collaborated with QA testers during the testing period.
• Monitored SSIS packages, including troubleshooting errors and failures, creating stored procedures utilizing execution plan and SQL Profiler, redesigning tasks and components for optimization, configuring buffer size properties in data flow tasks, etc. to optimize performance.
• Designed T-SQL queries and stored procedures with UDFs, views, CTEs, table variables, temp tables, to implement business logic, including data cleansing, preventive error handling, transformation.
• In Azure environment, assisted DBA teams to perform Database backup and recovery, SQL database on-premise and private data Gateway set-up, and data warehouse modeling for data analysis and machine learning in 27 databases across the Salesforce department.
• Implemented Azure data Factory, data lake storage and deployed SSIS to perform ETL process and to store XML files into Azure for over one hundred tables.
• Worked on performance tuning on databases management, packages, indexes, stored procedures, etc. and optimizing SQL statements using execution plan and adjustment in parameter values to reduce inefficiency, created index, including clustered index, non-clustered index, and covering index to improve query performance.
• Designed, implemented, and supported the environment with OLTP and OLAP data warehouse for over 40 billion records of customer information using views and indexes, multi-dimensional models and Fact tables, Star schema, and so on.
• Performed error handling in T-SQL stored procedures using try/catch, raiserror, throw, etc.

Environment: Python, SQL Server 2017, T-SQL, ER-Win, SSIS, SSRS, Power BI

Confidential, Mahwah, NJ

ETL/BI Developer

Responsibilities:

• Prepared the complete data-mapping document for all the migrated jobs.
• Created T-SQL scripts and 20+ complex stored procedures for data validation and data process tables, and designed T-SQL queries with UDFs, CTEs, table variables, temp tables, etc. to implement business logic.
• Created and altered 30+ tables and views in EMR, departmental and claim data marts. Performed index analysis on tables and provided more efficient solutions to use between different kinds of indexes such as clustered, non-clustered and covering indexes.
• Performed error handling in T-SQL stored procedure using try/catch, raiserror, throw, etc.
• Extract Transform and Load data from Sources Systems to Azure Data Storage services using a combination of Azure Data Factory, T-SQL, Spark SQL and U-SQL Azure Data Lake Analytics. Data Ingestion to one or more Azure Services - (Azure Data Lake, Azure Storage, Azure SQL, Azure DW) and processing the data in In Azure Databricks.
• Created Pipelines in ADF using Linked Services/Datasets/Pipeline/ to Extract, Transform and load data from different sources like Azure SQL, Blob storage, Azure SQL Data warehouse, write-back tool and backwards.
• Defined ETL process by creating 80 SSIS packages for extracting, cleansing, transforming and loading data fromheterogeneous sources such as Oracle, DB2, Sybase, SAP, SQL Server, PSFT in different format such as flat files, Excel, XML into SQL Server data marts.
• Performed initial and incremental load from new incoming data in various data sources for dimension tables and fact tables. Utilized Python to automate various tasks. Used type 2 slowly changing dimension to insert data.
• Performed error handling in event handler, implemented custom logging to output error and record package running information, and achieved performance tuning and troubleshooting.
• Processed data profiling and data cleansing with pre-staging and staging table.
• Implemented various types of SSIS Transformation in packages including Aggregate, Merge Join, Lookup, Conditional Split, Row Count and Derived Column etc.
• Wrote C# in SSIS Script Task component to loop through all email addresses and send customized email, check the existence of the file and check the file size and split large files into small pieces.
• Migrated data from SQL Server to AWS Redshift with SSIS ZappySys PowerPack plug-in, including the amazon redshift data transfer task, amazon redshift executeSQL task, etc.
• Implemented the master child package technique to manage big ETL projects efficiently.
• Achieved performance tuning and troubleshooting in t-Sql and SSIS such as rewriting stored procedure, loading data in parallel and batch size, and rescheduling deploy time.
• Performed unit testing on SSIS packages and collaborated with QA during the testing period such as writing some scripts and testing scenarios for QA.
• Worked with senior Architect and DBA to develop data validation procedures and implement logic required business rules.
• Consistently applied security standards in daily development, administration, and/or solutions where applicable and as set for in the Information Security and HIPAA policies.
• Maintained HIPAA transactions specifically 835 and 837 transaction sets, created the ad hoc reports to query the transaction sets.
• Participated in collaboration opportunities amongst Salesforce and solved technical problems.
• Generated monthly Confidential customer case and attachment volume changing reports with SSRS utilizing techniques such as drill down, drill through, cascading parameters, conditional formatting, custom functions (VB scripts), etc.
• Supported maintenance of existing Confidential customer call and email SSRS reports, including troubleshooting errors, tuning T-SQL stored procedures, redesigning SSRS components, etc.
• Designed KPI, dashboards and ad-hoc reports in support of Salesforce department business by Power BI to gauge customer service history.
• Designed different types of reports such as Up-selling and Cross-selling reports using Power BI, such as last five-year sales static KPI report, regional sales dashboard and patient satisfaction granular filtering.
• Scheduled the delivery of Power BI reports in different formats such as PDF, Excel, using standard and did performance tuning to improve the response times and reduce traffic to the report server.

Environment: SQL Server 2016, T-SQL, ER-Win, SSIS, SSRS, DataStage, and Power BI Desktop

Confidential, New York, NY

ETL/BI Developer

Responsibilities:

• Prepared the complete data-mapping document for all the migrated jobs using SSIS.
• Created T-SQL scripts and 20+ complex stored procedures for data validation and data process tables.
• Created and altered 30+ tables and views in EMR, departmental and claim data marts.
• Designed T-SQL queries with UDFs, CTEs, table variables, temp tables, etc. to implement business logic.
• Performed index analysis on tables and provided more efficient solutions to use between different kinds of indexes such as clustered, non-clustered and covering indexes.
• Defined ETL process by creating 80 SSIS packages for extracting, cleansing, transforming and loading data fromheterogeneous sources such as Oracle, DB2, Sybase, SAP, SQL Server, PSFT in different format such as flat files, Excel, XML into SQL Server data marts.
• Performed initial and incremental load from new incoming data in various data sources for dimension tables and fact tables.
• Used type 2 slowly changing dimension to insert data.
• Used C# in SSIS Script Task component to convert datatypes.
• Performed error handling in event handler, implemented custom logging to output error and record package running information, and achieved performance tuning and troubleshooting.
• Processed data profiling and data cleansing with pre-staging and staging table.
• Implemented various types of SSIS Transformation in packages including Aggregate, Merge Join, Lookup, Conditional Split, Row Count and Derived Column etc.
• Implemented the master child package technique to manage big ETL projects efficiently.
• Achieved performance tuning and troubleshooting in t-sql and SSIS.
• Worked with senior Architect and DBA to develop data validation procedures and implement logic required business rules.
• Designed KPI, dashboards and ad-hoc reports in support of physicians, health center and actuarial department business by SSRS to gauge patient clinical history and health plan sales.
• Designed different types of reports such as drill down, drill through, sub and linked reports using SSRS, such as last five-year sales static KPI report, regional sales dashboard and patient satisfaction granular filtering.
• Used Report Manager for setting up roles and security on the reports.

Environment: SQL Server 2016, T-SQL, ER-Win, SSIS, SSRS, and Power BI Desktop

Confidential, Dallas TX

ETL/DW developer

Responsibilities:

• Designed databases (physical and logical) to meet business requirements using ERWIN.
• Create various data marts such as user, contact, delinquency and from scratch by taking into various business processes by identifying different dimensions and facts from existing data warehouses.
• Designed new database objects like stored procedures, functions, triggers, indexed, tables and views, table-valued and scalar functions using T-SQL in a development environment.
• Created stored procedures for reporting on audit information and error information during each ETL process.
• Handling query optimization and performance tuning using Execution Plan, SQL profiler and database tuning advisor (DTA).
• Designed and Implemented ETL tasks by creating 130 packages for the credit department and private banking department.
• Create packages with several transformations in each package making sure that the data is cleaned and confirmed before being sent to the staging area.
• Reran the failed SSIS packages using checkpoints and scripting with C# in SSIS.
• Complete complex ETL packages to pull data from DB2/Oracle, loading monthly data from Excel to SQL Server. Utilized Python and IBM Urbancode.
• Implemented error handling and failure in SSIS packages using event handler, row redirects, check points and used logging for monitoring the execution.
• Implemented proper package configuration features and finally securing the package by using password and encryption methods.
• Enabled checkpoints on ready implemented transactions to optimize the entire ETL strategy so as to start the package execution from the latest point of failure.
• Promoted database objects from test/development to production server by coordinating and communicating with production schedules within the development team.
• Created different types of reports like drill down, drill through, sub-reports and parameterized reports.
• Designed reports to include charts and logos that complies with organization culture and policies of reporting and documentation.
• Design and development of a reporting data module for Credit Card Marketing Analytics.
• Creating Row level security with power bi and integration with power BI service portal.
• Developed analysis reports and visualization using DAX functions like table function, aggregation function and iteration functions.
• Worked on all types of transformations that are available in Power BI query editor.

Environment: SQL, Power BI, DAX, SSIS, Oracle, Python, ETL