PROFESSIONAL SUMMARY:

• Over 10 years of experience in the IT Field with an emphasis on Requirements Gathering, Business Technology and Ecology Architecture, and Business Contingency Planning
• Experience working as a lead - Taking initiative, providing direction, dispersing tasks and reporting updates.
• Extensive experience with process modeling using UML, Flow charts, sequence diagrams, activity diagrams and Use Cases.
• Experienced in conducting Joint Application Development (JAD) sessions with end-users, Business system analysts, software developers and quality assurance teams for project meetings
• Experience with Business Intelligence Tools like Business Objects (Supervisor, Designer, and Reporter), Cognos (Cubes, report studio, etc.), Microstrategy and Crystal Reports.
• Experience with various data sources like SQL Server, Oracle, MS Access, and Flat files.
• Trained in SAP Modules SD/MM.
• Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team

TECHNICAL SKILLS:

OLAP & Reporting: Business Objects Reports/Webi, Cognos, Microstrategy, Crystal Reports.

Databases & Tools: Oracle, SQL Server, TOAD, SQL PLUS

Languages: XML, HTML, SQL, PL/SQL

ETL Tools: Informatica

Business Tools: MS Visio, Microsoft Office, Adobe Acrobat, Adobe Captivate, Sharepoint, Box, etc., Salesforce.com

Methodologies: SDLC, RUP, Agile, Design as a Process

PROFESSIONAL EXPERIENCE:

Confidential

Lead Business Analyst (Director)

Responsibilities:

• Functioned as lead Analyst/PM and performed Requirements Elicitation for Revenue and Expense Management System implementation for Mutual Fund Fees/accounting.
• Assisted in the new SAP journal entry booking project by strategy
• Created 200++ ETL specification for a non-conforming data project
• Assisted in managing 2 offshore teams and multiple onsite resources
• Created a Work Breakdown structure for multiple BAs and vendors, where applicable
• Performed Business analysis, documentation, validations and assisted in development and QA
• Documented the proposed to-be process for Sub-advisory, Trails, Sub-transfer agency fees and Fund Invoicing
• Sourced marketing data from Broadridge, partner investment firms, Market Metrics Discovery and other independent firms
• Created models, acceptance criteria and guidelines for Proof of Concept for Sales Performance Management systems (e.g. Varicent, Xactly, Callidus cloud)
• Worked with vendors to define gaps in the product to work in the Asset Management world
• Assessed and documented business requirements and queries in relation to Fixed Deferred Annuities, Variable Annuities, Third party retail and Marketing groups for multiple dashboards
• Assessed tools that can perform intelligence on-the-go for mutual funds marketing and sales (Qlikview, DOMO, etc)
• Analyzed and documented changes for Salesforce systems
• Lead the BA team for the implementation of sourcing data from DST Sales Connect and bridged to existing warehouse.
• Documented requirements for a new Sales Performance management system based on changing structures and sales campaigns.
• Designed demand intake forms and process for business requests
• Assisted IT teams in establishing guidelines on specifications
• Functioned as Business Analysis Process Owner for entire NYL Investments teams

Confidential

Product Service Owner/Lead Analyst

Responsibilities:

• Worked with the SAP migration team to migrate some of the applications to SAP environments such as MM and FI.
• Led a team of 11 in instilling a process in business support teams.
• Documented and organized existing or new enhancement request from the train control business.
• Approved changes and outages, when and if necessary.
• Reviewed verification and validation UAT test cases.
• Managed business expectation and prioritize business requirements.
• Negotiated prioritization of enhancements with the business.
• Negotiated enhancement with other teams on behalf of the Train Control business.
• Assigned enhancement requests to the development team.
• Revamped and restarted a completely failed project.
• Elicited Business Requirements in a short period of time
• Created functional requirements based on business requirements.
• Prioritized requirements based on cost and effort
• Created Status Reports for the directors.

Confidential

Senior Analyst

Responsibilities:

• Led the initiative and managed seven (7) onsite resources.
• Performed a market study of Industry standards and generally requested tools by the Members.
• Performed Scope identification, prioritization and management for the project.
• Performed Cost Benefit Analyst for the business processed to be converted online.
• Worked with the team to create an RFP for vendors to provide assistance with the project.
• Provided wireframes and samples as needed for the project.
• Created high level Business Cases and sequence diagrams for both the Business and Technical teams.
• Documented backlogs and prioritized features
• Worked with development in identifying features per sprint.
• Worked on documenting user stories for each sprint.
• Led the requirements elicitation initiative and led the group in creating a prototype.
• Performed research on industry practices on Secure Member Messaging.
• Facilitated sessions with development team to brainstorm implementation strategies and complete Prototype.
• Authored a Functional Specification based on the change order provided by the FEPDO.
• Facilitated a walkthrough with the FEPDO, development team, QA team and team.
• Analyzed web analytics tools (Omniture site catalyst, Google Analytics) currently available in the market.
• Performed a gap analysis on what is currently captured in the Event Reporting Systems.
• Worked with the development team to identify data structure to store data. Created dummy tables for presentation purposes.
• Created sample SQL queries for reporting.
• Performed current state analysis of the MyBlue Customer eService Permissions settings.
• Analyzed industry standards on how HIPAA privacy rights affect claims viewing capability.
• Presented implementation strategies to the business.
• Created background sheets for distribution to all Blue Cross Blue Shield Plans.
• Created flows that will allow the Member as well as the Customer Service representative to assist the Member in updating the registration email.
• Updated use cases that refer to the act of updating registration email from the CSR end.
• Participated in JAD sessions to discuss additional functionality as described in the SOW.
• Assessed impact of change on other related systems.
• Communicated any suggestions, issues and roadblocks to stake holders.
• Produced and updated use cases for the current system with current functionalities as well as future planned functionalities.
• Updated database documentation with new fields required
• Updated error and validation rules documentation and presented it to development.
• Coordinated new functionalities with the development team and assisted in understanding on how the new system should work.
• Assisted testers in creating test cases based on the use case documentation prepared.
• Prepared new report layouts based on new functionalities.
• Created recorded demonstration for plan SIM with attendance of more than 200 person audience.
• Assisted in the further analysis during systems and integrations test.
• Worked with team to ensure data from the claims system was brought into the data warehouse.
• Documented ETL requirements

