SUMMARY

• Over 5 years of experience in IT Industry as a Business Analyst
• Worked with various versions in Tableau, Tableau Server, Tableau Public, Tableau Reader and Tableau Online
• Able to creatively stretch the capability of Tableau to customize and develop creatively stunning and dynamic visualizations
• Understand SQL best practices, tips, and tricks; Innovate in the usage of SQL
• Experience in writing Business Requirement Document (BRD), Functional Requirement Document (FRD) and System Requirement Specification (SRS)
• Thorough knowledge in UML Modeling, Use Cases, State Chart Diagram, Deployment Diagram, Class Diagram, Component Diagram, technical design documents and Solutions Engineering concepts
• Worked in managing requirements from project inception through execution
• Proficient in all phases of Software Development Life Cycle (SDLC) and its methodologies like: Agile, Scrum
• RUP and Waterfall. Experienced in requirements management, controlling change, system implementation and preparing RTM (Requirement Traceability Matrix)
• Extensively worked on Business Process Models with understanding of Business Process Modeling Notations (BPMN). Created new models and updated the existing models. Used tools like Rational Rose, MS Visio

TECHNICAL SKILLS

Methodologies: Software Development Life Cycle (SDLC), Agile (Scrum, XP), Waterfall

Operating systems: Unix, Windows

MS Office suite: Advanced Excel (Macros, Pivot Tables, Power Query, Lookups) MS Word, MS Power Point

Languages: MySQL, ISQL, Java, C, C++, Perl, COBOL, JCL, PowerBuilder, VB, Vi Editor

Databases: Oracle 10g/9i, MySQL, MS - Access, SQL

Testing Tools: Quality Center, QTP, REST, SOAP UI, Selenium WebDriver/RC/IDE/GRID

Data Analytics: Tableau, R Programming, Power BI

Enterprise software: SAP/Oracle (ERP), Salesforce (CRM)

PROFESSIONAL EXPERIENCE

Confidential

Business Analyst

Responsibilities:

• Built an analytical financial model integrated with SQL database for financial analysis and to calculate fulfillment, storage and transport margin, used for budget forecast, P&L overview, and quarterly business reviews
• Developed dashboards in Tableau to visualize actual sales data and provide insights on revenue, cost, and volume
• Developed Tableau data visualization using Cross Map, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trails, and Density Chart.
• Optimized cardboard box utilization by 30% and reduced cost-per-unit of warehouse inventory (COGS) by building a spreadsheet model to perform cost benefit and cost predictive analysis for a $180M project
• Involved in moving the data from flat files to staging area tables using SQL loader
• Create T-SQL scripts to perform complex queries and complex data manipulations
• Built an inventory simulation model using Macros and Power Query to analyze dimensions of SKU items and cardboard boxes
• Automated 7 hours of monthly operation work by building Excel models using functions (Index Match, SUMIFS)
• Provided inputs to create, maintain SQL queries
• Executed exporting table data in MS Excel and flat files to SQL Server
• Created Use Case Diagrams, Activity Diagrams, Sequence Diagrams and ER Diagrams in MS Visio
• Assisted the account managers in credit/charge back calculation that had to be applied towards the 3PLs to manage the error in billing process
• Saved $70,000 by writing complex SQL queries/workflows to flag supplier accounts having null freight rates
• Designed a cost module in SQL that increased granularity of cost structure by 20%, resulting in accurate allocation
• Responsible for approval of Bills generated for all 600 suppliers every month
• Improved project’s cashflow by 12%, by presenting actionable insights on invoice changes to stakeholders by creating dashboards in Tableau and preparing analysis summary to reach key decisions
• Solved the compliance issue by performing Salesforce Audit on fulfillment policies/contracts with more than 600 suppliers
• Reduced time taken for variance analysis by 25%, by integrating forecast and actual sales data from Salesforce into Tableau
• Implemented ‘DocuSign’ for managing contracts and conducted training to new users using flow charts and presentations with graphics and charts
• Executed operations including billing of 3PL providers, invoice auditing and processing, performing ad-hoc analysis, creating Standard Operating Procedures and training documents, performing price analysis to use during negotiation calls, mitigating and solving payment reconciliation issues

Confidential, Boston, MA

Business Analyst

Responsibilities:

