SUMMARY

• Extensive experience in Information Systems development and technology implementations.
• A result oriented manager with strong process orientation with production support, SDLC and SLA management.
• Significant expertise in the development of large - scale public sector IT systems for the healthcare, hosting services, pharmaceutical, business registration & manufacturing.
• Extensive experience in Systems Consolidation Projects, which unites core business functions onto a single system platform.
• Major strengths include strong leadership, people management, communication skills, excellent analytical & problem solving skills, day to day productivity, and attention to detail.
• Extensive experience in Datacenter consolidation, DR and Data Warehousing verticals involving multi-functional role spanning Program Management, Project Delivery (SDLC), Operations, Support services and People Management.
• Extensive experience on implementation of high volume OLTP & OLAP database systems.
• Managed many large cross functional projects with more than 30+ team members and budget in excess of $5M+.
• Experience in setting up operations / support teams providing 1st, 2nd and 3rd level day to day operational support and developing business continuity plans.
• Expertise in developing a competent & technical team with niche skills through recruitment, training and employee engagement initiatives.
• Facilitate review of risks & development of risk mitigation plans, implementation of DR across multiple geological regions.
• Enforced policies, standards, and guidelines regarding databases, database development and management to comply with HIPAA, SOX & audit.
• Management of several outsourcing project initiatives with multiple offshore firms.
• Negotiation of complex contract terms and conditions.
• Maintain on-going learning curve of new products and solutions in the industry. Identify training requirements for staff on the latest technologies, solutions, and products.
• Have been rated as top performer throughout the career, by Clients, Managers, Peers and direct-Reports alike.
• Certified Scrum Master ( SMAC)

TECHNICAL SKILLS

RDBMS: Oracle 12c/11g/10g, Oracle RDB6/7, Teradata, ExadataMS access, SQL Server

HDFS: Big Data, Mongo DB, Cloudera, Hive, Pig, Sqoop, Flume

GUI Tools/IDE: OEM12c/11g, Oracle Developer, X-Windows/Motif, HTML

Data Warehousing & OLAP: Business Objects, Cognos, SAS, SSIS, SSRS

ETL Tools: Informatica (PowerMart, PowerCenter )

Data Mining Tools: IBM Intelligent Miner, Business Miner, DataMirror

Data Modeling & Use Cases: Oracle Designer, Erwin

Languages: Python, JSON, C++, C#, R

Tools: MS Project, Visio, MS Office Suites, Jira

Automation tools: HP DMA, Bladelogic, Ansible

Cloud: AWS, Azure, EC2

PROFESSIONAL EXPERIENCE

Confidential, Thousand Oaks CA

Technical Project Manager

Responsibilities:

