SUMMARY:

19 Years of experience working in with Oracle databases and PL/SQL. 10 years of experience in data warehousing.

WORK EXPERIENCE:

Confidential, Charlotte, NC

Consultant

Environment: Oracle 11g, Linux, Informatica, PL/SQL, SQL, SQL Loader, Shell Script, Autosys

Responsibilities:

• Working on database and ETL enhancements so that reporting is compliant with the Markets in Financial Instruments Directive II(MiFID II) regulation.
• Modified existing Informatica jobs and PL/SQL code to apply MiFID II enhancements.
• Working on creating new ETL jobs using Autosys, shell scripts, SQL Loader and PL/SQL to populate an Oracle reporting database with feeds from multiple sources.
• Work with business analysts to research reporting issues.

Confidential, Boston, MA

Senior Data Engineer

Environment: Amazon Web Services(S3, Redshift, EMR), PySpark, Python, Tableau, PyCharm, SQL Server, T - SQL, SQL

Responsibilities:

• Designed data model for digital marketing analytics database.
• Developed Python code to populate digital marketing analytics database with Snowplow data.
• Created data flow diagrams to document how the digital marketing analytics database would be populated.
• Supported existing SQL Server data warehouse.
• Created and modified T-SQL stored procedures to populate the existing SQL Server data warehouse.
• Trained an offshore team to support the existing SQL Server data warehouse.
• Worked with business intelligence and data science teams to resolve reporting issues.
• Created data flow diagrams to document how the existing SQL Server data warehouse is populated.
• Helped with redesign of existing SQL Server data warehouse.
• Worked on source to target mappings to populate the new data warehouse.

Confidential, Boston, MA

Data Warehouse and ETL Developer

Environment: Oracle 11g, Dell Boomi, Linux, PL/SQL, SQL, SAP Business Objects, Microstrategy, Siebel, SQL Server

Responsibilities:

• Designed and developed an enterprise data warehouse to be used by Marketing, Finance and Operations departments.
• Designed data model for the data warehouse Schema.
• Used Dell Boomi and Oracle PL/SQL to architect and develop the ETL to pull data from multiple systems to populate the data warehouse.
• Used SAP business to create universes to make the data available for reporting.
• Working on implementing Microstrategy as a BI tool to replace Business Objects.
• Work with business users on requirements gathering.
• Evaluated and helped select ETL and BI tools to be used for this project.

Confidential, Burlington, MA

ETL Developer

Environment: OLAP, Oracle 11g, MySQL, Unix, Talend Open Studio, PL/SQL, SQL, Unix Shell Script

Responsibilities:

• Work on development and support of an operational data stores and data warehouses for several of Confidential ’s clients.
• Architected ETLs using Talend Open Studio and Oracle PL/SQL.
• Support Unica marketing campaigns.
• Oracle Database Performance Tuning
• Train and support an offshore support team.
• Provide support to analytics team to help resolve data anomalies.
• Provide business analysts with development resource requirements and estimates.
• Help make improvements to the development process.

Confidential, Hopewell, NJ

Oracle Developer / Backend Team Lead - Consultant

Environment: OLTP, Oracle 11g, Unix, PL/SQL, SQL, Unix Shell Script, TKProf

Responsibilities:

• Analyzed business requirements to ascertain the necessary backend changes required for various projects.
• Wrote low level design documents.
• Assigned tasks to offshore development team in India. Wrote Oracle PL/SQL code and Unix Shell Scripts.
• Worked as backend development team lead to make enhancements to the client’s Oracle Database to be compliant with the Dodd-Frank Act.
• Worked as backend development team lead to make tax calculation enhancements to the client’s Oracle Database.
• Used TKProf to identify bottlenecks and make performance enhancements to the Oracle Database.

Confidential, Westfield, NJ

Oracle Developer

Environment: OLTP, OLAP, Oracle 11g, Oracle Warehouse Builder, PL/SQL, SQL, Business Objects, XML

Responsibilities:

• Worked on development and support of an Electronic Data Interchange(EDI) system.
• Wrote Oracle PL/SQL code to generate and parse XML files.
• Architected and developed a Data Warehouse using Oracle Warehouse Builder.
• Created universes and business objects using SAP Business Objects.
• Wrote ETL using Oracle Warehouse Builder.
• Designed data model for the Data Warehouse.
• Provided backend support for a global shipment management system.
• Created and modified Oracle PL/SQL code.
• Developed and supported accounting interface from the shipment management system to an external financial system.
• Wrote the extraction code in Oracle PL/SQL.

Confidential, New York, NY

Software Engineer / Team Lead

Environment: OLAP, OLTP, Oracle (8i, 9i, 10g), Windows XP, Unix, PL/SQL, SQL, Brio Intelligence 6.6, PowerBuilder

Responsibilities:

• Worked on the re-design of an existing Oracle data warehouse.
• Provided technical support to researchers to fulfill their data and reporting needs.
• Managed and assigned tasks for the data warehouse team.
• Wrote and maintained several ETLs written in Oracle PL/SQL.
• Wrote a hot backup of the Oracle data warehouse using Unix shell scripts and Oracle PL/SQL.