Oracle PLSQL/ETL/UI Developer

GURMEET SINGH

Oracle/ETL/UI Developer

Email: ************.**@*****.***

Phone: 540-***-****

SUMMARY OF QUALIFICATION

9+ years of IT Experience as Application Developer for System Analysis, Designing, Testing Development & Support of Oracle 9i, 10g, 11g & 12c, MS SQL 2012/2014 in Production, Staging, Development environments.

Experience in pharmacy, financial, insurance, health and manufacturing domain.

Oracle Tools: Oracle APEX, Oracle OEM, Oracle OBIEE, Oracle Forms and Reports and Oracle Portal.

Databases – Oracle (OCA Certified), MSSQL Server, MongoDB, PostgreSQL, Netezza, Oracle Exadata, SQLite, Vertica, MySQL, Teradata etc.

Proficient in Data modeling for Data Warehouse/Data Mart development, Data Analysis for Online Transaction Processing (OLTP) and Data Warehousing (OLAP)/Business Intelligence (BI).

Expert in creating SQL, PL/SQL package, function, stored procedure, triggers, and cursors.

Created DB objects like tables, views, sequences, synonyms, indexes using Oracle tools like SQL*Plus, SQL Developer and Toad.

Created interfaces utilizing Oracle APEX, OBIEE, Oracle Forms and Reports, Oracle Portal and Oracle EBS for interactive UI, web-forms, grids-view, charts, maps, trees and calendars.

Developed several back-end PLSQL objects - Packages, Procedures and Function to use in multiple web-forms and series of other backend applications.

Modified the CGIs to generate dynamic content on web pages and web applications.

Developed application using JDBC, SQL injection, CCS, jQuery, JScript, AngularJS, Bootstrap.

Created and modified Oracle forms and reports with Oracle Report Builder.

Proficient in advance features of Oracle 11g and 12c for PL/SQL programming like Using Records and Collections, Bulk Bind, Ref. Cursors, Varrays, Nested tables and Dynamic SQL.

Experience in SQL and PL/SQL tuning and query optimization tools – Oracle OEM, SQL Trace, TKPROF, Explain Plan, DBMS_PROFILER.

Strong knowledge in Oracle utilities like SQL*Loader, Export/Import and Data Pump.

Extensively used package like DBMS_STATS, UTL_FILE, DBMS_SCHEDULER and UTL_MAIL.

Hands on experience with Crontab in UNIX environment for scheduling routine tasks.

Strong knowledge with PL/SQL Wrapper to protect the PL/SQL procedures or packages.

Extensively used Cubes & Rollups for making cross tabular reports.

Strong knowledge of Star Schema, Snow Flake Schema, Dimension and Fact table.

Expertise in handling errors using Exceptions.

Transferred data using data transfer tools like FTP (File Transfer Protocol) and SFTP (Smart FTP)

Exposure & knowledge of designing logical & physical Data Model.

Extensive experience with all phases of the Software Development Life Cycle including analysis, Resource Planning, code development, testing, implementing and maintenance.

Have worked in fast paced AGILE environment & attended daily scrum meeting.

Used Facets for Trizetto, EPIC Clarity, SOA Arch, CMS and knowledge on JDA driven environment.

SKILL & TECH MATRIX

Operating System

Languages

LINUX, Sun Solaris 5.10/5.9/5.8, HP-UX 11i 3/11i 2, IBM AIX 5.2/5.3, Windows 7/XP/2000/98

SQL, PL/SQL, C, C++, UNIX Shell & PERL Scripting, Batch, Java Scripting, JAVA and .NET

Database

Database Tools

Oracle 12C/11g/10g/9i, Netezza 6.0, MS SQL Server 2008/2005, Oracle Enterprise Manager (OEM) 12C/11g, Sybase 15.0.2

SQL*PLUS, Putty beta 0.67, TOAD 12.0, MobaXterm 3.2, SQL Developer 17.2, Erwin 8, Notepad++, Oracle Apex 4.2.3, Data Stage 8.1, Oracle Forms & Reports 12c, OEM 12c

Data Utilities

Reporting Tools

SQL Loader, Export/Import, Data pump, Explain Plan, Oracle Wrap

MS SQL 2008/2005, Oracle Forms & Reports 9i/10g, MicroStrategy, SAS, APEX, Clickview, BI/BO

