SUMMARY

• 8+ years experience using SQL (Oracle 8i - 11g, Teradata V2R6 - 13, SQL Server 2000 - 2016)
• Experience in developing, testing, and supporting production ETL routines
• Ability to analyze systems and processes and propose performance improvements
• Ability to gather and analyze data requirements for new developing and modifying existing ETL
• Experience in tuning queries for reports, views and ETL routines in multiple platforms
• Ability to work effectively both independently and in a team environment
• Relationship building with customers, application vendors, and members of other teams

TECHNICAL SKILLS

• ETL Design and Data Warehousing concepts
• Systems and Data Analysis,
• Process analysis, documentation, and improvement
• Business Objects Data Integrator 6.5, 11.5
• Data Services XI 3.1 (Designer and environment admin)
• Informatica
• SQL (Oracle, Teradata, SQL Server)

PROFESSIONAL EXPERIENCE

Confidential

Sr. Staff - Software Application Engineering

Responsibilities:

• Developed a flat-file upload and processing function for a Stock Options processing application
• Delivered a POC for converting a collection of .NET web applications from SQL Server to Teradata
• Worked with the Data Warehouse support team to determine Teradata system configuration changes that would fully support a dual role (OLAP, OLTP) for the Teradata DW
• Provided analysis and tuning recommendations for a collection of older SQL Server DTS packages
• Led the Dev team through the 6+ month process of upgrading from PRPC 6.1 SP2 to PRPC 7.1.7 across all application environment levels (Dev through Prod)
• Produced application enhancements per the in-sprint story requirements
• Performed code review sessions with Dev Team Members per the team’s Code Development Procedures
• Managed all code migration and provided post deployment support (RBS dept application)
• Led and mentored third party developers, QA team members and offshore QA
• Provided technical guidance on all story grooming and sprint planning sessions and assisted the team’s business analyst on any technical questions pertaining to new story development
• Created and maintained documentation on application team processes and proposed improvements wherever necessary

Confidential

Lead Systems Integrator

Responsibilities:

• Performed analysis of source data and table structures to create/verify data extraction rules
• Worked with BI Leads and Business Users to define new ETL and report logic requirements
• Created and tuned complex queries to satisfy data delivery requirements
• Extracted data from SQL Server (2000/2005), Oracle 9i/10g, and other proprietary database products
• Created new/improved ETL designs and provided ETL design direction to third party development teams
• Created and tuned ETL using Teradata loading utilities (MultiLoad, Fastload, Tpump, Bteq)
• Improved Teradata resource use via table statistics, improved Index selection, and table partitioning
• Built ETL routines using Business Objects Data Services and Teradata’s OLE DB Access Module
• Built Stored Procedures and Macros in Teradata where needed for improved push-down optimization
• Assisted with tuning of SQL queries generated from Business Objects reports
• Created solution design documents for enterprise data integration opportunities
• Worked with teams of people from peers to upper management across departments and global locations
• Provided support for the Business Objects Data Integrator/Data Services XI 3.1 ETL servers
• Analyzed the ETL environment for performance tuning opportunities and presented proposals for same
• Provided training as needed for new hires (internal & third party) on use of Freeport’s ETL tools
• Improved performance of the Data Services ETL tool through updates to coding practices
• Production Support Lead for 2000+ ETL routines and on-call rotation for after hours support
• Created processes guiding the use of third party development resources in India & Indonesia
• Created and maintained the scheduling services for ETL in Test and Production environments (Autosys)
• Provided representation for the Data Warehouse at global change management review sessions
• Performed impact analysis and gave EDW change requirements to cover changes in source systems

Confidential

Sr. Systems Analyst

Responsibilities:

• Worked to transition support for Production ETL and Reporting processes from the Confidential Data Warehouse Support Team
• Monitored, created, and repaired batch jobs running in Business Objects Data Integrator 6.5
• Analyzed and recommended performance improvements at the job, workflow, and dataflow levels
• Created and maintained Rapid Ramp-Up training documentation to quickly train new additions to the team
• Assisted in defining protocols for utilizing off-shore resources in India to facilitate 24x7 production support for Honeywell's data loading and reporting tasks
• Provided 3rd shift support on a rotating basis

Confidential

Oracle ETL Developer

Responsibilities:

• Worked with business groups and end users of various skill levels to define and refine data requirements for data extracts used in product development
• Established programming templates to help standardize data extract code
• Reviewed and tuned complex SQL code for both ad-hoc and recurring data extract requests
• Performed monthly, quarterly, and ad-hoc data extract requests from Oracle 8i & 9i Databases
• Delivered data to both internal and external customers as per requirements
• Created ETL process improvement proposals and documented existing processes
• Created weekly and monthly reports for ETL team productivity
• Worked with dozens of data sources feeding into 50+ Terabytes worth of healthcare related data (Rx,Mx)