PROFESSIONAL EXPERIENCE:

Confidential

Senior Data Analyst - Moon Twp, PA

Responsibilities:

Responsible for data analysis of large data sets using SAS Visual Analytics to perform advanced statistical and predictive modeling against the Package Level Profitability (PLP) 5.4TB Big Data data warehouse and presented analytical research findings to director-level senior management. Developed statistical models, decisioning graphics and imbedded predictive marketing analytics using SAS Customer Intelligence 360 to present “what if” analysis to the sales organization to aid in the development of regional product line agreements. Designed and implemented several daily, weekly and monthly ETL processes written primarily in Informatica aimed at analyzing data integrity, quality and viability. This involved writing complex multi-table PL/SQL routines to quickly extrapolate key performance indicators within each data set. Graphically designed, documented and executed all mappings and transformations, performed capacity planning, performance tuning, data validation, data mining and cleansing, partitioning, multi-level aggregations and complex transformations to populate the multi-terabyte Teradata Big Data EDW which housed the information for several director level reports. Designed graphical decisioning and visualization models using SAS against the Big Data EDW for presentation and collaboration with business stakeholders. Worked directly with the various business units to immediately resolve any functional or performance issues that arose as well as perform continuous improvements and functional enhancements as requested. Constantly evaluated ETL processes for performance tuning, efficiency, sustainability, scalability and load scheduling. Further responsible for the design, architecture and normalization of the underlying Oracle DW and database and composed associated ERD diagrams and conceptual and physical data models. This included conducting multiple joint application design (JAD) sessions with the various clients and business units to thoroughly understand their business processes and requirements. Managed small group of 4 PL/SQL contractors/developers to perform the underlying data validation and sensitive data cleansing. PLP, architected primarily in Informatica Agile Integration, pulls data from 27 various data sources and transforms the data into a staging database containing package level, station level, and linehaul level information. The application pulls approximately 40 million packages, 600 million scans, and 120 million linehaul routes on a daily basis from the various data sources and uses complex logic to develop package revenue and costs, shipment scan history, point-to-point linehaul, and accessorial costs (i.e. return to shipper, multiple delivery attempts, hold at location, etc.) to transform and compile the data using OBIEE dimensional modeling into the star-schema Teradata data warehouse which houses historical scan data in several billion+ row tables. The data sources include various Oracle tables, Terradata Big Data tables, upstream AbInitio and Informatica ETL feeds, flat files, excel files, and XML feeds. All application development done adhering to strict guidelines of all phases of the System Development Lice Cycle (SDLC) and following Agile SAFE Framework methodologies.

Confidential

Senior Database/ETL Architect - Pittsburgh, PA

Responsibilities:

While maintaining strict HIPAA guidelines working with sensitive customer medical data, responsible for the performance and integration of key ETL processes populating several large Sybase 12.5.4/15.0 & Oracle 10g data warehouses for a mail-order pharmacy application. Managed team of 6 level 1 database developers through all stages of the project life cycle. Responsible for requirements gathering and mapping those requirements in Sybase PowerDesigner to build the ERD diagrams, conceptual, logical and physical data models and design. Developed and maintained MS Project plan ensuring all project deliverables accounted for. Worked closely with clients and various business units to ensure all business requirements reflected in the data model and design. Further responsible for designing the ETL processes in Informatica PowerCenter to populate the database from the various data sources as defined in the business requirements. Ensured team always focused on Confidential ICARE principals of Integrity, Customer-first, Accountability, Respect and Excellence. Created and maintained logical & physical database model for all 2080 tables and 1900 stored procedures via several large entity-relationship and functional hierarchy diagrams in Sybase PowerDesigner. Assigned to design and/or review all SQL code - both TransactSQL and PL/SQL either embedded or stored procedures - written by the development staff for performance implications. This involved reading query plans and making SQL and/or index schema changes to make the query more efficient. Further responsible for troubleshooting all performance issues and/or deadlocks reported by clients. Triaged all customer issues and implemented or delegated resolutions. Version control maintained in CVS and Subversion. Load testing performed by setting up Autosys scripts to simulate 1200 simultaneous users. Further responsible for normal DBA tasks for both Oracle and Sybase databases such as installations, periodic maintenance, performance & tuning, database backup & recovery, database configurations, data device management, re-sync & maintenance of replication server, table/user security, capacity planning and space allocations, etc.

Confidential

System Performance Group - Harrisburg PA

Responsibilities:

Database Project Manager and Data Architect responsible for designing the data architecture to successfully migrate the criminal and juvenile court information from all 67 counties within the state of Pennsylvania into a unified judicial system. Responsibilities included data modeling and database design of the Oracle 9i database and Sybase IQ data warehouse based on the functional requirements of the many business communities. All modeling done in Erwin and PowerDesigner. Further responsible for visiting each county and performing detailed gap analysis between the 67 legacy database systems and the Oracle hub. Developed ETL conversion scripts to identify data leakage and successfully migrate all data to the centralized database hub. While primary ETL tool was Informatica, several ETL scripts written in PL/SQL, Perl, SQL*LOADER, Sybase Stored Procedures, and UNIX shell. Further responsible for managing the Sybase Replication Server employed to keep the database and data hub (warehouse) in sync.

Confidential

Senior Systems Engineer

Responsibilities:

Responsible for technical integration and proposal responses to major government and commercial RFP's and RFI's. Evaluated several vendors of major systems components including optical servers/drives, workstations, imaging software, scanners, printers/faxes, workflow, networks and mainframe terminal emulators determining their requirements specifications, ease-of-use, overall functionality, and integration with other third-party packages and the Oracle RDBMS.

Confidential

Senior Database Consultant

Responsibilities:

Headquarter’s Manager of Database Services responsible for all U.S. refinery DBA’s and the support of each local database and its associated applications. Database Administrator responsible for the maintenance, performance monitoring, application tuning, network and system configuration, database security, and capacity planning of a large (~60GB) logical database distributed across 3 separate U.S. refinery physical database servers.