ETL Developer / Technical Analyst Resume

SUMMARY

I am an ETL developer with experience in supporting an Enterprise wide solution which maintains multidivisional customer data. In my most recent role with Confidential as and ETL developer, my primary task is to design implement and support, tables, views, stored procedures and DDL triggers. Our Azure SQL Server is then used to deliver data for Metrics Reporting, Digital Enterprise Solutions, and for user creation in source systems. I am a local commuter within the Twin Cities, and surrounding areas.

TECHNICAL SKILLS

Technologies: SSMS, SSIS, SSRS, EBX, C#, Power BI, Azure Dev Ops, SalesForce, Salesforce Workbench, Workday, Okta, Active Directory and Computers, Jexplorer, Softerra, Atlassian Jira, Service Now, Taleo, Survey Gizmo, Survey Monkey, Microsoft Office including Excel (Expert) and Access. SQL / T - SQL, VBA, Java, C#, Visual Basic, HTML/CSS, PHP (xampp, wamp, Abyss) WordPress, Freshdesk, Chase Orbital Gateway Paymentech, Stripe, Batch Scripting, Brightcove Video Cloud, Amazon S3, EBX

SQL: The queries I wrote serve three functions Stored Procedures, Views, and Data Analysis. Our Stored Procedures are used to populate data into the different tables. Data comes from our source systems such as Salesforce, Okta, EBX, and our store procedures manipulate and replicate the data across relevant tables

PROFESSIONAL EXPERIENCE

Confidential

ETL Developer / Technical Analyst

Responsibilities:

As an ETL Developer for Confidential my primary focus is to ensure our ETL runs smoothly and serves the needs our Divisions and our Business Partners
Error log analysis / SSRS Reporting to determine job failures
Gather business requirements to Architect Database objects and flows to support new Solutions, Customers, or Functionality
Data manipulation and cleansing
Documentation for both Technical and Non-Technical knowledge
Devise plans for deployments and regression testing which impact the ETL.

Confidential

Data Analyst

Responsibilities:

As an Analyst for Confidential Tax & Accounting team, my primary responsibility is to provide both granular and high level data models on Key Performance Indicators on revenue and sales to drive growth for a $50 million business unit within Wolters.
Internal Teams include: Accounting, Global Sales, Technology Implementation Solutions, Governance Risk & Compliance (GRC), Product Management, Tagetik Aquisistions team, and TeamMate Next Gen
Salesforce is the main repository for Sales information and archived for data models
Data is extracted from Salesforce, and four separate SAP databases and from there manipulated to align with reporting requests
Collected data archived within Access and SQL
Created Forms, and queries within Access, Excel and PHP to report on data
Used Relational DBs to link multiple sources of Large Data together
Customize reporting to provide data specific to Organizations

Confidential

Data Analyst

Responsibilities:

As a Data Analyst for Confidential, my main responsibilities are to provide the Leadership Teams with multi-dimensional demographical data analysis and support.
Reporting via Salesforce to analyze impact of system issues (ie, customer canceled accounts, production hours to assist customers, revenues affected, etc.)
Salesforce track repeat customer occurrences
Working with our Support services team it is my duty to ensure the preservation, integrity, and modeling of data related to RLJE’s Streaming Video On Demand (SVOD) services.
Data is analyzed and presented for use in Business planning, future implementation, and to garner support and interest from our investors.
Types of Reporting: Customer interactions Monthly and Annually, Customer Subscriptions, Video Engagement, Revenue reporting, S3 Data Scrubs
Provide data, and support for any departments (ie, Profits and Loses, Accounting, Marketing, HR, Product Research and Development) requesting information related to our SVOD
Data is extracted through internal systems, then filtered multiple times, down to a subset of data which represents a specific population or category
KPI Related Reporting: Workday Reporting (Personnel and Job-related data), Taleo Reporting (Recruiting related Data), Survey Gizmo (Quality of Hire and New Hire Retention Data), Survey Monkey (Exit Interview Data), Sales KPI and Performance Management Reporting
Distribute findings in Monthly and Quarterly Dashboards created through Excel and PowerPoint
Provide useful insight on abstract and non-linear correlating data
Gather and archive customer data within Access
Maintained search forms and queries within Access as a local database search.
Created search tool within Excel linked to Access to provide simplified search for non-experienced users with RDBMs.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship