SUMMARY

• 5+ years of experience in Business Intelligence Process especially in Business Requirement Analysis, Application Design, Development, Implementation, Testing, Production Support
• Performed analysis and presented results using SQL, SSIS, MS Access, Excel, and Visual Basic scripts.
• Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
• 4+ years of experience in Tableau and Power BI
• Created Chat - bots using IBM Assistant and Microsoft QnA maker
• Experienced in designing Queries and working with Stored Procedures.
• Wrote and analyzed trending reports, drew extrapolations from findings to/with the project manager and the commercial team
• Expertise in all the phases of System development life Cycle (SDLC) and working in different methodologies like Agile.
• Developed and presented weekly and monthly financial reporting, with a focus on KPI targeting and trending analysis.
• Understanding of Gap Analysis using Swim lane diagrams, requirement management, risk analysis and project plans
• Strong communicator and problem-solver skilled at analyzing/eliciting business needs and transforming them into technical designs, applying technical skills and business knowledge to achieve sound results.
• Excellent interpersonal dexterity with proven ability to converse, liaise, negotiate and relate with a wide range of personalities from diverse socio-economic and cultural backgrounds.
• Superior proficiency with MS Office including PowerPoint, Project, Excel and Word.

TECHNICAL SKILLS

BI Tools: Tableau, QlikView, Power BI

Database: Oracle SQL Developer, MS-Access, My SQL

SQL Server Business Intelligence tools: SSIS and SSAS

Frameworks: IBM Watson, Jenkins

Version Control Systems: SVN, GIT, CVS, Chef

Methodologies: Agile

Development Tools: Microsoft Visual Studio, MATLAB

Watson API’s: Assistant, Discovery, Natural language processing, Speech to text and Personality Insight

Programming Languages: Python

Cloud Technologies: IBM cloud, Confidential web services

PROFESSIONAL EXPERIENCE

Confidential

Data Analyst/Business Analyst

Responsibilities:

• Created Power BI dashboards for windows 10 migration assisting Info-spec when the feature update fails or faces any issue
• Assisted the client in solving computer related issues and orientation of new equipment as deployed using Power BI Dashboards
• Creating Power BI dashboards for End Point Management.
• Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources.
• Worked in HR Data to cross reference data points and create Dashboards
• Generated score cards with executive summary dashboards to display performance monitoring measures with Power BI.
• Delivered on-demand reports in multiple rendering formats with standard and data driven subscriptions.
• 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 number of users on end points, critical applications which might be a treat to the organization with the number of people effected by its removal
• Generated ad-hoc reports in Excel Power Pivot and shared them using Power BI to the decision makers for strategic 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.
• Participate in cross-team information sharing resources and work to identify risks early in the development process

Confidential

Data Analyst

Responsibilities:

• Gathered requirements and performed data mapping to understand the key information by creating tables
• Defined data requirements and report layouts for business review. Created testing plans and scripts based on requirements
• Partnered with developers to automate manual processes, saving time and money while decreasing errors. Credited as a primary driving force behind a 5% increase in margins this fiscal year.
• Involved in creating database objects like tables, views, procedures, triggers, and functions using SQL to provide definition, structure and to maintain data efficiently.
• Developed Tableau visualizations and dashboards using Tableau Desktop.
• Worked on building KPIs, Heat maps, scatter chart, Pareto charts, what-if analysis.
• Created Stored Procedures, Triggers, Functions, Indexes, Views, Joins and SQL code for applications.
• Managed indexes, statistics and optimized queries by using execution plan for tuning the database.
• Fine-tuned the data model for better response rate of the dashboards.
• Used parameters and variables for storing expressions to avoid dimension/measure redundancy and for improving performance.
• Designing data model from scratch to aid team in data collection to be used for Power BI visuals.
• Fine-tuned SQL Queries for maximum efficiency and performance and connect to various data source’s like SAP Hanna
• Analyzed the requirements, identified, and documented the issues, risks, gaps and its impact
• Designed a Chat-Bot assisting customers on queries about replacing a wall oven.
• Constructed an efficient dialog flow to simulate a human-like interaction assisting wall oven replacement.
• Performed quality assurance, system integration and user acceptance testing facilitating on-time, on-budget and acclaimed “go-live” of enterprise implementations for up to 25,000 global users
• Integrated a support system where in the customer gets connected to a customer care representative in case the bot is unable to assist the customer.
• Cleaning and Blending multiple data sources to allow for different views on application data in a single dashboard in Power BI

Confidential

Data Analyst

Responsibilities:

• Worked on designing a Chat-bot using IBM Watson Assistant Framework for Cambridge Savings Bank to facilitate ease of availing services for customers.
• Involved in User Interface (UI) analysis with the business team to validate accuracy.
• Reviewed business priorities, and analyzed options, risks, and costs.
• Performed Gap Analysis between current and future state to define required remediation to attain project objectives
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction
• Strong user interface and reporting design skills translating client requirements into professional reporting using Tableau desktop

Confidential

Data Analyst

Responsibilities:

• Led a team of associates and managed a wide variety of customer service and administrative tasks to resolve customer issues quickly and efficiently.
• Raised tickets for customers experiencing inconvenience making transactions.
• Trained agents for Customer Care service for peak periods.
• We also worked on seamless transition to the agent
• Experienced in administering large-scale databases
• Created Tableau dashboards to understand the call flow and analyze the incoming call volume trends.
• Helped take decision’s on hiring required number of people by analyzing the call volume trends in each region

Confidential

Data Analyst

Responsibilities:

• This is a coursework project on which the data of top-notch global universities are represented by using Tableau across three different years by identifying and analyzing the various factors affecting the ranking of these universities
• Raw data extraction from SQL server
• Simplified the data so that it can be directly inputted into Tableau. Different views of data are provided in dashboards such as bar chart, Pie chart, Radar chart etc.
• Comparison of business over time periods is also available
• Responsible for the evaluation of design and development of the project lifecycle.