Subbaiah Choudary Kotha (KS Choudary) E: adbcpr@r.postjobfree.com

**** ***** **, ******, ** 60504 M: 630-***-****

Linked In: linkedin.com/in/kschoudary

Currently working for US TRANSCOM TMS Project (US Army/Airforce) as SAP Reporting team (BW/BO) lead and Architect. Prior to this worked as Sr. BW Consultant in the LMP Sustainment from Sep-2007 to Nov-2017 for a total 10+ years and one year (2018) in AESIP for IDM team.

Secret Clearance Status and Professional Certifications:

-Secret clearance granted by OPM on 7/17/2019, valid for 10 years

-Security Plus certificate from CompTIA (valid till April-2022)

-NetWeaver’04 – BI (BW 7.0), SAP HANA Modeling and SAP CRM 4.0 (5 Certificates),

-Hadoop Certificate (HCA) from Hartonworks on 5/9/2018

Overview:

Over 24 years of experience in SAP in the area of ABAP, BW, BW on HANA, Business Objects, CRM and NetWeaver Portal, out of which 10 years was in LMP BW team, a US Army (DOD) project.

Also familiar with Hadoop development as well as administration.

-Initial setup and configuration of BW and SLT systems completed in record 2 weeks’ time each

-SME for Network Monitoring, Performance Tuning for Queries and Data loads, Process Chains

-Conducted Workshop for LMP Site Support team for EDW Reports and BEX Tools

-SME for all KPI Reports like Supply Availability KPI, Delivery Performance KPI ETC and conducted several workshops with Govt. users and power users for refining the requirements and improving performance of reports and defining logic for calculating RDNI Date

-SME for Network Monitoring, Trouble shooting, training and documenting

-SME for configuring and troubleshooting all tools (BEX Tools, BOBJ Client Tools, NWBC, NWDS, HANA Studio, ARIS Tools Set, QC & QTP, File Depot etc with Portal Links) and performs initial validation before releasing to testing team and help them to run their test scripts

-Configured all DISA SAP systems (59) to connect with LMP PI systems for UAMp and Role Provisioning and Portal iViews with DISA hostnames and SSO

-Configured and set up SSO for all CAMS (9) and MII Systems (16), without a single issue

-Familiar with MII Reports, Workbench and Admin to configure the SSO, ECC integration etc.

-Worked with project managers and technical leads to provide the existing LMP functionality on the DISA servers utilizing my knowledge and understanding of the LMP Solution across the SAP systems like ECC, APO, EWM, BW, GRC, cFolders and XI and making the systems ready for functional validation and support during validation period.

-Familiar with ABAP, BW, Business Objects, Java, Windows, Citrix, Linux, HANA, SLT and HADOOP

EXPERIENCE:

Role: Reporting Team Lead, Client: USTRANSCOM Project for US Army (DOD) in O’Fallon, IL

Dates: Jan-2019 to Current:

-SAP BW/BI/BO/HANA Architect and Reporting Team Lead at TelestoGroup for USTRANSCOM project jointly managed by US Army, Navy and Air Force of DoD.

-Portfolio of Products include SAP TM, BW, BO, SLT.

-Completed initial setup, configuration, BI Content installation and Data loads from ECC (TM) system in just 2 weeks and provided SAP standard reports (60+) for review by functional team.

-Successfully configured and setup of SLT systems (2) for Real Time Data that used for Dashboards

-SME for Process Chains, Scheduling of Webi Reports, SLT and Network Load Monitoring

-Designed and Developed several Webi Reports (25) and Lumira Dashboards (12). These include reading data from multiple BW queries, Excel files and created merged Webi reports to display content from multiple sources.

-Developed Webi report that reads data from BEX Query with ECC data and an Excel file with data from RFID Scanners on field to display document information merged to display in one line

-Developed 6 Webi Reports for FI team that ensure compliance with Govt. and regulatory policies. These reports are used directly to make vendor payments by uploading data into bank.

