OBJECTIVE:

• Adaptable Data Analyst skilled in recording, interpreting and analyzing data in a fast - paced environment.
• Advanced proficiency in all aspects of Excel.
• Experienced in preparing detailed documents and reports while managing complex internal and external data analysis responsibilities includes Data Quality issues, and Data Profiling.

SUMMARY:

• 5 years of experience as a Business Analyst
• Highly proficient in working with stakeholders to gather, analyze, model and subsequently use various tools to capture, trace, and manage changes in requirement documentation
• In-depth knowledge of creating and writing Functional Requirement Document, Business Requirement Documents, Use Cases, Activity Diagrams, Logical, Component and Deployment views to extract Business Process Flows
• Extensive experience in various types of UML artifacts including Activity diagram, Use Case diagram, Sequence diagram, Collaboration diagram, Class diagram, Component diagram, Data Flow diagrams and ER diagrams
• Proficiency in using tools to organize, track and change software requirements as well as developing project plans and managing midsized teams
• Efficient in conducting collaborative workshops like JAD sessions and walkthroughs involving executives, stakeholders, developers and end users
• Sound understanding of SDLC
• Experience in conducting GAP analysis, User Acceptance Testing (UAT), SWOT analysis, Cost benefit analysis, Impact Analysis and ROI analysis
• Highly skilled in developing Test Plans, Test strategies, and Creating and Executing Test Cases for highly customized applications
• Experience in writing queries/scripts for Data Analysis.
• Excellent business, communication (written and verbal), and presentation skills
• Skilled in effectively communicating across the broad spectrum of stakeholders without compromising accuracy or detail
• Adept at reducing development costs and providing traceability of projects
• Knowledge on Data Quality and Experienced on the techniques to eliminate outliers
• Proficient in cleaning and transforming data: Formulas, flash fill, power query and text to columns used the advanced Microsoft Excel, Pivot Table, If error, v-lookup, match, conditional formatting, functions, left, mid, right, replace, substitute, string, Trim, Proper, find and replace, go to special, paste special, data validation, Pivot Tables, and Macro
• Proficient in data pattern

TECHNICAL SKILLS:

Data AnomaliesNormalization: 1NF, 2NF, 3NF, BSNF

Communication System: User Interface, Pattern Evaluation, Data Mining, Data Warehouse { Data Mart }, OLAP Cube, Primary Key, Foreign Key, Surrogate Key

Data Models: Subject Area Model, Conceptual Model, and Conceptual Entity Model

ETL: SSIS

Data Source: OLTP, External, Historical Repository of Data, Knowledge Base, Data Reporting

E-R Diagram: 1-1, 1-M, M-M (Cardinality)

World Wide Web: MS Visual Studio, ASP.Net using C# and Wireframe, Mockingbird, and Balsamic, Business Rules and Data Rules

Data Management: My SQL, USE Cases Data Cleansing, Data Selection, Data Integration, SAP NetWeaver BW

Information Systems: Zap Business Intelligence, and Power BI, Big Data

Model Management: Statistical tool like R, SAS, MapReduce/, Hadoop, Lucid Chart, BPMN, MS Visio, Basic Statistics

ERP: SAP Functional, and SAP Configuration; Dynamics AX, Windows Server 2012 Virtual Machines, Data Quality (DQ), Data Discovery

Microsoft Project, and MS Office Suite: Word, Excel, Access, and Power Point

Cyber Security:  Data Governance Process, Master Data Management (MDM), Data Governance Audits, Data Profiling, Data Validation

WORK EXPERIENCE:

Confidential  

ERP integration Analyst

 Responsibilities:

• Data Validated and cleaned data on excel, used formulas, string, left, mid, right, replace, match, if error, v-lookups, Trim, Proper, and used Conditional formatting, count, sort, filter, pivot table, Macro, data validation, etc. and insert data into new ERP System
• Proficient in cleaning and transforming data
• Made data pattern
• Changed and matched data types before migrating data to Microsoft Dynamics Navision ERP
• Proficient in Data Profiling

Environment: Advanced Excel

Confidential

Cashier

Responsibilities:

• Successfully handling retail operation on the front-end area

Confidential

Data Analyst

Responsibilities:

• Gathered requirements, and Analyzed for the monthly reporting purposes
• OLTP data extracted from ERP, Dynamics Ax 2012 and transforms and load to Excel
• Mitigated errors using Advanced Excel Techniques for Data Analysis, Data Management and Data Validation
• Used ETL techniques for SQL Server Management Studio
• Made Database Design, Star Schema, Snowflake Schema, Various including complex type of SQL Queries applied for the customized reports
• OLAP Cube was made on Inventory and sales for the data analysis and reporting purposes and used main five functions, drill down, roll up, dice, slice and pivot for the data analysis
• Created dashboard report for the presentation

Environment: MS Excel, Dynamics AX, MS Access, SQL, ZAP BI, SIS

Confidential

Customer Service Manager

Responsibilities:

• Successfully Managed retail operation on the front-end area
• Integrated team members in process to make sure quality customer service was delivered
• Ethically handled transactions and delivered proper guidance to team members and customers
• Generated audit reports to make sure transactions were accurately reflected

Confidential

Cashier

