PROFESSIONAL SUMMARY:

• Over 8 years of IT experience as a Lead Business Analyst, Systems and Technical Consultant, and in Software Development on different domains including finance, telecom, health care, manufacturing, and data analytics.
• Seasoned in all phases of the Software Development Life Cycle (SDLC) including Requirement gathering, Design, Development, Testing and Deployment.
• Experience in IT implementations and Data Migration on both technical and functional requirements of Supply Chain Management, Customer Relationship Management, Finance, and Human Capital Management.
• Experience in coding on SQL, PL/SQL, Shell Scripting, JAVA and HTML.
• Involved in Data Warehousing Design.
• Experience in creating the reports and Data warehouse tools and concepts.
• Potential knowledge and applicability in coding and development process in understanding the requirement by its Functionality, Development and Testing with all possible scenarios.
• Functional working capability towards documentation of entire Enhancement request life cycle including Requirement Gathering, Technical Design, Change Request, Test Case, Issue/Defect logging, Installation document, Review documents, Pre - builds and Post Builds Checklists as per CMMI Standards.
• Extensive knowledge on Project Charter and Project Management Plan.
• Extensive knowledge in HealthCare Insurance domain.
• Performed Functional, Technical, Integration and GUI testing’s including various business scenarios on Oracle Reports, Form Personalization and Functionality testing on Customized OAF pages.
• Experience as a developer aids in understanding the development environment as a Business Analyst.
• Created SQL-Loader scripts to load legacy data into Oracle staging tables and wrote SQL queries to perform Data Validation and Data Integrity testing
• Experienced in multiple Project Life Cycle and SDLC methodologies including Waterfall and Agile.
• Adaptive at prioritizing and completing tasks to meet customer needs, yet flexible to multitask when necessary.
• Experience in leading and managing teams.
• Experienced in conducting Joint application Development (JAD) sessions with the end-users, Subject Matter experts (SME) and QA teams.
• Comprehensive knowledge in writing test cases, test scripts and test plans.
• Experienced in conducting User Acceptance Testing (UAT) and Smoke Testing.
• A team player who is attentive to detail, committed to quality and excellence with a good record of meeting deadlines.
• Experience working with off-shore and remote teams.
• Highly diplomatic and able to bring different groups to consensus.
• Creative and aggressive person capable of maintain a positive team environment.

TECHNICAL SKILLS:

ERP: Oracle R12 and Sales force CRM

Oracle Technologies: SQL, PL/SQL, Oracle Reports 6i/10g, XMLP Reports, Oracle Discoverer Reports, Oracle Application Framework(OAF)

RDBMS: Oracle 9.x, Oracle 10g

Languages: SQL,PL/SQL, C, JAVA, Shell, HTML

Tools: JDeveloper 10g/11g, SQL developer, SQL Plus, SQL Server, Toad, Report Builder, FileZilla, Oracle Discoverer tools(Administrator, Desktop, Plus and Viewer), Salesforce Data loader, Microsoft Office, Adobe Photoshop, Microsoft Project, Microsoft Visio.

Operating Systems: Windows2000, Windows98, Windows XP, Windows Vista, Windows 8 UNIX, LINUX, MAC

Functional Areas: SCM: Order Management and Purchasing

HCM Core: HR and Oracle Learning Management: CRM: Quoting and Depot Repair

Methodologies: CMMI, Agile Software Development, Waterfall, SDLC

PROFESSIONAL EXPERIENCE:

Confidential, Shoreview, MN

Business Analyst/Project Manager

Responsibilities:

