Rama Krishna Arvind Kothakonda Clearance: Public Trust Level 5

MS in Information Systems

ITIL – V3, ICP Agile Certified

Email: adgozi@r.postjobfree.com

630-***-**** cell

EXPERIENCE SUMMARY

Mr. Rama Krishna Arvind Kothakonda with over 15 years of experience as a Sr Data Modeler and Data Architect, Business and Systems Analyst, Technical Lead. Experience includes Data Modeling, Data Architecture, Data Management, API Security Standards Framework, Capabilities Assessments, Data Operations at Center of Medicare and Medicaid Services (CMS) and Department of Health and Human Services (HHS), Office of Inspector General (OIG), delivering Enterprise Resource Planning-Sales and Distribution (ERP-SD), managing Client-Server and Middleware solutions at Oil & Gas (Downstream) and Retail businesses. He is skilled in managing various size projects/programs and staff. Extensive background in mapping the AS-IS and TO-BE business processes and converting the requirements to technical specifications and developing test plans.

CORE COMPETENCIES

Data Modeling, Data Architecture, Project discovery, Cost Benefit Analysis, Full Software Development Life Cycle in agile environment including Test Management, Risk Management, Change Management and Release management plus Research and Investigation and Business Case Development, Business Architecture, Enterprise Architecture.

CERTIFICATIONS

ICP - ICAgile Certified Professional

ICAgile

2017

ITIL-V3 Foundation

IT Services Management

2012

TRAININGS

PMP-Project Management Professional

Project Management Institute

2018

AWS Solutions Architect - Associate

Amazon Web Services

2018

SUMMARY OF SKILLS, TOOLS, AND TECHNOLOGIES:

Business Modeling: Canonical Data Modeling, Logical & Physical Modeling, Rational Rose, MS Visio, Erwin

Configuration Tools: Magic Draw, Rational Rose

UML Modeling Tool: XML Spy, Eclipse

Project Management: Microsoft Project Plan, Microsoft PowerPoint

Methodologies: Waterfall, RAD, RUP, Agile, Business Modeling

Quality/Security Management: SOX and ConTesA

RDBMS: Oracle, MS Access, and SQL Server, Opera, PostGreSQL

Operating Systems: UNIX, Windows XP-10, Windows server 2003

ECM: CALT, SVN, Microsoft SharePoint, JIRA, Remedy

Others: ERP-SD, Remoteware 4.3, PL/SQL, NIEM, FISMA, FIPS 199, API Security Standards, NIST/CMS Risk Management Framework

EXPERIENCE DETAILS

Oron Inc., Data Architest/Lead Data Modeler @CMS & CGI Federal– DC Metro 10/2019 – Present

Analyze the functional and non-functional business requirements and translate into technical data requirements and create or update logical and physical data models.

Create data models (conceptual and logical) and database designs (physical), using approved Enterprise Data Modeling tool utilizing reverse and forward engineering, that depicts business areas and systems in the technical environment to ensure the integrity of the business data is being maintained.

Ensure adhere to technical database design standards in accordance with the approved enterprise data modeling and database design standards.

Review DB design with the development teams, and generate initial Data Definition Language (DDL), as needed.

Booz Allen Hamilton, Inc., Lead Technologist @CMS & HHS OIG – DC Metro 03/2013 – 10/2019

Projects –

HHS OIG Data Technology Services – Technical Lead/Sr Data Architect

Identification of business capability needs for the Integrated Data Platform (IDP) hosted on AWS cloud as part of the modernization project.

Determine I.T infrastructure and compatibilities for various products on IDP and to ensure they meet the business user’s needs and be part of the overall Data Service Architecture.

Conduct market research to identify technologies which enables the business needs and technology requirements such as AWS platform, enterprise architecture, deployment and security.

Provided recommendations on product assessments and reviewed them with appropriate HHS OIG personnel to ensure the methodology meets standards for product inclusion in the IDP.

Shortlisted tools like Data Governance (5 to 2), Text Analytics (48 to 3) and Data Prep (5 to 2) capabilities and facilitated demos, conducted Proof of Concepts (POC) and user evaluations within stipulated time to meet financial year goals.

Make sure the tools meet various technical requirements as on-premise installation on AWS cloud, automated scalability & high Availability, support SAML authentication and attribute-based authorization etc.

Collaborated with HHS OIG in its effort to increase HHS OIG personnel’s access to data, in accordance with appropriate data protection laws and policies.

Provided data integration expertise, expanding to new OIG internal and external data sources.

Work with product owners to prioritize data set integration into the data lake and from the data lake into the data warehouse.

Conceptualize IDP ‘workspaces’ that allow for further data exploration and the upload of external datasets related to analyst fieldwork to combine them with data from the lake or warehouse for analysis.

Followed best practices in product and project development leveraging agile practices. Participate in team planning/scrum meetings, product/project backlog(s), user stories developments and documentation.

Marketplace Systems Integrator (MSI) CMS CTO Architecture Support Project – Data Architect/ Business Systems Analyst

Developed the CMS API Security Standards Framework by using NIST/CMS Risk Management Framework and applying FISMA and FIPS 199 rules to increase the security architecture of CMS data exchange for Marketplace.

Contributed towards advancement and integration of CMS marketplace architecture through modern architecture design patterns and principles that capture the needs of diverse groups of CMS stakeholder.

Worked with business owners and system developers and identified that they were using ad hoc approach for establishing internal or external facing APIs.

Performed in-depth research on various best practices applied towards API Security standards in conjunction with sensitivity of the data to make sure all critical aspects of data security are covered based on the ever-changing digital landscape.