-Developed several Process Chains to automate the data loads and created jobs to run using Solution Manager 7.2 and its monitoring tools

-Responsible for checking the data loads daily and fix any failed loads in the entire landscape for providing up to date and accurate data for reporting

-Identified and implemented several SAP OSS Notes for BW and SLT systems

-Supported Unit Move operations with several KPI Reports running every hour to identify the data inconsistencies that helped the core team to correct them immediately, so the dashboards report timely and accurate metrics.

-Trained and mentoring reporting team members to use full features of Lumira Designer.

-Coordinating with training team to record user guides for each report and dashboard.

-Prepared Technical Design Document, End User Training document for each report and dashboard developed and supported testing teams during Integration test cycles and UVT.

-Received “Exceptional Client Service 2019” Award in Oct-2019

Role: Security Consultant, Client: AESIP IDM Project

Dates: May-2018 to Jan-2019:

-Contributed to the successful migration project that went live in Dec-2018 for LOGSA / AESIP with Enterprise wide Oracle IDM with SSO using the EAMS-A

-Documented all the current and new IDM applications

-Prepared and posted Test Scripts to Solman

-Collected and compiled 1.2M user data for migration of AKO Users

-Customization of UI Console as per AESIP Requirements

-Developed SQL Queries to validate and clean the huge data from several SAP systems

-Prepared detailed cut-over steps and executed across the systems

-Data migration completed with Users, Roles and Role Approvers using Bulk Load Utility

-Helped team members in trouble shooting the custom connectors and made progress within a short time

Role: Senior SAP Netweaver Consultant, Client: AESIP DISA Migration Project

Dates: Nov-2017 to Apr-2018:

-Worked as SAP Netweaver and PI consultant with Functional team in the AESIP DISA Migration project.

-Compiled detailed steps to perform at each stage in migration for each AESIP system

-Compiled detailed steps to perform during interface validation with partners

Role: Senior SAP Netweaver Administrator at LMP DISA Migration Project

Client: LMP DISA Migration Project, Dates: Mar-2016 to Nov-2017:

-Primary Responsibilities are to Configure the SAP NetWeaver Portal with SAP backend systems with SLD and SSO and to set up SSO for all MII systems and publish links

-Conducted workshops with internal teams to focus on the requirements and educate DISA team on how LMP works, which helps to complete the tickets with minimal interaction

-Conduct meetings before every phase of life cycle to heads up what is being released to them for validation and address all questions and support during validation.

-Single point-of-contact for Portal team to handle all SAP systems, BEX and BOBJ tools

-Configured LDAP servers with High Availability option in several MII systems for 1st time in LMP

-Configured CAMS (9) with MII system, and MII (16) with ECC system FQDN / hostnames

-Configured BW Workspaces (SAP NWBC) in QAS Portal

-Configured SAP Business Objects Client Tools (7) in QAS EP and working with Functional teams to troubleshoot issues and resolve. This includes – Webi, SBOP Dashboards, Crystal Reports, BI Launchpad, Analysis for Excel, Information Design Tool (IDT) and Central Management Console (CMC). Configured tools for Version 4.1 & 4.2.

-Validated each of these tools before releasing to testing team and support their activities by coordinating with all internal teams like PORTAL, CITRIX, WINTEL, BASIS and DISA team.

-Familiar with several tools like HANA Studio, NWDS, NWBC, BEx and BO Client tools

-Worked with CITRIX team to publish apps and Quick Launch Tiles. Also worked closely with CITRIX lead to troubleshoot all issues related to CITRIX Published apps for SAP systems

-Experienced in Windows and UNIX environments and uses RDP and PuTTy tools to check the OE level status for connectivity, hostnames etc. Hands on ABAP, BW and Portal skills.

-Helped testing team in trouble shooting CAMS and MII issues with integration to ECC

-Familiar with MII Portal with regards to configuration of SSO, Integration with ECC, validation of reports and workbench