Other Tools & Web Application

Automation Job/Batch Scheduling Tools

HTML 5, XML 1.0, Filezilla 3.23.0.2, WinSCP 5.1, Java SE 10, CSS 4, SVN 1.3, Notepad++ 7, Beyond Compare 3, Bootstrap v4.0.0, jScript, jQuery

Control–M 7.0, Cybermation 2.0, Autosys 11.3, Cron Jobs, JAMS V6, Oracle Jobs

Project Management Tools

Quality Assurance

PM Tools: MS Project 2013, IBM RUP 7.5.1, Requisite Pro 7.1, HP Quality Center, Rally

Methodologies: SDLC & AGILE

Data Modeling: ERwin r7.1/7.2/7.3/8.0, ER Studio 8.5.3

System Testing, Functional Testing, Unit Testing, System Integration Testing (SIT), User Acceptance Testing (UAT), Test Plan, Test Scripts and Test Cases

TECHNICAL CERTIFICATION

Oracle Certified Associate. SQL Certification (1Z0-051)

Oracle Certified Associate. PL/SQL Certification (1Z0-144)

PROFESSIONAL SUMMARY

Ally Financial INC., Detroit, MI Sep2017 – Mar2018.

Oracle Performance Tuning

iWarranty Single Platform: To eliminate reliance on multiple systems to invoice dealers and administer products by migrating all applicable insurance product to the Core Policy System(CPS) platform, allowing discontinuation of these applications. Core objectives – Migrate product from SCS to iWarranty, Migrate financial data from MAS90 to FSCD, Enable dealers and agents in Vehicle Protection Center(VPC), Enable DWR for related reporting needs, Sunset SCS Apps (SCS, MAS90, Sales Sites, Report Manager), Archive SCS and MAS90 historical data.

Interacted client in Agile and supervised in preparation of the technical documentation.

Maintained data for relational structure in Tables, Views, MVs, Temporary Table, External tables.

Designed DB tables and related Indexes, Partitions, Sequences, Synonyms, Grants and Roles.

Wrote PLSQL – Packages, Procedures, Functions using Cursors, Ref Cursors, Dynamic SQL, Bind Variables, Bulk Collect, Bulk Bind, Pipelined functions, Collections, PLSQL Table, XML Parser

Wrote complex business transformation logic using PL/SQL and delivered data in end/target tables.

Apply required pre/post validation to assure correctness of data for business.

Maintain central repo of code to move the same to multiple environments keep in sync across.

Extract DDL for Schema from lower environments and deploy in upper environments.

Use file extracted from multiple sources to load data into Oracle DB using SQL*Loader(sqlldr).

Create MASTER data using PL/SQL and deliver data utilizing SQL Aggregate and Analytical functions.

Created multiple Oracle Forms and Reports for ad hoc reports and manual load run for business.

Created Oracle reports with repeating frames for Agency/Agent/Provider/Subscribers.

Scrutinize performance thru OEM for long running scripts utilizing AWR/ASH reports, Explain Plan.

Use OEM AWR reports to hit performance pin-point and recommend fix accordingly.

OEM tracking to find the problem SQL and suggest fix to tune the same.

Monitor OEM for Wait Events and Session Locks kills.

Analyze Schema Tablespaces for Table, Indexes and UNDO and coordinated with DBA for the same.

Recommend frequency for Stats Gathering and directed DBA to include them at DB schedules.

Assisted DBA for Flashback Restore Point for the rigorous testing session in multiple environments.

Coordinate DBA to check on DB parameters and Flash Recovery Area(FRA) for health DB.

Use AppDynamics to perform stress test and suggest Bulk SQL insertion thread count.

Lookup Java code to use logic to migrate process to PL/SQL procedure for server-side processing.

Used WinSCP for file transfer between different data base servers.

Come up with apt Testing Strategy for various test cases and scenarios.

Wrote Dev Test Plan, Design Doc & Code Review Doc as part of project deliverable.

Environment: Oracle 12c, OEM 12c, SQL Developer 17.2, Java SE 10, HTML 5, CSS4, jScript, jQuery, Bootstrap v4.0.0, Notepad++ 7, Beyond Compare 3, Putty Beta 0.67, Filezilla 3.23.0.2, AppDynamics 4.1

