Phani Varanasi Email & Phone Number

Greater Denver Area

Led BI/DW, Cloud Services and EAI teams through the design, development, implementation, and administration of strategic data assets and applications.With cloud-first strategy, architected BI and Application Integration strategy using Microsoft Azure cloud.Directed creation of predictive maintenance solutions that utilized IoT and Telematics.Led team of 30 architects, analysts, developers, and testers through the project. Supervised the integration of 20 different systems (over 150 interfaces and 100 reports delivered) and consolidated data from over 15 systems into a data warehousing system.Automation created approximately $3M in cost savings, reduced demand on the workforce, and led to planning for preventive maintenance.Technologies: Azure Cloud, Azure LogicApps and WebApps, Azure Data Factory, Azure Data Warehouse, Power BI, Data Lake using storage blobs, Polybase, Azure AD, Azure Secure Vault, SSIS, Akamai CDN, SQL Server, C#, AngularJS, Swagger, APIM, Azure Kubernetes Service, Azure IoT hub.

Englewood, Co

Managed Global BI for $17B worldwide operations across Americas, EMEA, and APAC.Supervised a team of 60 architects, analysts, and developers, both onshore and offshore, managing delivery and resource management for a pipeline of an average 130-250 projects.Worked closely with C-level executives and all business users from various business units spanned across EMEA, APAC, and North America regions.Assessed impact of business processes on stakeholders and evaluated potential areas for improvement.Oversaw development of a state-of-the-art predictive modeling application for end of life product: Generated approximately $15M in new business as this tool allowed the company to expand into end of life product management and sales.Application was nominated for Information Week’s Elite 100 Excellence award at the national level).Produced millions of dollars in savings by developing dashboards for Transportation, Finance, Engineering, HR, Executives and other groups that helped in consolidating/minimizing vendors and changing processes.Facilitated the design and implementation of Arrow Data Platform that consists of Data Lake, Global Data Warehouse, Data as a Service (DaaS), Data-Driven applications, Advanced Data Visualization, and Mobile / Search BI. Spearheaded delivery of Executive Dashboards, Self-Service BI Reports, and In-Memory Analytical Solutions for Sales, Marketing, Finance, HR and IT divisions.Directed the architecture of web and mobile applications and managed their overall delivery.Technologies: Oracle EBS, QlikSense, OBIEE, Microstrategy, Java, AngularJS, Node JS, Cloudera Hadoop, Apache Scoop, Informatica, Oracle, Teradata, Document DB, Azure Data Factory.

Overland Park

Led a teams of 40 analysts, developers, database admins, provided mentorship, prompt and effective coaching and counseling for the team, direction, and business-IT alignment.Architected, designed and developed state of the art overall Supply Chain Management and Logistics footprint using Oracle E-Business Suite.Provided strategic direction for the creation of mission-critical enterprise applications and a collaboration platform from ground-up that require high availability, increased the capacity of the applications by 600% during iPhone launch, improved operational SLA to 99.9%, and delivered $5M in annual cost savings by retiring legacy ASI application.Worked closely with stakeholders, business users, product owners, and PMO across various products/applications to understand functional and technical aspects of projects and ensured adherence to Enterprise Architecture principles and development best practices.Guided team through the integration of 50+ systems that include various domains like Retail replenishment, order fulfillment, Inventory and reverse logistics, provisioning, OEMs, EDI, Warehouse management.Oversaw coordination business requirements, identifying gaps, design solutions to resolve gaps in the standard Oracle E-Business system, configuration/setup, testing, training, documentation, and reporting.Collaborated with reporting team and assisted with E-business related functional and technical questions.Technologies: Oracle EBS, Order Management, Inventory Management, Shipping, Purchasing, Advanced Pricing, BOM, WIP, Install Base, BPEL, Oracle 11G, SQL, PL/SQL, Java, JSP, XML, UPS PkMS (Warehouse Management system).

