Ash C. Email & Phone Number

Overland Park, Ks, United States

Austin, Texas Area

Greater Chicago Area

Worked across multiple projects in Federal Employee Program Care Coordination Technical Infrastructure {FEP CCTI}♦ Data Retention and Archival ♦ Production Refresh♦ Support and Maintenance★ Responsibilities:☑Involved in complete SDLC which includes requirement gathering, architecture, design, document, planning, development, deployment & End to End testing in CCTI.☑ Gathered & analyzed the business & technical requirements. Created Functional Requirement Specification Documents across multiple projects.☑ Profiled data & Worked with the ETL (Abinitio) team to document the transformation rules for data migration from OLTP to Warehouse to marts for reporting purposes. ☑Created source to target documents with business rules after conducting Logical & Physical design reviews with SME's. Assisted Development team in creating Data Exchange Documents (DED) ☑ Analyzed existing Logical & Physical data models & altered them using Erwin model to support enhancements. Conducted walk through's with the DBA's & Architect's about the changes made. Reverse Engineered databases schema into Erwin Physical Data Model for re-usability.☑ Created tables in DB2, views, Partitions, sequence, Indexes, Constraints & generated SQL scripts for physical implementation.☑ Maintained & updated Metadata repository (MDH) based on the CR's. Uploaded XML's in MDH for respective changes in Erwin model & updated MDH sheets regarding new codes.☑ Developed S2T mapping documents to support ETL design.☑ Attended design, coding, test case & test results review walk-through meetings to provide inputs regarding adherence to technical standards & customer requirements.☑ Assisted QA, UAT & Development teams to mock up data to meet scenarios.☑ Maintained test cases, results and SQL's in HP ALM. Tracked defects in Clear Quest(CQ). Performed Root Cause & GAP analysis to fix the defects found during testing. ☑Conducted white boarding sessions to have concrete agreement with cross-functional teams.

Albany, New York Area

♦ State of New York Office of General Services (NYS OGS) division of Procurement Services is currently using multiple internally developed and maintained databases as well as spreadsheets to store much of the data for search on the OGS public website. The project is to give Procurement Services a comprehensive assessment of its current data storage and data management systems and business processes as well as recommendations for database★ Responsibilities:☑ Analyzed multiple databases, profiled data and investigated areas of overlap/duplication.☑ Assisted in creating Request for Proposal (RFP) and Project Charter.☑ Profiled data in SQL server and Created Excel Spreadsheets for all tables in different databases with Duplicates, In-consistences, Source, Usage and Linkage by Mapping Manually.☑ Created Current State of Procurement Services Database Structure Architecture Diagrams in Visio.☑ Interviewed SMEs, Contract portfolio management, Bid Opening team, Bid Posting team, Contractawarding team, Asst. Directors of Customer Service Team along with OGS Management.☑ Based on information obtained created Unified Modeling Language (UML) diagrams that will help shape the order and depth of deep dive discovery into the following Business Processes.☑ Discovered how a contract is awarded and how it is posted in State Wide Financing System (SFS) forpublic to view.☑ Analyzed contract awarding life cycle from Bid Posting to Award winning with what all the ContractAmendments and Vendor Responsibilities involved.☑ Identified Gaps in the Business process during JAD Sessions.☑ Documented roles of people and their portfolio’s for those who all are involved in the contract life cycle.☑ Organized SharePoint website for State OF NY OGS i.e. to be used as project data repository by the (OGS Team) and various Teams involved in the process.☑ Provided Final Recommendations Document for Future State Requirements and Options for Improvement.

Norfolk, Virginia Area

♦ Worked on the conversion of data from Ameri group Data Mart (AGPDM) to the newly established ER conversion of Anthem Inc. for Nevada state deliverable. This is because Ameri group was acquired by Anthem, so they need to transfer all the data to their existing data mart.★ Responsibilities:☑Involved in complete SDLC which includes requirement gathering, architecture, design, document, planning, development, deployment & End to End testing of ER conversion for Nevada Provider Network Files ( NV PNF)☑Gathered, Analyzed and Prepared documents for business requirements document (BRD).☑Conducted Gap Analysis, and Gathered User Requirements by Interviews, user meeting, JAD session, and Requirement Elicitation Sessions.☑ Interviewed Nevada state health plan people and Medicaid director of state to get the state specifications.☑ Interviewed SMEs and Stakeholders to get a better understanding of client business processes and gather Business requirements.☑ Created data Mapping document and crosswalk documents for the Nevada state specifications.☑ Assisted to develop the Test Plan, Test Cases and Test Scenarios to be used in testing based on Business Requirements, technical specifications and/or product knowledge.☑ Conducted regular walk through's, inspections of documents with stakeholders and documented training material for end users.☑ Analyzed FACETS application to extract data from AGPDM to Data Mart Provider tables (DM PROV) tables.☑ Profiled data in Microsoft SQL server and Created Error report with Rule matrix for inclusion and exclusion logics.☑ Created and designed SharePoint website for Nevada state i.e. to be used as data repository for project.☑ Logged defects in Jira that were found during testing, performed root cause analysis and assisted development team to fix code.☑ Created Requirement Traceability Matrix (RTM) to track End to End delivery during SDLC.

Master Of Science - Ms, Electrical, Electronics And Communications Engineering

Master'S Degree, Electrical, Electronics And Communications Engineering