SUMMARY

• 8 years of IT experience in large scale data analytics,data visualization, design and development of windows and web applications, databases and automation in Insurance domain.
• Expertise in streamling data flows and models, improve consistency, quality, accessibility, and security, unify data architecture, remove unnecessary costs, and, optimize database activity across company needs.
• Expertise in building and test data models of various business data, applications and database structures to meet project goals.
• Well experienced in data analysis and design skills using using Power BI, Google sheets and Tableau.
• Good at analyzing and synthesizing a wide range of big data into valuable insights by data extraction, transformation and loading into tool and visualize using BI tools.
• Expertise in Power BI admin and developing custom Power BI reports using Power query, SQL, dataflows and advanced DAX.
• Expertise in implementing star and snowflake schemas using Power BI.
• Proficient in Data Transformation, Data Architecture and Modeling,Microsoft BI stack, including SQL, PowerBI, Power Query, DAX, M, and, SSAS, SSRS, SSIS.
• Expertise in configuration / management of Microsoft Power BI Service also extracting, manipulating and analyzing data via Dataflows, Datamarts, Dashboards.
• Experienced in advanced level of MS Excel skills with knowledge of functions, macros, and VBA programming.
• Strong RDBMS skills SQL querying, writing stored procedures, triggers, functions, views, user privileges, object privileges, etc.
• Expertise in database, datamodeling, dataflows, datapipelines and data warehousing methodologies including snowflakes concepts.
• Expertise in statistical data analysis and data mining packages (R, Python) and Machine Learning Services.
• Expertise in SQL, data modelling and data warehousing methodologies.
• Worked with SQL queries across multiple database and applications.
• Well experienced in implemented ETL and .net frameworks.
• Expertise as Azure cloud and configuring virtual Machines,Azure logic apps.
• Experienced in analysis, design, development of window and web based application using Microsoft technologies like Windows, C#. NET,Html, Css, Javascripts and python in Visual studio.
• Experienced in working with Data Scientists to ensure the source data is aggregated and cleansed to define robust architecture in cloud setup pipelines and workflows.
• Experienced working with various data sources, including SQL Server,Oracle, Excel, Azure SQL, SharePoint, and Azure DevOps REST APIs.
• Experienced in improving SQL server performance using performance monitor, index tuning wizards, SQL profiler, Database engine tuning advisor.
• Experienced working with waterfall and agile SDLC methodologies.
• Good exposure in functional and technical documentation and creating POC’s for the projects.
• Good knowledge in Big Data technologies like Hadoop, Hive, Spark, python, scala etc.
• Good knowledge and experience with robotics process automation tools.
• Good at analytical and problem - solving skills, motivated and strong independent contributor.

TECHNICAL SKILLS

Languages: C, C#.net, R, M, Python, Javascript

BI Tools: R Studio, Power BI, MS Excel,Google Sheets,SSRS.

Databases: SQL Server, My SQL Workbench, Oracle, Azure SQL

Web Technologies: HTML, CSS, JSON, XML, PHP

Defect Tracking Tools: JIRA, Redmedy

Operating Systems: Windows, Linux

Source Control: Tortoise SVN, GitHub, TFS, SourceTree

PROFESSIONAL EXPERIENCE

Confidential, Portland, Maine

Sr. Power BI Developer/ Data Engineer

Responsibilites:

• Working with business product owners, develop Power BI reports and setup Power BI environments based on the client requirements.
• Converting business requirements into technical specifications and decide timeline to accomplish.
• Migrating PHP reports to Power BI.
• Developing and Implementing Power BI and Google sheets reports end to end to resolve business problems ensuring high performance and scalability.
• Designing data by ETL and utilized advance analysis actions, calculations, parameters, background images, maps, trend lines, groups, hierarchies, detail level summary report sets, and KPI dashboards.
• Integrating reports to CRM application built on .net framework.
• Creating python scripts and power automate workflows to design AI solutions.
• Publishing reports on Power BI cloud services, deploy pipelines and workspace management.
• Installed enterprise gateway in a standalone server and scheduled daily refresh for reports.
• Maintenance and support on database and reports and working on ad-hoc requests.
• Creating database objects and developing procedures for implementing complex functionality at the database side for reports performance enhancement.
• Designing and maintaining efficient data models, schemas(star and snowflakes), and database structures to optimize storage.
• Creating Power BI Tabular model, DAX measures, reports, and Apps for operational reporting and KPI dashboads.
• Developing and maintaining ETL processes using Azure Data Factory.
• Creating reports using SSRS,excel services, Power BI and deployed in sharepoint server.
• Code reviewing and bug fixing in the database and reports.

Environment: Power BI Desktop, Power BI Cloud service, DAX, Power query, Power Automate, Google Sheets,C#.net, Visual Studio, HTML, CSS, SQL Server, Snowflakes, SSIS, SSRS,Azure SQL, PHP, Python, SharePoint, JIRA.

Confidential, Richmond, VA

Power BI Developer/Admin

Responsibilites:

