MS BI Developer Resume

TECHNICAL SKILLS:

Databases: T - SQL, SSAS, MDX, SSIS, SSRS, ODBC, ADO, C# LINQ, Perl DBI

Languages: C#, C/C++, assembler, VB, VB.net, Perl, VBScript, Ruby, some Powershell, HTML, some Javascript, ASP.NET WebForms/MVC/WebAPI.

Functional programming: F#, some Scala, some Haskell nix: Cygwin, Linux, bash, ssh, apache2, proftpd, emacs, vim

MSOffice: Excel (macros, functions, pivot tables), Access

PROFESSIONAL EXPERIENCE:

Confidential

MS BI Developer

Responsibilities:

Implemented custom rollups and many-to-many currency conversion for an Analysis Services proof-of-concept. Built and optimized MDX cell-calculations with scoped subcube assignments. Used usage-based optimization for aggregations. Developed comprehensive use cases in Excel with complete SQL to compare with MDX. Developed testing scripts in IFsharp (IPython) notebooks. POC was published to Sharepoint using Excel Services. Presented and delivered the prototype to the client.

Confidential

Data Analyst

Responsibilities:

Created export reports (TSV/CSV/pipe), migrated reports from Crystal to SSRS, built a web service exporter (C#), resolved report tickets, developed a few small utilities in F# including SSRS to PDF and SSRS deployment tools.

Confidentia

Data Analyst

Responsibilities:

Resolved tickets with Oracle queries and Perl scripts, generalized report scripts into a single Perl script which emails the result as an Excel spreadsheet

Confidential

SQL SDET

Responsibilities:

Linked-server population pulls rows from DB2 to SQL (row limits made it tricky)
TSV import for population (with a regex “trick” to fix for tabs in fields) (C#)

Confidential

Database Engineer

Responsibilities:

Some of an FTP to AWS S3 utility, which copied and validated data (Talend/Java)
Migrated databases & cubes from SQL 2000 to 2008 (MSFT to AWS)

Confidential

Database Developer

Responsibilities:

SQL: Optimized stored procedures, built a few reports

Confidential

Database Engineer

Responsibilities:

Reports (SSRS), web front-end (C#), data collection (webtrends)

Confidential

Software Engineer

Responsibilities:

Site metrics reports (aggregation along a tree of invitations) (SSRS)

Confidential

CTO / database & web developer

Responsibilities:

Created Import, export, “pinger”, product update, replicated backup in Perl, optimized queries and created cached aggregates, built a collection system using Linux,Cygwin,ssh,rsync,proftpd, wrote SPUpload to send file changes via FTP or SOAP using C++ & ATL, wrote upload web services in VB with example clients in VBScript, Perl and C#, wrote SPScan for collecting sales in C# using Sqlite

Confidential

Software Engineer

Confidential maintenance: billing in Access, customer-support, script changes.
Helped import Confidential ’s customers to zShops, Inventory control application for a partner, identified memory leaks and query inefficiencies. (C++/Oracle)
Scripts to archive/delete old files, monitor & bounce java processes (bash/Perl)

Confidential

Software Engineer

Responsibilities:

Migrated Confidential to new servers, answered customer support issues, ad-hoc queries, script debugging, made modifications for security concerns.

Confidential

Independent Contractor

Responsibilities:

Importing, email, nightly indexing, “want matching” (C++,Thunderstone,batch files)
Search, shopping basket, send order emails (Thunderstone webscript)

Confidential, Bloomfield, CT

Computer Programmer

Responsibilities:

A “report viewer” for a communications app in Visual Basic, an accounting workbook with posting macros, a spreadsheet that pulls from SQLBibliofind’s first import, search & “want matching” (VB/C++/Texis/MSSQL)

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship