SUMMARY:

• Around 3 years of experience in BUSINESS INTELLIGENCE, BUSINESS ANALYSIS & Statistical DATA MINING.
• Experience on working with Database Platforms like Oracle, SQL SERVER, T - SQL and Data warehousing environments
• Excellent knowledge on working with INFORMATICA-POWERCENTER, SSIS for ETL development
• Expertise in creating Dashboards/KPI’s, Scorecards, Reports, views, pivot tables for analysis using TABLEAU and other DATA VISUALIZATION tools like SAP BO, QLIKSENSE
• Experience in building and analyzing the datasets according to the project specifications and data cleaning using SAS/SQL/Python
• Technical expertise in predictive modeling and implementing various machine learning algorithms.

TECHNICAL SKILLS:

BI Tools: Informatica-powercenter, SSIS,SSRS, QLIKVIEW,Tableau Desktop/Server, SAP BO, STATA

Data mining Tools: R Studio, SAS Rapid Miner, SAS E-miner, Google Analytics, SPSS, Minitab, Python

Languages: SQL, PL/SQL (basic), UML,.NET

Microsoft Office Suite: Visio, Advanced Excel, Access, Project, Word, Survey Monkey

Software utilities: TOAD, Scrum wise, JIRA, SharePoint, SQL Management Studio, Service Now, Survey Monkey

Environment: Windows (All), UNIX.

PROFESSIONAL EXPERIENCE:

Confidential

BUSINESS ANALYST INTERN

AREAS: SAS,NO SQL SCRUM, LEAN, EXCEL, SAP BO, Python

Responsibilities:

• Conducted deep dive data analyses to gain insights, JAD sessions and provide analytically driven recommendations to improve products/services and profitability using SQL queries
• Single Handedly built a Dashboard on Xcelsius from the from the older Webi report
• Made quarterly presentations to communicate analyses results and recommendations to Clients and managers
• Performed Market Basket Analyses on Companies core products and analyzed the most interesting association rules from the patters using Association rules. This led to an increase in revenue by 10%.
• Developed strategic business plans, identifies key KPI’S and business requirements for projects supporting growth.

Confidential

BI ANALYST

AREAS: Tableau Desktop/Server, JIRA, SQL, QLIK, SSRS

Responsibilities:

• Developed Tableau Dashboards to calculate the financial data to get better understanding of future enhancements
• Studied and analyzed similar applications and brainstormed with business team to gather effective requirements for the system along with dashboard development
• Built statistical models and implemented the same
• Conducted deep dive data analysis to gain insights, diagnose issues and provide analytical recommendations
• Complied interactive dashboards in Tableau Desktop and published them to Tableau Server which allowed story telling behind the Insurance App usage with Quick Filters for on demand needed information with just a click of a button.

Confidential

BI/DATA ANALYST

AREAS: Informatica, Tableau, QA, ETL, SQL, SAP BO, SSRS

Responsibilities:

• Understanding the complete application architecture, I identified projects risks and also mitigate them
• Worked closely with the client operational and functional teams to gather the requirements and performed source to target mappings.
• Delivered automation tools using SQL queries, UNIX shell scripts. These automation tools helped the client to reduce manual reporting efforts by 20 hours per week.
• Monitored the performance of Data warehouse (DW) ETL runs and removed the performance barriers
• Majorly involved in database query and application performance improvement process and incident Tracking
• Review Vendor status reports team and created visualization for budget forecasting using BO
• Mentored the new joiners in the project and guided them on Informatica, ETL and other project related works
• Analyzed historical data for 150,000 borrowers using SAS R MINER. Performed variable exploration and transformation
• Implemented statistical modeling techniques like Neural Nets and logistic regression
• Assessed and implemented models which yielded 84% accuracy rate for logistic regression
• Created dashboards for real - time in TABLEAU that allows clients to grasp actionable insights
• Tweets are collected by making API calls to Twitter and Data Cleaning (Identifying and removing re-tweets, removing hash tags, hyperlinks) is performed. Also, Identified and Removed Tweets in foreign languages other than English
• Collecting the Classification Parameters by making API calls to IBM Watson Personality Insights (Watson PI) and Classify
• Performed Data Analytics using Rapid Miner and R - Descriptive Analysis, Visual Insights, Decision Trees and Multiple
• Increased conversion rates & ROI by 20% using optimization strategies
• Provided weekly, monthly & ad hoc web analytics reports using GOOGLE ANALYTICS
• Managed e-mail marketing campaigns
• Tracked revenues and settled goals for desired period
• Performed Data cleansing on the latest health care formats and built Predictive models
• Work autonomously and collaboratively with researchers to define report requirements and validate results
• Built models using SVM and Neural Nets using R and SAS MINER
• Interpret the outcomes and rules associated among cardiac arrest.
• Build an Android application which will enable financial advisors to interact and conduct business in a whole new way
• Developed a dashboard to create notes based on client meetings and update information in SQLite database
• Performed text mining on the notes written by the advisor using SAS and WEKA to extract information by using Naïve Bayes.