Summary

• Around 7 years of diversified experience in Business Analysis, Project Management, Software Design, Development, Implementation and Quality Assurance of web based, client server applications, service oriented architecture applications with knowledge of the complete Software Development Life Cycle and Quality Assurance Life Cycles
• Extensive knowledge experience in various in-house and industry standard methodologies like Waterfall, Six Sigma, Rational Unified Process, Agile, Scrum, Spiral, Extreme Programming, Business Process Management, Data Modeling Mapping, and Process Modeling Optimization.
• Thorough knowledge of Banking, Mortgage, Pharmaceutical, Commercial Insurance, Property Casualty Insurance, Healthcare, Finance, Retail domains, and E-business applications.
• Experienced in all phases of software product development including Requirement gathering analysis, design, development, testing, implementation, post production support, specialty providing support to L2 applications which includes constant interaction with clients in resolving the issues and confronting and overcoming problem situations.
• Experience in utilizing online enterprise based application and collaboration tools like SharePoint, Rational Suite, Live Link, Documentum, Jira, Peregrine Systems, IBM-Tivoli, ITIL tools, testing tools, templates, forms, content management, business intelligence, and workflow tools to accomplish various tasks in different projects.
• Excellent analytical, communication skills, leadership qualities, result-driven, self-motivated, organizational and interpersonal skills in addition to being productive individually and working as a team member.

• To Duplicate IVM data from MFC database, improve MFC applications' stability and performance and to build the infrastructure to meet the near term reporting growth needs and to provide cost effective and seamless services/support to the business users, IVM Reporting and Data Analytics project has been take up.
• The Scope is to duplicate IVM Reporting set up from MFC data base and migrate all reports in its present condition to a new IVM Reporting environment. The details are as follows:
• Make a copy of MFC database into IVM Reporting Environment
• Procurement of new reporting server, configuration, build, network cabling and installation of related apps
• migrate all the 23 scheduled reports in as-is condition and imitate the legacy structure/pattern s in the new IVM reporting server s
• Build the reporting server capacity to accommodate a growth rate of 100 by Q1 2013.
• MST will follow bank SDLC methodology for migration and providing operational support
• Implementation of SAN upgrades to SQL servers Production and Contingency to the BAS tax services application suite is necessary to provide additional server capacity and business stability required to meet agreed upon service levels. This effort will address the incidents of system failures, minimize costs of technology support from monitoring, maintenance, and emergency break fix implementations. Increase the technology resources by providing new SQL servers to replace the existing SQL servers Production and Contingency . This will be realized migrating the single SQL server load to multiple servers and maintaining a high level of technological integrity among the systems. Additionally this effort will result in increased satisfaction to associates due to improved performance of the suite of applications.

Project: Document Management

As part of the new BAC initiatives, the document management and imaging program will deliver an integrated and efficient document management solution throughout the bank. Due to the current challenges with inefficient and inaccurate document retention and indexing process of Mortgage Loan Servicing systems which result in increased loan processing time and contribute to the increased backlogged volumes for mortgage related activities. Through the use of an integrated document management system with Servicing and PCCS platforms, the bank can deliver on the Fair, Fast and Final commitment, as well as promote greater clarity, consistency, accuracy, completeness.

Project: Pebble Divestiture

Confidential sold the assets of BAC Tax Services Corporation to a third party provider, CoreLogic CL . The sale included operations, technology, and support functions Pebble Divestiture Legal Day 1 . The technology applications and infrastructure, a.k.a Technical Day 1 and support staff accessing those applications moved into a temporary 'Ring Fence' environment in order to allow the continuation of service defined in the Transition Services Agreement TSA and to support certain services to be provided back to BAC from CL under Statement of Work SOW , and Outsourcing Agreement . This phase will address the target state and include implementing / enhancing interface s between the BAC and CoreLogic. The solution will support the needs of applications, processes, reporting, vendor management and other operational needs as required by BAC and CoreLogic.

Roles Responsibilities:

