Email: ad1ebb@r.postjobfree.com Phone: 913-***-****

SUMMARY

In a comprehensive total 15+ years of IT experience in development and maintenance of Finance systems

* ***** ** ************** ***erience as Business Intelligence Specialist or Business Analyst in Finance Domain

The Financial Reporting Accountant reports to a Senior Accountant and performs a variety of accounting activities in accordance with Generally Accepted Accounting Principles (GAAP) and the Government Accounting Standards Board (GASB)

Experience in the public sector(University of California Office of President)

Proven experience in Oracle Cloud databases in ERP/EPM software, and other analytical technologies

Deep understanding of financial close cycle and best practices

Expertise in data modelling

Proficiency in Programming languages like Python and Pyspark

Expertise in SQL,Db2,Oracle and Mysql Databases

Experience with data visualization tools like Power BI or Tableau

Understanding of and experience with extract, transform load (ETL) concepts, tools, and practices.

Experience creating consolidated financial statements for public and private companies

Experience using Jira, Qualtrics and ServiceNow functionality for support

Experience in old to new conversions from old legacy systems to oracle FCCS

Proven experience in data analysis using SAS

Strong process optimization skills and the ability to define the benefit for process owners to pivot to the proposed process

Proficiency in synthesizing complex information into clear insights and translating those insights into decisions and actions

Manages communication with external parties (e.g., Deloitte) and addresses inquiries.

System Implementation (Billing Systems, Revenue Balancing & Reporting):

Participates in various billing and revenue reporting system projects

Works with IT business partner to ensure the functional design and business requirements meet the accounting and regulatory needs

Review IT test plans for alignment with accounting requirements and expected results

Performs User Acceptance Testing (UAT), as needed

Strong master data management, dashboard building and reporting background.

Perform analysis for business process improvement, application design and workflow automation

Documenting the processes flow for the requirement for future refrence

Modeling and documenting functional designs and process workflows

Everyday leading and working within campus and cross-functional teams that include business subject matter experts (SMEs), architects, developers, and testers.

Interface with different team and stake holders

Proficient in Software Design Life Cycle (SDLC) and quality aspect

Batch timing Reduction and Critical Path Optimization of long running critical path jobs

Experienced in Documenting, preparing Test Plans, uploading it in quality center & executing it.

Analyzing the root cause for the defect and involved in explaining the same to the team

Highly motivated and adaptive with the ability to grasp things quickly and possess excellent interpersonal technical skills

Worked as a Team lead assigning work to team members and handle client calls

Perform code release to various environments

Ability to logically organize information

Involved in quality control team meetings to understand the most probable and oversight issues faced by the team and prepare a checklist to handle issues further

Involved in SQL Performance tuning & Performance enhancements

Involved with clients gathering the requirements and developing documents for the client requirement

Have good experience in Development, Maintenance, Production support and Testing projects in Mainframes

SKILLS

Oracle Cloud : Certified specialist of Financial Consolidation and Close Service

Databases : DB2, Oracle, SQL

AWS Cloud : Glue Jobs, Athena, S3, Quick Sight, Lambda, Python, Pyspark

Tools : BI Publisher, Oracle OITB, Scheduler in Oracle

Project Experience

Worked as Business Systems Analyst with UCOP through Compunell Technologies. From April 2018 to till date

Worked as Business Analyst with Valsatech Corp. from April 2017 to March 2018

Worked as a senior software engineer in CGI, Mumbai from Jan 2011 to September 2011

Worked as an associate consultant in Datamatics Global Services, Mumbai from Dec 2008 to Jan 2011

Worked as an Assistant systems engineer in TATA Consultancy Services, Chennai from Feb 2007 to Sep 2008.

Worked as a Software Engineer with HSBC, Pune through Quinnox Consultancy Services Ltd. from Feb 2006 to Feb 2007

Worked as a Software Engineer with ISM Technologies, Bangalore through ISM Technologies from Nov 2004 to Feb 2006

Education:

Bachelor of technology in Sri Venkateshwara University College of Engineering, A.P., India.

Professional Experience:

UCOP, Oakland, CA Apr’18- till date

Business Intelligence Specialist

Project Description:

The Corporate Financial Data Warehouse is a repository of current and historical data originating from the

Corporate Account Fund Profile, the Corporate Financial system, the Corporate Budget System, the Corporate Staffing System, and the Common Chart of Accounts monthly balances file submissions from campuses who are mapping to the CCOA.

