SUMMARY

• Experienced Business Analyst with proven expertise in business process/business standards, customer relationship, development, data movement, mapping & profiling, and business management; adept Confidential handling complex scenarios pertaining continuous process improvement
• Business Analyst with 9 years of Business analysis experience with expertise in business processes, project leadership, risk and change management
• Thorough understanding of the Software development life cycle (SDLC: RUP, Waterfall and Agile) including but not limited to development of web servers, requirement elicitation and implementation
• Experience in facilitating Joint Application Development (JAD) sessions with IT Groups and Conflict Management within projects
• Proficient in Business modeling, Data Analysis, requirement validation and technical documentation
• Responsible to Document, track, Manage and Communicate the Requirements using Requirement Traceability Matrix (RTM)which help in controlling several artifacts produced by the team members across the project
• Expertise in developing Use Cases, creating screen mockups, Impact and GAP analysis, Risk analysis, Activity diagrams using MS VISIO
• Interface between business users and project team to prepare and update Business Requirement Document (BRD) and Functional Requirement Document (FRD)
• Experienced in Project Management i.e. Project Scoping, Planning, Estimating, Scheduling, Organizing, Directing, Controlling, Budgeting and Drafting Remedy Procedures.
• Proficiency in broad range of technologies, including business process tools such as Microsoft Project, MS Excel, MS Access, MS Visio, technical assessment tools, Data Warehousing concepts and web design and development
• Strong experience in conducting User Acceptance Testing (UAT), writing test cases, developing Test Plans and validating test results
• Possess a detail oriented nature with excellent interpersonal, communication skills, documentation, problem solving skills and leadership qualities

TECHNICAL SKILLS

Methodologies, Tools and Applications: SDLC, Rational Unified process (RUP), Rumba (HOST), UML, Systems engineering methodology (SEM), Agile, V - Model, Six sigma, Lean, Rational product suite, PMMT, MS Project, MS Visio, MS Office, Lotus notes, Wiki, Share point, HP Service Manager

Programming Languages: HTML,C,C++, Cold Fusion

PROFESSIONAL EXPERIENCE

Confidential, Bloomington, IL

Lead Business Data Analyst

Responsibilities:

• Currently the SIPOC and data movement lead data analyst responsible for making business data related decisions
• Developed High Level Logical Data Models and BRDs (Business Requirement Documents) supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the actors to analyze and document business data requirements
• Assisted in the development of a Data Warehouse for personal lines of insurance namely AUTO (UAX, ICP), FIRE Enterprise/Internet application (Homeowners, Renters and condo, ICP), HUB Base, UDP, EUI,CUI
• Extensively worked under supervision in performance measurement of ongoing data collection to determine if the input XML matches the output XML.
• Experienced in validating and testing the code in message broker (MB) that is responsible for filtering the input XML and sending through to the output XML and to the File Writer (FW)
• Responsible for maintaining, validating and reviewing the quality of data being filtered through the file writer to the federated data warehouse (FDW) tables
• Analyzed data with discrepancies through Error files and Log files to further manage broker and file writer queues
• Designed, Developed, updated and maintained the source to target mapping documents in order to better understand the movement of data
• Profiled data according to the business source elements, their descriptions, business rules and the containers they belong to and the respective product models
• Responsible for understanding the current data capture points and developing more efficient capture points for the product lines being introduced into the new integrated customer platform
• Accountable for Business requirements reviews, File Writer reviews, FDW reviews, Message Broker reviews and testing walkthroughs
• Developed and maintained project documentation to communicate requirement deliverables, impacts and dependencies and ensured that the documents satisfy Confidential standards
• Clarified and prioritized requirements and business volume metrics with the SME’s, architects, developers and the stakeholders by conducting brainstorming sessions
• Accountable for day to day impacts, Risks, and business knowledge transfer
• Developed Use case, workflow and activity diagrams to depict workflows using MS Visio

Confidential, Atlanta, GA

Sr. Business Analyst/Data Analyst

Responsibilities:

