Arun Kumar Reddy Gangidi

***** *********** **, ****** ****, AR 72212 • United States

Cell 501-***-**** • ad18me@r.postjobfree.com

Highlights of Qualifications

MBA graduate complementing 18+ years of experience in information technology with a focus on Infrastructure Design, Database Administration and Team management. Currently, I am working at UnitedHealth Group Inc., a fortune 500 ranked 6th firm, as a Technical Architect. As a multi-skilled technical architect, I have comprehensive experience of designing, developing, and deploying architectures and infrastructure for software applications. My Architectural Experience includes knowledge on Tableau, Cognos Business Intelligence, Cognos Analytics, Informatica Power Center, BMC footprints, Siteminder, PingFederate, Oracle Internet Directory, Oracle Single Sign on, Oracle Portal, Oracle Business Warehouse builder, Oracle forms and Reports and Oracle Application server versions (11g and 10g). In addition to that, I am working on cloud migration project to Microsoft Azure and Snowflake DB.

Education & Certifications

•Master of Business Administration (MBA).

SAM M. WALTON College of Business, University of Arkansas, USA

•Bachelor in computer science (B. Tech).

National Institute of Technology, Allahabad, INDIA

•Project Management Professional (PMP)

•Exadata database machine- 12c Administration Workshop

•Oracle Certified Associate

•IBM Cognos 10 BI Administrator

•Oracle Application server 10g

•Oracle BI Publisher

•Oracle Data warehouse builder

•Microsoft SQL Server 2008, Database Development certification

•ERP Certification with SAP ERP Central Component 6.0, BI Reporting and SAP portals

•Snowflake

Technical Skills

•Strong knowledge to apply specific core expertise in implementing and migrating to Snowflake. Through understanding of Snowflake as a Data Cloud and how Snowflake can be used to drive business objectives.

Knowledge on

oScale Virtual Warehouses for Performance and Concurrency

oUtilize Data Sharing

oQuery Constructs and DDL & DML Operations

oManage and Monitor Snowflake Accounts

oWork with Semi-Structured Data

oUtilize Snowflake's method for Continuous Data Protection

•Experience on server virtualization, transforming application deployment and management to reduce the total cost of ownership (TCO), increasing IT flexibility, consolidating systems to reduce capital expenditures (CAPEX) and achieving greater business agility. Experience includes Oracle Server Virtualization using Oracle VM Server for x86 and working with Oracle VM Templates and Oracle Virtual Assembly Builder for creating assemblies and collections of VMs.

•Has thorough knowledge of infrastructure, application programming, and web and software applications. Designed and Implemented information systems which will adequately support the enterprise infrastructure of the organization.

•Expertise in solving security challenges such as Data Tampering, Falsifying User Identities, Password-Related Threats, Eavesdropping and Data Theft by designing security in Enterprise Grid Computing Environments with Oracle Net and Oracle Advanced Security.

•Extensive knowledge on Information Security and Privacy. Comprehensive knowledge on policy guidance, standards, regulations, laws, and other documentation related to the CMS Information Security and Privacy Programs.

•Expertise in configuring and maintaining appliances such as Oracle Exadata, Oracle database appliance

•Expertise in using the built-in features such as Real Application Clusters (RAC), Data Guard, Automatic Storage Management (ASM), Flashback, Recovery Manager (RMAN), Online Reorganization etc. of the Oracle Database.

•Expertise in doing advanced configuration on Oracle Middleware components such as WebLogic server, Forms & Reports Services, Oracle Portal Administration, Oracle Wireless Administration, Oracle Single Signon, and Oracle Internet Directory.

•Experience in tuning large databases using Oracle built in advisors such as ADDM, Automatic Undo Management, Memory Advisors, MTTR Advisor, Segment Advisor, SQL Advisors and SQL Performance Analyzer and working with ASH, AWR Reports, Compare Periods reports etc.

•Extensive knowledge on Oracle internals such as enqueues, latches, bind variables etc. and Strong understanding about Wait Events Statistics, SQL Statistics, Instance Activity Statistics, IO Stats, Buffer Pool Statistics, Advisory Statistics, Wait Statistics, Undo Statistics, Latch Statistics, Segment Statistics, Dictionary Cache Statistics, Library Cache Statistics and Memory Statistics.

