SUMMARY

• Solution - oriented professional with 10 years and 8 months of experience in designing and supporting complex Financial and Enterprise BI web applications.
• Extensive experience as a Business System Analyst with emphasis on requirements and business process improvement, tactical planning, identifying and resolving solution to teh business needs
• Experience in working through all phases of Software Development Life Cycle (SDLC) including teh design, development, implementation, and maintenance of financial applications
• Proficient in Creating Business Requirement Documents (BRD), Functional Specification Documents (FSD), and converting business requirement into Software Requirement Specifications (SRS)
• Good knowledge and solid expertise in Waterfall, Agile Methodology & working knowledge on JIRA
• A clear communicator, team building, strong analytical & problem solving skills, and a well-organized individual, Involved in Business Analysis, Requirement mapping, Design, Development and Test Support
• Certified JAVA professional and have experience working with financial applications
• Demonstrated ability to work both in independent and team-oriented environments with well-developed organizational skills and excellent interpersonal skills.
• Strong analytical and problem solving abilities with excellent oral and written communication skills

PROFESSIONAL EXPERIENCE

Sr. Business Analyst

Confidential, Charlotte, NC

Responsibilities:

• Participate in user projects relates to financial applications and provided critical analysis & support
• Interacted with Business head & developed FSD, coordinated with technology team for successful
• Developed test scripts and coordinate UAT of technology components
• Develop and update user documentation and procedures regularly to capture system/process changes
• Hedge Accounting entries related LOB Coordination, Update & Validation
• 3 way OOB report validation and triage out of balance (OOB) variances & explained discoveries in custom Java application
• Broadcast controller’s group on Close & OOB status and associated critical tasks
• Received high recognition from controller’s group for maintaining DRM Hierarchies on time. Quickly assess teh DRM Legal Entity maintenance requests Incorporate teh changes into LE TOTAL hierarchy
• Successfully executed 3 way validation for OGL R12 migration. Successfully performed 3 way Recon. validation between Essbase vs OGL R12 vs IRIS Web systems for APAC, EMEA iLedgers, AMER USD and AMER CAD Ledgers for Final and Interim cycles.
• 100 % compliance on Reporting & Sync. changes - Quickly Implemented Corporate Regulatory Reporting by applying changes to Dodeca, DRM Live and Archived Reg Reporting version and worked with tech. teams to sync. change across systems
• Monitor closely teh daily General Ledger, Fixed Assets and Non Merchandise critical data loads and analyze any Issues in case of any failure.
• TranslatedBusinessrequirements into functional specifications and created user stories in JIRA
• Provided detailed research & analysis to financial planning, controllers business users’
• Assisted in designing solutions for maintenance requests to resolve critical problems & 100% system availability
• Analyzed and Reviewed Lawson files are successfully loaded to Essbase and tracked observations in JIRA
• Documented procedures to capture key critical validation alerts and escalation mechanism to be followed
• Received high recognition from client for validating Hyperion patch set 11.1.2.1.103. Validated patch set to train & transition users to Smart View when teh hyperion system gets upgraded to latest version in 2017 as teh classic excel addin no longer supported
• Successfully Migrated HFR reports from Prod to Dev/QA. Successfully migrated more TEMPthan 30 reports from production to development environment to enable FY17 Spring enhancement

Business Analyst

Confidential. Pleasanton, CA

Responsibilities:

• Responsible for all maintenance and business analysis activities during Month End close, Forecast, LRP & Budgeting processes
• Addressed user queries and shared analysis, root cause for requested data, ensuring process flags, variables, filters are set up appropriately for different financial cycle
• Suggested best practice for efficient application monitoring and back-up
• Analyzed data discrepancies in Domestic, S&OP Essbase cubes and/or mapping issues with different upstream systems
• Add Limbs and Leafs’ nodes to existing structure as specified in BRD on DRM
• TranslatedBusinessrequirements into functional specifications for automating international division cost center actuals from LATAM and captured all changes, artifacts in Service now
• Successful Execution of yearend and quarter end (QE) close processes: Received well appreciation and recognition from customer for teh flawless execution of actuals and quarter end close
• Budget, Forecast and LRP process cycle executed successfully with system availability and data accuracy of 100%. Published planning system scorecard for May forecast with day wise details of system availability and data accuracy
• Involved in fast paced knowledge transition to handle critical requests during incumbent resource absence
• Had a quick understanding on Belk Hyperion Landscape and supported teh environment
• Addressed user queries and resolved ticket requests with in defined SLA
• Monitored critical GL Close cube loads and kept business customers informed about its status and completion
• Work closely with business users to understand teh Issues with teh application and Interact with teh upstream system teams to figure out teh root cause and provide resolution

System Analyst

Confidential, Bentonville, AR

Responsibilities:

• Monitored closely teh daily Essbase data loads and resolved any technical Issues in case of any load failure
• Ensure that HFM, workspace & shared services components are up and running during teh month end closure event and ensured successful multiple period, QTR closures
• Co-ordinate with teh Hyperion Infrastructure team to recycle teh services and successfully validated teh components are up and running
• Recreated customer reported Issue in CERT / QA environment and provided root cause analysis and resolution to Implement in Prod
• Assess planning system and provide user with detailed analysis on data
• Assisted HFM business users to load data to teh FDM application by setting up appropriate mapping with target HFM application
• Fully automated teh data load and dimension load for Separate accounts & Management reporting Essbase cubes
• Involved in setting up Hyperion Administrative tasks. Assigned various privileges to groups and users
• Contributed in teh development of Essbase cubes, created rule files, built dimensions, loaded data, restructured cubes, maintained regular backups of cube, outline, restored cube from backups etc
• Automated and scheduled teh Meta data and data loads for all cubes (Management Reporting, etc)
• Captured teh entire batch process flow of all cubes in MS Visio and demonstrated teh flow to teh team
• User management over teh Web provides a single point for teh administrator to create users for teh Hyperion environment, and assign them to specific BPM domains, including role and security class access
• Complete alternate data input environment for users through support for Financial Management Web Data Forms in teh MS Office Smart View add-in
• Troubleshoot data discrepancies and/or mapping issues between different systems and work with teh finance team to resolve them
• Extensively involved in maintenance and modification of batch scripts and Metadata outline.

Programmer Analyst

Confidential

Responsibilities:

• Communicate with client to gather requirements on Compliance-K, Invoice Logging system, PQA application enhancements
• Prepare questionnaire & Understanding documents based on teh requirements captured and share it with customer
• Clarify teh queries raised during customer connect discussions and share teh minutes, document teh clarifications received
• Worked on PL/SQL for writing Stored Procedures, Packages, Functions and Database Triggers
• Resolve defects out of releases Compliance-K P I & P II, Invoice Logging System enhancements
• Deployment and go-live support

TECHNICAL SKILLS

• Oracle Hyperion Essbase 11.1.2.x
• Hyperion Planning 11.1.2.1, Hyperion Financial Management 9.3.x,11.1.2.x
• Hyperion Financial reporting, Hyperion Smart view, Hyperion Essbase Spreadsheet Add-inHyperion DRM, Tableau 9.0.1, Oracle BI Publisher 12c, Informatica Power center client tools 8.6.1
• Oracle Data Integrator 11G, MS Sharepoint
• Cold Fusion MX7, JavaScript, SQL, PL/SQL, C/C++, Java, Oracle 10G, MS SQL Server 2008.
• Oracle SQL Developer, HP Quality Center, Harvest (version control), SQL *PlusTOAD, Service Now, Maximo, Service Desk Manager (SDM), Remedy 7, Xshell (Linux)
• Windows 2012/2008/2003/NT 4.0/98/95, Oracle Exalytics
• PPM, Microsoft Visio 2000, JIRA - Kanbon, Planview, Requirements GatheringDesign, Development, Rollout, Post Implementation support