Resume

Sign in

Data Accounting

Location:
Edmond, Oklahoma, United States
Posted:
October 20, 2016

Contact this candidate

Resume:

SANJAY KODAM (US Citizen)

acw5zl@r.postjobfree.com

405-***-****©

IT COORDINATOR ● LEAD SOFTWARE DEVELOPER

Information technology consultant with expertise in the development and implementation of business and technical solutions for Various Departments

Seeking challenging opportunity to understand business and enable operations to run smoothly.

Experience Summary :

Service Delivery Manger with more than 20 years of experience in Supply Chain, Manufacturing, Distribution, Order Entry, Order Fulfillment, Warehouse Management Systems, Financial – Accounts Receivables, Accounts Payables, General Ledger, Revenue Distribution for oil and gas, Division Order for Land in oil and gas, Insurance claims & Adjudication process, Benefit plans and Adjudication, Payroll, Utility Billing, Data Migration & EDI based Applications.

These 20 years were well spent in leading, coordinating and developing new applications, enhancing functionality of existing applications, giving new technology solutions, maintenance on existing applications, briefing executives of various departments on technology issues, and providing required solutions, training users and preparing documentation for users.

SUMMARY OF SKILLS :

20+ years IT development experience Using ORACLE development tools, Iseries tools, Informatica, MS-SSIS, Change Management Cherwell, Turnover, Hawkeye,

Proven track record of managing and delivering large-scale IT projects.

Deep hands-on experience leading the design, development and deployment of applications.

Experience in designing and implementing ETL environments using ETL strategies as well as tools like Informatica Power Center 9.x/8.x/ 7.x/6.x.

Experience in all aspects of project development life cycle in Data Warehousing.

Extensive experience with Data Extraction, Transformation, and Loading (ETL) from disparate Data sources like Multiple Relational Databases like Oracle, SQL Server and DB2 and Worked on integrating data from flat files, CSV files, and XML files into a common reporting and analytical Data Model using Informatica.

Experienced in Capturing Incremental data (CDC) from source systems.

Extensive background in Oracle 8i/9i/10g/11/12c including Table, Index, Stored Procedure, Exception Handling and Trigger designs and packages.

Strong skills in SQL, PL/SQL, RPG, RPG LE, and CLLE.

Extensive experience in Oracle Forms and Reports.

Experience in reporting tools like Hyperion interactive reporting services.

Strong skills in UNIX and UNIX Shell programming, written Shell Scripts to support pre/post-processing of input and output files.

Expertise in application unit testing, Functional Integration Testing (FIT), Functional Unit Testing (FUT) .

Excellent skills in gathering requirements from users, design, build and deploy. Have extensively worked on Validating end-to-end ETL data integration processes to ensure performance, reliability, and data validity and accuracy.

Team-oriented individual with excellent interpersonal, planning, coordination, and problem-solving skills and has excellent communicant skills.

PROFESSIONAL EXPERIENCE

Oct, 2005 – Present : Chesapeake Energy

Service Delivery Manager / Lead Process Integrator

Chesapeake Energy is a second-largest producer of natural gas, a Top 20 producer of oil and natural gas liquids and the most active driller of new wells in the U.S. Headquartered in Oklahoma City, the company's operations are focused on discovering and developing unconventional natural gas and oil fields onshore in the U.S. Chesapeake owns leading positions in the Barnett, Fayetteville, Haynesville, Marcellus and Bossier natural gas shale plays and in the Eagle Ford, Granite Wash and various other unconventional liquids-rich plays. The company has also vertically integrated its operations and owns substantial midstream, compression, drilling and oilfield service assets and it was awarded as Fortune’s 100 Best Companies to work for in 2012.

CHK Financial ERP is built in house to cater to all financial needs of the organization. System provides link between drilling, production, financials, and revenue distribution divisions of the organization. System process and tracks information related to Accounts Payable, Accounts Receivable, General Ledger, Production, and various batch processing process for AP/Cash/Revenue divisions. System gives visibility to data flow from data element level to Trial Balance, Balance Sheet, cash flow statements and monthly, quarterly, yearly financial reporting to external world.

