SUMMARY

• I am IT Business System Analyst/Project Manager with over 10 + years of experience. I am in - depth knowledge of conducting User Acceptance Test (UAT), data quality checks using SQL creating and running queries, and Requirement Traceability.
• I documented procedures from MYSQL to SQL Server and Oracle to SQL Server.
• I am expert in Database MS Access, Oracle 11g, and Oracle 12C. I am very client-facing with the ability to build strong relationships.
• I am a progressive IT Business System Analyst with a Bachelor degree in Computer Science and over Ten +years of experience with extensive knowledge and experience across the project life cycle using Software Development Life Cycle (SDLC) in the fields of Procurement, Finance, Health Insurance, Investment Banking, and Telecommunication.
• Excellent analytical, organizational, communication and documentation skills along with good process management skill to gather requirements to bring out the quality product.
• Comprehensive knowledge of Waterfall SDLC, Rational Unified Process (RUP) software development process framework, complete UML Artifact, Scope definitions, and an AGILE development framework with Scrum, AUP, XP and Six Sigma.
• Extensive experience in facilitating user group meetings and gathering system requirements for web application development using Rational RequisitePro, Microsoft Word.
• Experience in networking with individuals Confidential various levels and possesses outstanding skills in structuring and facilitating JAD sessions for requirements gathering, analysis, and design.
• Ability to work cohesively with all Stakeholders to formulate Functional models and prototypes to meet stakeholder expectations, and Workflow optimization.
• Experienced in developing Use Case Models, Activity Diagrams, Sequence Diagrams Process flow diagram, and Data Flow Diagrams (DFD).
• Worked extensively on performing AS IS' and to BE', GAP, Cost Benefit, Impact analysis and drafted Project Analysis documentations.
• Strong visual modeling and business process modeling skills with tools like Rational Rose, MS Visio, and StarUML.
• In-depth knowledge of conducting User Acceptance Test (UAT), data quality checks using SQL, and Requirement Traceability.
• Familiar with MS Project SharePoint to manage schedules, deadlines, resources, collaborate with different teams and analyze project information.
• Well versed with conducting SWOT, PESTLE, Resource analysis, developing proof of concept, and detailed story boards to help with business and technical decisions.

TECHNICAL SKILLS

Business Modeling: UML Modeling using Rational Rose, Star UML, MS Business intelligence reporting, Business Objects Visio, Rational Software Modeler.

Requirement Management: Rational Requisite Pro, Microsoft Word, Case Complete.

Methodologies: Rational Unified Process, SDLC, Agile Methodologies, Waterfall.

Application: SharePoint, MS Office Suite, Oracle E-Business Suite Financials Oracle, Microsoft suite, MS Project, SPSS.

Database: MS Access, Oracle 8i, Oracle 9i, Oracle 10g.

Operating Systems: Windows Vista Professional, Windows XP Professional, UNIX 5.0.4, Linux, Windows 98.

Internet Mailing Services: MS Outlook, IBM Lotus Notes.

PROFESSIONAL EXPERIENCE

Confidential, Hapeville, GA

Agile Expert Business Analyst

Responsibilities:

• Gathered Requirements for Applications access to Databases thru WSDL's.
• Wrote and Maintained Requirements Specifications for Web Services.
• Created and Tracked Defects through the Quality Center Application
• Gathered and modeled the requirements for the Merger of the NWA and Delta Loyalty Programs and the Rewrite of the Self-Service Check-In Platform
• Conducted JAD sessions and Joint Requirement Sessions
• Wrote USE Cases and produced multiple UML Documents and Diagrams
• Tracked and Documented Daily Status of Project's Scope, Budget, and Resources
• Performed the Role of Project Manager on Smaller Projects/Enhancements
• Proven track record of delivering global, large scale multi-channel, integrated projects or isolated specializedapplications and campaigns
• Deep understanding of user experience, digital eco-systems, and technology within the context of client’s organizations.
• Determining and implementing of most optimal approach for analysis, scoping and delivery.
• Agile and waterfall approaches across full Lifecycle.
• Strategic definition, road mapping, and alignment of digital initiatives with corporate strategy, capabilities, user needs and environmental factors.
• Excellent communicator and mediator between senior stakeholders, marketing, technical and creative specialists: theability to discuss technical details with non-technical internal and external stakeholders to ensure projects are understood.
• Accustomed to working in creatively driven / user-experience focused, technically focused or highly formal environments.
• Environment:MS SharePoint, SQL Sever, MS Visio, Oracle, MS Office Suite, JIRA, Quality Center, XML, XHTML JSP, MS Visio, MS Project.

