SUMMARY:

• Working as an OFSAA Consultant for Confidential, has over 13.5 Years of experience in IT industry with Banking domain. Around 3 Years of experience in configuring and implementing solutions related to EPM and ERM suites of OFSAA and 10 Years of Quality Assurance and Testing.
• Accomplished extensive experience in broader financial transformation programs using OFSAA and analyzing OBIEE reports at major financial institutions like Confidential, Key Bank and Wells Fargo which involved the implementation of Confidential, Funds Transfer Pricing, Credit Risk and GL Recon modules as well as OFSAA version upgrade programs and gained knowledge on different financial statements and risks.
• Good understanding of OFSDF and its different OFSAA Data Models and the data flows involving Profitability, Credit Risk, Funds Transfer Pricing, FED Regulatory Reporting with Lombard risk, Liquidity Risk Management as well as its component OFSAAI.
• Aggressively worked on OFSAA PFT, Credit Risk and GL Recon module and limited work on OFSAA FTP. Having thorough knowledge and understand OFSAA LRM and good understanding on Basel regulatory capital (internal ratings based approach) as well as Fed Regulatory reports.
• Worked on transforming business oriented functional requirements in the form of F2T, T2T, Post Load transformations using PL/SQL and all the components of BMM (Datasets, Business measures, Business Processers, Derived entities) and creating runs using Run Rule Framework & execution of batches for the same in OFSAAI.
• Worked on Uploading of UNIT Costs and Configuring Revenue Allocation rules in OFSAA for Profitability and Funds Transfer Pricing Calculations. Also, worked on Manual adjustments file uploads & Configuring DQ Rules in OFSAA through UMM Module of OFSAAI.
• Having a strong analytical experience in identifying the gaps in reporting data in OBIEE and implementing best practices in different Reconciliation Strategies to handle heavy volume of financial data of different financial products which are processed through incremental data feeds as well as historical data into OFSAA which is loaded into OBIEE through Essbase cubes for reporting and then to different downstream data marts. Also, between the legacy 4.5 & 6.1 versions of OFSAA. Resulting into early reporting of gaps and impact analysis in data loads and resolution time.
• Expert in identifying the gaps between GL recon data and Instrumental data. And evaluating the outputs of a variety of allocations and fixing them.
• Acted as liaison between the customer and onsite/offshore to teams to fold the OFSAA related requirements. Worked with business users to provide customer insights for Financial Planning and Analysis (FP&A) during UAT Testing and leading UAT Teams.
• In - depth understanding of Erwin Data Modeling and Dimensional Hierarchies which are applied to Confidential, Credit Risk, Funds Transfer pricing and LRM modules.
• Gained expertise in preparing Test approaches, Test strategies, Effort Estimations, Test plans, Checklists for Test design, Execution, Defect process, Test Evaluation summaries and Test metrics etc and involved in each phase of testing life cycle until UAT
• Expert in identification of Gap analysis and preparation of Requirements mapping using ALM /Quality Center/JIRA which enabled the complete test coverage in all the projects handled as a part of Release planning
• Having execution experience in various types of testing like ETL Testing using Teradata, Oracle, Control M jobs, Data warehouse Testing using OFSAA and Web Services Testing using SOAP UI, Content Management testing, Disaster Recovery Testing, Failover Testing
• Proficient in designing SQL queries for Back End testing using Toad, SQL Developer, Oracle, Teradata to test the data integrity of the application and databases using SQL.
• Worked on analyzing and testing the Business Intelligence reporting tools like OBIEE and BRIO that are present in the datawarehouse and are generated from the datamarts
• Experience with Oracle applications and databases.
• Experience in testing Informatica Workflows and Sessions using Informatica Work flow manager.
• Worked on several Always on Technologies like Application migration project: Savvion to IBM Messaging Queue, Version Upgrade Projects like Oracle Client Upgrade, Capstone Upgrade, Savvion Upgrade and Data Migration Projects Golden Gate and Data Pruning
• Expertise in Data analysis, Data modeling, Data migration, and Business intelligence solutions
• Expert in Mainframes JCL Jobs execution and trouble shooting of the abends to perform source to target validation in the Datawarehouse projects.
• Experience in several testing methodologies like SDLC, Rational Unified Process and Agile Scrum Methodologies. Gained in-depth knowledge of Testing Methodologies and Quality Assurance standards by working with different clients.
• Experience in using the Version One and Mingle tools for maintaining, estimating and Tracking the status of the User Stories in Agile Environment.
• Worked on Multiple projects with multiple stake holders and could deliver the deliverables on time and met aggressive deadlines

