SUMMARY:

• I am a highly motivated Data Architect consultant with over 25 years’ experience in designing, developing and certifying high performance data solutions that allow businesses to be more predictive or better reactive with their analytical business decisions.I have deep experience in architecting and designing end - to-end data solutions including integration with external systems/enterprise business applications. I am able to facilitate the collection of business requirements through analysis and investigation with the business teams. Creating functional specifications with UML diagrams, layouts of producible objects (reports, dashboards, mobile, etc), applying metadata governance and standards to produce a specification that will be translated into a technical design.
• Identifying data elements and determining their fit within the framework of the enterprise data model as to eliminate redundancy. The framework model is maintained through proper data investigation, metadata nomenclature application and metadata management.
• Adhere to a "single version of the truth" belief by evaluating incoming data through additional data profiling and analysis to determine the relevance against the existing business model. These are blended into tasks of Master Data Management (MDM) and Data Governance (DG) across the enterprise.
• Efficient ETL solutions are designed identified from the functional and technical specifications. ETL solutions are built for speed, efficiency and data quality. Provide ETL job restart and reset capabilities which meet the business and technical needs. Build and manage job schedules using internal ETL schedulers and 3rd party tools such as Control-M and Tivoli. Migrating these ETL mappings from development, to system test, to user acceptance testing on to production using version control and/or migration process control software.
• Business Intelligence (BI) solutions developed will normally consist of a mix of canned reporting, dashboards for managing information, business cubes for data mining and data analysis, and creating self-serving reporting possibilities for the more savvy business users.
• I am able to effectively administer and manage small to large teams and all my consulting engagements end with extensive knowledge transfer to local and/or off-shore staff. I have extensive experience managing local and off-shore (Mexico and India) teams remotely.
• I proactively communicate the status, raise issues, and coordinate with all the parties involved. I take a personal sense of ownership and responsibility for all my projects and will provide strong communication and interpersonal skills to any team I join. I communicate effectively, operating within many levels of the business and technical hierarchies and am able to influence other people when appropriate.
• I am proactive and seek out solutions to blocking or competing dependencies. I work well in high pressure situations as well as in tranquil and structured environments. I am passionate about staying abreast with new technologies and stay close to the latest advances and industry trends. I look forward to working with you on your upcoming endeavor.
• Certified Data Warehouse Architect by BILL INMON / Kimball Architect
• Over 25 years of experience using Informatica Power Center, IBM Data Stage Suite, MS SSIS, SSAS, SSRS, Business Objects, Cognos, QlikView and Spotfire BI tools.
• Able to decode and reverse engineer very complex SQL statements (stored procedures, nested code, etc) to identify ways to improve speed, reliability and/or overall quality.
• Design and build ETL solutions to complex business requirements.
• Experience with NoSQL databases such as OrientDB and Neo4j
• Reverse Engineer complex ETL solutions from one tool and migrate that mapping to another tool; or simplify the ETL process within an ETL tool itself by reducing steps and/or prequalifying data.
• Identify the best area to place the "work" required to solve the business need, i.e. in the data model, in the ETL process or on the presentation layer of your BI tools.
• To plan, design, develop and maintain overall data strategy, data architecture, data retention policies, data models, principles and standards for data warehouse design.
• Develop OBI Metadata/Logical Data model, support various business/ infrastructure projects with teams comprising of technology and business representatives
• Develop and maintain documentation of the data architecture, data flow and data models
• Maintain and publish business metadata for a consistent view of business terms, definitions and taxonomies. Build MDM and Data Governance concepts into business solutions.
• Manage In House and Off Shore Teams (India & Mexico) - Multiple teams of up to 20 team members
• Self-starter, highly motivated, able to shift directions quickly when priorities change, think through problems to come up with innovative solutions and deliver against very tight deadlines.
• Excellent spoken and written communication as well as receptive listening skills, with ability to present complex ideas in a clear, concise fashion to technical and non-technical audiences.
• Proficient in communicating and driving technology solutions that support current and future business objectives.
• Served as a solution architect for multiple enterprise and customer facing application implementations.
• Proficiency in software development lifecycle, code management, and release management. Agile development experience.

SOFTWARE AND TECHNOLOGIES:

