PROFESSIONAL SUMMARY

• Senior Business Intelligence Developer / Data Architect with a passion for new technology and an ability to speak at both a technical level as well as a Business functionality level. Natural leader, very skilled at leading planning sessions, requirements gathering, and implementation of client initiatives.
• Exhibit excellent project management skills, possess the ability to quickly put structure in place to manage work in a dynamic complex environment. Have a passion for coaching and developing a team of associates that is able to share and embrace client vision.
• Have a proven record of achievement in the area of Database Development, Database Architecture, Database Analysis, Database Modeling, and Database Administration.
• Data Warehouse Design, Transactional (OLTP) and Dimensional Modeling (OLAP) Implementation. Experience in designing solutions for Big Data environment both structured and unstructured.
• Extensive experience in Data warehouse design and development using MS DTS, SSIS, IBM DataStage v9.1 and Informatica Powercenter 9.5. Extensive experience in implementing Master Data Management (MDM) strategies, requirements and policies aligned to companies’ goals for data quality, data security and data integration.

TECHNICAL SKILLS

• Microsoft Azure (SQL Azure, CosmosDB, Data Factory, DataLake, ML, U - SQL)
• Microsoft SQL Server and SSAS
• Data Modeling: Conceptual, Logical, Physical using: Erwin, ER-Studio, SQL Developer Data Modeler, Power Designer, TOAD and Visio
• Enterprise Data warehouse design and implementation based on the KIMBALL BUS methology and Microsoft UDM
• Strong ETL Skills, SSIS, Oracle, or Sybase
• Oracle OBIEE Hadoop
• Hyperion Essbase (ASO, BSO), MAXL, Calc Script
• C#, VB, Excel Macro, Power Builder, COBOL, 4GL and Assembly, ASP, ASP.Net, Java Script,
• Agile and Waterfall methodologies
• Project Management
• Functional Expertise
• Business Process Modeling
• Logical and Physical data modeling
• Business Process Re-Engineering
• Budgeting and Forecasting
• Driver Based Modeling
• Rolling Forecasts
• Advanced Analytics Methodologies such
• Descriptive, Predictive, Discovery and Prescriptive

PROFESSIONAL EXPERIENCE

Confidential, Portland, Oregon

Team Lead/Senior Data Architect

Responsibilities:

• As a Data Architect was responsible for designing, creating, deploying and managing data solutions to enable analytics and reporting for Confidential . Was strictly responsible for guiding the strategic direction of the organization through extensive cross functional partnership; identified, evaluated, synthesized and deployed new analytical approaches across Pfizer for customer analytics.
• Responsibilities included defining solution architecture and implementation of projects for the data and analytics platform in a hybrid (on premises & cloud) environment, as well as developing and implementing data architecture standards for the organization which also included interactivity/visualization of complex datasets and the implementation of new approaches for predictive analytics, machine learning and network analysis.
• Developed data solutions, across all phases from conceptualization to optimization. Incorporated emerging technologies like columnar and NoSQL databases, predictive analytics, data visualization, and unstructured data.
• Initiated, evaluated, and implemented projects involving data from numerous sources, Pharmaceutical data, Research data, Clinical Data, departmental repositories, legacy, and external repositories in the client's unified analytics environment.
• Mapped the systems and interfaced used to manage data and set standards for data management.
• Analyzed current architecture and conceived desired future state, and identified projects needed to close the gap between current state and future goals.
• Abled to emphasize methodology, modeling, and governance.
• Scoped client requirements and created solution architecture and design documents.
• Created project plans and project management solutions.
• Worked with the Director of Data Development to prioritize projects.
• Responded to all requests with high standards for customer service, in keeping with Data Analytics & Reporting department standards.
• Adhered to HIPAA and JCAHO compliance standards.
• Performed job functions adhering to service principles with customer service focus on innovation, service excellence and team work to provide the highest quality care and service to our patients, families, co-workers and others.

Confidential, Pittsburgh, PA

Senior BI Solution & Data Architect/Data Modeler/ETL Developerr

Responsibilities:

• Responsible for the design and development of enterprise data marts.
• Lead the planning, requirements gathering, and implementation of a Data Modeling initiative for the client, both structured and unstructured data.
• Designed, developed, and managed project plans in a complex dynamic environment.
• Responsible for developing business intelligence solutions using the Tableau Suite of products from Tableau Desktop to Tableau Server.
• Designed New SSAS and Tableau Cubes.
• Worked with team members and business leaders to identify opportunities to turn data analytics into insights, for intelligent decision-making.
• Designed, maintained and managed Tableau driven dashboards
• Managed Tableau Report Performance Optimization
• Participated in definition, development, and implementation of data warehouse and data mart databases
• Implemented and supported ETL processes and practices using SSIS in a high availability data warehousing and data mart environments.
• Planned and coordinated ETL and database changes with project team members, development, and database engineers
• Designed, developed, tested, optimized, and deployed SSIS / ETL solutions which consisted of batch load packages, workflow processes, stored procedures, related functions and various scripting tasks
• Worked with the Infrastructure team to help develop and uphold data governance policies and procedures to ensure standardized data naming, establish consistent data definitions and monitor overall data quality for assigned data entities
• Developed and supported creation and management of KPIs Dashboards
• Gathered and documented business requirements for new sources of data and data warehouse enhancements.
• Translated requirements, source mapping documents, and models into solutions. Responsible for applying Master Data Services, Data Quality (MDS, DTQ) strategies, requirements and policies aligned to the company’s goals for data quality, data security and data integration.
• Tuning and redesign the Financial Data Warehouse to support planning (Operation), Labor (Warehouse, Non-warehouse, Overhead) Planning, Income statement and balance sheet Planning.
• Implement the Security for Essbase Hyperion Planning and Hyperion Reports.
• Production Support and problem solving Financial Monthly End Closing using Essbase as the BI tool and SQL/Server as Data Warehouse to store Trial Balance and Transaction Details.
• Create Interface for Work Day (New HR System) and Book Service in Data Warehouse with SQL Server Scripts, Essbase dataexport and MAXL.

Operating Systems and Tools: Windows Server 2014. Database Servers: MS/SQLServer 2014 Enterprise Edition, SQL Server Data Tools for Visual Studio 2013. SSAS Analysis Services Enterprise Edition, SSIS. Tableau, PeopleSoft, Great Plains, Microsoft Dynamics AX, Oracle EBS R12 Financials and Hyperion Planning, Power BI Pro.

Confidential, Pittsburgh, PA

Senior Solution & Data Architect/Data Modeler/ETL Developer

Responsibilities:

• Participated in the architecting, development of New Computer System that helps client manage their entire internal operation.
• Participated in the conversion of the front-end systems and the installation of a new Online Transaction Processing and Data Warehouse. Developed ETL procedures to convert the old warehouse data into the new one.
• Developed ETL procedures / SSIS packages to automate implementation of Reference Data for both the OLTP side and the OLAP side.
• Produced Entity Relationship Diagrams (ERDs, STAR Schemas) for systems using Erwin Data modeling tool.
• Responsible for applying Master Data Management (MDM) strategies, requirements and policies aligned to the company’s goals for data quality, data security and data integration.
• Prepares deliverables such as source to target mappings and transformation rules documentation.
• Designed New Analysis Services Cubes.
• Developed SSRS Reports for accessing SSAS Cubes as well as the underlining DW tables in MS BI platform.
• Interfaced with Network Engineer, Windows Systems Engineer, SQLServer DBA and Business users.
• Made extensive use of Visual Studio Data Tools, Team Foundation Server (TFS).
• Made extensive use of Microsoft SQL SSIs (SQL Server Integration Services), TSQL.
• Develops interactive visualizations with Business Intelligence platforms such as Qlikview and Tableau.
• Participated in Database Development review sessions and Database Administration review sessions.

Confidential

Senior Solution & Data Architect/ETL Developer

Responsibilities:

• Responsible for architecting a highly scalable SMP data-warehouse Server capable of processing over 4 terabytes of information.
• The hardware comprised of 4-way SMP (64 bits) systems capable of scaling up to 64 nodes.
• Participating in the conversion of the front-end systems and the installation of a new Data Warehouse. Develop ETL procedures to convert the old warehouse data into the new one.
• Prepares deliverables such as source to target mappings and transformation rules documentation.
• Convert Data Mining Model from SQLServer 2005 to SQL Server 2012
• Design New SSAS Cubes
• Develop SSRS Reports for accessing SSAS Cubes as well as the underlining DW tables MS BI platform.
• Interfaced with Network Engineer, Windows Systems Engineer, SQLServer DBA and Business users.

Confidential, Purchase, NY

Senior Data Architect /Data Modeler

Responsibilities:

• Lead the planning, requirements gathering, and implementation of a Big Data modeling initiative for the client, both structured and unstructured data.
• Designed, developed, and managed project plans in a complex dynamic environment, revised needs to meet changing requirements.
• Developed detailed tasks for accurate project planning and scheduling, as well as performing estimation, forecasting, planning, analysis, issue / risk / change management, escalation management, meeting facilitation, variance analysis, and status reporting.
• Build relationships and collaborated with key stakeholders to ensure delivery of commitments.
• Inventoried data sources for all major systems by reverse engineering the RDBMS databases (Oracle, MySQL, Informix) to produce an Enterprise Data Dictionary reconciling all disparate data definitions and obtaining business definitions for business critical data elements.
• Produced Data Flow Diagrams, showing flows of all major data elements between systems and reporting sources.
• Evaluated data consistency and cleanliness. Develop recommendations for cleaning up the data and for keeping it clean on a go forward basis.
• Responsible for supporting MDM implementation using Master Data Services and Data Quality Services in MS SQLServer 2012 Enterprise Edition technologies.
• Produced Entity Relationship Diagrams (ERDs) for all systems.
• Designed and documented data governance process.
• Developed policy that specifies who is accountable for various portions or aspects of the data, including its accuracy, accessibility, consistency, completeness, and updating.
• Developed a set of standards and procedures that defines how the data is to be used by authorized personnel.
• Put into place a set of controls and audit procedures that ensure ongoing compliance with government regulations.
• Defined rules and policies that govern data quality.
• Used Embarcadero Connect to extract metadata from application, business intelligence, data integration, data modeling, and relational metadata sources, to browse and search metadata objects, trace data lineage, analyze metadata usage, and perform data profiling on the metadata in the Enterprise Metadata Repository.
• Used Embarcadero Connect to create and manage business glossaries to generate reports on the metadata in the Enterprise Metadata Repository warehouse.
• Tool used: ER/Studio, VersionOne Agile.

Confidential, La Jolla, CA

Senior Data Architect/IBM DataStage Developer

Responsibilities:

• Developed and validated requirements for Enterprise Data Warehouse.
• Collaborated with MO to develop a data integration strategy for the project.
• Prepares deliverables such as source to target mappings and transformation rules documentation.
• Developed ETL solutions, architectural standards and rules
• Provided input on long-term technology planning for data integration and BI initiatives.
• Determine optimal approach for obtaining data from diverse source systems.
• Implemented Change Data Capture on SQL Server (CDC)
• Built appropriate logging and tracking systems to support the ongoing management and optimization of the system.
• Used IBM Infosphere Information Analyzer to collect information on data-flows and manage changes within the integrations and communicate with the user community by generating Analytical reports regarding the objects found in the Metadata Warehouse.
• Used IBM Infosphere Information analyser to browse and search metadata objects, trace data lineage in order to determine dependencies between source and target data, analyze metadata usage, and perform data profiling on the metadata in the Metadata Manager warehouse.
• Demonstrated a high proficiency level with the following: Large scale ETL (Extract, Transform, Load) using IBM DataStage v9.1, Large scale ETL (IBM DataStage development for XML and various other feeds, Performance tuning, clustering, RDBMS data modeling, design and partitioning.
• Managed design and implementation of business reporting solutions using IBM Cognos. Highly proficient with IBM Cognos Framework Manager, Report Studio and Analysis Studio.

Operating Systems: Windows Server 2003/2010, Linux. Database Servers: IBM DataStage v9.1, IBM DB2/LUW, MS/Sqlserver 2012 Enterprise Edition, Knowledge of distributed architecture and design. Data modeling tool: ER/Studio, Thorough knowledge scalability techniques. Thorough knowledge of data backup, recovery, and rollback planning/implementation, in DB2/LUW optimization, fine-tuning, and scalability techniques. Thorough knowledge of data security issues.

Confidential, Jersey City, NJ

Senior Data Architect/Informatica DBA

Responsibilities:

• Developed and validated requirements for Archiving Enterprise Data Warehouse.
• Collaborated with PMO to develop a data archiving strategy for the organization.
• Developed EL solutions, architectural standards and rules for using Informatica Data Archive.
• Provided input on long-term technology planning for data archiving, integration and BI initiatives.
• Determined optimal approach for obtaining data from diverse source systems.
• Built appropriate logging and tracking systems to support the ongoing management and optimization of the data archiving system including data analysis of source data
• Classified data into different categories based on Security and Compliances Polices.
• Created and maintained the metadata repository.
• Performed source system data profiling including structure, data, and relationship discovery
• Designed conceptual, logical, and physical models to meet project requirements
• Evolved existing models to meet new and changing business requirements
• Designed new tables, and integrate new tables into existing schema
• Consolidated and deliver data centric project artifacts including data profile findings, data quality requirements, business metadata (table/column), operational requirements (data retention, archiving, and purge)

Operating Systems: Windows Server 2003/2010, Linux. Database Servers: ORACLE 10g, IBM DB2/LUW, IBM DB2/Z-OS, PL/SQL, Knowledge of distributed architecture and design. Thorough knowledge of data backup, recovery, and rollback planning/implementation, in ORACLE 10g optimization, fine-tuning, and scalability techniques. Thorough knowledge of data backup, recovery, and rollback planning/implementation, in DB2/LUW, and DB2/Z-OS optimization, fine-tuning, and scalability techniques. Thorough knowledge of data security issues.

Confidential, Hoboken, NJ

Senior Data Architect

Responsibilities:

• Developed and validated requirements for Enterprise Data Warehouse.
• Collaborated with PMO to develop a data integration strategy for the organization.
• Developed ETL solutions, architectural standards and rules for using Informatica Powercenter 9.5.
• Provided input on long-term technology planning for data integration and BI initiatives.
• Determined optimal approach for obtaining data from diverse source systems.
• Built appropriate logging and tracking systems to support the ongoing management and optimization of the system.
• Oversee projects and educate other Data Services team members on deliverables.
• Make recommendations to improve Data Services environments.
• Demonstrated a high proficiency level with the following: Large scale ETL (Extract, transform, load) using Informatica Powercenter 9.5. Informatica development for XML and various other feeds, Performance tuning, clustering, RDBMS data modeling, design and partitioning.

Operating Systems: Windows Server 2003/2010, ORACLE 10g, PL/SQL, Knowledge of distributed architecture and design.

Confidential, New York, NY

Senior Data Architect | Database Administrator

Responsibilities:

• Partnered with the AG team to create an integrated data model of the Enterprise DW.
• Validated the business requirements for the business processes in scope.
• Identified the key business user and IT roles required for a successful dimensional model design effort.
• Demonstrated a high proficiency level with the following: Large scale ETL (Extract, transform, load) using SQL Server 2012 Enterprise Edition, SSIS development for XML and various other feeds, Performance tuning, clustering, RDBMS data modeling and design. Develop and administer OLAP cubes in SSAS 2012. Data modeling tool: ERWIN.
• Used SSIS to provide guidance and best practices strategy for maintaining various databases
• Documented the dimensional data model in an effective set of deliverables to enable downstream implementation efforts to move forward smoothly.
• Provided knowledge transfer of the dimensional design process as well as the final design to relevant AG team members.
• Provided a comprehensive dimensional data model for the new DW that presents a consolidated model with conformed dimensions shared across business processes as appropriate to support integration for the following business areas: Exposures, Premiums, Losses, Roll forwards, Ratings, and Market Data.
• The ETL system relies on an overall infrastructure framework to standardize and automate the ETL process. This framework has five major subsystems that address the management and operations of the ETL systems. The ETL framework includes subsystems that support the instrumentation and tracking of the execution of the system and its ongoing operations. In addition, the ETL system and underlying database require ongoing maintenance.
• The DW/BI system is built with appropriate logging and tracking systems to support the ongoing management and optimization of the system. The ETL process has an auditing system to ensure the integrity of the data being loaded, and to support the troubleshooting and optimization needed for any significant production system. The data warehouse database has monitoring system to support a range of needs including performance tuning, capacity planning, and potentially even user access auditing and compliance. The enterprise reporting environment also have its own monitoring system to track the usage and performance of the organizations standard reports.
• The DW is a collection of about 30 fact tables and 60 dimension tables (Info dimensions, Bridge tables, and surrogate key pipeline, conformed and degenerate dimensions)
• The DW contains a minimum of 40 years of data partitioned by year where each year averaged 5500MB of data
• Manage client expectations by building relationships; communicating project status and open issues; preparing reports; conducting reviews and issue meetings; discovering new issues.
• Implements solutions by monitoring project progress; tracking action items; conducting design and implementation reviews; examining, researching, and resolving issues; escalating issues to appropriate authority; responding to team members' concerns; following production, productivity, quality, and customer-service standards; identifying work process improvements

Operating Systems: Windows Server 2003/2010, Installing SQL Server database, knowledge of Transact SQL (T SQL), Knowledge of distributed architecture and design Thorough knowledge of data backup, recovery, and rollback planning/implementation, in SQL Server 2005 optimization, fine-tuning, and scalability techniques, Thorough knowledge of data security issues.