•Excellent backend skills in creating developing and benching marking the PL/SQL objects such as procedures, packages, functions etc and T-SQL objects such as procedures etc.

•Experience in Data Modeling (Logical and Physical Design of Databases) on tools such as Microsoft Visio, Erwin data modeler etc. Ability to create plugins to automate the modifications into design documents etc.

Professional Experience

United Health group, Inc. March/2014 - present

www.unitedhealthgroup.com

UnitedHealth Group is the most diversified health care company in the United States. OptumInsight, a subsidiary of UnitedHealth Group, provides software and information products, advisory consulting services and business process outsourcing to participants in the health care industry.

Optum Government solutions implements projects across various states with scope that includes delivery and support services for the Medicaid Enterprise Data Warehouse consisting of Decision Support System (DSS), FADS, MARS and SURS and Program Integrity capabilities.

Role: Technical Architect / IT systems Manager - Little Rock, AR, USA

Client –I handled below responsibilities across various projects under Optum Government solutions. Demonstrated mastery in evaluating and delivering agreed upon solutions of the highest quality contributing towards our shared vision.

Arkansas (Phase I) operations support.

Arkansas (Phase II) infrastructure setup.

New York APD infrastructure support

California infrastructure setup and support

New Jersey BDW project initiation

New York MARS support.

Responsibilities

In the role of IT Systems Manager, my responsibilities include but are not limited to:

Generate new business opportunities and foster relationships with client personnel at appropriate levels.

Articulate alternatives in terms of cost, benefit, and risk where multiple solutions exist. Assist the Project Manager in the creation of technical project plans and assist in assembling teams for customer engagements. Perform technical quality assurance audits.

Stay abreast of current technical trends relevant to the client's business. Foster relationships with client personnel to analyze, evaluate, and enhance information systems to develop and improve security at procedural and technology levels.

Work with a team of technology professionals through all phases of the technology lifecycle, including requirements definition, architecture design, and conversion and testing both internally and client facing.

Ensure the system is operational, available to users and meeting contract Service Level Agreements (SLAs) related to system performance.

Proactively identify opportunities for system upgrades or enhancements to improve system performance and user experience.

Possessing a proven ability to lead project teams to successfully deliver agreed upon solutions of the highest quality, often in complex and challenging customer environments. Below are some of the tasks performed.

Working on cloud Migration project to facilitate secure data storage, real-time analytics, and concurrent, project-wide data sharing without exorbitant capital expenditures. With high customer demand for Azure, the migration project will utilize Microsoft Azure for Cloud-based data services and Snowflake as SaaS for data warehousing.

Involved in vital planning for infrastructure setup for various Optum Government solutions’ projects. Technical footprints for these projects ranged from 250-500 TB. The combined CPU cores in the environments ranged 256 cores to 512 cores and combined RAM ranged from 5 - 10 TB.

Designed and Implemented information system which will adequately support the enterprise infrastructure of the organization. Analyzed system requirements and ensured that systems will offer security and will be effectively integrated with current applications. Ensured that all systems are working at optimal levels and offers support to application development department regarding new technologies and system requirements.

Worked on Capacity Planning, Space Management, Security Management, Auditing, Shell scripting, Memory and Performance Tuning.

Involved in cost reduction and better investment decisions for applications infrastructure and services. Further assisted in reduction of complexity and in improvement of agility for applications to support changing business needs and risk mitigation

Was Responsible for detailed technical design at a solution level, delivery of overall technical solution to estimated schedule and time. Estimated technical effort, work breakdown structure, risks, and solutions at a solution level.

Involved in strategic decision making that included real-time collaboration between business and technology subject matter experts. Advice on investments regarding price versus performance.

Security Administration - Solved security challenges by designing security with Oracle Net and Oracle Advanced Security. Implemented Transparent Data Encryption (TDE) to enforce data-at-rest encryption in the database layer. Used Encryptions and Hash routines to obfuscate the data. Implemented STIGs to adhere to NIST certification requirements. Worked on identifying and fixing the security Gaps to adhere to CMS ARS moderate certification.

