BI Developer

Radhika Mahesh Gupta

Email: ****************@*****.***

Mobile: 832-***-****

Professional Summary:

● Motivated and results-driven BI developer with proven track record in Business Intelligence, Data Analyst and Quality Analyst role. Proven ability to identify business needs and develop valuable solutions to drive efficiency and process improvements

● 5 plus years of work experience as a Business Intelligence and Data Analyst utilizing Power BI, SQL Server, SSIS/SSRS/SSAS, Python and AWS

● Have played hands-on roles across the various stages of the implementation-lifecycle: Requirement Gathering, Design, Systems Integration, Development of Analytic applications, Reporting, Training and End- user support

● Experience in developing, implementing, documenting, monitoring and maintaining the data warehouse extracts, transformations and ETL processes in various industries like Insurance, Finance and Logistics

● Proficient across entire Microsoft BI suite of products including SQL Server, SSIS, SSRS, SSAS, Excel, Access DB and Power BI SDLC from prototyping to deployment

● Experience with AWS services (S3, EC2, Redshift, ELB, EBS, Route53, VPC, Auto Scaling, Glue and Lambda etc.) and deployment services (Lambda and Cloud Formation) and security practices (IAM, Cloud Watch and Cloud Trail)

● Working experience of statistical analysis using Python and libraries such as Pandas, matplotlib, PIL

● Experience with Python packages such as NumPy, SciPy, PySpark and graph frames

● Experience working with Web languages such as C#, html, CSS, etc

● Experience working with Version Control tools (Microsoft TFS and Git)

● Experience working in Agile Scrum Software Development

● Experience with various software methodologies such as Agile, SDLC and Waterfall

● Experience in all stages of SDLC from Requirements Gathering, Analysis, Design, Development, Testing and Deployment

● Strong understanding of how analytics supports a large organization including being able to successfully articulate the linkage between business objectives, analytical approaches & findings, and business decisions.

● High Proficiency in Excel including complex data analysis and manipulation

● Good oral and written communication skills

● Strong interpersonal skills to successfully build long-term relationships with colleagues and business partners

● A results-driven individual with a passion for data/analytics who can work collaboratively with others to solve business problems that drive business growth

● Demonstrated leadership and self-direction. Demonstrated willingness to both teach others and learn new techniques

● Ability to work with managers and executives to understand the business objectives and deliver as per the business needs and a firm believer in teamwork

Technical Skills:

BI Tools Power BI, SSIS, SSRS, SSAS

Programming & Scripting Languages Python, C#, C++, HTML, CSS, API Database SQL, MySQL, MS Access, SSMS, Postgres, Redshift, Oracle Development Tools Visual Studio, PyCharm IDE, Jupiter, Sublime Text Version Control Git, Team Foundation Server

Web server IIS, Apache/Apache2

Packages Django, NumPy, SciPy, Pandas, matplotlib, PIL Business Analysis ● Requirements Engineering, Business Process Modeling & Improvement

Cloud ● AWS (EC2, S3, RDS, EBS, VPC, IAM, Security Groups, Code- Build, Lambda, Glue, CI/CD, Redshift), Azure

Operating Systems ● Microsoft windows 7/8/8.1/10/Vista/XP, Linux (Ubuntu) Education, Certificates & Trainings:

o Masters of Engineering, University of Houston - 2016 o Bachelors in Engineering, Nagpur University - 2011 o Microsoft Power BI Udemy Certified

o AWS Solutions Architect Associate Certified

o Python for Data Science and Machine Learning Udemy Certified Experience:

Power BI/AWS Developer Oct 2019 – Present

Adept Minds LLC

Houston, TX (Remote)

● Collaborated with senior management, subject matter experts, and IT teams to define business requirements

● Transformed business requirements into functional and nonfunctional requirements

● Designed, developed, and tested the ETL strategy to populate data from multiple source systems

● Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards

● Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPIs such as billing hours and finance along with slicers and dicers enabling end-user to make filters

● Generated ad-hoc reports in Excel Power Pivot and shared them using Power BI to the decision makers for planning

● Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging

● Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI

● Utilized Power BI Amazon Redshift connector and gateway to keep dashboards and reports up to-date with data sources

● Provisioned VMs with SQL Server on cloud utilizing AWS and setting up communication with the help of endpoints

● Perform thorough unit testing on all relevant platforms to ensure proper implementation

● Responsible for launching Amazon EC2 instances (Windows & Linux)

● Created roles for EC2, S3 and EBS resources to communicate within the team using IAM

● Responsible for S3 bucket creation, policies and the IAM role-based policies and creating alarms and notifications for EC2 hosts using Cloud Watch

● Extensive data cleansing and analysis, using pivot tables, formulas (V-lookup and others), data validation, conditional formatting, and graph and chart manipulation using MS Excel

