Resume

Sign in

Accounting Data

Location:
Edmond, OK
Posted:
May 19, 2020

Contact this candidate

Resume:

SANJAY KODAM

TECHNICAL SKILLS

Programming: C/C++, Pascal, FORTRAN, Basic, PowerBuilder, Assembly, COBOL, RPG ILE, VB, .net, XML and HTML

Applications: SAP/ECC, SAP S4 HANA, Oil and Gas Accounting Application Artesia, Production Application Enertia, AP K2 Workflows, Electronic Invoicing, all MS-Office products

Database Applications: DB/2, Oracle 7.3/8.x/9i,10G/11g/12c MS-SQL Server 6.x/7.0/2000, MS-Access 97/2000, DB2.

ETL Tools: Informatica Power Center 9.x/8.x/ 7.x/, Microsoft SSIS.

PM Tools: MS-Project, TFS, PVCS Tracker, Agile Methodologies

Reporting Tools: Hyperion and OBIEE

Operating Systems: Windows 95/98 SE/ME /NT /2000, Linux, UNIX, OS400, MS-Dos

QA Tools: Microsoft Test Manger, Load Runner

Methodologies: Agile (Scrum) and Waterfall development methodologies.

PROFESSIONAL EXPERIENCE

Consultant

Duration: Jan 2017 till date

Client: Devon Energy

Project: E & P BI Solutions for Drilling, Completions and Financials

Role: Business Analyst/ Designer & Lead Build team offshore

Devon Energy building interactive data visualization business solutions for Drilling, Completions and Financials divisions. Enabled data visibility at Division, Business Unit, Pad and Well Level by operation types and capex allocations. Visualization are built with ability to compare Allocations vs Field Estimates Vs Actuals to analyze actuals trending to forecast.

The enabling platform of choice was SAP/CO, SAP S4 HANA, Informatica, MS-SSAS, MS-Power BI and Team Foundation Server to track all work associated. Accenture was engaged to implement and maintain all processes. The team consisted of a team onshore and offshore.

As Enterprise Reporting and Analytics Sr Analyst

Worked with client SME doing System Analysis & Design

Review of Data Model of Drilling, Completions, Well View, Site View and Financial HANA based data to design inbound and outbound integrations for Tabular Model.

Reviewed available data services via internal Data hub ODATA to decide on data sources

Worked on Design Document and STTM interacting with Clients.

Gathering requirements, preparing design document for approval, creating technical specifications, and coordinating built effort.

Coordinated and lead a build team to create tabular model/CUBES for different business streams vise Finance, LOS, Drilling, Completions, Supplier Connect, and Divestures.

Doing impact analysis and work estimates to retire BOBJ based reports to be converted to SSRS Reports or SSAS Cubes.

Designed visualizations to enable user to review data for predictive analysis, presented via PowerBI.

Client: Sanofi - GenZyme

Project: MDM Implementation

Role: Business Analyst/ Designer & Lead Build team offshore

Genzyme is implementing a CRM transformation onto a standard Veeva SFA platform across the Rare Disease and MS Business Units. Implementing Reltio for MDM needs.

The integration platform of choice was Hadoop, Informatica and TIBCO to Reltio from Salesforce CRM. Accenture was engaged to implement and maintain Reltio MDM. The team consisted of a team onshore and offshore.

Worked with client SME doing System Analysis & Design

Review of Data Model of E2E applications/Systems.

Worked on Design Document and STTM interacting with Clients.

Designed Inbound and Outbound Integrations for Reltio MDM, Salesforce CRM, and ERP.

Build integrations to UPSERT and Outbound for Mastering.

Designed visualizations to enable user to review data for predictive analysis, presented via PowerBI.

CHESAPEAKE ENERGY CORPORATION Oct. 2005 – Aug. 2016

Service Delivery Manager/ Lead Process Integrator/ IT Coordinator