University of Michigan-ICAM, Ann Arbor, MI Feb2017 – Sep2017.

Application Developer

ICAM (International Center for Automotive Medicine) Operational Data Repository: Structure the flow of incoming UD10 crash data from the state(DOT) and house the data in new PostgreSQL database. Developer and maintained UI layer on top of this data and other data collected from multiple sources and developed an Operational Layer for random access to perform data manipulation of the business. Integrate Oracle webservices and use run the ETL loads from UI.

Used Trizetto for Facets to create Data Mart for the underling application usage in Agile Environment.

Integrated Oracle services to kick-off and monitor load from the UI layer.

Used XMLtype API in PL/SQL and SQL statements combined with other columns and datatypes.

Stored XMLtype data in Oracle XDB (XML DB).

Used pgAdmin client to access PostgreSQL DB and PL/pgSQL.

Used Serials feature in PostgreSQL to generate Sequencing on column of the table.

Utilized advance PostgreSQL utilities– COPY, \copy, pgAgent, pgLoader, pgChart Foreign Table, etc.

Automated and structured flow of incoming UD10 crash data from DOT and house in PostgreSQL.

Lead initiative to implement open source Vfront tool, which is a PHP based application and require APACHE server configuration to create application layer using PostgreSQL.

User Manuals –Created User Guide, Installation Guide and Inplementaion and config for APACHE.

Demonstrated use of the Vfront tool to team added the required features and fixed error encountered with proper exception handling techniques in back-end to support SDLC.

Used SQL Injection and Dynamic SQL to satisfy appropriate search from the front-end.

Made changes to base CSS directory, jQuery, jScript, PHP and HTML to fix the tool as desired.

Vfront gives the access to the data from a Web API for operational needs and show the data in form and grid format on a single page UI.

Vfront features:

oWeb API for operational needs and presenting data in form and grid format on single page UI.

oData validation at the field level.

oAttach docs and images at the record level.

oFilter records based a specific search from the form view.

oGenerate pdf, xml, csv, excel format.

oAudit trail for Error for operation performed

oSynchronize the Database.

oAdminister the User groups and add user as per the need.

Maintained the users and roles in the tool and database level to suffice data security.

Performed manual onetime load of UD10 data to perform Split of data into required table structure.

Created logs for the data issue occurred during load and performed the corrective action to load data.

Environment: Oracle 12c, pgAdmin 4, WAMPServer64, PHP, jQuery, HTML 5, CSS, jScript, Bootstrap, MS Visio 2010, JAMS V6, SVN 1.3, Notepad++ 7, Beyond Compare 3, Putty Beta 0.67, Filezilla 3.23.0.2.

Marketing Associate, LLC Detroit, MI Aug2016 – Feb2017.

Sr. Oracle PL/SQL Developer/ETL

Resolving Data Sharing Process: The project primarily involved automating the manual process to an UNIX framework and delivering the data to various application layer, and hence was a straight though processing of files into DB and supporting entire data life-cycle (front office, middle office and back office functions) of a comprehensive list of application like TPG, VGF, Vparts, Gparts, OAP, CMS and many more.

Used the provided tech docs to create the code right thru.

Actively involved in cross platform discussion with DA, DBA, Admins, Reporting, and Web teams, to resolve complex issue in Agile Environment to Support full SDLC.

Analyzed, designed and implemented VGF Data warehouse, Data marts and File Validation Process.

Created complex Procedures, Packages, Functions, Materialized Views, External Tables, DB Links, Tables, View, Synonyms, Sequence, Indexes, Partitions.

Created storage structures for XML schema-based data.

Mapped XML Schema data types to SQL data types and binary XML encoding types.

Assisted in integration of Exadata applications into current IT actionable events and solutions.

Participated in analysis and designing of Oracle Exadata Server for infrastructure and related projects.

Leveraged UNIX framework for automating execution process and handing complex logic.

Used the appropriate indexes, hints, partitions for Performance Tuning and enforced other PLSQL techniques like Bulk Collect/Bind, Set Based Operators.

Used Oracle APEX to generate interactive reports to give access to the backend table.

Used Oracle APEX to develop quick data entry form for the purpose for operational purposes.

Created custom Reports and Web-Forms using Oracle APEX.

