SUMMARY

• Qualified IT Professional with 5 years of experience in Data Analysis and Data Visualization.
• Strong background in Development, testing and implementation of Data Warehousing and Business Intelligence applications in various domain such as Insurance, Banking and Retail industries.
• Extensive experience in Data Modelling, Data Profiling, Data Integration, Data Migration and Data Mining.
• Sound knowledge of SQL queries, E - R and Dimensional Model, Database Architecture for OLTP and OLAP applications, Data Analysis and ETL processes.
• Proficient in design and development of various dashboards, stories and reports utilizing Tableau like Bar Charts, Line Charts, Histograms, Tree Maps, Heat Maps, Scatter plots, pie-charts, and geographic visualizations.
• Proficient in Building compelling, interactive dashboards in Tableau that answer key business questions using calculations, parameters, calculated fields, groups, sets and hierarchies.
• Developed reports using Advance Analytics like Reference Lines, Reference Bands, Trend Lines, Box plots and Custom Geocoding.
• Hands-on experience using Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimension Tables, Physical and Logical Data Modeling.
• Proficient in using T-SQL for developing complex Stored Procedures, Effective Triggers, Tables, Views, User defined Functions, Relational Database Models and Data Integrity, SQL Joins, Indexing and Query Writing.
• Experience in developing source to target Mapping Document for migration and Data Transformation documents for the development team to facilitate the development of interfaces.
• Highly skilled in Requirement Gathering Methodologies and implementation of large projects with complete end to end participation in all areas of Software Development Life Cycle (SDLC) which includes traditional Waterfall and Agile (SCRUM).
• Organized and facilitated Scrum ceremonies, which included Sprint Planning, Daily Scrums or Standups, Sprint Review & Sprint Retrospective.
• Conducted GAP Analysis, SWOT Analysis, Cost Benefit Analysis, Risk Analysis, GAP analysis and PESTLE Analysis.
• Experience in creating Business Process Models and notations, Wireframes and Mockups for Prototypes. Highly proficient in creating Use Cases, Use case diagrams, Activity Diagrams, Workflow Diagrams, Sequence Diagrams and Class Diagrams.
• Proficient in preparing Business Requirements Document (BRD), Software Requirements Specification (SRS), Functional Specifications Document (FSD).
• Broad knowledge in reviewing test input data and test procedures, document detailed test plans, test scenarios, define test cases and experience in performing User Acceptance Testing (UAT).
• Experience supervising Black-Box Testing, Functionality Testing, System Testing, Integration Testing, Regression Testing, Load/Stress Testing, Performance Testing and User Acceptance Testing (UAT).
• Basic knowledge of Hadoop framework of tools that supports running applications on big data.
• Experience in creating XML, HTML and handling JavaScript, PHP files.
• Approaches all tasks in an organized and structured manner.
• Excellent communication and inter-personal skills with ability to develop creative solutions for challenging client needs using agile methodologies.

TECHNICAL SKILLS

Methodologies: SDLC, STLC, Waterfall, Agile - SCRUM, PESTLE, SWOT Analysis, GAP Analysis, Data Modeling, Predictive Analysis, Business Intelligence, Data Warehousing

Modelling Tools: MS Visio, Erwin, Wireframes, Mockup screens, UMLet, StarUML, LucidChart

Web Technologies: HTML 5, CSS, PHP, XML, JavaScript

Reporting/BI Tools: Tableau Desktop, Tableau Server, Tableau Public, R Studio, MS Excel, SharePoint, Pentaho BI Server, Alteryx, Google Analytics

Front End Tools: MS Outlook, MS Project, MS Office

Databases: Oracle 11i, MS SQL Server, Oracle, Relational databases, SQL Server, MS Access, MySQL, Teradata

Languages: C, C++, Java, R programming, PL/SQL, Python, VB.NET

ETL Tools: Pentaho- Kettle, DataWatch, Keshif

Analytical tools: R Studio, Python, Machine Learning, Hadoop

Advanced Excel: Macros, V-LookUp, Pivot Table, Histograms, Reports, Functions

PROFESSIONAL EXPERIENCE

Confidential, New York City, NY

Business Intelligence Analyst

Responsibilities:

