We provide IT Staff Augmentation Services!

Sr Data Architect Business Intelligence Resume

3.00/5 (Submit Your Rating)

MichigaN

SUMMARY:

  • Data Architect / Technology Director with experience over 17 years in bridging the “business - technology gap” by simultaneously acting as a liaison between the two “worlds”, demonstrating/facilitating business functionality requests focusing on delivering business value as quickly as possible. Developing/mentoring Technical teams which are more aware of business needs and develop advanced analysis / design / development techniques needed to meet the requirements of the project.
  • Overall responsibility of collaborating with 6 Confidential, 27 service providers and 14 Addiction Clinics for all application, system and data needs.
  • Have been an integral part of every phase (analysis, design, testing, implementation) of database projects using every common type of data store - transactional (OLTP), Data warehouse (Kimball/Inmon), and Data Mart (OLAP).
  • Extensive experience in requirements gathering and business rules analysis using a variety of techniques, conceptual/logical/physical database modeling in ORM/ER/UML, model validation/business rules traceability analysis, “as-is” vs. “to be” software modeling, gap analysis, and meta-modeling.
  • Facilitate and review enterprise wide data dictionaries.
  • Defined data, information and underlying technology roadmap.
  • Evaluate, recommend and select database tools & utilities.
  • Establish formal policies and procedures for data model review and approval.
  • Identify and implement best practices, tools and standards (ER modeling, normalization, data security, etc)
  • Manage data architecture, data quality, data standards and data structures.
  • Facilitate database performance, scalability and availability activities.
  • Fifteen years of implementation and integration of multiple data conversion and data modeling projects involving complex and large amount of data.
  • Strong trouble shooting and problem analysis and solving skills.
  • Exceptional ability to Research technical issues, problems, procedures, and methods and advise management.
  • Excellent ability to understand business needs and data to generate end to end business solutions.
  • Ability to think critically and act expeditiously to evaluate situations, make decisions and solve problem.
  • People oriented and strong inter personal skills and a proven team player/ leader.
  • Experienced in project coordination and management at every phase of project lifecycle.

TECHNICAL SKILLS:

  • Business Problem Analysis
  • Database System Architecture and Design
  • Data Modeling
  • Software Development and Methodology Mentoring
  • Project Management
  • Object-Role Modeling (ORM)
  • Entity-Relationship (ER) Modeling
  • Unified Modeling Language (UML)
  • Rational Unified Process (RUP)
  • Kimball and INMON
  • Rational Tools
  • Visio for Enterprise Architects
  • ERWin Data Modeler r7
  • Power Designer 12
  • Cognos 8.4.1
  • Sybase Power Builder
  • Oracle OBIEE
  • Crystal Reports
  • Business Objects
  • Data Stage
  • SQL Loader
  • SSRS / SSIS / SSAS
  • MS SQL Server
  • MS Analysis Server (OLAP)
  • Sybase SQL Server
  • Oracle RDBMS
  • Terradata
  • DB2
  • SQL, PL/SQL
  • Cobol
  • C/C++
  • T-SQL,

PROFESSIONAL EXPERIENCE:

Confidential, Michigan

Tools: Oracle10g/ Informatica Data Explorer / Toad Data Modeler 3.5 / Informatica Meta Data Manager

Sr Data Architect Business Intelligence

Responsibilities:

  • Worked as amember of the core Data Management team.
  • Responsible for ensuring data used by various Data marts and Data warehouses have conforming data.
  • Objective of the role was to identify and authenticate the source of data and verify the quality/ integrity of data, which simplifies the effort of Data Modelers and ETL writers.
  • Diagnosed the faults with Source Data, eventually leading to business process reengineering initiatives to address the root causes of dirty data and improve data quality over time.
  • Maintained and added required information in data gap matrix that had details of various data points such as table/column name, percentage population, source systems etc.Conceptualized and was instrumental in the creation of data quality analysis report for all tables in EDW for future use by various projects.

Confidential, Albequerque, NM

Sr Data Architect

Responsibilities:

  • Analyzed and submitted written report on issues in the current data warehouse.
  • Also did impact analysis and reported various changes required in the Data Warehouse redesign and associated applications and reports.
  • The project was shelved due to the magnanimity of the work involved.
  • Client decided to make corrections at report level.

Confidential, Indianapolis, IN

Tools: /SQL SERVER 2005 & 2008 / Cache / Oracle/ DB2/ Erwin / Crystal Reports / Cognos 8.4.1/ C# / XML Webservices / Sharepoint 2007 / SSRS/ SSIS/ SSAS / SOAP/Microsoft Visual Studio/.Net/ WSDL/HIPAA/ICD-9 and DSM IV

