OBJECTIVE

• To leverage over 15 years of IT experience in Data Architect wif remarkable software analysis, Application, Database, Data warehouse, Business Intelligence and Web app designs and developments space.
• I bring wif me exceptional skill in finding and bringing about result oriented solutions.
• I have architected and lead managed many successful Data warehouse projects, and Business Intelligence development including Data migration, and ETL processes to support enterprise reporting systems.
• I have exceptional and TEMPeffective leadership abilities to mentor junior developers and raise team moral to achieving and for most times exceeding team’s stated mission.
• I is a people’s person and leader who work collaboratively wif other teams to realize corporate IT goals, all teh while employing best practices and methodologies.
• I have excellent writing and verbal communication skills.

SUMMARY

• Database, Data warehouse, BI Architect, Data Modeling, design and implementations, including supports for all phases of SDLC.
• AWS Redshift cloud and Azure architecture and integration wif on premise systems.
• Experienced Business Intelligence developer and Architect specializing mainly in, but not limited to Microsoft Technologies such as SQL Server 2014, 2012, 2008, 2005 suites including SSRS, SSDT, SSIS, and SSMS stack.
• Led and directed teh design and successful deployments of many corporate Business Intelligence applications including Enterprise Data Warehouse, Analysis Services, and Reporting Services wif outstanding results.
• Data warehousing design and management including Master Data Management.
• Defined and managed Data staging environment and ETL designs and enhancements.
• SQL 2005 Reporting services, Analysis services and Integration services development.
• Data modeling and Database Performance Tuning.
• Advance Microsoft SQL 2008 programming wif DMO, DDL, DML, ETL and DTS including using ActiveX.
• Microsoft .Net framework 3.0 to 4.5 technologies.
• Front - end tools such as ASP.NET, ADO.NET, ASP.NET MVC, Razor, Entity Framework / EF Code First, LINQ.
• Microsoft Access, Oracle 8, 9i, 10g, 11 - PL/SQL, Oracle work bench and export tools.
• Service broker programming for asynchronous processing.
• Visual Basic. NET, C#. NET and Visual C++. NET, ADO.NET, ASP.net.
• Object-Oriented programming using C++, C# and Visual Basic.
• Postgres DB, Vertica DB, MySQL, Graphic database design - Neo4J.
• Visual Basic Database programming and OLE-Automation reports and Seagate Crystal Report Designer 9.
• Pentaho BI Solutions, Mondrian Saiku-Server.
• Open source development tool - Python and BASH/Script programming.
• Expert VBA programming wif Excel, Power BI, Word and Outlook.
• Excellent communication and interpersonal skills wif extensive client interaction.

TECHNICAL SKILLS

RDBMS: Microsoft SQL Server (2014, 2012, 2008), Oracle (9 - 11), PostgreSQL, MySQL, Vertica DB

NoSQL: MongoDB, JSON Notation, XML

GraphDB: Neo4J