• Conducted GAP analysis by understanding AS-IS and TO-BE process models and process flows.
• Gathered Business Requirements, Interacted with the Users, Project Manager and SMEs to get a better understanding of the Business Processes.
• Performed detailed analysis of complex business requirements and proposed solutions that demonstrate a thorough understanding of technical solution delivery.
• Performed data extraction and transformation using Data Wrangler, DataWatch, and Keshif.
• Administered ETL Process and identified source table, target table and created the data mapping document.
• Developed UML diagrams such as sequence diagrams, decision tree and activity diagram.
• Performed SQL queries using JOINS and nested queries to fetch data from MS SQL Server.
• Assisted in creating analytical models, helped in forecasting, identifying trends, developing business cases, analyzing key metrics, and short/long-range planning.
• Worked with the HR team and senior executives in negotiating the Acceptance Criteria for the user stories.
• Created various types of reports and drilldown like standard and cross tab reports with bar chart, pie chart, line chart graphs and dashboards using Tableau platform.
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
• Generated insights out of voluminous and complex datasets and built story lines.
• Compared data mining techniques for the predictive accuracy of data models and applied machine learning algorithms like Linear Regression, GBM, Neural Networks and Decision Tree using R.
• Created visualizations to identify factors causing increase in attrition rate while utilizing sample data to create dashboard.

Environment: Tableau, Keshif, Data Wrangler MS Office, MS Excel, MS Power Point, MS Word, MS Visio, UmLet, SQL, R Studio, MySQL Server

Confidential, Rockville, MD

Business Intelligence Analyst (Tableau)

Responsibilities:

• Interacted with the stakeholders to understand the current state of system and defined future needs based on analysis of business requirements after implementing GAP analysis.
• Conducted JAD sessions for requirement elicitation and to allow stakeholders as well as the technical team to communicate their perspectives.
• Developed Data Migration, Data Profiling and Cleansing rules considering data linkage and data transformation rules.
• Developed Data Mapping and Data Transformation documents between legacy database, Production DWH, and front end applications.
• Prepared ER Diagram, Use Cases and Data Flow Diagrams to communicate the page flow and user interaction with the system.
• Analyzed quantitative data using Tableau showcasing heart rate, blood levels to identify severe factors contributing fatalities.
• Blended data from multiple databases into one report by selecting primary keys from each database for data validation.
• Produced complex table calculations, use of parameters, actions, filters and other advanced options in Tableau.
• Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• Analyzed issues reported by client while user acceptance testing and communicated appropriately to client
• Used PL/SQL, stored procedures, triggers, functions and packages for extracting data, validating data and generate reports according to the requirements specified by the SMEs.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business changes to ensure that the views and dashboards displayed the changed data accurately.
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
• Involved in generating Test Plans and Test Specifications, prepared test data for positive and negative Test Scenarios as per system specifications and requirements.
• Performed User Acceptance testing, verification testing and System testing manually.
• Designing and implementing quality control systems and processes for existing and new data management processes.
• Implemented web application using MySQL Server and PHP for managing employees’ data in MS Excel, Access format.
• Implemented Change Data Capture (CDC) for inserting and updating slowly changing dimension tables in target for maintaining the historical data.

Environment: Agile/Scrum, Tableau (Desktop and Server), Oracle, MS Visio, MS Office, SQL, R Studio, MySQL Server.

Confidential, Baltimore, MD

Business Intelligence Analyst

Responsibilities:

• Worked closely with end users to understand the problems with current system and need for new system.
• Assisted the project manager to construct a project plan that included Project Schedules, Status reporting, Milestones tracking, and Meeting minutes using MS Project.
• Interacted with SME’s asking detailed questions and carefully recording the requirements in a format that can be understood and reviewed by both technical and business people.
• Analyze business requirements quickly to determine and assess technical feasibility within mobile applications.
• Complete study of the in-house requirements for the data warehouse. Analyzed the DW project database requirements from the users in terms of the dimensions they want to measure and the facts for which the dimensions need to be analyzed.
• Implemented a hybrid of waterfall and Scrum as a part of agile methodology for work management.
• Process mapping, data cleansing, data migration and validation of data table structure.
• Involved in logical & physical data modeling, database schema design and modification of Triggers, Scripts, and Stored Procedures in Database Servers.
• Worked on data modelling, data mapping, data definition, metadata, and user documentation.
• Created ETL workflows through which records were loaded daily, from various data resources such as Excel, Access, Flat File, and XML in order to create and maintain a centralized data warehouse.
• Created views in Tableau Desktop that were published to internal clients for review and further data analysis and customization using filters and actions.
• Designed interactive Tableau dashboards and presented correct decisions independently based on what different kind of visuals would make sense for the business.
• Designed reports/graphs/presentations using Tableau for specified projects. Produced accurate analyses of project datasets as defined by the required specification.
• Responsible for Google Analytics reporting and analysis for various marketing clients.
• Developed the business logic and the design of data queries and calculations used to extract and format data for project reports and external presentations.
• Worked a great extent with the design and development of Tableau visualizations which includes Preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies etc.
• Created numerous dashboards in Tableau Desktop based on the data collected from financial reporting System by importing and blending data from MS Excel and CSV files along with MS SQL Server Databases.
• Complied interactive dashboards in Tableau Desktop and published them to Tableau Server which allowed story telling behind the market spread with Quick Filters for on demand needed information.
• Documented business workflows textually as well as in UML diagrams for the stakeholder review.
• Used Microsoft Office suite to develop the documents such as Visio for creating wireframes, Word, Excel and Power Point for creation of Business Requirement documents.
• Reviewed Test Plans that contained test scripts, test cases, test data and expected results for the User Acceptance testing.