Worked as DM working with 5 FT AM resources

Successfully organized team responsibilities and prioritized projects.

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

Maintained 100 % project deliverables for the period.

Worked as liaison between client SME, development team and internal senior managers of Application Management services.

Lead team in providing expedited solutions working with team members. Contributor and Change Leader for enterprise re-design of integration and information architecture.

Demonstrated ability to think strategically about business, and technical challenges.

Lead team to gather requirement from user side Subject Matter Expert (SME), prepared Functional Specification Document (FSD), Technical Specification Document (TSD), and Functional Unit Testing (FUT), Functional Integration Testing (FIT) documents.

Worked extensively on Knowledge Map, Knowledge Acquisition, Technical Design and Estimation for Fixes and Enhancement.

Worked extensively on data migration projects from AS/400 to SAP.

Designed, mapped, and lead a team to develop integrations to send Revenue, Division Order and General Ledger data to SAP.

Integrations were build using Informatica, SSIS and posted to Oracle databases.

Designed, Mapped, Build and implemented conversions, and integration relating to real time data flow for Accounts Payable, Accounts Receivable, General Ledger, Owner Membership, Benefit Plans, Claims and Division Order Data.

Part of team designing and coordinating development effort for process integrations for Revenue Accounting, General Ledger and Division Order Streams. Integrations from Artesia to SAP, Master Data Management to Artesia, and SAP to Artesia.

Involved in development and enhancements to mappings related to Revenue Accounting, General Ledger and Division Order Modules on CHK Financial ERP to EDW.

Integrations were build using Informatica, SSIS and posted to Oracle databases.

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

IT Coordinator / Sr. System Analyst / Technical Consultant Oct, 2005 – Aug, 2013

Interface 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 was part of technical team on integration and conversion 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

Was involved in Requirement gathering, Analysis, Participate in Data Model design

Part of a team decommissioning legacy based data mart, and building oracle based EDW. Extensively used Informatica 7.X/8.x/9.x to design and develop mappings.

Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Power Center.

Created design specifications including source to target mappings for Mainframe/Operational Source to Stage, Stage to operational data store (ODS) and form ODS to Data warehouse tables.

Designed and Developed complex mappings and workflows using informatica Designer, Workflow manager to load data different databases and flat files.

Helped to create load layer tool to generate XML mappings.

Worked with transformations like Lookup, Aggregator, Expression, Router, Filter, Update strategy, Stored Procedure

Tuning of SQL queries for better performance.

Working on Web Service Consumer transformation and XML transformation.

Created Mapplets with the help of Mapplet Designer and used those Mapplets in the Mappings.

Created reusable transformations and mapplets using Lookup, Aggregator, Normalizer, Update strategy, Expression, Joiner, Rank, Router, Filter, and Sequence Generator etc. in the Transformation Developer, and Mapplet Designer.

The tables had to be populated for use in daily load for the initial load ‘inserts’ and then updated using incremental loads and update strategy transformation for General Ledger and Revenue Data.

Extracting Incremental data (Change Data Capture) from Source Systems using Informatica Power Exchange for daily deltas and monthly bulk data.

Optimized the mappings by changing the logic and reduced running time and encouraged the usage of reusable objects.

Worked with mapping variables mapping parameters and variable functions.

Extensively used almost all of the transformations of Informatica including lookups, Stored Procedures, Update Strategy and others.

Designed and developed Informatica mappings for data loads and data cleansing. Extensively worked on Informatica Designer.

Lead designer and developer for enterprise cross-platform for Revenue Accounting and Division Order as both applications on legacy system.

Tuned performance of Informatica sessions for large data files by implementing pipeline partitioning and increasing block size, data cache size, sequence buffer length and target based commit interval and resolved bottlenecks.

Oversaw business analysts and developers in designing new Revenue Accounting and Division Order Functions to ETL data from legacy systems to Oracle based EDW using Informatica.

Performed data cleansing activities like Data Enhancement, Parsing, Matching and Consolidation.

