SUMMARY:

• A results oriented Business Analyst professional with focus on delivering efficient and cost effective Information Technology solutions. Extensive hands - on experience in gathering and understanding complex business requirements for insurance, pharmaceutical, and telecommunication industries.
• Excellent communicator well versed in serving as a liaison between business stakeholders and technical implementation teams. Management of Full Life-Cycle software development including: requirement analysis, use case, data modeling, software architecture, implementation, testing, performance tuning, production deployment and support. Familiar with RUP and SCRUM/Agile methodologies.

TECHNICAL SKILLS:

Software: ASP, SQL, PL/SQL, TSO/ISPF, UNIX Shell, COBOL II, MICROFOCUS COBOL, SAS, MVS/JCL, Sync Sort, MQ Series, Oracle 10g, PeopleSoft, IBM Utilities, Librarian, EASYTRIEVE, FILEAID, CMS, SQA Suite, SAP, CICS,SPUFI, QMF, MS Office (advanced), UML, Visio Pro, MS SharePointHP Quality Center

Databases: MS Excel, MS Access, Teradata, DB2, MS sqlServer, XDB, VSAM

Systems: IBM MVS/XA/ESA, MS Windows, Unix, Lawson

PROFESSIONAL EXPERIENCE:

Confidential

Project Manager/Business Analyst

Responsibilities:

• Project Manager coordinating and managing the selection process of potential vendors for MK Payroll Process. (Web based time and attendance solution with workforce management capability).
• Conducted research and analysis to quantify business opportunities and issues and developed formal recommendations for presentation to management.
• Worked with client to generate solutions to business issues and then planning/implementing those solutions.
• As a Project Manager fully responsible for identifying and understanding all the Payroll challenges and needs.
• Experience interfacing (inbound and outbound) Payroll results to and from agency Systems. (Epicor, NOVATime/Andrews Technology).
• Communicated and collaborated with internal customers, controllers and stakeholders to analyze information and business need for delivering functional and technical requirements using Use Case approach, Use Case Diagrams, Class diagrams, wire-frame diagrams, screen-mock up, Navigation Flow, and Business Flow Diagrams.
• Scheduled and facilitated project status meetings with project owners and Payroll/HR Team.
• Selecting Product that will allow MK to operate more efficiently, save time, reduces payroll cost and drive sales and productivity.
• Scheduled and facilitated potential vendor’s solutions demonstrations for MK Payroll/HR executive team.
• Directed, moderated and negotiated multi-functional groups.
• Review selected vendor implementation process.
• Facilitated and participated in presentations for internal/external business partners.
• Worked with the business to identify key decision points and build decision models to identify business rules.
• Process payroll adhering to comply with company rules and regulations.

Confidential

Lead Business Analyst

Responsibilities:

