SUMMARY:

• Data/Business/Analytics/Science Professional offering 8+ years of successful experience in designing, developing, and implementing data - driven solutions to support Healthcare
• Customer relationship management-oriented research projects and Business processes. Expert in statistical modeling, interpreting, and analysing data utilize advanced data analytics and visualization tools. Excellent understanding of business operations and analytics tools for effective analyses of data.

TECHNICAL SKILLS:

• MS SQL SERVER 2019/2017/2016/2014/2012/2008 R2/2008 *R Programming * R Studio *Azure Machine Learning * Tableau * QlikView * Python * PowerBI * Qlik *Microsoft Office * MS-Access * Java script * Oracle Database Design and Modeler * Microsoft Suite * STATA * EVIEWS * SPSS *
• Jupyter * MATLAB * MS SQL SERVER Management Studio * Business Intelligence Development Studio * U-SQL * Azure Data Lake Storage (ADLS) * Azure Data Lake Analytics (ADLA) * Azure Data Factory (ADF) * Logic Apps * Microsoft Flow * Apache Spark * Jupyter * PySpark * Scala
• Azure Databricks * SQL Server Enterprise Manager * Oracle * Teradata * DB2 * C++ * T-SQL * PowerBI Desktop * PowerBI Service * PowerBI
• Pro * PowerBI Premium * PowerApps * PowerBI Report Builder * Tableau Desktop * Tableau Server * Tableau Prep * MS Excel * DTS * SQL
• Server Integration Service (SSIS) * SQL Service Analysis Service (SSAS) * SQL Server Reporting Service (SSRS) * SQL Server Mobile Report Publisher * SQL profiler. *GCP *looker

PROFESSIONAL EXPERIENCE:

Confidential

Data Engineer/Power BI developer

Responsibilities:

• Developed and Implemented Operational data store with continuous and scheduled data ingestion.
• Developed Linked reports for live data and Migrated SSRS ad-hoc reports to Power BI reports using Report builder.
• Developed complex SQL queries with T-SQL and automated these extracts in Alteryx.
• Created Azure Data Factory Pipeline to load data from On-premises SQL Server to Azure Data Lake store.
• Created notebooks in Azure Databricks to transform data using Pyspark.
• Developed reusable notebooks in Azure Databricks with parameterized variables to use with ETL pipelines
• Migrated On-prem SSIS package solutions to ADF.
• Ingesting Parquet files using ADF from multiple sources and loaded data into ADLS (Azure data lake Storage) using Pyspark in Databricks.
• Performed parsing JSON files to create at datasets using Pyspark.
• Performed ELT while ingesting raw data from multiple CRM systems to Snow ake and performed transformations using DBT and FiveTran.
• Developed and build data integration pipeline architecture and ensure successful creation of theinfrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using python, SQL.
• Created functions in notebooks for capturing audit details like row counts and call these from ADF.
• Well acquainted with Work ows and Unified Modeling Language (UML) diagrams such as, Use case diagrams, Activity Diagrams, State, Collaboration / Sequence Diagrams.
• Expert in Tracking and managing the requirements using Requirement Traceability Matrix (RTM) thatlinks and controls numerous artifacts produced by several teams across the project.
• Worked with various RDBMS like Oracle, SQL Server with experience in extracting, transforming, and loading (ETL) data from spreadsheets, database tables and other sources.
• Preformed extensive customizations throughout multiple deployments in numerous instances ofMicrosoft Dynamics 2011, 2013, 2015, 2016 8.X and Dynamics 365 9.1 to meet specified business requirements spanning numerous industries in small to large businesses and government sectors
• Expertise in handling solutions with related to technologies like, MS Dynamics 365, Power Platform.
• Extensive experience in SharePoint 2010/2013/2016/2019 and Office 365 including installation, development, administration, upgrades, and migrations.
• Very Strong understanding in HRIS.
• Experience in technical and business writing including current and future business process modeling/ re-engineering, business requirements documents, business requirements mapping.
• Extensive experience in aspects such as writing User Stories, Test Strategies, Test plans, Test cases,Defect reports, Traceability Matrices and Test Environments.
• Extensive working experience using JIRA, ALM.
• Experienced in defining Testing Strategies with Technical Team (IT Lead) and Line of Business Team (LOB Lead).

