Sudhir Chandraiah

App Development Manager

678-***-****, ad4oc0@r.postjobfree.com, USA,

https://www.linkedin.com/in/sudhirmchandraiah/

SUMMARY

I am a seasoned, organized, motivated, passionate IT professional with a track record of delivering successful software projects on schedule. I am experienced in architecture designing, developing, and managing multiple projects, collaborate with software teams and key stakeholders, leverages deep understanding of database theory, SDLC to lead software development projects across global teams using both Waterfall and Agile methodologies, apply complex problem-solving skills and seeks continuous improvement. I am excited to join a growing team and take on new challenges. Major roles as App Development Manager.

• Provide Project plan [30-60-90 days] - accurate, achievable timeline for project completion.

• Liaison between upper management and development team, communicate accurate status.

• Weekly sessions with stakeholders.

• Oversee onshore and offshore full stack development team.

• Scrum master.

• Coordinate with cross-disciplined team members (Ex: DBA group, InfoSec group) for database administration support, Web Farm group for hosting ..etc.

• Define and lead database architecture strategies and roadmaps.

• Conduct design of database schemas, data modeling and analysis to support business initiatives.

• Design and implementation of robust database systems, ensuring that data is stored efficiently, securely, and is accessible to meet the needs of users and applications.

• Provide technical expertise and recommendations for database management and infrastructure enhancements.

• Analyze and understand the data requirements of the business, and architect a database structure that is scalable, reliable, and facilitates easy retrieval and manipulation of data.

• Research and utilize state-of-the-art technologies to support database efficiency and advancements.

• Monitor and optimize database performance and troubleshoot any issues that arise.

• Implement database security measures, including access controls and encryption.

• Lead initiatives for data migration, integration, and transformation.

• Documentation for database designs, configurations, and procedures for both technical and non-technical stakeholders.

• Disaster recovery planning and testing to ensure data preservation in the event of emergencies or system failures.

• Review Code – adheres to Standards, Performance, Accuracy, Consistency, Reliability and Maintenance.

• Train team members where needed in understanding the applications or technology.

• Hire qualified personnel, build a strong. high performance and dedicated team.

• Manage applications and services using Service Management Catalog (ServiceNow) per (ITSM) and (ITIL) best practices.

• Create User and Customer experience surveys, review feedback with team and act accordingly.

• Study and enhance user experience of dashboards in web/mobile apps. Projects and Special Assignments

UPS Inc (Atlanta, GA)

Role: App Development Manager -

Project: GC3 Calculator 3/1/2021 06/30/2023

Technology: C++, Oracle.

Global Common Cost Calculator An enterprise Activity based Costing model for UPS US Domestic and International Product service contracts. Application was developed in C++ and used in the last 2 decades on Windows and Linux environments.

Achievements:

Oversaw team of 5 developers, rewriting the project to reduce Tech debt of legacy system to migrate into SQL based system in Oracle database.

Designed and implemented a robust database system, to store data efficiently, securely, and is accessible to meet the needs of users and applications. Designed and implemented a robust bid (service contracts) processing system in Oracle database utilizing advanced PL/SQL programing.

Create Knowledge Transfer videos for new hires which reduced KT session period by 70%. Utilize Agile project management framework with Microsoft Team Foundation Server (TFS) to collaborate and coordinate with Onshore and Offshore teams, which increased team performance by about 25%.

Project: International Revenue Recovery Model, 4/15/2021 6/30/2021 Role: App Development Manager

Technology: Oracle Business Intelligence (OBIEE Suite, Reporting and Analysis system) Added International Revenue Recovery perspective and reporting capabilities in Oracle Business Intelligence Suite (OBIEE) for International Small Package Revenue recovery group. This involved creating a new model, database infrastructure, ETL processes and creating new Subject Area in OBIEE. Achievements:

• Designed, developed, and implemented a robust star schema-based database/data warehouse to store data efficiently, securely.

• Designed, developed/created database artifacts - tables, tablespaces, partitions, procedures/functions, and supporting ETL processes.

• Successfully trained Lead developer on

o adding Subject Area, creating Physical, Business and Presentation layers and Setup security in OBIEE.

o Administer OBIEE System.

Lead developer was involved in multiple projects, training the resource in house saved on external training costs and increased percent of utilization of the resources on multiple projects.

• Trained business users on creating dashboards and reports for the needs of business groups.

• Prototype dashboards based on user experience.

Training business groups in-house saved on external training costs and was a hands-on experience for the users where they could create meaningful dashboards and reports. Project: Daily Profit Plan (DPF) 1/2/2019 3/31/2021 Role: App Development Manager

Technology: Web App, Developed Using .Net, C# – MVC architecture, ExtJS, MS SQL Server database. Took over the responsibilities on DPF App which has been in operation for 2 years. App captures Daily Vol/Rev and expenses by product for US domestic services. Provides various KPI’s in the form of graphical views, charts and reports in PDF and Excel for daily, weekly, and monthly time periods with drill down capabilities of KPI’s from Corp level to customer level. Data is consumed daily by upper management, groups like Operations, IE’s, Marketing and Sales. Achievements:

