Etl Developer Sql
Resume:
Cecile K. Djoumessi
Bowie, MD 20716
**********@*****.***
SUMMARY
Senior Oracle PL/SQL Developer / BI & ETL Specialist with 15+ years of experience. Results-oriented with strong interpersonal and team-building skills. Proven analytical and written communications skills. Areas of expertise include: Data modeling (ERWIN, Star schema, Snowflake), PL/SQL, Informatica, BI Reporting tools (Crystal Reports Enterprise, BI Publisher), Perl/Unix shell scripting, web services and Database administration and monitoring with exposure to Object-Oriented Design and Java Programming.
· SQL, PL/SQL, SQL*PLUS, SQL*Loader, Toad
· OOD, Java, Javascript, Jquery, JASON, AJAX, HTML, CSS, Python, C++, PRO*C/C++
· Erwin, Data Modeling Techniques (Star Schema, Snowflake)
· Web services, SOAP, WSDL, SOAPUI, Restful, JAX-WS
· Data migration using Advanced PL/SQL Techniques in a RAC environment
· Unix shell and Perl scripting
· ETL (Informatica) and Reporting Tools (BI Publisher, Crystal Reports)
· Testing, Maintenance and Troubleshooting
RDBMS Software: ORACLE 11g/12c
Case tools: ER Studio, Oracle Designer, Erwin, Doors
Development tools: PL/SQL, SQL*PLUS, TOAD, SQL Developer,
ETL and Reporting tools: SQL*Loader, Informatica, Data Stage, Crystal Reports, BI Publisher.
Operating systems: MS DOS, Windows, UNIX (SOLARIS, HP_UX, AIX)
Others: PVCS version control, TeamSite, Eclipse, CVS, Team Approach,
Subversion/SVN, Putty.
PROFESSIONAL EXPERIENCE
PSI / ProSphere-tek – Alexandria, VA November 2017–May 2022
Senior Oracle Database Developer
Client: Department of Veterans Affairs - VBA (Veterans Benefits Administration)
●Wrote the Oracle PL/SQL standard document to be used as PL/SQL coding reference document
●Work assignment: Duplicate Data Merge Application (DDM): One of the main objectives of the DDM application is to eliminate duplicate records by merging, reconciling, and consolidating participants records flagged as duplicated in the VA Corporate database.
●Led the Database Development of the new DDM code. Data model type: hierarchical as opposed to relational. Database: VA Corporate Database.
●Attended requirements gathering and clarification meeting with peers.
●Attended VET360, Benefits EO/PD Daily Synch-up meeting in preparation of the BGS project.
●Reviewed and analyzed the old code to extract the DDM requirements. The requirements were also gathered by reviewing the DDM legacy output.
●Streamlined the very complex and challenging DDM packages to use oracle analytics and hierarchical functions. We went from 10k lines of codes to less than 2k by cleaning up and refactoring/rewriting major functionalities. Over 95% of the code were rewritten.
●Solved the performance issues with the creation of indexes and the rewriting of more than 90% of the original code. Also added the errors logging procedure for easy debugging and maintenance.
●Unit tested the new code by comparing results with the old code and legacy application
●Used the DDM tool to process merge/deactivation requests from the business client.
●Prepared the deployment scripts for promotion to INTGD environment.
●Work assignment: Request for Architecture Change application (RFAC): Redesigned the RFAC database by creating intersection tables to solve de many to many relationships for the purpose of tracking historical data across all database environments. Refactored, streamlined and rewrote over 90% of the code. Merged 13 existing packages with over 60,000 lines into one package with less than 20,000 lines. Wrote advanced pl/sql procedures and functions to generate complex RFAC reports.
ManPowerGroup / Experis – Washington, DC December 2015–September 2017
Senior PL/SQL Developer
Client: USPS Wilkes-Barre, PA
●Developed complex PL/SQL packages/stored procedures in support of the ECR Order Merchandising and Peak hour reports (Microstrategy).
●Developed complex XML queries to support the ATG XML migration requirement .
●Participated in the Design, modelling, development of the RPM Data Warehouse in support of the Microstrategy reports. Design methodology: Star-schema.
●Provided Production support for various databases applications: ECC, RPM, HRKM.
●Troubleshoot performance issues using indexes, tables partitioning. Diagnostic tools: Explain Plan, AWR, HOPR, Oracle advisor.
●Wrote Unix scripts and stored procedures in support of Where Is My Package ETL batch process.
CSRA – Columbia, MD December 2013–June 2015
Senior Professional Data Warehouse Architect / Informatica ETL Developer
Federal Project - Healthcare System: DECC - CMS Program Columbia, MD
Database Size: 100+TB, Clinical measures submission data
●Federal Project - Healthcare System: DECC - CMS Program Columbia, MD
Database Size: 100+TB, Clinical measures submission data
●Developed complex Informatica clinical measures mappings to support ETL processes that populate the staging database and the data warehouse.
●Developed complex queries to support the dashboard high level requirements.
●Participated in the Design, modelling, development of the Enterprise Data Warehouse and the associated Data Marts. Design methodology: Star-schema.
●Worked with business analysts to ensure that the correct data is being sourced into the Enterprise Data Warehouse.
●Worked with business analysts to ensure the technical solutions are updated in the requirement traceability matrix (RTM) document.
●Developed data set queries and PL/SQL packages/stored procedures in support of the design and creation of enterprise BI Reports (OBIEE, COGNOS).
●Performs gap analysis between source data loaded in the staging area and target DW data.
●Translated business needs into data models and technical specifications.
●Worked with team members in peer reviews throughout the BI/DW life cycle.
●Prepared unit testing documents and deployment plan in support of deliverables and QA/UAT test cases.
●Developed complex SQL queries in support of the OBIEE dashboard high level requirements.
●Wrote stored procedures to support reports development in Cognos and OBIEE environments.
●Developed BI Publisher reports.
●Performed queries optimization and performance tuning on packages/procedures/queries used in BI/DW. Created indexes, partitions, materialized views and scheduled jobs (DBMS_SCHEDULER) when needed.
●Solved Production fixes and advised on strategies to prevent recurrent defects.
●Wrote anonymous procedures to populate development data warehouse environment with test data.
●Mentored juniors PL/SQL developers.
CSRA – Washington, DC January 2012–June 2013
Senior Oracle Database Administrator
Client: U.S. Department of Justice
●Identified data anomalies and restructured the current BVP Bulletproof Vest Partnership (BVP) database to use the Oracle TCA (Oracle Trading Community Architecture). This includes the design of the highly normalized party structure of actors and artifacts. Led the database design and development team with the implementation of the logical and physical data modeling of the normalized system.
●Led the development team by defining detailed specifications and clarifying high level requirements.
●Created indexes, performed queries optimization and performance tuning at all levels (database instance and query). Used Oracle Tuning Advisor and Toad query optimizer.
●Performed import and export using oracle Data Pump utility.
●Developed views and instead-of-triggers to support the JEE web interfaces.
●Wrote stored procedures, packages functions and materialized views to support the normalized system.
●Rewrote the payment batch process to comply with the new party structure and to automate the batch execution process.
●Wrote ad-hoc reports to generate reconciliation/de-obligation reports using payment requests, obligations, de-obligations and invoices.
●Wrote various migrations and validation scripts to implement the new party structure. Automated the validation of the data migration to ensure all data were migrated.
●Streamlined deployment process to reduce errors during FQT and Production implementation.
●Wrote the data conversion document.
●Wrote queries and procedures for unit testing (for testers).
●Provided database support in a RAC development environment including starting and shutting down database instances, performance tuning and queries optimization, database refresh and replication, table partitioning, space management and all other PL/SQL development taking advantage of the RAC features (parallel hints).
Verizon Business – Colorado Springs, CO July 2007–December 2010
Onshore Technical Lead/ Senior ETL Developer
Database Size: 5TB, Inventory and Billing Data Warehouse
●Managed & supervised all development done by offshore developers based in Argentina.
●Developed complex PL/SQL packages and supervised the production maintenance of the GARM SENSITIVITY based on the requirements received from business users.
●Wrote and implemented advanced PL/SQL features: Oracle advance queuing (OAQ), Streams CDC propagation, Parallel scheduling of jobs (stored procedures and functions), tables partitioning and swapping, parallel query, bulk binding, collections, Merge statement, Oracle External tables, Oracle parallel jobs execution.
●Developed PL/SQL and Perl scripts to issue web service calls, parse and load data into Oracle database.
●Wrote Unix shell scripts, PL/SQL packages and procedures to support the IDW inventory system data warehouse ETL processes.
●Developed Unix Shell Scripts to process the files on daily basis before loading them into Oracle based tables.
●Involved in multi-tier Java and J2EE based applications support, responsible for writing business logic using core Java, SQL statements for the Oracle backend RDBMS.
●Wrote C++ code with embedded Oracle SQL statements that will later use the Pro*C/C++ precompiler to replace the statements with appropriate calls to Oracle runtime library functions.
●Extensive experience in implementing SOA concepts by designing and developing Web Services using SOAP/HTTP.
●Wrote C# and Java code to consume Web Services.
●Developed web applications using various technologies (mod-PLSQL, JavaScript, html, CSS, prototype, dojo, ajax, JQUERY, PL/SQL web kit).
●Attended Informatica 9 training and ITIL version 3 I and II.
●Provided Production Support on a 24/7 rotation basis.
●Self-taught the following OBIEE components: Repository administration, BI Server, BI Publishers, Scorecard, Interactive Dashboard, Briefing books, Disconnected Analytics & BI Delivers.
●Developed report processes using Crystal Reports 7/8/XI.
Teksystems – Colorado Springs, CO August 2005–June 2007
Client: Verizon Business
Senior Oracle PL/SQL/ETL Developer (08/2005–06/2007)
Database Size: 5TB, Inventory and Billing Data Warehouse
●Developed complex PL/SQL packages and supervised the production maintenance of the GARM SENSITIVITY based on the requirements received from business users.
●Wrote and implemented advanced PL/SQL features: Oracle advance queuing (OAQ), Parallel scheduling of jobs (stored procedures and functions), tables partitioning and swapping, parallel query, bulk binding, collections, Merge statement, Oracle External tables, Oracle parallel jobs execution.
●Developed PL/SQL and Perl scripts to issue web service calls, parse and load data into Oracle database.
●Wrote Unix shell scripts, PL/SQL packages and procedures to support the IDW inventory system data warehouse ETL processes.
●Assisted in Designing Conceptual, Logical and Physical Data Models. Developed stored procedures to migrate data from legacy to staging area.
●Developped GUI using JQuery JSON and Java script.
●Resolved defects using a combination of Javascript, JSON and JQUERY.
●Developed report processes using Crystal Reports 7/8/XI.
●Provided Production Support on a 24/7 rotation basis.
.
Management Systems Designers (MSD) – Bethesda, MD
Client: National Library of Medicine (NLM) August 2004–June 2005
Senior PL/SQL/ETL Developer
Database Size: 1+ TB, Drug Information Data Warehouse
●Served as an extract, transform, and load (ETL) developer on the RXNORM project, implemented an automated Oracle PL/SQL ETL process that extracts clinical drug data from healthcare and pharmaceutical organization sources including SNOMEDCT, HL7, NDDF, FDA, MICROMEDEX, VANDEF, and UMLS to an RXNORM database. Clinical drugs edits comply with semantic normal form, Semantic Clinical Drug (SBD), Semantic Clinical Drug Component (SCDC), Semantic Clinical Dose Form (SCDF), and Ingredient (IN).
●Gathered requirements associated to the source data filtering requirements and transformation rules; attended meetings to identify and clarify ETL RXNORM project requirements; and performed data analysis, validation, and mapping between source data and RXNORM data.
●Created external tables on flat files using Oracle9i loader.
●Wrote procedural language/structured query language (PL/SQL) packages and UNIX scripts to extract, transform, and load data into the RXNORM database and optimized PL/SQL scripts using Oracle9i EXPLAIN PLAN features.
●Performed full production, development, and testing schema exports; implemented an automated routine to process Obsolete Clinical Drug (OCD) when the drug has been removed from the market; and implemented an automated process to create safe replacements for absent clinical drugs.
●Wrote PL/SQL9i stored procedures on Oracle Parallel Servers environment to implement the Resynchronization process; reconciled the latest UMLS release with current RXNORM database; and runs scripts to apply appropriate changes.
●Wrote detailed documentation of the entire RXNORM ETL processes.
●Performed Graphic user interfaces and Web applications development using J2EE (Servlets, JSP, EJB), Eclipse, MVC, Struts, JNI, ant.
●Developed and tested Java Core Development for various projects.
EDUCATION & PROFESSIONAL DEVELOPMENT
Master, Accounting & Finance, ESSEC - Business School of Economics and Commerce, 1984-1988
Erwin and Data warehouse Design (Dimensional Modeling)
Advanced SQL&PL\SQL
Oracle Designer/Developer 2000
UNIX Solaris (administration and programming)
Oracle Database Administration 10g and Oracle Financials 11i
Completed Java J2EE Web Applications development class with Learning Tree, June/2005
Informatica 9/10 completed formal training July/2010
ITIL1 Version 3 and ITIL2 Version 3
Contact this candidate