TECHNICAL SKILLS:

Operating Systems: Windows, UNIX

Programming Languages: Knowledge on C, C++, VB

Scripting Languages: VB Script

WWW Development: HTML, XML

Database: Teradata, Toad, Oracle, SQL Server, and DB2.

Test Management Tools: ALM, JIRA, Quality Centre, Clear Quest, Rational Requiste Pro, Test Director

BI Reporting Tools: OBIEE, BRIO

Configuration Tools: Share Point, VSS, Rational Clear Case

Automation Tools: QTP, Load Runner

Web Servers: Microsoft IIS, Web logic

MSSuite: MS-Word, MS-Excel, MS-Outlook

Other Tools: SOAP UI, Mainframe ( JCL, CICS, FILE AID),Control M, Ondemand,Putty,Informatica, Autosys Batch Jobs

Agile Tools: Version One, Mingle

Methodologies: Waterfall, RUP and Agile Scrum

Architectures: OFSAA 4.5 & 6.1, ESSBASE, IBM MQ, Savvion

PROFESSIONAL EXPERIENCE:

Confidential, Jersey City, NJ

OFSAA Consultant (Developer, Analyst and Testing)

Responsibilities:

• Gathering requirements from business users to create Data mapping and Data lineage documents
• Providing Profitability Solutions for the banks Overhead, Indirect and Direct Support allocations.
• Working with business to design the different profitability reports at Organizational, Customer and Product level.
• Documenting the BRDs, DDDs for the data flow with respect to OFSAA T2Ts, Allocations and other BMM objects.
• Configuring Table to Table (T2T), Data sets, Business Measures, Business Processors, Derived Entities and Post Load Transformations in OFSAAI by writing complex SQL Queries and PL/SQL coding when needed.
• Configuration of Data Filters, Expressions, SQL Rules, Allocation Rules and models in OFSAA 6.1 version.
• Creating, executing and closely monitoring of Runs and Batches and identify application/process related issues if any.
• Reconciliation of high-volume data between OFSAA 4.5 and OFSAA 6.1 as part of Data loading and allocation process.
• Debugging and solve data related issues.
• Migrating the Allocation Rules and T2Ts between environments
• Standardizing and automating the process of reconciliation of High-volume data from different sources
• Reconciliation of OBIEE Reports at different dimensional levels for different financial measures for various time periods (Profitability Reports and Risk Related Reports)

Confidential, Cleveland, OH

OFSAA Tech Lead

Responsibilities:

• Understanding of Profitability Management Implementations and reporting related to verification of Customer Organizational Profitability and Risks.
• Understanding Download specifications for various modules of OFSAAI and provide required guidance to ETL teams to get the data into staging tables and provided logic transformations.
• Understanding of logical and physical OFSAAI data model and ETL Process
• Uploading of UNIT Costs and Configuring Revenue Allocation rules in OFSAA for Profitability Calculations
• Building Table to Table (T2T) Transformations and Business measures, Business Processors in OFSAAI by writing complex SQL Queries.
• Manual file uploads & Configuring DQ Rules in OFSAA through UMM of OFSAAI
• Scheduling and Executing Batch Jobs, creating sql and maintain OFSAA Configurations. Validating the SCD Process to handle Dimensional Hierarchies
• Transforming business-oriented functional specifications into ETL and OFSAA Test Scenarios and associated Test cases
• Identifying Test strategies to process incremental data feeds as well as historical data into OFSAA and then loading into OBIEE for reporting
• Identify test data to Test Business Intelligence (BI) Reports using OBIEE, relational structures and dimensional hierarchy data modeling
• Supporting implemented BI Test Solutions: Creating Complex SQL Queries using Spool Scripting in Oracle and Teradata. And fine tuning any complex queries that impacts Performance with the given Data cleansing rules, Source filter criteria, Default values for reuse.
• Involving in analysis of data issues from upstream and downstream applications associated with the OFSAA and its datamarts
• Participates in functional design reviews
• Reviews work deliverables of peers
• Evaluating and providing estimations for upcoming releases and change requests
• Troubleshooting issues related to data integrity
• Depicts adequate Knowledge of Oracle E-business suite OFSAA and Profitability domain and proactively creating knowledge documents for the QA team and provide training to new joiners on business intelligence analysis tools, dashboards and OBIEE Basel regulatory reports.