Worked as onsite coordinator for an accounting application, trained to be SDM working with 5 FT AM resources, successfully organized team responsibilities and prioritized projects. Maintained 100 % project deliverables for the period. Worked as liaison between client SME, development team and internal senior managers of Application Management services.

Contributor and Change Leader for enterprise re-design of integration and information architecture. Demonstrated ability to think strategically about business, and technical challenges.

Assist in developing future-state integration roadmap for major ERP, SAP implementation initiative.

Lead team in gathering requirements, preparing Functional Specification Document (FSD), Technical Specification Document (TSD), providing expedited solutions working with team members. Coordinated Functional Unit Testing (FUT), Functional Integration Testing ( FIT) events and documents.

Worked extensively on Knowledge Map, Knowledge Acquisition, Technical Design and Estimation for Fixes and Enhancement, Data Migration projects from IBM Iseries to SAP.

Integrations from Artesia to SAP, Master Data Management to Artesia, and SAP to Artesia.

Supported integrations from Legacy to SAP ECC/ S4 HANA, related to Revenue Accounting, General Ledger and Division Order Module.

Oversaw business analysts and developers in designing new Revenue Accounting and Division Order Functions.

As Coordinator Interfaced with IT leadership, and accounting leadership, champion IT leadership initiatives. Managed large, custom software optimization efforts for core accounting processes resulting in many days saved in clients’ monthly processes

As coordinator was part of team commanding one of the largest custom database and application expansion projects in company history resulting in over thousands of object changes and millions of lines of data converted

As coordinator was part of team responsible for the planning, scoping, budget to actual, and mentoring of staff on all ITRF projects.

As coordinator contributed to SDLC process for the IT Application Services team that standardized the way IT managed the life cycle of a project or support request. To achieve this, we implemented the Agile project management methodology & introduced 2 week sprints/iterations for all software development.

As coordinator was responsible for managing the Agile project life cycle for development of new accounting functionality, enhancements to existing functionality & support of current functionality.

As coordinator was part of technical team working on integration and conversion for a major acquisition of all Eastern division accounting processes from legacy systems to enterprise accounting system

As coordinator was part of team responsible for resource allocations with a pool of 13 developers. Analyzing strengths and grooming new developers as needed.

As coordinator assessed performance and assisted in planning and career development for new team members

Sanjay Kodam Resume Page 2 of 4

Lead designer and developer for enterprise cross-platform for Revenue Accounting and Division Order.

Point of contact for global external auditors in IT Sarbanes-Oxley processes and data exports for Revenue Accounting, General Ledger, and Division Order Functions.

Have used change management tools to implement and meet set deadlines.

Conducted daily scrum meetings and bi-weekly meetings in the agile environment.

Sr. Applications Technical Consultant / Analyst

Lead developer on Revenue Accounting system

Work with cross functional team on design and implementation.

Developed strong relationships with leadership and Revenue accounting user and division orders groups.

Enforced security requirements for functions across iSeries platform I developed and recommended to all functions across different modules.

Developed functions for Joint Interest Billing Processing and assisted in business process redesign

Developed quality control reporting console for executive leadership in Division Orders group

Created user documentation and performed end-user training for developed applications.

Have used extensively change management tools, PL/SQL, SQL, RPG ILE, CLLE, Informatica to created new process/functions.

Major accomplishments in last 10 years at Chesapeake

Lead designer and developer for enterprise cross-platform applications for General Ledger, Revenue Accounting and Division Order modules.

Lead a team to develop owner member maintenance module, and created reports to enlist member validations.

Lead a team to develop benefactor’s plan and deck maintenance module, and built process of distribution based on owner member and benefits information. Distribution of over $500 million takes place every month depending on oil prices.

Worked on a project to capture data for Revenue & JIB of Chairman’s accounts. Created data entry screens and reports for daily reconciliation with Accounts Payable & Receivable departments. Generated reports for accounts reconciliation for Daily, Monthly and yearly uploads to off-shelf accounting software.

