Bharatish Shirahatti

Atlanta GA, *****

acu71d@r.postjobfree.com

678-***-**** C: 678-***-****

Resident Status : US Citizen

Experience Profile:

Experienced Senior IT solutions expert with diverse experience in multiple business applications. Well-versed in many IBM, Microsoft, Oracle, Open Source software products. Industry experience includes Banking, Finance, Insurance, Retail, Logistics, Manufacturing and Government sectors. Experienced in effective use of Full Life Cycle Methodologies, Productivity Management Tools in large enterprise environments. Current Experience includes working with multiple database products in Ecommerce, Data Warehouse/BI and ERP environments.

-Analysis, Architecture, Design, Physical and Logical Data modelling, DDL scripting, Creation/upgrades of Databases

-Architecture, Design, Capacity Planning and setup of Hardware/OS/Storage/Network infrastructure

-Development of Stored procedures, functions, triggers, PL/SQL

-Performance tuning Hardware/OS/Network/File Systems/Databases/SQL/Applications/Processes

-Customizations and implementations of ERP Databases

-Installation/upgrades of software, Creation and upgrade of Database Instances

-Setup of Instances/Databases, setup of maintenance scripts

-DDL Scripting and Creation of database objects

-ETL development and processes, Data loads

-Daily Database monitoring, problem determination, problem resolution, on call support

-Design, implement and test BCP & DRP procedures and processes, mirroring, clustering, replication, High availability/Failover

-Compliance with Organization Security/IT/Statutory(SOX) Policies

-Security design, Setups, audits and maintenance.

-Design and Implement database design, change and operational standards

-Experienced as Team Lead as well Team member in upgrade/migration projects

-Advice on the technical directions

-Evaluation of tools

-Work with system and application software teams/vendors to resolve problems

Education: Bachelor of Technology (ECE), NIT Karnataka,

MBA, JBIMS Bombay University

Professional Training / Certifications:

DB2 Advanced Database Administration for Linux, UNIX and Windows

Workflow & Information Management Redesign Specialist (AHIMA/ONC)

Implementation Manager (AHIMA/ONC)

Project Management (PMI, Microsoft)

Java/J2EE

Hardware/Software:

Databases: DB2 LUW, MS SQL Server, Oracle, MS-Access

UNIX: AIX, Linux (Debian, SuSe, and Red Hat distributions), HP-UX, Sun Solaris, Shell scripting,

