Summary
Overview
Work History
Education
Skills
Cell
Areas Of Interest
Domains
Volunteer Experience
Timeline
Generic

Mohan Penta

San Antonio,TX

Summary

25+ Years of experience in Information Technology in several roles as Database Administrator, Data Engineer Lead, Data Architect, DB Solution Engineer, Design, Application Development, Database Administration, Product Development and Management, Java Web Services development, REST, SOAP, integration and consolidating systems.

Overview

17
17
years of professional experience

Work History

Application Technical Architect

WPS
  • Integrys Energy Group (formerly WPS) is a leading regulated natural gas utility company serving in various states
  • Developed and maintain PowerNet Application, which stores, measures, and captures people’s data and sends to various departments within organization
  • Developed and maintained WPD’ Internet Applications.

Application Technical Architect

WPS
  • Integrys Energy Group (formerly WPS) is a leading regulated natural gas utility company serving in various states
  • Developed and maintain PowerNet Application, which stores, measures, and captures people’s data and sends to various departments within organization
  • Developed and maintained WPD’ Internet Applications.

IT Department Project Lead

Kohler
  • Responsible for developing and maintaining the Applications for various departments in the manufacturing company Kohler
  • Worked with different departments/divisions within the organization providing quick, efficient solutions by developing and interfacing with other applications.

Application DB Consultant

SBC
  • Developed and maintained TechScore Application that measures performance of a technician in SBC
  • TechScore consists of multiple Applications, SBC ASI, ASI-LFO, Outside Specials, Network Operations Center, Special Services center, Central office, Mass Market, TechScore Issue Minder.

Senior DB Developer/ Application System Analyst

MAYO CLINIC
  • Developed RAS for MAYO that processed Dental, Vision and Medical claims of MAYO employees and clients, 90,000 to 160,000 annually
  • Mayo Hormel Foods implemented Defined Contribution Plan for employees and Mayo Medical/Dental/Vision HRA, Orthodontia HRA, MRMP DAP and Orthodontia HRA included in this project, with Explanation of Benefits produced for paid claims.

Lead Programmer / System Analyst

ECHO GROUP
  • ShareCare California Developmental Disabilities Information is online service that allows behavioral healthcare programs and providers to use access center, electronic clinical records, billing, and management applications over Internet (used by organizations that either do not have information system infrastructure or do not want responsibility of managing their own data center and network)
  • Users access ShareCare via Internet, is web-based application, and not web-enabled
  • AMASE 32 Fund Accounting is an integrated financial software suite designed to manage intricacies of fund accounting, financial management, human resources, purchases, and reporting needs
  • Responsible for making enhancements and modifying existing functionality of ShareCare and Amase32 Application.

Sr. Programmer / System Analyst

WIND RIVER
  • Wind River is a public company with diverse products to its clients in Network Infrastructure, Digital Consumer, Automotive, Industrial, and Aerospace, with customized platforms and real-time operating systems
  • I developed and enhanced Internet and Intranet applications for manufacturing, web sales, and HRIS Application.

Sr. Programmer / System Analyst

PREFERRED TRADE
  • Responsible for developing Internet websites and maintain and enhanced four intranet websites ran by Preferred Capital Markets Inc., maintained Interwoven Content Management, and enhanced four other Intranet websites run by Preferred.

Programmer / Analyst

EXCITE @ HOME
  • Supported intranet application project, including developing new interfaces, contract and site maintenance, terms and conditions, error management, vendor master, purchase order, inventory movement, item availability
  • Wrote program specifications, coding, unit, and system testing of terms/conditions, error management, contract terms / conditions, work scope, probability of contract signing, contract deal strategy, contract margin, contract requirements, type, terms / conditions, equipment details, contract margin, site details and other contact details.

Programmer / Analyst