• Interacted with the LOB business users, product experts, functional leads subject matter experts to define system objectives and scope, identified constraints and the measures of success for the system s to be built and enhanced.
• Responsible for Requirement gathering, Business Process flow, Business Process Modeling and documenting AWE High-Level Design HLD document.
• Gathered requirements to enhance mortgage insurance policy output, printing and mailing of this output and offer our agents/policyholders eDelivery options.
• Gathered requirements for Escrow and Reserve Administration, Escrow processing, Escrow Analysis, Non-Escrow Loans Collateral Inspection and Monitoring, Property Inspection, Income and Expense Statement Review, Inspection Report functionalities of Insurance systems.
• Gathered requirements for various XML file formats to be transmitted.
• Performed GAP analysis on business process after performing AS-IS and TO-BE analysis
• Facilitated requirements gathering sessions with LOB, users and other stakeholders to define the project and to reduce the time frame required to complete deliverables.
• Prepared and presented High Level Design Document HLD and Low Level Design Document LLD that captured requirements, specifications, business processes, data entities, transformation logic, and recommendations related to proposed solution.
• Analyzed business requirements and segregated them into Use Cases. Created Use case diagrams, activity diagrams, Sequence Diagrams.
• Created data mapping documents for both one to one and also involving transformation of data elements between various Tax Insurance systems for both enterprise BAC and partner systems.
• Created Logical Architecture diagrams and component diagrams to identify the data flow
• Utilized DAIC Customized Six Sigma methodology for rapid delivery of the high quality application and also for development with customer needs and company goals and also complying with the regulatory requirements for documentation.
• Utilized Agile Scrum methodology to implement Document Management project.
• Participated in daily stand up meeting and created Product Backlog and Sprint backlog.
• Participated in Sprint Planning, Sprint Review Sprint Retrospective meetings.
• Created Interface Design documents for ETL batches used to parse and load Tlog files from source system to target systems both internal and external to Bank of America.
• Partnered with stakeholders at all levels to build SharePoint collaboration and intranet solutions that with proven results improve team cohesiveness, collaboration, process flow, productivity, customer response times, efficiency, while at the same time, cutting waste and costs.
• Assisted in creation of Transition Services Agreement TSA between vendor partners and BAC.
• Handled Risk Management activities to minimize client impact and tax collector impact during and after project completion for Pebble project.
• Prepared participated in deployment review meetings and cut over plans for Go-Live.
• Created data mapping sheets and aided the development team with creation of stored procedure using SQL, data dictionaries, and data models from Operational and Legacy Systems within Tax Insurance LOBs of the organization.
• Created Screen Mockups using HTML.
• Created complex stored procedures using SQL with multiple table joins and comprehended and isolated areas problems as part of functional testing.
• Created Activity, Use Case, Sequence diagrams to depict the requirements and flow of functionalities.
• Created custom queries to generate various ad-hoc reports.
• Extensively used SharePoint Discovery to document project processes and procedures, communicate requirement and version control them.
• Identified and created the Issues Risks Register and Risk Mitigation Plan.
• Worked under umbrella projects and analyzed the business impact of our LOB and suggested remediation to the current process to minimize the impact.
• Created detailed test plans and testing strategies and ensure these are executed extensively, which includes executing SQL queries to retrieve data and test.
• Provided support for User Acceptance Testing with UAT cases and resolving any issues with the users and performed UAT and participated in writing test plans, and developed different test cases for functional testing and non-functional testing.
• Developed the requirements traceability matrix document to ensure both forward and backward traceability.
• Performed ITIL or service desk tasks to support Insurance and tax application related issues in Production environment.
• Provided requirements for custom reports in ITSM Dashboards for effective service management activities.
• Handled Service requests, problem requests, incident requests, process requests as needed for applications in production and test environment.
• Used incident management tool Maximo to create tickets for L3 to address any BAC issues.