• As a member of BC (Business Content) team fully responsible for understanding all the BC Dependencies (common interfaces to integrate with data regarding policy holders, policy, coverage, covered items, limits, deductibles, SIR information, reinsurance flag (identification if information is available), co-insurance information, etc.
• Documenting business processes and workflows and their relationships to current and future software solutions. Responsible for understanding the data flow from each of the systems in Meta Data (APT Gold, BC1, BC2, Dev).
• Responsible for successful load of Code/Decodes spreadsheet and other tables to APT Gold, BC1, BC2 Dev databases.
• Owned Code/Decode spreadsheet (Descriptions/Category Number, Code/Decodes, Code Relations), and tables, Events and Response type spreadsheets.
• Fully automated or semi-automated diary actions to make the claims handling process more efficient and consistent (e.g., completely automated correspondence such as acknowledgment letters and forms).
• Partnering with business users around the globe to fully surface their requirements; conducting interviews with key project stakeholders, SME’s and document and presenting the results.
• Scheduled and facilitated meetings with project owners and SMEs from US, UK, Germany and Italy.
• Responsible for tagging all the Forms and Correspondence for CR4 release.
• Provided all the Forms and Correspondence in Confidential format for each European carries like UK, Italy, France, Spain, Germany, Portuguese, Dutch (Using MS SharePoint 2010).
• Supporting traceability from requirements through to QA; developing the definition of test plans and testing strategies and assisting in the creation of test cases and test scenarios from user stories.
• Worked closely with the Build team, made fixes to the majority of application during the test phases using HP Quality Center.

Confidential

Principle Business Data Analyst

Responsibilities:

• Principle Business Analyst/Project Manager responsible for coordinating and managing all of Quick Indicator User Interface (QIUI) related projects.
• Communicated and collaborated with external and internal customers and stakeholders to analyze information and business need for delivering functional and technical requirements (Use Cases, class models/diagrams) to outsourced software development teams.
• Participated in development project proposals and coordination business requirements documentation.
• Prepared and maintained tracking status documents for Quick Indicator project.
• Elicited requirements through interviews, document analysis, workshops (JAD Sessions), surveys, and site visits.
• Scheduled and facilitated project status meetings with project owners and outsourced software development team.
• Conducted weekly/monthly/quarterly status meetings within the various user groups
• Developed User Acceptance Testing (UAT) documentation (test strategy, test cases, test data), participated in test activities and validated test results.
• Coordinated program and project framework with senior management to ensure consistency and compliance within company guidelines.
• Critically evaluated information gathered from multiple sources, reconciled conflicts, decomposed high-level information into details, abstracted up from low-level information to a general understanding, and distinguished user requests from the underlying true needs.
• Project lead and coordinator for all systems changes needed in the development of new business initiatives.
• Collaborated with developers and subject matter experts (SMEs) to establish the technical vision and analyze tradeoffs between usability and performance needs.
• Produced ad hoc projects upon management request.
• Reported project progress to senior management.

Confidential

Senior Business/Data Analyst

Responsibilities:

• Managed and design, development, implementation and produced interface specification documentation for existing Payroll, HR Compensation and Executive Compensation programs.
• Communicated and collaborated with external and internal customers and stakeholders to analyze information and business need to deliver functional and technical requirements to software development teams.
• Elicited requirements through interviews, document analysis, requirements workshops (JAD and JRD sessions), surveys, and on- site visits.
• Reviewed and reverse-engineered program code into a well-defined, well-structured documentation utilizing use case approach.
• Critically evaluated information gathered from multiple sources, reconciled conflicts, decomposed high-level information into details, abstracted up from low-level information to a general understanding, and distinguished user requests from the underlying true needs.
• Collaborate with developers and subject matter experts (SMEs) to establish the technical vision and analyze tradeoffs between usability and performance needs (portals, e-rooms, net meetings, etc).
• Responsible for providing interface specifications in a given format for J&J integration team.
• Researched and identified data sources (MS SQL Server, Mainframe, Oracle, and flat files), constructed data flow and data decomposition diagrams.
• Prepared process flow diagrams; sequence diagrams; context diagrams in UML notation using Visio.
• Responsible for creating project plan and monitoring progress against plan for all projects and production releases.
• Coordinating between cross-functional groups and making key decisions to ensure the timely delivery of the production releases and various projects assigned
• Conducted weekly/monthly/quarterly status meetings within the various user groups
• Developed User Acceptance Testing documentation (test cases, test scenarios from user stories, test data).
• Provided suggestions for process improvements and streamlining where appropriate.

Confidential

Senior Business Analyst

Responsibilities:

• As a Lead Analyst responsible for development, maintenance and ongoing enhancements of MILAN data warehouse.(large amounts of data in an extremely complex multi-platform and multi-system data processing environment Windows-UNIX-MVS - Teradata - SQL Server - Oracle).
• Gathered Requirements, built logical models and provided quality documentation of detailed user requirements using sequence diagrams; context diagrams in UML notation.
• Researched and identified data sources, constructed data flow and data decomposition diagrams (MS Excel).
• Utilized and integrated various data sources: Teradata, DB2, MS SQL Server, Oracle, flat files.
• Proposed solution to automate processes to trigger JCL jobs on Mainframe.
• Created multiple scripts for daily data manipulation, transformation, cleanup and loading.
• Developed, maintained and operated monthly market segmentation and database scoring process for identifying Military segment customers.
• Identified and effectively managed synergies and potential conflicts across systems/operational impacts.
• Provided monthly results tracking, analysis and reporting.
• Interfaced directly with clients and Confidential &T data centers.
• Conducted regular status meetings amongst all project teams.
• Developed requirements traceability matrix.
• Reported project progress to senior management.
• Gathered Requirements for the project identifying international customers based on usage and calling plan.
• Designed highly efficient process for loading, analyzing and refreshing international data on SQL Server from different sources.
• Managed and maintained of International Consumer Long Distance (ICLD) project, utilization of (MS SQL Server 7.0)
• Responsible for maintenance and analysis of MPS data and generation of various reports upon client’s requests.
• Created specifications for troubleshooting GPPC monthly processes including client interface and design.
• Provided Monthly GRADS Book close tapes results.
• Managed ad-hoc analysis for project previously Lucky Dog, Confidential &T’s dial around code.
• Responsible for providing and sending monthly files to the client.
• Updated and created quarterly reports for Lucky Dog Mexico Rate Band Data.
• Created and executed test plan and test cases.
• Daily production of ad hoc requests based on specifications of group management.
• Participated in all meetings, conference calls and the decision making process.

Confidential

Senior Systems Analyst

Responsibilities:

• Supported Confidential &T Marketing Science division by producing statistical samples extracted from
• Acted as a List Manager for ongoing online/mail marketing promotion programs. Responsibilities included:
• Generating a list based on marketing specifications using SQL script for e-mail blast campaign.
• Data Analysis in customer database.
• Was responsible for loading data with operational data (clicks tracking, surveys data tracking).
• Developed reporting tools (ASP) for web-based promotional campaign ( Confidential &T Click it Rich).

Confidential

Project Manager/Business Analyst

Responsibilities:

• Analyzed and determined project complexity.
• Provided high level business and systems requirements to internal and external vendors.
• Developed Business Requirements document.
• Created use case specification to define functional require ments.
• Project lead and coordination for all systems changes needed in the development of new business initiatives.
• Responsible for issue identifications, resolution, issue logging, escalation.
• Performed testing,, implementation into production.
• Investigated and analyzed interface errors and resolved system/requirement issues.
• Managed outside telemarketing agency by prioritizing work and negotiating time and cost.
• Acted as a liaison between Sales/Marketing and outside agencies.
• Ordered and reported requirements to meet marketing needs.
• Developed test scenarios and tested the application that allows sales/marketing departments to collect and analyze data for tracking potential customers (MS Excel).
• Designed test-case specifications according to business requirements.
• Maintained user interaction to address system’s business requirements.
• As a member of the Sample Management Group provided everyday production support for the Marketing Research Department.
• Maintain COBOL/SAS/VSAM based sample creation system for Confidential &T Consumer Services Group.
• Create and maintain JCL PROCs and EXECs for daily vendor sample creation runs.
• Heavy interface with Confidential &T contracted sample vendors to resolve requirements and technical issues.
• Use control files and reports to daily track status of monthly sampling process and create additional sample when needed to ensure that vendors meet monthly quotas.
• Work on technical requirements to convert SAS based programs and databases onto COBOL/VSAM based processing
• Provided daily, weekly status reports to the Marketing Research Department.
• Modified existing and coded new program modules.
• Participant in all meetings, conference calls in the decision making process to establish and revise time frames, documentation regarding project feeds, date changes revisions, updates.

Confidential

Systems Analyst

Responsibilities:

• Performed analyses, coding, testing of Customer Service System.
• Participated in the monthly release of the pharmaceutical insurance application-Point of Sale System.
• Wrote and modified various on-line and batch modules to satisfy new user requirements.
• As part of the team, was involved in full project Life cycle, System and User acceptance, regression, integration and maintenance testing.
• Designed test-case specifications according to business requirements.
• Heavy user interface responsibilities.
• Performed the disaster recovery testing for the Customer Service Application.