UNIVERSITY OF ALABAMA AT BIRMINGHAM
  • Held leading role to maintain and enhance University of Alabama at Birmingham Health System Y2K information website with Y2K compliance information on medical equipment and information systems
  • Application used ColdFusion 4.0 as application server in conjunction with SQL-Server 7.0 database
  • Information collected from various entities in the Health System.

Database Administrator

OVATION FINANCIAL SERVICES
05.2019 - Current
  • Experience within direct or database marketing functions; in a B2B environment is preferred.
    • Possess an understanding of Cloud Data Warehouse methodologies, Data Architecture, Data Modeling and Digital Metadata.
    • Highly skilled at time management, is detail oriented and has high standards for project delivery.
    • 2+ years experience with SQL queries and knowledge of database technologies including window and analytical functions.
    • Self-starter with a passion and curiosity for solving unstructured data problems and the ability to manipulate and optimize large data sets.
    • Process orientated, highly organized, excels at multitasking, strong documentation, coordination and project management skills
    • Strong communication skills and an ability to provide technical guidance, direction and problem-solving to less technical team members
    • Confidence to offer consultation to business partners and team members within Sales, Partner, and Marketing Operations.
    • A familiarity working with AGILE/SCRUM process management
  • Develop and coach offshore development team mentor and engineers to support varied applications
  • Collaborate with the development team and translate requirements created by business analysts
  • Mentor and provide solutions within and outside of teams on DB Performance areas
  • Perform maintenance, patching and upgrading of Oracle12gR1 database for six departments
  • Execute requirements planning and database upgrades for three internal databases
  • Troubleshoot database structure issues and data retrieval, reducing mean time to resolve by 20%
  • Extensive Experience with moving marketing DB from on-prem to Cloud Azure
  • Experience within direct or database marketing functions; in a B2B environment is preferred.
    • Possess an understanding of Cloud Data Warehouse methodologies, Data Architecture, Data Modeling and Digital Metadata.
    • Highly skilled at time management, is detail oriented and has high standards for project delivery.
    • 2+ years experience with SQL queries and knowledge of database technologies including window and analytical functions.
    • Self-starter with a passion and curiosity for solving unstructured data problems and the ability to manipulate and optimize large data sets.
    • Process orientated, highly organized, excels at multitasking, strong documentation, coordination and project management skills
    • Strong communication skills and an ability to provide technical guidance, direction and problem-solving to less technical team members
    • Confidence to offer consultation to business partners and team members within Sales, Partner, and Marketing Operations.
    • A familiarity working with AGILE/SCRUM process management
  • Migrated DB from SQL on-perm to cloud
  • Used Data Stage director and its run-time engine to schedule running the solution, testing, and debugging its components, and monitoring the resulting executable versions on ad hoc or scheduled basis
  • Designed and developed Data stage jobs to Extract data from heterogeneous sources, applied transformation logic to extract data, and loaded it into Data Warehouse DB’s
  • Experienced in creating technical specifications and design documents throughout all the phases of the SDLC process
  • Efficient in integration on Azure for cloud services, including computing, analytics, storage, and networking
  • Develop programming specifications
  • Design, code, and unit test application code using Software Development Life Cycle (SDLC) best practices
  • Estimates and work plans with the assistance of more senior team members as appropriate for design, development, implementation, and rollout tasks
  • Expertise in writing PowerShell Scripting and debugging
  • Streamlined data scrapping (190+ County Scrappers) & standardization of the DTR process using ETL
  • Expertise with a connection manager, tasks, control flow, data flow, parameters, event handlers, log-shipping, always On call availability groups, and variables, to execute a task
  • Renegotiated with ITES vendors, resulting in 60% reductions in expenses
  • Set up IT-managed services for five locations
  • Ongoing Projects in Salesforce: Originations Platform for Lead Generation and Automation of Delinquent Taxpayers; Sales Activity Management; Title Request/Title Management; Underwriting, Auditing, Accounting
  • Manage production and operational support teams to maintain systems
  • Worked closely with Data Review Boards and set up a code review session with Junior and Offshore teams
  • Guide team to design, build, and manage data structures encompassing data transformation, data models, schemas, metadata, data quality, and workload management
  • Developing a data warehouse using two records systems and automating clients/banks and internal reports
  • Manage the ticketing system, prioritize enhancements/projects, and allocate work to the development team.

