SUMMARY

• Data architect providing organizations in different verticals strategic data direction, while considering tactical solutions with transactional databases and data warehouse/business intelligence solutions.
• This includes, but is not limited to cloud and distributed solutions, security considerations (Regulatory,
• PII/SPII/PHI/PCI, in transit vs at rest), driving consensus towards high level entity definitions with consideration of business rules and process models, and data and
• ETL mapping/modeling (Conceptual/Logical/Physical/Dimensional, Inmon/Kimball/ Linstedt) and overall data governance/master data management.

TECHNOLOGY SKILLS

Programming in the following languages: TSQL, SQL Server 2008, 2012 and 2014, SSIS, SSRS, SSAS (MDX and DMX), PLSQL, VB 6 and .Net, ASP.Net, Salesforce/DBAMP, Talend, Tableau, Amazon Redshift, Azure, Hadoop (Hortonworks) and other software set - up and usage.

Data and process Modeling utilizing: ER/Studio, ERWIN, Sparx (EA - Enterprise architect) and Visio

PROFESSIONAL EXPERIENCE

Data Architect/Modeler

Confidential, NY

Responsibilities:

• Reverse engineering and documentation of a health care network data warehouse due to key personnel loss in the organization, which consists of SQL databases, an array of flat files and other data sources, Talend ETL, SSAS, Tableau and SSRS.
• Document as many shortcomings/areas of improvement.
• Create visuals (data models) and documents of the varied components, as well as data movement/transforms. The models were system driven at a high level, and data driven at lower levels.
• Full source to destination modeling - at a table level at minimum, field level for pertinent fields
• Provide counsel and direction for data privacy - as this is a healthcare client - HIPPA, PII, PHI and SPII all need consideration.
• Provide counsel and direction for "moving the platform forward." This include(s/d) documents, data maps, software recommendations, security, etc

BI Architect/Team Lead

Confidential, PA

Responsibilities:

• Architecture of Datawarehouse/Datamarts for global dashboard/KPIs in paper manufacturing including measures such as production plan vs actual, machine downtime, quality and waste
• Led team of 8 offshore/onshore developers, with hands on development, direction and code review on Azure, ADF/SSIS and PowerBI Premium
• Reverse engineering and documentation of various current localized solutions for consideration in new BI system

Confidential

Responsibilities:

• Led team of 6 offshore developers, with hands on development and code review within BODS, SSIS and PowerBI Pro
• Architecture of POC EDW/BI solution from disparate source systems relating to global customer, sales order and delivery entities.
• Gathering and analyzing customer requirements/source systems including SAP R/3, Syteline and Innatrack
• Development and communication for validation with the business units Conceptual and Logical data model
• Technical and data governance assistance with hierarchal model for Item entity, considering OTC, human pharma, vet pharma and pet products for usage in Oracle PDH
• Compilation of documents including a strategic outline for data cleansing, EDW extensibility to include other entities, system integration mapping and guidance towards self service BI
• Design and development of “first run” director/C level performance dashboards and KPIs

Data Architect/Sr Database Developer

Confidential, Pittsburgh, PA

Responsibilities:

• Mapping/modeling of current Physical transactional database designs and Logical
• Data Flows in preparation for build of new transactional database and datawarehouse in Microsoft SQL Server/Azure and Oracle environments
• Guidance on data design for expanding into new lines of business
• Creation of several UML diagrams documenting current business process for streamlining
• Development of ERD’s to model entities at the conceptual level
• Establishment of documented database development and design standards including Schema definitions, syntactical documentation of code, and object naming principles.
• Technical guidance on tactical vs strategic paths for future development in using Agile methodologies
• Start of Master Data implementation process including key definitions and entities
• Modification of several SSIS packages and other SQL server code sets (views/stored procedures) that were not working as needed in current environment
• Modification of reports/dashboards utilizing SSRS and Power BI

Data Architect/BI Developer

Confidential

Data Architecture

• Development of Conceptual and Logical Data Models utilizing Microsoft Visio and Embarcadero - ER/Studio 10/11
• Design of application systems map showing dataflows between applications, with documentation and dictionary for each connected system at conceptual and logical levels
• Mapping/modeling of current Physical and Logical Data Flows in preparation for implementation of SalesForce
• Data profiling to provide strategies and guidance for targeted data cleansing.
• Mapping/modeling of several full current physical data flows from source systems to reports to record business rules and transforms to initiate and implement new physical model and datawarehouse structure/schema.
• Development of and presentation/participation in several workshops/training sessions for companywide major master data initiatives including Customer Master, Customer 360, Organization Master, Distribution Channel (Event Master)
• Establishment of a master data dictionary and ancillary dictionaries
• Creation of initial routines to cleanse/merge customer master data
• Technical guidance on establishment of data lake on Amazon AWS

Senior Data Architect/Team Lead

Confidential, Winston-Salem, NC

Responsibilities:

• Schedule and usage oversight, to prioritize highest profile pain points, and “biggest bang for the buck” efforts, as well as post deployment analysis of annualized man-hour savings.
• Coordination with client staff, and assignment of business analyst s as needed.
• Review and modifications of solution development maps and current/prospective process models prior to development.
• Code review and modification prior to deployment.
• Usage of Informatica Power center tools including MDM tools for data management and IDQ for data quality and business rules, as well as Informatica Analyst and Developer
• Final documentation review with a mindset towards overall future data architecture.
• Development of SSIS (ETL) packages to import, cleanse and modify data from varied sources.
• Weekly status reporting on initiative to client representatives with presentations on targeted solutions
• Development of POC solutions utilizing PowerBI, Tableau and Amazon AWS

Data Architect/Senior Developer

Confidential, NY

Responsibilities:

• Development of Complex T-SQL queries, stored procedures triggers, and SSIS packages to implement complex business needs.
• Development of jobs on Talend (ETL) to import, cleanse and modify data from varied sources to Amazon Redshift.
• Data pulls in response to client needs for marketing campaign purposes involving complex SQL statements.
• Converted/moved data from a variety of source systems to Amazon S3 bucket, for load to Amazon (AWS)/Redshift
• Development of Tableau dashboards

Senior Data Architect

Confidential

Responsibilities:

• Team leader coordinating efforts of 2 Business Analysts
• Interpretation of Federal Regulations and guidance notices regarding reporting requirements for new and “substantially equivalent” products for R&D department.
• Analysis of 100+ current process documents for discovery purposes - data/systems, reports, personnel/roles across several departments and legal staff.
• Reverse engineering and modeling of current data and reports(SSRS and Business Objects), which included database DDL’s, ETL flows (SSIS, XML, ADO and stored procedures) and current reporting for production system (Simatic IT Interspec - Oracle), Lab systems (LWLims) and Manufacturing system (Simatic IT-Oracle) with several stages between source and final destination (SQL Server 2008r2 EDW) utilizing EA Sparx Systems tools and SQL Server 2008r2/SQL Server 2014 data tools.
• SQL Stored procedure, SSIS, SSAS and SSRS code review and mapping
• Design of application systems map showing dataflows between applications to current reports, with documentation from source to destination, as well as transforms for each field on all current reports.
• System and report discovery for non standard (Excel, screen scraping) reports via interviews of report producers based on analysis of process documents and senior leader recommendations.
• Created glossaries and metadata map for existing databases, systems and processes involving reportable systems and data.
• Development of data ownership, governance and management map surrounding current and prospective FDA reportable data.
• Assistance in developing and analyzing surveys and data collected from surveys from over 300 employees at various levels and in various departments.
• Involved in building high level future state roadmap for systems, data, processes and change management related to federal reporting requirements which has includes revised data flow maps, data diagrams, multi purpose stored procedures and reporting processes for a highly flexible yet less complicated architecture which will be responsive to changes in FDA reporting requirements.

Data Architect/Senior Developer

Confidential, NY

Responsibilities:

• Design of application systems map showing dataflows between applications, with backing documentation for each connected system.
• Internal database discovery, mapping and archiving SQL server databases, as well as moving databases between servers during server consolidations and upgrades.
• Created data dictionaries for all existing and new databases
• Implemented, maintained and responded to SQL job failure notification with post mortem reporting.
• Created system wide job/task timing map creation, and realignment to allow for smoother system function and performance tuning.
• Coordinate with third party application vendors and technical staff for modifications needed by business, modification of internal systems as needed due to implementation of changes and documentation surrounding modifications and impact.
• Modification/redesign of several internal ASP.net and VB.net applications as business need, reporting, or third party application requirements dictated.
• Position documents on various vendor solutions for datawarehousing and business intelligence.
• Provided technical leadership, expertise in data mapping, OLTP and OLAP database design, business intelligence tools and usage.
• Business analysis and requirement gathering from business users for new functionality/reporting, design and delivery of new functionality/reports, and technical documentation.
• Installation, implementation and customization of DBAMP to draw data from Salesforce instance to SQL Server 2008r2 for reporting and data analysis needs.
• Conversion and migration of data from various sources to Salesforce
• Development of Complex T-SQL queries, stored procedures triggers, and SSIS packages to implement complex business needs.
• Development of user audit reporting database for IT and departmental usage on termination of employees/contractors.
• Design of Excel based finance reports including ODBC connections to various databases, VBA code for automation and custom functions required by business.
• Design and implementation of an Enterprise Data Warehouse (Star schema) on Amazon Redshift/SQL Server, utilizing SSIS and Informatica ETL tools to import data from an array of sources, further utilizing PowerBI and Tableau for reporting/charting.

Senior Developer/Database architect

Confidential, NY

Responsibilities:

• Analysis of pre-existing data from disparate databases for commonalities in an effort to re-architect data structures
• Analysis of all ETL processes used in bring data into the databases from a variety of sources/data types, as well as those processes in use to export data from existing databases to external sources
• Development of jobs on Talend (ETL) and SSIS to import, cleanse and modify data from varied sources.
• Designed new transactional databases, while maintaining existing ones and design/development of new datawarehouse
• Optimized and enhanced performance of stored procedures, reconfigured index structure for Web and transactional DB’s
• Modified existing data warehouse and created new SSIS packages for data feeds
• Created ERD diagrams for new data bases
• Created data dictionaries for all existing and new databases
• Compiled a guide lines documentation for naming object, procedures, functions, tables and fields
• Established basic security and code promotion rules for production, QA and development environments.
• Development of POC dashboard solutions utilizing Tableau, Qlilkview and PowerBI as comparative solutions

Senior Developer/BI architect

Confidential, NY

Responsibilities:

• Designed Enterprise Data warehouse Architecture and assisted in development of the conceptual and physical Data Models utilizing Erwin
• Provided strategies and the Data Warehousing Best Practices based on Inmon methodology
• Worked within business line to gather the needs and translated them into a Data Warehouse solution
• Assisted in analysis of multiple client source systems and current reporting structures including Microsoft AX2009 and BlueCherry to determine full extent of data to be subject to BI.
• Reviewed the ETL code and tuned mappings and workflows for better performance.
• Development of jobs on Talend (ETL) and SSIS to import, cleanse and modify data from varied sources.
• Reviewed sample SSAS cubes for data tuning
• Onsite team leader of 4 consultants and 4 offshore developers, which included weekly client facing status meetings, and coordination of team activities.
• Mentored junior team members, and client team members on technical knowledge regarding SSIS, SSAS, Business Intelligence and data warehousing concepts

Sr. Data Architect

Confidential - Montvale, NJ

Responsibilities:

• Analysis of an existing client facing internet application with a SQL Server 2008r2 backend and .net frontend, developed for the manufacturing vertical to enable them to manage their supply chain.
• Then analysis was geared towards architecting a datawarehouse/reporting solution that would be more useful for the clients, as well as scaling of the transactional database for future expected growth.
• The application is currently used by 10+ manufacturers, and over 2,000 suppliers worldwide who supply data on a periodic basis
• Analysis of design of model datawarehouse developed by internal staff, and sample SSAS cubes built to provide business intelligence.
• This analysis was geared towards documentation and recommendations for the datawarehouse structure.
• Development of a 2 stage ETL process utilizing SSIS to move data from the transactional to the datawarehouse.
• Technical assistance in development of cubes utilizing SSAS for usage in the new reporting system being developed.
• Development of several prototype pages for differing reporting techniques using parameterized SSRS, customized Confidential pivot components and ASP/VB/datagrid designs.
• Development of prototype dashboard for comparative analysis utilizing Microstrategy

Manager Consulting Services

Confidential

Responsibilities:

• Design and development of a intranet/excel based Pivot Table and reporting solution utilizing ASP.Net,
• SQL Server and MSBIDS, SSIS, SSAS, Office Web Components (OWC) for pivots and charts/graphs and internally generated XML.
• Customization and parameterization of OWC components as requested by client
• Debug and tuning of varied cubes and MDX queries in SSAS where result set was inaccurate or was in need of format reconstruction.
• Development of various excel 2010 workbooks for traders and back office utilizing VBA extensively
• Reverse engineering and documentation of an application developed utilizing SQL Server 2008, SSIS, SSRS and ASP.net/VB.net
• Design and architecture of a new database structure transforming relevant data from existing schema for a more robust end user reporting experience.
• Development of ETL packages utilizing SSIS packages and Siemens Invision 27 to build the structure for a SQL server datawarehouse, and SSRS for aggregated financials and other reporting needs.
• Reverse engineer and documentation of financial models and ETL processes in Bankware and replicating process for audit and control purposes in MS Access2010, SQL Server and SSIS.
• Architecture and Development of various MS Access/SQL Server database solutions for client demonstrations utilizing differing versions (2007/2010) of
• Access as needed with custom SQL and VBA code based on client specifications.
• Demonstrations for C-Level employees of above mentioned applications.
• Redevelopment of SQL Stored Procedure code for use in internally developed application upgrades.
• Development of MS Access databases with SQL server backends for several client projects.
• Testing/analysis of SQL server databases for tuning purposes and correcting bottlenecks/locks. Focuses on index tuning, query modifications, transactional replication, partitioning and hardware optimization.
• Various white papers utilized for client pitches on a variety of topics including migrations between SQL Server versions; tuning SQL stored procedures, views, ETL and cubes for performance.
• Designed and developed several Hadoop and Cassandra POC databases for usage by Confidential as material on client sites. This included layout, design, data movement and query capability utilizing Hive and Shark.
• Development within Investran and Bancware environments

SQL Server Architect/BI Consultant

Confidential, NY

Responsibilities:

• Development of SSIS (ETL) packages to import, cleanse and modify data from varied sources.
• Development of base reporting structure utilizing SSRS.
• Training of staff on usage of SSIS and SSRS (MS SQL Server BI Tools) for continuation of module development by internal resources.

Sr. Technical Database Consultant

Confidential

Responsibilities:

• Financial database redesign and redevelopment to conform to standard IT practices and procedures utilizing SQL server 2005 creating a robust database structure
• Development and redesign of SSIS packages manipulation of data from over 60 source files being imported on a monthly basis for use in a financial reporting application
• Documented current workflow and procedures implementing changes to the workflow to increase the speed of reporting production while decreasing manhours in the process
• Assistance with setup and design of a 3 tier database modification path (DEV, QA and Prod) from a single point of failure mode.
• Assistance in modification of several VBA driven Excel/Access Finance applications used in post Bankruptcy accounting process
• Environment: MS Access and Excel 2007, SQL Server 2005, TSQL, SSIS, VBA

Sr. Technical Database Consultant

Confidential

Responsibilities:

• Database architecture and development for sales, renewals and cancellations utilizing MS Access, SQL Server and salesforce.com
• Datascrubbing of existing data from varied sources
• Development of varied SSIS packages, and VBA within Excel and Access to manipulate data for reporting purposes and distribution of reports.
• Front end interface developed utilizing MS Access for data overrides, data imports and FX rate change inputs as well as report generation.

Sr. Technical Consultant

Confidential

Responsibilities:

• Redevelopment and Automation of Financial Reporting system utilizing Excel, Access, SQL Server, Oracle
• Development of Stored Procedures and SSIS packages on SQL server 2005/2008 for ETL of data pertaining to financial reporting system
• VBA development within Excel and Access to Automate Financial reporting and distribution process.

Sr. Technical Consultant

Confidential

Responsibilities:

• Redevelopment of existing MS Access Database to be utilized in multiple offices for HR purposes.
• Development of reporting system utilizing MS Access, Excel and VBA
• Documentation on migration of Client to Access 2007 and Back-end to SQL Server
• Coding and recoding of assorted TSQL and VBA code as needed.
• Development of SSIS packages for ETL within various SQL Server databases.
• Training of 3 employees on Access 2000, 2007 and SQL functionality

Sr. Consultant/Data Architect

Confidential

Responsibilities:

• Development and tuning of various databases and processes on the SQL Server 2000, 2005 and 2008 platforms including Stored Procedure tuning, SSIS and SSRS tuning.
• Focuses on index tuning, query modifications, transactional replication, partitioning and hardware optimization.
• Technical assistance in development of OLAP Databases and SSAS/MDX Queries for BI purposes.
• Database administration for databases up to 2 terabytes including T-SQL coding, stored procedures, backup/recovery, high availability.
• Technical assistance in development of high availability SQL Server solutions, including Log shipping, Replication and SQL Server clustering
• Technical assistance in developing datawarehouses for using in BI operations
• Use of various internal, Microsoft and third party tools such as PSSDiag, Cleartrace, PAL, RML Utilities, SQLDIAG.
• Technical assistance in migration of several databases from SQL 2005 to SQL 2008.
• Technical assistance in tuning various Oracle 9i and 10g databases.
• Redevelopment of VB.Net modules and ASP.Net pages for speed and scalability.
• Development of several modules for MS Access 2003 Databases with SQL 2000/2005 Backend.
• Development of varied automated procedures utilizing MS Excel and VBA..