-Worked heavily on Linux systems to check the ports for UAM activities, telnet with UA2/UA3 systems to check connectivity

-Familiar with several tools like HANA Studio, NWDS, NWBC, BEx and BO Client tools

Role: Senior SAP BW Consultant at US Army Logistics Modernization Program (LMP)

Dates: Sep-2007 to Mar-2016:

-Participated in strategic assessments and design reviews to validate enterprise approach and best practices during the implementation of ‘EDW on CITRIX’ project

-Worked on BW on HANA POC team that completed in Jul-2013. SME for Usage reports. Played a key role in the entire duration of the migration by converting BW objects into HANA in each of the 7 landscape environments

-I have hands on experience creating and using Attribute views, Analytical views and calculation views during SAP HANA training program at SAP America in Dec-2012

-Migrated all DSO’s and InfoCubes into HANA during POC, ran several validation reports to check the pre and post migration issues and performance under the guidance of SAP team

-Developed several KPI reports with BEx Queries that shows the run times before and after migration to HANA and high light the areas that need further improvements.

-Conducted workshops to educate the end users on Supply Availability KPI report and to refine the requirements, particularly calculation of RDNI Date logic. SME for all Sales KPI reports.

-Conducted workshop to train the LMP Site Support Team on EDW reports and BEX Tools and provided support when they were helping end users at sites.

-Provided subject matter expertise in using BEx Broadcaster and Subscription Service and prepared a ‘How to’ document and provided guidelines for proper usage of the tools

-Participated in the development of the Blueprint and involved in the development, documentation, implementation, integration testing, training, cutover plan, transition and implementation of the Sales and IDOC Datamarts which contains huge volume of data.

-Participated in the development of the Data Foundation Queries for Sales and IDOC data marts from Blueprint to implementation and prototyped Webi reports to demonstrate the usage of these special queries

-Familiar and experienced in LMP lifecycle process to include development of CRD, CDD & QA Test Script, FDD, TDD and Training Documents Etc

-Developed prototypes using various BI tools for reviews and demonstrations.

-SME for Query Performance, Caching, Query Usage Reports and Process Chains run time reports

-Prepared periodic reports that help management to estimate volume and time during upgrades. SME for analyzing Early Watch Reports and recommended action plan

-POC to run validation steps during monthly maintenance window, Support Packs, SAP GUI upgrades, Portal Configurations etc.

-Worked with multiple teams like BASIS, Portal, Training, Wintel and CITRIX on resolving production defects and performance issues

-Mentored new hires on LMP processes and tools to effectively use them

-I was responsible for day to day monitoring of BWA (Pre-HANA), Broadcaster Jobs, Daily Network Loads and Proactively worked on performance improvements for ETL loads

-Streamlined Network loads and contributed to reduce the nightly loads from 12 to 6 hours.

-Prepared several “How to documents, explaining detailed instructions on performing several tasks in BW system and keep updating them as needed.

-Hands on experience in ECC 6, BWA, BW 7.3 with BW on HANA, BO 4.1, Portal links

-Focused on KPI Metrics, Trend Analysis reports etc. for Sales and IDOC Metrics with huge volume of data (650+ Million records) and optimized their run time.

-Experienced in Business Object tools like BI Launchpad, Webi, Dashboards, Crystal Reports, Analysis for Excel, IDT and CMC and developed few Webi reports

-Good oral and written communication skills. Proactively reach out to end users

-Good understanding of the development lifecycle and best practices in SAP BI/BW implementations at LMP

Role: Senior SAP Technical Consultant, Client: Contractor to SAP AG, Waldorf, Germany for MS SQL & BW work, Dates: Mar-2007 to Sep-2007:

As a solution consultant, I was responsible for migration of the current BW-BPS implementation of planning applications and layouts into new BI Integrated planning and Web Applications for the CRM Marketing Project.

-Maintained an MS SQL Database and JSP programs for Customer Opportunity Analysis program where Sales team uses for potential customers to upsell new products.

