rohith chintalapudi

Support
• Monitor batch jobs, handle online user tickets, and coordinate job delivery with onsite team and
client stakeholders.
• Built Automated Year-End Tariff Upload Solution enabling business users to validate new tariff
structures via structured templates, eliminating manual configuration.
• Designed Tariff Calculator Report to simulate billing scenarios and validate tariff adjustments prior
to production billing.
• Developed Rates Validation & Compliance Report reconciling Residential, Commercial, Industrial,
and Indigent monthly billing against valuation reports per National Treasury requirements.
• Built Indigent Customer Identification Report to monitor subsidy eligibility and municipal
regulatory compliance.
• Designed Monthly Billing Variance Analysis Report identifying abnormal consumption trends and
revenue deviations.
• Developed Billing Status & Extraction Reports (Billed/Invoiced/Extracted accounts) segmented by
Town and Portion for operational and financial reporting.
• Created Billing Master Data (Billing Class, Rates, Rate Types, Categories, Operands, Process), Rate
Determination, Variant programs, and Billing Schema.
• Delivered full business cycle configuration — Business Partner, Contract Account, Contract,
Technical Master Data (Device, Connection Object, Premise, Installation), Move In/Move Out,
Billing & Invoicing.
• Reduced application downtime by 50% through proactive troubleshooting of SAP application issues.
• Compared SAP billing calculations against ProMIS legacy system output; configured Data Services
connections to SAP, BI, and CRM.

Technical Data Migration Lead Consultant ERP Implementation
• Analysed and refined the IS-U (Revenue) data extraction process; developed ETL for SAP IS-U,
HCM, and FI-CA data objects using SSIS and SAP Data Services (BODS).
• Used SAP Data Services to transform, cleanse, and standardise data per business requirements,
including deduplication and error handling; designed SSIS packages, stored procedures, and
configuration tables/views.
• Developed BODS projects extracting/loading from SQL Server, flat files, SAP BI, and SAP ERP using
Data Integrator and Data Quality transformations; built batch files for BODS job notifications.
• Delivered data for SAP loading teams supporting testing, mock/parallel runs, and go-lives;
proficient in LSMW, Emigall, SQL views, and MS Access/Excel for field mapping and cutover.
• Led project and team management for the data migration workstream; trained developers and
advised technical groups on ETL best practice.
• Worked across Plant Maintenance (PM), HCM, IS-U, Funds Management (FM), Fixed Assets (FAA),
Real Estate (RE), Grants Management (GM), Cash & Loans (CL), and Material Management (MM)
to extract data from legacy systems including Progress and ProMIS.
• Provided data reconciliation reports for Mock/Parallel runs, UAT, and SIT phases; developed and
executed unit and system integration test plans; delivered on-call production support.

SAP ERP to S/4HANA Transformation
• Led data migration activities for the SERGAS Gas Company SAP ERP to S/4HANA transformation,
overseeing data transformation, validation, and upload across multiple SAP modules including IS-U,
HCM, MM, and FI-CA.
• Coordinated with Points of Contact (POCs) and Business Teams to ensure timely receipt of accurate
legacy data, and ran regular data review meetings to track progress and resolve data issues.
• Validated and transformed legacy data per approved SAP data templates, performing loads through
the SAP Migration Cockpit and Emigall with full mapping, transformation, and reconciliation across
master and transactional objects.
• Prepared data mapping documentation, validation reports, and load-status summaries for audit and
governance; ran quality checks, trial mock loads, and cutover readiness assessments.
• Designed and managed data migration dashboards and progress trackers for stakeholder and
project leadership visibility.

• Gathered business requirements and built dimension models; configured and managed Informatica
Repositories via the Informatica Administrator console.
• Used Informatica PowerCenter (Source Analyzer, Target Designer, Mapping Designer, Mapplet
Designer, Transformation Developer) to build mappings and workflows extracting from DB2,
Oracle, MS SQL Server, and Teradata.
• Applied Informatica Data Quality (IDQ) for cleansing/standardisation prior to DWH load; built
Power BI dashboards and SSRS reports; used transformations including Aggregator, Lookup,
Router, Filter, Sequence Generator, Expression, and Joiner.
• Performed session/mapping/target performance tuning; wrote unit test cases in SQL.

• Built Oracle PL/SQL stored procedures, packages, triggers, and cursors with backup-recovery for
production tables; supported OLTP/OLAP data warehouse feeds.
• Extracted data from Oracle, flat files, Excel, XML, and COBOL sources, applying joiner, expression,
aggregate, lookup, and update-strategy transformations to load target systems.
• Installed/configured Informatica PowerExchange for CDC and Informatica Data Quality (IDQ); built
custom IDQ plans for product-name discrepancy checks as reusable Mapplets.
• Designed IDQ data quality plans and Informatica mappings; debugged mappings, sessions,
worklets, and workflows; built reusable tasks/worklets in Workflow Manager; provided user training
and production support.