Environment: Tableau, MySQL Server, R Studio, Oracle, MS Office Suite, MS Visio, R, Google Analytics.

Confidential

Data Analyst

Responsibilities:

• Waterfall Methodology was used in acute functionalities to design, document and manage requirements throughout the life cycle of the project, including definition, design and testing.
• Assisted in gathering requirements for the GUI (Graphical User Interface) screens and designing. Also created CSS style sheet for designing the layout of webpages.
• Identified business stakeholders, gathered, discussed and refined business requirements by conducting workshops and focus groups.
• Facilitated the Joint Application development (JAD) sessions to identify business rules and requirements and then documented them.
• Created Use cases for any new or updated functionality of the product after every release.
• Worked as Database Design Analyst, led the team for two months and designed OLTPS working closely with senior management.
• Created and modified tables, views and indexes, PL/SQL stored procedures, functions and triggers according to business requirement.
• During the design phase, worked with the development team to ensure testability, reliability, usability, maintainability, scalability, performance and security by documenting processes and workflow, identifying cross functional and organizational process improvement opportunities.
• Followed the Agile Model of software development implementing the Scrum methodology.
• Formulated clear, well-defined Business Requirement Document (BRD) and Functional Requirement Document (FRD) for the IT development team to work on
• Created mock ups and wireframes for better visualization of the system using Mock Up Screens.
• Created use cases and designed use case diagrams, class diagram, sequence diagrams and activity diagrams.
• Involved in doing End to End testing, Regression Testing of Quarter Releases.
• Involved in training of new members joining the team.
• Demonstrated strong ability to work on multiple tasks while successfully meeting established goals and deadlines.
• Responsible for debugging, troubleshooting system functionalities and prepared suggestion documents to improve the quality of the application.
• Created data model and developed SQL scripts to create database tables
• Prepared project related presentations using MS Power Point.
• Conducted training sessions for business and end users.

Environment: Oracle, SQL, MySQL Server, Testing tool, UML, MS Visio, Agile, Scrum, MS Project, MS Office-PowerPoint, Excel, Java, HTML, and CSS.

Confidential

Pentaho ETL Developer

Responsibilities:

• Established close relationship with the Training and Placement coordinators and SMEs to understand their issues and data requirements.
• Developed processes for standardizing raw data coming from different sources in a variety of formats, and support team members in cleaning and improving data quality.
• Developed mappings in ETL tools like Pentaho Kettle to load the data from various sources into the Data warehouse using transformations like Value Mapper, Expression, Lookup, Aggregate, Update Strategy and Filters.
• Implemented OLAP to OLTP conversions, Data Staging, Data Integration, Data Cleaning tasks.
• Implemented and maintained data mining, statistical and visualization algorithms needed for data analysis.
• Provided data integration and designed expertise that will lead to the appropriate mapping and integration of data from various authoritative sources.
• Prepared reports using Excel and Pentaho BI Server according to the business user requirements defined by the Training Officer.
• Developed interactive data visualizations and developed automated processes for updating content used in standardized dashboards.
• Held responsibility for integration points and the order in which these must be executed.
• Built compelling, interactive dashboards in Pentaho that answer key business questions.
• Audited the datasets and data analyzed as required ensuring their continuity, accuracy and consistency.
• Prioritized and responded to requests for data retrieval, visualization and investigation with minimal turn-around time.
• Prepared technical documents, clearly describing data cleaning & analysis methods and results.
• Preparing user manuals and system guides.
• Supported database application testing and production implementation as required.
• Managed large datasets; moved and merged data files from different platforms, aggregated data and performed quality control.

Environment: Pentaho. Kettle, Pentaho BI Server, Oracle, Erwin, MySQL, MS Visio, MS Excel, MS Access, Android SDK.