TECHNICAL SKILLS:

• Data Analysis with tools such as Google Analytics, Crystal Reports, TOAD, Business Objects, MS - SQL server 2012 and Oracle (SQL Developer)
• SQL queries, Data Mining, ETL, Data Analytics and Trend Analysis
• Business Process Modeling and Data Warehouse Concepts
• Microsoft - Word, Excel, Access, Visio, Visual Paradigm, Project, PowerPoint and SharePoint
• Testing tools - JIRA, HP-ALM, BMC Remedy and Soap UI
• Internet Explorer, Outlook Express, and Windows 8/7/Vista/XP/NT
• Web research and usable data drilling and retrieval/Investigation and Typing Speed - 60 to 80 WPM
• Excellent ability to discuss technical issues with non-technical users in a clear and effective manner
• Strong business requirements gathering and documentation skills
• Exceptional ability to balance customer needs with business objectives
• Able to produce quality work within tight timeframes and simultaneously manage several projects
• Proven ability to reduce costs during the Software Development phase.
• Have excellent analytical and problem-solving skills and strong critical thinking/applied logic skills
• Able to interact and liaison with business partners and other technical teams
• Lead by example with driving standard workflow and being process oriented
• Able to interact and clearly communicate with all levels of management, employees, distributors, clients, and suppliers
• Take personal responsibility and ownership of their work and strives for quality outcomes and results
• Experience in using problem-solving techniques to determine root cause followed by sustainable corrective action
• Project management and coordination experience. Knowledgeable in the use of Microsoft Project to oversee large project timelines
• Have knowledge and experience of standard project methodology processes and Joint Application Design/Development sessions (e.g. Scrum, agile process, requirements analysis techniques, testing approaches)
• Have comprehensive testing skills including the ability to ensure that the system is meeting all defined requirements. (Have experience writing use cases, test cases and executing test scripts)
• Have experience writing functional and non-functional specifications
• Possess an understanding of the financial industry (banking and securities brokerage), healthcare industry (health insurance industry) and telecommunications and digital media industry (print & online)
• Purchasing & Inventory management experience
• Production scheduling and planning experience and Print/Card production experience
• Exceptional knowledge of HIPAA Privacy and Security Policies. Familiarity with HIPAA and PHI Federal regulations. In-depth knowledge of Health Information Management activities and hospital administration methods

PROFESSIONAL EXPERIENCE:

Confidential, Saint Louis, MO

Senior Business Analyst

Responsibilities:

• Created BAPD (Business Analysis Project Document) for Customer Order Confirmation and Home Shipment Tracking through elicitation from stakeholders
• Created business requirements for Voluntary Disconnect, Store Pick Up and Equipment Swap notifications through customer’s contact preferences
• Designed Call Flow diagrams in Visio and business process flow in Visual Paradigm
• Designed email, SMS and IVR templates for multiple event notifications
• Performed GAP analysis and initiating change request for documenting requirements for debugging code and enhancements
• Scrum Master for the daily touchpoint call with CSG for code development status, removing bottlenecks and following up on outstanding issues
• Facilitated JAD sessions with CSG for reaching consensus on business requirements for Voluntary Disconnect, Store Pick Up and Equipment Swap notifications
• Drafted test scenarios and performed User Acceptance Testing for SMB 3.0 user roles and New Connect notifications in test (QAKA) and production (PROD) environments
• Performed User Acceptance Testing for validating functionality of Advanced Customer Service Representative (ACSR) Gateway module
• Analyzed impacts of new projects like Charter Secure Connection on existing projects like Preferred Communications
• Formulated business processes for Unified platform to integrate Preferred Communications processes with Time-Warner and BHN to bring all under the Spectrum brand
• Acted as SME from Preferred Communications team and handled all queries from upper level management
• Verified estimation of Level of Efforts (LOE) from CSG and synced them in line with the project plan
• Performed API testing in (Soap UI 5.2.1 Restful services) for validating Evolve Customer (CSG database) sync process data in JSON format
• Performed backend database testing in SQL developer for PREF COMM and VANTAGE database testing in QAKA and PROD environment
• Analyzed data from ad-hoc reports for management using Pivot tables and generated dashboard reports for Preferred Communications portal
• Designed CSR training documents for reflecting the most recent production environment changes and proper interpretation of the business rules
• Tracked defect in HP-ALM (internal tracking for CSG and IT-Gateway tickets, Business ), and BMC Remedy Service Request Management(external tracking for CSG tickets) Utilized JIRA for creating requests for template approval
• Assisted Program Manager as needed with Project Management in updating project status plan, creating RACI matrix and maintaining SharePoint portal