-Performed Quarterly data loads from BW system into SQL database to refresh the customers and their inventory list.

Client: As an Employee of SAP America, I was responsible for design and development of CRM Marketing applications for integration with Portal.

Role: Senior SAP Technical Consultant, Dates: Dec-2004 to Mar-2007:

As a technical team lead, one of my major responsibilities was to develop CRM PCUI 50 applications for EP6.

These include business blue print, design and develop CRM PCUI applications, BW Reports, testing, deployment and documentation for test scripts end user training.

-Administered a BW project developed based on data from R/3, CRM, BW and EP6 and responsible for Product support, User support and enhancements that contains 10 InfoCubes, 6 ODS and 1 MultiProvider and several queries and web templates.

-Compiled and prepared a presentation document showing the delivered BW reports in CRM50 as part of migration project for Lead Manager and Marketing Manager Roles

-Successfully implemented CRM for Lead Manager (March-2006) and Marketing Manager (March-2007) and played a significant role for its successful Go-Live

-Successfully completed a migration project to CRM 50 and PCUI 50 with EP6 in July 2006

-Successfully completed the configuration of iViews, worksets, Roles for CRM 50 on EP6

-Team lead with 8 developers and working on design and development of PCUI Layout, MAC classes using ABAP-OO, Portal Configurations etc using Best Practices

-Responsible for administration and maintenance of a web based application developed on ASP using VB Scripts and MS SQL Server 2000 database

-Developed several native BSP applications that are launched from the PCUI applications

-Developed XML, XSLT, HTML and XHTML for custom web pages using CRM data

Client: Contractor to US Customs (CBP), DC with IBM for ABAP & SAPScripts

Role: Senior SAP Technical Consultant, Dates: Dec.2002 to Nov.2004:

As a Sr. Technical Consultant, helping the client in designing and developing all custom reports and Adobe, Smartforms and ABAP development work.

Role: Employee of Mastech – Senior Technical Consultant for ABAP & SAPScripts

Dates: Jan-1997 to Nov-2002:

Fujitsu Electronics, San Jose, CA (Jan-1997 to Apr-1997) - R/3 2.2C to 3.0F upgrade project

USS/Kobe Steel, Lorain, OH (May-1997 to Mar-1999) - Implementing SD, MM, PP, QM and FI

Motorola, Schaumburg, IL (Apr-1999 to Dec-2000) - Implementing global HR module

Kimball Electronics, Jasper, IN (Feb-2001 to Sep-2001) – Team lead for Sapscript work

Visiontek, Gurnee, IL (Oct-2001 to Mar-2002) – Implementing Smartforms and Tax Forms (FI)

Kimball International, Jasper, IN (Apr-2002 to Nov-2002) – developed Reports using ABAP-OO

Role: Employee of IVL India, German comp. & SAP Partner, BASIS, ABAP & SAPScripts,

Dates: Jan-1996 to Dec-1996:

Trained in ABAP and Basis in Germany for 3 months

Installed SAP R/3 3.0D on Windows NT server

Familiar with SAPDBA, System and User Administration, Spool Administration (SPAD) and CTS

Conducted Training in SAP R/3 overview, ABAP/4 development and SAPScript

Involved in detail design, program specifications, development and testing.

Jan-1988 to Dec-1995: AP Tech. Services Ltd (Govt.), Hyderabad, India – Systems Analyst, COBOL

Apr-1982 to Dec-1987: I worked as Programmer in 3 companies in India developing COBOL programs.

EDUCATION:

-Master of Science from Bhopal University, Bhopal, India in Mar-1981

-Diploma in Management (in Mar-1991)

TRAINING / CONTINUOUS EDUCATION:

-Completed several OpenHPI and OpenSAP courses in 2013 (4 Courses), 2014 (5 Courses), 2015 (2 Courses), 2016 (3 Courses), 2017 (5 Courses) and 2019 (2 Courses)

-Completed several Big Data Hadoop and Spark, MongoDB, Hadoop Admin courses

Contact this candidate