PROFESSIONAL PROFILE:

Key areas of competency:

PL/SQL,11g Administration, OEM, RMAN, ETL, Microsoft Studio Management 2012, Data pump, Business and Enterprise Analysis, Requirement Elicitation Management, Solution Assessment validation, Stakeholders communication Management, SDLC Agile Waterfall methodology , Testing system testing, functional Nonfunctional . UAT integration, regression etc.

TECHNICAL SKILLS:

SharePoint, PL/SQL, T/SQL, OEM, Rally, TortoiseSVN, Redgate, SQL plus, MS Studio management 2012, Lync 2013, ALM

PROFESSIONAL EXPERIENCE:

Confidential

Project:

To maintain the RDBMS of Harford Commercial Insurance's legacy system into Guidewire Platform using true agile methodology, to ensure interoperability, efficiency, reporting, access to database, billing center, policy center and claim center

Data/Business Analyst

• Elicit Requirements from Insurance Employees, Producers, and Agents to better understand the present state and make recommendation for the Future State of Commercial Insurance based on ISO, State and federal Laws
• Created traceability metric based on requirements and documented various procedures on SharePoint regarding requirements from the technical and business side
• Analyze T/SQL scripts and determine business rules, including JAD sessions, One on One interview, Questionnaire with the business Side of the Insurance Company
• Create Mapping Policy Line of business mapping template, Create Data base Objects from LOB's Tables
• Created Stored Procedures as per the ETL mapping sheets
• Created and build ETL Mapping sheets for Legacy to EDW Guidewire conversions
• Flexibility working both Agile Scrum and waterfall environment
• Conducted meetings to interview end users, SME's to gather business requirements
• Managed and modified user requirements in terms of existing legacy systems modules to verify operability and integration in the new Guidewire systems
• Prepared BRD's and used Artifacts to manage, analyze and convert Business Requirement into Functional Requirements.
• Interacted with business and Guidewire application commercial Insurance Suite development team to bridge the gap between legacy data and future state data for Guidewire.
• Clarified and validated requirements throughout the process of SDLC using both agile and waterfall Methodology
• Liaised between stakeholders, development teams and management for solution assessment and validation requirements
• Collaborated with production team to implement UI user interface and create enhancement to optimize user experience
• Engaged with stakeholders to capture business and systems requirements using different elicitation techniques for the proposed Guidewire application
• Map Line of Business Coverage and develop transformation logics and Develop Store procedures Shell based on required Mapping Document
• Worked on creating a streamlined process to understand the various steps in the Policy Center insurance Suite and desired functionality of the new systems by interacting with users, management, SME subject Matter Expert , stakeholders, and the board of director and bond issuers
• Translated high level business requirements and Commercial Insurance industry best practices and standards making sure to explain SDLC

Confidential

Project 1

To maintain the DBMS of Finance department's legacy system into Oracle Platform using PL/SQL,OEM, RMAN to ensure interoperability, efficiency, reporting, access to database, customer service database, functionality, communication and security of the RDBMS

Business Analyst

• Cooperated with production team to implement UI user interface and create enhancement to optimize user experience
• Managed the business process by re-engineering and identifying the as is process, collaborated with SME's on the ways forward and documenting the 'to be process for software development
• Engaged with stakeholders to capture business and systems requirements using different elicitation techniques for the proposed accounting systems and Microsoft Dynamic Modules
• Was Adept at all phase of projects lifecycle including requirements gathering and user analysis, testing graphic user interface GUI and implementation
• Worked Closely with Stakeholders and programmers to define user experience and user interface guidelines
• Cooperated with production team to implement UI user interface and create enhancements to optimize user experience
• Prepared BRD's and used Artifacts to manage, analyze and convert Business Requirement into Functional Requirements. Managed and modified user requirements in terms of existing legacy systems modules to verify operability
• Expertise in using UML's drawing process flow diagrams and use case to capture and clarify functional requirements
• Clarified and validated requirements with stakeholders to avoid any gap before the set Go-live date
• Created database and user account schemas and table spaces for development and production environment for window servers
• Worked as part of a project team to Implement and Coordinate Oracle Database development team and determine the Scope and limitation of a project.

Confidential

Project II

