Sr. Business Intelligence Developer Profile LIVINGSTON, NJ

SUMMARY:

Development of business applications
Experience utilizing languages and tools
Well organized, team Player.
Minimal supervision.
Analyze data and detecting room for opportunity and growth.
Responding to needs to different departments and managers.
Creating Ad-hoc reports on demand, Gathering Business requirements for custom reports.
Having a set of canned reports that can be analyzed in many different scenarios. Forecasting which University Programs will need additional physical class room space for incoming students.
Using Data ratio students vs. teacher salary How much will does it cost to run the program . Analyzing and interpreting data in a visual Dashboard, Scorecards and Filtering features.
Suggesting BI needs to Managers.

PROFESSIONAL EXPERIENCE:

Position: Senior Consultant L4

Confidential

RESPONSIBILITIES:

Position: Sr. Business Intelligence Developer/Database Administrator Contract

Confidential

RESPONSIBILITIES:

Scripts using SSIS, SSRS and SSAS.
Migrating to MS-SQL 2012.
Rewriting many process that Data Objects SAP were using to process data and data extracts using SQL Script.
Designing ETL processes using Visual Studio. Data extract from the AS/400.
On Call 24 hours, troubleshooting data issues in the middle of night. Using the Pragmatics and Red gate tools.
Scripting to send out alerts that data is accurate to the specific end user. Writing scripts to fine tune indexing.

Position: Sr. Business Intelligence Developer

Confidential

RESPONSIBILITIES:

Purchasing, Setting up, and configuring a MS-SQL 2008 R2 server for Data warehouse purpose. Writing scripts using SSIS, SSRS and SSAS.
Purchasing, Setting up and Configuring and administrating the Tableau Server Version 7.
Creating Dashboard, Scorecard and Reports Card concept as needed using Tableau Desktop and Tableau Server Versions 7
Designing ETL processes.
Defining Data sets such as Google Analytic, MediaMind, Facebook, Twitter, Bright Cove, Resolution Media and Radiant6
Define and Design Dashboards, Scorecards and Reports
Writing Scripts to send out alerts that data is accurate.

Position: Sr. Database Administrator and Developer Full Time

Confidential

RESPONSIBILITIES:

Purchasing, Setting up, and configuring a MS-SQL 2008 R2 server for Data warehouse purpose.
Consolidate multiple data silos that exist on campus to one location.
Scheduled data extracts on a daily basis,
Sophisticated stored procedures and triggers to provide complete technical solutions.
Using Advanced DTS Packages and well as scripting Language for data scrubbing and data mining, build internal/external interfaces, and support currently developed for the Server.
Use expert knowledge of MS-SQL Concepts, Using development tools such as SQL-Developer Suite 10g toolset and programming languages such as PL/SQL, and MS-SQL, PL/SQL
BI Reporting tools Tableau and Cognos,
Diagnose/resolve technical problems independently, articulate and discuss solution with peers in a confident manner with a view to getting input to provide the best solution.
Multi task in the fast-paced, production environment to juggle priorities as needed to provide resolution to high profile technical issues.
Diagnose performance issues using SQL trace technology as well as database explain statements and ability to analyze output of these traces.
Creating reports as needed using Tableau Desktop, Tableau Public and Server versions, the reports are shown in a Dashboard, Scorecard and Reports Card concept. Architect technical solutions using deep understanding of the Data sets.

Hardware: Pentium series. Dell PowerEdge 2970 Opteron Server

Operating Systems: Windows XP, Linux, Windows 7, AS/400 DOS

Databases and Mining tools: MS-SQL 2008 R2, MS-Access, Tableau, Excel and Jenzabar

Languages: C , Ruby on Rails, VBA Visual Basic, PL-SQL

Position: Tableau Developer Contract

Confidential

RESPONSIBILITIES:

Project consists tracking Internet activity along with competitor's data. My responsibility consists of setting up Server and being the point person to answer questions about tableau Desktop along with.
Creating Ad-hoc Reports against SEO and e-commerce data
Define requirements, partner with business users to think beyond operational metrics to the next question and manage client expectations about capabilities and timing.
Work closely and build relationships with team members.
Using large data sets Core Metrics, and Bright Edge.