Oversaw developer team of 3 to successfully add End of Week (EOW), End of Month (EOM) View and What if Analysis features to KPI dashboards.

• Interacted with Users/Customers, created design workflow, prototype UI and dashboards. Get approval and implement in application development.

• Designed and created functional specs to create database artifacts - tables, tablespaces, partitions, procedures/functions (API’s) to support the new application features listed below.

• The EOW view allows users to view the current week’s Vol/Rev forecast, which is aligned to the outlook from the Corporate Forecasting group.

• The EOM view will allow users to view how the month is expected to end based on the actuals from completed weeks, the current week’s outlook, and the Plan for the future weeks in the month.

• Redesigned Operation stats to consolidate performance measurement against profit plan, business plan and LY. This streamlined view provides visibility to all measurements without the need to toggle between numerous filters when evaluating the impact on expense from productivity, wages and volume.

• Designed a What if analysis and NRPP (Net Rev Per Piece by segment) analysis dashboards. o Add enhanced feature for What if scenario with Incremental Vol/Rev method. o NRPP (Net Rev Per Piece by segment) analysis dashboards facilitate venue to change and analyze various key facts (Volume, Revenue, Costs etc..) and view resulting change in KPI’s by business segment.

The visibility of the KPI’s from the above features provides greater insight into current/daily business performance to upper management which was crucial to making decisions daily. Project: Financial Dashboard (FDB) 9/3/2018 3/31/2021 Technology: Web App developed using .Net, C# - MVC architecture, ExtJS, MS SQL Server database. Role: App Development Manager

Took over the responsibilities FDB App which had been in operation for two years. The Financial Dashboard provides details of UPS US Domestic product/services business operations from center level to Corp level. App Captures details of Operational and Non-Operational costs, Volume and Revenue and Third-party costs.

Achievements:

Oversaw developer team of 3 to successfully add below features –,

• Designed and created functional specs to create database artifacts - tables, tablespaces, partitions, procedures/functions (API’s) to support the new application features listed below.

• End of Month (EOM) View EOM defines the period from current date till last date of the month.

• Weekly Pay View

o Display the data received from company books financial systems - weekly GL Journals for Payroll Expenses.

• Rolling Four Months View Provides data for Daily, Weekly and Monthly time periods for a future 120 Days.

• Designed and developed - Leverage Report in Excel for IE with GAP hours and Plan Report produces Complete detail operational performances for Daily, Week to Date and Month to date.

These enhanced perspectives and reports gave in depth visibility to Business users and management; Instrumental in business decision making process by comparing business unit’s performances. Role: Sr. Programmer Analyst (Team Lead) - 08/2004 – 08/2018 Technology: Oracle Business Intelligence Enterprise Edition Suite Responsibility: Production support, Administration, develop, oversee development team, train - development team and users.

Instrumental in complete OBIEE system setup and Administration for Freight Forwarding and Logistics business units. RPD development – Developed Freight Forwarding and Logistics business unit Subject Area’s, dashboards, and reports in OBIEE for various users of UPS domestic and international business units.

• Designed, developed, and implemented a robust star schema-based database/data warehouse to store data efficiently, securely.

• Designed, developed/created database artifacts - tables, tablespaces, partitions, procedures/functions, and supporting ETL processes.

• Developed complete user security and administration system. Peak Assignment: Amazon hub, Chattanooga, TN 10/2016 – 01/2017 Assist in peak operations of UPS small packages in Amazon hub – Track daily package volumes, check trailer availability, open/close package loading to trailers. Make sure package loading is completed and accounted for by departure time. Provide hourly reporting to operations management. Project: Global Price Optimization Calibration Tool - 5/1/2014 6/15/2015. Technology: Web based tool developed in .Net, MVC architecture, MS SQL Server database. Lead development and implementation of Global Price Optimization Calibration Tool, developed for Revenue Management group to provide Sales and AE’s to price UPS products to customers at different locations. The system implements business rules for product pricing by Locations and Services. Users can instantly see the impact of the sales offer to revenue and OR’s and compare different offers. Responsibilities:

• Design UI per business requirement.

• Create Spec for developers to code in MS SQL/C#

• Resolve any impediments and make sure tasks are completed as agreed upon timeline.

• Assist team where needed [technical areas like SQL tuning, logic building].

• Review code and testing.

• Production release upon approval.

• Report status to upper management.

