Post Job Free

Resume

Sign in

Customer Service Sql Server

Location:
Omaha, NE
Posted:
July 03, 2023

Contact this candidate

Resume:

Praveer Rapoor

Director - Union Pacific RailRoad

Omaha, NE 68135

adx2qs@r.postjobfree.com

+1-402-***-****

I.T. DIRECTOR • SENIOR MANAGER

Focused on providing value to clients in intensely-competitive industries Expert in aligning technology strategies with corporate goals and driving major initiatives through dispersed and complex enterprises. Innovative and highly motivated with a consistent history of producing results.

I believe and exercised in creating employee-oriented, high-performance culture emphasizing diversity, goal attainment and superior workforce optimization. Utilized process-oriented approach transforming project tasks/road blocks into specific sub-tasks/negotiations that facilitated in accomplishing bigger goals.

History of accelerating customer service levels, and leveraging existing technology and knowledge base with internal resources to facilitate business excellence and competitive advantage. A friendly and approachable "go-to resource" who brings subject matter expertise in I.T., Infra- structure Database Management, and software development. Familiar with databases, ERP packages, and Reporting Tools.

Work Experience

Director

Union Pacific RailRoad - Omaha, NE

April 2016 to Present

Led, motivated, and energized 5 IT Managers who supported areas in Database Management, Infra structure software development and Vendor products such OBIEE, Hyperion, SQL Server and Informatica projects

• Developed Goals for Managers so they can develop with Project plan with the tasks

• Managed Teams that implemented Oracle and SQL Server migration projects

• Budget development, vendor and partner relationship building and management

• Supervised the Managers and guiding them thru in completing the projects

• Managed ON and Offshore Teams. Coached Interns

• Elevated customer satisfaction every year thru Customer Satisfaction Survey. Played an active role in boosting satisfaction from 60% to 100% in two years Lowered software maintenance fees 20% by reviewing the license agreements and changing applications to site-licensed software

• Managed this project to integrate a newly-acquired Reporting Tool for Marketing Department -supported software, and data archival to meet exacting requirements of the Customers

• Identified priorities associated with business-critical system usage so that vital maintenance could be performed during periods of dormant activity

• Averted downtime for business-critical applications, by promptly responding to a hardware failure and commencing reactivity in just 5 hours

• Eliminated the need for 7 additional employees by repurposing them to different groups and then supported the services thru Managed services and off and on shore model. SENIOR PROJECT MANAGER, TECHNICAL PRODUCT MANAGER

TPM

April 2012 to October 2016

Union Pacific Rail Road

• Responsibilities involves planning, measuring the deliverables and performance evaluation of direct reports (SMART)

• Managed projects using Waterfall and Agile methodologies

• Managed ETL onshore and offshore Teams (Datamirror and Informatica)

• Migrate Oracle and SQL Server Databases projects

• Migrate OBIEE migration from windows to Linux platform projects

• Lead the planning, design of Infrastructure layout and product management of Oracle Business Intelligence and Hyperion

• Lead project team planning, develop and implement using the internal project staff

• Met regularly with interdepartmental work group to monitor and evaluate the product, discuss policy issues and recommend service improvements

• As lead, spearheaded and directed implementation of OBIEE 11G upgrade, resulting in greater speed and access to information for both internal site and outside clients using mobile devices

• Developed and implemented new batch programs, working closely with project Tech leads to select and refine services offered, monitor effectiveness, and institute systems to improve services for customers

• Initiated cross-training with other departments to improve work flow and streamline project completion

• Directed OBIEE 11G and 12c implementation, including research and analysis of existing process. Maintained strong commitment to accuracy, detail, confidentiality and timeliness of completion

• Organized training classes on usage of OBIEE 11g for BI Developers across departments such as Enterprise, Safety, Engineering, Mechanical, Trasentric and Intermodal.

• As OBIEE TPM performed consistency and user-friendliness information of outgoing information and documentation

• Documented and mentored and knowledge sharing with colleagues Senior Oracle and Senior SQL Server DBA

Production and Development

April 2004 to October 2012

Union Pacific Rail Road

Managed and maintained critical production applications. Managed and monitored the data flow from several data sources to targets. Ensured data being transmitted to several downstream systems by monitoring (24x7) the critical applications using Data Mirror replication tool. UP supported Applications

MCS, LCM, ITMS, BTP, NMS, ONB, WDL, ODS, SHN, BPEL, RYM, WDI, RIMS, RSP, GENESIS, SAP-ADX, SAP- APX, AOW, LCM, NCSC and UP Portal

• Coordinated, managed and migrated SQL 2000 packages to SQL 2008 packages

• Project life cycle to maintain deliverables on Development activities

• Developed several Infrastructure related objects to support various systems

• Conducted Team identifying quarterly and year goals (beginning of the year)

• Conducted weekly Team meeting and project review with application Team

• Attend/Address Customer meetings and gather requirements and issues

• Software Installations/Upgrades, capacity planning,

• Ongoing monitoring & alerting improvements

• System Health Management, System Performance & Tuning

• Problem Management, License Compliance Management

• Mentored and knowledge transfer to the Team

• Managed onshore and offshore Teams

Senior Consultant / Principal Consultant

Oracle Corporation / ACS Corporation

January 1996 to February 2004

Managed and maintained ACPINS (Automated Computer generated Identification) system. The system supports worldwide customers. Primarily, the system keeps track of orders, delivery and inventory system.

• Software Upgrade: Managed a team of 6 through all phases of a $4 million upgrade in the transportation software for Tinker AFB

• Database Development: Guided a team of 4 in the development of relational database management systems (RDBMS) for a multi-billion dollar global staffing firm

• Infrastructure: Led a team at Oracle Head quarters in developing and completing Service Request modules (ERP - CRM Customer Service)

Education

Diploma in Computer Science in Computer Science

NIIT

December 1989

Bachelor of Science

Osmania University

April 1988

Additional Information

AREAS OF EXPERTISE

• Strategic Planning / Visioning & Tactical Execution

• Problem & Change Management

• SLA Authoring & Resource Allocation

• Team-Building Leadership

• Manpower Planning & Scheduling

• Software &Application Lifecycle Management

• Expense Budgeting & Forecasting

• Technology Upgrades



Contact this candidate