Responsibilities:

• A Successfully Managed retail operation on the front-end area

Confidential

Cashier

Responsibilities:

• Successfully handling retail operation on the front-end area

Confidential

Assistant Store Manager

Responsibilities

• A Successfully Managed store

Confidential

Cashier

Responsibilities:

• Successfully handling retail operation on the front-end area

Confidential

Cashier

Responsibilities:

• Successfully handling retail operation on the front-end area

Confidential  

Cashier

Responsibilities:

• Successfully handling retail operation on the front-end area

Confidential, Chicago, IL

Business Analyst Course

Responsibilities:

• Certification in Business Analyst
• Did Academic Projects

Confidential

Operation Support III/Business Analyst

Responsibilities:

• Acted as a liaison between the company and the business partner in support of gathering and documenting requirements, developing process flows, writing use cases, specifications and in writing user guides to meet project objectives
• Developed test plans and Scripts to test the FACET based e- workflow for the Claims routing processes
• Followed RUP quality Assurance and Testing Process; Interfacing with program management and executive teams regarding quality assurance goals
• Developed prototypes for the UI and also helped in development of screen navigation flows
• Maintained project plans, task, defect and issues lists, lead meetings to discuss all aspects of the project’s execution, developed test scripts, executed UAT, participated in the QA process, and developed training materials and system documentation
• Designed and developed Detailed Technical Specifications for several Use Cases
• Created Use Cases, Use Case Diagrams, Activity Diagrams to demonstrate software architecture and interaction of system components before prototyping
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the database
• Maintained the requirements traceability matrix and ensured that the requirements were consistent after changes
• Ensured a high level of data quality including data analysis, creation of scrubbing and augmentation rules and data quality reporting
• Participated in tracking defects and change management using Clear Case and Clear Quest
• Executed all efforts within the SDLC parameters of the IT organization leveraging existing technologies, proven system architectures and management team.

Environment: Cognos, MS Excel, MS Access, Expense Manager

Confidential

Cashier

Responsibilities:

• Successfully handling retail operation on the front-end area

  Confidential

Cashier

Responsibilities:

• Successfully handling retail operation on the front-end area

  Confidential

Business Analyst

Responsibilities:

• Achieved Import Export License through legal compliance of the government requirements
• Accomplished the tobacco wholesale licenses from various states in short time frame
• Attained various permits from Village; Set up an export procedure
• Handled criminal investigation and obtained wholesale tobacco licenses from various states

Environment: Adobe Acrobat, MS office

  Confidential

Business Analyst

Responsibilities:

• Involved in requirement analysis, design and testing for Internet based business
• Developed user friendly, functional, fast, and intuitive web content and structure for intranet or extranet sites
• Worked closely with multi-disciplinary teams including project managers, business analysts, designers, and systems personnel to translate website requests and apply online
• Participated in all phases of the software development lifecycle
• Supported outside agency to deliver business solutions to streamline processes
• Project manager for design, automation, and solution development of various applications, including integrating existing user-developed Access databases into SQL server back-end and modifying front-end screens
• Analyzed business models, logical specifications, and user requirements to design and test solutions for application environment
• Employ activity and data modeling, transaction/workflow analysis, internal control and risk analysis, and performance-measurement techniques; Defined disaster recovery plan, recommended options, and created user manual. Led tool evaluation
• Prepare reports, studies, and documentation. Deliver presentations and lead meetings
• Supported development of Access applications for product management group, involving analysis, design, coding, and testing of components; Worked with end users to develop specifications for coding; Assisted outside developers in creating project plans and progress reports

Environment: C#, Visual Studio, MS Excel, MS Access, Quick Book, Tenant Pro

Confidential

Business Analyst 

Responsibilities:

• Interacted closely with the Subject matter experts (SME) for the functional requirements gathering
• Conducted interviews, Q and A sessions with business users to solicit business requirements relative to proposed functionality and created Functional and Non-functional requirements
• Worked closely with the development team to clarify and understand functionality, resolve issues and provided feedback from the UML diagrams
• Created Use Cases and Business Use Cases model after accessing the scope and status of the project and understanding the business processes form USER perspective
• Analyzed, collected and prepared user requirements, definitions, scope and expectations for deliverable plans and delivered system documents, processes, diagrams
• Defined business processes, identified gaps, evaluated requirements and change requests, managed scope and transferred knowledge
• Developed and managed all the work plans, acted as the key client contact, handled all kinds of scheduling, ran all status meetings and compiled various reports

Confidential

Business Analyst

Responsibilities:

• Worked on billing operations like rating one-off products, creating rating systems for new customers and products, maintaining internal price books, drafting user guides for new systems
• Improved customer satisfaction and retention rate through Change Management and Process based Management
• Created templates & Worked on several reports and manual billing processes (MS Access) to expedite the process; and reduce errors and discrepancies
• Worked extensively on MS Access and created invoice summary reports
• Worked extensively with MS- Visio to present processes graphically; created the AS-IS and TO-BE process flows
• Coordinated weekly status reports; presented ideas and diagrams to get the business users
• Worked on all stages of the migration, which included requirements, specifications, design, and analysis
• Created check-points in the system for audit control (Inventory Control) as well as for easy tracking through various stages