We provide IT Staff Augmentation Services!

Senior Etl Developer Resume

Birmingham, AL

PROFESSIONAL SUMMARY:

  • Self - Motivated, Self-Starter
  • Confident, articulate, and professional speaker to a variety of audiences
  • Diligent and enthusiastic with a proven track record of working successfully across functional areas within the enterprise
  • Have supervised efforts of requirements gathering for all phases of the SDLC
  • Senior Business Intelligence Analyst performing end to end solutions development. Have led efforts to move data (ETL) to a data warehouse/data lake/operational data stores for reporting to C level executives
  • Led MicroStrategy systems analysis, solutions analysis, architecture, development and management
  • ETL design, data architecture, development, integration and deployment of SaaS (Software as a Service) solutions in the healthcare industry
  • Data Architect of a cloud based, SaaS solution consolidating 98 plus existing services, cleansing, harmonizing the data, and delivering syndicated outputs flat files to the enterprise
  • SAS software integration, administration and programming in the healthcare and financial sectors
  • Project lead from conceptualization, through design, integration, and implementation of a SAS software system built and utilized by the Confidential, Division of Medicaid for consolidating multiple data sources, performing advanced analytics, flagging fraud, anomalies and patterns for further investigation
  • Worked in multiple large scale data migrations in multiple environments including MySQL, Oracle, MS SQL Server and HPCC(High Performance Computing Cluster)
  • SQL analysis and development in a variety of sectors, including Healthcare, Financial, Insurance, Natural Resources (Oil and Gas) and Retail
  • C level report creation and automation on the Confidential Medicaid in relation to many Federal and Confidential initiatives (examples: LTC facilities MDS calculation automation, Dental Encounter Settlement calculation automation, Behavioral Health, and other ICD-9-10, CPT, and HCPCS code sets)
  • Healthcare Affordability Act preliminary implementation testing through ‘go live’ Jan 3, 2012
  • MMIS (Medicare Medicaid Management Information System) administration and systems analysis
  • Extensive use of the Microsoft Suite (Word, Excel, PowerPoint, SharePoint, Visio, Project) in multiple industries.
  • Have worked with an array of BI tools (MicroStrategy, Tableau, Power BI, OBIEE etc.) as part of the data gathering and analytic/data discovery/data mining phase of any project

TECHNICAL SKILLS:

Languages: SAS, R, T - SQL, PL-SQL, ECL, PowerShell, CAML, DAX

Environment: s: HPCC, Windows, OS X, IBM iSeries, web hosted & local distributed environments, NoSQL data stores, Oracle 11c and 12g, MS SQL Server 2008 through 2017

Software: MicroStrategy, Elasticsearch (Kibana, Logstash), OBIEE, Oracle(Multiple Versions), Visual Studio (SSIS, SSRS, SSAS and SQL Server) SAS (Base SAS with multiple business specific modules), R, MBS, Essbase, Pentaho, Talend, Power BI & other Microsoft Products(Office Suite, Visio, Project), Toad for Oracle.

Databases: Vertica, Netezza, DB2, MS SQL Server, MySQL, Oracle, Sybase, FoxBASE, HPCC, NoSQL environments and other distributed systems

PROFESSIONAL EXPERIENCE:

Confidential, Birmingham, AL

Senior ETL Developer

Responsibilities:

  • Developed an Error Handling method for SQL Server using SSIS
  • Developed a method of going between Incremental Data Loads and Historical data loads to the Enterprise Data Warehouse
  • Perform the ETL the get data to the Enterprise Data Warehouse bringing in new data elements

Confidential, Birmingham, AL

Senior Data Engineer

Responsibilities:

  • Load data from various source systems to an Enterprise Data Warehouse
  • Optimize SQL queries when needed for performance
  • Use multiple tools to create the ETL to load the EDW
  • Write SQL queries to pull data into the EDW
  • Tune and Optimize Oracle and Vertica SQL Queries
  • Worked on a large scale cloud migration of an Enterprise Data Warehouse. Moved an on premise EDW to the cloud
  • Managed Data Migration using iPass Informatica Cloud
  • Used Kimball Data Warehousing methodology to create data structures

Confidential, Birmingham, AL

Programmer Analyst

Responsibilities:

  • Gathered requirements on large scope projects that would be built to support the Enterprise
  • Worked heavily in Visual Studio developing solutions (SSIS, SSRS, SSAS)
  • Worked with Oracle 12g in all regards via Toad
  • Was second in command (backup) for Confidential Corporations SAS data operations
  • Programmed, troubleshot, introduced SAS code into a SAS user base of 400+ users
  • Programmed in Windows PowerShell extensively when applicable
  • Worked with SharePoint Designer on certain solutions
  • Directed projects with C level executives on custom programmatic solutions.
  • Designed workflows and solutions to meet needs that couldn’t be met with out of the box solutions
  • Developed SQL queries which would enhance the environment as well as populate SSRS reports
  • Worked heavily in Microsoft’s Power BI application both on premise servers and their cloud service offering
  • Integrated R into a few projects through Visual Studio’s new interface to R

Confidential, Birmingham, AL

