SUMMARY

• Senior Business Analyst with 10+ years of data analysis and reporting experience. Extensive experience in the banking, retail, healthcare and government domains.
• Expert in Analyzing and documenting business and functional requirements,use cases and user stories for projects and processes of significant complexity and scope.
• Experienced in creating Use Cases, Sequence Diagrams, Activity Diagrams, Collaboration Diagrams and Class Diagrams using Rational tools and Microsoft Visio.
• Extensive experience in gathering requirements and authoring Business Requirement Documents (BRD), Software Requirement Specification (SRS), Functional Requirement Document (FRD) and maintaining Requirement Traceability Matrix.
• Highly skilled in integrating data from a variety of sources. Experienced working within and leading multifunctional teams tasked with delivering custom Business Intelligence (BI) solutions.
• Expert in analysis, design, development and implementation of Business Intelligence (BI) solutions focused on streamlining data for operational, functional, and enterprise level reporting.
• Extensive experience in implementing BI concepts like self service analytics and data visualization.
• Extensive knowledge of data warehousing & big data concepts.
• Expert in Agile/SCRUM methodologies, specifically rapid prototyping and in CMS XLC (eXpedited Life Cycle) Agile currenlty used at DHS.

TECHNICAL SKILLS

CRM Tools: Salesforce Service Cloud

Reporting Tools: MicroStrategy Reporting Suite, SAS, Salesforce, Qlik Sense

Process/ Model: MS VISIO, Blueprint, Rational Rose

Database & ETL Applications: MS - Access, Oracle 10g/9i/8i, Teradata, Talend

Programming Languages: SQL, VB

Project Management: Office Suite Including Excel & MS Project, SharePoint.

PROFESSIONAL EXPERIENCE

Confidential

Sr. BI Business Analyst / Data Analyst

Responsibilities:

• Responsible for eliciting, analyzing, communicating, and validating requirements and business processes for Salesforce implementation specifically designed for reporting and analytics as part of the PSP program at CMS.
• Analyzed business needs for information relating to Premium Stabilization Program (PSP) and lead the design, customization and deployment of Salesforce reporting, on the Salesforce service cloud platform.
• Collaborated with stakeholders to develop business requirements and convert those requirements to technical specifications in support of reporting and software development. Responsible for documentation compliance with CMS XLC (Expedited Life Cycle).
• Worked on building custom reports and dashboard mockup in conjunction with key stakeholders and worked on building Salesforce Reports and Dashboards in conjunction with the development team.
• Worked on building custom reports and dashboard mockup in conjunction with key stakeholders and worked on building Salesforce Reports and Dashboards in conjunction with the development team.
• Used custom SQL queries to pull data from IDR for PSP data captured from pay.gov.
• Implemented Qlik Sense to create advanced trending dashboards focusing on data visualization and self service functionality.
• Supported product management initiatives related to Analytics portfolio. Ran BI Pilot for Qlik Sense, Salesforce Wave, and Tableau.
• Responsible for internal testing including data validation and source to target mapping.