Environment: Oracle 10g, SQLDeveloper OBIEE Tool, OFSAA, ESSBASE, Beyond Compare, Informatica, Teradata Client 14.0, HP ALM, JIRA, SharePoint

Confidential, Charlotte, NC

Senior Computer Programmer Analyst (ETL/ OFSAA QA)

Responsibilities:

• Understanding of Profitability Framework and OFSAAI PR2 frameworks and Profitability Management Implementations and reporting includes Proprietary and other reports.
• Complete understanding of logical and physical OFSAAI data model and ETL Process
• Transforming business-oriented functional specifications into ETL and OFSAA Datawarehouse Test Scenarios and associated Test cases
• Identifying Test strategies to process incremental data feeds as well as historical data into OFSAA datawarehouse and then loading into datamart for reporting
• Identify test data to Test Business Intelligence (BI) Reports using OBIEE, relational structures and dimensional hierarchy data modeling
• Supporting implemented BI Test Solutions: Creating Complex SQL Queries using Spool Scripting in Oracle and Teradata. And fine tuning any complex queries that impacts Performance with the given Data cleansing rules, Source filter criteria, Default values for reuse.
• Performed Reference data uploads related to cost factors that are associated with different metrics and dimensional Hierarchical Updates and also manual file uploads in OFSAA through UMM Data Entry Forms and Queries
• Test execution and review along with Automation of business ETL workflows using in-house ETL Test Frameworks in OFSAA and performance activities
• Feasibility, gap analysis and impact analysis for highlighting risks.
• Involving in analysis of data issues from upstream and downstream applications associated with the OFSAA datawarehouse and its datamarts
• Validating the financials (BPs) between OFSAA ESSBASE Cubes vs OBIEE Portal and Data Marts which are created for different LOBs. Compare the target table data with different Source data that resides on different databases on different platforms.
• Validating the DQ Rules and Hierarchies that are developed in OFSAA
• Analyzing the Profitability and Risk Reports using OBIEE
• Validating the Materialized Views and Datamarts in Teradata against the OFSAA results area
• Performing the data movement validation within datamart that are created on Teradata Platforms at different layers STAGE, BASE and Semantic.
• Participates in functional design reviews
• Reviews work deliverables of peers
• Evaluating and providing estimations for upcoming releases and change requests
• Troubleshooting issues related to data integrity
• Depicts adequate Knowledge of Oracle E-business suite OFSAA and Profitability domain and proactively creating knowledge documents for the QA team and provide training to new joiners on business intelligence analysis tools, dashboards and OBIEE reports.
• Participating in interviewing genuine and qualified candidates for the project requirements.

Environment: HP ALM, Oracle 10g, OBIEE Tool, Teradata Client 14.0, OFSAA, ESSBASE, Beyond Compare, Informatica, SharePoint

Confidential

Scrum Coordinator, Technical Test Leads

Responsibilities:

• Involving in Test Effort estimation for Agile projects based on a high level understanding of what needs to be done and required to track progress toward achieving these commitments
• Responsible for Test Strategy, Test Planning, review of test scenarios and test cases.
• Playing the role of QA Scrum Coordinator for 4 Scrum Teams to ensure On-time delivery and address Risks and Challenges well in advance
• Participating in Grooming Sessions where all the Business Analysts, Developers, QA and end users are involved and work as a single development team to split the requirements into user stories after further analysis
• Responsible for creating user stories and task allocation in Mingle.
• Transforming business-oriented functional specifications into ETL and Datawarehouse Test Scenarios and associated Test cases
• Worked on Test data Management to identify different varieties of test data.
• Performing Data Driven and Database, ETL and Datawarehouse Testing for verification of results.
• Validating the BI reports related that are present in the datawarehouse through OBIEE
• Preparation of complex SQL Queries using Oracle and SQL Server
• Providing support to UAT Testing Team
• Allocating work to offshore automation teams and discuss the business requirements and automation requirements and mentor the team to further work on the pending automation work by providing 24X7 testing services to the client in global delivery model and resume the work at onsite
• Involving in Defect prevention process by reviewing and tracking defects in QC
• Involved in daily and weekly test Summary report preparation and test closure activities

