PROFESSIONAL SUMMARY:

• Overall 6+years of Data Analyst experience in developing scalable business solutions and support data driven decision making in Telecommunication, eCommerce, Finance and Call centre industry.
• Experience with Statistical and machine learning models in Clustering, Classification, Hypothesis Testing, Data mining, Database Warehousing, RDBMS, A/B Test, ETL.
• Logistic/Linear Regression, Customer Segmentation, ANOVA and Forecasting.
• Exposure to SQL, Python, AZURE, R, Tableau, Advanced MS EXCEL and Tableau.
• Good exposure to cross - functional Data Analysis and Business Intelligence tools, Machine Learning, Predictive Analytics, Personal Analytics and Visual Business Analytics
• Business Analytics graduate with strong numerical, analytical and statistical skills.
• Experience in conducting Joint Application Development (JAD) sessions with end users, Tech Leads, developments and testing teams for conflict resolution.
• Experienced in creating user-friendly reports and dynamic dashboards using Tableau.
• Very good understanding of Data warehousing Concepts - RDBMS, OLTP, OLAP Star and Snowflake schema, Normalization/De-Normalization, Dimension & Fact tables.
• Extensive experience in creating detailed Business Requirements Document (BRD) and Functional Requirements Document (FRD).
• Understanding of Redpoint Customer data platform for control of customer data.
• Proven expertise in successful Requirements gathering using suitable elicitation techniques.
• Hands on experience with SQL database, MS SQL Server, MYSQL and Oracle SQL.
• Experience working with Extract, Transform, Load (ETL) using Informatica, SQL and Python.
• And developing the data lineage.
• Developed Custom Reports and different types of Tabular Reports, Matrix Reports, and distributed reports in multiple formats using SQL, Tableau and Excel.
• Designed and developed Informatica Packages to extract data from various data sources such as Excel spreadsheet, Oracle database and flat files and transforming it for further
• Hands on experience on Microsoft Power BI and Tableau.
• Translate business requirements into -ETL and report specifications.
• Worked closely with QA team to support Test Planning, Test Preparation, Test Execution and Defects/Bugs Validation through various defect tracking tools.
• Strong testing experience in performing Functional Testing, Smoke Testing, Regression Testing and User Acceptance Testing (UAT).
• Experience in creating ‘User Manual’ and providing training to the end users.

TECHNICAL SKILLS:

Business & Modeling tools: Power Designer, MS Office, SQL, R, Python, MS Azure ML, Informatica

Methodologies: Agile.

Project Management Tools: MS Project, MS Excel, Confidential Rational Portfolio Manager

Database: Oracle SQL, MySQL, MS SQL Server, MS Access, Data Lineage, Hadoop - Hive, PIG, Teradata

Data Analysis: Hypothesis Testing, Data mining, Data warehousing, RDBMS, A/B Test

Machine learning/Statistics: Clustering, Classification, Logistic/Linear Regression, Customer Segmentation, Forecasting, ANOVA

General: MS Office Word, MS Project, Advance Excel, Lotus Notes, GitHub repository

Reporting Tools: Tableau, Power BI, Excel, Macros

PROFESSIONAL EXPERIENCE:

Senior Business Data Analyst

Confidential, Phoenix, Az

Responsibilities:

• Lead a team of 4 members to conduct interviews and facilitate requirements gathering, process analysis , and application design sessions with company staff across all levels and functions and performed extensive Requirement Analysis including data analysis .
• Drove requirements for data collection and attribution modelling.
• Built a Structured Analytical Data Framework in terms of relational and dimensional databases using SQL, Python and Excel and created a standard metadata for the HR team.
• Created ETL pipelines for data flow from various sources ranging from Hadoop through Hive and Teradata RDBMS into raw and summary data.
• Used ETL in Informatica, Python and SQL to transform and prepare the data for further statistical analysis .
• Deployed and maintained codes in GitHub.
• Performed data cleaning based on imputation methods including regression imputation.
• Analyzed the pattern on data and found the best suited algorithm for predictive analytics .
• Implemented BI solutions by: monitoring and tuning queries and data loads, addressing user questions concerning data integrity , monitoring performance and communicating functional and technical issues.
• Gathered requirement and proposed possible solutions to satisfy business needs and designed/ created star, snowflake schema models .
• Evaluated historical decisions and discovered relationship between employee profile and client revenue through regression and built models to predict Customer loyalty using Classification models in python .
• Performed root-cause analysis to identify reasons for fluctuations in different sources of revenue and customer satisfaction using descriptive and Regression analysis in python and created visualizations through Tableau .
• Created with machine learning algorithms such as decision trees, neural networks, Gradient Boosted Decision trees and Random Forest to evaluate inter-operability on different platforms (Python, R and Azure)
• Evaluated performances of machine learning algorithms by using RMSE and MAE.
• Built a Machine Learning model with Decision Trees, Support Vector Machine, and Neural Network that will determine an employee's access needs based on various organizational attributes.
• Effectively translated statistical findings into actionable recommendations for players based on statistical analysis using regression models, classification models.

Environment: Requirement Gathering, Requirement analysis, relational and dimensional data models, SQL, Python, R, ETL, star & snowflake schema models, predictive analysis, Statistical Analysis, Regression, Classification, Machine Learning, Tableau, Azure Machine learning, Hadoop Hive, Pig

Senior Business Data Analyst