Integrated existing Oracle APEX forms and reports into Oracle EBS to enhance the business utilities.

Monitored long running processes thru OEM features– Top SQL, Top session, AWR, ASH.

Designed and creates jobs in JAMS for scheduling complex data flows to integrate multiple processes.

Drill down to the Root Cause of the failure in the process and provide instant long-term scale-able fix.

Handled various formats of file - XML, HTML, cvs, dat, txt, ctl, ldr as per the desired need.

Managed, Organized and Traced the progress of the Development, monitor dependent tasks of the team, and do a follow-up to track and enforce deliverables in time.

Environment: Oracle 12c, PL/SQL, SQL*PLUS 11g, TOAD 12.0, SQL Developer 4.1, OEM, HTML 5, JAMS V6, SVN 1.3, Notepad++ 7, Beyond Compare 3, Putty Beta 0.67, Filezilla 3.23.0.2

.Credit Acceptance, Southfield, MI June2016 – Aug2016.

Oracle PLSQL/Performance Tuning Developer

Credit Acceptance has offered automobile dealers financing programs to help them sell vehicles to consumers, regardless of their credit history. LSS (Load Servicing System) data migration is the large initiate to stream line their old system into never platforms, which will help their customer to leverage better services, effectively and efficiently, and hence help them to utilize new features available by CA to them with it. Data needed to be validated, if needed then corrected, and migrated and scaled to be specific format and hence, used and available for the downstream business layers.

Understanding the current requirement and existing environment in terms of data and architecture.

Involved in daily stand-ups with Scrum Master in the Agile environment.

Involved in Design discussions and meetings to come up with appropriate Data Mart to the lowest level of grain for each of the Dimensions involved.

Extensively worked on SQL & PLSQL procedure, function, and packages to take care of ETL process and effective data movement thru Oracle Data Integrator(ODI) and managed via Autosys jobs.

Used ROLLUP, CUBE and GROUPING SET to achieve report display for total and sub-total.

Modified, enhanced and developed complex Oracle Forms and Reports.

Created Oracle Forms and Reports using repeating frame.

Created Oracle Forms and Reports, Stored Procs, Functions, and Packages as per the business need.

Designed and implemented the MongoDB schema.

Wrote services to store and retrieve user data from the MongoDB for the application.

Used Mongoose API to access the MongoDB from NodeJS.

Give support to DSS, DWH, Reporting and Analytics teams as and when required.

Working on connectivity between analytical tools like Spotfire with Hadoop cluster thru JDBC.

Identifying and documenting necessary reporting requirements to build reporting architecture.

Used Vertica to build and working on validation tool for automated validation of source to target data.

Tuned PLSQL processes thru OEM and drill down to problem SQL and suggest fixed accordingly.

Monitored performance thru OEM and addressed to load balancing scenarios and issues.

Environment: Oracle 12c, OEM 12c, MS SQL 2012 SSRS SSAS, UNIX, HDP 2.X, Big Data, Hive, Hbase, Spotfire, Oracle Forms and Reports 11.2, Oracle APEX 4.2, ER Studio 8.5.3.

.ADP, Atlanta, GA Jan2016 - May2016.

Oracle PLSQL/Performance Tuning

ADP is large INC, which caters to the need of the payroll administration in the market and have countrywide presence. P2V (Pay Force to Vonage) data migration is the large initiate to stream line their old system into never platforms which will help their customer to leverage better services, effectively and efficiently, and hence help them to utilize new features available by ADP to them with it. Data needed to be validated, if needed then corrected, and migrated and scaled to be specific format and hence, used and available for the downstream business layers.

Used advanced PLSQL concepts in Procedure, Package & Functions to move the data effectively as required in various ETL processes.

Used Datastage as an ETL tool to extract data from sources systems, loaded the data into the ORACLE database.

Designed and Developed Datastage Jobs to Extract data from heterogeneous sources, applied transform logics to extracted data and loaded into Data Warehouse Databases.

Created Datastage jobs using different stages like Transformer, Aggregator, Sort, Join, Merge, Lookup, Data Set, Funnel, Remove Duplicates, Copy, Modify, Filter, Change Data Capture, Change Apply, Sample, Surrogate Key, Column Generator, Row Generator, Etc.

Tuned oracle processes build in PLSQL and drill down to the problem SQL and fixed them accordantly.

