SUMMARY

• Dynamic and fast learning professional wif 7+ years of work experience as an analyst in top MNCs.
• Data Analysis was done for various industries, such as human resource management, Healthcare, IT user base management, and retail market.
• Extensive experience wif data analysis and converting business requirements into detailed specifications such as UML for use cases, activity diagrams, class diagrams, sequence diagrams, process modeling, and data flow diagram by using MS Visio
• Ability to TEMPeffectively communicate using analytical, interpersonal, and presentation skills, theirby providing key personnel wif the right information at the right time
• Robust Analytical background using MS Excel, R Studio, Tableau, SAS, Denodo, MS SQL Server, MS Project, PowerBI, Looker and Access
• Proficient in documentation preparation for end - users and data management using SAP HCM, PeopleSoft, eNate, Taleo, and MS PowerPoint
• Comfortable wif a bunch of project management tools, such as JIRA, ALM, Trello, Pivotal Tracker, and HP QC tracking tools for tracking defects and changes for Change management
• Analysis of variance (ANOVA), General Linear Model (GLM), Chi-Squared, Pearson Correlation, Linear Discriminant Analysis (LDA)
• Proficient in writing SQL queries
• Experience in various types of testing like End-to-End, Functional, Regression, Integration, Smoke and User Acceptance Test (UAT).
• Expert in all phases of SDLC methodologies including Agile and Waterfall. Consistently delivered results in various stages of Software Development Life Cycle (SDLC)
• Experience in creating different visualizations using Bars, Lines, and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Heat maps, and Highlight tables.
• Strong interpersonal and multi-tasking skills
• Proficient in managing cross-cultural team
• Fluent communicator wif problem-solving and decision-making skills
• Roll-up sleeves attitude and a great team player
• Excellent in strategic intelligence, strategic thinking, and strategic solutions.
• Highly TEMPeffective leadership and motivational skills to produce positive results while meeting deadlines.
• Creative, proactive, quick and eager to learn any concepts, programs or procedures dat may serve to enhance company growth potential.

TECHNICAL SKILLS

Data Analytics Tools: R Studio, Tableau, Denodo, SAS, SPSS, MS Excel, PowerBI, MS Visio, Smart Draw

Languages: Python, R programming, Shell Scripts

Database: MS SQL Server, MS Access 2010, MySQL

Data Modeling: Tableau, Power BI, R, SAS, Python, MS Visio, FACT& Dimensions tables, Physical & Logical data modeling, Star & Snowflake schema, Relational, Dimensional, and multidimensional modeling and De-Normalization Techniques, MS- Access

OS: Windows, Linux, Mac

Other Tools: JIRA, Visio, Peoplesoft, eNate, Taleo, Image Now, MS Project, SAP HCM, TFS, JSON

PROFESSIONAL EXPERIENCE

Confidential, NYC, NY

Business Data Analyst

Responsibilities:

• Gathering requirements from Business, feasibility analysis and proposing different design solutions for it
• Preparing flow-charts, data models and diagrams to capture and illustrate the business processes
• Data preparation and conversion for analysis
• Identify the data patterns and recommend the new ways for data management
• Documenting requirements in requirement gathering sessions
• Experienced in requirement gathering/analysis, design, development, testing, and production rollover of reporting and analysis projects.
• Developing data specification and data restructure documents
• Developing Functional Requirement Specification document (FRS), Technical Design Document (TDD), User Stories & Use Case diagrams
• Developing data specification and data restructure documents; project closure documents, end-user training manual, lessons Learned documents
• Use statistical methods to analyze data and generate useful business reports using Tableau and R integration
• Using Tableau Performance recording to improve the load time of the dashboard
• Work wif the management team to create a prioritized list of needs for each business segment
• Designed and implemented a Data Quality Model framework at an enterprise level to automate data validation
• Reduced data generation time from 22 hours to 1hr wif R parallel processing to enhance performance and remediate data quality related issues.
• Reduced time from 24 hrs to 4hrs wif DataFlux to ETL Migration to standardize and remediation of data related issues.
• Implemented Business Rules using SQL & Tableau framework for data quality dashboards, issue tracker, definition and implementation of data cleansing rules.
• Engaged in the development of Ataccama Data Quality Components and Plans, identification of reusable business rules which were used for data integration from the different business process.
• Performed data integration wif ETL process using Informatica and implemented the data validation to provide accurate and timely reports for multiple businesses.
• Worked wif the data modeling team to understand the EDW implementation and hence plan and approach the corresponding ETL implementation.
• Worked closely wif the solution architect to churn out the design deliverables - ETL
• Design Document, Technical Architecture Document, and ETL Implementation Guidelines
• Developed a simple database and ETL process in BI Informatica PowerCenter tool to load the existing data for the business modules.
• Performed data visualization using BI reporting tool Business Object wif multiple data modeling schemas.
• Performed and analyzed Data Lineage on various applications and created Functional Requirement document and supported the Business Requirement document.
• Decoded and enhanced the SQL stored procedures as a part of data lineage
• Use business data to develop prediction models and to depict the trends using SQL and R integration
• Creating and maintaining Requirement Traceability Matrix (RTM)
• Root cause analysis of the data validation findings
• Actively participating in manual and automation testing
• Creating and validating test cases, identifying defect resolution steps, and defects fixing

