CAREER SUMMARY:

• Overall 15 years of experience in Analysis, Design, Development, Support, Migration and Testing of various Applications in Finance, Healthcare, Insurance, Telecommunication, Banking, Manufacturing and Retail domains.
• Worked with Clients like Confidential, Confidential, Deloitte, Confidential, SONY, Confidential, Nortel Networks, Confidential, Confidential Insurance & Confidential
• Experience in migration of applications data into Cloud Simple Storage Service (AWS S3)
• Experience in Data migration to Amazon Redshift and Snowflake Cloud Databases
• Expertise in Oracle 12c SQL & PL/SQL programming.
• Expertise in T - SQL & PL/SQL programming
• Experience on data extraction, Transformation and loading (ETL) from various sources like Oracle, Teradata, SQL Server and Flat files using SSIS Import and Export, SSIS Packages.
• Expertise in design & development of PL/SQL Procedures, Functions, Packages and Triggers
• Expertise in Writing Oracle, SQL Server, Spark & Teradata Scripts
• Experience in Data modelling (Logical & Physical), Database Design & Development.
• Good Knowledge on Big data Hadoop Framework &Ecosystems Hive, Pig & Spark
• Knowledge in Python & R programming
• Extensive experience leading and coordinating onsite and offshore teams.
• Experience in preparation of HLD (High Level Design) & LLD (Low Level Design) documents
• Expertise in Preparation of Business, Functional & Technical Design Documents.
• Expertise in Oracle 6i,9i,10g,11g Web Forms & Reports Development(D2K)
• Extensively worked on data extraction, Transformation and loading (ETL) data from various sources like Oracle, Teradata, SQL Server and Flat files.
• Extensive experience in ETL design, development and maintenance using Oracle SQL, PL/SQL, SQL Loader, Informatica Power Center 8.x/9x.
• Experience in using Informatica Client tools: Power Center Designer, Workflow Manager, Workflow Monitor, Repository Manager
• Expertise in Implementing Row level data access using Oracle Label Security (Fine Grained Data Access Control)
• Creating and managing Schema objects like Tables, Views, Synonyms, Indexes, Clusters, Table spaces, User Roles/Privileges and Materialized views
• Extensively used PL/SQL concepts like Bulk collect, PL/SQL tables and Dynamic SQL, Autonomous Transactions, Cursors, REF Cursors & Analytical functions
• SQL and PL/SQL Performance Tuning using Explain Plans, Auto trace, and TkProf.
• Good Understanding of AWR (Automatic Workload Repository) Reports and ADDM (Automatic Database Diagnostic System)
• Oracle utilities (Import, Export, Data Pump, SQL *Loader, UTL FILE and External Tables)
• Experience in UNIX Shell Scripting
• Experience in Oracle E-Business Suite(ERP) &RICE components development
• Experience in working with Oracle Supplied packages
• Good knowledge on using Oracle Business Intelligence(OBIEE) Reporting Tool
• Experience on OLTP, OLAP and Cloud Database Systems.
• Good Knowledge on Dimensional Data Modeling (STAR Schema & Snow flake Schema)

TECHNICAL SKILLS:

Databases: Oracle, SQL Server, Teradata, Redshift, Snowflake, PostgreSQL, Cassandra NoSQL

Bigdata Technologies: Hadoop HDFS, MapReduce, Spark, Hive, PIG, Python, R programming

Tools: and languages: SQL, PL/SQL. Core Java, E-Business Suite (11i, R12), UNIX Shell Programming, SQL Loader, Erwin 7.1, Putty, PVCS, CVS, VSS, Remedy, GitHub, Control M scheduling tool, Oracle Forms, Core Java, Toad, SQL Developer

Data Visualization & Business Intelligence tools: Tableau, OBIEE, Oracle Reports Builder, Crystal Reports, SSRS, SSIS, Cognos

Operating System: Unix, SUN Solaris, HP-UX 10.x/11, Windows

Web technologies: XML, JavaScript

Functional areas: Banking, Insurance, Healthcare, Retail, Manufacturing, Telecom, Finance

PROFESSIONAL EXPERIENCE:

Confidential, Plano, TX

Senior Data Engineer

Responsibilities:

• Creation of metadata for the Technical & Business data sets
• Writing BDQ (Business data quality) rules for data elements
• Preparation of Business Lineage documents for Enterprise Home Loans reports scripts
• Creation of Mapping document for Source System (SQL Server) to Target System (Teradata)
• Using PostgreSQL Automation Script
• Creation of Logical & Physical data model for Rational tables and columns
• Development of Rationalized Flat Spark SQL script in Amazon S3 (Simple Storage Service)
• Creation of the Big Rationalized Table by transposing required business data from multiple tables used in specific LOB (Line of Business) in Home Loans Origination system
• Creation of Business Spark SQL Script for derived metrics based off Rationalized data elements in Amazon S3 Bucket
• Testing Home equity Enterprise Tableau & Business Objects Reports running against Business Spark SQL Script

Environment: Amazon S3, Spark, Scala, SQL Server, Teradata, PostgreSQL, Redshift, Snowflake, Empower. Tableau, Erwin data modeler