Senior Business Intelligence Solutions Analyst

Responsibilities:

  • Defined data requirements and designed report (metrics & other objects) layouts for the business to review and utilize.
  • Worked with development team to define and migrate data from multiple sources to operational data stores and data warehouse for multiple uses i.e. reporting, analysis etc.
  • Created testing plans and scripts for new project additions based on business and technical requirements.
  • Created and delivered documentation and solutions to various business teams to quantify key projects and their business impact
  • Oversaw integration projects into a common BI environment, MicroStrategy
  • Managed relationships with key business stakeholders through the process lifecycle

Confidential, Alpharetta, GA

ETL Developer

Responsibilities:

  • Create support and persist multiple products through ECL development on an HPCC platform
  • Utilize multiple platforms in concert for product development
  • Work with multiple teams to ensure smooth transitioning through the SDLC

Confidential, Lawrenceville, GA

Business Intelligence Administrator, ETL Developer

Responsibilities:

  • ETL Development utilizing Pentaho
  • SQL Development
  • Developed ETL workflows migrating multiple data source systems to a Linux environment using Pentaho

Confidential, Alpharetta, GA

Senior Consultant

Responsibilities:

  • Worked across multiple platforms in an enterprise data migration
  • Member of HPCC Development team (proprietary open source ‘big data’ platform, HPCC), developing reportable data marts from MS SQL Server to a distributed environment
  • Systems including, but not limited to, Siebel, Eloqua, Essbase, MBS, Google Analytics, HPCC
  • Data was transformed and cubed for reporting using OBIEE, Tableau dasboarding etc.

Confidential, Atlanta, GA

Business Intelligence Analyst

Responsibilities:

  • Analyzed, reconciled, validated, updated, and made changes to data from over fifty physical/virtual servers located throughout the U.S. and Canada.
  • Worked with Business Analysts to validate UAT environments to ensure all clients’ needs were being met prior to moving to production
  • Analyze, modify, change and create stored procedures and reports as needed using MS BI Stack
  • Interpreted various data sources and structures and advised senior management on data governance as well as Business Intelligence best practices.
  • Generated and executed Test scripts in and plans for new Energy Efficiency related programs.
  • Generated updates, transactions and other transformation scripts to align data from disparate sources.
  • Maintained scripts during all phases of the SDLC.

Confidential, Atlanta, GA

Big Data Analyst | Data Scientist

Responsibilities:

  • Worked on the data science team analyzing large amounts of data
  • Performed all SAS Analytics for the enterprise.
  • Administered a SAS server (V-9.3) in all regards.
  • Analyzed and modeled financial data showing patterns in fraud and trends determining default
  • Worked with executive management on company initiative development, integration and implementation

Confidential, Alpharetta, GA

Data Architect | MDM

Responsibilities:

  • On the development team of the “Scientific Workflow Management Solution Harmonization” project, combined and cleansed data across 98 legacy systems and developed a SaaS solution utilizing many current software development techniques/methodologies in an Agile/ SCRUM development environment.
  • Assisted Liaison’s SOI (Service Oriented Infrastructure) and Contivo (Liaison’s proprietary mapping utility) developers in the configuration, scalability, testing and standing up of the environment for this project.
  • Performed Master Data Management and data architecture in the build of a SaaS solution
  • ETL in the integration of multiple data sources
  • Utilized were web services, SOAP calls (Extraction), XSD construction using a proprietary mapping solution (Contivo), PL-SQL, PL-SQL Developer, Oracle (10g,11g), MS SQL Server, and finally served up cleansed data marts to an SFTP.

Confidential, Anchorage, AK

ETL Developer | Architect | PM

Responsibilities:

  • Project lead in the full lifecycle (RAD) development of specialized applications to implement new state or federal regulations and policy changes | incentives quickly
  • Modeled data, ETL processes and performed analysis of these specialized applications, in parallel to ensure policy was integrated correctly
  • Analysis, reporting of Confidential, Division of Medicaid policy and programs to ensure consistency, detect fraud and abuse, efficiency and compliance
  • Conceptualized, designed and implemented a SAS software system allowing the state to consolidate multiple data sources (ETL) and established processes and procedures to analyze 20-25 million dollars in weekly Medicaid claims
  • Provided a SAS analytic environment allowing 60 + Medicaid program managers tools needed to make informed, quantifiable reasoning to support program changes
  • Implemented an analytic solution used in reporting to key stakeholders in the state and federal government, fiscal agents, and business partners
  • Developed Centers of Excellence (COE) related to project & program models, development and deployment ensuring effective deployment of personnel, processes and technology and documentation
  • Defined the concept, data model, ETL, and macros to automate an acuity based measure of payment for specific Medicaid programs and generate reports for state and federal officials
  • Digest, interpret and implement policy, ensuring compliance and determining impact
  • Served as the point of contact on many federal/state initiatives in healthcare
  • Created requirements documents and liaised on enterprise software and hardware implementation
  • Identified related risks, constraints and needed action on BI project transformations, technical and functional analysis, product selection and change management
  • Mapped Medicaid programs using SAS/GIS to see the impact of the programs on the Medicaid population

Hire Now