SUMMARY:

• A degreed professional with 20 years IT Experience. This includes 12+ year’s hands - on experience in Data Warehouse/Modeling, Business Intelligence Architecture and Implementation.
• 7+ years’ experience in Programming and Software Development.
• Involved with all phases of the development lifecycle; from gathering requirements to testing, implementation, and support.

TECHNICAL SKILLS:

Databases: Microsoft SQL Server, SSAS, MySQL, Oracle, MS Access

ETL Tools: SSIS, SQL Agent, AutoSys, Talend Open Studio (for Big Data)

Programming: SQL/Database and Dimensional Design, OLAP/MDX, Java, C#/.Net, ASP.NET, Visual Basic/VBA, XML/JSON, PHP, JavaScript

Software and Reporting: Git, Visual Studio, SSRS, ERWIN, Tableau Desktop, Cognos, Business Objects, Excel Macro programming, Microstrategy

Cloud Software: AWS: S3, EC2, Redshift

PROFESSIONAL EXPERIENCE:

Confidential, Jersey City, NJ

Data Architect/Technical Lead

• Managed the technical team which developed a Self-Service Reporting Business Intelligence platform. Legacy Trading and GL Reconciliation reports were converted to SSAS OLAP Cubes, enabling quicker and flexible self-service reports.
• Architected star-schema data models and dimensional data marts for loading and reconciling Trading and General Ledger data, including Oracle and SAP.
• Implemented SSIS ETL design and established best-practices for improving the scalability and reliability of current applications while adhering to enterprise standards.
• Worked on POC using MPP ParaAccel/Actian Matrix, Redshift and S3 for querying and storing Big Data.
• Migrated key legacy Reports to support Funding Value Adjustments leading to better valuation of Credit Risk and meeting regulation requirements.
• Developed new cubes that will lead to new and improved Trending analytics, enabling identification of new trends and metrics to measure and improve the reconciliation process.

Confidential, NY, NY

ETL Architect/Consultant

• Designed and implemented Data Warehouse models to enable flexible financial-planning and forecasting.
• Lead architecture sessions with US and Off-shore teams to design and implement robust and best-practice solutions for ETL audit, load balance and exception handling.
• Worked with Business stakeholders to develop and enhance applications for integrating Investran© (Sungard) into the financial reporting data warehouse.
• Developed multiple SSIS packages to integrate with Microsoft MDM (Master Data) and SSAS to enable dynamic financial-planning and budgeting models and hierarchies. (e.g. GL Account parent-child roll-ups).

Confidential, NY, NY

Senior Data Warehouse/Business Intelligence Architect

• Gathered business requirements and developed architecture and specs for integrating new data into expanded insurance data model.
• Technical Architect/Project Lead - Oversaw technical consultants and managed project delivery timelines.
• Helped integrate 10+ systems into existing data warehouse comprising of 1TB+ of data.
• Collaborated with multiple departments to develop Business Intelligence strategies to measure and manage risk for insurance policies and new products.
• Implemented OLAP cubes and custom MDX reports with Microsoft Reporting Services and Analysis Services (SSRS and SSAS).
• Implemented ETL processes using SSIS, SQL stored procedures, and C# for integrating policy-premium and claims data.
• Optimized load performance and capacity planning of various data transformation processes related to various reports and data feeds.
• Maintained and supported SQL Agent batch jobs, SSIS packages, and provided Production support and code reviews.

Confidential, NY, NY

Database Reporting Specialist

• Imported Sales/Employee data from Oracle and Informix into SSAS OLAP cubes enabling competitive analytics and forecasting.
• Architected data models, SSRS and Cognos reports for forecasting and optimizing Sales Resources.
• Developed Intranet-based client in C# / ASP.NET for querying and presenting data-mining results.
• Added custom server-side MDX calculations for SSAS cubes.
• Partitioned tables and cubes to maximize parallel processing and query performance.

Confidential, NY, NY

Data Warehouse Consultant / IT Manager

• Technical Lead - oversaw development of company-wide Data Repository used for Sales Analysis and Marketing.
• Managed IT vendor relationships and served as a liason to business.
• Developed Cognos PowerPlay cubes for OLAP analysis, and ReportNet Meta-Model and reports for detailed reporting.
• Integrated MS Analysis Services for reporting from custom cubes.
• Used SQL Profiler to determine and optimize database indexes and queries.
• Maintained and enhanced C# .Net - based ASP.NET Intranet application for updating product category and account information.

Confidential, Valley Stream, NY

Senior Developer/Analyst

• Responsible for development and maintenance of title report and closing systems.
• Developed procedures for exporting data to MAS 500 accounting system.
• Created web-service enabling company-wide PDF Conversion of documents saving company expense of purchasing multiple Acrobat licenses. Utilized C# and .Net framework technologies.

Confidential, Harbor Side, NJ

Intranet Programmer/Analyst

• Created mission-critical (24/7) NT Services for backend integration to RightFax, FileNet Image Repository and SQL Server.
• Optimized access to SQL Server through use of Index and Query Analysis tools, and further normalization of large tables.
• Improved interface, efficiency and flexibility of Intranet and Client/Server applications.
• Automated receipt and processing of faxes and instituted controls for audit and research purposes.
• Successfully completed Disaster Recovery procedures and testing for servers affected by 9/11.

Confidential, New York, NY

Programmer/Analyst

• Developed and maintained on-line order entry system (OLOES) using Visual Basic and MS Access.
• Responsible for maintaining, troubleshooting and improving Windows based global estimate entry software (RIALTO).