SUMMARY

• Overall 15 years of experience in Analysis, Design, Development, Support, Migration and Testing of various Applications in Finance, Investment Banking, GRC, Healthcare, Insurance, Telecommunication, Banking, Manufacturing and Retail domains.
• Worked wif Clients like Confidential, Fidelity, Confidential, Deloitte, Confidential, Confidential, Confidential, Nortel Networks, Confidential, Zurich Insurance & Confidential
• Experience working wif Big data technologies like Spark SQL &Hive SQL by accessing AWS 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.
• Experience in Functional areas like Bill of Materials, CRM Customer relation management, Payables, Receivables, Sales & Billing, procure to pay and Order to Cash management
• 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
• Good noledge 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

Big data Technologies: Hadoop HDFS, MapReduce, Spark, Hive, Python

Tools: and languages: SQL, PL/SQL. Core Java, E-Business Suite (11i, R12), UNIX Shell Programming, SQL Loader, Erwin 7.1, Putty, PVCS, CVS, 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, GRC, Financial Accounting, Retail, Manufacturing, Telecom, Finance, Bill of Materials, Payables, Receivables, Sales & Billing, procure to pay and Order to Cash management

PROFESSIONAL EXPERIENCE

Confidential, Plano, TX

Senior Data Engineer

Responsibilities:

• Writing SQL scripts for business analysis and reporting.
• Supporting Home Loans Servicing business for ad hoc requests
• Development of scripts for Automation of QA testing controls.
• Remediating SQL scripts and Teradata scripts into Snowflake database.
• Development of Sub-serving reports using PostgreSQL
• Extracting data from legacy databases Oracle & SQL Server into Teradata using Python scripts for business analysis & reporting

Environment: Oracle, SQL Server, Teradata, Snowflake, PostgreSQL, Python, AWS

Confidential, Merrimack, NH

Senior Data Engineer

Responsibilities:

• Designing Fact & Dimension tables for IGAR performance attribute reports
• Creating relationships between Fact & dimension keys.
• Created data models using Erwin for business processes writing PL/SQL Packages and Procedures to load Operational data into ODS (operational data source) stage tables
• Created Informatica mappings & workflows for data migration from ODS stage to CDE (Central data enterprise) stage.
• Created PL/SQL ETL Package interfaces to load data into Target Fact & Dimension tables.
• Created Autosys Jobs to automate teh loading process.
• Writing UTPLSQL scripts for testing of PL/SQL Procedures & Packages.

Environment: Oracle 11G SQL, PLSQL, TOAD, SQL Developer, Informatica 10.1, Tableau 10.3, UNIX, GitHub, AutoSys, Jenkins, Power Designer

Confidential, Plano, TX

Senior Data Analyst

Responsibilities:

• Creation of Mapping document for Source System (SQL Server) to Target System (Oracle)
• Prepared technical design and database design document
• Created data models using Erwin for business processes
• Migrating data from external database and flat files to staging database using ETL utility tools like Informatica, SQL Loader, External Tables
• Writing PL/SQL Interfaces to transform and load SQL Server data in to oracle form staging
• Performed optimization and performance tuning of SQL and PL/SQL code.
• Creation of teh Big Rationalized Script in SPARK by transposing required business data from multiple tables used in specific 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: AWS, Spark, SQL Server, Oracle, Snowflake, PostgreSQL, Erwin data modeler, GitHub

Confidential, Plano, TX

Senior Data Analyst

Responsibilities:

• Understanding teh Mortgage data warehouse (MDW) for Home Loans data analysis
• Analyze teh HMDA (Home Mortgage Disclosure data) data for LAR (Loan Application Registry) Submission.
• Writing Tera Data & SQL scripts to develop Target Control Reports (TCR’s) for missing HMDA reportable population
• Writing SQL queries to provide data for business analysis and Testing
• Writing SQL scripts to prepare data for testing of LAR data for Quality Analysis (QA) & Quality Control (QC) check.
• Understanding teh Oracle Risk Data warehouse (RDW) for Business risk data analysis
• Developing scripts to identify potential exceptions for ICTT - CANSPAM Commercial E-mail Solicitation Opt-Out, FCRA Affiliate Sharing and FACTA affiliate marketing Opt-Out
• Writing SQL scripts for Automation of teh Home Loans Mortgage Compliance Risk Controls to avoid manual testing.
• Developing Business Compliance Reports for CPC (Credit policy controls) and CMP (Compliance Monitoring Program) controls using SQL scripts
• Created SQL scripts to Automate Testing controls for Risk Management Team

Environment: Teradata, Python, SQL Server, Empower. Tableau, Business Objects (BOBJ)

Confidential, Richardson, TX

PL/SQL Lead Developer

Responsibilities:

• Understanding teh 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 teh 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 teh data in to New System.
• Writing SQL scripts to test & validate teh data after migration.
• Performance tuning of teh 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 teh 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 teh Database Objects and data after migration
• Design and development of new database tables and integrate wif existing tables to maintain teh 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

Oracle PL/SQL Tech Lead

Responsibilities:

• Understanding teh Source & Target system wif Business users and Functional Consultants
• Preparation of Data Migration strategies
• Involved in Business & Data flow diagrams
• Data Modeling & Database Design of teh 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 wif policy handling, Claims, Master data handling.
• Created stored procedures, functions and packages as part of enhancement.
• Debugging teh 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 wifout SLA compliance.
• Preparation of Run book for teh Business users

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

Confidential

Oracle 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 teh 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 teh 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 teh central oracle database.
• Used Informatica Power Center 8.6 for extraction, transformation and load (ETL) of data into teh 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 teh data from various sources.
• Used Informatica Power Center Workflow manager to create sessions, workflows and batches to run wif teh logic embedded in teh mappings.
• Extensively used Toad utility for executing SQL scripts and worked on SQL for enhancing teh performance of teh conversion mapping.
• Used teh PL/SQL procedures for Informatica mappings for truncating teh 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 wif 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 wif SAP Functional and Business Consultants.
• Development of PL/SQL procedures and LSMW objects for uploading data into SAP R/3
• Understanding teh business in teh Application Receivables, Payables and Material Management modules
• Used Bulk Collect & Collections (PL/SQL tables) to improve Performance of interfaces
• Working wif SAP R/3 system to upload teh 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 teh 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
• Involved in Deployment of Oracle Label Security.
• Implemented teh 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 teh legacy System in to Oracle EBS.
• Designed and developed Payables Open Interface to load AP Invoices from teh legacy System in to Oracle EBS.
• Designed and developed AR Interface to load AR Invoices from teh 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 teh Application Object Library to register SQL*Loader programs, PL/SQL packages and procedures, forms and reports.

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

Confidential

Senior Systems Analyst

Responsibilities:

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

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