• Worked with stakeholders and management team in gathering various requirements for the project
• Written Use Cases, Use Cases designed detailed logical class and activity diagrams, other high-level process flows
• Worked on all phases of SDLC (Software Development Life Cycle) from inception to completion and Quality Assurance methodologies of Agile
• Worked with Tablea u administrator in managing Production, Test and Development environments.
• Developed data driven reports using SQL Server Reporting Services (SSRS)
• Utilized various tools to evaluate performance and implement remedies to improve performance, including tuning database parameters and SQL statements
• UML standard thus defining the Data Process Models
• Participated in all phases of Software Development Life Cycle (Agile, SCRUM, RUP, and Iterative)
• Performed Requirement Elicitation and Analysis and conducted C sessions for communicating with Stakeholders and Project directors during Iteration
• Assisted the Project Manager in creating proposals and project budget allocation and worked on Gantt Chart, Project charter and Work Breakdown structure (WBS) using MS Project
• Discussed requirements with other members of the team like the Application developers, Project Manager and Data Base Administrators
• Requirement Analysis and Business Proposal EPDM Utility- Regulatory Affairs Management through PLM
• Designed detailed logical class, use case, activity diagrams and high-level process flows
• Created user stories from the feedback obtained from the end users
• Interacted with clients to assess needs, identify key challenges, and define project Scope and deliverables
• Liaised with Business, Team Leads and PMs in global offices for various operations
• Interpreted customer business needs and translate them into application requirements
• Created reports to help users track cash flows by business areas/department
• Prioritized process in developing project plans, process flows, UML Model and Use Cases
• Maintained and update digital reports and dashboards based on client requirements.
• Identified and prepared business requirements- gap analysis
• Reported status, milestones, and project plan tracking to project management and project owners on a weekly basis. Used MS Visio for flow-charts, process model of the application

Confidential

Business Analyst

Responsibilities:

• Improved Client’s business operations by 20% by identifying scope and key areas of improvement in current business process and making recommendations to improve business actions
• Assisted the Supply Planning team by handling MRP workflows and scheduling replenishment of warehouse inventories in SAP to ensure optimal stock levels and managing global clients from Americas, Europe and Asia
• Working with the client to manage the claims and processing change requests in policies into the mainframe
• Coordinating Import/Export activities and tracking shipments for the client
• Perform Tableau Server admin duties; add users/groups from Active Directory; and schedule instances in Tableau Server including weekly data dump
• Building, publishing customized interactive reports and dashboards, report scheduling on Tableau Server
• Analyzed and optimized purchase requisition approval process by 25% by implementing a release strategy
• Experience with proper SQL testing procedures and strong understanding of deciphering results for accuracy
• Optimized SQL performance, integrity and security of the project’s databases/schemas to contribute to the optimization of data management and performance tuning
• Contributed to furniture retailer’s 15% revenue growth in 2016 by standardizing content from disparate databases, enabling sales and support staff to quickly respond to customer requests
• Performed User Acceptance Tests (UAT) by developing use case scenarios
• Innovated timesaving, robust employee data-intake system that automated database update functions, enabling new salary and process-exception information to be automatically populated
• Ensured adherence of 85% to the service level agreements by processing sales and purchase orders for client and maintained the corresponding master data in SAP to avoid discrepancies
• Conducted Project related presentations to senior management and the team
• Managed inventory flow to warehouses using Kanban and optimized logistics distribution networks for on-time delivery
• Assisted and worked with Project manager in creating and assigned task through Work Break-down Structure (WBS)
• Developed test plans to assist the Quality Assurance department to check the quality of the deliverable
• Defined the context of the system by creating various Use Cases for the development system requirements specifications encompassing Functional and Non-Functional requirements
• Auditing the bills generated towards client to make sure all the charges are included
• Tested and logged defects using JIRA. Assisted in the implementation of Confluence as the documentation space of choice, which allowed us the flexibility to integrate seamlessly with JIRA and forge a collaborative workspace
• Gathered requirements using JAD, document analysis, focus groups from key stakeholders, customers and SMEs
• Worked closely with Project Manager for any change request and helped to do Impact Analysis
• Manipulated and analyze large amounts of data to develop customer strategic insights
• Managed projects by creating project plans and tracking project milestones using Gantt Chart in MS Project
• Managing the responsibility of billing the clients for the services provided by the tech team and assisting the client for forecasting of CAPEX
• Gathering inputs from the tech team and managed documentation of technical and business processes
• Performed ad hoc project management activities like financial data analysis, gathering functional requirements, generating weekly and monthly reports, documenting, and troubleshooting project’s risks

Confidential

Supply Chain Intern

Responsibilities:

• Reduced transportation costs by $84,000 by performing root cause analysis and continuous improvement
• Optimized inventory by 15% by conducting FSN analysis to remove obsolete supplies to solve capacity constraints
• Performed operations like competitive bidding, creating RFQ, PO in SAP, coordinating on-time delivery, managing inventory levelling, identifying trends in inventory levels with Power BI using key performance indicators

Confidential

Electronics Intern

Responsibilities:

• Provided support to the lead Mechanical and/or Electrical Engineers in tasks such as part and assembly drawing/design or classification, engineering analysis and test, PLC/HMI programming, and support of proof-of-concept or final system testing.
• Worked issues across multiple functions including mechanical, electrical, fabrication, assembly, and sales.
• Performed routine tasks under close supervision using well-defined standards and procedures.
• Supported the development and documentation of standard procedures, design standardization, and engineering change notices.
• Used predetermined methods, sequences, and setups to perform job duties