• Interacted with business leads to identify the requirements of various parts of the system
• FollowedAgile/SCRUMmethodologywith 2-week iterations
• Worked with business partners to develop User Stories, User Interface, Process Modeling, Work Flow Analysis and Functional Specifications
• Analyzed the process of the current inventory system and created user stories to remedy problems
• Reviewed user stories with business users to negotiate changes in the process to gain agreement on direction and content of stories
• Worked with the IT team to make them understand the requirements
• Organized and facilitated large JAD sessions (15 to 20 people) with customers and internal stakeholders with the purpose of defining and documenting the functional business requirements
• Worked as a bridge betweenthe businessteam and IT team to get clarifications needed from either side
• Worked closely with Technical Architects to help convert requirements to functional design documents
• Assisted the development team with the changing requirements
• Worked with Project Managers to identify, document and communicate short-term project plans
• Led a team of 4 BAs
• Maintained a close and strong working relationship with teammates, developers, testers and management staff
• Facilitated walkthroughs between technical and business teams for meeting business requirements as well as solving problems on a daily basis
• Helped conduct UAT testing and ensured that the application met the highest quality standards
• Performed GUI testing to check whether the application compiles with the User interface standards
• Worked closely with contractors, vendors and clients to ensure all were on the same page
• Updated and managed SharePoint site for the entire project
• Analyzed documents and created reports, including graphical presentation to be presented to Steering Committee meetings
• Managed resource allocation and budgeted hours
• Ensured PMO was apprised on the status of projects
• Maintained Project Plans in Clarity
• Prepared teams for project audits

Confidential, Bedford, MA

Sr. Business Systems Analyst

Responsibilities:

• Conducted a walkthrough session of the scope document to ensure that the project sponsors and stakeholders understood the project scope
• Managed relationship with key partners and stakeholders
• Worked closely with other project teams to uncover dependencies
• Prioritize roadmap items /across iterations.
• Steered and reviewed story approach (e.g. use cases, customer experience, technical solutions, etc.)
• Helped business and technical teams to identify any associated early constraints, risks or issues
• Conducted Data Migration using a similar data model as in Oracle Database to transfer the data from Oracle Database to the salesforce cloud.
• Wrote Business rules and Operational rules and documented the business and associated validation logic
• Prepared Business Requirement Documents for the data migration from Oracle to Salesforce.
• Regression testing of the functionality has been done. Data Conversions and the Monitoring were done during the test process.
• Prepared Data Flow and Visio Diagrams to review the future state of the business processes
• Prepared for and conducted iteration kick-off meetings with Business Users, Lead BSA, Project Manager, Development and QA teams to document Product Backlog Items (PBI)
• Worked closely with the merchandising and inventory control business teams to prioritize Product Backlog Items (PBI)
• Participated in daily SPRINT sessions with 3-week iterations
• Helped develop User Stories, and maintain Story Boards in Rally
• Reviewed user stories with business users and got their approval
• Created screen mockups to review the requirements and provided feedback on the screen designs
• Facilitated discussions around solution design and documented action items and System Flows, highlighting integration between multiple systems
• Acted as the requirement Subject Matter Expert (SME) for the architects and the development team
• Helped prepare for and conducted User Acceptance Testing (UAT)
• Performed GUI testing to make sure that the final product was in line with the business needs
• Interacted with the users and logged any defects, or enhancements from the UAT
• Reviewed and prioritized the defects identified by the Quality Assurance (QA) team and assigned them to the development team
• Supported assigned project manager in creating detailed project plans, tracking project timelines and provided weekly status
• Performed knowledge transfer to the merchandising and inventory control teams
• Created End-User Manuals as well as documented Release Notes
• Worked with the Group to provide any suggestions to assist in User

Confidential, Billerica, MA

Lead Business Analyst

Responsibilities:

• Worked with business users and stakeholders to understand, and analyze the current business processes
• Created WBS (work break down structure) for the project team
• Presented weekly status with PM at steering committee meetings
• Managed team of 3 BA’s throughout the project
• Took charge and assisted in resolving issues and roadblocks, escalating where needed
• Prepared documentation and diagrams to develop a comprehensive depiction of the existing business processes including Process Flow Diagrams and Interaction Diagrams
• Broke down processes into sub-processes and created process maps and user interface definitions for each sub-processes
• Conducted GAP Analysis to uncover root causes of the slow billing process by shadowing the operations team filing this information manually
• Worked closely with the operations team to document refined business processes and corresponding new business requirements to fill the gaps identified
• Prepared and maintained Business Rules Spreadsheets (BRS) identifying rules and triggers
• Prepared Business Requirement Documents (BRD) and created Use Cases using UML after conducting requirements elaborating sessions with the stakeholders
• Led requirements walkthrough sessions with stakeholders and the business team to ensure that all their needs are met
• Incorporated the business requirements into workflow to depict various scenarios
• Documented and followed the methodical Change Management Process for any change requests in the requirements after the requirements were finalized
• Led cross-functional teams to analyze and understand the operational impacts and opportunities of technology changes
• Represented business in bringing about the technical changes in line with the business requirements
• Served as the Subject Matter Expert (SME) in JAD sessions with IT to help document technical requirements
• Helped the QA team to create Test Plans and Test Scripts
• Helped prepare for and conducted UAT and End-to-End testing of the new system to make sure that all the components are working properly
• Documented defects and worked with developers and QA to fix these defects
• Worked closely with the project manager to maintain and update the project plan, communicate any road blocks and get approval on the change requests
• Created product documentation including print user manuals and materials

Confidential, Bedford, MA

Business Analyst/Business Systems Analyst

Responsibilities:

• Developed strong relationships with business partners to understand different business areas
• Assisted clients in documentation of current business processes and future business processes
• Partnered with business team on writing (test verifiable) Business Requirements Documents (BRD)
• Created Functional Specification Document (FSD) and Technical Design Document
• Partnered with business and IT to elicit, analyze, write and d prioritize both functional and non-functional requirements
• Created a requirements document that contained analysis, process decompositions and flows and uses cases
• Developed Procedures to automatically edit the data whenever the User made changes on the custom pages.
• Developed SQL code for Discover reports to fetch the data in specific to the Sub-Inventory.
• Participated in work breakdown flow definitions
• Participated in the development of a detailed project scope which included both in and out of scope requirements
• Performed traceability to ensure functional and non-functional requirements are met
• Performed gap analysis
• Managed requirements change requests and performed impact analysis of changes
• Worked with the application and application owner to develop business process change & documentation
• Tracked issues and led resolution and escalation to leadership, as required
• Identified project risks and provided risk mitigation strategies
• Worked with clients to develop use cases and UAT test cases
• Worked with testing team(s) to develop, document and execute test plans

Confidential

Technical Consultant/Developer

Responsibilities:

• Review project documentation i.e. Business Requirements, Specifications, Solutions Architecture, Detailed Design documents to identify test scenarios.
• Customized Standard OAF pages as per requirement.
• Developed Programs to automate the manual process done by the users.
• Worked closely with Business Analyst to understand business requirements.
• Prepared MD70, MD120, Test cases, Walkthrough documents.
• Testing, Patch analysis and post patch validations.
• CMMI Processes and Version Controlling.
• Worked in Shell scripting, Oracle Application Framework and Reports.

Confidential

Responsibilities:

• Preparing the technical design according to the requirements provided by the client and analyzing the changes required.
• Data entry by using Conversions to enter the bulk data into the custom tables.
• Review sales force fields mapping to insure a smooth integration with other application
• Correct mapping issues as they occur and verify fixed fields by running regression testing and unit testing.
• Development of custom code to fetch the data from the Data Warehouse.
• Developed the code according to the functionality requested to implement OLM.
• Regression testing of the functionality has been done.
• Supported ETL mapping activities as per established business requirements
• Prepared Unit Test Cases documents to test the changes implemented.
• Test cases and Test date have been inserted.
• Developed Custom Reports using SQL and PL/SQL coding techniques to fetch data from the existing Data warehouse.
• Data Conversions and the Monitoring were done during the test process.
• Provided the entire requirement Documentations as per CMMI standard