Oracle Exadata/Database appliance Administration – Involved in design, purchase, installation, configuration, and management of Oracle appliances.

Database Administration - Involved in Installation, Management and Administration of Oracle RAC (real application cluster), and single Instance systems from design architecture to implementation and support.

In these projects, I used built-in features such as Real Application Clusters (RAC), Automatic Storage Management (ASM), Flashback, Recovery Manager (RMAN), Online Reorganization etc. of the Oracle Databases on various production and development databases. Used Oracle built in advisors such as ADDM, Automatic Undo Management, Memory Advisors, MTTR Advisor, Segment Advisor, SQL Advisors and SQL Performance Analyzer and worked with ASH, AWR Reports, Compare Periods reports etc.

Informatica Administration- Installed and configured PowerCenter on UNIX platform administered the Informatica domain and Informatica security, Managed Licenses, and configured Highly Available Domain and Grids. Configured services such as Content Management Service, Data Integration Service, PowerCenter Integration Service, PowerCenter Repository Service, PowerExchange Listener Service etc. based on requirements.

Cognos Administration- Worked on Creation and maintenance of Informatica users and privileges. Configured Metadata Manager Service, integrated and linked resources such as Cognos repository, database metadata and Informatica PowerCenter repository to provide an end to end lineage

Linux Administration- Extensively worked on UNIX shell scripts on automation (Auto restart of servers, Disk space utilization, and UNIX file system maintenance and cleanup, and scripts using Informatica Command line utilities, taking backups)

Protech Solutions, Inc. Little Rock, AR, USA February/2006 – March/2014

http://protechsolutions.com/

Protech is a nationwide information technology services provider for development, maintenance and enhancement of automated systems with primary focus on child support enforcement systems.

Role: Database Architect / Operations Manager - Little Rock, AR, USA November/2010 – March/2014

Client

New Hampshire, Child Support Enforcement Information Systems

Virginia, State Disbursement Unit Information Systems

Mississippi, State Disbursement Unit Information Systems

Iowa, State Disbursement Unit Information Systems

Maine, Child Support Enforcement Information Systems

Protech, In-house projects such as Workflow, Timekeeper, R&D Projects

Protech India, Offshore Development Team

Role: Database Administrator - Little Rock, AR, USA October /2009-November/2010

Client – Delaware, Child Support Enforcement Information Systems

Role: Database Administrator - Little Rock, AR, USA February/2006-October/2009

Client - New Jersey Child Support Enforcement Information Systems

Tata Consultancy Services – Mumbai, Maharashtra, India May/2004 - October/2005

http://www.tcs.com/

Role: Software Engineer

September/2004 - October/2005

Client – Hutchison Max Telecom Limited

Scope

•Enabling Self-service through different channels namely – WEB, WAP, SMS and IVR

•Implementing Oracle Portal 10g

•Designing of the solution to enable the integrated self-service system

•Integrating self-service with other applications – IVR, SMSC, Pre Paid systems, EBPP (Electronic Bill Presentation and Payment) and Payment gateways

May/2004 - September/2004

Client – Financial Institutions

State Bank of India, Tata TeleServices Ltd., HDFC Bank, IFFCO, ICICI Bank, Railways, RBI, Kotak Mahindra Bank, CCIL, TELCO, NTPC, ONGC, Lakshmi Machine Works Ltd., National Insurance Company, NPCL, Huges Escorts Communication Ltd.

Scope

The TCS Product Alliances Group (PAG) has its roots in the TCS-Oracle relationship way back in 1987, when Oracle approached TCS and appointed it as their sole distributor / value-added reseller, much before the formation of Oracle India Pvt Ltd in 1992.

The group has come a long way since, having become an "Oracle Certified Advantage Partner" and having setup strategic alliances with SUN, IBM, BEA and Citrix, among others. TCS has signed reseller agreements and worldwide agreements with the companies mentioned above. It provides support to all clients.

Contact this candidate