Manmohan Mann Email & Phone Number

Detroit, Mi, Us

Detroit, Mi, Us

• Provide operational and development (DevOps) support of tolling and trip building applications for the Washington State Department of Transportation (WSDOT) and Riverside County Transportation Commission (RCTC)• Worked independently, within small teams, and cross-functional teams to mitigate and root cause production issues to meet service level agreements.• Reviewed and provided suggestions for standardization to ease development and management of the code base.• Quickly learned the high-level technical and business rules of the application and provided knowledge transfer to team members.• Translated complex technical issues to the appropriate business language so that the business facing accounts could effectively communicate issues to the end customers.• Supported multiple application teams enhancing interfaces between lane-side, application, database, and the back-office billing departments.

Detroit, Michigan, Us

• Supported development and enhancements of an application to allow business users to author soft parts for flashing ECMs at dealerships and over-the-air in a mix of OLTP and Data Warehouse environments.• Provided input into the OLTP and Data Warehouse data model designs utilizing Erwin.• Performance tuning of the OLTP and Data Warehouse environments by reviewing and updating stats, creation of appropriate indexes, and overall design of table and index structures.• Utilized DB Links, Golden Gate, and IBM DataStage to facilitate data migration (via ETL processing) from the OLTP environments into the Data Warehouse environments.• Provided database (Oracle 12c) support from both a development and operational perspective utilizing SQL, SQL*Plus, PL/SQL, Partitioning, indexing, SQL Developer, TOAD for Oracle, and OEM.• Utilized Oracle Context for enhanced search functionality.• Developed interfaces and ETL processes between multiple systems and applications (Both within and outside the company) to either obtain the necessary information and/or share with delivery and external systems.• Interfaced with the database and Golden Gate teams to setup and support 10+ interfaces to facilitate continuous data migration functionality.• Developed UNIX scripts (Kornshell and Bash) to both push data into the database and pull data to interface with other vendors, systems, and applications.• Utilized SVN for configuration management of database source code.• Performed database deployments in SIT, UAT, Pre-Prod, and Production environments by creating the necessary change tickets and packaging of database DDL and DML scripts.• Supported access for QA team and business users by creating the necessary roles and database ids.• Created and provided tablespace creation scripts to the DBA team.• As necessary, added space to existing tablespaces.• Researched and resolved production issues, in part by generation and analysis of AWR and ADDM reports.

Houston, Texas, Us

• Supported a proof of concept to utilize Golden Gate as an interface between SQL Server and Oracle.• Supported the divesture of multiple business divisions by splitting existing databases and writing PL/SQL and SQL code to facilitate the movement of data between the existing and new databases.• Team member in the development and enhancement (SQL, PL/SQL, Windows batch scripts) of an application to manage warranty claims, document root cause, and share warranty cost with suppliers.• Provided database support for the migration of an application from a SUN and Oracle 9g to a LINUX and Oracle 10g platform. (single node with ASM.) And subsequent upgrade to 11g.• Team member on multiple projects in OLTP, Data Warehouse, and Data Mart environments; in part utilizing ETL processes to massage and migrate data.

• Supported the transition of the support of applications and databases to DBAs in India.• Implemented Transparent Data Encryption (TDE) to support the storage of PII information.• Supported tech refresh of OnStar to a new set of servers and databases.• Production support of Sprint databases including setting up new databases and replicating existing databases using RMAN.• Enhancements to an application used to classify and categorize vehicle parts.• Supported development and enhancements of an application to allow engineers to find vehicle parts.• Enhancements to an application to allow engineers to identify and use existing parts.• Generation of XML files to feed from a product development database to Teamcenter, a product lifecycle management (PLM) system.• Supported development and enhancements of an application to allow business users to categorize and prioritize warranty claims for quick and broad resolution.

West Hartford, Us

Supported applications for Oracle 7, 8i, 9i, 10g and 11g databases.• Generated and utilized Statspack and then AWR and ADDM reports to monitor and tune database systems according to customer’s business requirements• Performed run-time-improvements (RTI) of problematic SQL statements and database health checks for customers.• Created database users and roles. • Designed and implemented roles to enhance database security infrastructure.• Planned, managed and supported migration of Oracle databases from version 6 through 11.2 and implemented Oracle patches.• Monitored backup jobs.• Assisted in the design of an archival strategy.• Interfaced with local and off-shore DBA resources in India and China.

West Hartford, Us

• Participated in the development of an interface between an MVS-based system and a web-based, SQL Server system using Pro*C, Oracle Forms 6i and KORN shell scripts.• Developed an interface to load data from a Manufacturing ERP system into MAXIMO.

West Hartford, Us

• Enhanced manufacturing reports on intranet web sites.• Helped a major diesel engine manufacturer meet federally mandated stricter fuel efficiency standards.• Responsible for enhancements to HTML and ASP web pages, DTS packages and SQL Server stored procedures.• Helped develop and coordinate test plans for a migration from SQL Server 7.0, Windows NT to SQL Server 2000 and Windows 2000.

West Hartford, Us

• Lead a major enhancement to interface an automatic feed between a CMS|Oracle-based procurement tracking system and a web-based ordering system.• Functioned in a Configuration Management role (using Visual Sourcesafe) to insure control of all project documents and source code.• Played a major role in Y2K remediation activities.• Interfaced with the customer to resolve business and technical issues.• Participated in a successful CMM Level 2 Assessment.• Helped in the preparation, coordination, and testing for DRA drills.• Responsible for monitoring jobs and taking appropriate actions to correct and document abended jobs.

• Part of a three-member team that worked on the full life cycle development of the Officer Aggregate Analysis Tool (OAAT), a manpower-forecasting tool.• Used DELPHI as the front end, MS ACCESS 2.0 (with ODBC) as the database, and AMPL/C-PLEX as the formulator/optimizer.• Met with Headquarters, Department of the Army (HQDA) Decision Support System (DSS) decision-makers to gather requirements.• Responsible for choosing and developing the database design (using Erwin for Power Builder) and designing and developing over 50% of the forms.

• Worked on The Officer Projection Specialty System (TOPSS) and the Officer Projection-Aggregate Level System (OPALS), manpower-forecasting tools used by HQDA/DSS.• Specific duties included designing, developing, coding, testing, maintaining, and documenting programs written in PL/I, REXX, and JCL in both a VM/CMS and a MVS/TSO environment.• Designed and coded User Control interfaces using DMS, ISPF, PL/I, and REXX with embedded SQL/DS in a VM/CMS environment.• Contributed to the development of training materials for TOPSS and OPALS users.• Helped the System Operator with getting monthly production runs out on schedule and in the day-to-day operation of the systems.