Responsible for the correct data modeling and successful transfer of data to data lake

Working on performance and load balancing scenarios and issues

Understanding the current requirement and existing environment in terms of data and architecture.

Working as a Scrum Master in the Agile environment

Loading data and building the schemas in Hive

Working on HBase on Hadoop cluster.

Worked on Talend ETL packages and integrated it with the Hadoop platform.

Support freshly build MongoDB server to utilize the need of the Web Apps.

Generated the required data set using MongoDB for NodeJS.

Implemented flat-file load into HBase using GoldenGate and Flume.

Environment: Oracle 12c, SQL Server 2008 – SSIS, SSRS & SSAS, UNIX, HDP 2.X, Big Data, Hive, Hbase, Spotfire, DB Visualizer, jQuery, HTML 5, CSS, JScript, Bootstrap, Datastage, ER Studio 8.5.3

.Beaumont Health, Troy, MI Aug2014 – Dec2015.

Lead Oracle PL/SQL Developer/Oracle Application Programmer

Beaumont Health is Michigan based health care system and recently collaborated with Oakwood and Botsford hospitals. Here my responsibilities were mainly focused on UI applications like Parenting, Breast Imaging Biopsy Processing (BIBP), CBT, LAB, PIX, Inside Beaumont, Concern and Grievance, My Projects, Nursing Dashboard, Physician Referral System (PRS), Physician Preference Guide (PPG), Bed Management System. Managed large files for inbound and outbound loads. Maintained end-to-end data flow and housed them in DB. Created user interfaces and handled data to house them.

Leveraged the EPIC system data framework for Clarity and house data in required Data Mart.

Technical assistance to user session to gather & implement requirements in agile environment.

Provide technical decisions as lead for deliverables for key projects.

Integrated and implemented enterprise MDM, business intelligence (BI) and DWH solutions.

Involved in projects to pull the required sources from EPIC and Clarity data to handle patient info.

Primarily maintained data in table using SQL Queries, PL/SQL package, Function, Stored Procedure.

Extracted data from Oracle, SQL Server and Clarity using Informatica to load into warehouse repo.

Utilized features like Temporary Table, DB Links, M Views, External Tables, Bulk Collect/Bind, Partitions, Collection Methods, Pragma Autonomous Transaction and Dynamic SQL.

Performed SQL and PL/SQL tuning using OEM and drill to the problem and suggested fixes.

Used OEM for SQL and Application tuning to recommend solutions to increase efficiency.

Handled errors using Exception Handling and Java Script validation extensively for the ease of debugging and hence directing user to provide suitable data.

Used Oracle HTP.P to deliver embedded HTML5, CSS3, jQuery and jScript to present web content.

Generate UI mockups from paper-and-pencil concepts to actual technical prototypes.

Used bootstrap framework, CSS3, jQuery, jScript and HTML5 for responsive website to enhance user experience for button and overall UI.

Administered Oracle APEX to generated swift role-based UI Application.

Created short time UI layer using Oracle APEX on the required DB set to handle Operational issue.

Generated dynamic Web-Forms and Grid Layouts using Oracle APEX.

Developed several Packages, Procedures and Functions consumed in Oracle APEX Forms.

Formulated SQL queries, functions and processes as per customization requirement for Oracle APEX.

Contributed with database designs and assisted in increasing response time for Oracle APEX reports.

Designed application framework and developed Oracle APEX Application.

Used Oracle APEX to created web-forms, charts, maps, trees and calendars.

Leveraged Azure SQL to create data-set for the Operational UI.

Created ER diagrams and multidimensional data models, reports and diagrams.

Applied data cleansing/masking techniques to ensure consistency amongst data sets.

Created relational and dimensional model for multiple applications.

Developed, managed and organized logical and physical data models using ERwin.

Environment: Oracle 11g 12c, IBM AIX 7.1, UNIX, TOAD 10.6, Oracle Report and Forms 10g & 11g, Oracle APEX 4.2.3, jQuery, HTML 5, CSS, jScript, Bootstrap, Remedy, EPIC/Clarity, ERwin r7.1/7.2/7.3/8.0

.Priority Health Insurance, Grand Rapids, MI May2013 – Jul2014.

Sr. Oracle PL/SQL Application Developer

