SUMMARY

• Over 7 Years of IT experience which includes System Analysis and Design, Development & Support of ORACLE DATABASE 10G AND 11G in Production, QA and Development Environments.
• Implementation of OFSAA solutions for FSDF, PFT, Liquidity Risk, and GL Recon for Advanced and Standardize Approach.
• Experience in implementing OFSAAI with various solutions like Profitability (PFT),Fund transfer(FTP),Asset Liability Management (ALM),Performance Analytics (PA),Anti Money Laundering (AML) under various solution suites.
• Ability to work in all stages of System Development Life Cycle (SDLC).
• Install and upgrade OFSAA Infrastructure (OFSAAI) and frameworks,worked on different modules.
• Strong knowledge of data warehouse architecture, OFSAA internal architecture and experienced in dimensional modeling on data modeling tool (ERWIN).
• Extensive Experience in RDBMS concepts such as Tables, User Defined Data Types, Indexes, Indexed Views, Functions, CTE's, Table Variables and Stored Procedures.
• Experience in using tools like Database Engine Tuning Advisor, PLSQL Profiler, Index Tuning Wizard and Windows Performance Monitor for Monitoring and Tuning Oracle db Performance.
• Worked on OFSAA Application for creating members and hierarchies and for running the predefined batches process inorder to populate the resultant tables.
• Deep understanding of the OFSAA modules and hands on experience in building and configuring rules within the OFSAA tool.
• Experience in data Extraction, Loading and Transformation in data ware house environment using Oracle Data Integrator.
• Thorough knowledge and experience in configuring F2T rules, rules for cost and revenue allocation, T2T rules to transform data, DQ Rules in OFSAA through UMM DQ Framework.
• Expertise in Implimenting Oracle Business Intelligence reports (OBIEE).
• Hands on experience in installing, configuring, managing, upgrading and migrating, Backup/Restore, monitoring and troubleshooting Oracle db.
• Experience in Managing Security of Oracle db by creating Database Users, Roles and assigning proper permissions according to the business requirements.
• Experience in Interacting with Business users to analyze the business process and transforming requirements into screens, performing ETL, documenting and rolling out the deliverables.
• Worked extensively on Extraction, Transformation, Loading data from Oracle, DB2, Access, Excel, Flat Files and XML using DTS, SSIS.
• Experience in working with Database setup, partitions and maintenance.
• Good knowledge of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Data Modeling like Dimensional Data Modeling, Star Schema Modeling, Snow - Flake Modeling, FACT and Dimensions Tables.
• Good understanding of Normalization /De-normalization, Normal Form and database design methodology Expertise in using data modeling tools like MS Visio and Erwin Tool for logical and physical design of databases.
• Skilled in design of logical and physical data modeling using Erwin data modeling tool.
• Worked with Business Analysts, Web development team, and users on database solutions.

PROFESSIONAL EXPERIENCE

OFSAA CONSULTANT

Confidential -Houston, TX

Responsibilities:

• Developed BASEL Regulatory reports like SLS, IRS and BASEL MIS Reports by using OBIEE.
• Used Erwin, Star Schema Modeling, and Snowflake modeling, FACT and Dimensions tables, physical and logical modeling.
• Strong skills in Data Analysis, Data Requirement Analysis and Data Mapping for ETL processes.
• Hands on experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.
• Transformed business-oriented functional specifications into ETL and OFSAA Test Scenarios and associated Test cases.
• Used Post Load Changes to define transformations to the source data before extracting/loading it to Target database to populate the data warehouse.
• Used Data Management Tool for data transformation and merging.
• Developed PLSQL PACKAGES, PROCEDURES, FUNCTIONS based on the client original data in the development environment.
• Used Unified Metadata Manager to enhance the ability to manage enterprise by distributing a consistent view of the business dimensions and key measures to every decision maker and application developer.
• Involved on data extraction from core banking system (Finacle) to OFSAA Instrument tables via OFSAA staging using OWB 11g, PL/SQL Programming and T2T mappings.
• Gathering of the client requirements and manipulating the data according to the BI reporting.
• Building the BI reports based on the requirement and delivering in the perfect TIMELINES and SCHEDULES.
• Used import model to upload the warehouse data from the operational systems to database schema using ERwin xml file.
• Understand user requirements and Data Model defined and developed by the business analysts and data architects.
• Performed DBA tasks like Backup, Restore of tables and Stored Procedures and Refreshing Database on weekly basis.
• Used Rules Framework to define a set of rules, reporting objects, and processes that are required to transform data in a warehouse.
• Created Oracle ADF (Application Development Framework) and OAF (Oracle Application Framework), OFSAA D5 forms.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other Plsql code and SQL joins for applications following SQL code standards.
• Designed and applied entity and attributes description and definition for the models.
• Managed indexes, statistics and tuned queries by using execution plan for optimizing the performance of the databases.
• Extract, Transform and Load source data into respective target tables to build the required data marts.
• Performed unit and system testing, troubleshooting and bug fixing in development and QA environments.
• Developed optimal stored procedures and queries to create data sets for reports.
• Created usage based aggregations in cube to minimize time for query retrieval from client tool Target.
• Manual file uploads & Configuring DQ Rules in OFSAA through UMM and PR2 Modules of OFSAAI.
• Worked on performance tuning on existing stored procedures and existing reports for the faster processing of reports.

