SUMMARY:

• I am IT Business System Analyst/Project Manager with over 8 + 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 10g, and Oracle 11g. I am very client-facing with the ability to build strong relationships. I am a progressive IT Business System Analyst with a Bachelor degree
• 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 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 Requisite Pro, Microsoft Word.
• Experience in networking with individuals at 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 Star UML.
• 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.
• 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.
• Network Hubs, Modems, Repeaters, generic Routers, and CISCO Routers Switches.

PROFESSIONAL EXPERIENCE:

Confidential, Deerfield, IL

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 specialized applications 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: ability 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: SOX, SharePoint, SQL, MS Visio, Oracle, MS Office Suite, JIRA, Quality Center, XML, XHTML JSP, MS Visio, MS Project.

Confidential, Deerfield, IL

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.
• Used Teradata utilities fast load, multi load to load data
• 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
• 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)
• Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.
• Experience in importing/exporting data between different sources like Oracle/Access/Excel etc. using SSIS/DTS utility.
• Experience in ETL processes involving migrations and in sync processes between two databases.
• Experience in Microsoft Visual C# in script component of SSIS.
• 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, 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 ecommerce 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 subsequent 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 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 business of the clients.
• Identified business reporting needs through the use of the MIS tool.
• Conducted weekly Crystal Report and Oracle SQL 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 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 Web Top, Documentum Administrator.
• Assisted with the creation of Standard Operating Procedures (SOPs) to maintain equality while providing high level end 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 Teamwork’s & Corticon Rule Engine. Having good knowledge on other Appian 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 with in the cooperation in the area of content management, Record management and compliance, Business process management and image capture.
• Thorough 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/TBASE and DB2 tables
• Determining the appropriate tables to be updated keeping in mind the relationship between the tables.
• Requirement gathering from various stakeholders as automations 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 at 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 application.
• 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 end-user'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, Access IT 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 was 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 .
• 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 service 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 existing system and evaluated benefits of new 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