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