SUMMARY

• Over 5+ years of IT experience as a Data visualization, Database Design and Business intelligence, Advanced T - SQL skills with a good knowledge on machine learning technologies R and Python
• Hands on Experience in Tableau 9/10, T-SQL, SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) and Power BI.
• Worked with DBAs to implement table partitioning and partition switching for large data volume loads.
• Proficient in T-SQL programming.
• Expert in creating Views, Indexes, Triggers, Stored Procedures, User Defined Functions (UDFs), Derived Tables, and Common Table Expressions (CTEs).
• Excellent T-SQL development skills to write complex queries involving multiple tables, great ability to develop and maintain stored procedures, triggers, user defined functions.
• Experience in Performance Tuning and Query Optimization.
• Used stored procedures, wrote new stored procedures, modified existing ones, and tuned them such that they perform well.
• Used indexes to enhance the performance of individual queries and enhance the Stored Procedures.
• Extensively used Joins and Subqueries to simplify complex queries involving multiple tables and established relationships between tables using Primary Key & Foreign Key Constraints.
• Built dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices using Tableau
• Developed and maintained Power BI multiple Dashboards/reports and content packs.
• Responsible for building Dashboards using Tabular and Multidimensional Models.
• Design and model data sets with desktop based on measure and dimension requested by customer and dashboard needs using Power BI
• Implemented various machine learning algorithms such as regression, cluster analysis, neural networks to predict future sales’ performance
• Experienced in requirement gathering/analysis, design, development, testing, and production rollover of reporting and analysis projects
• Developed Tableau visualizations, Dashboards, Workbooks using Tableau Desktop using Data Blending
• Understand the Requirements and Functionality of the application from specifications
• Designed, developed, tested, and maintained SSRS reports based on user requirements.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop-down menu option and Parameters using Tableau.
• Scheduled Jobs for executing the stored SSIS packages, which were developed to update the database on a Daily basis using SQL Server Agent.
• Experience in publishing Desktop reports created in Report view to the Power BI service.

TECHNICAL SKILLS

SQL Server Tools: SQL Server Management Studio, T-SQL, SSIS, SSRS, SQL Profiler, Query Analyzer

Data Mining Tools: Eviews, Advanced MS Excel

Languages: R, Python, T-SQL, C,MySql,Hive

Visualization Tools: Tableau 8, 9, 10, SSRS, Power BI

Machine Learning Techniques: Regression models-Linear and Log, Neural Network, Cluster Analysis, Conjoint Analysis, Sentiment Analysis

PROFESSIONAL EXPERIENCE

Confidential, North Reading MA

Business Intelligence Engineer

Responsibilities:

• Collaborated with senior management, and IT teams to define business requirements.
• Interacted with the business users for understanding the business requirements and the existing system.
• Knowledge on Configuration and maintenance of physical standby database for no data loss.
• Translated business requirements into workable functional and non-functional requirements at detailed production level using workflow diagrams, sequence diagrams and Use Case Modelling.
• Fetched the data from different sources like SharePoint. Able to load data from Excel, Flat Files, XML, Azure and various other databases.
• Extensive experience in Application Development, Database developmentand24x7production system support handling large databases using Oracle 12c, 11g, 10g, 9i on various platforms like AIX, Solaris, Red hat EL, UNIX andWindows.
• Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
• Imported data using Azure Data Link (ADL) to SQL Server in Power BI to generate reports.
• Utilized Power BI Gateway to keep dashboards and reports up to-date with on premise data sources.
• Developed Microsoft Power BI Dashboards to showcase the result of data analysis from the database.
• Developed Tabular Reports, Sub Reports, Matrix Reports, drill down Reports and Charts using SQL Server Reporting Services (SSRS)
• Involved in creating MDX, DAX, Cubes and Tabular models using SQL Analysis Services (SSAS) .
• Used different types of visualization (Stacked bar Chart, Clustered bar Chart, Scatter Chart, Pie Chart, Donut Chart, Line & Clustered Column Chart, Map, Slicer etc.) in Power BI according to the requirements.
• Generated dashboards in Power BI Desktop and Power BI Service using latest data visualization features.
• Integrated custom visuals based on business requirements using Power BI desktop for better clarity of information.
• Migrated existing QlikView reports to Power BI reports.
• Created Drill down Reports, Summary Reports, Linked Reports and sub reports by region, year, quarter, month and week for different departments.
• Practical knowledge on Azure related data management and good exposure to Python.
• Using Team Foundation Server (TFS) for managing source code changes.
• Managing physical structure of Oracle database like Data files, Redo logfiles and control files.
• Implemented dashboards and scorecards with power pivot for executive management for data insights as per business requirements.
• Involved in Application and Database Migration as part of company initiative Global Data Center Migration Program (GDCP)

Environment: SQL Server, Database, SQL Server Management Studio (SSMS), Database, Visual Studio, SSAS Tabular Cubes, T- SQL, Excel, DAX, SSIS, Business Intelligence Development Studio (BIDS), TFS, Database, Azure Analysis services (AAS) and Power BI.