Confidential, Saint Louis MO

Senior Systems (Business) Analyst/Interim Project Manager

Responsibilities:

• Created Master RTM file consisting 5000+ records and analyzed the absence of Use Cases from all the 67 functional requirement documents for National Applicant Tracking System (NATS)
• Prepared business process models, activity diagrams, use cases, user stories, user acceptance criteria, and textual requirements for 3V Full Sale transactions for migration from PLAS (COBOL legacy systems) to Direct Loan System (Java based)
• Communicated directly with client-USDA FSA business users and product owners and identified problem areas, risks, and solutions for business and technical problems
• Performed requirements verification activities
• Applied appropriate techniques for eliciting, composing, and structuring requirements within a virtual team environment
• Led requirements sessions with technical and business resources
• Elicited, captured, documented, prioritized, validated and communicated business needs and expectations
• Facilitated requirements development by participating on project teams as part of an agile team, communicating stakeholder needs and expectations, facilitating team prioritization, estimation and task planning, validating requirements development and results and communicating progress and results with product owners
• Utilized HP-ALM (external - business unit) and JIRA (internal team) software for tracking defects and managing requirements throughout the application development and testing cycle for the Customer History project
• Created Supplementary Specifications document for the Customer History project detailing the 2013 and 2014 gap analysis changes as well as their impact on the project scope
• Assisted in manual testing of the production data using SQL queries in MS-SQL server 2014
• Created Business Vision document defining project scope and limitations for the Commercial Credit bureau project including work flow/process flow diagrams in Visual Paradigm and data mapping diagrams
• Writing and Executing SQL queries for extracting and testing data for projects
• Developed and modified existing UI screens (wireframes) in Visio/Visual Paradigm for enhancing the capabilities of the system to meet Client needs
• Organized and chaired User Experience (UX) sessions with Client for development and approval of UI prototypes
• Eliminated use of Tax ID/SSN by using a surrogate ID and implementing in projects to be in compliance with PII
• Assisted PMO office in transitioning from Waterfall to Agile methodology by reproducing artifacts
• Updated weekly project status on SharePoint as well as dashboard metrics reports on ad hoc basis during transitioning of PMs
• Delegated and monitored tasks from team members while acting as interim PM

Confidential, Saint Louis MO

Senior Technical Project Manager/Business Analyst

Responsibilities:

• Managed 2 SOW Java based projects for MasterCard simultaneously - Smart Data Migration & Bill Pay-R2
• Bill Pay-R2 software was completely designed and developed using Agile methodology including System Testing and UAT
• Smart Data Migration project utilized waterfall methodology and included 4 waves with more than 40 mappers
• Extensive use of MS Project, Excel, PowerPoint, Visio and other MS Office products was required
• Identified and tracked Project Issues, Risks and generated a Jeopardy when required
• Organized and chaired daily scrum meeting with the internal onshore & offshore team in India
• Interfaced with client (MasterCard) to determine their business requirements and establish project roadmap
• Interacted weekly Confidential the client site (MasterCard) with their PMO and updated them with the revised project plan
• Generated weekly Project Status reports for client (MasterCard) and PRI’s Management review
• Demonstrated the front-end User Interface screens to the client’s (MasterCard) Business Leader weekly for approval
• Monitored PRI’s internal project plan adherence to client’s (MasterCard) Master project plan
• Managed projects utilizing PMBOK practices and practices directed by MasterCard’s Connect (MCC) system
• Requested and received successfully an extension of Change Management Request due to the flux in the business requirements of the client (MasterCard) for Bill Pay-R2
• Completed Wave 2 and 3 of SDG project ahead of time and cross-utilized those resources with Bill Pay-R2 project
• Tracked and reported the progress of the Quality Assurance and UAT testing associated with this project
• Supervised a staff of 30 (Business Analysts, IT developers, QA analysts, and Life Cycle Management personnel)
• Conducted Joint Application Development (JAD) sessions and interviewed Subject Matter Experts (SME’s), asking detailed functionality aspects of business process and carefully updated the information to the requirements in an easily understandable format
• Chaired client’s design reviews, requirement reviews, managed the system requirements baseline process and managed the change control process associated with requirement changes.
• Participated in gathering business requirements and the generation of system requirements.
• Tracked project budget and generated project budget forecasts
• Served as the primary interface between management and clients
• Managed and tracked the resolution of project risks and issues
• Chaired the Change Control Board and participated in the Release Management process
• Approval of timesheets/leaves of project based resources and updated the weekly budget planner
• Recruited & Terminated(sourced/interviewed/tested/screened) qualified candidates for the project
• Restructured jobs and assignments that significantly improved cost control by eliminating positions
• Created data mapping diagrams and work flow charts for business processes in MS-Visio

