Abhay (Green Card)

908-333-3807

3626 Barcroft View Terrace, Apt# 403

Falls Church, VA 22041 Sr. Business Analyst

PROFESSIONAL EXPERIENCE:

  • Having 6+ years of experience in working as a liaison between the business, developers and SME’s in an IT Business environment, serving as the link between Business, Mills and Plants in a Corporate environment and bridging between customer and the plant in a manufacturing and Supply Chain Environment (SCM). Hands on experience in data analysis, instrument handling, building diagnostics, troubleshooting and cross-functional team
  • In depth knowledge of Software Development Life Cycle (SDLC) with thorough understanding of various phases like Requirements Analysis, Design, Development and Testing.
  • Knowledge in Developing Power BI Reports and Dashboards from multiple data sources using Data Blending.
  • Conducted Joint Application Development (JAD) sessions with stakeholders throughout SDLC to resolve open issues
  • Worked with SMEs, and other cross functional Application teams, along with Stakeholders to elicit requirements by sharing the questionnaire and conducting JAD sessions
  • Experience in working with Data Cleaning techniques in ETL procedures.
  • Skilled at building and deploying multi-valued parameterized reports using Power BI, Tableau.
  • Excellent hands on experience in creating groups and measures, KPIs.
  • Extensively involved in Reverse-Engineering and Business Rules Extraction Expert in project planning, systems analysis and troubleshooting, quality control, forecasting, scheduling, planning, and tracking of results.
  • Created relationships, actions, data blending, filters, parameters, hierarchies, calculated fields, sorting, groupings, live connections, and in-memory in both Tableau and Excel.
  • Created customized reports using various chart types like, text tables, bar pies, tree maps, line charts, pivot tables, combination charts in excel and Tableau.
  • Create exceptional business/functional requirements documents using cases and product definitions
  • Good in defining business solutions in an IT environment as a business analyst role - working with business owners and IT development staff
  • Involved in creating views, stored procedures, and custom SQL queries to import data from SQlserver to Tableau.
  • Created Tableau worksheet that involves Schema Import, Implementing the business logic by customization.
  • Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle SQL Server and MS Excel.
  • Created documents for validation and verification against business unit requirements.
  • Extensive skills Business Modeling, and use case developing using UML methodology including Activity Diagrams, Sequence Diagrams, Data Flow Diagrams, Class Diagrams, designing prototypes and documenting them using Microsoft Visio.
  • Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
  • Developed story-telling dashboards in Tableau Desktop and published them onto Tableau Server, which allowed end users to understand the data on the fly with the usage of quick filters for on demand, needed information.
  • Involved in analyzing the user requirements and transform them into Tableau Dashboards and Reports.
  • Involved in designing and creating Dimensional Data models (star schema) for Dodge Global Network application and ENR Survey reports.
  • Executive dashboards, International DR's Usage reports for Sales Executives.
  • Developed complex data Visualization reports and dashboards related to User Activates, Trends on DGN application and Dodge Market Share, Build Share and Spec Share using multiple large volume data sources.
  • Extensively used Tableau feature like data blending, Extracts, Parameters, Filters, Calculations, Context Filters, Hierarchies, Actions, Maps etc.

Education:

MS, ES (Mechanical Engineering)

University of Mississippi,University,Mississippi

GPA3.8

Sep 2013-Dec2015

B.Tech (Metallurgical Engineering)

National Institute of Technology (NIT), Raipur,India

GPA3.4

Jul 2008-May 2012

Technical Skills:

Scripting Language: JavaScript, VB Script, AngularJS and CSS.

Markup Languages: HTML, DHTML, XML, XSL and JQuery

Database Development MS SQL Server T-SQL, PL/SQL, MS Access and Oracle

Business Methodologies: Waterfall, Agile (Scrum, Kanban, Lean, XP, Crystal, FDD), RUP

Tools:Jira, Microsoft Project, Microsoft Visio, Microsoft Office Suite, Rational Requisite Pro, Astah, Visual Paradigm, Edraw Max

Lean Quality Tools (FMEA, 5S, 8D, RCA)

Analytical Software: Minitab, JMP, Power BI

Project Management Software:MS Project, Gantter, JIRA, ALM

Operation System Windows 7/XP, Windows Server 2003, MS-DOS and Unix

MS Office: Word, Excel, PowerPoint, Access, OneNote, Publisher

Work Experience:

Blue Cross Blue Shield(Health Insurance organization) Tulsa, OK

Business Analyst Consultant May 2017 – Present

Responsibilities:

  • Bridging between the business problems and the technology solutions while overseeing migration of data from the legacy server
  • Working across multiple facets of the business community and the IT organization to provide technical solutions to meet user needs
  • Defined application problems (activation) by consulting with clients to evaluate procedures and processes
  • Analyzed system vulnerabilities,worked with IT and business teams to eliminate vulnerabilities in support of internal and external audits
  • Created and presented interactive graphical dashboards to facilitate insightful decision making
  • Elicited Business and user requirements.
  • Gathered requirements from key stakeholders, customers and subject matter experts to define the scope and requirements based on User Stories.
  • Worked closely with the development team to verify that business needs are fulfilled and deliverables are produced within specified budget, quality and time.
  • Developed Use Cases and Use Case Scenarios and visualized those using UML diagrams in MS Visio.
  • Elicit and document requirements, test plans, and system functional specification for Application Tracking System.
  • Supported users and reported the application issues and improvements in Jira.
  • Collaborate with Product Owners and stakeholders to prepare user stories as part of an Agile team.
  • Documented User Manual and facilitated UAT, and provided follow up to resolve the issues
  • Interface with internal business users as well as various IT development groups so the needs can be clearly understood, expectations managed and change initiated
  • Act as the point of contact between the business units and IT
  • Perform analysis for business applications
  • Develop and implement plans to suite business plans and objectives