Confidential

BI Developer

Responsibilities:

• Regularly assisting with SQL scripts and ETL process to meet Sales Department reporting needs and automating the analytical reports by creating dashboards using Tableau.
• Developing End to End Analytical environment using Power BI.
• Transforming and Migrating the SSRS reports to Power BI paginated reports as a part of holistic Analytical framework.
• Mentoring stakeholders on Power BI processes and procedures and best practices.
• Regularly used Data Analysis Expressions (DAX) functions to dynamically express, calculate, and return findings in a scalable way.
• Implemented CI/CD for the Power BI reports in the Azure Repos for the Leadership at Stripe
• Hands on experience in creating tables, indexes
• Extensive experience with SQL Server and T-SQL in constructing tables, user functions, views, indexes, user profiles, relational database models.
• Expertise in Backup Maintenance, Backup Strategies in Production, Development Environments.
• Monitoring, Scheduling SQL Jobs and troubleshooting failed jobs.
• Experience in Log file behavior & Disk Space Issues.
• Experience in Database Mirroring, Log Shipping for high availability.
• Expertise in creating Clustered Indexes, Non-Clustered Indexes, and handling Index fragmentation.
• Monitor Database performance using Activity monitor, DMV's etc.
• Experience Database Security like creation of logins, users and handling roles and permissions on database objects.
• Experience in Installation, Upgrade & Migration.
• Experience in resolving SQL Server Database locks and hardware-related issues, using SQL Server Profiler and SQL Server Query Tuning & Diagramming where necessary, to resolve Performance slow- downs due to blocking and other index issues, etc.
• Hands on experience to identify SQL Server Procedures that took longer time for execution andimplemented tuning methodologies.
• Hands on experience in creation of Packages using SSIS.
• Hands on experience in creation of custom reports using SSRS.
• Performed data integrity checks and informing data teams and SME to ensure the functional requirements documentations were updated.
• Strong knowledge about Data modelling techniques and developed Designs using Erwin Data modeler

Confidential

Database Administrator

Responsibilities:

• Creating Database Objects like Procedures, Views, functions, and Tables.
• Copying XML data files and Importing Data from XML files into SQL SERVER database using SSIS.
• Wrote many scripts for fitting data as per table structure.
• Moving data files into SFTP server using SSIS packages.
• Repeating same steps for various products.
• Analysing functional requirements and modelling the database tables and relationships to re ect optimal and easily retrievable database structure Designing the MDM for clients
• Designing of the ETL work ow including data load from source to landing layer
• Developed Internal Reporting Dashboards Using Tableau and Automated the data ows using Alteryx.
• Perform end to end Data validation to maintain accuracy of data sets
• Lead discussions with business partners to identify functional requirements resulting in data acquisition for BI applications and converted business logic from SQL database into Alteryx in a quick and accurate manner.
• Developing the Code
• Design of Test Cases
• Coordinating with onshore point of contact on UAT, bug fixes and enhancements

Confidential

Data Analyst

Responsibilities:

• Obtained CMS patient’s healthcare costs data from multiple sources, compiled and Validated for Data analysis and Performed Data Cleaning and Transformation using MS SQL Server; analysed data using SAS enterprise miner.
• Built predictive models using di erent techniques like Linear Regression, Multiple Regression and
• Performed Regression analysis and built a score analysis tool with healthcare clinical dataset.

Confidential

Database Administrator

Responsibilities:

• Creating Database Objects like Procedures, Views, functions, and Tables.
• Copying various source data files and Importing Data from various source files into SQL SERVER database using SSIS.
• Wrote many scripts for fitting data as per table structure.
• Moving data files into SFTP server using SSIS packages.
• Repeating same steps for various products.
• Created many reports as per client need and enhancing the extended support for smooth process