Tax Processing Automation (TPA) System processes AT&T and its subsidiary companies Sales and Use Taxes to all jurisdiction. TPA process $650-900 million tax payment each month. TPA framework was vendor owned (until 2018) and supported for many years (until 2015). As a Lead developer/designer, my key responsibilities were to be vendor free environment that includes to Learn TPA, replace vendor team with in-house team and replace vendor owned system to in-house developed framework. Current initiative is to migrate TPA to Azure cloud platform.

• Replaced vendor resources for day to day support and enhancement within one year, as per plan. Within another four years (2015 to 2018), along with day to day support and enhancement, design, develop and implement AT&T owned system that includes framework, rule engines, ETL/ELT process, data retention and retrieval process to support tax audits.
• Responsible to analyze, reverse engineering, design/support, dynamic and parameter driven multi instance ELT, data processing and DW solutions for AT&T Tax Processing Automation system to file AT&T and its subsidiary monthly/yearly taxes
• Responsible to enhance and provide support for tax compliance processes, storage of monthly raw and processed tax data as per AT&T retention policy. Maintain Business Objects to access raw and processed tax data for tax audits.
• Responsible to design and implement tax data specs for M&A (Direct TV) and onboarding various legacy billers, CFAS, EDW data to Tax Processing Automation platforms by applying cleansing, data standardization, enrich data through mapping and custom rules to integrate data for filing AT&T subsidiary Sales and Use taxes
• Manage day to day operation support for Property and Fixed Assed tax applications
• DB modeling, process/query performance tuning. Design and develop various jobs to extract, cleanse, transform, integrate and process data in batch mode.
• Developed Technical Specification from Business Requirements and Functional Specification Artifacts including SOP
• Prepare deployment plan for enhancements, oversee the production deployment and enforce maintenance of non-production environment.
• Serve as technical resource to teams of offshore and onshore programming resources.
• Lead requirement gathering, analyze design with process/program objective, input/output requirement, scalability and optimized solution for various tax processing
• Upgrade system code to be compatible for Oracle 11g R2, Unix to Linux, DB migration from On-Prim to Cloud Tools: Data Modeler, Toad, TLC framework, SQL Loader, ETL/ELT, SAP Business Object, Crystal Reports, Linux, Shell script, Windows server, Data archival, CI/CD

Key responsibility to replace fifteen year old GE Capital compliance IT team to new IT team (from one off-shore to another) to support Synchrony Financial spin-off. Another initiative was to improve IT infrastructure such as migrate to new data center with upgrade of servers OS, DB and COTS version so new company can focus on business then IT. Responsible for interacting with internal customer, and other technical resources to deliver solution for a wide variety of applications. Applications supported are a mix of commercially available (Fircosoft filtering and Kronos) and internally developed ALM and HR platform. Applications deployed supports the functional areas of Compliance, Human Resources and Finance. Essential responsibilities:

• Played a pivotal technical role in the successful transition of GDC resources (for 15 years), data center, and software upgrades to new technical team
• delivering high-quality solutions on time and within budget
• Applied accrued experience and skills across multiple application development teams in a fast-moving multi-location environment as a designer, developer, and tester
• Developed Technical Specification from Business Requirements and Functional Specification Artifacts including SOP
• Worked closely with an experienced staff comprised of both GE FTE resources and/or 3rd party contractors.
• Architected and designed ETL/ELT, reconciliation and audit process
• Serve as technical resource to teams of offshore and onshore programming resources.
• Lead requirement gathering, analyze design with process/program objective, input/output requirement, scalability and optimized solution for GECOM interface enhancement and employee WLS process
• Integrated various solution components using variety of tools and languages for a variety of functional applications including: ETL/ELT design, Ab Initio graph, batch processing, DB development, various scripting (shell, JIL, batch), XML and J2EE Components for Unix and Windows Server 2008 Tools: ERwin, Data Modeler, IBM InfoSphere, Toad, Ab Initio, SQL Loader, Fircosoft

I was hired as Lead System Performance Engineer, after five months I was assigned with primary role as Data Modeling/Architect and spearheaded system performance responsibility Responsible for data modeling and database design (ODS, Data Mart, OLTP) for (JITR) Just In-Time Rating system that process network data to billing systems. Integration to Usage Broker systems to processes all Verizon wireless network usage data for rating and billing.

• Design ODS as per requirement, deploy ODS, load and maintain data with CDC replication for subscriber and ETNI
• Design OLTP DB for UB/JITR and Error Handling Systems
• Design Revenue Operation Data Marts for reconciliation and Error correction
• Data modeling responsibility includes access control, naming standard, data stewardship, following data governance, creation of DDL/DML, deployment, replication, data flow walkthrough, DB development code review Tools: ERwin, Data Modeler, IBM InfoSphere, Toad, Informatica, SQL Loader

Design, development and support of Mobile Marketing OLAP DW system. DW enhancement and BI Analytics reporting for latency/performance, traffic, campaign and billing. Data Warehouse process improvements focusing on ETL, partitioning, materialized views, SQL tuning and logs.

• DW ETL process to convert router non-relational data in to fact and dimension model. Daily volume of 25-30 million rows.
• Various batch processing of scheduled marketing campaigns for analysis and billing. Volume 5 to 10 million rows.
• Automated Star Service monthly billing process using shell script, PL/SQL and ETL processes.
• Development of customer facing latency and performance reports for marketing campaign.
• ETL job using Talend File delimited and positional metadata, tMap, tFilterRows, Row generator, tLogRow and output to Oracle database or data file
• Analysis and design of real time data refresh and new BI reporting platform using Vertica (Analytical DBMS) and Tableau for data visualization
• internal and customer facing portal.

