SUMMARY

• 15+ Years of IT experience in developing and supporting financial systems - ERP Financials and EPM, Business Intelligence, Planning Analytics - Budgeting and Forecasting, Corporate Reporting.
• Implemented Planning process for department Operating expense, Sales forecasting, profitability forecasting, workforce planning and merchandise planning.
• Worked with other finance team users to scope detailed business and functional requirements for TM1/Planning Analytics solutions to optimize corporate reporting and planning processes.
• Expertise in building TM1 models in Planning Analytics which includes dimensions, cubes, processes, rules, feeders, chores, security, MDX.
• Developed input templates and reports for budgeting and forecasting, actual analysis, variance analysis, trend analysis, financial KPI reporting - DSO, DIO, DPO, Cash conversion, working capital analysis.
• Worked on Implementing, Upgrading, Cloud migration and supporting IBM Cognos TM1 for Planning and Analytics, Oracle BI Reporting (OBIEE), PeopleSoft Financials, and Blackline for financial reconciliation.
• Good understanding of ERP financial business processes - General Ledger with Multicurrency set up, Capital Asset management, Project costing, department expenses, supplier spend analysis, Customer payment performance analysis. Revenue and Receivable Analysis
• Experience in OLTP and OLAP reporting - Cube design, Dimension and measure design.
• Experience in developing Trial Balance, Balance sheet, Income statement reports, Variance Analysis, and Comparative reports.
• Hands-on experience with Data Analysis, Querying using SQLs (Oracle/DB2/MSSQL), considerable exposure data warehouse technologies, and ETL processes.
• Worked on reporting tools like IBM Cognos TM1, OBIEE, BI Publisher, PeopleSoft nVision report, Crystal report, VBA scripting in Excel.
• Extensive knowledge on all phases of the Software Development Life Cycle - Requirement gathering, Analysis, Design, Coding, Testing, Reviewing, Implementation and Production support.
• Experience in Retail, healthcare, Manufacturing, and banking.
• Knowledge of the systems development life cycle including structured analysis, test, and documentation required for building and supporting finance applications
• Experience in managing multiple projects and oversight of multiple resources - Onsite and Offshore, communicating with C-level finance executives.
• Established outstanding client relationships, strong Project leadership and project management capabilities.
• Staff augmentation, managed service, and onsite-offshore model experience.
• SLA tracking, response time and resolution time management, working with a third-party solution provider.

PROFESSIONAL EXPERIENCE

Confidential, Atlanta GA

Sr. Architect - Financial systems, Planning Analytics

Responsibilities:

• Develop and maintain the Planning Analytics, Business Intelligence and PeopleSoft Financials ERP roadmap and drive delivery against the roadmap.
• Collaborate with FP&A and other finance team users to scope detailed business and functional requirements for TM1/Planning Analytics solutions to optimize reporting and planning process.
• Implement Planning analytics for domestic and foreign subs using their chart of account and data source and also provide GAAP reporting for each subs.
• Develop the TM1 models in Planning Analytics which includes TM1 cubes, processes, chores, security, rules, hierarchies.
• Define interface specifications for TM1 data loads and map data across systems for TM1 integrations with external data sources.
• Run and schedule TM1 processes, Roll-forward system to forecast and budget month, perform month-end, Quarter-end and Year end manual activities.
• Design Sub Ledger reporting (Account Receivable, Payables, Asset Management) in OBIEE.
• Migrate Reports from Peoplesoft to analytical platform - OBIEE and TM1.
• Formulate Strategy on Data Archiving/Retention.
• Work with Admin Team to develop a disaster recovery plan for Financial application.
• Assist in the creation, maintenance and distribution of standard reporting to the organization. Troubleshoot issues, identify solutions, and resolve.
• Ensure development, review, and maintenance of the necessary documentation supporting projects or internal processes.
• Oversee ongoing development to ensure the timely and accurate delivery of requirements to stakeholders.
• Establish Service level agreement for production support activities.
• Provide support for SOX audit.
• Provide the Director of the Finance with status reports and keep them apprised of overall project status
• Work with Onsite and offshore resources, distribute task and maintain status

Confidential

Lead Consultant

Responsibilities:

• Coordinate with the clients to understand business requirements.
• Provide solutions and industry expertise to customers and project teams for solution design and development.
• Apply advanced application programming concepts in designing, developing, modifying, debugging and evaluating highly complex programs for functional areas.
• Create reusable, repeatable and transferable designs that can be leveraged for other solutions.
• Streamline business processes and best practices to improve efficiency within the team.
• Participate in peer reviews and recommend improvements.
• Prepare test scenarios, system testing, assist in UAT testing, and conduct train the trainer sessions.
• Provide support in all phases of SDLC.
• Drive key meetings and workshops to achieve the outcomes within the deadlines.
• Identify performance bottlenecks, process improvement opportunities, and recommend a solution.
• Look for new OOTB (Oracle out of Box) features and find out the de-customization opportunity.
• Assist in preparing project plans, effort estimation for each phase and develop a resource plan.
• Prepare cutover activities. Plan production outage with functional, technical and business teams.
• Support team members on issues and upcoming changes in the production environment.
• Provide training and mentoring junior team members.

Confidential, Saint Paul MN

Responsibilities:

• Implemented FIFO method of costing inventory
• Developed Bolt on module for manufacturing data
• Developed interface for loading manufacturing data like material issue for manufacturing, machine hours and labor hours.
• Created report to calculate production variances.
• Developed process to capture month end snap short of inventory balances.
• Involved in design and development of Inventory Items (SKU) data Conversion /migration from different legacy systems like CIAS and others into PeopleSoft, by creating Cross-reference tables, custom Component Interfaces for the delivered Components, that were called in the Custom Application Engine program, with the client specific business rule.
• Analyzed PS delivered FIFO method of costing, Cost adjustment, User adjustment, Variance calculation, RTV costing, RMA costing. Figured out table loading sequence.
• Modified cost adjustment process. Customized Onhand view to limit number of rows returned. Customized delivered costing logic that was creating redundant row in depletion calculation.
• Asset transactions from the legacy system were mapped to PeopleSoft, using an excel template and a custom Conversion program.
• The data was loaded into PeopleSoft Asset Management Interface tables.
• The delivered edit process was used to make necessary changes to the conversion transactions while the assets reside in the interface tables.
• When the edit process determines that there are no errors, the Transaction Loader process load the asset transaction from the interface table into the PeopleSoft Asset Management tables.
• The Depreciation Calculation process executed on the newly created assets.
• Verification of the load was done by running delivered reports for asset activity, depreciation, and net book value, and by inquiries using panels and queries.
• Developed ExcelToCI template for loading set up data like Book, Profile, category etc.
• ConfiguredLocations, Calendars, and createdAM Business Units, Assets Accounting Entry Templates.
• Configuredcost types and capitalization limits, depreciation schedules.
• PerformedAsset maintenance - Asset Adjustments,Re-categorizations and Transfers.Retired and Reinstate.
• These reports were created since delivered SQR were giving output in PDF whereas finance users wanted reports in Excel.

Confidential, Morristown NJ

Responsibilities:

• Analyzed and documented traditional credit card processing in PeopleSoft and identified all tables where credit card information was stored.
• Designed and developed an Integration program for sending synchronous messages to Cybersource.
• Design data conversion process for moving credit card details to Cybersource, generating tokens, and updating tokens in PeopleSoft.
• Co-ordinate with the Cybersource team to set up Customer Profile and payment tokenization.
• Set up a new credit card processor.
• Ran the cleanup process to delete credit card information from PeopleSoft

Confidential, Anaheim CA

Responsibilities:

• Work with conversion team to transform legacy system data in to PeopleSoft
• Designed and developed integration with Bloomberg for loading market rates.
• Designed and configuredchart-fields. Modified and customizedchart-field labelsto suit business need.
• Set up chartfield edit and Combo edit rule for validating chart of accounts
• Set up Allocations
• Design and developed a process for Intercompany Profit elimination.
• Configure Spreadsheet upload process for importing journals
• ConfiguredBusiness Units, Ledgers and Ledger Groups.
• ConfiguredJournal Sources.
• Designed and configuredcombination edits and closing rules.
• DesignedGL Journal approval workflow.
• CreatednVision Balance Sheet reports.
• Modified and maintained Income Statements, Trial Balances and Cash flow statementsfor existing Business Units.
• Configured newAllocationsincludingInter-Unit Allocations.