Ramesh Golla

• Proven experience in design, construction, testing, and administration of Enterprise Data Warehouses, Data Marts and Data integration.
  

• Hands-on experience leading all stages of system development efforts, including requirements definition, design, architecture, testing, maintenance and support.
  

• Primary strengths include Data Warehousing and Decision Support Systems in a Unix/Windows environment using Informatica, Oracle PL/SQL, DB2 UDB, SQL Server, First Logic, Cognos and Dimensional Modeling.
  

• Experienced and effective in visualizing and implementing creative solutions to the most complex requirements.
  

• Experienced dealing with outsourced technical resources and coordinating global development efforts.
  

• Excellent communication skills, able to explain complex technical structures in an understandable user friendly format.

Platforms: UNIX (AIX, Solaris, HP-UX), Microsoft Windows�® operating systems, Linux (Red Hat), MVS - OS/390 & z/OS, OS2 Warp

Languages: Shell Scripting, C#, COBOL, JCL, AWK, PL/SQL, CICS, ADSO, HTML, Perl.

ETL: Informatica PowerCenter, SAS ETL Studio, Oracle Data Integrator (ODI)

Data Quality: First Logic Data Right IQ, ACE and Match Consolidate, Informatica Data Quality.

Data Modeling: Erwin, Visio

BI: SAS, Cognos Impromptu and Powerplay, SQL Server Reporting Services (SSRS).

RDBMS: Oracle versions 7.x to 10g, DB2 UDB 7.x to 9.x, MS SQL 200x

Tools: KnowledgeWare ADW, Developer 2000, Oracle Reports 6i, Toad, PVCS, CA-7, Appworx, Autosys, Hyperion Finanical Management (HFM), Microsoft Office System, Microsoft Project, and Microsoft FrontPage�®.

Clinical Grouper Software: Johns Hopkins Adjusted Clinical Groups (ACG) Case-Mix System, Episode Treatment Groups� (ETGs) and Centers for Medicare & Medicaid services (CMS) DRG Grouper

_Working at Duke Energy
Provide IT architect services for a series of projects involving a portfolio of financial applications by:

• Participating in the development and review of the conceptual architecture and high level design of major projects and system enhancements across the full range of the Finance IT portfolio, assuring conformance to IT standards and fulfillment of requirements
  

• Participating in the review of the detail design and construction for the above projects
  

• Resolving technical issues across projects
  

• Providing architecture review for proposed projects and enhancements to aid the governance process in decision making
  

• Participating in the development and maintenance of Finance's IT application architecture and data architecture information, providing conceptual models, strategies, and long term technical directions
  

• Providing representation for the Finance organization on various Enterprise level architecture-related working teams

Working at Florida Department of Law Enforcement through Keane Inc through Chronarch Inc

Responsible for:

• Coordination with Dept of Justice(DOJ) incorporating the National Information Exchange Model (NIEM) and Law Enforcement Information Sharing Program Exchange Specifications (LEXS).
  

• One of the first implement the Department Of Justice LEISP Exchange Specification Schema in Informatica with both Payload and Digest Portions.
  

• Coordinated with Informatica Professional Services and DOJ Architects in understanding working with Complex XML schema's
  

• Created mappings to write Images in XML files to Oracle Blobs.
  

• Installation of Informatica PowerCenter 8.1.3 and Informatica Data Quality 8.5 on Linux & Oracle Platform.
  

• Developing design standards, code conversion standards, address correction standards.
  

• Training and Mentoring Junior team members
  

Working on as needed basis at Salem Health Solutions Inc through Chronarch Inc

Responsible for:

• Automation of Employer Suite using Informatica, Windows Shell scripts, SAS and Argent Scheduler.
  

• De-Identification of Partner Health Plan data for future benchmarking purposes.
  

• Designed & developed MD indicators for SciHealth digital cockpit
  

Worked at National City Bank

Responsible for:

• ETL architecture and design of data integration from different sources - legacy, relational and 3rd party data for SearchSpace/Fortent Anti Money Laundering Suite.
  

• Coordination of Implementation and troubleshooting SearchSpace/Fortent Anti Money Laundering Suite.
  

• Innovative design for Change data capture of 20 Million Customer and 28 million Account every business day.
  

• Design and Development of automated script to download Politically Exposed person (PEP) from a secure website and feed to the data integration hub.
  

• Performance tunned the system to cut 8 hours of daily load time using unorthodox techniques like LOAD from Cursor, Non recoverable loads, Volatile Tables, Clustered tables and Partitioning
  

Subsidiary of Novant Health Inc

Responsible for:

• ETL design, development, administration, source to target mappings, data warehouse transformations, on call support, troubleshooting, testing, and documentation.
  

• Upgrading to Informatica 7.1.1 and installation and trouble shooting Infa production server, installation and integration of Firstlogic Ã?® Informatica 7.1 IQ Link.
  

• Design and development of a comprehensive data model with conformed dimensions for Industry specific codes like CPT-4, ICD9-CM, NDC, HCPCS, Discharge, Revenue and DRG.
  

• Installation and maintenance of Industry specific grouper software like ACG, ETG and CMS DRG grouper.
  

• DB2 DBA support as and when needed as part of Data Management Group.
  

• Design and development of many complex Informatica processes to support subject areas like Group Health Score Card, Cost and Utilization, Preventive Screening for Medicare population, Evidence based medicine Guidelines and many more CMS pilot measures.
  

• Data base and ETL design and development for Population health management for Partners National Health Plans of North Carolina, Inc - Subsidiary of Blue Cross Blue Shield North Carolina.
  

Worked at J&J Subsidiary - Ethicon Endo-Surgery, Inc through Sogeti

Responsible for:

• Changes to Informatica and PL/SQL code for removing Social Security numbers in HCI (Health Care Integrity) system for HIPAA Compliance.
  

• Informatica Lead for Enterprise One World Data Warehouse - for JD Edwards Enterprise One World.
  

• Participation in JAD sessions with users to understand the business logic based on their existing reports.
  

• Work with WebMethods, JD Edward's team to define a common data definition for the XML Canonicals.
  

Worked at GE Aircraft Engines

Responsible for:

• Onsite co-ordination between client (GE) and two offshore teams in Mumbai and Bangalore, India.
  

• Responsible for 24X7 support of critical GEAE systems like Cost Management System (CMS) Proposal Pricing Analysis and Tracking System (PPTS) and Supply Chain Finance Shop Cost Data Warehouse (SCDW).
  

• Participation in JAD sessions with users to understand the business requirements and develop specifications for ETL Maps, Data Model and Cognos Catalog.