Confidential, Columbus, OH

Business Analyst

Responsibilities:

• Assist with development of Quarterly Risk Decks and SOX presentations for Audit Committee and Board.
• Enhancing monitoring/control framework for early identification of risk/issues/dependencies, expediting resolution development by promoting collaboration within CCAR program team and SMEs
• Document and assist with facilitating a global ERM process across all of the company’s Line of Business.
• Created entity relationship diagrams and multidimensional data models, reports and diagrams for marketing.
• Assist Risk Owners with developing appropriate management responses through research and topic discussions.
• Organizing and performing audits on internal system as well as investigation on vendor audits
• Developing and implementing new standard operation procedures\
• I have accomplished and grown digital wealth management and online brokerage platform, and a trusted corporate finance business offering capital for equity sponsors and for middle-market companies.
• With my diversity and theset of my technical and analytical skills to organize resources around the execution of business objectives in a highly dynamic environment, with a focus in the areas of retirement and wealth management.
• The CRS gives clients confidence that they are working with a credentialed practitioner.
• Creating test materials and guidelines for clinical tests reversed 2-year negative e-commerce sales decline and increased revenue by 25% in 12 months
• Reviewing and revising legal contracts and quality agreements with vendors
• Planning, scheduling, and conducting audit programs
• Performing quality assurance on clinical and non-clinical documentation
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS)
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), and SQL Server Integration Services (SSIS) (2005/2008).
• Experience in creating configuration files to deploy the SSIS packages across all environments.
• Researched current ITIL standards and architecture integration processes.
• Reviewed and recommended ITIL process improvements.
• Developed various operational Drill-through and Drill-down reports using SSRS
• Wrote, tested and implemented Teradata Fast load, Multifood and Bteq scripts, DML and DDL.
• Integrated tools with Service Now applications utilizing mid server and email technologies.
• Debugged, escalated and resolved HPSM server based issues.
• Developed and implemented online security procedures.
• Worked with management to update security manuals and address current concerns.
• Updated security software to prevent database security threats.
• Implemented system recovery procedures to minimize losses should an attack occur.
• Installed, configured and evaluated new and latest HP versions.
• Assist with compiling quarterly ERM presentations for Signet Audit Committee and Board.
• Coordinate ERM updates from each of the Divisions.
• Perform Internal Audit SOX testing of various key processes within the company.
• Facilitate the company’s SOX Change Management process relating to changes in key internal controls and/or processes.
• Assist with preparation of SOX decks for Executive Management presentations.
• Plan and schedule quarterly risk meetings according to company ERM process.
• Update risk documents as necessary in the company’s ERM software, B. wise.
• I’m involved Interacting with Senior Management to discuss current risks to the company,
• Perform SOX testing of various key company processes.
• Report SOX findings to Management and provide recommendations on corrective action implementation.
• Facilitate the company’s quarterly SOX change management process.
• Worked on Documentum WebTop, Documentum Administrator
• Created test cases for testing Documentum environment, methods, and jobs

Environment: Sarbanes - Oxley Act (SOX), BI Reporting, BWI Reporting, SQL Server, Toad for Oracle, ERM Web Base Tool, Enterprise resource planning (ERP), SOX Management Process, J2EE Core I Dev, Java, Cyber-Ark, Documentum, SSRS, SSIS, Teradata.

Confidential, Collegeville, PA

Business System Analyst

Responsibilities:

• Lead the development and design of a new Business Productivity Suite based SharePoint.
• Scope new projects, interpret business needs, translate technical issues, identify and model data requirements, identifying business rules requirements, and test requirements.
• Developed KPIs for e-commerce site and created various dashboards to track relevant web analytics
• Facilitate interaction between different Business and IT Managers to process data for update into CRM.
• Performing data loads into a complex Staging Database Environment via SQL Server 2005 and subsequently updated into CRM.
• Performing all data maintenance in CRM system which includes data transfers, data migration, and data merging.
• Create specific reporting requirements to determine the needs can be satisfied to meet the business requirements.
• Directly responsible for 3rd tier user training throughout the company.
• Performing all System Administrator and Developer duties for over 1000 users in CRM system across the globe.
• Perform complex Data Quality Analysis procedures and manual matching techniques to successfully correct data inaccuracies directly in CRM system or via SQL scripts in the Staging Database.
• Create specific Regulatory Reporting requirements to determine the needs can be satisfied to meet the Business Requirement.
• Hands on Dynamic CRM.
• Enveloped logical data models and physical data models using ER-Studio.
• Strong experience as a business system analyst in various functions including risk management, regulatory standards, and reporting.
• Design Pharmaceutical portfolio credit risk analytics & modeling.
• Working with diverse Siebel modules and versions and create optimized reports for the development of thebusiness of the clients.
• Identified business reporting needs through the use of the MIS tool.
• Conducted weekly Crystal Report and Oracle SQL training sessions for the reports team.
• Prepare a variety of reports in response to senior management’s request.
• Working on documenting various processes, functional requirements, setting up users for UAT, creating training materials and other management specific documentation.
• Contract Management and Procurement for Business Purpose
• Educating customers and internal staff on VMware products offerings and best practices for combining solutions to create private and hybrid clouds.
• Worked on Documentum WebTop, Documentum Administrator.
• Assisted with the creation of Standard Operating Procedures (SOPs) to maintain equality while providing high-levelend-user support.
• Created Test Cases for testing Documentum environment, methods and jobs.
• Installs maintain systems for their Solaris, UNIX. Linux and Red hat Linux customer base.
• Responsible for maintaining Solaris servers, BSD UNIX servers, Linux, and Red Hat Linux servers.
• Maintain all upgrades and patches to the Solars, BSD, Linux, and Red Hat Linux servers.
• Software Applications: SAP, MS Project Professional, MS Project Server, SharePoint, Excel, Access, Word, Visio, PowerPoint, Outlook, Internet Explorer, VS.NET, SharePoint Designer, Steel Ray, One Pager Pro.
• Road mapped for this Project Identity and Access Management architecture and work streams for presentation to CTO/CIO.
• Worked extensively in Appian BPM tools like Lombardi Teamworks& Corticon Rule Engine. Having good knowledge on otherAppian BPM tools like G360 Case manager, Appian Enterprise version 5.6 & PEGA PRPC, Dynamic CRM.

Environment: Lotus Notes, MS Office Suite, MS SharePoint VBA, MS Office 2013. TFS, RALLY, Documentum Administrator 6.5, MS VISIO, UNIX, LINUX, SAP BW, SAP Bex Reporting, Crystal Reporting. MS project Sever 2010. Informatics, Data Stage ETL VMware.

Confidential, Boston, MA

Business System Analyst

Responsibilities:

• BSA for Annuity Host and Life Insurance Team
• Lead and Lead Analyst of the Production Discrepancy team
• Conducted e-commerce RFP to switch platforms and acted as a Project Manager to ensure successful implementation
• Involved in Problem discussion with the business, end users, QA (Testing Team) and other BSA from business perspective
• Being as a Subject Matter Expert for BPM solution for shared delivery service and annuity host, Life insurance within the cooperation in the area of content management, Record management and compliance, Business process management, and image capture.
• Through self-analysis of the problem to determine its root cause as soon as a defect is logged and deciding the appropriate solution/fix to resolve the problem.
• Review the analysis of the developers and based on the analysis being done, determine the appropriate fix for the problem+
• Leveraged highly available VMware Virtual Infrastructure (VI3) environment to improve server availability, reduce workload for IT staff, and automate server deployment for various business units.
• Preparation of technical specification document for the development team to implement the fix and functional requirement document for the QA team to test the fix
• As a BSA of Annuity Host and Life Insurance Team, review the QA Test results, get signoff from Business and create the SOX docs for implementing the defect fix to production
• Involved in Requirement Elicitation & Analysis of tables related to multiple Confidential Projects.
• Analysis of production tables and updates to the production IMS/BASE and DB2 tables
• Determining the appropriate tables to be updated keeping in mind the relationship between the tables.
• Requirement gathering from various stakeholders as automation involving multiple Applications
• Updates to the DB2 tables are done using SQL Queries in SPUFI and some of the tools and applications used in the client system like DBASSIST and Product Central.
• Involved in generating the reports through Focus language
• Follow up and root cause analysis of the ABEND and logging of defect for the same.
• Onsite Coordinator for the project and handling multimember 4-member team Confidential offshore
• Involvement of various mainframe and distributed applications and worked on languages such as Perl, SQL, REXX, CLIST.
• Designed and developed reports using Crystal Reports XI version

