SUMMARY:

• Enthusiastic people person - with an advanced technical education, combining more than fifteen years of extensive experience and expertise in Database Technologies, Business Intelligence (BI), DW Solutions,, ERP Systems, OLAP, Critical Problem Solving and Analysis in Information Technology with responsibility for directing and managing all aspects of complex projects with record results.
• Worked with diverse environments of various clients like Confidential, HYLAMobile, Novartis, Confidential, Pacebus, and AT&T.
• Bringing organization to large-scale, complex, multi-phased database and software development, migrations, and implementation projects and stability and focus to diverse cross-functional teams. Helping companies achieve strategic and financial goals and competitive advantage through technology.
• Experience in incident and change management as well as BAU improvement projects and formal PMO projects.  
• Worked with Business and Agile Scrum team to implement various projects within budget and timelines.
• With strong communication and organizing skill, expert in monitoring sub-contractors to ensure guidelines are maintained. Expert in collaboration with IT Executives and Finance on Cost of Ownership, financial metrics, and cost transparency initiatives.
• Experience and understanding in Cloud deployment tools such as Github, Terraform, Jenkin, Git, Chef, Puppet, AWS Cloud Formation, Ansible.
• Cloud experience, including designing/establishing infrastructure utilizing SaaS, PaaS & IaaS. Understanding of Cloud architecture and terminology for various providers such as AWS, Azure, Pivotal.
• Experience with designing and creating database structures, including normalized, denormalized, and data warehouse, data vault, database topologies and providing product and new technology research and evaluation.
• Experience and understanding in Cloud deployment tools such as Github, Terraform, AWS Cloud Formation, Ansible.
• Experience in installing, configuring, patching, upgrade, backup, cloning, and performance tuning of databases as well as data modeling, data analysis, data profiling, and architecting.
• Hands-on experience in data warehousing, Big Data, data science, Information management, and analytics technologies to provide tactical and strategic direction in the areas of data curation, machine learning, business intelligence analytics, data mining and visualization, and assessment of data quality and consistency across platforms, products and geographical areas.

TECHNICAL SKILLS:

OS and Cloud: Windows, Linux/Unix, AWS, MS Azure, Oracle Cloud, ServiceNow, Saleforce Cloud, Amazon S3 and Amazon EC2, Cloud computing, Big Data, DevOps

Middleware: Oracle Weblogic Server, WebSphere, Fusion, Apache

RDBMS: Oracle 12c/11/10, Oracle Exadata, Exadata OVMs, Oracle E-Business, MySQL, MongoDB, SQL Server, DB2, Netezza, Cassandra

RDBMS Tools: PLSQL, OEM, T-SQL, TOAD, Erwin, ER Studio, Oracle Warehouse Builder (OWB), Informatica, Oracle Data Integrator (ODI)

Languages: XML, HTML, Java, J2EE, JavaScript/VBScript, Perl, Hadoop, DDL scripting, ETL, SQL

Tools & Technologies: VMWare, Remedy, Oracle 4GL, Informatica, SOAPUI, Qlikview, Business Objects reports, Crystal Reports, .Net, Jenkin, Git, Chef, Puppet, Ansible, Maven, AppDynamics, Zabbix, Web Services, HP Loan Runner, Meditech, Epic, Cerner, Virtualization, SAS, Jira, HP QC, New Relic, IBM MDM, AppDynamics, CloudOps, Splunk, Atlassian stack, Spark, Hive, Microsoft Dynamics GP

PROFESSIONAL EXPERIENCE:

Confidential, Plano, TX

Production and Development Support Manager