Confidential, Claremont, NH

Data Reporting Analyst

Responsibilities:

• Designed highly available, cost effective and fault tolerant systems using multiple EC2 instances, Auto Scaling, Elastic Load Balance and AMIs.
• Built a solution using Azure managed services and Blob storage to archive on-premises data to cloud.
• Experience in designing and deploying AWS Solutions using EC2, S3, EBS, Elastic Load Balancer (ELB), Auto scaling groups.
• Responsible for Design and architecture of different Release Environments for new projects.
• Worked at optimizing volumes and EC2 instances and created multiple VPC instances.
• Expert in Azure infrastructure management ( Azure Web Roles, TFS/TFVC, Azure DevOps, Worker Roles, SQL Azure, Azure Storage, Azure AD Licenses, Office365)
• Continuously managed and improved the build infrastructure for global software development engineering teams including implementation of build scripts, continuous integration infrastructure and deployment tools.
• Experience involving configuring S3 versioning and lifecycle policies to backup files and archive files in Glacier.
• Utilize Amazon Glacier for archiving data.
• Experience in Creating the CI/CD Azure DevOps Pipeline for the .Net, java & UI based Web Applications.
• Implemented new projects builds framework using Jenkins &maven as build framework tools.
• Experience in System monitoring with Nagios.
• Migrating virtual environments VMWare to Azure cloud using ASR
• Installed, configured and maintained web servers like HTTP Web Server, Apache Web Server on Red Hat Linux, Ubuntu, Fedora,CentOs.
• Experience in Continuous Integration (CI) and Continuous Deployment (CD) using Jenkins.
• Used Puppet server and workstation to manage and configure nodes.
• eveloped Azure PaaS services including WebJobs, Azure SQL, Azure BLOB storage, Azure Application Insights,
• Azure Data Factory, Azure functions, Azure BOT Service, Azure Active Directory, Azure Stream Analytics, Azure CDN
• Experience in writing Puppet manifests to automate configuration of a broad range of services.
• Prepared projects, dashboards, reports and questions for all JIRA related services.
• Generated scripts for effective integration of JIRA applications with other tools.
• Configured plugins for the integration tools to the version control tools.
• Worked with development/testing, deployment, systems/infrastructure and project teams to ensure continuous operation of build and test systems.
• Implemented high availability with Azure Classic and Azure Resource Manager deployment models
• Defining Release Process & Policy for projects early in SDLC.
• Branching and merging code lines in the GIT and resolved all the conflicts raised during the merges.
• Supported different projects build & Release SCM effort e.g. branching, tagging, merge, etc.
• Highly skilled in the usage of data center automation and configuration management tool such as Docker.
• Performed Deployment of Release to various QA &UAT environments.
• Responsible for installation and upgrade of patches and packages on RHEL5/6 using RPM &YUM.
• Hands on Experience in migrate an On-premises Instances or Azure Classic Instances to AZURE ARM Subscription with Azure Site Recovery.

Environment: AWS, S3, Azure, EBS, Elastic Load balancer (ELB), Auto Scaling Groups, VPC, IAM, Cloud Watch, Glacier, Azure, Jenkins, Maven, Subversion, Ant, Bash Scripts, Git, Azure, Docker, Jira, puppet.

Confidential, Boston, MA

Data Science

Responsibilities:

• Analysis of 400 Web applications data using data mining techniques and Meta-Analysis to measure the effectiveness of application’s performance, to decrease churn rate and increase session length.
• Develop Tableau dashboards that provide clear visualizations of various Adobe analytics and google analytics data.
• Access and transform massive datasets through filtering, grouping, aggregation, and statistical calculation.
• Consult with clients and internal stakeholders to gather requirements and plan milestones in the research, development, and implementation phases of the project lifecycle.
• Analyzed and suggested various statistical methodologies based on their outcome accuracy
• Explored member churn data through regression analysis using R, and created a report that provided strategy to decrease churn rate

Confidential

Data Analyst

Responsibilities:

• Involved in creating database objects like tables, views, procedures, triggers, functions using T-SQL to provide definition, structure and to maintain data efficiently.
• Involved in performance tuning to optimize complex SQL queries.
• Created Indexes, Constraints and Rules on database objects.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server
• Performed extract, transform and load data from various sources using Microsoft Integration Services, and schedule them via SQL jobs
• Worked extensively with stakeholders to understand the requirements and defined KPIs
• Worked in all phases of BW/BI full life cycles including analysis, design, development, testing, deployment, post-production support/maintenance, documentation and end-user training
• Built and published customized interactive reports and dashboards using Tableau
• Created many Ad-hoc reports, drill down and drill through reports and cross tab reports using both SSRS and Tableau.

Environment: ETL, SQL Server 2012/, SSRS 2012, SSIS 2012, TFS, Tableau 9, Visual Studio 2012, MS Office, Visual source safe.