Environment: WS FTP, SQL Server, TOAD, Putty, MS-Access, MS-Visio, Maestro, Perl, SQLREXX, CLIST. SAP BW, SAP Be Reporting, Crystal Reporting, VMware, SIPOCs, RACIs

Confidential, Merrillville, IN

Business System Analyst

Responsibilities:

• Acted as a liaison between Columbia Gas and IBM.
• Gathered business requirements from all users under IT service delivery and followed IT PMO Methodology to deliver the projects.
• Expertise in using TFS to open bugs, create tasks and user stories, initiate change requests.
• Used TFS source control to deploy theapplication.
• Created Crystal Reports using Crystal Reports formulae, Grouping, Parameters, Selection criteria.
• Created test plans, test cases using Test Manager.
• Executed test cases using test manager.
• Took ownership in modeling and documenting the enduser's AS-IS workflow and TO-BE business processes.
• Created different artifacts such as requirements document, business process flow using Microsoft Word and MS Visio.
• Support and maintained Request IT, AccessIT and Problem Tickets (TARMAC) and also supported all the escalations and IT related issues for the customers.
• Support overall coordination between all involved parties, using project management skills and techniques.
• Wrote various Excel VBA scripts and access queries to massage raw data from carriers across the globe to standardize the data input format and used pivot tables/charts extensively for presenting various trend analysis to the department.
• Work with third party vendor to deploy multiple projects.
• Worked as SME for SharePoint and created system requirements document (SRD) for SOX and Accounts Payable projects which were built on SharePoint
• Electronic File Transfer for Client
• Autopsy’s Client Request
• Converted Access reports to Crystal Reports XI version.
• User Interface Development.
• Creating Reusable Assets-Documentum and Captiva
• Providing Development, Documentum Migration Framework.

Environment: Lotus Notes, MS Office Suite, MS SharePoint VBA, MS Office 2013. TFS, RALLY, EMC Captiva, and Documentum, VMware.

Confidential, Fort Pierce,FL

Business System Analyst/ Data Analyst

Responsibilities:

• Developed source to target data mapping for the source elements and create transformation rules as per the business need.
• Developed testing strategy and assisted in review test cases.
• Involved in User Acceptance Testing Involved in conducting Team meetings to gather requirements from key stakeholders such as Business SMEs, QA analysts and project management team. Also, conducted follow-up one-on-one meetings with SMES.
• Performed GAP Analysis.
• Wrote Teradata Macros and used various Teradata analytic functions.
• Involved in migration projects to migrate data from data warehouses on Oracle/DB2 and migrated those to Teradata.
• Translated business requirements into functional specifications for communication to technology team.
• Extensive knowledge of coordinating all of the entities involved in a supply chain.
• Created documents like business user stories, business requirements, and system requirements Coach and direct Black-Belts in Lean Six Sigma Methodology across multiple organizations to support certification.
• Promote the use of Six Sigma Methodologies. Managed all process and planning activities for a key product line. Analyzed data.
• Estate planning, risk management, and wealth management
• Monitored and tracked customer satisfaction results for aservice provider on a global basis.
• Documented up gradation procedures from MYSQL to SQL Server and Oracle to SQL Server.
• Master Integrator on multi-phase, multi-project Service Oriented Architecture (SOA) Identity and Access Management project (ID, SSO, PKE, CAC).
• Developed various operational Drill-through and Drill-down reports using SSRS
• Designed and developed reports using Crystal Reports XI version.
• Created Crystal Reports using Crystal Reports formulas, Grouping, Parameters, Selection criteria to handle the customer's requests from Tables, Stored Procedures, Views, and Command Objects.

