SUMMARY

• Strong experience in assisting program management and project teams, manage Scope, collaborate with functional teams, adapt to Change, manage product backlog for planned releases.
• Strong experience in design and document Report templates, execute ad - hoc reports, clean and maintain frequent updates to reports modules based on business need.
• Expert in Agile solution delivery, build trust and team collaboration, facilitate Agile ceremonies, identify and promote engineering efforts to delivery tracks in SAFe by Value Proposition.
• An innovative team player possessing excellent interpersonal, communication, team motivating, people management skills with demonstrable analytical and problem-solving abilities, proficient in meeting deliverables and excel under high pressure.
• Proficient in design, development and implementation of technology-enabled business solutions, possess domain specific knowledge in the design and implementation of APIs and platform services.
• Excellent in collaborating with clients, self-organized, demonstrated ability to facilitate discussions and have a strong desire to influence and meet commitments to lead and excel in project deliverables.
• Proficient in defining Data specification, Integration points and create Data Modeling, Data Mapping and Data Migration documents in support of Legacy migration and re-design of server environments.
• Knowledge in SQL, able to write simple queries to validate ETL completed data, possess demonstrated experience in Data Visualization using Advanced Excel and Tableau and generate Dashboard reports for project and application use.
• Excellent in UML Modeling, design of Use Cases, Flowcharts, Business Process Models and Workflow diagrams and experience with presentation, initiator for conducting sessions across multi-functional and inter-dependent departments.
• Strong verbal/written communication and interpersonal skills and a team-player.

AREAS OF EXPERTISE:

• Product Development Process Management UML Modeling
• Agile Project Delivery JIRA & CA Rally Enterprise Reporting - SSRS
• Change Management Data Mapping UAT
• Web Technologies SQL and Advanced Excel Enterprise Reporting

PROFESSIONAL EXPERIENCE

Confidential, TX

Business Analyst

Responsibilities:

• Gathered technical requirements by coordinating with IS team and translating them to system requirements, reviewed change with Product Owner and stakeholders.
• Conducted detailed GAP analysis (As-is and To-be state), Root-Cause Analysis, Impact analysis, Risk analysis in data acquisition and transformation efforts done in Customer Integration platform.
• Created Source to target mapping, BRDs, FSDs, DRDs, Testing Documents for MRP, CNA, AIMS and data integration to EDW, worked with Data Integration team for SQL data extract.
• Created ETL documents that includes data types, data definitions, business/transformation rule based on the requirements or formatting needs of the data from both source and target using MS Office.
• Reviewing designs and documentations that develops logical and physical data models to support Data marts and Data Warehouse using MS Office, MS Visio, Ab Initio, Adobe Reader, and SharePoint.
• Extensively executing SQL queries to analyze the data in the System of Record (SOR) to judge the requirements and impact of implementing those requirements.
• Analyzed system of records by performing sanity checks on acquired data by CI. In addition, analyzed data to check the impact of changing system time zone of C2T database on the applications acquired by CI, and provided solutions for data integration.
• Developed complex SQL queries in both SQL Server and Teradata platforms in order to test data for comparative analysis and to ensure data quality is maintained by resolving the identified data anomalies.
• Managed SharePoint site for document share, document template, document reviews and signoffs and setup calendar invite for Change Control meetings, reported and documented issues.
• Assisted in creating Dataflow, Workflow, Process flow and Entity Relationship diagrams in MS Visio.
• Involved in project cycle plan for the source XML data extraction process, data analysis, transformation and ETL loading strategy designing.
• Managed Agile board in JIRA for New Ventures portfolio, Information Systems for Merchandise Operations, performed daily reporting to senior management on track progress, led scrum of scrums within tracks, resolved impediments, discussed and promoted opportunities for team development.
• Worked with project management on delivery of service enhancements in Data Services Layer, created and reviewed web service operations, created XSD rules for XML data and used SOAP UI for XML data validation.
• Coordinated with QA and ETL teams, conducted ETL regression and ETL Completeness testing, used SQL to describe tables and conduct metadata testing, documented functional requirements and E-R diagrams for
• Coordinated with project management, lead and managed Scrum Team for Agile Solution Delivery and MDM implementation, managed team project and deliverables in Atlassian JIRA.
• Created an Event Publish Service to publish the data near to real time even being a batch process.
• Chaired various meetings, trained testers of another team on various data transformation documents.
• Performing sophisticated QA testing including SIT and UAT, executing complex SQL queries involving joins, aggregate functions, date functions, cast, coalesce, case, trim, extract, scalar functions, wildcards and string functions amongst others. Maintained strong documentation, gathered approvals using MS Outlook and upload it to SharePoint.
• Assumed ownership and accountability for the assigned deliverables through all the phases of SDLC

Confidential, Denver, CO

Business Analyst

Responsibilities:

