SUMMARY

• Extensive Data Warehousing experience, including advanced data analytics and Business Intelligence
• Focused Business Intelligence Specialist and Software Developer with close to twenty years of experience in working independently as well as leading and motivating development teams.
• Passionate about creating quality product as well as effective work environment through coordination and collaboration between team members.
• Highly skilled in various databases design and development, business intelligence products and at the same time working with the user community by analyzing the requirements, taking the best route in solving departmental needs, involving not just technical solution but also taking into account costs, team structure and time constraints.
• Understands the importance of documenting every aspect of the project during the development phase and after for ongoing support.
• Excellent analytical and problem - solving skills.
• Hard working, motivated, always keeping myself on the cutting edge of the latest tools available to produce better and more robust solutions for the company.
• Notable certifications/degrees: Microsoft SQL Server certified, Master Degree in Financial Engineering.

TECHNICAL SKILLS

Database: Netezza, SQL Server, Oracle, DashDB, DB2, MySQL, DW, Data Modeling

BI/Reporting: Cognos 8.x, 10.x, Analytics, OBIEE, Cognos FM, D3 Visualizations, SSRS, TM1

Languages: .NET - C#, VB, JavaScript, VBA, PHP, HTML, XML

Transformation Tools: SSIS

Other: AWS, Hadoop/Hive, Google Analytics, Photoshop

PROFESSIONAL EXPERIENCE

Confidential, Park Ridge, NJ

Senior Database Developer

Responsibilities:

• Working on a data warehouse project designed to benefit various departments across organization. Sources include Hana, Peoplesoft, various Oracle and Sql databases.
• Responsibilities include Data modelling, database development and optimization as well as design and deployment of ETL packages.
• Leading efforts to analyze new data sources and modelling target repositories.
• Optimizing ETL performance to provide quickest response and load time possible.
• Creating detailed functional and technical design documents.

Confidential, New York, NY

Senior Business Intelligence Engineer

Responsibilities:

• Worked with the business to gather requirements, create data models based on these requirements and designing BI functionality to meet these needs. The tools created currently are being used throughout the company by different departments. Technology used: Netezza (back end). Cognos 10.x - 11 (front end).
• Developed complex SSIS packages to ingest billions of records daily as well as trained other developers in ETL best practices and data warehouse development.
• Involved in full cycle of Data Warehouse development from requirement gathering to testing, implementation, optimization, and support.
• Designed and developed automated processes for data validation, data corrections, and data inconsistency alerts.
• Architected company-wide digital data ingestion and analysis tools. Sources include TV Everywhere, iTunes, YouTube, Amazon, Cable providers as well as Facebook, Twitter, Apps, internal sites, VOD, Live streaming, Google Analytics, iTunes, Amazon, Xbox.
• Created online BI interface to be used by various departments. The interface is using highly interactive JavaScript based charts and tables. Personally lead the team in implementing brand new to the company technology.
• Researched the use of promos/ads and their effectiveness on targeted shows and audience. Produced various strategies on how to improve the performance of ads in terms of reaching bigger audience and at the same time increasing the revenue by placing ads in more “strategic” spots.
• Data modeling and database design
• Developing Netezza stored procedures as well as performance tuning
• Being involved in full cycle of development: data warehouse projects, reporting systems
• Developing and maintaining ETL processes (SSIS, Netezza, nzload, C# scripts)
• Working closely with BI tools user community. Not only to support existing tools in use but also to understand different departments’ needs which lead to new ways of data analysis to help the business and keep it ahead of a competition.
• Extensively researching new data sources that can potentially bring new revenues to the company.
• Mentoring new team members.

Confidential, New York, NY

Data Architect

Responsibilities:

• Designed and developed key revenue application for Confidential TV Networks Sales Force
• Major role in developing several key business applications.
• Responsible for creation of specifications and implementation for the GUI, the business layers, and the databases.
• Developed Shared Data Repository Application. The goal was to build a multi-phase solution that will help to achieve objective of a three hundred sixty (360) degree view of DATG’s customers and products to drive retention, enrich the customer experience, and create personalized products and service offerings. Technology used for the project included Netezza Database, Oracle Endeca, SSIS, Cognos, and OBIEE. Responsibilities included:
• Review of User Requirements
• Consolidating multiple data sources in a single SDR
• Design and Architectural Review of System
• Universe/Model design to be used in Reporting/BI
• Design and implementation of ETL processes using SSIS, nzload, Python scripts, cURL
• Worked as part of design and development team for Sales Contract Management System, a multi-tiered distributed .NET application, utilizing WinForms as a front end with an XML web service as a middle-tier data transfer layer with an ORACLE backend. This user friendly GUI application was developed using C# 2.0 for the front end. Business tier (Business Logic residing on IIS Server) was developed using C# 2.0. ORACLE database interaction with other systems was handled using PL-SQL packages to handle real-time data transfer with dependent systems. Responsibilities included:
• Review of User Requirements/User Interviews
• Design and Architectural Review of System
• Designed and Developed Key Graphical User Interfaces for the project
• Development of Key Components of System.
• Development of Test Plans
• Implementation of Stress Tests
• Development of Server Side Services
• Development of User Training Materials.
• Developed a system for network producers to request intellectual property to be used in news magazine shows, manage negotiated contracts, and generate multiple reports. Application was written using VB.NET, WinForms, Microsoft Remoting Technology, ASP.NET and SQL Server 2000. Crystal Reports was used for reporting. Responsibilities included:
• Design of all SQL Tables, stored procedures, and triggers
• GUI design and development
• Reports design
• Business layer architecture
• End User Training
• Developed Sports Management System (SMS) that feeds the data used throughout the Sports Financial System. This system is used to track year to year event contract information, projected air dates and sponsor guidelines. As events get approved for air they will be made available to the users of the SFS to create future budget and planning scenarios. SMS was written using VB6 and SQL 6.5 which was later converted to SQL 2005. Responsibilities included:
• Design of all SQL Tables, stored procedures, and triggers
• GUI design
• Universe/Model design to be used in reporting system
• Developed Tickets application for the sports department to help distribute tickets for sports events. Application was written in VB6.0. Application was deployed to COM platform.
• Involved in developing and supporting Sports Financial System (SFS) which was written to track all costs associated with ABC Sporting Events. This system was designed using VB4.0 16 bit and SQL Server 6.5 The system tracks current and future events, scheduling of on air talent payroll and gives detail analyses for year to year planning. Database was converted to SQL 2005.
• Involved in a full cycle of developing Cognos reports/dashboards.
• Involved in Extraction, Transformation, and Loading (ETL) solutions using SQL Server Integration Services (SSIS).