Environment: MS-Office, MS PROJECT, MS-Visio, Oracle (9i 10g), SQL, Rational Clear Quest, SSRS, SAP, Logistics, Teradata.

Confidential, Bloomington, IL

Business System Analyst

Responsibilities:

• Interfaced with business users to identify Business Objectives, Stakeholder Needs, Decision Framework, Solution Scope, Stakeholder Expectations, and Critical Success Factors.
• Performed GAP and Risk analysis of theexisting system and evaluated benefits of thenew system.
• Work with the SME to understand the Annuity product and prepare BPR documents for ongoing projects.
• Utilized ESDM and Agile Methodology to configure and develop process, standards, and procedures.
• Developed use case with UML for new product functionality.
• Created Interface specification documents between impacted applications.
• Conducted Joint Application Development (JAD) sessions with stakeholders throughout SDLC to resolve open issues.
• Participate in stage gate sessions, transition to release (DDI) and all other ESDM lifecycle meetings for projects
• Created procedure document for RUBY Scripting.
• Environment: Crystal Reports XI, Oracle 11g, Windows XP Pro, Visual Studio 2005, Microsoft.Net C#, ASP.Net, IIS & JSP
• Work with the development team and created RUBY Scripts for testing automation.

Environment: Lotus Notes, SQL Server, HP Quality Center, Siebel, RUBY, Mainframe, SQL Lite, Oracle 11g

Confidential, Horsham, PA

Business Analyst

Responsibilities:

• Acted as a liaison between corporate departments, including Executive, Legal and Information Services as well as vendor relationships.
• Requirement gathering and analyzing - conducting customer interviews, surveys and creating Scope documents defining Partial payment option (PPO) methods.
• Followed Agile Methodology for the Software Development Life Cycle.
• Performed audits and assessments on supplier systems
• Involved in Complete Software Development Lifecycle Experience (SDLC) from Business Analysis to Development, Testing, Deployment, and Documentation.
• Estate planning, risk management, and wealth management. Led businesses in the strategic development and implementation of their corporate benefits program including executive compensation and risk management to tailor a plan to align with the needs of the company.
• Designed the Vision document to give the stakeholders a high-level idea about the project.
• Created a simpler version in a diagrammatic approach using Star UML that how client, customers, and agents were connected.
• Developed use-cases and use-case diagrams from the functional requirements and user stories using STAR UML.
• Followed up with the SME in every module to ensure that FDCPA (Fair Debt Collection Practice Act) guidelines are being followed.
• DFD and state diagrams were created using MS Visio Analyzed and tested the user interface (UI) and redesigned it to increase its user friendliness for the business user.
• Maintained the Requirement Traceability Matrix (RTM) and managed requirements.
• Used MS Project in updating timelines and project scheduling for the new automated payment system.
• Led PowerPoint presentations for the development of technical applications for the departmental user base.
• Migrated Databases from MySQL, Oracle, IBM Informix, to SQL Server 2012.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS).

Environment: MS Office Suite, MS Visio, MS Project, Star UML, Star UMLE, Energy Component, SSRS, SQL. SAP, Logistics, Teradata.

Confidential, Atlanta, GA

Business System Analyst

Responsibilities:

• Responsible and accountable for the coordination with themanagement of multiple projects directed toward strategic business and other organizational objectives.
• Liaised with business and functional owner during risk engineering and high-level review sessions to derive and execute action plans, meeting deadlines and standards.
• Implemented RUP methodology to develop process, standards, and procedures.
• Performed Gap Analysis to check the compatibility of the existing Mediation system infrastructure with the new business requirements.
• Utilize SQL (queries) programming to understand the DB structure.
• Convert the Business Process Requirements (BPR) into System Specification Requirements (SRS).
• Created different traceability views to determine feature and use case dependence.
• Traced test cases and functional specifications to SSRs and BPRs using Caliber.
• Created Interface document between upstream and downstream applications.
• Created, compiled, maintained, and communicated orderly test results and status reports.
• Worked with the clients on the final signing process in the user acceptance stages.
• Fine-tuned Stored Procedures using Execution Plan in T-SQL for better performance.
• Develop reports using complex formulas and to query the database to generate different types of ad-hoc reports using SSRS.

Environment: MS Visio, RequisitePro, SQL Server, MS SharePoint, SSRS, SAP, Logistics