• Responsible for migration of project artifacts to Sharepoint2012 - System Requirements Specification (SRS) document, Business Requirements (BRD), XML and XSD data mappings for TPS systems.
• Possess great knowledge in Transaction Processing Systems - TPS for data management services and support of data through web services to consuming applications like Crew Management and POS.
• Worked with Frontier’s Ancillary Development and Revenue Analysis (ADRA) for requirements to Frontier’s ancillary product offerings, documented business cases and Use Case for system workflows.
• Participated in Technical Review Board (TRB) sessions on weekly basis, reviewed design documents and system requirements with teams, understand Risk, issues and documented mitigation plan.
• Created Epics and Themes in JIRA, added Labels - Component Tags - story card Priority - Dependencies - Attachments and required information to story documents for visibility to delivery teams.
• Prepared User Story documentation in JIRA for software requirements and development for migration.
• Reviewed TPS and web services architecture, integration components, data points, target databases.
• Constantly groomed product backlog, received estimates from developers and QA on story sizing, details, tasks for development and delivery and documented Acceptance Criteria.
• Worked with Release engineering teams to coordinate web services code migration to higher environments and coordinated test efforts with offshore QA on regression testing services functionality.
• Performed GAP Analysis to As-Is Vs To-Be state and Impact Analysis to analyze system impact from platform migration and improved architecture, provided documentation for rebuild of Audit services.
• Demonstrated system design documentation in UML models, provided flowcharts, Use Case Diagrams, Sequence diagrams, Activity and State diagrams using MS Visio.
• Created Requirements Traceability matrix using Confluence and integration with JIRA, created JIRA Dashboards to demonstrate project tracking, customer reports, status reports, iteration burndown, etc.
• Coordinated Business Acceptance Testing (BAT) efforts, worked with release engineering teams on defect fix and code migration to higher environments, re-testing defect corrections and approvals.
• Provided sign-off for web services code complete, test validation and complete, defect status and decision on code delivery to non-PROD environments from priority and release readiness.
• Coordinated migration efforts, documentation, requirements and dependencies with integration teams, worked with integration analysts and data analysts to identify and correct issues from dependencies.

Environment: Oracle, Quality Center, TPS, MS Visio, Office 365, Atlassian JIRA, CAS, BAT (Business Acceptance Testing), CAMP.

Confidential, Los Angeles, CA

Confidential

Responsibilities:

• Conducted requirements review for MPS platform, worked with business team, stakeholders, 3rd party vendors for MPS integration and platform services integration to media channels, media streaming and source-to-target mapping.
• Used Jira to plan, create Epics and User Stories, prioritize and itemize user stories into Sprints for development and iterative testing, coordinated with offsite teams on requirements management and reviews.
• Monitored network traffic on Splunk and to capture API calls made on various NBC applications using URLs and validated the functionality of Ads publish, resource path, media site, data streaming duration and synchronization options.
• Conducted extensive Data Analysis using Advanced Excel and SQL and created Power Query, Power Pivot and Power Charts for data analysis.
• Conducted database validation, coordinated with DB teams in the development of enhancements, table changes, deployment scripts, design, Query Tuning, Procedures, Triggers and Views.
• Created Business and System Requirements for the implementation of web service APIs that are required for Benefits Inquiry, Quality Reporting and Additional Data services.
• Created data transformation rules in FSD for data discovery and remediation techniques to meet enterprise Data Quality, iterative measures for improving the quality of data and integration to Enterprise Data Lake.
• Wrote SQL queries for data analysis, validated service operations and API validation, provide forecast on increasing data volumes that increases workload complexity.
• Created Epics and Issues in Atlassian JIRA, documented work efforts, work estimates, story sizing and acceptance criteria for API consumption by front-end applications.
• Thoroughly reviewed application setup and configuration, coordinated release sign-off, resolved issues and facilitated Agile ceremonies by coordination.
• Experience in system analysis, metadata management, troubleshooting to review data loss, data inconsistencies and documenting RCA - root cause analysis for systematic procedures in problem identification through technical expertise.
• Managing complex software development and integration projects in a fast paced, constantly changing Agile Environment.
• Reported, tracked, reviewed, analyzed and compared the defects using HP ALM/Quality Center.
• Gathered business requirements and maintained product documentation for EDW enhancements, data acquisition changes by implementing micro-services and designed enterprise Data Lake.
• Created User Stories to support Continuous Delivery Pipelines by Continuous Exploration, Continuous Integration, Continuous Deployment and Release in Demand to support Agile implementation.
• Created workflows and business rules for data inject and data streaming into enterprise Data Lake by batch processing, created supply-demand model for reports and analytics interfaces.
• Responsible for Document Management, used SharePoint and integration to Office365 and organized project and program documents from BRDs, FSD and Change Control implementation.
• Coordinated efforts in data migration and data conversion from legacy to Oracle platform, documented data mapping and data profiling requirements, data transformation requirements for ETL and data integration.