Data Architect and Project Manager

Responsibilities:

  • Conversion of faxing Patient Referral Information to an electronic process from the Confidential.
  • Conceptualization of the project, Project Management, Technology usage decision, Liasoning between Indiana Office of Technology, Dept of Technology Services, 6 Mental Hospitals and 27 Confidential ’s, development, HIPAA compliance, identifying users for launching a pilot project, planning the training for the Providers and Hospitals for using the system using Webinar, planning access and availability of tools and technology to the users.
  • Monitoring the performance of all the State run Mental Hospitals, Mental Health Service Providers, Addiction Clinics and Community based recovery services.
  • Monitoring various types of incidents happening at the Hospitals.
  • Making Rejected patient Medicaid data from HP available to all Providers thru Reports developed in SSRS and Database maintained in SQL SERVER 2008.
  • Information Library in Sharepoint 2007 for each IT Project of DMHA. All Data Models, Report Documentation, Data definition Documents, User Manuals and Disaster Recovery information was located in Sharepoint.
  • Processes were developed to maintain changes and rules were set for version control.
  • Reengineer, redesign and oversee the redevelopment of Community Cube and Encounter Cube. Using these cubes and Cognos, the Decision makers are able to expedite and access information about various aspects of Mental Health information. Conversion of existing cubes based on data warehouse redesign. Role involved: Data Mapping, Identifying Fact and Dimension tables, Data Warehouse redesign, Data Modeling, Data Load, Data Quality, Data Standard, monitoring Testing and Launching of the Hyper cubes.Report Monthly, Quarterly and Annual Hospital Admission / Discharge / Capacity and Movement Status to the DMHA Director and Governor of Indiana. Developed in SSRS.
  • Data Mapping and Feasibility Analysis for Information transfer between WITS System and DARMHA System. Analyze and write requirements for ETL creation. Plan and create test cases for testing and verifying data transfer between the systems.
  • Reverse Engineer in ERWIN, create Data Models, Data Definition Documents, and compile various information about WITS / DARMHA / ICOPE / AVATAR applications being used by the Division.
  • Migration of all Databases, Data warehouse and SSRS reports from SQL Server 2005 to SQL Server 2008.

Confidential, Indianapolis, IN

Tools: Oracle / J.D. Edwards & OBIEE

BI Business Tech Analyst / Data Architect

Responsibilities:

  • Attended and lead JAD sessions between various teams to identify the process and tables involved from various Databases.
  • Data mapping between the EDW tables and various application tables.
  • Facilitate and review enterprise wide data dictionaries.
  • Defined data, information and underlying technology roadmap.
  • Create Data Model and comply with policies and procedures for data model review and approval.
  • Identified and implemented best practices, tools and standards (ER modeling, normalization, data security, etc)
  • Managed data architecture, data environments, data quality, data standards and data structures.
  • Facilitated database performance, scalability and availability activities.
  • Team included more than 50 people working as DBA’s, Application Leads, Specialists and multiple Data Architects.

Confidential

Architect/Project Coordinator

Tools: SQL Server / Visual Basic

Responsibilities:

  • Responsible for all activities from conception to implementation of the project.
  • Met with business users to understand business processes.
  • Documented existing business processes with detailed explanation of events and data elements involved in each process.
  • Analyzed and designed database tables for automated data transfer System.
  • Designed automated procedure for data uploads and downloads to the auto dialer and to the billing system.
  • SQL writing and tuning for optimum performance and valid retrieval.
  • Developed user friendly QA (Query Analysis) System for Sale Verification
Confidential, Indianapolis, IN

Senior Systems Analyst - Systems Analyst

Tools: ESSBase Hyperion / Business Objects / DB2 / COBOL / VSAM/ CICS / TSO(SPUFI/QMF)

Responsibilities:

  • Mapping of VSAM data to various tables in DB2, identifying changes in application and programs, analyzing data retrieval by optimizing, performance tuning and SQL tuning of queries, testing and implementation of In-house and AMAPS system.
  • Project involved more than 100 tables.
  • Conversion of Batch and Online Job submissions and Program changes.
  • Team of 4 programmers and a DBA.
  • Developed and implemented programs to enable submission of user jobs directly through CICS screen there by circumventing the request / scheduler.
  • Conception of process and requirement gathering through research, formal-informal sessions and JAD sessions with end users.
  • Performed Gap analysis, data analysis, business process improvement and systems integration.
  • Involved with conception to implementation of the project.
  • Requirements gathering through research, Database analysis, identifying tables and deciding changes for more than 100 DB2 and VSAm tables.

We'd love your feedback!