Environment: AS400, .Net, Oracle, Mainframe, Clarity, Maximo, Live Link, MS Office, MS Visio, MS Project, HTML, SQL, Win Runner, HP Quality Center.

Field Assessment Tool FAS-T , an application for the online and offline collection of task-related data from Team Members. Used primarily overseas, FAS-T consists of Activity Management the way people know what work needs to be done and Forms the mechanism for collecting specific data related to a task .

Confidential

Factory Production Information FPI formerly FLS , is an online application that allows Vendors to provide critical information on the timing and location of production of Brand products.

Confidential

• Commitment Management System CMS , enhancements to an existing PD D application and creating more required fields in order to support Foundation work described below .
• QMP Foundation, the creation of two of several building blocks needed for the overall program:
• A. Event Generation:
• Tools and methods to have a PD D application send data each time a defined system action takes place.
• Tools and methods to allow QMP to receive, interpret and store sent data for future use.
• Factory Office Application, a tool that allows Team Members to combine an ISO country list, merchandising hierarchy and TCPS business processes to define how to route work tasks to specific overseas offices for completion.

Roles Responsibilities:

• Elicited business requirements, documented them textually and within models such as wire frames, swim lanes use cases. Effectively converted the user requirements into business requirements, functional specifications technical requirements. Re-Engineered Requirements from existing systems.
• Organized JAD sessions for analyzing the User Requirements in relation to the expectations to identify the critical areas of the application and convert them into Business Requirements with various stakeholders like development teams, end users, SMEs Project Managers.
• Prepared coordinated Software Requirements Specifications SRS , Release Summary Document RSD , Production Verification Plan, Release Notes, Test Summary Report, Impact Analysis Requirement Traceability Matrix RTM .
• Created Use Case specifications, business flow diagrams using MS Visio for a clearer understanding of the business process with possible alternate scenarios for the business team and the developers.
• Coordinated worked on data fixes.
• Gathered requirements to generate reports in Business Intelligence systems Cognos Spotfire for the managerial decision making activities.
• Created Business rules from existing systems existing documentation.
• Created, maintained monitored Review Items Change Requests using IT-Service Now.
• Facilitated peer reviews peer review documentation.
• Coordinated Release Management activities documentation for the Planned un Planned Releases
• Validated test cases by tracing them back to requirements in a Requirements Traceability Matrix.
• Utilized Water fall RUP methodology to accomplish project tasks.
• Used MS Office Suite Word, Excel, PowerPoint, Outlook Express, Project , Agile methodology, Visio, ORACLE, TOAD, SQL PLUS, Quality Center.

Environment: J2EE, Web services, Oracle 10g, DB2, SQL Developer, MS-Office, Sharepoint, MS-Project, MS-Visio, Quality Center

Target Financial Services TFS is the pyramid within Target that is responsible for credit operations. Target requires all its products to be Payment Card Industry PCI guidelines compliant and hence it is looking to get the Gramm-Leach-Bliley Act GLBA compliance in place for all the data for its products. To align with this, the Target Central Encryption Data Store CEDS mission is to develop a centralized data repository with capabilities to generate reference numbers and store encrypted data elements that are Confidential Secure Handling Required.

Roles Responsibilities:

• Interacted closely with the clients at Target Financial Services TFS in order to clearly understand the nuances of the credit card industry and identify their needs based on the required implementation guidelines GLBA through interviewing and conducting the JAD sessions and RAD sessions.
• Asked the right questions through the use of interviewing templates developed specifically for business analysis complying with Target Systems Development TSD methodologies.
• Created User Stories to capture all requirements.
• Clearly documented the complex scenarios arising in the Target specific payments cards and Credit Data Warehouses and ensured that these are translated into appropriate system level requirements so as to facilitate their implementation.
• Facilitated document review sessions and obtained approvals from various stakeholders.
• Conducted sessions within the development team to provide a clearer understanding of the business implications of the GLBA act and the relevance in the project
• Actively interfaced with a variety of Key Risk stakeholders to provide information and data to support company operations.
• Involved in performance tuning both ETL informatica mappings and SQL statements.
• Involved in scheduling the Informatica jobs, UNIX scripts and Oracle procedures.
• Collaborated with DBA and Data Architects on implementation of database changes.
• Worked closely with the business users for each area within Target Credit in order to elucidate the UAT strategy and offer strategic validation solutions to the business for all the Enterprise Credit Data Warehouses.
• Closely monitored the progress and the inherent changes in the scope of the requirements by conducting regular tollgate meetings so as to measure the business return on investment and also to check the validity of the need for financing the project.
• Created data mapping templates and aided the development team to reduce the bandwidth of the project.
• Identified and classified the data elements to bring target issuance based applications into compliance with industry standards related to the handling of confidential data.
• Developed the requirements traceability matrix document to ensure both forward and backward traceability developed issue tracker and risk tracker and organized regular weekly meeting to close these issues.
• Developed, maintained, analyzed, and published metrics SLA's, OLA's in support of the services specified in the services agreement or sow.
• Provided timely status reports to the business and to all the stake holders.
• Used MS SharePoint, MS Office Suite which included MS Word, MS Excel, MS Project, MS Power Point, and MS Visio for various documents and reports.

Description:

• Pfizer, the world's highly reputed pharmaceutical company that is involved in a global production of the drugs. Pfizer has undertaken many projects in different parts of the world. The Supply chain is a group of applications working together in order to move the clinical supplies from various distribution centers to locations where the drugs are actually dispensed to the patients. This group of applications mainly deals with the research Ri department where different drugs are administered to the same kind of patients according to their treatment groups basing on the kind of study protocol these patients belong to.
• Impala application deals with the drugs that are given to patients at different visit schedules. It also manages the shipping section of the drugs.
• CSDS Clinical Supplies Distribution Center mainly deals with the finished goods which ought to be packed according to the request placed by the investigator.
• Clinicopia deals with the design of a protocol or study of the course of action of a single or multiple drugs.

Roles Responsibilities:

• Worked on full life cycle of the project requirements gathering, design, development, test, production phases.
• Facilitated requirements gathering sessions JAD sessions by engaging Clinical Users, Physicians, cross-functional teams, subject matter experts, vendors as needed and prepared business requirements documents use cases for Impala, CSDS Clinicopia.
• Analyzed As-is process of the existing CMS system and understood the to-be process and provided assessment document created process flows.
• Handled change requests and prepared several change requests by creating RFCs within Peregrine Systems' ISCM tool and was designated as Change Manager Change Owner and responsible for the entire lifecycle from initiation to closure.
• Created Wireframes using Mockflow to represent the UI requirements and obtained sign-offs from the business user groups.
• Experience organizing, moving and managing content material to and from Sharepoint, external file systems, databases, email, and applications together with creating announcements, news upcoming releases modules for auto email notifications.
• Responsible for best practices like naming conventions, performance tuning at mapping and session level, error handling.
• Worked with the development team very closely in helping them finish their tasks and resolving both technical and functional type of issues.
• Ran study related BI reports in Cognos 8i to ensure that the reports developed met the needs of the business and contained the appropriate study and protocol related information.
• Created test scripts for various doc subtypes within HP Quality Center and performed testing in De Demo environments.
• Collaborated with DBA and Data Architects on implementation of database changes.
• Coordinated integration testing and QC testing in all cycles with several QA analysts and ensured that all the requirements were tested and passed thereby being responsible for approving the testing.
• Prepared test summary reports after the testing is performed prior to code move and updated the same with release validation test results after the code is moved to production.
• Facilitated UAT by assisting the user groups in creation of business scenarios, UAT scripts, executing the same.
• Created issues in JIRA and tracked the progress of the issue and assigned the same to the necessary resources and pulled reports out of JIRA for proper decision making by change council board in their monthly meetings.
• Handled change requests for Impala module to accommodate new patients' visits and also old patients updated visits.
• Worked in an ITIL-compliant environment to achieve ITIL compliance by developing new processes and remediating obsolete or dysfunctional processes.
• Contributed in generating Service Management work products Policies, Processes, RACI matrix, KPI Reporting frameworks/elements.
• Completed all required training in Learning Management System LMS to stay in compliance with the regulatory corporate requirements.
• Ran PL/SQL procedures in TOAD extensively to validate the code and databases during testing phases.
• Participated in the deployment rollback activities by acting as a liaison to business users to help ensure a smooth deployment.