Confidential, Tempe, AZ

Responsibilities:

• Acted as a primary point of contact working with stakeholders to understand their systems, AS-IS process and business needs and worked as a trusted advisor to identify opportunities for new insights, analytics and reporting solutions.
• Conducted Data analysis to answer specific business questions asked by clients and/or support teams; use data to establish facts and draw valid conclusions and manipulated data to make it usable for analysis by summarizing data points, creating new metrics, and addressing data quality issues.
• Created automated defect reports using Excel macros.
• Maintained data integrity during extraction, transformation and loading of data into data warehouse and engaged in requirements and gap workshops with clients for identifying the data sources and data needed for analysis.
• Analyzed and Designed the Data Mart model using Star Schema model with Facts and Dimension Tables and wrote SQL queries to perform data.
• Developed Test Cases, Facilitated UAT, compiled results, reviewed and discussed with Business Owners to provide signoff for the Clarity Reports and worked on stored procedures that are used in mapping pipeline.
• Worked under the guidance in the creation, enhancement and maintenance of new Business Intelligence solutions and attend meetings in which we helped stakeholders to interpret and understand data in Business Intelligence reports.
• Documented Requirement Traceability Matrix (RTM) through test cases and gathered requirements, Data and Use Case Analysis along with SDLC and QA life cycle.
• Responsible for writing documents Functional Requirements/ Business Requirements that implement the functional changes to the Integration systems, as defined by requirement analysis and interacted with Business Affairs and provide better solutions for increasing productivity and creating efficient review process by conducting GAP analysis, budget forecasting and financial planning. (Python)
• Worked under the guidance of Senior Business Analyst in writing Functional Specifications Document (FSD) and User Requirement Specification (URS) and provided clear and concise documentation regarding requirements management plans, Functional Requirements, Test Plans and Test Cases.

Environment: Requirement Gathering, Requirement analysis, relational data models, Test Cases, Data Marts, Data warehousing, SQL, Python, R, ETL, Star schema models, predictive analysis, Statistical analysis, Regression, UT, Machine Learning, Tableau, hive, Pig.

ETL Data Analyst

Confidential

Responsibilities:

• Collaborated with business clients to develop strategies based on the data/requirements generated for various telecom applications used by a Spanish Telecom Giant and documented the development workflow.
• Designed, developed and tested Batch Interface processes for various client requirements for extraction, transformation and loading of over million rows and generated reports through SQL, Excel and Tableau.
• Extensively involved in analysis, Design and development of Data conversion, Data migration and Integration process and procedures and worked with the database designer in data modeling through ER diagrams to identify tables, attributes and relationships between tables.
• Migrated the existing data from Sybase Database to Oracle Database using SQL and Informatica (ETL) and developed data lineage diagrams for the data flow.
• Analyzed the different causes for production defects and found the key factors to be managed which reduced the number of defects by 20% in one year.
• Developed and handled major ETL processes and optimized SQL queries to take 30% less time than previous tasks.
• Supported for executing data requests, custom reports, test scenarios, data migration, data analysis and quality assurance testing and ensured current testing practices met legal compliancy standards. Performed data integrity testing by executing SQL statements.
• Created and Maintained Supporting documents (technical, business, project level and sops) and conducted training sessions on Informatica and SQL to different teams and team members and conducted ETL testing process for data quality, data validations, data duplication and data count.
• Assisted Test Lead, Testers understanding business process and helped them for successful completion of Unit Testing, Integration Testing and Requirements Testing and supported the production database in terms of facilitating the implementation of defect resolutions and minor functionality enhancements.
• Managed data validation procedures and identify/resolve data issues and analysed the potential impact on users of automation of current data and processes, the movement towards standard data collection and reporting, and the implementation of data validation/verification practices to ensure data integrity.

Environment: Requirement Gathering, Requirement analysis, relational data models, Test Cases, Data warehousing, SQL, ETL, Data Migration, Informatica, UT, Tableau, Excel, Defect management and optimization.

Business Intelligence Analyst

Confidential

Responsibilities:

• Identified stakeholders of the project; prepared interview questionnaire for requirement elicitation on benefits, claims submission and CWB enhancements; interviewed SMEs and documented requirements. Gathered user and business requirements through interviews, surveys, prototyping and observing from subject matter experts.
• Analyzed and prioritized user and business requirements as system requirements that must be included while developing the software. Documented the Functional Requirement Document (FRD).
• Extensively involved in implementing the Software Development Life Cycle phases from identifying requirements to development and conducting UT.
• Gained exposure to OLTP/OLAP systems to develop ETL mappings using Informatica.
• Constructed batch interfaces to perform ETL in Informatica with custom SQL queries.
• Documented all custom and system modification.
• Authored progress and completion reports and submitted them to the project manager on a weekly basis.
• Conducted Unit Testing and verified performance, reliability and fault tolerance issues.
• Performed Gap analysis by identifying existing processes and technologies and documented the enhancements needed to meet the end state requirements.
• Suggested measures and recommendations to improve the current application performance using SQL query optimization and Informatica workflow optimization.
• Involved in preparing a simple and detailed user manual for the application, intended for a novice user

Environment: Requirement Gathering, Requirement analysis, OLTP/OLAP, Test Cases, Data Marts, Data warehousing, SQL, ETL, Query and informatica optimization, Gap analysis, Excel.