• Managed DevOps Engineers, DBAs, SQL Developers, .NET, Java, Hadoop, and Pega developers and production support team.
• Manage workflow of Level 3 Production support team to ensure timely and accurate responses are delivered to clients. Monitor case queues to ensure client cases are handled in a timely manner, assigning cases when needed to ensure service levels are met.
• Successfully led, measured, and improved the delivery of technical support provided by an multiple outsourced partner within a global IT setting.
• Provide instructional guidance to CSRs for handling complex issues; analyzing and resolving problems for customers by aiding the CSR to determine and explaining the best solution for the problem.
• Worked with PMO to localize project change management process as required.
• Worked on various small development projects, and delivered the project in time within the budget. Reviewed code to make sure that coding standards has been followed, and testing team completes the testing with proper bug tracking.
• Created Change Request status material for weekly, and monthly Operations, and Business Review Meetings.
• Interface with other internal departments and/or clients to follow up on customer requests. Handle escalated requests from clients. Develop and maintain an excellent working relationship with internal/external customers.
• Managed successful disaster recovery exercise for various application, systems, and databases. Responsible to mentor new team members, and provides training. Provide technical guidance for outsourced development staff and serve as escalation point for complex technical issues. Created an end to end data management program from source data collection to business data visualizations and insights ensuring the security of data in storage and data in motion.
• Worked on various technology partner to implement Cloud infrastructure to provide PaaS & IaaS within the Bank. Used AWS, and Azure for POC. Also worked on DevOps to automate the deployment.
• Provided leadership on a project to build an ITIL based services and support structure while managing projects and a department staff when the bank was reorganizing global applications administration, development, and support model. Operationalize monthly data by loading, validating, and reviewing on timely basis
• Established project management processes and methodologies to ensure assigned projects are delivered on time, within budget and meet high quality standards and Leadership expectations using the appropriate tools.
• Support the ongoing process improvement of databases, systems and applications development and monitoring. Ensure all systems are compliant with monitoring standards and customer requests.
• Prioritized the product, release and sprint backlogs; managed scope and customer commitments and ensured progressing delivery of a product portfolio comprising multiple products.
• Manage, mentor and facilitate the developers on the teams in agile methodologies. Leading development related projects and the evangelist for best practices for the development of code and processes which will support systems that manage, deliver, and support for multiple clients.

Confidential, Farmers Branch, TX

Database, BI, Data Warehouse, Analytics Manager

• Negotiated and contracted consultants, technical personnel and vendors for services and products.
• Responsible to create, maintain and execute processes for deploying code to production environments that adhere to established policies and procedures and well as industry best practices.
• Worked on Oracle EBS Financials, Purchasing, I-Procurement, Inventory, and Project Costing modules. Created MD50s, and BR100s.
• Developed, implemented, and monitored management information systems polices and controls to ensure data accuracy, security, and regulatory compliance.
• Recommend and develop plans for system development and operations to include hardware & software purchases, budget, and staffing.
• Managed Oracle & SQL Server installations, migrations/upgrades, configurations, tuning, and performance analysis. Also worked on Active/Passive and Active cluster implementations in Windows Servers.
• Involved in code review of DTS, SSIS Packages, T-SQL, and Stored Procedures. Worked on data modeling using IBM Rational Rose.
• Worked on automation to manage processes, scripts and automation pipelines for software build, integration and deployment of database and associated resources. Used DevOps to automate the deployment. Implement advanced data analysis, statistical analysis, and data mining capabilities.
• Provided technical and data leadership in the research, experimentation, business analysis and use of systems technology including infrastructure architecture, integration capabilities and database management.
• Developed & reported on operational measurements to support business analytics across the product team. Worked on Data Analysis, Data Profiling, and SQL Tuning. Prepared high-level ETL mapping specifications. Worked closely with developers, support and QA teams to design and optimize all Systems/DB environments.
• Executed and delivered various Infrastructure projects like data center migration to Cloud environment, various database upgrades, BI and SAS analytics environment setup, and data warehouse implementation projects.
• Prepared business plans & use cases to prioritize opportunity and influence product strategy. Contributed with product & solution expertise and add value to sales process by conveying complex ideas via simple, easy to understand presentations and product demos. Develop and tests disaster recovery plans to meet RTO, and RPO.
• Maintain continuous control of production Information Systems activities through daily management reports and direct supervision. Manage the IT Change Control process to facilitate changes while exercising the necessary precautions to protect the production environments.
• Developed data system infrastructure solutions by defining hardware and software requirements to meet company policies and specifications for security, back-up, and recovery.
• Worked in data Quality technology strategy deliverables, including activities supporting data standards, data governance processes, data quality, tools, best practices, analytics, business scorecard monitoring, and implementations.
• Reduced server and database footprints for $150K per month cost savings.

Confidential

Database and Systems Lead/ Service Delivery Manager

• Successfully transitioned database services from IBM to Confidential, which supports 1400 Oracle, 700 SQL Server, and 5 MySQL databases. Worked on Azure- Cloud Delivery Solutions to implement SQL server database on Azure.
• Through Global Knowledge Transfer sessions arranged by IBM in Argentina and Switzerland, delivered Service Operational Manual and Standard Operational Procedures for the database service line. Assists in preparation of IT presentations for management.
• Managed reverse KT to the off-shore team members through web sessions and conference calls. Prepared technical documents for daily Service Operations and Run book for Oracle databases, MySQL, and SQL Server databases.
• Responsible for managing the timely delivery of automated reports for server, storage, and memory utilization. Participated in internal/ external audit. Track & monitor operational performance metrics; provisioning, change and incident.
• Handled the various service transition related projects and make sure the accuracy of transition documents for active/active and active/passive clustering, log shipping, replication, and mirroring. Prepared Knowledge transfer session’s meeting minutes with the detailed understanding of SQL Server database configuration, standards, backup strategy, RTO & RPO, replication, patching, and SQL Server monitoring tools.
• Prepared the daily KT Sessions tracking report as part of information mining and gathering from BAU, Order Fulfillment, and Engineering teams.

Confidential

Database and Systems Lead/ Service Delivery Manager

• Managed team of on-shore and off-shore team members including application development & support, DBAs, and business analysts. Make sure that assigned projects were delivered in time, within the budget, and as per the quality standards expectations. Participated in Change Control Board (CCB) meetings to deliver the changes in Production system.
• Participate in IT Department's operational and strategic planning, including fostering innovation, planning projects, and working with the application product owners in negotiating the allocation of resources.
• Benchmark, analyze, report on, and make recommendations for the improvement and growth of core business applications. Developed and implemented IT policies and procedures for application support, development and change management. Implemented process improvements in Problem Management, root cause analysis, and change implementation.
• Participated in all of Software Development Life Cycle, starting from requirements, design, maintenance, enhancement, and coding. Worked with various teams to delivered performance tuning, and administration of Oracle, and SQL servers. Introduced data compression, partitioning, grid control, data guard for high availability.
• Managed projects in architecting, designing, modeling, developing, maintaining and deploying complex data models, and data integrations utilizing SQL server (SSIS) based ETL processes for new and existing systems.
• Lead in planning and implementing the data integration and data migration activities.
• Managed daily operations and support services to ensure all support incidents, change and provisioning requests are acted on and resolved according to published SLAs. Authorized CR's in IPM based on authorization from PM, and stakeholders approval.
• Partners with architecture teams to drive information architecture standards. Responsible for facilitating problem solving and technical resolution meetings between the Assigned Client Engineers and the client.
• Manage various projects which include implementation of Oracle and SQL server databases, Database consolidation, Oracle database 12c roll-out, database schema re-design, and database capacity planning, regular database patching and upgrade, storage migrations, backup reports, and database refresh.
• Prepared Run book for 105 Oracle databases and 85 SQL Server databases. Involved in database services transition from HP to HCL. Run book includes database information, fail-over/switch-over plan with technical steps, backup details, and hardware configuration information.
• Enforced the change control procedures during production implementation and following path to production for any changes. Maintained accountability for an issue until service restored using ITIL best practice of Event, Incident & Problem management.
• Organize, implement, and report status of ongoing operational improvements to the existing applications, systems, and databases.

Confidential, Richardson, TX

Database, Weblogic and Oracle Apps Technical Support

• Managed Cellular Asset Tracking system, and Weblogic servers. Handled Weblogic upgrade, and CATS application upgrade. Oracle 10g Financial Applications database, and Oracle Applications 11/R12.
• Audited Change Requests for accurate assignments and categorization.
• Install, configure, and maintain MySQL multi-level Master-Slave replication. Troubleshoot database-related application performance issues. Provided on-call support of MySQL databases.
• Handled various requirement like Databases capacity planning, installation, setup, refresh, backup, monitoring, production support, application team’s requirement for new databases, replication setup, high availability setup. Structured the Weblogic servers monitoring, upgrade, configuration for production servers and QA Servers.
• Make sure that supported databases are upgraded to the approved database version and delivered Oracle database upgrade project and Oracle Grid control implementation project.
• Possess an advanced understanding and knowledge of Database and Middleware technologies, Data Warehouse functions, processes, and best standards. Worked on different data models.
• Interfaces with key Business Community members to ensure IT Services meet needs and service levels.
• Implemented methodologies to improve first call resolution, manage customer perceptions, and build strong internal relationships. Selected appropriate technology and other resources to maximize effectiveness of problem resolution and customer service.
• Provided a crucial role as a process and technical leader on Major Incident (Sev 1/Sev 2), and business impacting events and incident technical bridges.
• Conduct in-depth technical analysis of all systems, including the governance framework, architecture, and disaster recovery and business continuity; delivered gap analysis and recommendations, attaining 99% up time.