The Consolidated Financial System and Reporting (CFR) Replacement is a UCOP initiative to transition from CFR and Corporate Financial Reporting (CFS) to a cloud-based architecture with off-the-shelf software. The project entails:

Migration of CFR to Oracle Financial Consolidation and Close Cloud Service (FCCS) for the generation of UC's Annual Financial Statements using the Common Chart of Accounts

Migration of the CFS Financial Data Warehouse and existing canned reports to an Amazon Web Services data warehouse

Set up Account Reconciliation with ARCS for EPM CLoud

The new Amazon Web Services Financial Data Warehouse is a repository of current and historical data mapped to the new CCOA at the systemwide shared segment level. The data originates from the monthly campus file submissions for Corporate Account Fund Profile, the Corporate Financial System and the Common Chart of Accounts file submissions.

Responsibilities:

Collaborate with stakeholders in the data program to understand their requirements and objectives.

Conduct comprehensive analysis of existing data systems and processes to identify areas of improvement.

Work with product owner to gather and document functional and technical requirements to guide data solution development.

Analyzing old legacy data using SAS

Data modeling from the scratch to convert legacy systems to new retrofit system

Create new design of database,coding optimized SQL’s

Prepare documentation for annual audits and year-end financial reporting.

Load into Oracle database using Oracle Integrator tool

Answer accounting questions for other campuses and resolve issues for internal and external customers.

Assist in preparing the Annual Comprehensive Annual Financial Reports (ACFRs)

Assist in implementing new GASB pronouncements

Prepare the State Controller’s Report through Power BI

Analyze business transactions and recognize financial impacts

Proactively communicates issues and key activities to management

Identifies process improvements to reduce risk and create efficiencies during account review

Assists in the implementation of process improvement initiatives undertaken by the department

Document standard operating procedures for routine processes to improve quality consistencyMaintain thorough documentation of technical specifications for future reference and knowledge sharing.

Conduct regular reviews and updates of requirements based on project progress and changes.

Work with the Product Owner to assist in translation of communication between data program stakeholders and the engineering team.

Clarify technical concepts to non-technical stakeholders and ensure alignment with data program goals.

Act as a bridge between data program needs and technical implementation, ensuring seamless coordination.

Writing functional design specifications

Requirements traceability matrices

Perform analysis for business process improvement, application design and workflow automation

Documenting as-is and to-be processes

Modeling and documenting functional designs and process workflows

Developing test scripts

Transition plans and/or implementation requirements

Managing/updating configuration

Implementing best practice solutions

Collaborate with QA and testing teams to develop data test cases based on technical requirements.

Review test results and provide feedback to ensure compliance with technical specifications.

Assist in troubleshooting and resolving technical issues during testing and implementation.Support all affiliate customers during monthly, quarterly and year end closes.

Utilize Accounting knowledge and experience to consult with customers and translate business requirements into correct FCC system configurations.

Support and participate in the design of existing and new Oracle Reporting for Scheduled Processes, OTBI, Ad-Hoc Reports, and Dashboards as needed.

#1

Valsatech Corp. Baltimore,MD Oct’17- Apr’18

Business Analyst

Environment: Unix,Shellscript

Project Description:

The objective of 21st Century Auto Insurance Geographical Expansion project is to roll out existing application to new states viz. California, Florida, Georgia and Pennsylvania. 21st Century wants to expand their business to these states and hence states specific changes will be done to Enterprise Billing, Review & New Business. With the aggressive goal of introducing 21st Century to new states on a regular basis, this strategy will be used as a baseline to allow us to quickly provide a high level of quality without duplication of effort, thus reducing or saving time. Changes in Auto Finance and financial services of automotive lending in the whole project. Changes in Advance Loan System and Consumer Lending and re-financing of Auto Insurance is part of the project

Responsibilities:

Work with business stakeholders to identify workflow inefficiencies and automation opportunities.

Facilitate workshops with stakeholders to understand process pain points and recommend the best combination of process reengineering and automation to deliver the most value.

Perform root cause analysis to identify solutions that address the true source of issues.

Influence policy and process decisions to effectively utilize existing applications without the need for customization or automation when it makes sense.

Partner with Solution Engineers to determine project feasibility, level of effort and ROI.

Determine the prioritization of automation opportunities across various Finance teams and manage the automation pipeline.

