SUMMARY

• Over 8 years of IT experience in Business Systems Analysis, Requirements Management, Product / Project / Release Management. Involved in enterprise - wide development initiatives including new development, legacy data migration, Data Modeling, Commercial Off-The Shelf (COTS) implementation and enhancement projects.
• Led business analysis and elicitation for application development projects using Agile, Rational Unified Process (RUP), and Waterfall processes
• Proficient in Use Case Models, Data Flow Diagrams (DFD), Entity Relationship Diagrams, Activity Diagrams and State chart diagrams
• Skilled in conducting Joint Application Design (JAD) and Rapid Application Development (RAD) sessions, brainstorming sessions, requirement reviews, document walk-through & customer interviews
• Experience in Functionality, Usability, Reliability and Performance testing
• Experience in repository management using SVN and GitHub
• Creating Change Management Proposals and interaction with Change Control Board (CCB)
• Coordination with UX team in conducting usability studies
• Conducting GAP analysis, SWOT analysis, Cost benefit & ROI analysis
• Experience working in cloud-based Software-as-a-Service (SaaS) environment
• Proficient in User Acceptance Testing (UAT)
• Strong analytical, interpersonal, communication and problem-solving skills
• Timely execution of client/server projects
• Experience in training the business end users.

TECHNICAL SKILLS

Business Modeling Tools: MS Visio, Balsamiq, Star UML, Visual Paradigm, Gliffy

Processes: Agile, Waterfall

Requirements Management: Confluence, Quip, Box, Rational Rose

Repository Management: SVN, Change Management

Project Management: Jira, Confluence, MS Office Suite, MS Project, Smartsheet, Databases, Data Modeling, Database Tools

BI Tools: Oracle, MS Access, SQL Server, MySQL, SQL Developer Data Modeler, MS Visio, SQL Developer, SQL*Plus, TOAD, Oracle EDQ, Tableau, SSRS, OBIEE, Crystal Reports

PROFESSIONAL EXPERIENCE

Confidential, Weston, FL

Business Analyst

Responsibilities

• Efficiently handling business/IT related Jira tickets ranging from small to large, in order to reduce the backlog of the DMS (Data Management Services) department
• Gathering requirements using elicitation techniques such as JAD (Joint Application Development) and brain storming sessions, interviews, weekly meetings with SMEs and Stakeholders from different departments
• Development of Business Intelligence (BI) reports such as CIO (Chief Information Officer) Dashboards, Product Usage reports for applications such as Benefits Prime, Perception, UltiPro Learning, Payroll etc. using Tableau. These reports led to metrics related to the product usage for making profitable business decisions
• pertaining to billing and invoicing customers for various products using SSRS (SQL Server Reporting Services)
• Proficient in using Confluence, Box and Quip to store requirements and other project related documents
• Actively collaborating with the Product Owner in creating product backlog, estimation, acceptance criteria and user stories prioritization
• Adeptly processing tickets relating to data modeling and ETL (Extraction Transformation and Loading) process to bring the data from various data sources to the DMS department’s data warehouse
• Developing user manuals and training customers/product users in process flows and system changes.
• Managing a 5-member team comprising of two Data Engineers, one Data Analyst, one Database Administrator (DBA) and one Quality Assurance (QA) tester
• Leading multiple projects and providing back end services to support efficient functioning of several business departments
• Working closely with PRC (Privacy Rights Clearing House) and Security teams in order to ensure there is no breach of customer privacy agreements, and PII (Personally Identifiable Information) is secure against outside networks
• Maintaining a cordial working relationship with all the stake holders, SMEs, team members and product owners for smooth and successful completion of the projects
• Active scrum master: Daily standup meetings. Encouraging team members to come up with new/out of the box ideas or suggestions that can be incorporated for efficient completion of the projects.

Environment: SQL Server, SQL Server Management Studio, SQL Server Reporting Services, Balsamiq, Tableau, Gliffy, Smartsheet, MS Office Suite, Box, Quip, Jira, Confluence

Confidential, PA

Business Systems Analyst

Responsibilities