Environment: Documentum, MockFlow, MS Office Suite extensively which included MS Word, MS Excel, MS Project, MS Power Point, MS Visio, MS Visual SourceSafe, TOAD, ISCM, JIRA, Mercury Quality Center, LMS, Webex Sessions.

Description:

• Online Recruitment System in an independent module and is a part of Human Resource Management System. OLRS is a feature integrated in recruitment package designed for the Desktop. It stores the details of jobs and details of the candidate in the database. It helps in conducting the online test and online searching of candidate details by the HR Personnel.
• Login Module: This module allows only authorized people to access the Application. Any person who needs an access to the application is needed to login in the first step. The user needs to provide his or her login id and the password. The user validation will be conducted here.
• Opportunities Module: This module is an interface to the jobseeker and company to apply for the vacant positions. The candidate can directly apply for any of the jobs or view their applications status. Here the candidate will be provided with the list of opportunities and he/she can opt for the position and the employers can click on the link provided to post the required and desired qualifications for a specific job.
• Online Test Module: This module helps the HR to conduct online test for the selected candidates. Here the HR will provide separate login and password for each candidate. This module will fetch questions randomly from the database and displays them to the candidate. The time limit to write the test is maintained automatically. The result will be displayed immediately after the test.

Roles Responsibilities:

• Gathered the new process requirements for Login, Opportunities, Online Test modules requested by the business users and listed a summary of all requirements that needed to be produced by conducting requirements gathering workshops.
• Developed project specifications and use cases by using activity use case diagrams for client configuration package.
• Performed ad-hoc queries and was responsible for designing the flow of the process based on the requirements gathered.
• Facilitated peer stakeholder reviews and obtained sign-offs on functional specifications document FSD , design documents, test plan document.
• Created data flow diagrams using Gliffy to represent the flow of the funcitonality.
• Created issues risk list which was a living document during the life of the project and tracked all issues risks and their resolutions mitigation solutions.
• Facilitated Communication with UI designers, developers, business users, and other multiple levels of management across various departments and updated the management team with weekly status updates.
• Prepared test requirements document that could be used to prepare test cases, test data, and validation plans for the application to be tested in Integration testing, formal testing, UAT and assisted in testing activities by creating resolving the defects in Mercury Quality Center
• Coordinated with offshore development teams during development and testing phases of the project.
• Worked on problem analysis, researched solutions and presented recommendations.

Environment: MS Office MS Project, TOAD, SharePoint and MS Visio, Gliffy, PL/SQL, Mercury QC.

Description:

• The project collaboration services is a user-friendly tool that makes the users share files and messages related to a specific project and know the status of the day to day activities/tasks. It acts as a connecting link for different members in a project located at different locations. Some of the features of the application are managing projects in an organization and all activities such as status report, tasks. The tool gives an overview of all the projects assigned to different persons and provides with the facility to update day to day activities in a particular project by posting messages related to that project, upload files which can be viewed by all the members present in that project. Administrator can give permissions and set rights to the users for a particular project.
• Modules lead for the Create, Modify and reset modes of users using struts Frame work.
• Involved in analysis of requirements business use cases.
• Developed Controller Servlet, JSPs Java Objects and Data Access Objects.
• Developed using technologies as Java J2EE, Struts, HTML, SQL, and open source Apache Tomcat.
• Responsible for ensuring database information is updated to support relevant activities and error logs.
• Created workflows for incorporating the business logic and Validator Frame work to validate presentation layer.