We provide IT Staff Augmentation Services!

Etl Developer Resume Profile

Professional Summary:

  • Expertise in VB, VBA, ETL Processes, Hyperion HFM, FDM, MS ACCESS, Excel, .Net
  • Expertise in SQL Server Architecture, Stored procedures, Triggers, SSRS, SSIS, DTS, Tuning
  • Strong Analytical and programming skills
  • Good work ethics with excellent communication and interpersonal skills

APPLICATIONS:

MS SQL SERVER 2000, 2008R2, Microsoft Visual Studio .NET 2003/2012, SQL Reporting Services, SQL Server Management Studio, MS Access 97/2000/2003/2007/2010, MS Excel 97/2000/2003/2007/2010MS Query Analyzer, MS Word, MS Outlook, Visual Basic 6.0, MS FrontPage, Crystal Reports, Visual Interdev, QuickBooks, VMware, Hyper-V, Hyperion HFM Financial Management Application, Financial Reporting Studio, Shared Services and SmartView, FDM, Hyperion Workspace

LANGUAGES:

Visual Basic for Applications, VB, T-SQL, Visual Basic, C , HTML, XML, XBRL, Python

EXPERIENCE:

Confidential

Senior SQL Server Database Developer

Worked in the finance org of CA and created reports and managed reporting leveraging MS SQL, MS Access VBA and Microsoft .Net Technologies. Wrote many custom finance applications including a Database upload tool, Database management application, GAAP checklist and headcount reporting. Worked on intercompany forecasting and P L databases to reconcile data from SAP, Hyperion and Journal entries. Further project details below.

Confidential

VB.NET windows application. This application was created to monitor for hung FDM processes. Once detected it would email the Hyperion team and allow for reply to actions. Such as Kill the process, cease monitor, or retrieve application status.

Confidential

MS Excel VBA code used to upload up to 12 periods of data to Hyperion Planning. Was used for Forecast Budget data. Used many data validations and complex logic. Logic was used to automatically determine period s to load, validate accounts existed in Planning, lock loads based on user security. Validated data needed based on load type Forecast or Budget. FDM Scripting was used to automatically load any file the user outputted by the application. A SQL server backend database was architected to store all user activity data, errors, user security, maps for logic, and version control enforced user to always use latest version of tool .

Confidential

MS Excel VBA code use to load various user data to Hyperion Planning/HFM. Used same complex logic for determining periods, user security, and data validation as the Multi-upload tool noted above . FDM scripting was used as well for auto-upload to Hyperion Planning/HFM. A SQL server backend database was architected to store all user activity data, errors, user security, maps for logic, and version control enforced user to always use latest version of tool .

Confidential

MS Access VBA code used to import the latest FDM export for each Planning country for current reporting period. It would split the revenue based on a SQL Server allocation table percentages maintained by corp FP A team into License, Maintenance, Subscription. FDM scripting was used to import into Planning statistical cube.

Confidential

SQL Stored procedure, SQL views SQL Server Reporting Services SSRS, ETL process was used for splitting reconciling SAP Feeds by revenue type. It compared two SAP feeds to do YOY/QTQ analysis and broke it by many different calculations/percentages. Purpose was to report any concerns to KPMG/ Internal auditors. This application was in scope with SOX compliance.

Confidential

- MS Access VBA code used to automate 450 local MS Access db's upload to SQL Server DB for legacy contracts. Logic implemented to only replace what is coming in. Also many data validations along with use of a handful of SQL stored procedures SSIS packages. This application was in scope with SOX compliance.

Confidential

ASP.NET / VB code for managing legacy contracts. Add/update/Delete, SSRS reports etc. Complex logic for unique legacy contract validation for all phases of user changes. This application was in scope with SOX compliance.

GAAP Checklist ASP.NET / VB code for managing local statutory reporting for many international countries/regions. Complex logic to ensure webforms are populated correctly. Implemented automatic check reports to auto flag follow-up needs. Output to Excel, etc. Also uses a few SSRS reports.

Confidential

ASP.NET / C code used for tracking and reporting Headcount for the finance org. Application was split into two parts due to time constraints. I built the ETL routine and designed the backend database using SQL Server and my colleague made the website. After his departure I upgraded the framework to 4.5, fixed some errors to reduce processing time, and also added new functionality as the business needs changed.

Confidential

MS Access VBA code used to automate validation of FX rates for the Finance Org.

Confidential

MS Access VBA code used to split revenue from the legacy contract db and load to SAP.

Confidential

MS Access VBA code used to track monitor employee expenses. An ETL process would load data from SAP weekly. The application served as a customer service type application to flag employees, T E rep to add notes, email employees, and reports on issues. This application became the most heavily used application in the T E group. I later architected a SQL database backend as the business needs changed.

Hire Now