Confidential, Saint Louis MO

Senior Business Analyst

Responsibilities:

• Created dynamic Production Timeline table based charts in Excel maintained with values for production steps so that updates are easily made
• Production Metrics database reporting in Excel of workload, quality and on-time delivery SQL queries in Access simplified
• Created auto-generated graphs for Client Review presentations from standard reporting
• Converted Inventory tracking in Microsoft Excel to Inventory database in Microsoft Access
• Created the Account Management Implementation Plan macro-enabled Excel spreadsheet which included current timelines and options so InteliSpend and clients understand program launch timing and dependencies, supporting Program Management Excellence and client satisfaction, and improving on time delivery performance
• Designed an InteliSpend MetaBank Program Information Application macro-enabled Excel form for Marketing Communications so it featured user driven restrictive choices while feeding data to reduce errors in transmission resulting in increased efficiency in production
• Linked Fulfillment Holds reporting to Production database and Inventory database and linked Production database to Inventory database so as to eliminate manual redundant methods of entering Production reprint and updating information into inventory reporting
• Automated new job auto-population in the Production database from Portico quote data
• Automated import of inventory data tables in Inventory database from Source One Direct database
• Designed and created custom spreadsheets and databases, utilizing advanced functions, transparent background cross linking and data validation methods
• Interacted with client-facing Program Managers as necessary to accommodate specific program requirements.
• Designed and implemented system based error-proofing controls in workflows and processes to drive continuous improvement
• Designed, created, maintained and delivered electronic tools and reporting required for Operations and Production needs
• Determined reorder points and quantities for inventoried printed materials that balance inventory carrying costs and economical order quantities to achieve least total cost to InteliSpend. Includes the use of Excel to develop formulas, set reorder points and manage optimal inventory levels to support on time delivery performance
• Maintained AMEX Security requirements as related to Personally Identifiable Information (PII) data and card production
• Trained new employees and served as subject matter expert on system and reporting related processes

Confidential, Saint Louis MO

Business Systems Analyst/Access Review Consultant

Responsibilities:

• Responsible for implementing and monitoring a risk-based program to identify and mitigate any operational risk that arises from inadequate or failed internal processes, people, systems or external events or may provide oversight of an operational risk program
• Provided as needed drafts of corrective action plans and in managing change. Identified training opportunities.
• Provided input to the development of training materials and delivered training. Drafted reports of findings and recommendations to mitigate risk for operational risk management
• Coordinated production of periodic operational risk performance reports for senior management, including trend analysis and recommendations
• Coordinated the system access program for assigned business units and partnered with various business lines to determine what types of system access is required by the various job roles within those groups
• Coordinated with application teams, function owners, etc. to validate that access is correct, ensure it is assigned using the least privileged approach and approve the change requests
• Coordinated with the Project Manager, Technical Lead and SME to identify any gaps and ensure the project milestones are met
• Coordinated with internal and Sox Auditors to validate access level changes and supporting documentation meet Sarbanes-Oxley (SOX) and Gramm-Leach-Bliley (GLB) testing requirements for key and non-key controls
• Created and maintained relational databases in Microsoft Access with extensive use of SQL queries and Microsoft Excel spreadsheets to track key deliverables and project status

Confidential, Saint Louis MO

Senior Data Analyst

Responsibilities:

• Enabled in generating approximately $10 million in revenue, which was 200% of the targeted annual revenue goal for 2009
• Responsible to compile and report to the upper management team, the results of the Sales Lead Scorecard
• Assisted in the retrieval and cleansing process of the lead source data for monthly ISLP drops
• Conducted vendor observation sessions on the Lead Generation effort, data analysis on efforts on both lead source data providers and lead qualification vendors
• Assisted in the development of forecasting model and assisted in data mining, compilation and training on the utilization of the Accelerated Leads Tool application
• Extracted, Transformed and Loaded (ETL) new qualified leads into Accelerated Leads Tool via Microsoft Access and assigning to Regional Sales Managers
• Created and analyzed new qualification leads reports for management review obtained from vendors
• Resolved discrepancy between the Sales Warehouse SOLD leads data versus Accelerated Leads Tool data
• Updated the master database file (comprising of 500,000 plus records in Microsoft Excel) weekly with new qualified leads and results from the results of various dispositions from Accelerated Leads Tool via queries through Microsoft Access
• Designed and executed the roadmap for successful implementation of SQL based Accelerated Leads Tool database
• Built and maintained SQL scripts, indexes, and complex queries for data analysis and extraction
• Performed quality assurance and testing of SQL server environment
• Ensured best practices are applied and integrity of data is maintained through security, documentation, and change management
• Worked with internal and external clients for import and normalization of third-party data
• Documented and maintained database system specifications, diagrams, and connectivity charts
• Monitored and provided front-line support of daily processes
• Liaised with project management and development teams to identify and implement reporting, control, and automation opportunities to improve overall access to information
• Supported all production operation activities, with focus on integration and development of new and existing products and services
• Created Process flowcharts for Sales Lead Generation efforts for the Yellow Pages Sales team in MS-Visio

Confidential, Saint Louis MO

Senior Data Analyst

Responsibilities:

• Administered access to users Confidential various levels in different software applications and Active Directory
• Data Analysis and Data Mining of Service Level and Ticket Volume for Access Operation Centre
• Generated weekly Service Level Agreement reports for Access Operations Centre
• Responsible for creating accurate and meaningful reports for departmental and management decision-making using Microsoft Access, Excel and other reporting tools as necessary.
• Responsible for daily activities involving data mining, reporting and analysis to ensure customer service levels are maintained
• Responsible to analyze and interpret Service Level and Ticket Volume
• Created forms in Microsoft Excel for workload monitoring and queue management

Confidential, Saint Louis MO

Data Analyst/Consultant

Responsibilities:

• One of the top 10 producers in new agents with gross sales of over $2,683,275.00
• Generated gross profits of $189,729.00 for the company
• Responsible to create and maintain detailed performance metrics reports in Excel
• Presented accurate reports to the management for review and analysis
• Assisted Confidential and Confidential customers in booking air-tickets, rental cars and hotel reservations

Confidential, Chesterfield MO

Sales Associate

Responsibilities:

• Salesperson for Chesterfield valley area
• Top 10 agents for open house lead generation for October 2005
• Trainer for IT classes such as MS-Word, Excel, PowerPoint and real estate application such as MARIS for new agents

Confidential, Belleville IL

Business Strategy Planner

Responsibilities:

• Collected more than $68,000.00 over the phone payments for delinquent bills
• Maintained detailed spreadsheets for further review and analysis
• Extremely assuring and convincing to generate faith in getting post-dated payments
• Strategized and negotiated individualized payment plan options

Confidential, Saint Louis MO

Information Technology Administrator

Responsibilities:

• Maintained software and hardware equipment worth $500,000.00 in running condition for staff, faculty and student use
• Diagnosed and troubleshoot technical problems faced by users
• Conceptualized the REFRESH database in Microsoft ACCESS (for tracking inventory, acquisition, disposition and replacement) through meticulous business planning and seamless execution
• Administered computer based testing for incoming freshmen
• Deployed more than 20 computer labs on campus for various departments