Environment: Tableau, Denodo, ALM, MS SQL Server 2016, Drupal, TFS, R, SAS, MS Office, Visio

Confidential, Bridgeport, CT

Graduate Teaching Assistant / Student Worker

Responsibilities:

• Publish, update and manage course curriculum
• Assist Professor in managing lecture sessions
• Students’ performance analysis and documentation
• Assist in query resolution for students to make them understand the study materials
• Provide administrative support to the professor
• Accept, document and process international applications for graduate studies
• Evaluate GPA as per the academic standard of USA
• Actively participate as a team member in a multicultural and multinational team
• Maintain and update international student records
• Resolve query of current and prospective students

Confidential

Business Intelligence Engineer

Responsibilities:

• Gathering requirements from Business, feasibility analysis and proposing different design solutions for it
• Developing and Whiteboarding wireframes, beta dashboards and presenting them to the business teams to see if they meet their requirements
• Documenting the dashboard needs, the critical success factors of the business, related KPIs and measures in the dataset, and the designs
• Preparing flow-charts, data models and diagrams to capture and illustrate the business processes
• ETL of data from various OLTP systems and loading into OLAP System using BTEQ, FLOAD, and MLOAD
• Development of PL/SQL procedures to process the data and load into reporting tables based on business need
• Ensuring the better performance of PowerBI by using various performance optimization techniques and TEMPeffective semantic design to reduce report generation time
• Development of new Business Objects, reports and Universe wif multi-data source universe
• Design and development Business Objects universe in UDT
• Development of tableau Reports to show the trends of Sales and customer acquisition metrics using a stacked bar, line, donut and heatmaps
• Managing associate team members and delegating them development tasks
• Performance optimization of Tableau dashboards to load the reports wif huge data set in less time on the server
• Assisted the project team in preparing Functional Specification Document (FSD), Functional Requirements Document (FRD) developed non-functional requirements and documented Business Requirements Document (BRD)
• Perform data validations and work on issues during IT and UAT testing phase
• Implementation of the multiple projects in iTunes Gift cards in Tableau and Business Objects
• Work wif QA team to halp them create Test cases and rectify the bugs if any.
• Analyze the data sources, be it a RDBMS or a XLSX file or a CSV file.
• Perform the required data wrangling before connecting to the data source from the Tableau client.
• Research ways to halp the report users to see the bigger picture at a single glance and insert the ability to drill through the different levels of dimensions.
• Testing the reports for formatting and data correctness, and publishing the workbooks on the Tableau server for scheduled refreshes.
• Defining access control levels using Tableau temp table using Initial SQL for different types of users, and communicating the requirements to the Tableau Server team to apply the same to the workbooks for row-level security.
• Develop custom reporting dashboards, reports and scorecards mainly focusing on Tableau and its components.
• Each application could source from multiple sources, including SQL Server, Excel, flat files, and CSV. The integration of all of this data while applying the appropriate business logic is the great value.
• Creating views and Tables in SQL server and running batch jobs daily using Informatica Power Center.
• Using Tableau Performance recording to improve the load time of the dashboard.
• Provided ad-hoc dashboards for Executive Directors to address specific business questions from stakeholder groups.
• Bridge the gap between business and technology. Take a business thought, and turn it into reality
• A quick fix of the post-deployment issue and enhancements
• Coordinating wif cross-functional teams as per project requirement
• Maintaining project-related documents for future reference
• Delivering user training to the Business for the usage of the reports

ENVIRONMENT: Tableau, PowerBI, Microsoft SQL Server 2014, Informatica Power Center, JIRA