Responsible for design and implementation of SDLC for contract and billing related IT systems for revenue operation for Verizon Communications' global footprint.

• Analyze and assimilate ever-changing business requirements and users' needs by development, enhancement and integration of various contract and billing systems.
• Collaborate with project managers and cross functional business group to define change control and ensure on-time completion of project deliverables.
• Develop project design, walkthrough, data integration, configuration management.
• Developed J2EE application components & back end processing to ease implementation of business logic.
• Designed and implemented various interfaces between revenue operation applications via data feeds, web services (SOA), ad-hoc reports to streamline business process.
• Implemented connection pooling using JAVA to support increased 20% load towards month end.
• Fine-tuned time-consuming queries identified by AWR report, using indexes, hints, and partitioning, materialized view/logs and rewrote many of the queries to substantially improve 80% response time.
• Worked extensively with DBA to upgrade, access control and migrate database to grid.
• Played a key role in building off shore development team, providing system training to bring them up to speed to participate in development.
• Ensured timely production support and issue resolution including level 3 production support. Audit Engine (Primary Project)
• Data Warehouse: Design and development of ETL processes to consolidate 16 legacy systems data into data warehouse allowing a one stop audit, auto pilot, verification process, and automated work flow management for various user groups across field reps, contract implementation, and revenue operation.
• Change Data Control (CDC) and Slowly Change Dimension (SCD) design and implementation.
• Development and support of ETL processes using SQL Loader, external tables, global temp tables, PL/SQL, procedures, packages, UNIX shell scripts and Talend tool.
• Responsible for logs, data archive and purge functionality.
• Development of batch process using PL/SQL, UNIX scripts to apply business rules, WFM, and audits\exceptions processing on consolidated data.
• Daily volume 5
• 20 million rows.
• Online Analytical Processing (OLAP): Developed OLAP for Accounts, HLQ, Data view, Rate cards, and promotions. Designed and developed Descriptive and Predictive Analysis processes to apply business rule and validation of customer's billing data setup on correlation of consolidated data as per contractual terms.
• Decision Support Systems: Notification of customer's contract\amendment data change analysis to appropriate POC/business owner group. Auto validation of account, rates, circuit change data control as per contract terms, existing billing data and approval process. Work flow management functionality for billing data discrepancy within expected time.
• Business Performance Management: Removed cross functional group dependency (billing auditor's dependency on account team verification) by implementing account team automated notification and 3 days escalation to reporting hierarchy. Notification and escalation process improved billing quality and reduce back billing by 10% along with better customer service.
• OLTP: Web application for various user groups to authenticate billing data, search functionality, automated audit options setup.
• Reporting platform: Contract\amendment process time and accuracy summary by region, center, and reporting hierarchy including various ad hoc and automated\on line reports. Contract implementation performance reports. Audit discrepancy report by account, analyst, and auditor group.
• Consumed and Publish web services for real time integration along with daily data feeds to 5 downstream systems.
• Servlets, DAO, JSP, HTML, CSS, JDBC, Connection Pooling, Oracle 11g, PL SQL, ETL, shell scripting, batch processing, Talend. Billing Transformation projects (Primary project) Lead and participate in various Billing Transformation projects for WorldCom/MCI/Verizon legacy systems synergy initiative. Supervised change control for AE, CRS, Rev Ops Web services project.
• Designed and implemented legacy systems decommission/integration projects
• Analysis and development of billing data integration ELT process in batch mode using Vertica
• Extensively worked with DBA for contingency plan including database backup, import-export utility, data files, control files, and table spaces.
• Development of complex stored procedures and optimized SQL queries for large volume data and intricate billing audit process
• data migration and built in functionality. Contract Reporting System (Primary Project) Maintain contract life cycle from presale to archive, contract work flow management through various stages of contract (Presale/Sale, Implementation, Billing) with data repository module.
• Published/consumed many web services, RPC, and data feeds to Rev Ops applications.
• Spring framework, EJB, DAO, JSP, Java Applets, Java Servlets, JDBC, connection pooling.
• Oracle Database 11g and Oracle Reports. Rev Ops Web Services (Secondary Project) Web services projects for real time interface between AE/CRS, and other REVOPS system. Published and consumed to publish and consume web services. Responsible for AE/CRS related web services.
• Web service uses Axis, XFire, CXF, JAXB, EJB, DAO, and JDBC.

Responsible for GUI and functionality design for commercial client/server application (Connex4.0) used by hospitals and medical practice for Behavioral Health Area.

• Developed PFC class extension objects to be used by development team.
• Designed and developed Appointment Scheduler for HMO/PPO facilities.
• Designed and developed Connex4.0 data migration functionality for employee health benefits.
• Developed eligibility data import functionality from various insurance companies to application by ETL.
• Worked as a member of a team in problem solving and issue resolution.
• Involved in evaluating the use of PowerBuilder 6.0
• PowerBuilder 5.0 with PFC and MS SQL server/Sybase SQL Anywhere database.

Member of a software team responsible for developing two client-server systems (Vehicle Registration and Title System) for DOT. Responsible for dealer license processing and transactions.

• Developed and implemented the Info Image subsystem, which displayed scanned images from MS SQL server to application processing windows.
• Integrated DP500 (Document Processing) to VRTS application.
• Designed, developed and implemented an incident tracking system for the North Dakota DOT.
• Occasionally coded DLL functions in C.
• PowerBuilder 5.0/PFC, Oracle 7.3, and MS SQL Server