● Verify that the proper files are uploaded into the right GIT repositories

● Collaborate with technical and non-technical resources across the business to leverage their support and integrate our efforts

● Coordinated and monitored the project progress to ensure the timely flow and complete delivery of the project

● Training and Testing of Data under data modelling process BI/ Quality Analyst Feb 2017 – Sept 2019

The Woodlands Financial Group

The Woodlands, TX

● Involved in all stages of the project; from requirement gathering, defining requirement, project planning, development, production implementation to end-user training for an Insurance policy application

● Responsible for Retrieving data using SQL Queries from the application database and perform Analysis enhancements

● Undertook user stories (tasks) with critical deadlines in Agile Environment using TFS

● Involved in Analyzing system failures, identifying root causes, and recommended course of actions

● Responsible for Testing and Modelling the data in order to migrate it to production environment

● Make sure that all the requirements are gathered before working on the data and collecting valuable information from the super users (customer)

● Designed and developed ETL SSIS packages to facilitate incremental load process

● Retrieve data from various files such as .xls, .csv using SSIS

● Migrated existing self-service reports and adhoc reports to Power BI

● Transitioned business critical slow performing legacy report from SSRS to Power BI

● Developed Power BI dashboards to track policy details, drill down visualization by different states for policy details, cancellations and reinstatement

● Custom calculated measures using DAX in Power BI to satisfy business requirements

● Performing Exploratory Data Analysis on the data provided by the Client

● Providing support to existing SSRS reports utilized by the business

● Conducting Root Cause Analysis independently/collaboratively in resolving issues

● Responsible for making sure that the data is accurate with no outliers

● Used advanced Microsoft Excel functions such as Pivot tables and VLOOKUP in order to system the data and prepare programs

● Performed various statistical tests for clear understanding of the client requirements

● Provided training to Beginners on the application system and other basics

● Actively involved in Analysis, Development and Unit testing of the data and delivery assurance of the user story in Agile Environment

● Involved in developing test cases for Unit, System, Integration and User Acceptance Testing Associate BI Developer

Integra Technologies LLC August 2016 – Feb 2017

Houston TX (Remote)

● Participated in discussions with Group Members and Technical Manager regarding Business Requirement for supporting and enhancing intranet Travel portal

● Developed SSIS packages to Extract, Transform and Load (ETL) data into the data warehouse database from heterogeneous databases/data sources

● Create new SSIS Packages to export flat files

● Write Stored Procedures, Triggers, Functions and T-SQL Queries to capture updated and deleted data

● Used different data Transformations like Lookup, Derived Column, Conditional Split, data conversion while creating the SSIS Packages

● Created Ad-Hoc Reports, Sub Reports and Summary Reports using SSRS

● Effectively handled data errors during the modification of existing reports and creation of new reports

● Export and import data from CSV files, Text files and Excel Spreadsheets by creating SSIS Packages

● Scheduled Jobs and Alerts using SQL Server Agent

● Creating, maintaining the users, roles and granting privileges

● Worked with various Python Frameworks such as Django in automation

● Worked with different REST API’s such as POST and GET to fetch and publish data

● Used various color combinations in CSS and implemented them in the HTML page

● Worked with Different data types in Python such as Vectors, Lists, Matrices, Arrays and Data Frames

● Perform data visualization using matplotlib library function in Python to create Histograms, Pie charts, Bar charts, scatter plots etc

● Responsible for creating Repositories in Git for a new user story

● Worked with various data types in Python such as Strings, Lists and Dictionaries

● Used various libraries and packages in Python such as Pandas, NumPy, SciPy, scikit-learn for reading, writing, calculations and modelling

● Assist in daily standup meetings for daily updates and roadblocks Accenture August 2011 – May 2014

Mumbai, India

Role: Software Engineering Analyst

● Actively involved in all stages of the project lifecycle, from system analysis, business, functional, technical requirements gathering, development, testing and deployment for Insurance claims portal

● Responsible for collecting and transforming claims data from database using SSIS

● Prepared dynamic claims reports of insurance claims details using SSRS

● Implemented discretization and binning, data wrangling: cleaning, transforming, merging and reshaping data frames

● Integrated applications with designing database architecture and server scripting, studying & establishing

● Designed SSAS Cube and developed MDX queries for Analysis

● Created database-using SSMS and wrote several queries to extract data from the database

● Created test cases during monthly sprints using agile methodology

● Involved in identifying test scenarios and test cases to be tested for a release

● Created test automation scripts using HP QTP and Duckcreek’s Test Automation Center (TAC) Tool

● Worked on Accenture - Duckcreek’s Claims Component System

● Worked on test management tools like Unified Functional Testing (UFT), Application Lifecycle Management(ALM) and Microsoft Test Manager(MTM)

● Lead the maintenance team and certified various release

Contact this candidate