Microsoft: Visual Studio.net 2015 (C++, C#, VB.net), ASP.Net (MVC), ADO.NET

Cloud: Azure, AWS (S3, ES2, Redshift), Firebase

Other: Python, PySpark, Java, Shell scripting, LinuxBusiness Intelligence

Microsoft: SSAS (Analysis Services) and SSRS (Reporting Services), SSIS (Integration Services), SSDT (SQL Server Data Tools). Power BI

Other: Pentaho BI solutions, Saiku BI Sever, Hadoop, Crystal Reports, Tableau, OLAP, SAS

Microsoft: ASP.NET, VBScript, MS Access, 8.5, Excel

Other: Web Services, HTML5, CSS, Angular4, Bootstrap

Data Modelling: Visio, Embarcadero, Erwin, MySQL

Version Control: Microsoft Team Foundation (TFS), GitHub

Others: Containers, Docker, and Kubernettes

PROFESSIONAL EXPERIENCE

Confidential, Purchase, NY

Senior Enterprise BI Architect/Lead

Responsibilities:

• TEMPPrincipal architect for teh re-architecture of crew personal communication devices (PCD). dis redesign architecture improved teh delivery of information for teh system to teh devices wif less TEMPthan 10 minutes latency from 4 hours. - using Google Cloud and Apple Push notification services as conduit to push data to devices.
• Design enhancements to many existing database processes for better performance enhancement.
• Introduced new methodologies tailored to better fit business architecture, goals and vision through making teh existing architecture more current.
• TEMPPrincipal architect for teh redesign efforts in addressing database performance and ETL process issues.
• Liaison between users and teh database management team and other application development/integration teams.
• Research data performance issues and provide mitigation solutions
• Performed detail and impact analysis on upgrading EDW server from SQL 2005 to SQL 2014 including teh migration of SSIS packages and SSAS cubes Stored procedures, UDFs and UDTs.
• Communicate teh data requirements of any future infrastructure needs, working wif teh IT architects to develop an approach dat fits teh current and planned needs of teh Atlas.
• Architected successfully, more TEMPthan 4 mission critical enterprise applications during teh course of my first 18 months at teh job.
• Used Google firebase to promptly alert and update crew of critical schedule changes including hotel and mandatory rest requirements and training schedules wif asynchronous acnoledgment process.
• Used Azure cloud services and .net to design application dat allows real time ground operations data via a rest API to client and data warehouse.

Environment: SQL 2012, 2014( SSIS, SSRS, SSAS), Oracle 11, Excel, Firebase, Azure, Power BI, Access, Microsoft Team Foundation, ASP.net, Hadoop, Python, Visual Studio .NET 2013, Cognos 10.2, IBM WebSphere, Java, Angular4, Tableau

Confidential, Brooklyn, NY

Senior Enterprise BI/Data Architect

Responsibilities:

• TEMPPrincipal Data Architect for database designs for DCPS IMPACT project from CDM through LDM, PDM and implementation using Embracado Data Architect tool.
• Reverse engineered other enterprise database platforms for architectural understandings and to learn various systems, identifying opportunities to drive performance and scalability.
• Managed and resolve production database issues including teh implementation of maintenance plan to mitigate flash issues.
• TEMPPrincipal architect to Multi-Source ETL process including SSDT (SSIS), SSAS and open source tools (Python, shell scripting, Pentaho Data Integration etc.)
• Played a key role in integrating all cloud solutions and strategies into teh Analytics Reporting System (ARS) platform using AWS Redshift and EC3 cloud computing infrastructure.
• Coordinates wif other teams for common design approaches and uniform standards to shared platforms for teh usage of enterprise resources.
• Led one of teh most successful enhancements to a bugged down (SSIS) ETL process reducing performance processing time from 15hrs to 3hrs.
• Provided enhancement and optimization wif ETL process development and maintenance.
• Designed and developed Analysis Services (SSAS) OLAP Cubes for various reports and data mining analysis.
• Designed and supported teh development of standard and ad-hoc BI reports and reporting modules using SQL Server Reporting Services (SSRS)
• Designed and developed various operationalDrill-throughandDrill-downreports usingSSAS and SSRS
• Design dash-board reports wifSub Reports,Charts,Matrix reports and Linked reports.
• Provided support to report performance issues byQuery Optimization.
• Designed predictive database using Neo4j graphic database.
• Led teh effort to designing a new and improved Data Warehouse for EDWare BI project.
• Member of teh database release advisory team.

Environment: SQL 2012 ( SSIS, SSRS, SSAS), Postgres, Oracle 10, Neo4J, Excel, Access, MongoDB, AWS (Redshift, S3, ES2) Memcached, IBM VerticaDB, PHP, Linux, Splunk, Git, Cygwin, ASP.net, Visual Studio .NET 2010, Java, Typescript, Angular2, Pentaho, Hadoop, Python, Power BI.

Confidential, Manhattan, NY

Senior Microsoft SQL Server BI Architect / Developer

Responsibilities:

• Managed teh development of multi-platform ETL process for teh automated Quality Management Reconciliation System (MRS).
• Analysed data from various enterprise source systems to understand teh structure and context of teh data, and how it fits into teh Enterprise Data Warehouse. Identify potential source system data issues and/or gaps.
• Developed and deployed SSIS packages for extracting and analysing data from multiple data sources, including flat file, Mainframe, DB2, SQL, Teradata servers and other data source.
• Designed and developed robust automated QA system for validating converted data.
• Provided both leadership, mentoring and technical expertise to junior developers and facilitated an atmosphere of can-do attitude among teh team and teh teams we supported.
• TEMPPrincipal supervisor of automating scripts including developing and publishing teh standards, performance tuning and ensuring consistency in reporting.
• Collaborating extensively wif peers and internal users from various business units to understand business processes, requirements and expected wish lists. Worked wif development team leaders to establish and map-out phased strategies and approximate timelines for completion of various milestones of development requirements wif defined metrics to evaluate teh success and failures of each phase.
• Defined and managed teh Data staging environment including working tables and ETL SSIS packages wif performance optimization through coding and database designs including teh analyses and selection of teh most TEMPeffective indexes to use.
• Member of teh cloud engineering team responsible for teh design and integration of Azure based cloud computing and support.
• Designed, developed and deployed Analytic and QA databases to Azure cloud platform wif an automated ETL loader for teh predictive group.
• Re-engineered a unified application process capable of processing all files received from differing, vendors and clients by standardizing teh send and received file layout and implementing unified business rules using stored procedures, functions and triggers.
• Monitored teh data consistency of automation scripts and data in staging database including version control.
• Imported and Exported data files to and from SAS using Proc Import and Proc Export from Excel and various delimited text based data files such as .TXT (tab delimited) and .CSV (comma delimited) files into SAS datasets for analysis.
• Used statistical analysis procedures in teh generation of reports periodically for analysing teh business using SAS STAT procedures such as Regression Univariate, Correlation.
• In Data Transformation and Manipulation process, extensively used procedures like SQL, Transpose, Tabulate, Copy, Sort, Datasets etc.
• Extracted, manipulated data, and created Data Sets from various sources like Excel, flat files, Oracle database, Access database using PROC IMPORT techniques and SQL pass through facilities.
• Administered database management and trained current DBA and Data processors.
• Created and generated enterprise QA reports using Microsoft reporting tools wif drill-down and drill-up capabilities and report subscription dat publishes reports to users at specific times.
• Partially managed teh Recon database server (SQL 2008.)

Environment: SQL 2008 (SSIS, SSRS, SSAS), MongoDB, Postgres, Oracle 10, Excel, Access, Azure cloud database, MongoDB, Linux, ASP.net, Visual Studio .NET 2010, Java, Hadoop, Python, Teradata, Power BI.

Confidential, Jersey City, NJ

Technical lead (Reporting Team) Risk Management

Responsibilities:

• Technical lead designer/architect wif teh ERP team tasked to design, develop and deploy Microsoft Reporting Services and Microsoft Analysis Services on teh 2008 platform for enterprise Data warehouse reconciliation system for teh Credit Risk Management group.
• Migrated reports from SQL2005 to SQL2008 including teh re-writing of RDLs using Multi-Dimensional Expression (MDX) queries. Created BI data mart and data mining cubes.
• Designed multiple SSIS packages to validate and load data files from different source feeds.
• Automated stored procedures through SSIS packages to generate ad-hoc reports for QA and business units including teh investigation team.
• Designed and deployed reconciliation reports between feeds from differing sources on SSRS.
• Successfully helped teh redevelopments and deployments of some long running SSIS packages for performance optimization.
• Designed reporting analysis cubes for teh EDW using SSAS.
• Provided documentations for teh design, and deployments for objects created and released to QA and UAT including technical processes and object migrations.

Confidential, White Plains, NY

Senior Microsoft SQL Server BI Architect / Developer

Responsibilities:

• In teh capacity of a Data Warehouse Architect, I architected, designed and managed teh development of teh company’s Data Warehouse infrastructure, using Microsoft’s BI technologies.
• Provided both leadership and technical expertise to building a robust, flexible and extensible foundation dat met 99.99% of teh design goals.
• Led teh team of designers, DBAs and developers to design a Master Data Management (MDM) system and teh strategies for change management while employing some of teh best practices in design patterns and methodology.
• Defined and managed teh Data staging environment including working tables and ETL SSIS packages wif performance optimization through coding and database designs including teh selection of teh most TEMPeffective indexes.
• Defined Data warehouse dimension tables including SCD ETL strategies.
• Designed, wrote teh project plan and lead teh project team to migrate teh company’s system from SQL2000 to SQL2005 to platform wif minimal down time.
• Lead teh Migration of database objects and DTS packages to SSIS Project including testing and user acceptance testing.
• Designed and supervised teh daily, weekly and monthly ETL processes for teh data warehouse and data marts databases including time sensitive and real time information extraction from transaction servers using SSIS.
• Managed ongoing maintenance of Microsoft Business Intelligence (SSAS) environment for performance, scalability and addressed issues regarding latency.
• Re-engineered teh existing application processes to efficiently utilize new technologies removing buggy modules and leveraging new programming practices wif astonishing efficiency and TEMPeffectively implementing business rules.
• Re-engineered a unified application process, capable of processing all files received from differing vendors and clients by standardizing teh send and received file layout and implementing unified business rules using stored procedures, functions and triggers.

Environment: SQL 2000, SQL 2005 (DTS, SSIS, SSRS, SSAS), SSRS, Excel, Access, ASP.net, Visual Studio .NET 2005, Visual Studio 2003, Crystal Reports XI, Monarch

Confidential, Long Island City, NY

Senior SQL Server Developer

Responsibilities:

• Senior Database Analyst responsible for leading and managing teh re-engineering of teh Enhancement Leads Management Systems (ELMS) department.
• Translated monthly product managers targeting strategies for marketing by leveraging TEMPeffective database programming, standing risk assessments and in-depth analysis for marketing profitable populations.
• Automated teh Triggers waterfall report process reducing teh usual 2 to 3hrs time normally needed for creating teh report to 10 minutes wif 100% accuracy using Excel formulas, VBA and SQL scripts.
• Led team to design and deploy internal application modules using Oracle PL/SQL procedures, UDFs and packages.
• Built a cross portfolio automated post campaign process application using Access, Oracle SQL, Encompass and VBA.

Confidential, New York, NY

Senior Microsoft BI Architect/Developer

Responsibilities:

• Responsibilities included conducting interviews wif executives, VPs, senior managers, business analysts, and technical staff in capturing and understanding business requirements, and defining project scope.
• Performed detail data analysis of both data elements requested by teh business and data source and documenting data source definition, source-to-target mapping, and logical structures for teh data warehouse/data mart.
• Project manager in designing ETL, Schema, Fact and Dimension tables and teh strategies to maintain teh availability and teh most current information through scheduling of ETL using SQL job scheduler.
• Defined and managed teh Data staging environment including working tables and ETL SSIS packages, including maintaining slowly changing dimensions (SCD).
• Deployed Microsoft reporting services for Business intelligence wif customized reports formats including Excel, Flat file and PDF.
• ETL operations for moving data from OLTP to staging databases and DATA MART.
• Lead a team of 4 developers to design and deploy teh Confidential Analysis (SSAS) and Reporting Services (SSRS).
• SQL optimization relating to using cursors, indexes, temporary tables.
• Conducted complete system studies to identify bottlenecks and suggest improvements wif documentation, unit and integration testing and teh definition of technical standards and requirements.
• Project management including monitoring and reporting of project milestone.
• Developing data warehousing schema and its supporting stored procedures, UDF and Views for reporting services.
• Developing DTS packages and automation of reporting services including Stored Procedures and UDFs.
• Developed trends, aggregates, charts and averages reports through Microsoft reporting services using DTS packages, stored procedures and Visual Basic ActiveX scripts and macros.
• Using Excel VBA to design complex spreadsheet applications for sales trends, cost analysis, data mining and forecasting of future returns on Investments.
• By re-writing existing stored procedure codes and re-packaging local packages, I managed to improve significantly teh efficiency and teh processing speeds of most in-house applications. In some cases, non-performing or crashing procedures/Packages were recoded to eliminate bugs and achieve speeds up to over 1000 times faster TEMPthan teh previous procedures. (Example, a package dat used to take almost 3hrs to complete its task was reduce to 2mins or less)