We provide IT Staff Augmentation Services!

Senior Systems Analyst / Developer Resume

Atlanta, GA

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.

Hire Now