Designed and implemented various functionalities such as:Order processing using various methods like real-time API calls, EDI, mass upload and manual entries.Retail store replenishment and return functionality.EDI/3rd Party, Insurance ordering and replenishment. Kitting/Packaging Plus (OSP/Outside Processing) functionality.Various real-time APIs for internal Sprint applications to provide functionality like order creation, inventory /order status check, and device availability check.Batch interfaces between PkMS (Warehouse Management system) and i2 (demand planning and forecasting systems).Coordinated business requirements gathering sessions and map these requirements into a configurable and customizable solution. Designed and integrated Oracle E-Business Suite with people soft financials for all the financial transactions, Month end closing process and credit check process. This also included design and implementation of Complex Oracle External credit check processor for credit check, based on the Customer Credit from PeopleSoft.Redesigned entire OEM interface system and implemented the changes without any major issues within 5 months of time.Configured Oracle Inventory, Order Management, Shipping, Purchasing, Advance Pricing, BOM, upgrading a system used for 1500 Sprint store locations and by major retailers. Integrated various external Legacy Systems to interface with Oracle Applications. Leveraged BPEL as an integration layer between OMIM and other Sprint applications.Technologies: Oracle EBS, Order Management, Inventory Management, Shipping, Purchasing, Advanced Pricing, BOM, WIP, Install Base, BPEL, Oracle 11G, SQL, PL/SQL, Java, JSP, XML.

Led a team of 10 while working on large and small demand projects.Completed exposure to all of the life cycles of various releases as a technical lead/SME.Designed and enhanced existing database schema, as well as Struts, XML and XSLT based user interface.Migrated application from WebLogic 6.1 to 8.1 and database from Oracle 8i to 9i.Critical resource in the design of Walmart integration project which involves implementation of Web Services.Consulted regularly with internal customers on application development project statuses, new project proposals and software-related technical issues.Recommended architectural improvements, design solutions and integration solutions.Technologies: JSP, Java, EJB, JavaScript, XML, XSLT, WebLogic 8.1/6.1, P2K, Oracle 9i/8i, Stored Procedures, SQL, PL/SQL, Custom Tags, Struts, Visual Basic, UNIX, ClearCase, Ant, Log4J.

Designed and developed Collections, Case management, and Equipment modules for a billing system’s front-end application.Led a team of 10 and acted as SME on Collections, Case management, and Equipment modules.Identified the requirements for small and large demand projects and providing LOEs.Designed and coordinated the migration of architecture from GRNDS to Struts.Migrated the application from Weblogic 5.1 to 6.1.Developed user interface using JSPs, re-engineered EJB components, and utilized Clarify Business Objects to retrieve and update data in Clarify Database.Worked with business/user group to identify and design new requirements.Environment: JSP, Java, EJB, JavaScript, XML, Weblogic 6.1/5.1, RZ, Clarify 10.1, Custom Tags, Struts, GRNDS, UNIX, ClearCase, Ant, Log4J.

Oversaw installation of software programs and hardware systems to meet sales and distribution requirements.Collaborated with product management to design, build and test systems; participated in design sessions to ascertain all project specifications for applications, databases and systems.Reviewed and approved all engineering, product and project scope documents prior to delivery.Worked in team-driven environments and communicated effectively with all stakeholders.Primary technical contact on the Search, Contingency and Sales Modules.Enhanced the application to include 3G functionality and developed user interface using JSPs.Utilized JDBC, online queries, and database for real time information and dynamically updated the screen.Reengineered EJB components and developing new components.Environment: JSP, Java, EJB, JavaScript, XML, Weblogic 5.1, P2K, Clarify 10.1, GRNDS architecture, UNIX, VSS, Clearcase.

Designed and developed a Job Expenditure Tracking System module to integrate it into a single system and enhance the budgeting function. Major forecasting and tracking functions of capital budgets (CAMIS).Creation of journal transactions associated with financial events attributed to authorizations (DOPAC). Online access to data stores of current and historical information necessary to track actual capital dollars and associated maintenance expenditures related to authorizations. Standard batch reports and download capability for end user computing.Designed change requests, performed coding and testing of change requests; oversaw quality assurance and managed 10 staff. CMM assessment group member.Delivered in-depth training to users, imparting knowledge of best practices for protecting data and minimizing errors.Investigated and addressed system issues to enhance usability and improve functionality.Environment: IBM S/390, COBOL, PL/I, DB2, Via soft, JEM, Windows95.