Data Analyst

Confidential -Houston,TX

Responsibilities:

• Working on product developemt of Rev Cycle Analytics designed the Database and handling all the Data as well Apllication side changes and issues.
• Utilized Java, Eclipse/ J2EE, tested programing code & Applications, collaborated with team and management.
• Created & maintained a centralized repository of UI components, participated in usability testing & research.
• Developed the database design and application design for the new application.
• Involved in the application design and deployment of application to the production environment and responsible for changes in the application.
• Worked as support engineer for the application as well as database.
• Wrote and executed test cases based on written design, as well as based on product knowledge that resulted in greatly improving the software.
• Responsible for investigating the issues, defects, determining problem root cause, formulating corrective action recommendations & implementing them.
• Created detailed design documents using UML (Use case, Class, Sequence, and Component diagrams).
• Involved in the full life cycle of software design process of other projects, including prototyping, proof of concepts, design, interface implementation, testing and maintenance.
• Worked on business analysis part of Healthcare data for the client in order to give an detail analysis of their business from end to end.
• Interacted with Business Users and Analyzed user requirements and built reporting solutions such as relational database reports OLAP reporting, dashboards, and scorecards.
• Created SSIS packages to pull data from SQL Server and exported to Excel Spreadsheets and designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments.
• Created the SSIS /DTS packages and scheduled them using Sql Server agent.
• Developed ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc) and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Designed and developed efficient SSIS packages for processing fact and dimension tables using transformations like Fuzzy lookup, lookup, merge, merge join, script component and Slowly changing dimension.
• Performed archiving and achieved automated processing of the raw data through the ETL process in SSIS.
• Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data.
• Created and developed data dictionary, tables, views, indexes, functions and advanced queries for databases by using Query Analyzer and SQL Server Enterprise Manager.
• Performed data transfer/migration using Export/Import and Data Transformation Services. Pulled data from various tables and databases to generate reports using different types of joins.
• Created new database objects like Sequences, Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server.
• Designed and implemented Parameterized and cascading parameterized reports using SSRS.

OFSAA/OBIEE Developer

Confidential -Buffalo, NY

Responsibilities:

• Developed Advance PL/SQLpackages, procedures, triggers, functions, Indexes and Collections to implement business logic using SQL Developer. Generated server side PL/SQLscripts for data manipulation and validation and materialized views for remote instances.
• 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 in OFSAA manual file uploads & Configuring DQ Rules in OFSAA through UMM and PR2 Modules of OFSAAI.
• Scheduling and Executing 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.
• Involved in analysis of data issues from upstream and downstream applications associated with the OFSAA and its datamarts.
• Depict 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.
• Used principles of Normalization to improve the performance. Involved in ETL code using PL/SQL in order to meet requirements for Extract, transformation, cleansing and loading of data from source to target data structures.
• Involved in the continuous enhancements and fixing of production problems. Designed, implemented and tuned interfaces and batch jobs using PL/SQL.
• Have experience in data Extraction, Loading and Transformation in data ware house environment.
• Designed and developed interfaces to load the data from multiple sources like Relational databases, flat files into oracle database.Developed packages, scenarios using interfaces and variables.

PL/SQL Developer

Confidential

Responsibilities:

• Involved in the whole life cycle of the project
• Interacted with clients to understand their requirements.
• Involved in data replication and high availability design scenarios with Oracle Streams. Developed UNIXShellscripts to automate repetitive database processes.
• Programmed Packages, stored procedures, queries, and triggers on Oracle 10g.
• Plan and supervise the daily activities of the application support
• Involved in resolving production problems for the applications and Ensure all support service level agreements are met.
• Developed PL/SQLpackages, procedures, triggers, functions, Indexes and Collections to implement business logic using SQL Developer. Generated server side PL/SQLscripts for data manipulation and validation and materialized views for remote instances.
• Involved in the continuous enhancements and fixing of production problems. Designed, implemented and tuned interfaces and batch jobs using PL/SQL.