ERP Application Env.: Oracle financials, SAP (Filo, BW Basis

Tools & Methodologies: Database tools/Utilities, SAP GUI tools, Splunk Monitoring, Data modelling tools, ETL, VMware, Project Management tools, Process methodologies, Reporting tools, Microsoft Office/Sharepoint

Trained in Java/J2EE, Oracle Applications financials GL/SL/AP/AR, SAP Basis/NetWeaver/Reporting Business ByDesign, Big Data and Hadoop, Splunk Admin…

Experience:

Mythri Solutions- Atlanta GA

Solutions Architect / Consultant - June 2015 – Present

Project Implementation and Support

Implementing application infrastructure in Windows/Linux environment for Database (DB2, SQL Server) and ETL tools in VMWare environment.

Coca-Cola, Atlanta GA

DBA/Architect- June 2014 – May 2015

Implement and Support DB2 LUW (AIX) in a large and complex SAP / non-SAP environment.

Environment includes large OLAP (DPF) /OLTP databases, HACMP/TSA, HADR, TSM.

Analysis, data architecture, data modelling, design, implementations, database installations / upgrades, OS/database/SQL tuning, performance tuning, maintenance, coordinating offshore team.

Supported development of DB2 PL/SQL.

Security Setups and maintenance.

Descartes, Atlanta GA

DBA/Architect - Aug 2013 – Mar 2014

Working in W2K/Linux/UNIX/DB2/SQL server environment to develop, implement and support of application systems.

Responsibilities included working on multiple implementation projects.

Work responsibilities included Analysis, data architecture, data modelling, design, implementations, database installations / upgrades, OS/database/SQL tuning, performance tuning, support development teams, performance tuning.

Security Setups and maintenance.

Apextek, Atlanta, GA

DBA/Architect - July 2011 – May 2013

Worked on migration project to migrate DB2 environment from AIX to VMware based Linux environments.

Worked on setup of MS SQL server 2005 and 2008 environments on Windows 2008 R2.

Worked on Analysis, data architecture, data modelling, design, implementations, database installations / upgrades, OS/database/SQL tuning, performance tuning, support development teams, performance tuning.

Macys

DBA/Architect - Systems Specialist- May 2009–April 2011

Worked in WebSphere/AIX/W2K/Linux/DB2/MSSQL/Oracle/J2EE environment to develop, implement and support Ecommerce, Pricing Data Warehouse/SAS applications.

Worked on large VMware cloud migration project for non-prod environments

Responsibilities include all database related activities like analysis, architecture, design, custom modifications, data modelling, implementations, development of DB2 PL/SQL procedures, DB2 installation / upgrades, OS/database/SQL tuning, performance tuning, manage / support development teams.

Responsibilities included support of development, test, staging, production database environments, installation, maintain, monitor, trouble shoot and configure databases.

Manhattan Associates

Principal DBA/Architect - April 2007 – July 2008

Worked in WebSphere/AIX/W2K/Linux/DB2/ MS-SQL/Oracle/J2EE environment to implement and support supply chain solutions.

Job involved working on multiple large implementation projects.

Responsibilities include all database related activities like analysis, architecture, design, custom modifications/design, implementation, DB2/MSSQL/Oracle installation/upgrades, OS/database/SQL tuning, manage/support development teams, performance tuning.

Worked on projects to migrate/develop/support DB2 PL/SQL from Oracle PL/SQL for Transport Management system for major customers like Home depot, Kroger.

S1 Corp (ACI Worldwide)

DBA/Architect - Mar 2004 to Feb 2007

Worked in WebSphere/AIX/W2K/DB2/MS-SQL/Informix/Oracle/EMC-SAN/J2EE environment to implement and support hosted front-end banking and Insurance application systems.

Responsibilities include all database related activities like analysis, architecture, design, implementations, DB2/MSSQL/Oracle installations / upgrades, OS tuning, support development teams, performance tuning, resolving resource conflicts, tool selection and planning.

Contributed in hardware/software infrastructure design/planning for high availability and disaster recovery of DB servers for production environment.

Community Loans of America

DBA/Architect - Oct 2003 to Mar 2004

Worked in Intranet/Linux/W2K/DB2/ MS-SQL/J2EE environment to design and develop loan management system.

Responsibilities included all database related activities like analysis, data modeling / data architecture, design, implementation Linux/DB2 installation / upgrades, Linux OS tuning, support development teams, performance tuning, resolving resource conflicts, Data Warehouse requirements, tool selection and planning.

Contributed in hardware/software infrastructure design/planning for high availability and disaster recovery of DB servers for production environment.

SecureWorks (Dell)

DBA/Architect - June 2002 to May 2003

Worked in Internet/Linux/W2K/DB2/MS-SQL/Java/C/C++ environment to support network intrusion detection and prevention service.

Responsibilities included data modeling/architecture, design, support of development and production environments, DB2/MSSQL installation / upgrades, Linux OS tuning, data recovery, Data Warehouse modeling / design / implementation, design / implementation of high availability and disaster recovery of DB servers, replications, performance tuning, resolving resource conflicts and all database related activities.

Developed service costing and profitability data mart for MIS reporting.

Interface

Solutions Architect/Consultant - Mar 2001 to May 2002

Worked as a Solutions Architect /consultant playing multiple roles in customization, data modeling/architecture, design, implementation, integration, Data migration and support of Internet / Intranet based e-commerce application system.

The job involved WebSphere Application server, DB2 UDB/LUW server and Database administration.

The project involved major upgrade / migration of existing system based on Windows server/ IIS / SMTP / SQL Server / Cold Fusion to one that is based on IBM WebSphere Commerce Suite.

Experience includes installation, configuration, and administration of WebSphere Commerce Suite based applications systems with following components: WebSphere Application Server, IBM HTTP server with SSL, DB2 UDB EE, XML tools, WebSphere Studio/Application Dev., VA for Java EE / Team Server, Windows NT/2000 with Visual source safe, Rational Rose/Visio

Development skills include Java, JSP, Servlet, EJB, JavaScript, C++, Net. Data, HTML and related tools.

Contact this candidate