Conducted brainstorming sessions and interviews with over 12 internal implementation partners and development teams to understand the API framework feasibility and improve its design.

Provided client with progress updates and guidance based on strategic need during weekly meetings.

MSI- Pre-Audit & Issuer Reconciliation Project – Data Architect/ Business Systems Analyst

Conducted and improved the Pre-Audit and Reconciliation of enrollment data for Marketplace by introducing automation and processing efficiencies.

Facilitated communications between Marketplace, Issuers (insurance companies) and IT systems involved in Reconciliation and Pre-Audit process while ensuring that the monthly operational cycles are executed as planned.

Facilitated weekly webinars with about 400 issuers plus internal and external stakeholders to communicate policy updates, data issues, track issues, educate.

Analyzed and troubleshooted the data issues encountered in the files submitted by the issuers and advised issuers with corrective actions.

Performed data analytics using SQL and prepared statistics with comparison to the Marketplace data. Published the statistics and comparison results to respective individual issuers to guide them through the findings and suggest corrective measure to improve the file submission match rates for next cycle.

Acted as the liaison between issuers and various stakeholders in coordinating testing efforts for various enhancements and implementations.

Canonical Data Modelling (CMS/CCIIO/Marketplace)– Data Architect

Performed Canonical data modelling (CDM) using NIEM standards and NDR to enhance the data design and architecture for Marketplace (CMS/CCIIO).

Developed application models using the CMS Canonical Data Model (CDM) to ensure applications are National Information Exchange Model (NIEM) informed and adhered to NIEM NDR standards.

As part of the Canonical Data Modelling project created the requirements breakdown for every sprint and identified data elements required by each service and implement the data models in stipulated time.

Developed Information Exchange Package Documentation (IEPD’s) for various Data Services Hub (DSH) service like IRS Monthly and Yearly Reporting, SSA Composite, Non ESI MEC, Verify Agents – Brokers Licensing, 834 Transactions, Verify Lawful Presence, Group Enrollment and Account Transfer using MagicDraw with NIEM plugin.

Maintained Healthcare Reference Models and created subset, extension, exchange and constraint schemas as part of CDM.

Aligned application data elements for Data Services Hub (DSH) and Federally Facilitated Exchange (FFE) with the Canonical Data Model (CDM).

The data models were bug free, allowing the development teams to focus on fixing application bugs and not creating additional bugs or becoming the bottleneck.

EPath USA, Data Architect/ B.A. @ CMS/CCIIO – Bethesda, MD 7/ 2012 – 3/2013

As a Data Architect developed application models using the Centers for Medicare and Medicaid Services (CMS) Canonical Data Model (CDM) to ensure applications are National Information Exchange Model (NIEM) informed and adhere to NIEM NDR standards.

Performed various market studies and identified tools which were instrumental in the project success.

Trained on the tool to meet the project requirements then trained other implementation partners.

Wipro Technologies, Project Manager/Business and System Analyst @BP - Naperville, IL 11/2009 – 7/2012

Managed delivery of the project as per the Capital Values Process (CVP) processes and ensured timely delivery of Project within scope, Budget, Control and Quality Assurance.

Conducted weekly review meetings with the development teams to track the project schedule.

Captured the scope, efforts, budget and detailed project plan (MPP) for implementing Vitria and LID interface changes required to handle the (Terminal Automation System) TMS6 data structure.

Managed team in developing a technical solution in the development environment and migrate them to production applying configuration management processes.

Managed/ monitored tests and identified all associated risks in test processes and ensured its compliance with all company standards and policies.

Coordinated with individual development teams and implemented System Integration Tests on processes.

As an Application Analyst modified and maintained oracle procedures using SQL while performing application support for SMART application.

As a Technical Manager/ Architect designed and optimized Remoteware System - an SAP product used by BP for transmission of data between BP stores, BP Headquarters and third-party external Vendors/Interfaces like Informatica, SAP, S2K and Pricing Applications - for managing the daily workflow processes and applications in a distributed environment.

Created the infrastructure designs, application process flows, data transfer frequencies, method of transfers, server configuration requirements documentation and provided the same to client architecture team.

The new infrastructure design reduced the number of physical servers required for hosting the production application from 10 to 3 (1 physical and 2 VMware slices) and for hosting DR environment from 5 to 2 (1 physical and 1 VM ware), thereby reducing the cost of maintenance by $260,000/year.

Mahindra Satyam, Business/Technical Analyst - Naperville, IL/UK/ India 5/2004 – 11/2009

As a Technical Analyst gathered technical and business requirements and developed new interfaces for SAP migration project to transition the business process from cross-border to third-party association.

Conducted workshops with business users to understand their requirements and organized various brainstorming session with the SAP implementation team to make sure all the business requirements are met.

Gained domain expertise of ISP Sales (ISPS) and distributions and good knowledge of bespoke` s and interfaces from other modules like ISI-MI, ISP-Accounting and ISP-Operations (RFS, Scheduling).

Conducted Gap Analysis (GAP), Functional testing, User Acceptance Testing (UAT), and System Integration testing (SIT).

Provided 2nd level applications and technical support for global implementations of BP's ISP applications in line with agreed SLA on both production and test databases.

Monitored tickets, performed root cause analysis of recurring issues and resolved tickets within the defined SLAs.

Documented Functional Requirement Specifications (FRS) and User Requirement Specification (URS).

Created high and low-level Use Cases, Activity and State Chart Diagrams using Rational Rose in accordance to UML methodology for defining the Data Process Models.

Education

Master’s in information systems (MSC, IS) from Osmania University, A.P, India -2003

Bachelor’s in computer applications (BCA) from Osmania University, A.P, India – 2001

Contact this candidate