Worked on a Revenue project to issue manual checks issuing process for different owner accounts following business rules. Enhanced related programs to accommodate accounts with more than 9999 records and changed programs to process the same.

Worked on a Revenue Project to resolve error issues concerning batch postings process.

Worked on a project to web-enable revenue screens to retrieve owner accounts data and view invoice and voucher details.

Designed enhancements to Owner Portal to access Accounts Payable, Suspense & Netted Suspense data.

Designed a news menu in accounting application Artesia – Revenue Module to help Mass Pre-Post and Post batches. Automated Excel spreadsheet uploads process.

GL Balance Field Expansion Project to accommodate billion dollar amounts.

Worked on Major Enhancements for Revenue Distribution Process. Added state regulations to calculate State and Federal Withholding Backup withholding.

Lead a team on General Ledger Enhancements for speeding process.

Worked on Well Distribution List project, this application traps Division Orders changes and transmits to BizTalk in xml form.

Worked on Mass Upload Functions, this function enables user to manage decks, property and owner comments, owner information.

Worked on Division Orders and Demand project, enables users to generate Division Order On Demand (DOODS) on global transfers and owner requests.

OKLAHOMA INSURANCE DEPARTMENT (OID), Oklahoma City, OK Nov. 2004 – Aug. 2005

Consultant

Sanjay Kodam Resume Page 3 of 4

HELWETT PACKARD, Omaha, NE May 2004 – Nov. 2004

Consultant

DOREL JUVENILE GROUP, Columbus, IN Apr. 2001 – Mar. 2004

Consultant

CUMMINS ENGINE COMPANY, INC. Columbus, IN Jul. 2000 – Dec. 2000

Consultant

ALUMINUM CORPORATION OF AMERICA, INC. (ALCOA), Indianapolis, IN Oct. 1999 – Jun. 2000

Consultant

HTE UTILITY SOFTWARE HOUSE, FL Nov. 1998 – Sep. 1999

Consultant

VISA INTERNATIONAL, FL Aug. 1997 – Aug. 1998

Consultant

SQUARE-D SOFTWARE, INDIA Oct. 1996 – Jun. 1997

Consultant

General and Consulting

Created hundreds of applications and utilities to enhance, speed up or automate Batch, Interactive and manual processes and general operational processes for Utility and Financial clients.

Provided consulting, and programming services to numerous iSeries customers around the country.

Travel to customer sites to perform iSeries application maintenance, and built new functionality.

TRAINING

IBM Programming in RPG and COBOL

ETL tools (Informatica MS SSIS) Process Builder Training

Oracle PL/SQL, T-SQL, SQL, Forms and Reports

EDUCATION

NAGPUR UNIVERSITY, India

Bachelor of Computer science from Eng. Dept.

PUBLISHER/PRESENTER

Presented improvements to General Ledger Closing processing to IT Management and Stake Holders. Managed Team, Designed, Lead a team and coordinated development effort and implementation.

Presented Findings for Order Date Consistency - Order Fulfillment Process Implementation project (OFPI) to executive group and implemented changes required. Managed Team, helped in blue printing, realization and deployment phases.

Provided multiple high level presentations to all levels of management and executives to illustrate the mechanics of how date fields are automatically managed by the Legacy system as orders are brought into that system via EDI and manual entry.

Presentations to customer groups teaching about query tool to create ad hoc reports. Saved over 80 hours per week for user groups.

Presentations to customer groups teaching new functionality to application to speedup daily operations, saved over 80 hours per week for operations group.

Sanjay Kodam Resume Page 4 of 4

DOMAIN KNOWLEDGE

Industry

Years of Experience

Rating

Financial - Accounts Payable, Receivables, General Ledger, Fixed Assets

18

8

Manufacturing, Distribution and Warehouse Management System

8

8

Oil and Gas Accounting, Membership, Ownership, Owner Benefit

12

8



Contact this candidate