SUMMARY:

Technically astute Senior IT Professional with solid history of driving pioneering programs, divestitures and mergers, leading business analysis, system development, and go - to-market strategies. Over 20 years of experience leveraging technology in the development of customized solutions for complex projects and delivering key milestones on the technology roadmap. Broad knowledge and success in partnering with internal and external stakeholders, and translating strategic initiatives into executable and measurable tactics that results in increased ROI. Trainer and leader focused on accelerating team members’ professional growth.

AREAS OF EXPERTISE:

• Team/Resource Management
• Client and Vendor Relationship Management
• Business Analysis / BI Analysis
• PCI/PII compliance
• Product Development/Management
• Program/Project Management (Agile framework & Waterfall)
• Software Package Selection
• ISO9001 & CMM Standards

PROFESSIONAL EXPERIENCE:

Confidential, Mason, OH

Team lead, Data Migration and support

Responsibilities:

• Led a team of developers at Anthem to migrate PMIS application from Teradata to Oracle 12C .
• PMIS - Performance Management Information System - Provides associates and management accurate performance data for ongoing reviews and feedback.
• The primary purpose of the PMIS application is to accurately and fairly record the various types of work being done and to standardize the performance assessment methodology.
• The functionality of PMIS is to understand the CLAIMS and process the same.
• The data is stored in the PMIS base tables. Reports are generated on these base tables to generate a dashboard or scorecard of each associate.
• In order to normalize time and productive reporting, claim records will be transferred from applications throughout the organization into PMIS.There are 6 source systems that feed into PMIS namely ACES, CS90, FACETS, NASCO, WGS and MTM.
• Involved in logical database design using Erwin, E-R model review and extracting scripts, DWH Modeling and creating Database objects according.
• Involved in decision making on database configuration, feature and abilities as per application needs and compliance.
• Modifying shell scripts, convert Teradata BTEQ scripts to Oracle stored procedures, Modifying Informatica ETL mappings, Oracle Performance tuning, Control-M job creation
• Migrate data from Teradata to Oracle using Export/Import and SQL*LOADER
• Analyzing Database and SQL performance tuning based on reports generated by SQL Trace, TKPROF, AWR, ADDM, ASH, SQL-T, and Explain Plan and validating database parameters when slowness issues reported or alerted.
• Implemented Backup & Recovery strategies

Principal Consultant

Confidential

Responsibilities:

• Migrated a cooperative banking data from SQL Server to Oracle .
• Written Shell scripts and PL/SQL Programming to resolve business problems of various natures and to monitor activity like availability of database, space utilization, gathering statistic for the cost base optimizer, index rebuilding and batch job scheduling with tool called Tidal.
• Configuring TNSNAMES.ORA, LISTNER.ORA, SQL *NET for network connectivity.
• Created Materialized Views, Partitioned tables, DB links and other database objects.
• Conducted daily routine checks on Alert logs and Trace files.
• Involved in resolving daily user issues in Dev, QA and Prod databases.
• Monitored replication tools like Oracle Golden gate and Quest Shareplex.
• Defining and Implementation of recovery strategies with and without catalog RMAN and FLASHBACK recovery.
• Developed Learning Management Systems for various IT technologies and Data Warehousing Tools .
• Developed Training Infrastructure and Organized Training Programs for Advanced Database Learning in multiple cities

Senior Manager

Confidential

Responsibilities:

• Lead design, architecture and development of Price Planning product (technology components includes - Analytic Workspace/OLAP, OWB/ETL tool, BI Beans, JSP, JavaScript, SVG, Data Mining algorithms)
• Successfully implemented technical design review, architecture review, code and unit test plan review processes.
• Provide leadership and direction to a highly motivated and forward-thinking team. Hired, mentored and retained the top talent.
• Worked effectively with operations teams to resolve environment issues and with release teams to optimize the release processes for the product.
• Identify operational improvement opportunities in overall CRM development organization and lead initiatives to improve productivity and operational efficiency by proactive planning, monitoring, risk management and performance management.
• Responsible for project planning, tracking project progress, resource allocation, cross training, risk management, conflict/issue resolution, and ensuring that project is completed on time, on budget with high quality

Senior Manager

Confidential, San Jose, CA