• Agile
• Zachman Framework
• SDLC SOX Compliant
• GIF (Govt Info Factory)
• Inmon 3 rd NF EDW
• Kimball Star Schema DM
• Operational Data Stores (ODS)
• Data Lakes
• Informatica
• Business Objects
• IBM Data Stage EE/Server (v8.7 & v11.5)
• IBM Cognos BI Suite
• Microsoft SSIS/SSRS/SSAS/SSMS
• Power BI
• AWS
• JavaScript
• SpotFire
• QlikView
• Aginity for Netezza
• Putty
• Eclipse
• Netezza
• Teradata
• DB2
• Oracle 8-11
• SQL Server 2005-2018
• Sybase
• Access
• XML
• Hadoop
• Redshift
• Neo4j
• OrientDB
• JIRA
• RTC
• HP ALM
• TFS
• MKS Source
• Quest STAT
• HP Quality Center
• BOX
• MS Project
• Erwin
• ER Studio
• SAP Power Designer
• SharePoint
• IBM Infosphere Information Governance Catalog
• IBM Infosphere MDM
• IBM Initiate
• TIBCO EBX

EXPERIENCE:

Confidential, Phoenix, Arizona

MDM Data Architect

Technologies: TIBCO EBX, IBM Data Stage, SQL Server, Control-M

Responsibilities:

• Install, configure and stand-up TIBCO EBX application in DEV, TEST and PROD
• Work with Confidential DBA’s to design new RDM/MDM data models
• Create data models, datasets, workflow models within the EBX application and implement security to enforce data governance and separation of duties within the tool.
• Create Source to Target mappings inbound and outbound to EBX
• Create outputs from EBX to replace downstream consumers of RDM/MDM data and to minimalize impact on those systems using IBM Data Stage/Control-M
• Create integration feeds to IBM Information Governance Catalog
• Socialize and train all Data Governance personnel on the use of EBX
• Document all processes and experiences in the Confidential Wiki for use within the enterprise community
• Served as key architect in the business and technical solution development and recommendations for all areas of the project (data analysis, data capture, ETL design, data quality initiatives, meta data management and enterprise governance catalogs) for mastering the Golden Record.
• Worked with multiple LOBs within Confidential to coordinate and simplify RDM/MDM requirements eliminating redundancy.
• Design and implement data solutions using Master Data Management principles and tools
• Partnered with various Confidential leaders and program managers across business and IT to design and institute practices that will drive the appropriate levels of rigor and quality in enterprise information architecture.
• Setup a self-service RDM/MDM hub using REST/SOAP services so Confidential applications could come and get what they need instead of the MDM hub pushing data to them
• Evaluated complex business requirements and was the lead to propose elegant & simplified enterprise information architecture solutions.
• Document logical data integration (ETL) strategies for data flows between disparate source/target systems and the enterprise information repositories
• Define processes for the effective, integrated introduction of new data
• Establish and contribute to standards for ensuring consistent usage of our information platforms
• Make tradeoffs between speed of delivery and data quality measures. Ability to think through multiple alternatives and select the most relevant solution that solves tactical and strategic business needs.
• Using strong leadership and communication skills to socialize and advance complex issues and concepts to business and technical leadership. Ability to drive results towards consensus and amicable resolution whenever possible.

Confidential, Northbrook, Illinois

Data Architect/MDM Data Architect

Technologies: IBM Initiate, IBM Data Stage, Netezza, Oracle, AWS, Redshift, Talend, ER Studio

Responsibilities:

• Served as key architect in the business and technical solution development and recommendations.
• As a result of my detailed analysis, I provided an end-to-end data lineage and ETL job lineage that was easily queried and provided simple impact analysis statistics.
• Identified lack of best practices from prior designs in ETL processes.
• Developed a Data Profiling methodology to eliminate the concern of the business on the data quality of the incoming data. By proactively providing a data profiling process before the input file is processed through the entire ETL process, this gives the business the opportunity to stop or continue the ETL process based on a predetermined algorithm. We also provided the business to override the data profiling audit due to knowledge from the business team that the data would be out of spec.
• Using strong leadership and communication skills to socialize and advance complex issues and concepts to business and technical leadership. Ability to drive results towards consensus and amicable resolution whenever possible.
• Applying strong data privacy against HCO and HCP information to ensure proper confidentiality and sensitivity to customer related information. Applying HIPPA rules and other regulatory considerations on all data activities.
• Maintained productive working relationships with other teams across Astellas business and IT teams to validate enterprise and cross-functional business requirements.
• Solution architecture considerations and recommendation for all phases of development, Current State, Interim State and Future State.

