SUMMARY:

• Over 15 years’ experience as a business systems analyst, with production of highly effective requirements documentation - -BRD’s, using interviews with management and SME's to distill strategic priorities and key performance indicators, business processes and objectives, leading to detailed project and development plans using Agile/Scrum methodologies.
• Using data analytics skills prepared and analyzed ETL data extractions and visualizations to identify and recommend high impact strategies to gain cost reductions and efficiencies in workflow, business processes, data collection and data migration.
• Microsoft Certificate of Achievement in Querying Microsoft SQL Server awarded in February 2016, refresher course completed in April 2017
• Ability to lead and problem solve in a time sensitive environment.

TECHNICAL SKILLS:

SQL: T-SQL with SSIS, SSRS and SSAS, MS Project, Microsoft Excel, Access, Word, PowerPoint, Visio, Crystal Reports, Tableau, SDLC with Agile - Scrum and Waterfall methodologies, Salesforce, Project Management, .NET, Rational and UML

PROFESSIONAL EXPERIENCE:

Confidential, Santa Clara, CA

Senior Business Systems Analyst

RESPONSIBILITIES:

• Responsible for facilitation of discovery, gathering requirements and preparing accurate business specifications and documentation
• Act as a liaison between business units and technology teams, stakeholders, program management, and project delivery teams.
• Develop complex SQL queries to identify the performance bottle necks in the processing.
• Profound understanding of Campaign management experience.
• Extensive knowledge on Python Scripting
• Working with Business analyst to develop productive models and advance SQL statements
• Extracting data from various sources across the organization (MySQL, SQL Server and Flat files) and loading into staging area.
• Experienced in Analyzing Data and creating visualizations.
• Tuned Teradata Sql queries and resolved performance issues due to Data Skew and Spool space issues.
• Acts as workstation subject matter expert and works directly with the Product Management team to develop and deliver best practices and ensure compliance with Equator standards of practice
• Proactively communicate and collaborate with external and internal customers to analyze information needs and functional requirements.
• Obtain requirements through discovery, document analysis, business process descriptions and use cases while researching scenarios, tasks and workflow.
• Owned the design, development and maintenance of ongoing metrics, reports, analyses, dashboards, etc., to drive key business decisions and communicate key concepts to readers.
• Led the complete lifecycle of visual analytical applications, from development of mock ups and storyboards to the complete production-ready application.
• Interfaced with data miners and analysts to extract, transform and load data from a wide variety of data sources using SQL and Ruby.
• Fine-tuned and improved query performance using profiling tools and SQL.
• Built database cubes and design star schemas using ER/Studio and Visio.
• Push creative thinking beyond the boundaries of existing industry practices and client mindsets by asking thought provoking and clarifying questions
• Evaluate and reconcile information gathered from multiple sources; distinguish user requests from true underlying needs; create quality requirements documentation.
• Understand the necessity of project standards and apply them consistently. Promote best practice application.
• Prepare professional business correspondence that is coherent, grammatically correct, effective and engaging.
• Collaborate with developers and subject matter experts to establish the technical vision of client; analyze tradeoffs between usability and performance needs.
• Designed business analysis work products - BRD's with data analytics report requirements, and non-functional requirements documents.

Confidential, Tracy, CA

Senior Business Systems Analyst

RESPONSIBILITIES:

• Provided consultative support to business units and IT development teams, facilitating meetings with high level users.
• Conducted and designed business analysis, high level design, and technical design documentation.
• Created project plans and maintained schedules/backlogs with the scrum master.
• Pre-flight created user stories to assist in development cycle, validation of data and problem resolution post flight.
• Created and executed automated software test plans, cases and scripts to uncover, identify and document software problems and their causes
• Developed Process Flow Diagram/Activity Diagrams, Test Cases and performed functionality testing
• Producing test reports and test metrics to ensure that all the requirements are met and the applications works as expected
• Develop several reports over a Tera Byte data source including the following:
• Complex T-SQL querying to extract data from a normalized database as per client specifications
• Import data to Data Warehouse using SSIS
• Report Creation using SSRS
• Designing and implementing ETL processes to populate a Data Warehouse (SQL Server 2014) from different sources
• Develop different data entry forms using PowerBuilder
• Perform quality assurance to several reports using SQL Server 2014.
• Follow project requirements using Microsoft Team Foundation.

Confidential, San Francisco, CA

Senior Business Systems Analyst

RESPONSIBILITIES:

• Facilitated powerful insightful strategic meetings and interviews, for elicitation, documentation, UML visualization and data models to purposely develop key performance metrics, user system requirements and user stories.
• Designed, planned and conducted user acceptance testing within a tight period.
• Trained organization staff on the accepted tools and provided on-going consultation for management and staff.
• Prepare Enrollment Summary Reports (Enrollment & Disenrollment)
• Daily NPS Member eligibility updates, PDE error reports, FIR Transaction Process, Daily NPS Critical Errors
• PCP membership mass moves, PCP assignments, corrections, monthly capitation reconciliation using TriZetto
• Generation of initial OTC cards for Medicare & Medicaid members, and ID cards reconciliation
• Engages in those activities required to obtain, monitor and maintain accurate and current membership information monitoring the Transaction Reply Reports and sending out the necessary member letters
• Performs enrollment calls to members to validate enrollment information and any required follow-up
• Performs mail and letter merges for post enrollment fulfillment purposes
• Prepares documentation and assist in audits related to enrollment activities
• Manage mail tracking logs/Department workflows and spreadsheets
• Updates policies and procedures according to CMS guidelines
• Work in a team or independently to bring assignments to a timely successful conclusion

Confidential, Los Angeles, CA

Business Systems Analyst

RESPONSIBILITIES:

• Exercising independent judgment, coordinate and handle all aspects of the organization’s databases, compliance and data products, creating and generating reports, integrating multiple data sources.
• Using analytical skillset and tools provided an objective qualitative software evaluation leading to an accepted recommendation of an industry leading ERP software solution to improve the data collection, performance management and contractual compliance of the entire organization.
• Member of the management team and as an SME (subject matter expert) providing guidance, knowledge in compliance regulations, project management as well as training to staff, vendors and funding entities on long and short-term programs, projects and initiatives.
• Developed and implemented data collection tools and data migration plans for the organization using Excel, Visio and a MS SharePoint like data-sharing application.

Confidential, Jacksonville, FL

Senior Business Systems Analyst

RESPONSIBILITIES:

• Developed recommendations to resolve problems and issues related to business operations by redesign of process workflow, resulting in streamlining of trouble ticket entry, disbursement and tracking.
• Utilized SQL to extract and organize high-value datasets for transformation to front-end client dashboards.
• Leveraging experience in data relationships and dependencies used the existing data warehouse and data dictionaries to extend depth and interpretations of data sets in property values and insurance.

Confidential, New York City, NY

Sales/Business Analyst

RESPONSIBILITIES:

• Customer acquisition, lead generation and direct-to-consumer marketing in the support of the agent and agency goals.
• Designed databases of client information in Access and Excel and using application-imbedded tools to transform datasets to facilitate email campaigns bringing qualified sales leads to sales team for client acquisition.
• Worked with sales on proprietary quote tools to provide insight and problem resolutions for client presentations.
• Trained agents on system tools, developing documentation and training aids for this purpose.

Confidential, Irvine, CA

Senior Business Systems Analyst

RESPONSIBILITIES:

• Interviewed SME's representing the largest mortgage issuers in the country to gather the business requirements with a quick understanding of complex and sensitive operational needs.
• Crafted system design and technical requirements for major claims system conversions and implementation of web front-ends using Faster, a proprietary SDLC methodology.
• Out-of-the box thinking to provide insightful research and analysis of processes and workflow with documentation in Visio.
• Received training and developed experience in project management using MS Project.

Confidential, CA

Sr. Business Systems Analyst/Engagement Manager

RESPONSIBILITIES:

• Provided Business Intelligence and analytical insights to user behavior to enable market targeting and strategic influence points for Fortune 200 clients, utilizing data mining, and OLAP and ETL methodologies.
• Responsible for client facing engagements with an analysis of their business and requirements, making translations, analyzing risks and in corporation of those needs into the documentation of the design roadmap.