SUMMARY:

• Accomplished, determined IT professional driven by the intense need to solve puzzles; tenacious when pursuing solutions to complex data mapping issues.
• A quick study who thrives on challenges and opportunities to leverage/expand skill set with more data tools and new, bleeding - edge applications.
• Expertise in SQL Server 2005/2008r2/2012r2 thru 2017 SSIS/SSAS/SSRS (MSBI), AlwaysOn, performance-tuning, stored procedures, and ETL design/management.
• Record of performing ETL against OLTP data, extracting batch data from DB2, ingesting data from drop sites, and pulling data from AWS sources.
• Proven ability to handle data from OLTP advertising placement negotiations, property/workers Comp, HIPPA MDS, MS CRM, GPS, GIS, and customer wireless post/pre-paid billing.
• Adept at reverse-engineering existing stored procedures and ETL, relationships from front-end systems and end-user requirements.
• Understands index maintenance, query performance tuning (query plans), long-running queries, configuring meaningful SQL alerts.

TECHNICAL PROFICIENCIES:

Agile, Scrum, JIRA, VersionOne Exposure to working with AWS, GCS, Azure, Tableau, PowerBI and other BI tools Cloudera Enterprise 5.12 Administration Python/Spark code debugging Jenkins testing/deployment Oracle 9i and 10.2g, using REFs, PL/SQL, imp/exp, SQL Loader Crystal Reports 1.x to 2013 Business Objects Enterprise XI and 6.5, Web Intelligence Cognos Business Intelligence Reporting & Analysis, Framework Manager CA/AllFusion ERwin Data Modeler 7.x - 4.x ODBC data sources MS Team Foundation Server

PROFESSIONAL EXPERIENCE:

Senior Systems Analyst / Developer

Confidential, Atlanta, GA

Responsibilities:

• Perform SQL Server 2012r2 DBA duties for DEV/PreProd(QA)/PROD enterprise data warehouse processes; availability: on-call rotation.
• Maintain SQL ETL, upgraded and improved performance when migrating from 2008R2 to 2012 r2.
• Manage new ETL development projects in SSIS and Hadoop, including hybridized jobs deployed with Jenkins.
• Conduct Cloudera Admin duties in DEV, including some development and deployment tasks.
• Project managed production deployment efforts for SQL Server and BizTalk; provided scripts to DBAs, and run book schedules.
• Drove SQL Server 2012r2 promote-to-production implementation; moved/upgraded 300+GB DB, and led initial deployment of AlwaysOn for Darwin database(s) to maximize availability.
• Provide DEV and QA support to additional CoxReps initiatives, including Darwin eHub, Darwin dHub, and Finance Group’s salary calculator; managed production deployment for all products.

Principal Business Intelligence Developer

Confidential, Atlanta, GA

Responsibilities:

• Investigated all source systems used by Confidential BI2 data warehouse, including two billing systems (one on DB2), Peoplesoft HR and Financials, external vendor-supplied data, and MDS-sourced data for the full life cycle of back-end development of the data warehouse.
• Extensively researched legacy DW and BI 2.0 DW to investigate data validation discrepancies, determined causes, and fixed or documented ETL issues.
• Developed Analysis Services (SSAS) cubes for end-user access via pivot tables in Excel.

Lead Data Warehouse Analyst

Confidential, Atlanta, GA

Responsibilities:

• Collaborated with business clients and stakeholders to document business requirements and create database specifications.
• Transformed data from two disparate AS/400-based Insurance management/claims/billings applications, loaded into interim ODS and conformed the results into a merged data warehouse to allow combined reporting.
• Provided 24/7 on-call support for database support as needed to ensure achievement of operational and project objectives.
• Compiled quarterly financial reporting for workers’ compensation insurance filing requirements.

Data Analyst

Confidential, Atlanta, GA

Responsibilities:

• Analyzed raw data from healthcare networks for import into CAI data model to support RepriceEngine (out-of-network claims repricing application).
• Determined calculation of multiple-column/32-character "PrimeID" to represent single provider/location record.
• Investigated/converted Client’s customer invoice and service order data into their SQL server database (FrontLine) and supported Cobol-based back-end (SouthWare).
• Developed design specification for TechLine, (web-based Field Tech support application) using Ormandy's Frontline back-end database; worked directly with front-end developer.
• Analyzed data to support projects being added to EDW data warehouse based in Oracle 10.2g with BusinessObjects Enterprise XI.
• Audited Informatica ETL maps extracting data from Confidential billing system, transferred to staging area, and transformed into Facts and Dims in EDW data warehouse.
• Determined Confidential business rules for converting work orders from “pending” to “completed” to expedite Confidential business processing before ETL jobs.
• Analyzed data to support new 3C Data Warehouse (based in Oracle 10.2g) with Cognos 8 analysis tools.
• Developed specifications for ETL processes to extract Landmark data, send it to outside vendor, and import resulting GPS Clinic Stops data for evaluation; ensured adherence of all business rules for matching criteria.

Confidential, Atlanta, GA

Data Warehouse Analyst

Responsibilities:

• Parsed ETL scripts and stored procedures to extract application-specific information regarding Teradata/Oracle databases and tables used within ETL; analyzed data to support consolidation of customer information in data warehouse projects.
• Designed Informatica-based data mappings and transformations for new data feeds into/out of warehouse.
• Created Teradata-based Data Marts for 24- and 36-month rolling histories of billing and revenue data for Client’s consumer and large/small business customers.
• Analyzed Sarbanes-Oxley (SOX) compliance for user access validation process.
• Identified data for cleansing before import into IBM’s Tivoli Identity Manager; reported fixes to source data managers.

Confidential, Atlanta, GA

Data Migration Analyst/Report Developer

Responsibilities:

• Created data flow diagrams illustrating current ETL and data warehouse processes.
• Developed reports against Network Lease Audit/Management Data Warehouse in Business Objects 6.5; validated results against original MS SQL Server v 2000 database with matching queries.
• Imported data from flat file and Excel spreadsheets into Oracle 9i tables.
• Extracted data from Oracle into temporary tables for cleansing and standardizing column entries to be re-imported into new Oracle data structures; used extensive ad-hoc queries to create/modify/delete data.
• Cleansed data from network infrastructure information contained in Oracle 9i backend database for migration to Xng (Granite) application; made extensive use of REFs, Nested Tables, and collection objects.