Project: OBI SOAP Web Service 3/17/2008 8/24/2009 Technology: Web Service developed using .Net, C#, OBIEE SOAP API, Oracle database. The web service was developed to address OBIEE licensing. The IFA OBI system was supporting worldwide users and many end user’s needs were final reports in Excel spreadsheet. Users who didn’t need OBI analysis capabilities were using Predeveloped Excel report templates which gave access to same data through this service but without a need for OBIEE license. Both parts used the same security features for authentication and access level. This helped reduce costs by limiting the number of OBI licenses. The service has two parts; one part interacts with OBIEE using OBIEE SOAP API to feed ISP report. Another part interacts with database directly to feed Forwarding and Logistics reports. Responsibilities:

• Designed, Developed and Implemented SOA (Service Oriented Architecture) based service in asp.net using Visual Studio (C#) to service MS Excel templates for reporting ISP, Forwarding and Logistics financials/Stats.

International Experience and Exposure

Singapore - worked as Sr. Software Engineer Managed development and implementation of various turnkey projects [Embedded Systems and System Integration] Flight Information Display System for Changi Airport, Singapore. Auto parking and Autopay system for various clients in Singapore. Port licensing system for Singapore Port Authority, Singapore. Employee access system for Motorola Corporation, Tianjin China. Student access system for Hong Kong University, Hong Kong China. Management Skills

• Experienced in full SDLC covering planning, requirements gathering, system design and architecture, configuration/development, testing (Code review, functional/Security testing), go live and support.

• Project planning using MS Project. Define project scope, timeline, resource coordination, provide accurate status to upper management and team, define roadmap for project delivery and manage delivery/deployment.

• Prioritize business requests (RFC’s) for new features and application issues submitted by users.

• Experienced using Service Management Catalog – which implements and utilizes IT Service Management (ITSM) and IT Infrastructure Library (ITIL) best practices to manage services and support UPS IT infrastructure.

• Utilize MS Team Foundation Server (TFS) for day-to-day team management.

• Oversee Offshore/Onshore developers (Third party vendors/contractors).

• Mentor/Train developers, analysts, users on different tools and technology.

• Conduct meetings with various groups like business stakeholders, DBA’s, IT Security etc.. to understand business issues, infrastructure issues or security issues, provide status updates on projects in progress.

• Day today Management of employees in the team through Workday. Technical Skills

• Microsoft SQL Server 2012 (5+ years) - Proficiency: 3. Advanced–in depth knowledge with hands on experience; able to handle most complex tasks. Well experienced in developing complex SQLs at various levels for processing/solving complex issues, creating database artifacts.

• Oracle database (20 + years) – SQL, PL/SQL [Earlier versions through 19C] [Windows and Exadata platform] - Proficiency: 3, Advanced–in depth knowledge with hands on experience; able to handle most complex tasks. Well experienced in developing complex SQL’s, utilize PL/SQL at various levels for processing/solving complex issues, use of Collections, Jobs and creating database artifacts.

• Oracle Business Intelligence (OBIEE) (15+ years) - Proficiency: 4, Expert–mastery knowledge with hands on experience; able to handle all tasks and coach others. Hands-on experience in architecting OBIEE environment, setting up security features, developing RPD, dashboards, reports. Creating database infrastructure/artifacts. Administering OBIEE system, using Oracle Fusion middleware.

• Other – SOAP (Simple Object Access Protocol) API, VBA, SSIS

• Languages - C, C# (.Net), C++, Delphi, Java, Java Script, VBA, R, SQL, PL/SQL

• ETL – Informatica (3 years)

• Tools - Visual Studio (2017), Eclipse, TOAD, PL SQL Developer, SSMS, MS Team Foundation Server (TFS), MS Office (365), Burp suite, MS Teams. Education: MS in Computer Applications, B. Sc. In Electronics. External Training and Development

Google Cloud Platform Architect – In progress

Google Cloud Platform – Kubernetes – In progress

Machine Learning – In progress

Microsoft Power BI 3/1/2021 5/31/2021

Next Steps in SAP HANA Cloud Platform (Online Class by SAP) 6/12/2014 7/31/2014 SAP HANA Native Development

Advanced Identity Management

Securing Web APIs

Introduction to Mobile Solution Development for the Enterprise (Online Class by SAP) 9/15/2013 10/31/2013

Introduction to Mobile Development

Creating an Enterprise ready Application, OData

Client Design and Implementation Choices

Enterprise Security Concept & Outlook

Introduction to Software Development on SAP HANA (Online Class by SAP) 5/31/2013 7/15/2013 Developing Applications for SAP HANA

Database Tasks, Loading, and Modeling

Exposing and Consuming Data with OData

Exposing and Consuming Data with Server Side JavaScript Community Leadership Roles

UPSPAC Department Coordinator 6/15/2018 8/15/2021 Details: Coordinate UPSPAC fund rise drive for BIA department Role : Vice President 1/1/2007 12/31/2008

Organization Name: VSNA GA Chapter

VSNA Veerashaiva Samaja of North America, GA Chapter, an association related to Veerashaiva community founded in 1978 in the USA. Served as Vice President for the local chapter of Georgia.

Contact this candidate