• Analyzed Adjudication process and helped in creating the Business Process Flow diagrams
• Interfaced with business users to prepare and update Business Requirement Document (BRD) and Functional Requirement Document (FRD)
• Worked with the DBA to provide data to the development/Testing and the Production Environment
• Tracked and maintained the Action/Issues/Risks folder for the project team
• Developed Microsoft Share Point site for the Project and maintained flow of project documents within the business, development and the project management teams
• Analyzed adjudication process and developed Use Cases for capturing functionalities for all interactions of the project.
• Conducted JAR sessions with the project team to collate requirements and traced those to the requirements list, which then was traced to the Use Cases
• Defined the Roles and Responsibilities for the system and was responsible for collating field office employee list for loading into the system. Traced Access and Privileges rights for the system.
• Assisted project manager in creating WBS and cost Estimations
• Monitored production ETL applications
• Responsible for defining the data tables and mapped the data source for all tables list.
• Responsible for Business Acceptance Test Scripting. Created formats to be used for the testing and assisted business teams in writing the test scripts
• Created and presented System Testing tracking sheet

Confidential, Baltimore, MD

Business Analyst

Responsibilities:

• Gathered detailed business and technical requirements and participated in the definitions of business rules and data standards
• Used MS-Visio for flow-charting, Use- Case process model and architectural design of the application
• Created Business process workflow diagrams using IBM business process modeler
• Developed business proposals and RFP responses and trained others in this capability
• Helped with the design scope documents and the Request for Proposal (RFP) after extensive ROI analysis and coordinated with top management for the approval process
• Designed and developed use cases, activity diagrams, and sequence diagrams using UML
• Performed Gap Analysis of the processes to identify and validate requirements
• Design, development, implementation and roll-out of Micro strategy Business Intelligence applications
• Applied a detailed COCOMO for determining the cost driver’s impact on each step of the project life cycle
• Testing ETL objects properly, Preparing Unit test case
• Prepared questionnaire based on the System Analysis Performed for all entities.
• Generating High Level Architecture, High Level Design, ETL Mapping, OLAP Reporting and Process Flow diagram documents

Confidential, Moreno valley, CA

Business Analyst

Responsibilities:

• Improved the workflow and efficiency for the two most important departments of the company - shipping and Hotel (Inventory) by designing a value stream map and developing the existing processes.
• Decreased the operating costs, improved the work flow and increased productivity by 20%.
• Managed & built Engineered Labor Standards for multi-variable production operations.
• Achieved estimated savings of 15,500 labor hours in 2010.
• Recommended resource optimization and process standardization to increase savings by $90K annually.
• Redesigned the layout of shipping department, using lean principles and increased productivity by 30.2%.
• Played a crucial role in implementing hourly incentive program called ‘Blue Chip’.
• Optimized raw material order quantities and reorder points to save $30K in inventory carrying costs.
• Developed a set of guidelines to reduce costs in the division through value improvement programs.
• Developed and implemented staffing matrix that helped the supervisor’s make effective staffing decisions.
• Prepared and maintained engineering documentation including performance guides.
• Assisted in training new hires on engineered labor standards and incentive programs.
• Advised management with economic justification studies and implementation of engineering methods.
• Assumed project leadership roles in partnership with associates, managers and VP’s.

Confidential

Business Analyst

Responsibilities:

• Performed detailed comparative analysis of response to RFP’s of vendors and Graphically Represented the recommended solutions in PowerPoint to Senior Management
• Actively interacted with different business groups to perform Gap analysis to identify the deficiencies in the system by comparing the actual objectives with the system objectives desired.
• Performed Gap Analysis of the processes to identify and validate requirements.
• Provided business intelligence analysis to decision-makers using an interactive OLAP tool
• Performed extensive data modelling to differentiate between the OLTP and Data Warehouse data models
• Designed and developed Project document templates based on SDLC methodology
• Helped with data modeling and defining the conceptual and logical model of the data warehouse.
• Tuned the batch programs and online transactions to alleviate performance problems.
• Developed & executed several Optimized queries in SQL on this data.
• Tested Performance & Accuracy related queries under SQL Server.