Confidential, Plano, TX

Senior Data Analyst

Responsibilities:

• Understanding the Mortgage data warehouse (MDW) for Home Loans data analysis
• Analyze the HMDA (Home Mortgage Disclosure data) data for LAR (Loan Application Registry) Submission.
• Writing PL/SQL Packages to develop Target Control Reports (TCR’s) for missing HMDA reportable population
• Working with Teradata SQL queries to provide data for business analysis and Testing
• Prepare data for testing of LAR data for Quality Analysis (QA) & Quality Control (QC) check.
• Understanding the Risk Data warehouse (RDW) for Business risk data analysis
• Developing PL/SQL Packages, Stored Procedures to identify potential exceptions for ICTT - CANSPAM Commercial E-mail Solicitation Opt-Out, FCRA Affiliate Sharing and FACTA affiliate marketing Opt-Out
• Creating SSIS Packages to export and import data from Sql Server,Teradata
• Involved in writing Stored Procedures, User Defined Functions, Views, TSQL Scripting for
• Complex business logic
• Automation of the Home Loans Mortgage Compliance Risk Controls to avoid manual Testing and Performance tuning of the SQL scripts.
• Developing Business Compliance Reports for CPC (Credit policy controls) and CMP (Compliance Monitoring Program) controls
• Design and develop programs to Automate Testing controls for Risk Management Team
• Scheduling the QA & QC testing control reports for Email distribution to the respective teams

Environment: Oracle 11g, SQL, PL/SQL, TOAD, SQL Developer, Teradata, Python, SQL Server, Empower. Tableau

Confidential, Richardson, TX

Application Developer

Responsibilities:

• Understanding the Current Legacy systems to Integrate into new System
• Preparation of Data mapping documents from source systems to Target system
• Defining Translations and Business rules which suites the new Target System
• Creation of schema objects like Tables, Public Synonyms and Sequences Confidential .
• Writing PLSQL Packages to Extract, Transform and Load data into Target tables
• Design and development of PL/SQL Interfaces to migrate the data in to New System.
• Writing SQL scripts to test & validate the data after migration.
• Performance tuning of the PL/SQL Procedures and SQL scripts.
• Writing Dynamic SQL scripts to Enable & Disable constraints & Triggers Dynamically
• Compiling all database schema Packages, Procedures, Functions, Triggers, Sequences, Synonyms, Views after migration.

Environment: Oracle Database12c, PL/SQL, TOAD, Oracle Developer Suite 11g, Eclipse, Hibernate

Confidential, Raleigh, NC

Project Consultant

Responsibilities:

• Involved in Preparation of ER Diagrams for different Business Flows
• Design and Creation of the new database schema objects as part of Application Enhancement.
• Involved in Performance Tuning of SQL Queries
• Used SQL LOADER Utility to load data from Flat files into Staging tables
• Writing PLSQL Procedures to Extract, Transform and Load data to Target tables
• Writing SQL Scripts which can be called from Java as a web service.
• Database Migration from multiple Environments (Development, Test, Stage & Production)
• Validating the Database Objects and data after migration
• Design and development of new database tables and integrate with existing tables to maintain the data integrity by applying Normalization concepts.

Environment: Oracle Database10g, PL/SQL, SQL* Loader, TOAD, SQL Developer, Eclipse, Hibernate, Erwin data modeler, GITHUB, UNIX & Windows

Confidential

Tech Lead & Developer

Responsibilities:

• Understanding the Source & Target system with Business users and Functional Consultants
• Preparation of Data Migration strategies
• Involved in Business & Data flow diagrams
• Data Modeling & Database Design of the Target system
• Preparation Data Mapping documents from Source System to Target System
• Data modeling, Schema design & Development
• Used SQL LOADER Utility to load data from legacy data from Flat files
• Writing PLSQL Interfaces & Conversions for Data migration
• Used oracle utilities IMPORT & EXPORT for Schema migration from Oracle 9i to 10g
• Involved in Performance Tuning of SQL Queries & PL/SQL programs
• Writing SQL Scripts for Deployment
• Used Dynamic SQL to Disable & Enable Constraints & database Triggers.
• Shell scripting

Environment: Oracle Database10g, 11g, PL/SQL, SQL* Loader, Java, Erwin data modeler, TOAD

Confidential

Tech Lead & Developer

Responsibilities:

• Process Keeper for Auto Insurance Functional Area
• Handling Applications of Auto Insurance which deals with policy handling, Claims, Master data handling.
• Created stored procedures, functions and packages as part of enhancement.
• Debugging the PL/SQL Packages and Procedures
• Preparation of RCA (Root Cause Analysis) Documents
• Used oracle utilities SQL* LOADER and UTL FILE to load data from external
• Involved in GUI Application Enhancements using Oracle forms developer.
• Involved in Reports customizations and development using Oracle Reports tool.
• Responsible for providing quality support without SLA compliance.
• Preparation of Run book for the Business users

