SUMMARY:

• 12+ years of professional experience in various IT Industries across Banking and Telecom.
• Around 2+ years of experience in OFSAA (Oracle Financial Services Analytical Applications previously known as Reveleus in I - flex) Business suite solutions like EPM (EPM- Enterprise Profitability Management (ALM, ALM BI, PFT, FTP, BSP, and IFRS), ERM-Enterprise Risk Management (Basel, LRM, and MR), and FCCM (Anti Money Laundering, KYC, Regulatory Reporting, Lombard and Agile Reporting).
• Proficient in Data Modeling using Erwin tool, Data Migration Activities, Metadata migration across all environments and Slowly Changing Dimension (SCD) Component.
• Proficient in various projects related to Data Modeling, System/Data Analysis, Development, customizations OFSAA suite of products.
• Experience in extracting, loading and transforming ( ELT ) data from spreadsheets, flat files, database tables and other sources using Oracle Data Integrator.
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Experience in OFSAA, ETL, Data-warehouse and Database Testing with strong knowledge on SQL.
• Expert in Migrating the OFSA 4.5 to OFSAA 8.0 & installed and implemented the suite for various clients.
• Experience in setup external sources in Oracle Data Integrator and OFS DIH (Data Integration Hub/ Handler) for Regulatory Reporting.
• Expertise in configuration and test bed preparation for US Fed Reports for Regulatory Reporting.
• Expert in UAT Planning and UAT Execution of multi-tier, enterprise Application with working knowledge of Software Development Life Cycle, Post Test Analysis, Test Design and Test Execution of software.
• Implemented Slowly Changing Dimensions - Type I & II in Dimension tables in OFSRCA (Oracle Financial Retail Customer Analytics) requirements.
• Knowledge on Hyperion ESSBASE server for OBIEE Regulatory reporting.
• Experience in implementation of OFSAA and production support for various clients.
• Expert in Agile (SCRUM), Iterative and V, SDLC and Test Driven Development Methodologies.
• Strong knowledge of Object Oriented Programming (OOP) concepts including the use of Polymorphism, Abstraction, Inheritance, and Encapsulation.
• Experience in data mapping and validation in Logical and Physical layers using DIH Connectors.
• Experience in configuration/mapping between ADI (Application data interfaces) and EDD (external srs).
• Expert in writing SQL queries to validate the data loaded in the target tables and business rules Confidential different databases like Oracle, SQL Server, HDFS, Hive, Teradata and DB2.
• Proven ability to work efficiently independently and in team work environments, excellent communication, interpersonal, intuitive and analytical skills.

TECHNICAL SKILLS:

Programming Languages: C, C++, Pro C, JAVA, SOAP UI, Restful API, and TestNG/Junit.

Databases: SQL, Oracle 9i, 10g, 11g, 12c, MS SQL and SQL Server.

Agile Collaboration Tools: RallyDev, Zephyr, Bug DB & OTM (specific to Oracle) and JIRA.

Scripting: Perl Scripting, Shell Scripting and VB Scripting

Data Modeling Tools: Erwin Data Modeler r7.x/r9.x and ER Studio.

OLAP and ETL Tools: Hyperion-Essbase and Oracle Data Integrator 11g and 12c.

PROFESSIONAL EXPERIENCE:

Confidential

Principal Technical Analyst/Consultant

• Lead, coordinates, prioritizes, performs, and mentored technical analysts’ team to ensure that developed systems satisfied the needs of business clients as specified in the functional requirements for OFSAA Analytical Apps.
• Provide Implementation support to various customers across the globe on Migrating old applications to new web based applications suite for balance sheet planning, Cash flow statement, Asset and liabilities management, Anti Money laundering, Liquidity Risk Management and Profitability management solutions.
• Experience in implementation of OFSAA and Oracle Support team for various clients.
• Used Erwin for reverse engineering to connect to existing database and ODS to create graphical representation in the form of Entity Relationships and elicit more information.
• Used Oracle Data Integrator to create source and target definition, design mappings, create repositories and establish users, groups and their privileges.
• Created dimensional model for the reporting system by identifying required dimensions and facts using Erwin r7.1
• Executed entire Migration Strategy for the client involving the validation of OFSAA installation and configuration, customization and live methods OFSAA Platform and related modules. (OFSA4.5+->OFSAA7.0/EPM 6.0+->OFSAA 7.3/EPM6.1+->OFSAA8.0+/EPM8.0+).
• Used Reverse Engineering approach to redefine entities, relationships and attributes in the data model as per new specifications in Erwin after analyzing the database systems in use for Migration data model issues.
• Created several of rules for DQs and T2Ts for ALM, FTP and PFT in OFSAA to generate FR reports.
• Validated of ALM & LRM Liquidity risk as per FED guidelines and created FR reports.
• Creation of rules for customized Recon process, contractual cash flows, Basel 3 risk weighted assets.
• Validation of integration of ALM and LRM solutions. Validation of all dashboard reports in ALM BI.
• Creation of different tasks, batch jobs, Batch runs and debug analysis for EPM and ERM solutions in OFSAA 8.0.
• Successfully Configured transfer pricing, prepayment, and rate card rules for the FTP module.
• Defined and executed the T2T’s definitions and T2T transformations for Customer profitability for OBIEE Reporting.
• Involved in Design of Data stage and autosys jobs and upstream and downstream of data using DIH.
• Installation and Configuration of OFS DIH(Oracle Financial Services Data Integrator Hub) on ODI(Oracle Data Integrator) for (OFSCRR) Currency Regulatory Reporting using Web services to pull the data from FCCM(AML) data sources.
• Executed batch jobs in test and validation of business transformation rules for PSTG to STG to Processing and Result tables.
• Written SQL, PL/SQL Scripts for DB Mapping & Testing for ETL, DWH Testing and OBIEE reports.
• Assisted product Managers, Pre sales team defining the Hardware Sizing tool for database, Web servers, and Application servers for OFSAA (Oracle Financial Services Analytical Applications) Products suite.
• Prepare and publish Quality matrices on OBIEE report portal for process improvements for product development, Oracle support services, OFSAA Consulting and Partner Services.
• Setup Gold Copy Demo environment for OFSAA( all major apps from EPM+ERM+FCCM+GRC) applications for Product Managers, Oracle sales team, Partner services, Consulting teams and Oracle Cross sales teams involving Software and Hardware sections.

Environment: /Tools: Oracle Linux-Solaris(SPARC),Oracle OLAP, Oracle HTTP Server, Web Logic, Oracle 11g, 12c, Hyperion Essbase, OBIEE reports, Java, Spring framework, Apache Tomcat, XML, JDK,SQL, Selenium, MAVEN, Eclipse, Rest SOAP,SOAPUI, Twiki, BugDB, JIRA, J2C,J2EE,JNDI,Shell,Oracle Primavera etc.

Confidential

Senior Production Systems Engineer

• Involved in New Cloud environment setup for Staging and Production environments for Digital Wallet Setup ( Confidential ) used for authentication of ecommerce tranx by merchant services and banks.
• Configuration and maintenance of common applications such as Apache Tomcat, http server, JBOSS, MySQL, MSSQL, SSH, DNS, SNMP, Nginx, HSM (HW Security Module), Mail &Message proxies.
• Performed Key Loading activity (Acceptance Testing/Go Live) using HSM module for one of premier multinational bank involving cryptographic keys for Visa and Master Cards.

Confidential

Senior Software Engineer - Project Lead

• Lead, Coordinates, prioritizes, performs and assigned UAT and Production environment setup for Clients.
• Involve in Planning, Monitoring and Implementation of respective Rollouts or Rollins in co - ordination with Product Offering Group, Project management, Within Development, Client Support (Manage Services), Hardware Vendor and Client tech teams and client PMO.
• Involve in all discussions from requirements to production Live and till Implementation.
• Lead and Help the team with understanding on REQs and to perform Data Mapping and Integration testing.
• Understand, maintain and improve the current testing procedure, sharing ownership with the teams in Germany and India.
• Mentor other UAT Engineers to assist them in developing, maintaining & executing automation scripts using Perl, QTP and VB Scripts.
• Work with developers in Germany & India to understand and practice existing automation framework.
• Develop & maintain automated test scripts covering functional correctness using Perl, QTP and VB Scripting and add new features & schedule Regression testing for existing features.
• Develop a deep knowledge of the business rules for existing and new functionality.
• Knowledge and proficiency in the use of various automated tools that are used in the automated testing procedures.
• Prepare Perl scripts for automating a backend features and for operational excellence.
• Perform Failover Testing for UAT and Production Servers.
• Created Database for Production and perform the DB mapping, Data Governance, transformations and c leansing across all platforms.
• Perform Core Engine Processing Performance testing and for Mediation, Rating, Aggregation and IO Modules.
• Debug the Code using DBX to help with root cause to DEV team for the Production Issues.
• Reviewing Performance documents for Application Processing and system adaptability.
• Involve in setup for Manage Services team to support client till handover.

Environment: /Tools: Linux, JDK, Apache Tomcat 7, Oracle11g, C++ and Java. HPE UFT, VB Scripting, Selenium Web Driver, TestNG, SQL, Ant, Eclipse, Jakarta JMeter

Confidential

Senior Software Engineer - Project Lead

• Successfully completed the QA and UAT Environment Setup, QA Testing and UAT Acceptance testing, UAT and Pre-Prod Signoff and assisted in Application Production environment setup for Confidential (US, UK and AUS).
• Lead, coordinates, prioritizes, performs UAT environment setup and assisted Production environment setup for Clients.
• Handled 12 different type file formats for the UAT testing.

Environment: /Tools: Linux, Oracle 11g, JDK7, Apache Tomcat, Apache http, MS Project, JIRA, Shell, SQL, Data pump export utility, various input file formats, Java, C++

Confidential

Senior Automation Engineer

• Automated highly transactional Telecom billing web application and MSTR Reporting Tool.
• Prepared Data Driven, Keyword Driven Framework from scratch using HPE UFT, VB Scripting, ALM and Descriptive Programming.
• Prepared and developed automation test scripts for Web based Regression Testing and Integration testing using HPE UFT-Unified Functional Testing, VB Scripting, ALM and SQL Scripting.
• Prepare and provided training to Scrum teams on usage of Data Driven Framework, Keyword Driven Frameworks.
• Enhanced automation scripts for improving test execution time using VB scripts and SQL Scripting.
• Automated External Web Components for Input Validations, User Interface Validations, Browser Compatibility testing and navigation testing using Selenium Web Driver, Java, Test NG, ANT.
• Used concepts of implicitWait, Explicit Wait, WebDriverWait to sync the script with the application during the run time, used concepts of switchTo.frame (), switchTo.defaultContent () to handle iFrame related page.
• Worked on different JavaScript libraries like JQuery, Underscorejs, Requirejs, knockoutjs

Environment: /Tools: UFT, VB Scripting, ALM, Selenium Web Driver, Java, TestNG, Web (HTTP/HTML) Spring Framework, Java Scripts

Confidential

Application Developer (Perl & SQL Developer)

• Developed Automation Execution Status Report using Perl (CGI) for Backend Automation Framework and developed Perl scripts for Operation Excellence.
• Written SQL and PL SQL Scripts for data migration and cleaning into Clone Database environment.
• Prepared and executed End to End Test Plan in Agile methodology for GSM International Roaming Products involving Web Testing, Backend Testing, ETL/DWH Testing and MSTR Reports Testing.
• Performed ETL and DWH testing for Micro Strategy Reports and prepared and executed the SQL, PL/SQL scripts for ETL load verifications.
• Extracted data from Oracle and SQL Server and DB2 using home grown etl tool to load it into a BI data warehouse repository.
• Created a Regression Test Plan/Suite for Web Application and automated suite using QTP, QC, Descriptive Programming.
• Prepared User acceptance test scripts and automated using selenium, Junit from scratch.
• Implemented the Integration of Rally Dev and Quality Center for Scrum Teams.

Environment: /Tools: AIX, Solaris, Netezza, Oracle 9i-10g, QTP, VB Scripting, Test Director, QC, Rally Dev, Eclipse, Selenium RC, Java, SQL, JUnit, ANT, SVN, Shell Scripting, Microstratry Reports