Confidential, Lansing, Michigan

ETL Architect/MDM Data Architect

Technologies: IBM Infosphere Information Governance Catalog, IBM Infosphere MDM, IBM Data Stage, Neo4j, OrientDB, Oracle

Responsibilities:

• Served as key architect in the technical solution development and identification of cross-application data reusability, data quality and standardization of enterprise data.
• Analyzed large amounts of data spanning multiple systems. Synthesized the data, interpreted reusable relationships, defined impact analysis, and suggested processes and/or procedure improvements. Identified trends and developed conclusive recommendations based on findings.
• Created data governance policies and procedures to drive improvement and reusability and provide training and mentorship.
• Developed and maintained productive working relationships with other teams across Confidential Information Technology teams to validate enterprise and cross-functional data requirements.
• Solution recommendation for all phases of important applications, Source to Consuming, through ETL, MDM, integration design patterns and provide guidance on best practices.
• Identify and help define the right strategies to integrate master data with other Confidential operational systems to leverage master data more efficiently and effectively across the Enterprise.
• Identified master data against the currently used data in various Confidential business processes to identify the gaps, discrepancies and the opportunities to further improve quality of Confidential master data.
• Acted as SME for Neo4j and OrientDB graph database design and implementation.

Confidential, Chicago, Illinois

Solution Architect/Data Architect/MDM Architect

Technologies: Netezza, SQL Server, Oracle, SSIS, SAP Power Designer, Business Objects

Responsibilities:

• Lead consultant on the data lineage and MDM aspects of the Customer 360 /Enterprise Product Master project
• Where existing business and technical documentation are available, review for accuracy and consistency. When in question, consult with the business and technical staff to review and validate customer related data and hierarchies.
• Identify key business personnel (SMEs) and stakeholders within each business unit and develop relationships as to build consensus within and across the enterprise; identify all customer and account related information within each business unit for completeness and accuracy.
• The same types of data (customer name, address, etc.) is usually be found in all business systems and it is important to identify and prioritize multiple disparate sources for customer data and determine the “master record” that is available from each source.
• Ability to evaluate complex data architectures across the enterprise. This is done through existing documentation, generating questions/interviews with business and technical SMEs within each business unit and by manual investigation of the supporting database where appropriate.
• Collaborate with source system experts to design integration points, ensuring completeness and accuracy of data.
• Develop data cleansing and data quality criteria so incoming customer data is consistent in format and completeness. Identify any data quality issues back to the appropriate owners so corrections can be made at the source instead of during the extract, transform and load (ETL) processes.
• Ability to synthesize large amounts of complex data into meaningful conclusions and recommendations.
• Ability to structure documents to effectively communicate with senior management to drive alignment and decision making

Confidential, Chicago, Illinois

Data Architect - Business Intelligence Technical Lead

Technologies: SQL Server, SSIS, Informatica, Oracle, Netezza, ASP/.Net, Spotfire

Responsibilities:

• Created a detailed understanding of business and functional requirements through analysis of activities, processes, systems, interfaces and data warehouses. Documentation provided by GE was usually outdated, incomplete or unverifiable. In cases where existing documentation was not sufficient, collaboration with business SMEs to determine optimize final scope and project requirements based on BMO needs not GE legacy policies.
• Created Detailed Requirement Specifications (DRS) through discussion and facilitation of the business users through the GE legacy processes. From these one-on-one and group interviews with GE and BMO financial staff we developed what was the best fit in the BMO business model. Achieve a viable business and technical solution for the BMO environment and acquire approvals with the business key stakeholders and appropriate technical leads. Validate cross functional business requirements where appropriate.
• Socialize business objectives and commitments to all business groups through the use of presentations, approach decks, high level overviews and on-line availability through the BMO intranet.
• Work to develop high level timelines, set prioritizations and plan necessary staffing levels for the different phases of implementation.
• Develop Detailed Technical Specifications (DTS) from DRSs which defined the technical scope of the implementation effort. Performed gap analysis of the BMO requirements against the GE legacy systems and created technical documentation that can be handed off to off-shore staff. In this case some of the business artifacts were available and were included as part of the technical solution.
• Plan, build and implement data models, data dictionaries, data lineage and metadata models (technical and business) .
• Act as technical lead for implementation of business requirements with a staff of 8 people (2 in-house/6 off-shore). Managing team and assigning tasks based on strength and weaknesses, but cross training whenever possible. Built a personal relationship with team members to improve communication and trust.
• Work with QA on testing requirements and test plans. Ensure BMO functional, technical and quality standards are applied throughout the business solution.
• Keep key stakeholders updated on a regular basis through meetings, teleconference presentations and other socializing media with BMO.
• Migrate SQL Server, Oracle and Netezza databases, views, stored procedures and triggers from GE environment to BMO environment.
• Migrate, modify and deploy Informatica Power Center and MS SSIS ETL maps from GE to BMO. Make environmental modifications where appropriate. Identify architectural legacy design inefficiencies and recommend efficient and time-saving solutions. Migrated ASP/.NET applications.
• Migrate, modify and deploy Business Objects dashboards and reports, QlikView dashboards and reports and Spotfire dashboards. Building BO universes and migrating reports and dashboards, rebuilding when original BO objects were not available.

Confidential, La Crosse, WI

BI Architect and Developer

Technologies: SQL Server, SSIS, SSAS, SSRS, QlikView, ER Studio, Power BI

Responsibilities:

• Interviewed and facilitated business stakeholders through one-one-one interviews and workshops to identify critical business entities and metrics which from conceptual, logical and physical data models are created.
• Manage the database architecture, including ensuring the consistency of: data attributes, naming conventions, element value types (data cleansing)
• Developed data models using ER Studio Data Architect. Responsible for Logical and Physical modeling with Inmon 3NF and Kimball Star Schema data models
• Develop, test, and implement extraction, transformation and loading (ETL) processes from external and internal source
• Optimize performance of the data warehouse and data marts
• Perform capacity planning, monitoring data warehouse growth and processor usage
• Maintain quality of data in the warehouse, ensuring: integrity of data in the warehouse, correcting any data problems, data currency, establish design procedures to purge/archive old data
• Performance analysis and optimization of relational data stores
• Develop business dashboards and reporting needs using QlikView BI tool.
• Developed and maintained online metadata repository using ER Studio and ER Team Server
• Developed and produced business documentation, data models, business nomenclature, business rules and made them available as business artifacts

Confidential, Milwaukee, WI

Data Warehouse Architect and Developer

Technologies: SQL Server, Oracle, Erwin

Responsibilities:

• Developed 1-2 year roadmaps for enterprise data management (EDM) initiatives; data acquisition and integration; data storage and consolidation; master data management, security and BI reporting
• Influenced direction with data governance (DGO) and internal organizational change management (OCM)

Confidential, Milwaukee, WI

BI Architect and Developer

Technologies: SQL Server, SSIS, SSAS, SSRS, ASP/.Net, ER Studio

Responsibilities:

• Healthcare (provider and payer) business domain expertise in data analysis and data mining of data from Electronic Health Record systems and Claims Processing Systems
• Development and working knowledge of Population Health Management, Clinical Quality Measurement, Cost and Utilization Management, and Care Management analysis and reporting applications
• Analyze, extract, transform and normalize claims and clinical data, from disparate data sources, into EDW and through to Encounter Reporting
• Design and Develop data analysis and mining application logic using Microsoft SQL Server T-SQL, Business Intelligence Studio, SharePoint 2010 and Office 2010.
• Experience developing one or more analysis and reporting applications amongst Population Health Management, Clinical Quality Measurement, Cost and Utilization Management, Business Performance Management and Care Management

Confidential, Cincinnati, OH

Data Warehouse Architect and Developer

Technologies: SQL Server, Oracle, SSIS, IBM Data Stage

Responsibilities:

• Performed an analysis of physical infrastructure (servers, SAN/NAS, network)
• Reviewed existing ETL maps and sequences for areas of concern
• Produced a report with dozens of recommendations to improve data quality, apply code management, ETL map design and implementation.
• Increased efficiency in some ETL processes up to 1200%
• Reviewed existing data warehouse architecture and suggested some ways to improve on the assessment of data quality early in the ETL process.
• Capturing of process metadata for statistical evaluation of performance

Confidential, Detroit, MI

Data Stage Architect

Technologies: DB2, SQL Server, IBM Data Stage

Responsibilities:

• Data Stage 390 is being used to extract data from mainframe with COBOL programs (generated from DS 390) and then loaded into DB2 tables
• Working with people in India, China and the US concurrently
• Act as mentor for Data Stage ETL maps to other GM consultants and employees

Confidential, Chicago, IL

Data Stage Architect

Technologies: SQL Server, Oracle, SSIS, IBM Data Stage, SSAS, Cognos, Control-M, TWS. CA7

Responsibilities:

• Developed functional requests with business users and achieved sign off.
• Created technical specifications for ETL (IBM Data Stage, SSIS) and BI (Cognos, SSAS) solutions
• Direct interfaces were built into Control-M, TWS and CA7 scheduling systems to retrieve job definitions and job messages during process execution and provide a BPM Dashboard.
• DB2, Oracle, SQL Server
• Analytical reporting developed using Cognos. Created dashboards, canned reporting and prompt able reporting capabilities.
• Developed and supported TIC (Technical Internal Control) Finance reporting for Confidential financial auditing and control reporting.
• Identifying and applying proper single sign-on security within the Cognos framework model
• Configured, administered and supported over 20 IBM Data Stage application servers and 5 IBM Cognos servers across the world.
• Developed SDK code to copy a generated report from the CS to a external drive location for SOX compliance
• Managed staff on-shore and off-shore in India
• Supported 1500+ business users world-wide

Confidential, Bloomington, IL

Data Model Architect

Technologies: SQL Server, Informatica, Erwin

Responsibilities:

• Facilitated and directed discussion of Country’s business artifacts and their effects on the Sales & Marketing needs with the business stakeholders.
• Translated the business requirements into a 3rd NF Inmon data warehouse model and on to Kimball Star Schema data marts
• EDW database in 3rd NF and Kimball data marts were maintained using CA Erwin
• Sales & Marketing data warehouse developed so Country can start to cross market Country products to their existing customer base.
• Customers from disparate business lines (Auto, Life, Property & Casualty, Commercial, Annuities, etc.) were brought together in one central data warehouse.
• Designed and developed ETL maps for Informatica to SQL Server
• Developed tables for Business Objects universes and reporting needs.
• Documentation/Knowledge Transfer of EDW Model to local DBA Architect

Confidential, Peoria, IL

Data Warehouse BI Architect

Technologies: UDB/DB2, IBM Data Stage, Cognos

Responsibilities:

• Worked directly with business stakeholders to create functional specification with use cases, class diagrams, layouts of BI deliverables (dashboards, reports, etc).
• Architect the framework model using best practices and governance.
• Develop operational data store (ODS) model & package migration practices through the version control methodology.
• Assist/Review design of Cognos reports, graphs, dashboards, scorecard capabilities based on selected Cognos tools
• Provide guidance on Report Net capabilities and mentor resources on how to build and design Report Net deliverables and best practices for Report Net/Cognos tool-suite.
• Reproduce existing reports from MS Excel/MS PowerPoint to the Cognos Report Net environment.
• Framework model built against PeopleSoft tables. Convert complex SQR reports to Cognos Report Studio
• UDB/DB2 environment

Confidential, Milwaukee, WI

Data Warehouse BI Architect

Technologies: SQL Server, SSIS, Cognos

Responsibilities:

• Develop Cognos Power Play and Report Net reports from a Phone IVR system for Plymouth, Minnesota facility from an operational data store (ODS).
• Responsible for development of the Framework Model, Transformer Model and 30+ reports across both environments.
• Developed functional business requirements with the creation of a formal Functional Specification from input with the business stakeholders.
• Cubes were made available with a focus on data mining for business users.
• SQL Server
• Documentation/Knowledge Transfer of Framework Model and reports to local staff