systematically upgrade the Finance Department's legacy system to Microsoft Dynamic-GP Great Plains ERP enterprise resource planning modules to ensure interoperability, efficiency, reporting, and access to data, customer service, functionality, communication and security.

Business Analyst

• Conducted CBA cost-benefit analysis research on personal property system upgrades to determine feasibility, cost, time required and compatibility between legacy and Microsoft Dynamic-GP accounting systems
• Performed data validation on the old system against the new system and created test cases
• Clarified and validated requirements with stakeholders to avoid any gap before the set Go-live date
• Worked with development teams for clarifying requirements throughout the process of SDLC using both agile and waterfall methodology
• Contributed to the functional and nonfunctional systems testing, UAT, integration, regression testing and management of BUG reports of ERP enterprise resource planning and CRM system
• Expertise in using UML in drawing process flow diagrams and use case to capture and clarify functional requirements.
• Flexibility working both in Agile Scrum and Waterfall environments
• Conducted meetings to interview end users, SME's to gather business requirements
• Performs validation of all application resources during implementation and assist developing work around as needed to ensure clients can meet Pre-go live date

Confidential

Project:

To enhance the HR and payroll legacy systems using ADP automated data processing commercial- off the shelf COTS product, identifying manual process that need to be upgraded. Check compatibility for legal and regulatory conformance and also identify key information well in advance for stakeholders

Business Systems Analyst

• Created UML diagram, use cases, users' stories using Microsoft Visio
• Documented ADP integration outcomes in a timely manner and ensure all modules related to testing are interoperable.
• Liaised between managers, accounting staff and technical teams during high level review sessions to obtain and carry out action plans, meeting deadlines and standards
• Performed data validation, integration and regression testing of Legacy against Microsoft Dynamic
• Facilitated the effort to effectively communicate and collaborate with stakeholders to analyze business needs and functional requirements and deliver various artifacts
• Engaged in a streamline process to understand the various stages in the automated data processing and desired functionality of the new ADP by interacting with users, managements, and SME. Stakeholders and government officials
• Prepared BRD's and used Artifacts to manage, analyze and convert Business Requirement into Functional Requirements. Managed and modified user requirements in terms of existing legacy systems modules to verify operability and integration in the new ADP systems
• Conducted bug report management, integration, UAT, regression and functional testing

Confidential

Project 1

• Integration and management of a new personal property revenue collection system. It employs work flow technology to control and monitor the various steps in processing personal property tax payment by implementing ACH in order to fully automate and simplify the process of electronically transfer of Mass payments from participating banks to Baltimore city account.
• Project II Integration of a new Microsoft Dynamic CRM system to upgrade the city's legacy CRM systems to create, assign and manage request by customers such as parking tickets, tax sales, personal property tax and other city's revenue generation programs.

Jr Systems Analyst

• Worked on creating a streamlined process to understand the various steps in the Revenue collection cycle of Baltimore City and desired functionality of the new systems by interacting with users, management, SME subject Matter Expert , stakeholders, the board of estimates and bond issuers
• Translated high level business requirements and industry best practices and standards making sure to explain SDLC.
• Contributed to the definition of the scope of the project, performed extensive requirements analysis and defined functional specification as required by the revenue department
• Used UML notations to analyze and translate business requirements CRM specifications.
• Worked with business and technology leads to identify the appropriate data needed for testing and ensured that information is provided within timeframe of testing milestone
• Assisted in designing test plans, test scenarios and test cases for integration, regression and user acceptance testing to improve overall quality of Baltimore city revenue Mass payment application process

Confidential

Accounting systems Analyst

• Worked on creating a streamlined process to understand the various steps in the Revenue collection cycle of Baltimore City and desired functionality of the new systems by interacting with users, management, SME subject Matter Expert , stakeholders, the board of estimates and bond issuers
• Translated high level business requirements and industry best practices and standards making sure to explain SDLC.
• Contributed to the definition of the scope of the project, performed extensive requirements analysis and defined functional specification as required by the revenue department
• Used UML notations to analyze and translate business requirements CRM specifications.
• Worked with business and technology leads to identify the appropriate data needed for testing and ensured that information is provided within timeframe of testing milestone
• Assisted in designing test plans, test scenarios and test cases for integration, regression and user acceptance testing to improve overall quality of Baltimore city revenue Mass payment application process