Database Administrator

AT&T Wi-Fi Operations
11.2007 - 05.2019
  • Diverse architecture development for DB Design, Architecture, Database Administration, Implementation, end-user training, support applications and IT during releases within AT&T Wi-Fi Services Organization
  • Started with AT&T on first Wi-Fi Project providing Wi-Fi Connection at Starbucks locations across USA
  • Closely collaborated with Legacy AT&T applications, share data, support/enhance existing applications
  • Mentored and provided solutions within and outside of teams on various data related areas
  • Responsible for gathering requirements and analyzing them to convert into user stories and creating test plans, test data creation and test execution
  • Maintained Data Warehouses by loading dimensions and facts as part of the project
  • Guided several teams within the organization for creating reports to higher management
  • Created various prototypes and POC applications based on initial requirements, presented to management
  • Managed several application issue initiatives that were of significant scope and complexity
  • DB Developer, Architect, design, Administrator, Scrum Master, Product Manager, Lead Developer
  • Expertise in SQL Server Integration Services and SQL Server Reporting Services
  • Lead the team in building processes that support effective data management, metadata management, and good data quality
  • Created DB Venue Builder Templates for almost all the AT&T Wi-Fi Services customers.

Education

MCA - Computer Applications

Kakatiya University
01.1996

Skills

  • Java, Web Services (REST, SOAP) Python, T-SQL, Python, PL/SQL
  • SQL Server 2005, PL/SQL, SSIS Packages, IBM-DataStage ETL Tool, DB2, Oracle DB, DataStage 85, 91, Netezza, Cassandra, Hadoop, Snowflake, PowerShell scripts, Cloud computing, Azure, TearaData, Informatica, DB2
  • Database Administrator, SAFe/agile/scrum/Kanban framework process, MySQL, Hadoop, Python, SQL Server Integration and Reporting Services; Architectural Road maps, Informatica, Analysis and Design, Software Testing Life Cycle, gathering requirements and building pipelines, Application Development Strategies, Methods, Standards, Approaches, and complex system design and Developer, Big Data initiatives and Service-Oriented Architecture (SOA)

Cell

507-261-8115

Areas Of Interest

Data Engineer, IT Project Manager, DB Architecture, Application Developer, Data and Information Architecture.

Domains

Banking/Finance, Telecommunications Wi-Fi, Healthcare, Manufacturing, Nonprofits, State Government.

Volunteer Experience

  • Girl Scouts southwest Texas, Cookie Manager, Current
  • Pinon Creek Homeowners Association, Vice President, Current
  • Health Careers High School, PTSA Membership manager, 2018, 2021
  • Telugu Association of San Antonio, Treasurer, 2010, 2018
  • Telangana Association of Greater San Antonio, Secretary, 2014, 2016

Timeline

Database Administrator

OVATION FINANCIAL SERVICES
05.2019 - Current

Database Administrator

AT&T Wi-Fi Operations
11.2007 - 05.2019

MCA - Computer Applications

Kakatiya University

Application Technical Architect

WPS

Application Technical Architect

WPS

IT Department Project Lead

Kohler

Application DB Consultant

SBC

Senior DB Developer/ Application System Analyst

MAYO CLINIC

Lead Programmer / System Analyst

ECHO GROUP

Sr. Programmer / System Analyst

WIND RIVER

Sr. Programmer / System Analyst

PREFERRED TRADE

Programmer / Analyst

EXCITE @ HOME

Programmer / Analyst

UNIVERSITY OF ALABAMA AT BIRMINGHAM

Similar Profiles

CREATE PROFILE
Mohan Penta