Created UNIX shell script to get the data from external websites, unzip into flat files and loaded into warehouse.

Created Jobs & Job plans for the Workflows, SQL jobs & Unix scripts by using UC4 tool.

All the Job plans are scheduled through Autosys, UC4 Scheduler tool.

Validate the data in warehouse and data marts after loading process balancing with source data.

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

Lead developer on Revenue Accounting system

Technical lead for accommodating billion dollar processing logic for all functions across Revenue Account and General Ledger Postings.

Responsible for security architecture for applications developed

Primary developer for installation and integration of backup withholding functionality into Revenue Distribution Process

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

Work with cross functional team on design and implementation.

Worked extensively on Technical specification (TSD) and After Care Documents (ACD) .

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

Designed and developed cross-platform extract functions for CEO accounts, Owner Portal for Division Order.

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

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 PL/SQL for procedures & functions, SQL, RPG ILE, CLLE, COBOL to created new process/functions, Informatica and MS-SSIS for integration mappings and ETL processes and business logic in database.

Environment : CHK Financial ERP, Oracle 10g & 11g, PL/SQL, Toad, Informatica Power Center 8.X/9.X, Autosys, UC4, HPUX, Hyperion IR 9.X, DB2, XML Publisher, Agile methodology and Change Man Version Manager, RPG ILE, Free Format, Turnover, Hawkeye, Visio & Flow, SQL reporting tools.

General and Consulting for clients listed

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.

Nov, 2004 – August, 2005 : Oklahoma Insurance Department (OID), Oklahoma City, OK.

Consultant

May, 2004 – Nov, 2004 : Helwett Packard, Omaha, NE

Consultant

April, 2001 – March, 2004 : Dorel Juvenile Group, Columbus, IN

Consultant

July, 2000 – Dec, 2000 : Cummins Engine Company, Inc. Columbus, IN

Consultant

Oct,1999 – June, 2000 : Aluminum Corporation of America, Inc. ( ALCOA ), Indianapolis, IN

Consultant

Nov, 1998 – Sept, 1999: HTE Utility Software House, FL

Consultant

August, 1997- August, 1998: VISA International, FL

Consultant

Oct, 1996 – June, 1997: SQUARE-D SOFTWARE, INDIA

Consultant

TRAINING:

IBM Programming in RPG and COBOL

SYNON Tool

ETL tool (Informatica and SSIS) Process Builder Training

Oracle PL/SQL, Forms and Reports

HIGHER 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.

Presented to customer groups teaching about query tools to create add hoc reports. Saved over 80 hours per week for use groups.

Presented to customer group new functionality added to application to speedup daily operations for land group. Saved over 160 hours per month.

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.

TECHNICAL SKILLS

PLATFORMS AND TOOLS

Development Tools: Microsoft Office skills (Outlook, Word, Excel, PowerPoint), Microsoft Project, and Microsoft Visio, MS Visual Studio, Visual Basic, Business Objects, XML Publisher, Turnover, Hawkeye, Autosys, UC4, Visio, TOAD, and SYNON.

Programming Languages: C, C++, MS Visual Basic, HTML, SQL, PL/SQL, Unix Shell Scripting, Pascal, Fortran, RPG ILE, CLLE and COBOL

Data Warehose & ETL Tools: Informatica Power Center 9.x/8.x/ 7.x/, Microsoft SSIS, Hyperion.

Reporting Tools: Hyperion, Reporting Services.

Operating Systems: Windows 2003/NT/XP/98, Linux, UNIX, OS400, MS-Dos

Databases: Oracle 8.x/9i,10G/11g/12c, MS-SQL Server 2008,2012, MS-Access 2000, DB2.

Methodologies: Agile (Scrum) and Waterfall development methodologies.

Domain Knowledge

Industry

Years of Experience

Rating

Financial - Accounts Payable, Receivables, General Ledger,

Fixed Assets

18

8

Manufacturing, Distribution and

Warehosue Management System

8

8

Oil and Gas Accounting, Benefits Plan, Membership, Ownership

10

8



Contact this candidate