PROFESSIONAL SUMMARY:

• Highly dedicated IT professional with a focus on steering high - impact BI initiatives and driving full-cycle database development in support of operational and technological company goals.
• Regarded as a sharp, independent “quick study” as well as a reliable, hands-on team contributor.
• Highly proficient in design and development of SSIS Packages and using various control flow tasks and data flow transformations.
• Extensive experience in developing stored procedures, functions, views and triggers and complex queries using T-SQL.
• Experienced in scheduling of SSIS packages using SQL Agent.
• Experienced in resolving on-going maintenance issues and bug-fixes, as well as query optimization and performance tuning.
• Working knowledge of MS Excel and COGNOS.
• Superior communication skills, strong decision making and organizational skills along with outstanding analytical and problem solving sills to undertake challenging jobs.
• Able to work well independently and also in a team by helping to troubleshoot technology and business related issues.

TECHNICAL EXPERTISE:

MS BI Stack: SSIS | SSRS | SSAS | DTS

Databases: SQL Server 2014/2012/2008 R2 /2005/ 2000 | mySQL | Oracle 10g/11g | DB2

DB Languages: T-SQL | PL/SQL

DB Objects: Tables | Views | Stored Procedures | Indexes | UDFs | Transactions

Tools: SSDT/BIDS 2008 | Visual Studio 2003/2005/2010 | PragmaticsWorks

Programming: C#

PROFESSIONAL EXPERIENCE:

SQL DEVELOPER CONSULTANT

Confidential

Responsibilities:

• Designed SSIS packages to transfer large health claim files from various sources to include Flat Files, CSV files and Excel to SQL Server databases.
• Created complex stored procedures/T-SQL code involving complex joins, CTE’s, Merge statements, correlated subqueries, views and functions in performance of integrity and consistency checking.
• Used various SSIS tasks such as Derived Column and Data Conversion for data scrubbing and validation during staging process and used the Conditional Split for loading data into date-specific tables.
• Coded batch processes to download files from secured FTP server using WinSCP and then having the process execute within SSIS packages using PSEXEC.
• Highly proficient in using the SSIS script task (coded in C#) in which I downloaded and renamed Excel files from Sharepoint and then loaded the data into staging tables.

BUSINESS INTELLIGENCE CONSULTANT

Confidential

Responsibilities:

• Interacted with functional business units to analyze, gather and prioritize business and reporting requirements for the Global Product Manager.
• Developed SSIS packages, stored procedures and ad-hoc queries to transfer data from Production OLTP databases to a staging area in which the data was cleansed, validated and reported on to facilitate its migration into third-party Catalog software.
• Improved performance of queries by creating clustered and non clustered indexes on staging tables.

SQL BUSINESS INTELLIGENCE ANALYST

Confidential

Responsibilities:

• Created operational reports by defining the report layout, identifying datasets using Reporting Services in Report Builder.
• Designed and deployed reports using Drill Down, Drill Through and Parameterized functionality in SSRS.
• Used SQL Profiler to determine which stored procedures and parameters executed to create dashboard report to facilitate bug fixes.
• Primary support contact in NY office for reporting and dashboard capabilities.

BUSINESS INTELLIGENCE CONSULTANT

Confidential

Responsibilities:

• Responsible for business analysis and requirements collection for the Sales Analytics Database.
• Authored functional specifications and related documentation to handle ETL processing.
• Designed, developed, configured and optimized complex ETL packages and process flows using SSIS in support of Sales Analytics team.
• Developed detailed test conditions and test cases to ensure quality of queries and reports.

SSIS CONSULTANT

Confidential

Responsibilities:

• Performed analysis, developed and documented multiple interfaces between SQL Server databases (2005/2008) and Oracle 11g database using SSIS and automated the packages using SQL Server Agent.

BUSINESS INTELLIGENCE ANALYST

Confidential

Responsibilities:

• Developed ETL process using SSIS between Enterprise DataWarehouse and Salesforce application using PragmaticWorks’ Task Factory.
• Developed dimensional data model and implemented processes to load dimension and fact tables in support of Loan, Prorata and Budget Cubes.
• Developed numerous reports using Excel (Loan Cube), TM1 (Prorata Cube and Budget vs. Actual Reporting Cube) and SSRS (Rent Roll Report).

APPLICATION DEVELOPER

Confidential

Responsibilities:

• Migrated 50 DTS to SSIS Packages supporting the order processing, confirmation, fulfillment and shipping, mass mailings, eBay processing and gaming functionality for all of Topps client-facing websites.
• Developed Stored Procedures, Triggers and SQL Scripts for use in automated tasks.
• Proficent in constructing C# scripts within SSIS packages and using SQL Server Agent for scheduling.

DOT NET DEVELOPER

Confidential

Responsibilities:

• Designed and coded an ASP.NET CMS System using an Oracle 10g database to house website artifacts.
• Leveraged leading edge tools to communicate with the embedded FLASH front-end (using XML technologies) and third party vendor (using SOAP/Web Services technologies).
• Coded, tested, and deployed the company’s ISO Bidding & Scheduling Tool and Incident Reporting System, both written in ASP.NET utilizing ADO.NET, C#.NET, and SQL Server 2005. Validated users against a custom credentials database.
• Specialized the presentation of navigational controls using role-based authorization.
• Collaborated with a small team to design and code a major browser-based cadet registration system in ASP.NET, AJAX, Data Access Layers, C#, and RAD techniques using an Oracle 10g database.

SOFTWARE ENGINEER

Confidential

Responsibilities:

• Team Lead responsible for the re-engineering of an existing Oracle database to Microsoft SQL Server 2000, which required the team to verify column integrity constraints, identify suitability of column data types, document connection data, prototype DML statements, generate logical and physical models, and create the data dictionary.
• Used BCP utilities to create the MSDE instance and preload data for the client.
• Developed the database api in C# and coded classes that encapsulated ADO.NET calls to the database, which handled database connectivity, query and transactional processing.