Multiple System - Agent Commission Solutions, Self-Funded Autism Claims, Medicaid Reconciliation, Load Non-Med Load to CMS, Packet Request Manager, Pharmacy Rebate File Processing involved in multiple projects which involved various systems like Agent Commission identification, Self-Funded Reports creation for higher management, Automated Package Creation for the group members and enhancements to ETL Processes for CCMS Load & Claims file dissemination for external vendors. Streamlining the changes to accommodate the new healthcare reform, the Medicaid Reconciliation & EDI and UD10 file processing in new X12 Format.

Worked on FACETS modules - Subscriber/Member, Groups, Enrollment, Claims, Billing, Accounting, Provider, Agent, Dealer, Agency, Commission Structure etc.

Experience in manipulating EDI X 12 837(Health care claim), 835(Payment/remittance advice), 834(Benefit enrollment), 270/ 271(inquire/response health care benefits), 276/277(Claim status) transaction files as per HIPAA guidelines.

Responsible for testing batch jobs and Upgraded Sybase 12.5.3 to Sybase 15.0.2.

Wrote scripts to massage data feed to Sybase IQ/Oracle for alerts and automated using Autosys.

Generated SQL and PL/SQL scripts to populate data-mart on top of the warehouse.

Wrote SP Transformation for oracle workflow in the ETL processes for Oracle Data Integrator(ODI).

Created DB objects like tables, views, MV, External Tables, sequences, synonyms, indexes.

Extensively worked on Nested Tables, Varrays and PL/SQL records.

Created PLSQL objects using Cursors, Ref Cursors, Dynamic SQL and Bind variable to process data.

Used Oracle packages - DBMS_STATS, UTL_FILE, DBMS_SCHEDULER and UTL_MAIL.

Used Bulk Collect and FOR ALL to DML multi-row from table.

Created interactive reports with constraints in APEX for users to manipulate the actual tables in DB.

Used Oracle APEX framework to created web-forms, charts, maps, trees and calendars.

Created interactive reports in APEX to provide direct access to the tables in DB.

Created Oracle Forms and Reports using repeating frame.

Created Oracle Forms and Reports consuming PLSQL objects to create business logic.

Loaded data from various DB using SQL *LOADER utility.

Created UNIX shell scripts and scheduled Cron jobs to automate Insurance billing file.

Modified CGIs in Perl and Java which flashes data processing alerts on Web.

Used Perl scripts covering data-feed handling, implementing business logic consuming web-services.

Defined CSS scripts with custom classes and used same in HTML to deliver web content.

Modified the APIs for JDBC connection scripts to pass the data set and invoke procs.

Delivered Java Scripts to generate dynamic views thru HTML scripts.

Drill down root cause of slow running processes & provided suitable performance technique.

Assisted in documentation for DevTech Approach, UseCase Spec, Effort Estimation and Design Doc.

Involved in Sprint planning for iterations in Agile environment.

Environment: Oracle 11g 12c, IBM AIX 7.1, UNIX, MS Office Visio, TOAD 10.6, Putty Beta 0.63, Erwin 8, Oracle Report and Forms 10g & 11g, Oracle APEX 4.2.3, C++, Rally, Trizetto’s 4.7, WinSCP 5.1, Sybase 15.0.2, Sybase Central 4.1

.IMS Health, Collegeville, PA Oct2012 – May2013.

Sr. Oracle PL/SQL & Netezza Developer

Controlled Substance Rating

This System handled patient data to send alert to different stakeholders to prevent misuse of the medical prescription throughout US, across all pharmacy outlet, prescriber, service providers, warehouse storages to catch hold of any illegal practices at different level of security. Helped in the maintenance and automation of the daily or monthly refresh, populated the data mart for the system to generate SAS/MicroStrategy reports on top of the main SRW warehouse.

Facets driven Environments.

Implemented data quality (DQ) solution for enterprise MDM and BI projects.

Modified and created Netezza tables, synonyms, sequences, views, stored and procedures.

Used Netezza box to implement the ETL framework.

Worked with NZ Load to load flat file data into Netezza tables.

Assist DBA and Architect to identify proper distribution keys for Netezza tables.

Created mappings using pushdown optimization to achieve performance in loading data into Netezza.

Used join queries with analytical functions for Star and Snow Flake Schema.