Environment: HP ALM, Mingle, GUI, SQL Server, SOAP, Oracle, Informatica, OBIEE

Confidential

Technical Test lead

Responsibilities:

• Participating in Grooming Sessions where all the Business Analysts, Developers, QA and end users are involved and work as a single development team to split the requirements into user stories after further analysis
• Involving in Test Effort estimation for Agile projects based on a high level understanding of what needs to be done and required to track progress toward achieving these commitments
• Responsible for creating user stories and task allocation using Version One Tool
• Transforming business-oriented functional specifications into ETL and Datawarehouse Test Scenarios and associated Test cases
• Test Planning, design, review of test scenarios and test cases.
• Executing workflows in Informatica for data movement.
• Performed database, ETL and datawarehosue Testing to validate several areas like counts, data mappings, Business rules, Batch Jobs dependency, and check points to validate failover, error handling, sampling, performance, Disaster recovery and connectivity.
• Involved in analysis of Data modeling and Database design, Data migration
• Preparation of SQL Queries using Oracle
• Coordinating with Multiple stakeholders for multiple projects in performing Web services testing using SOAP UI and Performance Testing using Load runner
• Execution of Regression Automation suite and troubleshooting in case of script failures to identify functionality defects and script issues
• Providing support to UAT Testing Team
• Allocating work to offshore automation teams and discuss the business requirements and automation requirements and mentor the team to further work on the pending automation work by providing 24X7 testing services to the client in global delivery model and resume the work at onsite
• Involving in Defect prevention process by reviewing and tracking defects in ALM
• Coordinating between onsite offshore teams on knowledge management activities of the project to improve the skill set of the resources in the team
• Involved in daily and weekly test Summary report preparation and test closure activities

Environment: HP ALM, Version One, GUI, SQL Server, Microsoft IIS, Weblogic, UNIX, Windows XP, Capstone, Savvion, Informatica, ORACLE

Confidential - Denver, CO

Technical Test Lead

Responsibilities:

• Participate in meetings with business to understand the AS IS and To Be functionalities
• Providing estimates for validation of requirements, creation of business End to End flow documentation, To Create Automation Scripts, Test planning and Testing activities
• Reviews all the risks and mitigation plans with the stakeholders
• Involving in High level testing approach discussions with client manager
• Preparation of test strategy document based on requirements understanding and scope of the testing
• Walkthroughs on the test plan documents with different stake holders involved in the project.
• Test Data requirements will be identified to proceed with test data preparation.
• Ensure all risks are documented, approved, validated, tested, have a Contingency Plan, a Verification Plan, reviewed, authorized and communicated
• Creating Test Scenarios and reviewing test cases.
• Documenting the End to End Business flows
• Preparation of SQL Queries using SQL Server
• Doing Automation Feasibility analysis on the generated End to End Business flows and Laying automation Framework
• Setup meetings with all Stakeholders to show the project status/ Issues/ Mitigation Plans.
• Status reporting with useful Metrics to showcase the project trends and productivity figures.
• Attend the regular onsite offshore calls and discuss the weekly status with the reporting manager and send the weekly status Report to the Client Manager
• Involved in test Summary report preparation and test closure activities
• Have been playing a Knowledge Management Anchor at Project level

Environment: Windows XP, VB.Net, SQL Server, IE V6.0, Citrix Web Interface, Rational ClearQuest, QTP, Quality Centre, Rational Requiste Pro, Snagit

Confidential

Test Analyst

Responsibilities:

• Perform functional, system, integration, smoke and regression Testing
• Run SQL queries and stored procedures for database testing for the verification of results retrieved.
• Running and Scheduling Mainframe Jobs in JCL and debugging the abends.
• Setting up the data in using File AID and doing integration testing between Mainframes and UNIX platforms by doing FTP
• Identification of Regression Suite for running JCL Jobs.
• Reported bugs in defect tracking tool and tracked them up to closure through Quality Center.
• Performed Data Driven Test using the test Data from Data files and Excel files.
• Validated the front end values with data base tables using SQL queries.
• Interact with the development teams in resolving several issues.
• Worked with the development team very closely and made sure that all the defects were fixed and closed in a timely manner.

Environment: JCL, File Aid & DB2 platforms, Windows XP, IE V6.0, Citrix Web Interface, Quality Center, Clear Quest, QTP