Responsibilities:

• Implemented a Data Conversion and migration project for a Guthy Renker, a global Direct Marketing company.
• Guthy Renker had acquired multiple companies in Europe and US .As part of the consolidation effort migrated data from SQL Server, SAP into ORACLE .
• Managed database administration and developments effort activities within scope and budget.
• Developed a custom ERP solution for a Golf course using .Net and SQLServer. Implemented Inventory, Accounts Payable and Accounts receivables . Developed a Tee time booking module and implemented on the website and mobile app for Iphone and Android .
• Worked with various organizations to develop Scorm complaint ELearning content . The content was developed using 2D and 3D animations.

Senior Manager

Confidential, Dallas, TX

Responsibilities:

• Managed Oracle database administrators on various infrastructure projects improving service level agreements by reducing time to deliver IT solutions to business.
• Supported BT Mobile bundling application by closely working with business unit .
• Used Oracle utilities like Export/import (traditional and data pump) and SQL*LOADER.
• Developed stronger ties between customers and Infrastructure team resulting in collaborating and working together to effectively use IT for business.
• Conducted interviews and participated in hiring decisions along with HR in order to retain the best talent in the organization.
• Participated in quarterly meetings with Senior Management to discuss technical infrastructure and market recommendations assisting in the formation of the technology roadmap
• Managed change control meetings ensuring that changes to production environments are validated and thoroughly tested. This effort reduced the number of outages by over 25%.

Principal Consultant

Confidential, Dallas, TX

Responsibilities:

• Responsible for customer data service management, project/program management, people management and infrastructure availability.
• Responsible for creating a Datamart for Confidential .
• Responsibilities included data modeling, creation of objects and coding to populate the Datamart.
• Developed Oracle Stored procedures to populate the Datamart.
• Additional responsibility included resolving Database outages, SQL tuning and Database tuning.

Senior Technical Manager

Confidential, Irving, TX

Responsibilities:

• Effectively managed multiple groups comprising of Database Administrators (Oracle, SQL Server & DB2), System Administrators (UNIX & Intel) and Developers (Java, .NET & PL/SQL).
• Installation, configuration and maintenance of Oracle 9i/10g standalone and Oracle 10g RAC Databases with and without ASM.
• Involved in Upgrading and Migration of older version Oracle databases,
• Applied PSU/CPU Patches, ASM Patches, Grid Infrastructure Patches and one-off Patches.
• Configuration of Oracle Data Guard for databases to ensure high availability and disaster recovery.
• Responsible for consolidation of multiple Broadband Order entry systems of former Bell Atlantic and former GTE companies.
• Converted millions of customers with zero fallout.
• Responsible for implementing the Order entry system for Verizon’s flagship product, Fiber to the premise.
• Managed the Product Catalog, DBA and conversion teams.
• Responsible for maintaining the ARBOR Broadband billing systems, multiple databases on multiple servers.
• Spearheaded the Performance tuning of the database, application code and batch jobs.
• Responsible for implementing a Data Warehouse for Broadband products.
• Enabled Business to take strategic decisions by generating up to the hour reports.
• Maintained DSL provisioning system, Usage Based billing system, Remedy Trouble ticketing system.
• Responsible for overall project management and performance of Data Reconciliation Tool. This tool was developed to identify the discrepancies in DSL Ordering, Billing and Provisioning systems. Guided all phases of the project life cycle including business development, scope definition, systems analysis, testing, documentation, user training, and implementation and clarified the transformation rules for all target data objects and developed software components to support the transformation
• Responsible for migrating all the existing Customers with DATA products (DSL, ATM, FRAME RELAY, Hibac and TLS) into a new system . Converted the embedded base customers from CABS & CBSS billing systems. Generated pre and post conversion reports for business to reconcile the data and work on fallouts. As a database administrator, involved in regular maintenance work and making schema changes as part of monthly releases.

Programmer Analyst

Confidential, Fort Worth, TX

Responsibilities:

• Responsible for maintaining Oracle Inventory and purchasing modules for Confidential .
• Maintained General Ledger and Oracle Payables modules.
• Customized forms and reports.
• Involved in labor management project, wherein developed stored procedures to accurately track and report the employee time management.