Senior Analyst, Programming Resume

SUMMARY:

Extensive 16 - year development history with Confidential, Inc.
Experienced in .NET applications development and support, database design, SSIS, SSRS, SSAS/Tabular Model.
Highly proficient and analytical IT professional in a fast-paced business environment.
25-year employment history with Confidential ’s, Inc. with miscellaneous recognitions for performance.

TECHNICAL SKILLS:

Languages: Teradata SQL, T-SQL, VB.NET 2.0/3.5/4.0, ASP.NET, VBA, VBScript, Classic ASP, HTML, XML, VB6

Databases: Teradata 14.0, MS SQL Server 2008R2/2012, MS SQL Server Enterprise Manager 8.0, MS Access 2010

Software: Teradata SQL Assistant, MS SQL Server Management Studio 2008R2/2012, MS Visual Studio 2010, MS Office 2010, PowerPivot, Toad for Oracle, ClearCase, Lotus Notes, Crystal Reports, MS Visual SourceSafe, InstallShield, Visio, Remote Desktop, FTP, ADO.NET

Concepts: Relational Database Design, Macros, Stored Procedures, Data Access and Retrieval, Object-Oriented Programming (OOP), Debugging and Testing, Deployment, Data Staging

Systems: Windows 7, Windows Vista, Windows XP, Windows 95

Other: MS SharePoint 2010, SQL Server Reporting Services (SSRS)

PROFESSIONAL EXPERIENCE:

Confidential

Senior Analyst, Programming

Responsibilities:

Teradata SQL developer for Standard Reports team. Develop complex Teradata backend solutions for reporting needs. Experienced Teradata SQL developer creating macros, global temp tables, derived tables, physical tables, sub-select queries, parameters, and indexes as necessary. Serve as Lead Developer on Replenishment reporting project.
Write queries and design Teradata DDL objects as necessary to support reporting needs.
Support/create/modify Excel VBA templates with connections to SSAS databases on a Sharepoint website.

Confidential

Senior Analyst, Programming

Responsibilities:

Developed database solutions in Teradata supporting Sales and Order Forecasting for Cube team. Developed VB.NET user interface applications for ad-hoc quering and reporting against Teradata. Served as Lead Developer and SME in a fast-paced environment.
Supported/modified SSAS/Tabular Models. Built all supporting SSIS packages for data extraction. Assisted other developers in how to create/design SSIS packages. Also assisted other developers with SQL queries and VBA / VB.NET applications.
Developed a PowerPivot reporting solution using Sharepoint 2010 for automatic and scheduled data refresh of Excel templates.

Confidential

Senior Analyst, Programming

Responsibilities:

Supported Localization POC. This effort included cube development with MDX calculated measures, Teradata objects, Teradata queries, ETL, VBA coding, SQL database table structure, views, and procedures, SSIS package, and SSRS report, and ad-hoc data dumps as requested.
Developed SSIS packages supporting daily processing. This package pulls data from Oracle daily and loads SQL tables. The package uses SMTP to send email in case of failure. Have created supporting SQL tables, views, and stored procedures which drive month-end and ad-hoc reporting.
Tested PerformancePoint Dashboard Designer and PowerPivot on Sharepoint 2010 sandbox environment.

Confidential

Programmer/Analyst

Responsibilities:

Designed VB.NET applications that pulled data from SQL databases and loaded Excel templates in order to automate manual processes. Designed supporting ETL packages that pulled data from Oracle or Excel data sources, or Lotus Notes csv attachments. Designed supporting SSRS reports. Limited exposure to C#. Provided how-to instruction to another developer and to manager on VB.NET.
Designed and coded Over, Short, and Damage system that allows users to search appointment records from SQL database, email carriers and vendors with carton shortage amounts, and update records on mainframe screen. This system included a VB.NET end-user application; a supporting daily ETL package pulling in data from Oracle tables; and a supporting daily screen scrape application loading data from mainframe screen. An HTML Email is generated by end-user within the application and sent using SMTP. This application is still in use.

Confidential

EUC Senior Programmer/Analyst II

Responsibilities:

Designed and coded merchant support applications and systems some of which were rolled out to all Confidential ’s retail divisions.
Coded Merchant Business Review (2020) application which produced end-user Excel report showing top 20% and bottom 20% of styles based on weekly selling. This system was rolled out to all Confidential ’s retail divisions. The system had a 10-year life.
Designed a coupon barcode tracking web application. This app was rolled out to all Confidential ’s retail divisions. This app took 20-digit coupon barcode data and converted to meaningful reporting data.
Designed SQL databases to support .NET project needs. Built DTS jobs and created .NET applications which imported flat files into SQL databases (ETL). Performed time sensitive merger-related projects.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship