SUMMARY:

• Accomplished professional with extensiveexperience in requirements gathering, data analysis and reporting in healthcare and insurance industries.
• Proficient in all phases of Software Development Life Cycle (SDLC), including design, development, and maintenance. Possess strong SQL
• ETL, and data warehousing skills related to data mining, capturing, mapping, modeling, documentation, and reporting. Proven leadership abilities at establishing and maintaining productive team environments.
• Positively Influence Team with Empathy / Accelerate Delivery / Satisfy Customers / Support Company Growth
• Project Management Sentiment Analysis Data Eng Mining Bus Analysis Enterprise Architecture Integration
• Process Methodologies:Agile, Rational Unified Process (RUP), Waterfall, Unified Modeling Language (UML), Extreme Programming, Scrum.
• Project Management / MS Project, Program International Student Assessment (PISA), Computer Aided Environment
• Office Tools and Databases:for Strategic Planning (SPACE), Microsoft Word, PowerPoint, OneNote, Access, & Outlook, Oracle, Microsoft SQL Server, JIRA, CMS.
• Reporting and Testing Tools: Rational Requisite Pro, Pentaho, Rapid Miner, Python, Tableau, Erwin, BI Objects, SysAid, FileZilla, Sharepoint, Data Warehouse, Use Case Model, Visio, Enterprise Architect (ERP), IBM SPSS, Modeler, MicroStrategy, Excel Reporting, Test Director.

PROFESSIONAL EXPERIENCE:

Confidential, Golden CO

Product Manager / Business Analyst / Service Delivery Manager

Responsibilities:

• Drove requirement gathering and migration of reports from Pentaho tool to Tableau and SSRS through integrating and systematizing teamwork, reducing downtime 20%.
• Owned ‘Clinical Review and Resolution (CRR)' item guide and the release configuration, managing project life cycle from start through conclusion. Provided instant updates of daily sprint meetings with internal team and weekly meetings with shareholders while creating and managing Change Requests (CR) for ongoing projects.
• Initiated and recorded requirements utilizing use case, user stories, and work process examinations. Supported business users with testing, preparing, and dispatching help, accelerating delivery speed 2 - fold increasing client satisfaction by administering and resolving customer issues.
• Tracked bugs and streamlined service quality delivery while collaborating with clinical review and resolution, account management, finance and operations teams; increasing employee workflow efficiency 10%.

Confidential, Louisville CO

Business Analyst

Responsibilities:

• Interacted and led cross-functional teams to coordinate training and QC efforts and translate business requirements into technical requirements. Created, modified and reviewed use case, activity diagrams, project plans, functional requirements, and test plans.
• Conducted data analysis, reporting, mining and consolidation, and writing SQL queries to assist utilities to increase energy efficiency. Integrated consumer invoice and geospatial data to assist energy and water conservation.
• Collaborated with marketing and IT to estimate and demonstrate the distribution of power consumption by multiple power utilities, governmental clients, and regional associations, enabling customer targeting, financial analysis and management and improving profits.
• Collaborated with ICF subject matter experts to gather and analyze business and system necessities, then identify and documented data sources. Teamed up with eligible residential and commercial customers for timely verification of rebates, progressing energy efficiency in the United States.

Confidential, Columbia SC

Business / Technical Analyst

Responsibilities:

• Facilitated Joint Application Design (JAD) sessions to collect requirements from system users concerning 2nd level issues for CMS weekly deliverable meetings, provided an appropriate scope of work for the technical team and documented requirements using Requirement Traceability Matrix (RTM).
• Extracted and interpreted data using SQL, from Automatic Call Distribution (ACD) and Remedy Systems, and performed data mapping between different data sources and User Interface (UI) for migration. Developed Star / Snow Flake Schemas, FACT / Dimensions Tables, and Physical / Logical Data Modeling.
• Worked closely with UI to model MAPD screens, which met user-defined requirements and organizational and regulatory standards; created mock-ups of client facing web portal screens.
• Point person for technical escalation and served as subject matter expert (SME) for all teams on CSM project; performed a GAP analysis to identify areas for training and improvement.

Confidential, Bloomington IL

Business / Systems Analyst

Responsibilities:

• Developed use case model, defined workflow and features of an by I Want This application, detailed and delivered it to project development team. Made signature cost and time effective, reducing manual processing, errors and rework and increasing reliability with auto notification.
• Performed data analysis for OLTP, OLAP and BI applications while developing Data Warehouse and Data Mart. Created Business Data Elements, Role Authorization Model, Event and business scenario list and source to target mapping; used Erwin and ER studio in numerous schemes.
• Analyzed and optimized SQL queries for complex reports, working with testing and development teams discussing all defects, cosmetic issues, and UAT decisions.

Confidential, Waltham MA

Business / Data Analyst

Responsibilities:

• Gathered and analyzed data and created Schemas to meet reporting requirements; created metrics, filters, and prompts, enabling decision-makers to generate customized reports.
• Conducted requirement analysis to collect various business measures and attributes to develop Star Schema and required facts and attributes, using SQL.
• Coordinated with micro-strategy architect to build hierarchies, attributes, facts, and relationships between various attributes and developed logical models for reporting environment.
• Analyzed data integrity for warehouse system and reporting tool to determine discrepancies from ETL tools, ensuring availability of data required for reporting.