Environment: Environment: ASP.NET 4.0, C# .NET, TFS, JavaScript, SQL Server 2008, Entity Framework, XML, HTML, Window 7, MS Project, PL/SQL, Microsoft Visual Studio, CSS

International Paper(Product Engineering Development, Containerboard Business in Industrial Packaging Group) Memphis, TN

Business Intelligence andProduct Engineer Jul 2016-Apr 2017

Responsibilities:

  • Automated and customized reports, schedules and subscriptions to facilitate daily reporting for end users
  • Interpret and Disseminate product manufacturing reports using CpK, CoV and distribution curves and presenting data to information
  • Designed SQL views and created Power BI dashboards for deep-dive analysis to improve manager response time by 80%
  • Established a unified Quality Standard System across all the mills in North America, this includes procedure, testing and standards
  • Conducting onsite and offsite mill audits based on quality norms and troubleshooting the issues based on symptoms with the team
  • Worked with cross-functional teams to solve real-time problems associated with data-sets to improve process efficiency
  • Saved 25% of time per tester with the Implementation of data acquisition in CCC labs, while working with the R&D team in Loveland
  • Testing, DOE, GR&R, diagnostics- NIR formation & packaging materials in creep environment
  • Lead, coordinate and track multiple disparate projects, using Gantter, MS project and A3’s following PDCA layout
  • Coordinating special projects within the International Paper community to explore new product and improvement options
  • Designed and created different ETL packages using SSIS from Oracle source, Excel, CSV Files, Text files, MS Access to SQL server as destination.
  • Designed and provided Ad-hoc and Parameterized clinical reports using SSRS in SQL Server Data Tools for the internal use and client presentation.
  • Created Pivot tables in excel using data from various sources like SSRS and MS Access.
  • Collaborated with fellow team members through Team Foundation Server for effective project management which includes work issues and track on the update of versions.
  • Diagnosing and tuning the server and query optimal performance using SQL Server Profiler and Database Tuning Wizard.
  • Created indexes on selective columns of patient records for the faster retrieval of data in SQL Server Management Studio.

Environment: MS SQL Server 2008, SQL Server Reporting Services (SSRS), SQL, (SSIS), SQL Server Data Tools, SQL Server Migration Assistant, SQL Server, SQL Server, TFS

Jabil Circuit(Supply Chain Management, Electronics Manufacturing) Memphis, TN

Business Analyst. Jan 2016 – Jun 2016

Responsibilities:

  • Diagnosing and tuning the server and query optimal performance using SQL Server Profiler and Database Tuning Wizard.
  • Created indexes on selective columns of patient records for the faster retrieval of data in SQL Server Management Studio.
  • Assess clients' needs, identifies and documents requirements critical to achieving business objectives
  • Develop understanding of business needs through discussion and meetings
  • Partner with the business and IT groups to find solutions for projects and operational issues
  • Define project business requirements as well as in defining the IT solutions
  • Develop, implement and maintain application software to established standards and specifications
  • Contribute to the business requirements development and the functional solution designs
  • Collaborate and coordinate with production, testing, quality, packing and shipping teams to ensure 100% on time delivery
  • Communicate daily with Fortune 500 customer on shipment priorities
  • Responsible for creating, tracking daily backlog, change implementation and weekly build plan, follow GMP’s (BP’s)
  • Optimization of bottlenecks, reducing downtime, tracking, creating and dropping orders using SAP, Shop Floors and E-Dashboards
  • Integrated supply chain system to create, release, drop orders and track WIP and inventory using SAP

Environment: SQL, Agile, MS Project, MS Office suite, MS Visio, MS PowerPoint, Oracle, Rational Requisite Pro, Quality Center.

University of Mississippi (Materials Science Lab, Engineering and NCNPR)

University, MSGraduate Instructor, Research Assistant, ESB Tutor Sep 2013–Dec 2015

Responsibilities:

  • Sample preparation in compliance with ASTM standards, coordination and perform experiments, handled equipment
  • Design 3-D models from concept tofinal prototype (modeling, 3-D Printing), manufacturing drawing and BOM
  • Validating application aspects of prototypes, boosting their performance with design or compositional changes
  • Facilitated and proctored exams, graded papers and conducted doubt and teaching sessions.

JSW Steel Ltd(Integrated Steel Plant) Toranagallu, KA

Product Development and Quality Control Engineer(JuniorManager) Jan 2012–Sep2013

Responsibilities:

  • Co-ordinated with customer, manufacturing, design and shipping teams about effective communication and diagnostics
  • Developing new grades by modifying its composition and defining and modifying manufacturing process based on end application
  • Visiting customer to analyze the complaint, following up with necessary troubleshooting actions and following
  • Performing FMEA, CAPA (Corrective Action/Preventive Action) and root cause analysis for defect analysis, reduction and prevention
  • Reading and modifying drawings, BOMs, and standard operating procedures to streamline workflow and production
  • Following safety protocols (Personal Protective Equipment PPE), 5S, GMP’s, SOP and ISO standards to maintain compliance