Confidential, Arlington Heights, IL

Database and Oracle Applications Manager

• Responsible to manage the team of Oracle E-Business R12, Oracle and SQL Server databases and DBAs.
• Responsible to administrator Oracle 10g RAC on Windows 4 node servers. Migrated Oracle 10g RAC from 4 node Windows to Linux 2 node servers.
• Managed an environment with Microsoft Dynamics GP.
• Successfully managed upgrade of SQL Server with data migration, Installation of SQL Server with integration, analysis, and reporting services, database backup and cloning.
• Manage the team to Support Oracle E-Business Suite modules GL, AP, Purchasing, Grants, and AR. Monitoring iStore activity and HTTP server for the iStore.
• Support various projects like Installation and setup of Oracle E-Business Suite R12 in Single Node install for Development setup and multi node install for Production setup. Bi-weekly cloning of application tiers, database installation and upgrades, setup of the RMAN hot backup using scripts for the daily database backup, and archive log backup, database and application cloning, patching, application installation, tablespace and file system management and monitoring, monitoring database backups, performance and health check of the databases, and provide solutions to the technical staff.
• Liaison with technology and business stakeholders to ensure priorities and timeline expectations are clearly understood; managed conflicts as needed.
• Managed and provided guidance to the team that research, analyzes, and documents business requirements for critical projects and programs. Established and maintained regular written and in-person communications with the organization’s leadership team, and end users regarding pertinent IT application services activities. Approved and oversee projects.
• Manage the most critical database in PACE for the ADA Paratransit Service. This database handles the vehicle trips, schedules, real time routes, customer information, vehicle information, and geographic location of the vehicles. Administration of Workflow Notification Mailer, Concurrent Managers, Schedule Jobs, Apache, Forms, HTTP, and OC4J.
• Make sure team follows the change management best practices to maintain the different version of reports.

Confidential, Hoffman Estates, IL

Lead Database Administrator

• Responsible for 10 SQL Server databases (2000/2005), 5 MySQL, and 50 Oracle databases (Installation, Upgrade and management) on Windows, Linux, Sun and AIX independently and 300 databases during on-call week.
• Upgraded 40 databases to Oracle 10g from Oracle 9i. Worked on various new projects to configure Oracle database on Windows, Linux, Sun and AIX.
• Monitored and maintained databases using tablespace monitoring script, analyze tables script, rebuild indexes script, stats pack reports, grid control, and using the tools like PETROL. Manage database availability, physical structures and storage based on database design. Managing tablespaces, database users, and controlling and monitoring their actions.
• Microsoft SQL 2005 server installation, implementation, conversion, backup and recovery, troubleshooting, performance tuning, system design, replication, and experience with clustering in a high availability environment.
• Developed technical and functional specifications for data acquisition, transformation, and load processes from a variety of sources including but not limited to XML file, CSV, Oracle, and MSSQL.
• Developed a strategy dictated by business, operational, and technical requirements. Used new features in Oracle XML DB, SQL functions to update the XML data in database & Oracle streams AQ for message queuing functionality using Enqueue & Dequeue functions.
• Setting up snap shot and stats pack report for performance tuning of the database. Excellent communication & documentation skills to gather requirements and successfully implemented internal customer needs. Worked on major releases which involve coordination with analysts, system designers, software engineers, and project managers.
• Responsible for DBMS installation, sizing, and building data bases and tables, monitoring, tuning, and performance management of the DB environment, deploying scripts and other mechanized means for automated detection and alarming of variance conditions.
• Participated in DB recovery efforts and the resolution of other DB-related problem occurrences identification and elimination of root cause problems in application DB environments, coordination and requirements definition with client. Documented daily production issues and its solutions.