• Created POC's and demo it to clients for project Implementation.
• Analyzed business requirements and create technical design documents.
• Created dashboards and interactive visual reports using Power BI.
• Integrateed high performance and highly scalable custom machine learning models into UI applications using Azure Machine Learning services.
• Created paginated reports using Power BI Report builder.
• Created and re-used DAX queries to power a new intelligent application by monitor the performance of existing datasets as part of the integration.
• Developed python scripts and components to support custom reports.
• Designed database schemas, SQL queries and procedures to retrieve data in front-end applications with proper tuning techniques.
• Ensure data quality and consistency across multiple data sources.
• Created SSIS packages to validate ETL data to datawarehouses database.
• Developed SQL scripts to support data integration, manipulation, and transformation.
• Code review, troubleshooting and bug fixing in the application.
• Worked with users and team members at all level for performance improvement and suggestions.

Environment: Power BI, Power BI admin, R, DAX, Azure, Python, SQL Server, Toad Data Modeler,SSIS, Github, AWS.

Confidential, Virginia Beach, VA

Power BI Developer

Responsibilites:

• Developed proof-of-concepts.
• Requirements gathering, solution designing, coding, testing, documentation and implementation using Power BI desktop and Power BI cloud service.
• Analyzed data and presented data through reports that aid decision-making.
• Designed dashboards and reports in accordance with standard platform design principles and conventions.
• Performed Row level Security(RLS) to create role based access to certain group.
• Created DAX queries and functions in Power BI.
• Integrated reports into sharepoint application.
• Built multi-dimensional data models.
• Designed new systems by analyzing current ETL processes.
• Used Python libraries - Pyspark, Pandas, Numpy, SqlAlchemy,Pyodbc etc. to build financial report.
• Created scripts and procedures in SQL for better code reusability and invoke custom code within process automations.
• Solved day to day technical issues arising while running robotics processes and provide timely resolutions using SiteScope monitoring tool.
• Troubleshooting and bug fixing.

Environment: Power BI, DAX, Visual Studio,Webservices,SQL Server, Python, SiteScope, JIRA, Git, Sourcetree, SDLC-Agile.

Confidential, Washington, DC

Database Developer

Responsibilites:

• Analyzed functional and business requirements.
• Created tables, stored procedures, views, functions, triggers according using MySQL and update in production database.
• Optimized queries and performance tuning using SQL Profiler and Index Tuning Wizard.
• Developed logical/physical data models by reverse engineering using Toad Data Modeler.
• Generated data analysis, graphics and statistical analysis reports using SSRS and Implemented custom stored procedures.
• Generated data modeling designs using Toad Data Modeler.
• Coordinated with datascience departments to establish business needs and better understanding of data for developing real time analytical models.(R-Studio).
• Applied SQL patches on cluster and standalone machines.
• Developed OLTP schemas and comprehensive testing plans for validating data transformation and integration to ensure integrity on data architecture.
• Developed and reviewed simultaneous SQL queries with the use of join clauses (inner, left, and right) in Tableau desktop to validated static and dynamic data for data validation.
• Database migration and maintenance.
• Trouble-shooting and bug fixes.

Environment: MySQL, Workbench, Tableau, Toad Data Modeler, R Studio, SSRS, Python, JIRA, SharePoint, Tortoise SVN, SDLC-Agile.

Confidential

Data Analyst

Responsibilites:

• Worked with BA’s and gather requirements and build technical design documents.
• Reviewed and analyzed large datasets related to identify trends and insights using R and machine learning.
• Forecasted the demand on client’s sales data using various forecasting methods and calculated the minimum investment required using optimization methods in MS Excel.
• Implemented indexes such as clustered index, non-clustered index on data structures to achieve faster data retrieval.
• Reprogrammed existing Oracle databases to improve functionality.
• Created weekly report for design and testing data processing procedure.
• Used Oracle and Excel for data analysis with inbuilt functions.

Environment: R Studio, Python, Spark, Oracle, MS Access, MS Excel, TFS, SDLC-Waterfall.

Confidential, Cincinnati, OH

Tableau Developer

Responsibilites:

• Developed and deployed business intelligence solutions as per needs.
• Performed data validation, cleansing, and preprocessing to ensure data quality and accuracy.
• Developed and analyzed data patterns and provided insights of forecast on client’s data-sets using Tableau to support business decision-making.
• Designed set of decision trees and statistical models to generate rules for classification of data sets.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps using show me functionality.
• Coded data migration, data fixes, index tuning and query optimization, designed relational databases.
• Developed dashboards in R studio providing insights into the client data.
• Built ad-hoc Business Objects and Web Intelligence Reports to query databases using SQL.
• Developed desktop applications using C# to display optimized data in the grid view for xml data.
• Troubleshoot data issues in reports and modify database Views as needed.

Environment: Tableau, R Studio,C#.net, SQL Server, Remedy tool, TFS, SDLC-Agile.

Confidential

Python Developer

Responsibilites:

• Developed application using python for Embedded Systems.
• Forecasted data and create reports for sales data using python scripts .
• Created stored procedures and SQL queries as per the requirements.
• Updated exisintg code to scalable code using Python programming language.
• Integrated data storage solutions by coordinating with front-end developers.
• Built application on microservice architecture like RestAPI etc.
• Developed Python APIs.
• Consumed APIs while utilizing requests to read numerous JSON reports and file automatic bugs for tests.
• Designed a data dictionary generator that creates documentation for developers as spreadsheets and webpages.
• Developed data structures and xml parsing using Python.
• Performed Break/Fix work on reports.

Environment: R Studio, Python, SQL Server, APIs,JSON.