Manage negotiations between teams and across organizational lines to promote the most effective and consistent global solutions.

Conduct comprehensive analysis of current business processes, including gathering and documenting requirements, workflows, and data flows using standard business process modeling (BPM) techniques.

Contribute to the overall maturity of the function through development of tools/templates and by providing education to peers and business partners.

2#

CGI, Mumbai Jan’11- Sep’11

Mainframe Developer

Project: Advantage Tool

Environment: Oracle,Java

Project Description:

Project Description:

AMS Advantage helps state and local governments manage their workforce by aligning their strategic human resources with organizational goals. With integrated functionality built specifically for the business of government, including unions, effective dating, electronic timekeeping, employee self-service and a simple retroactive pay process out-of-the-box, AMS Advantage clients are achieving their goals such as:

Recruit, hire and retain a competitive workforce

Allow employees access to information for managing benefits and leave

Improve employee service with around-the-clock self-service

Reduce redundant data entry with online forms and workflow

Access history of effective-dated transactions for auditable results

Reduce time between end of pay cycle and payday

Responsibilities:

Development and review of Cobol and Java programs.

Execution of the various SDLC phases supporting the QA, UAT phase

Project Management & coordination activities.

Deriving the financial quotations and planning the project schedules as well as resource

loading.

Incorporates the High-Maturity Processes into the project as part of CMMi v1.2

certification.

Deriving the detailed functional and technical requirements from the business

requirements.

Adherence to Quality processes throughout the project life cycle

#3

Datamatics, Mumbai Aug’09- Jan’11

Software Engineer

Project: Bupa Health Insurance

Environment: Unix

Project Description

Max Bupa Health Insurance is a Top most Insurance company in Australia. BAU deals with the production support for the whole insurance company. Having experience in Production Support & Maintenance project. In BOSS Maintenance project, Datamatics Global Services Ltd. has a Production Support Management process, which allows effective capture, reporting, tracking and resolution of Issues. This also includes continual and effective support of Batch Process scheduled daily in Production Environment. Following activities are performed in above process. Activate healthcare payment cards or increase utilization of healthcare payment products. With personalized cards, statements and correspondences from TSYS Output Services, we can create communications that educate members about plan benefits and help improve overall member engagement. Critical path optimization using Strobe tool and reduced batch overall timing from 3 hrs to 45 mins.

Responsibilities:

Tickets (issues) are tracked and assigned through Remedy tool to raise the issue

Analyzing the ticket depending on the priority level

Performance tuning of batch programs using Strobe tool.

Batch reduction time and performance timing results in better cost planning and speedy job process

Resolution, Processing and Management of Incidents in CA-Plex

Root Cause Analysis and writing SAS routines

Recreating and testing the ticket in test environment

Preparing Unit test results and sending analysis and test document to the client

Updating Remedy with the process and assign the ticket back to the client after resolution

Monitoring batch jobs in Hyperion on weekly rotation basis

Responding and quick resolution of any abends during batch monitoring

Sending e-mail and calling the client about the any abend occurred

Calculating the time taken for the jobs to run. In case the time exceeds the expected time, then tally the jobs and find out which job took extra time to run

Analyze the job and document the reason for extra run time

Documenting batch monitor process and send mail to the whole production team of client and offshore production team

Participating in weekly and monthly status meetings of the team

Having calls with the client about the business solutions for any change requirements

#4

Datamatics, Mumbai Dec’08- Aug’09

Software Engineer

Project: Bupa Health Insurance

Environment: Jav,Unix

Project Description

Hospital Casemix protocol creates reports of the entire Bupa Insurance company.

This report will be sent as a mail to the Health Department of Australia. This is a quarterly process. Hospitals send data to the Bupa Insurance through a CD or mail. The data is uploaded as a file into server through Automation process. All the claims are categorized. Valid claims are filtered and an EOS Report generated. At the end of each quarter a mail is sent automatically to the government of Australia.

Migrating part of the project from older mainframes to UNIX and Oracle from mainframes

Responsibilities:

Understanding the functional specification sent by the client

Prepare project estimates, document and send it to the client

Participating in meeting with the client and discussing about business solutions required

Preparing technical specification for the project required and get approval from the client

Analyzing the previous programs relating to the project

After approval, code new programs

Preparing jobs for the programs to run

Modify the existing programs if required

Unit testing of the programs developed is done in test environment