Environment: Oracle SQL, PL/SQL, Java, Oracle Forms10G, Reports 10g, PL/SQL Developer, TOAD and Remedy

Confidential

Tech Lead & Developer

Responsibilities:

• Database Migration & Development
• Oracle Web Forms Migration & Development
• Writing PLSQL Interfaces (Stored Procedures, Functions & Packages)
• Creation of Reusable GUI Templates using Oracle Forms Tool
• Creation of new Reports using Oracle Reports Tool
• Code Reviews
• Writing Oracle Scripts for Deployment of the code
• Preparation Test scripts.
• Performance Tuning of SQL queries Used in Business Objects Reports

Environment: Oracle Database10g, Oracle Developer Suite (Forms 10g), TOAD, SQL *Loader, MS Visio Oracle 10g Application Server, Mercury Quality Center, UNIX & Windows

Confidential

ETL Informatica Developer

Responsibilities:

• Analyzed the business requirements and functional specifications.
• Extracted data from oracle database and spreadsheets and staged into a single place and applied business logic to load them in the central oracle database.
• Used Informatica Power Center 8.6 for extraction, transformation and load (ETL) of data into the data Warehouse.
• Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression and Lookup,
• Update strategy and Sequence generator and Stored Procedure.
• Developed complex mappings in Informatica to load the data from various sources.
• Used Informatica Power Center Workflow manager to create sessions, workflows and batches to run with the logic embedded in the mappings.
• Extensively used Toad utility for executing SQL scripts and worked on SQL for enhancing the performance of the conversion mapping.
• Used the PL/SQL procedures for Informatica mappings for truncating the data in target tables at run time.

Environment: Oracle Database10g Informatica Power Center 8.6, TOAD, UNIX

Confidential

Senior Database Developer

Responsibilities:

• Data Analysis of Legacy System for Customer Master and Accounts Receivables.
• Preparation of Data Mapping documents from Legacy to SAP Applications
• Working with SQL* Loader, PLSQL Packages for Data Extraction from Legacy to Oracle Database.
• Designing and Writing Oracle Interfaces for Data Extraction, Transformation & Loading (ETL Process).
• Co-coordinating with SAP Functional and Business Consultants.
• Development of PL/SQL procedures and LSMW objects for uploading data into SAP R/3
• Understanding the business in the Application Receivables, Payables and Material Management modules
• Used Bulk Collect & Collections (PL/SQL tables) to improve Performance of interfaces
• Working with SAP R/3 system to upload the data in to SAP structures.SAP Application Testing

Environment: SAP R/3, Oracle 10g, PL/SQL, TOAD, UNIX & Windows

Confidential

Senior Application Developer

Responsibilities:

• Designing Functional &Technical Specifications to implement Oracle Label Security(OLS)
• Writing PL/SQL Procedures, Functions, Packages and Triggers to implement OLS
• Customizing Oracle forms & Reports to maintain Oracle Label Security
• Preparation of Test cases & Testing the OLS Procedures, Functions, Packages and Triggers
• Writing SQL & PL/SQL Scripts for Implementation
• Used Ref Cursors, Dynamic SQL (Execute Immediate)
• Used Dynamic SQL to Enable & Disable database Integrity constraints & Triggers Dynamically
• Involved in Deployment of Oracle Label Security.
• Implemented the Row Level Security using OLS
• Loading data from flat files into Oracle database using SQL * Loader
• Involved in preparation of Unit Test cases &Testing

Environment: Oracle 9i, SQL, PL/SQL, Oracle Forms & Reports TOAD 6.5, and SQL *LOADER, SQL *Plus, UNIX Shell Scripts, UNIX, Windows

Confidential

Senior Software Developer

Responsibilities:

• Designed and developed PO requisition interface to load PO requisitions from the legacy System in to Oracle EBS.
• Designed and developed Payables Open Interface to load AP Invoices from the legacy System in to Oracle EBS.
• Designed and developed AR Interface to load AR Invoices from the legacy System in to Oracle EBS.
• Experience in implementing reporting and business intelligence projects, including design and implementation.
• Identified and created aggregate tables to improve query performance.
• Extensively utilized the Application Object Library to register SQL*Loader programs, PL/SQL packages and procedures, forms and reports.
• Documented all the work using AIM Methodology. Created and updated MD070 Technical Specifications and Test Case documents for all the development work done.

Environment: Oracle 10g, SQL, PL/SQL, Reports6i and Oracle EBS Applications 11i (ERP), UNIX, Windows

Confidential

Senior Analyst

Responsibilities:

• Understanding the SQL*LIMS Application.
• Analyzing the Schema (Data Model) of the SQL*LIMS Application.
• Writing PL/SQL scripts. (Stored procedures, Functions and Packages)
• Preparation of Technical design documents for enhancements.
• Customizing the existing Application Using Oracle Forms & Reports
• Performance Tuning of the SQL queries used in Oracle Reports Builder
• Code review of the Team.
• Preparation of Test plans and testing the Lab Samples.

Environment: Oracle9i, PL/SQL, Oracle Forms & Reports (9i), SQL * Loader, SQL * LIMS, AIX Unix and windows