Confidential

Sr. Analyst

Responsibilities:

• Worked Closely with the Project Manager and acted as APM while coordinating across all COEs (BA, PMO, DA, DMO, ETL, BI, QA - 27 associates)
• Mend IT and business team rapport and relationships.
• Reviewed business requirements and assisted in completing the finalized FRD.
• Reviewed Use Cases and Test Cases.
• Assisted in defining standard templates that are required for report specifications.
• Performed Financial and Data Analysis to understand Accounting concepts to be applied to the reporting needs as well data structures in the Data warehouse to be able to query and create a Proof of concept.
• Documented a data mapping and data dictionary for the FCS project.
• Created SQL queries to check for test data.
• Documented derivative notional and fair value analysis as well as mitigation strategies on foreign investments using derivatives.
• Communicated outstanding questions and assist in query resolutions.
• Analyzed viable solutions to the business requirements
• Worked with Cognos BI team to explore the best approaches for reporting needs.
• Extensive documentation of BI reporting specifications.

Confidential, Owings Mills, MD

Sr. Analyst

Responsibilities:

• Maintained current forms in E-documents application.
• Made necessary XML and HTML and query information updates as necessary on E-docs forms.
• Communicated with business on any changes and kept users posted of any updates.
• Interviewed competitors on current processes.
• Determined problems and suggested solutions on each repetitive process.
• Depicted current flow and created multiple alternate flows.
• Determined Solutions to each issue and discussed probability of success with technology team.
• Bridged communication between stakeholder and technology to better explain plausible workaround items.
• Built Business Case / Deck: Market Parity, Cost Benefit Analysis, Resource planning, level of effort.
• Interviewed departments and created narratives.
• Created current state and future state workflows.
• Created Sample Use Cases for the project.
• Created a business Case / business deck: Market Parity, Cost Benefit Analysis, Resource planning, level of effort.
• Determined the Budget required.
• Interviewed different departments to understand how the paper form is managed and the turnaround time.
• Built a Business Case: Market Parity, Cost Benefit Analysis, Resource planning, level of effort.
• Presented and submitted a Business Deck / business case to the Stakeholders for approval.
• Wrote SQL queries to insert new form information in to the DB.

Confidential

Business Analyst

Responsibilities:

• Performed Business analysis, documentation, validations and assisted in development and QA
• Performed Impact Analysis on System Processes that affect the claims systems.
• Performed JAD sessions (E.G. with Budget and Cost Recovery department) to understood business needs.
• Wrote SQL queries to create sample reports and to verify data from one source to another.
• Created and updated user documentation on each major System Function (e.g. Claims in relation to Budget group, Recoveries in relation to cost recovery department, services in relations to office of clinical affairs)
• Reviewed requirements and worked with development team to identify solutions. Then, communicated the same solutions to the business community with information on identifying data useful in measuring quantity, quality and cost of service.
• Created and updated report specifications that contain report mock ups.
• Documented and updated standard querying practices as well as guidelines to using the data warehouse for reporting.
• Worked with Budgeting and Cost Recovery group on BCR reporting.
• Worked with MCO operations to work on pharmacy reporting based on MCO data.
• Reviewed data and query results for anomalies and unusual patterns.
• Represented projects on cross-agency initiatives.
• Updated and maintained various project documents.
• Created a Vision Document with the project stake holders.
• Since MA21 is an old system, there is very limited documentation on it. Thus, the DW required used cases on how the system interacts with the users and the internal business rules on eligibility. This had to be documented to effectively design the data warehouse for its data. Also, created use cases to show how the system interacts with the users.
• Analyzed and documented process flows and any other system interfaces with MA21.
• Found a common factor in terms of inflow and outflow and defined dimensions to be pulled.
• Facilitated discussions to define management level reporting requirements.
• Updated technical specifications once development had commenced to document changes in requests that took place.
• Assisted in putting a project plan together.
• Assisted in Creating a Vision Document for presentation to management as well as the budgeting committee.
• identified, understood and documented the business processes and flows to later identify data required
• Gathered business assessments and eligibility forms and information to gather policy information.
• Performed gap analysis on Schema and coordinate with business in resolving these issues.
• Validated data fields requirements and plausibility of performing data analytics on available data with developers.
• Coordinated tasks using Rational Clear quest.

Confidential

Business Analyst

Responsibilities:

• Performed Business analysis, documentation, validations and assisted in development and QA
• Created User (Business) Scenarios from the previous system that had been released and add on to the documentation of the previous system.
• Used Enterprise Architect in Coordinating with the Architecture team in terms of review of Use Cases.