Environment: Salesforce Service Cloud CRM, Teradata, Qlik Sense, Salesforce Wave, Informatica, MicroStrategy, Office Suite, Agile Scrum, RAD, CMS XLC (eXpedited Life Cycle

Confidential

Sr. BI Business Analyst

Responsibilities:

• Responsible for eliciting, analyzing, communicating, and validating requirements and business processes specifically designed for reporting and analytics as part of the ACA program at CMS.
• Developed timelines for project delivery, and managed projects deliverable and resources to successful completion.
• Developed project documents such as the Business Requirements Document (BRD) & Systems Requirements Document (SRD) compliant with CMS XLC (Expedited Life Cycle).
• Held regular JAD Sessions with the system architects, developers, database developers, quality testers during the entire project to assure that the critical as well as the minute details of the project were discussed and issues were resolved.
• Designed and created analytical reports built on OLAP and relational data sources.
• Thoroughly involved in building SAS Information Maps and Reports in conjunction with the development team.
• Analyzed data on system usage performance for internal and external customers utilizing MicroStrategy Reporting Services.
• Analyzed designed and helped to implement ETL GUI dashboard for BI/ETL Program. This dashboard focused on system usage & performance KPIs for internal and external customers utilizing MicroStrategy, Informatica and the IDR.
• Developed the test plan, test conditions and test cases to be used in testing based on business requirements and technical specifications.
• Responsible for internal testing including the data validation and source to target mapping.
• Led UAT with the core CMS team at OIS and CMCS.

Environment: Teradata, AWS Redshift, Informatica, SAS, Qlik Sense, MicroStrategy, Office Suite, Agile Scrum, RAD, CMS XLC (eXpedited Life Cycle)

Sr. Business Analyst / Data Analyst

Confidential

Responsibilities:

• Lead business requirements gathering for Pledging Auto Titled Consumer Loan project within the securitization initiative.
• Worked with the business users in requirements gathering and review of Business requirements for Pledging Auto Titled Loans.
• Created high level & detailed current state and future state process flow diagrams using UML diagrams including activity, sequence diagrams and data flow diagrams.
• Performed data analysis and reporting in support of program intelligence, compliance/program integrity, software usage, and data quality utilizing Excel, Access, and Business Objects.
• Created report and dashboard mockups for Business Objects based reporting.
• Responsible for internal testing including the data validation and source to target mapping.
• Led UAT with the core CMS team at OIS and CMCS.

Environment: IBM DB2, Business Objects, Office Suite, Waterfall, Mainframe, IBM Rational Suite

Sr. BI Business Analyst

Confidential

Responsibilities:

• Lead Business Analyst for the enterprise reporting project for Services Platform initiative.
• Created high level & detailed current state and future state process flow diagrams using UML diagrams and data flow diagrams which would be the foundation for creating detailed reporting requirements.
• Designed report and dashboard mockups for the services platform for diverse user groups from Shipping, to Lowes.com, to order fulfilliment, Finance and for C level executives.
• Build report and dashboard mockup in conjunction with key stakeholders.
• Supported product owner’s reporting needs throughout the project lifecycle.
• Build MicroStrategy Reports and Dashboards in conjunction with the development team.
• Implemented MicroStrategy I-cubes to optimize dashboard performance.
• Responsible for internal testing including the data validation and source to target mapping.
• Led UAT with the core management team and with key stakeholders for the SP initiative.

Environment: IBM DB2, Informatica, MicroStrategy, Office Suite, Waterfall, Mainframe, IBM Rational Suite

Confidential

Business Analyst

Responsibilities:

• Conducting user interviews, gathering requirements, analyzing and documenting requirements for process upgrades.
• Developed the test plan, test conditions and test cases to be used in testing based on business requirements and technical specifications.
• Led UAT with the Enumeration team to ensure functionality updates met user requirements.

Environment: CS Pro, IMPS, MS Office Suite, Waterfall

Confidential

Business Analyst

Responsibilities:

• Acted as a liaison between the IT Technical Team & the Line of Business by planning, conducting the analysis of complex business problems to be resolved by manual & automated systems.
• Produced business requirement document for upgrades to the Auto Title loan product as part of an existing buyout.
• Developed the test plan, test conditions and test cases to be used in testing based on business requirements and technical specifications.
• Led UAT with the Auto Title loan product team to ensure functionality updates met user requirements.

Environment: IBM Rational Suite, Office Suite, Waterfall

Confidential, Tempe, AZ

Business Analyst

Responsibilities:

• Created user stories, use case diagrams and wireframes to document business requirements for needed solution upgrades to the student portal.
• Developed the test plan, test conditions and test cases to be used in testing based on business requirements and technical specifications.
• Assisted with UAT with the director of financial aid and team to ensure functionality updates met user requirements.

Environment: Web Technologies, HTML, Office Suite, Waterfall