Preparing Unit test results and documenting technical specification with unit test results

Freeze the code and assign to the testing team

Discuss with the client for any changes to be done for the current code and modify according to the changes required

Analyze the job list and suggest time and location of the job in job cycle for production run

Perform batch monitoring on the day of implementation of the code

Resolving if any abend issues raised

#5

TCS, Chennai Feb’07- Sep’08

Systems Analyst

Project: JPMorgan Chase

Environment: Cobol, JCL, DB2, DBMS, CICS, VSAM, REXX, PL/1, Coolgen

Project Description

Enterprise Banking System (EBS) comprised of two separate systems (SBS and STARBASE) running in disparate technology architecture and framework thereby resulting in data and transaction integrity issues. The EBS re-engineering initiative has been formulated to address these issues and thereby re-engineer the system to position the Bank for a world class EBS that is encompassing of best of breed features while retaining its robustness from a functional and performance perspective. The primary object of the project thus included the following. Re-engineer the existing systems to define and Build a new service based architecture framework. Migrate the system out of the existing outdated PACABSE (tool driven software) to a structured framework. Change in Data model reflects in Payment Processing, Taxes, End of Term and Extension processes. Process clients' ACH payments daily and protect them from fraud. The best way to safely automate the growing volumes of ACH payments, ensure quick and efficient ACH payment processing, and bolster your bank's revenue is with PEP+

Responsibilities:

Understanding the business of the project

Understanding data model for the change required

Analyzing the existing programs

Working with TSYS tool to check risk prevention, creating personalized cards

Preparing technical specification for the modification of the business and send to the client

After approval start modifying the code and start unit testing

Prepare Unit test results and document it to the client

Freeze the code and send it to the testing team

Discuss with the client and modify any programs required for the business change

Monitoring production support for the project

Handling urgent issues for production jobs

Testing and fixing the issues as soon as possible

Participating in weekly and daily status meetings

Knowledge transfer to the new employees in the team

#6

Quinnox, Pune Feb’06- Feb’07

Mainframe Developer

Project: Auto Data Warehouse, HSBC

Environment: Cobol, JCL, DB2, CICS, VSAM, REXX

Project Description

HSBC Auto Data Ware house is part of HSBC credit card modulation with nearly $123 billion in managed assets, is a consumer lender that has been serving the middle-market customer since 1878.Household was acquired by HSBC Holdings plc. Household is grouped into different Business units (BU) as per the business functionality needs. The Auto Data Warehouse provides business users the ability to do analysis over time. This helps them to answer various business questions on behavior analysis, profitability of customers over time, usage and profitability of products, retention of profitable customers and marketing promotions. Making changes in Collections, Delinquency Tracking, Repossession, Charge Off, Recovery, Bankruptcy, and Accounting departments. Using TSYS tool for risk prevention, business servicing, account self-servicing. TSYS marketing platform enables clients to automate member communications to help lower costs, improve return on expenditures and deliver better customer interactions

Responsibilities:

Understanding the data model and requirement of the client

Preparing functional specification for the project

Preparing technical specification for the project after approval for functional specs

After approval start modifying the code and start unit testing

Prepare Unit test results and document it to the client

Freeze the code and send it to the testing team

Discuss with the client and modify any programs required for the business change

Monitoring production support for the project

Handling urgent issues for production jobs

Testing and fixing the issues as soon as possible

Participating in weekly and daily status meetings

Knowledge transfer to the new employees in the team

#7

ISM, Bangalore Nov’04- Feb’06

Mainframe Developer

Project: HCA IT&S

Environment: Cobol, JCL, DB2, CICS, VSAM

Project Description

This project has been divided into major areas of business viz., Financial reporting HR Payroll, Patient Accounting. Financial Reporting mainly deals with the financial applications like General Ledger, Budget, Patient Accounting, QMIRS etc. The Budget application maintains the Budget data of the HCA. It contains Current Year actual and next year Projections by month wise. Here almost all jobs are request jobs. This project involves the Maintenance and Enhancement activities. The production support is done by offshore and onsite in shifts. Apart from the production support activities we will be getting the enhancements tasks in the form of PNRs AND PWRs which has to be done and sent to the onsite.

Responsibilities:

Analysis of the specifications provided by the clients

Preparing Low Level Designing

Coding and Code Review according to the Check List

Review of work done by other team members

Preparation of Unit Test Plans

Contact this candidate