• Managed cross functional activities related to large-scale implementations or process improvement initiatives to deliver projects on schedule and within budget.
• Responsible for managing service requests, participating in change review & weekend planning sessions.
• Ensure project status’ are methodically tracked, reported and communicated to team members, and other key stakeholders; manage program repository and ensure all program documentation is up to date and accessible.
• Defining and developing roadmaps for phase wise migrations of business systems and managing migrations.
• Presented differentbusiness/technical solutionsto project stack holders to get their approvals.
• Responsible for leading the Oracle & SQL Server team on-site and offshore resources in India for day-to-day operations; develop & implement data warehouse solutions.
• Responsibilities included project scheduling, milestone, release planning, change requests, daily activity planning, risk assessment, estimations and budgeting.
• Delivered a couple of long outstanding projects within few months.
• Responsibilities included leading and developing the DBA staff, directing team members through the analysis and resolution of problems and issues, and conducting follow-up meetings to determine root cause analysis and prevention, automation of repetitive jobs.
• Providing technical and functional guidance to the corporate planning and decision making process. Defined and enforced standards, wrote SOP, adoring best practices and disciplines relating to Database Management and Architecture.
• Strategized databases migration strategies to AWS RDS & EC2, automate server builds on Confidential cloud.
• Handled responsibilities to implement BI solutions/ Data warehouse projects. Managed workloads, analyze requirements, assign dedicated resources to meet requirements for reporting, analysis, and implement data warehouse solutions.
• Responsibilities include entail defining, developing, implementing, measuring, and improving all processes, procedures, and activities required to ensure accuracy and quality of reports and data validation.
• Evaluated, integrated & implemented various Commercial-off the shelf (COTS) systems.
• Translated business requirement into cost effectivehigh level design componentsfor the developers to develop their low level design.
• Review allproject level design documentsto ensure that the business requirements, design standards are adhered to, created data repository for reporting and mapping purposes.
• Assist with resource planning and production implementations. Delegate technical tasks and responsibilities to appropriate team members.
• Hands on experience working with large data sets and performing product and business-level analysis using ETL tool, Informatica, OBIEE, Business Objects, Tableau & MS Access.
• Worked on evaluation of various Cloud computing technologies, Big Data, Hadoop Technologies and various distributed computing solutions based on Hadoop tools like Hive, Cloudera, MongoDB, Spark, Flume, and other related technologies for scalability, operational agility and automation.
• Most Valuable Project Manager & OTS award winner.

Confidential, Camarillo CA

Project Manager/Database Architect

Responsibilities:

• Responsible for leading the Oracle DBA team in improving Oracle database performance/ uptime, for implementing the best methodologies for reengineering efforts, and implementation of those reengineering efforts to ensure scalability.
• Providing technical and functional guidance to the corporate planning and decision making process. Define and enforce standards, best practices and disciplines relating to Database Management and Architecture.
• Lead a technical team supporting several critical databases in a Veritas Cluster (VCS) on Solaris, Linux, RAC and Oracle Fail Safe on Windows for 24x7 uptime and high availability.
• Providing technical consultation on moving Oracle databases currently running VCS configuration to Oracle RAC on Lintel farm.
• Implementation of DR across multiple geological regions.
• Worked with apps teams for minimizing down time for database & storage filer migrations.
• Interview, brainstorm and document the L2 & L3 processes, own OPS manual and create awareness through training sessions, FAQ, quizzes, and workshops.
• Finalize requirements for SLA measurement, and reporting.
• Conducted Sprint-solving meetings with the Product owners and provided new directions in addressing the release backlog problems while simplifying the team’s level-of-effort estimations used in selecting the right numbers of developers/testers with the right skill sets at the right time.
• Provided ways to measure a project’s backlog planning and its progress while avoiding scheduling constraints, slack time issues and deliverable problems.
• Worked as Release Manager to deploy/ upgrade several new applications within a specific timeframe. Was one of the primary interface managers working with the development groups making the build process more transparent during the Release life cycle phases.

Confidential, Woodland Hills CA

Principal Database Architect

Responsibilities:

• Responsibilities include entail defining, developing, implementing, measuring, and improving all processes, procedures, and activities required to ensure maximum 24X7 systems availability, utility, flexibility, and responsiveness of the production database servers.
• Responsible for managing service requests, participating in change review & weekend planning sessions, interfacing with Operations and Production Support.
• Other responsibilities included leading and developing the DBA staff, directing team members through the analysis and resolution of problems and issues, and conducting follow-up meetings to determine root cause analysis and prevention.
• Provided technical and functional guidance to the corporate planning and decision making process.
• Interfaced with internal customers. Assist customers with resource planning and production implementations. Delegate technical tasks and responsibilities to appropriate team members.
• Ensure the database servers are reliable, available, and servicing customers (RAS) and proactively monitored for health and performance. Monitor response time and critical batch processing and ensure closure to all production issues.
• Configured Web SSO to provide a Single Sign On.
• Monitor and manage all contract deliverables and activities to ensure compliance.
• Participated in the review/approval of Requests for Service to determine financial implications, to manage cost and to ensure operational environment integrity.
• Installed and Configured Oracle 10g/9i Real Application Cluster (RAC) Solutions on Solaris and OpenVMS. Set up, manage, administered the Oracle Clusterware.
• Wrote DTS packages for data loads, migrates them to SSIS routines.
• Wrote various database procedures and packages using T-SQL, PL/SQL.
• Database upgrades for OracleRDB upgrades from Version 6 to 7.1 & for Oracle from version 7, 8i to 9i & 10g. Performance tuning including monitoring and setting appropriate SGA. Worked extensively with the development team in tuning complex SQL statements and PLSQL code.
• Installed and upgraded Oracle Servers, Monitoring space requirements and adding new storage space. Monitoring and tuning database to ensure optimal performance. Handling database backup and recovery. Implementing schedules for database backups.
• Wrote backup policies and several OEM and cron jobs for proactive monitoring for health and performance of databases.
• Worked in environment support team to build, facilitate data & code refreshes required for development teams.
• Worked with the application development team to build & implement data warehouse project providing information for the membership & claims subject areas.
• Designs and build MDM (Master Data Management) repository for Member data in Healthcare space using Oracle Relational Database.
• Developed strategies to analyze existing data set, identify Master, Reference and Metadata for data acquisitions and Data Reporting, data profiling, identification of match rules, cleansing, data quality and source data remediation.
• Maintained a single MDM repository so that Data Collection and Data Reporting Systems are using the MDM Repository for the Enterprise needs.
• Developed MDM architecture/processes providing actionable, integrated data; improved productivity through strict management of data.
• Conducted BRD reviews with the Management Group, provided the infrastructure and data requirements to the ETL teams for each SDLC environment (Dev, Test, and Prod) and validated their set up. Worked with BI team in design & code reviews. Used the PMO ground rules covering a level of Agile development procedures. Set up the collaborative status meetings with the key Analyst groups and the QA team leaders to review the User acceptance test plans and the Business & QA teams’ signoff.

Confidential

Senior Oracle Consultant/ Database Administrator

Responsibilities:

• Worked as Production Database Administrator.
• Prime responsibilities for all DBA activities - Logical/ physical design of databases, defining of roles, profiles etc., backups, performance issues, connectivity to database, creation of database links, upgrade strategies, capacity planning & tuning of ORACLE parameters.
• Installation & configuration of ORACLE, SQL Server.
• Formulated upgrade strategy. Performed migration of entire system from DEC to Sun Spark machine
• Provided necessary upgrades required for integration with legacy COBOL system being used at common Government Data Center by various other agencies.
• Did System Study, Analysis & Prototyping. Designer 2000 was used extensively for the purposes. Reviewed and reformed the Function and Information model for the system.
• Customized Oracle Financials 10.6SC - HR and Project Accounting modules.
• Coordinated with other government agencies accessing the data.

Confidential

Assistant Manager (Systems)/ Senior Database Administrator

Responsibilities:

• Brainstorm with larger pursuit team on transition and stead state solutions.
• Participated in the development of strategies in support of objectives pursued by Manufacturing ( Confidential is a leading company manufacturing Cement, Paper, Tire, Magnetic Tapes with gross turnover of over $2Billion).
• Lead all Business Analysis efforts in support of the Manufacturing customer; developed business cases as appropriate for the implementation of multiple systems to support manufacturing.
• Assisted the Manufacturing customer in the development and support of business processes that produce measurable business outcomes.
• Represent support team on various platforms at Gap, including daily severity calls, peak planning, weekly change control calls etc
• Root Cause Analysis, Coding, Testing, Client interfacing and Issue resolution.
• Responsible for Migrating databases to a high availability configuration; featuring 0% down time,. Provided 7-x 24 on-call support.
• Responsible for maintenance and guidance in troubleshooting/fixing Oracle Servers databases and Administering Unix Servers.