Post Job Free

Resume

Sign in

Database Administrator Business Analyst

Location:
Phoenix, AZ
Posted:
June 05, 2023

Contact this candidate

Resume:

Ravi Narayanaswamy

Phoenix, ARIZONA • +1-720-***-**** • adxisq@r.postjobfree.com • https://www.linkedin.com/in/rnswamy2022

Chennai, TAMILNADU • +91-900-***-**** • adxisq@r.postjobfree.com

Information, Data, Technologist and Business Analyst; All-round work experience, people skills, technical strengths, business knowledge, audit, and education. Industries covering Banking, Customer Communications, Cosmetics, Shipping, Channel Management, Medical, Healthcare, Internet Advertising and Marketing, Telecommunications, Office Supplies, Distribution, Logistics, Dairy, Rural and Plastics. Led teams of 5-25 people across technology, data science, business and design.

PROFESSIONAL EXPERIENCE

Consulting, Phoenix, AZ AuG 2021 – Present

Business Analyst & Information Technology Consultant

Assisted in Customer Communication systems business solutions consulting (Stable-Orbit)

Involved in efficient People Logistics Management using Hybrid Electric Vehicle (Uber-Veyo)

In-depth exploration into data engineering & architecture preparing for certification (Athlyte)

Orchestrated Fast Moving Consumer Goods rural marketing & distribution systems (Radarss)

Completed Data Science & Business Analytics projects in Marketing and Finance (McCombs)

Researched potential export opportunities for Brazilian nuts and Rosewood (Self)

IBM India, Chennai, India JuL 2015 – MAY 2021

Technical Business Leader/Senior Manager

Led technical infrastructure projects in France & Canada for banking, shipping and cosmetics

Assisted delivery of projects for change management, audit needs, software/hardware upgrades and new technologies in weekly, monthly time windows

Analyzed problems and historical trends related to systems recovery to fix any issues and improve overall working

Met Service Level Agreements of 99.99 percent for up and running systems including audits

Managed obsolescence of hardware and software and risk management every week

Implemented best practices using Waterfall and Agile methodologies for projects review

Authored business requirements document for proprietary software application: led requirements elicitation sessions (including requirements analysis), solution assessment and validation, use cases and interface/functionality mock-ups

Interviewed business clients to analyze their business requirements and recommended and designed technological improvements to their business processes and operational procedures

Documented and ensured documentation for knowledge base for posterity

Consulting, Chennai, India JuL 2014 – JuL 2015

Information Technology Consultant

Assisted in functional requirements for Construction Management Software (Pioneer)

Analyzed and fine-tuned MySQL database for Pharmaceutical POS software (Tarnea)

Mentored and trained IT and database staff including review of regulatory guidelines(Tarnea)

Consulted projects for events management, Oil & Gas and children education software (Elite)

Welltok, Denver, CO JAN 2014 – APR 2014

Information Technology Consultant

Created data marts in MySQL 5.6 on AWS from Oracle 11gr2 database in a health benefits SaaS company in 3 months

ChannelInsight, Denver, CO OCT 2012 – NOV 2013

Senior Database Administrator

Adopted best practices for seamless refreshes & release planning with minimal downtime

Pre-emptive database maintenance, monitoring, and tuning OLTP/ETL 10 Tb database used for cloud-based channel management solutions including financial inspection

Planning audit compliance, database objects, sizing, legacy data archival and user management

McKesson Corporation, Westminster, CO MAR 2010 – OCT 2012

Upgrades Consultant

Upgraded Horizon Clinicals (Client, Hospital & Medical Systems) in Oracle on LINUX/UNIX

Planning remote migration and implementation across US over 30 days to 3 months

Mentored junior staff for quick turnaround and error-free conversions

Helped with automation of upgrades and client issues mitigation and resolution

Media Breakaway LLC, Westminster, CO MAY 2008 – FEB 2010

Infrastructure & Database Consultant

Requirements, Design, Development and Implementation of strategic IT & business initiatives

Rolled out from design to production in 6 months from a 3rd party application to a home-grown application with cost savings in service and infrastructure charges.

Project used Linux, Java, Apache, MySQL and JBoss (LAMJ) and audits compliance

Analyzed data from the mailing project to assist in mailing campaigns and profitability

Built data marts for business reporting

Level(3) Communications (LUMEN), Broomfield, CO NOV 1999 – JAN 2008

Infrastructure Database Architect/Senior Engineer/Database Administrator

Provided database services and SOX audits across Enterprise with 99.99 Service Level Agreements

Responsible for database administration, backup and restore operations across servers locally within US and UK for RAC and non-RAC database instances

Trained and managed onsite and off-shore DBA resources for redundant, basic DBA tasks to take advantages of blended costs saving the company headcount and costing 40-50% of original cost

Completed integration of Wiltel Communications, an acquired company, for Network Connectivity, On-call support framework, database inventory and backup operations for all databases in 3 months

Received “GTO Foundation Award” in 2006 for work related to SOX best practices and reporting compliance, catalogues migration and backup operations. Recipient of “Refuse to Lose“ Signature Award in July 2005 for stellar performance in Server Migration and Consolidation project that led to lowered costs of maintenance with newer servers

Corporate Express (STAPLES), Broomfield, CO JuL 1996 – NOV 1999

Database Administrator/Systems Analyst

Designed and developed server-side transaction system modules for different business processes for a leading office supplies provider including Vertex tax compliance

Development Technology used Pro-C on a three-tier client-server architecture using HP-UX 9000 platform with Oracle database backend, Tuxedo middleware and Visual Basic client

Migrated HP-UX 9000 server databases to Sun Solaris database servers as a major cost-savings effort in a Server and Disk Consolidation project in 3 months set with stringent Customer Commit Dates

EDUCATION

Great Learning & Texas McCombs School of Business, India/USA

Postgraduate Program; Decision Sciences & Business Analytics

Daniels’ College of Business at the University of Denver, Denver, CO

Master of Business Administration; Business & Information Systems

Institute of Rural Management, Anand, India

Postgraduate Program; Rural Management

Madras Christian College, Chennai, India

Bachelor of Science; Physics

SKILLS

Project Planning and Delivery Management

Business Analysis, Requirements Gathering, Analysis & User Acceptance Testing

Agile Project Management, Software Development Life Cycle (SDLC)

Risk & Obsolescence Management and Disaster Recovery Planning

Python, KNIME, Tableau, Business Intelligence (BI)

SQL, Microsoft Access, Oracle, MySQL, Postgres, LINUX, UNIX & Windows

Microsoft Word, Excel, Power Point

Cloud & Big Data, Data Analysis, KPI and metrics

OTHER

US Citizen; Overseas Citizen of India; Certification in GIS and Yoga; References on request.



Contact this candidate