Confidential, Chicago, Ill

Business System Analyst

Responsibilities:

• Work as a liaison between IT, Global Securities, and Trust Services business unit.
• Communicate Coordinate between businesses, IT teams, Desktop support to clearly define the project scope, map the project functional specs to technical system requirements.
• Identify technical primary and secondary owners for defining migration tasks by conducting interviews.
• Consolidate the Empower product solution, as client facing.
• Ensuring the quality of code delivered by the offshore team.
• Researched and analyzed various Confidential day-to-day operations and processes.
• Conduct GAP analysis of the Enterprise shared services design application.
• Coordinated the data center migration between the datacenter team, hosting team, infrastructure, third party, and PMO.
• Change Requests are documented and assessed their impact to project performance following Change Control Management.
• Lead the effort to create the design doc, test plan, coordinated all UAT test cycles, results, and defects.
• Pro-actively involved in defect discovery, resolve, and verified by implementing defect management process throughout SDLC.
• Facilitate training sessions for current Tustin IT Admin staff on how to escalate resolve system issues using BAC resources.
• Management of SQL Servers, databases, storage management for databases sizing from 25GB to 40GB.

Environment: MS Project, MS Visio, Microsoft Suite, SQL, MS SharePoint, SAP, Logistics

Confidential, OH

Business Analyst

Responsibilities:

• Responsible and accountable for the coordination with themanagement of multiple projects directed toward strategic business and other organizational objectives.
• Liaised with business and functional owner during risk engineering and high-level review sessions to derive and execute action plans, meeting deadlines and standards.
• Implemented RUP methodology to develop process, standards, and procedures.
• Performed Gap Analysis to check the compatibility of the existing Mediation system infrastructure with the new business requirements.
• Implemented Use Cases to capture the system requirement by using RequisitePro.
• Utilized SQL (queries) programming to understand the DB structure.
• Convert the Business Process Requirements (BPR) into System Specification Requirements (SRS).
• Created different traceability views to determine feature and use case dependence.
• Traced test cases and functional specifications to SSRs and BPRs using Caliber.
• Created Interface document between upstream and downstream applications. Created, compiled, maintained and communicated orderly test results and status reports.
• Worked with the clients on the final signing process in the user acceptance stages.

Environment: MS Visio, RequisitePro, SQL Server, MS Office Suite, MS Visio, MS Project, Star UML, Star FUMLE, SSRS, SQL. SAP, Logistic s, Data Stage, PLSQL

Confidential, Manhattan, NYC

Business System Analyst/SME

Responsibilities:

• Conducted GAP Analysis and documented the current state and future state, after understanding the Vision from the Business Group and the Technology Group.
• Conducted interviews with Process Owners, Administrators, and Functional Heads to gather audit-related information and facilitated meetings to explain the impacts and effects of SOX compliance.
• Played an active and lead role in gathering, analyzing and documenting the Business Requirements, the business rules and Technical Requirements from the Business Group and the Technological Group.
• Co - Authored and prepared Graphical depictions of Narrative Use Cases, created UML Models such as Use Case Diagrams, Activity Diagrams and Flow Diagrams using MS Visio throughout the Agile methodology
• Documented the Business Requirement Document to get a better understanding of client's business processes of both the projects using the agile methodology.
• Facilitating JRP and JAD sessions, brainstorming sessions with the Business Group and the Technology Group.
• Documented the Requirement traceability matrix (RTM) and conducted UML Modelling such as creating Activity Diagrams, Flow Diagrams using MS Visio. Analyzed test data to detect significant findings and recommended corrective measures
• Co-Managed the Change Control process for the entire project as a whole by facilitating group meetings, one-on-one interview sessions and email correspondence with work stream owners to discuss the impact of Change Request on the project.
• Worked with the Project Lead in setting realistic project expectations and in evaluating the impact of changes in the organization and plans accordingly and conducted project-related presentations.
• Co-coordinated with the offshore QA Team members to explain and develop the Test Plans, Test cases, Test and Evaluation strategy and methods for unit testing, functional testing and usability testing

Environment: SOX, SharePoint, SQL, MS Visio, Oracle, MS Office Suite, Quality Center, XML, XHTML JSP, MS Visio, MS Project.