• Created Project Vision Document (PVD) by conducting interviews and meetings with the Product Owners, Stakeholders and End Users
• Used Jira and Confluence as the team’s Agile management tools
• Assisted Product Owner in creating Product Backlog, Product Backlog Estimation, Acceptance Criteria and User Stories prioritization
• Participated in Sprint Planning, Daily Scrums, Sprint Reviews and Sprint Retrospective
• As part of user story grooming, developed UML artifacts such as Use Case, Activity and State Chart diagrams using Visual Paradigm
• Used Balsamiq to create and visualize user interfaces
• Used SQL Developer Data Modeler to carry out modeling for GET Gas module
• Developed Commercial Sales, Lead Activity by CL (Customer Liaison) and Work Package reports utilizing Tableau, OBIEE and Crystal reports
• Assisted scrum master in removal of impediments for the development team
• Developed user manuals for the different components of the project.

Environment: Oracle 11g, SQL*Plus, TOAD, SQL Developer Data Modeler, Balsamiq, Tableau, OBIEE, Crystal Reports, Visual Paradigm

Confidential, PA

Business Analyst

Responsibilities

• Used Waterfall Methodology for the successful completion of the EBS project
• Regularly interacted with the client and business end users to understand the functional requirements and process flow of the project
• Interacted with clients (Ratings Analysts) to elicit the requirements and translated them into specifications for Pay My Bill, Billing History and Paperless Billing components
• Developed Functional Requirements Document (FRD), Activity Diagrams (AD) and Use Case Diagrams (UCD) for EBS system using Visual Paradigm and MS Office suite
• Conducted brain storming sessions with the business stake holders and developed Business Requirements Document (BRD) using MS Visio and MS Word
• Developed Requirements Traceability Matrix (RTM) to link the requirements of the EBS project with test cases to ensure all requirements defined for the system are tested
• Actively assisted the testing team in carrying out the test process
• Developed user manual and assisted in business end user training.

Environment: Oracle 11g, .net, Java Script, HTML, CSS, TOAD, Visual Paradigm, MS Office Suite, MS Visio

Confidential, IL

Business Analyst

Responsibilities

• Worked with the business team to collect the business requirements and authored Business Requirements Document (BRD) using Rational Rose
• Developed Functional Requirements Documents (FRD) by interacting with the SME and Business Stakeholders
• Conducted user interviews, gathered requirements, and analyzed the requirements using MS Visio
• Participated in the logical and physical design sessions and developed design documents
• Assisted with data conversion activities using Toad as the database tool
• Assisted the Project Manager in planning the project, scheduling and tracking the deliverables using Microsoft Project
• Analyzed change requests and worked with the change management board
• Used SVN for version control of project documents
• Documented test cases for the Order Processing component
• Assisted the testing team in functional, system, regression, and integration testing.

Environment: Oracle 10g, Toad, MS Visio, MS Project, MS Office Suite

Confidential, Tallahassee, FL

Business Data Analyst

Responsibilities

• Developed Application Work Flow by interacting with application developers, SMEs and project manager
• Created data models for the FACT system by using Erwin and MS Visio
• After analysis, consolidated Oracle forms and reports, System tables and fields and created a centralized database
• Developed regression test cases for database structure changes
• Developed user manuals and conducted user training sessions for the changes in the system.

Environment: Oracle 10g, Toad, MS Visio, Erwin, Oracle Forms and Reports

Confidential

Database Programmer

Responsibilities

• Created database objects - tables, views, materialized views, stored procedures, functions, packages
• Applied tuning techniques to queries using EXPLAIN PLAN and Indexes for faster retrieval of data from the database
• Used SQL*Loader to load data (flat files) from external sources into the database tables
• Moved files between application & FTP servers using FTP commands to facilitate the data loading process
• Scheduled cron jobs to send reports and emails to the client and internal team at specific times
• Created DB Links for accessing objects across databases
• Used DBMS JOB feature to schedule jobs at the database level for data manipulation purposes
• Used UTL FILE feature to extract the data from the database into simple, flat files
• Effectively used triggers to avoid mutating table error problems and deadlock situations
• Handled errors using exception handling for ease of debugging.

Environment: Linux, Shell Scripting, Oracle 10g, SQL Developer, HTML, WinSCP, PuTTY