Created suitable B-tree, Bitmap indexes, Partition table for improving performance.

Used Hints and Generate Statistics command to enhance the performance.

Created effective ETL work flows using PLSQL objects.

Created and modified complex Oracle Reports and Forms.

Loaded flat file using SQL*LOADER into database.

Used TOAD and Vertica for querying and debugging application.

Created and modified the file mover Perl Scripts.

Written Cursors and REF Cursors for transaction processing.

Consumed DB triggers based on the business rules and requirements.

Used webservices for generating GIS and Spatial Analysis and stores the relevant data set.

Wrote requirement for the Cybermation Batch Scheduling Process.

Used Datastage for simple to complex load to Master Data Management.

Wrote scripts automate scripts to support Unit Test Cases for data validation from SAS to Oracle.

Assisted in Functional Requirement Specification & Use Case Diagrams to streamline business flow.

Wrote PL/SQL Rappers for maintaining data & code security.

Environment: UNIX, Cybermation EST 5.1, Netezza 7.0.3, Oracle 11g, SQL*Plus 9.2.0.0, Sun Solaris 5.8, Putty Beta 0.60, Oracle Forms and Reports 10g, HPQC, WinCVS 2.0, HTML, MS Visio 2005, Data Stage 8.1

Barclaycard US, Wilmington, DE Sep2011– Oct2012.

Sr. Oracle PL/SQL Developer

Multiple Projects – BCUS Securitization, Partner Comp, Honey Profit Sharing and ASP to CDS Migration

The projects primarily involved the use of Barclay’s in-house customized Framework to migrate the data from DB to STG and further to different layer like SRC, ODS, ADS, DMA and BREVA layer and finally to main legacy data warehouse PWARE to support different lines of business. Systems maintained accounts of all the customers, implemented a solution for providing standardized Accounting Reports, and automate the process of providing the data to business without manual intervention.

Worked to load OLTP data into the Staging Area and Data Warehouse using transformation.

Made structural changes to DB objects using Oracle tools like SQL*Plus and TOAD.

Leveraged enterprise MDM solutions to enhance the application features.

Wrote complex SQL queries, Sub queries and nested loops for faster data retrievals.

Extensively used Cursors, Ref-Cursors, Dynamic SQL, Bind Variable in PLSQL.

Utilized OEM in Performance Tuning for the SQL, PL/SQL scripts.

Created PLSQL objects using Bulk Collect and Bulk Binding for performance data retrieval.

Modify tables for loading data from different sources files using SQL*loader.

Used exception methods with pragma exception_init to associate customized exception names.

Used SP transformation and designed data flows for the Datastage Application.

Handled XML Files for data loading purposes.

Used UTL_file package for automated ETL processes for file modification sync system.

Used APEX to develop end to end Web Application Development.

Created PostgreSQL DB to build the data mart for the Web Application Usage.

Leveraged new PostgreSQL DB to integrate the requested data from front-end.

Organized and managed routine jobs using packages like DBMS_SCHEDULER to schedule tasks.

Used various Shell Scripts and Scheduled jobs on Crontab in UNIX environment on a routine basis.

Wrote complex Perl Scripts to handle pattern search for heavy data loads.

Assisted in Migrating Integrated Plant System (IPS) from Sybase 11.0 to Sybase 11.5.1.

Responsible for end to end testing on Oracle Accounts Payables.

Testing entire process of Oracle EBS Payables to GL, AP, Assets creation mass Addition thru Payables.

Involved in designing of DB architecture and developed ER Diagrams with ERWIN.

Environment: UNIX, Oracle 11g, OEM 11g, SQL*PLUS 9.2.0.3, Toad 10.6, E, HP-UX 11i v3, IBM AIX 5.2/5.3, HPQC, WinCVS 2.0, WinSCP 4.1, APEX 4, Data Stage 8.1, Sybase 11.5.1

Intern UNVA – School of Technology, Annandale, VA Sep2009 – May2011.

DB Application Associate

MASTER(MBA) General Management GPA 3.70/4.0 GRADUATE 2011OCT

Multiple Projects – Involved in in-house initiative for Student Grievance System, System Wiki and Poster campaign. Assisted in automating DB load using raw source and involved in manual cleaning and added constraint for correctness of

Contact this candidate