SUMMARY:

• Senior Enterprise /Data / Solutions Architect with over 18 years experience 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.
• Provide Technical leadership and mentor Technical teams, which are more aware of business needs and develop advanced analysis / design / development techniques needed to meet the requirements of the project.
• Provide overall technical architecture / design / leadership for implementation of the solution and various aspects of projects.
• Assist with Detail system / business / network / enterprise architecture design and have it approved by ARB.
• Identify and document architecturally significant aspects/views of the systems.
• Ensure that the design is consistent with the overall architecture.
• Collect, deliver and present industry best-practices.
• Provide rationale for architecture / design decisions.
• Identify gaps, provide missing process documentation and ensure consistent use of SDLC.
• Ensure that significant design decisions are communicated, validated, and adhered to.
• Facilitate and review enterprise wide Enterprise and Data Architectures, Models and data dictionaries.
• Define data, information and underlying technology roadmap.
• Evaluate, recommend and select database tools & utilities.
• Establish and document the System Backup plan.
• 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, and 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:

Primary Skills: Business Problem Analysis

Enterprise Architecture and Design

Database System Architecture and Design

Data Modeling

Software Development and Methodology Mentoring

Project Management

Techniques

Object: Role Modeling (ORM)

Entity: Relationship (ER) Modeling

Unified Modeling Language (UML)

Rational Unified Process (RUP)

Kimball and INMON

EA Frameworks

Zachman, TOGAF, DODAF, NIST and SOA Governance

Analysis/Design /DW/BI Tools

Rational Tools

Visio for Enterprise Architects

ERWin Data Modeler r7

Power Designer 16.5

Cognos 8.4.1

Sybase Power Builder

Oracle OBIEE

Crystal Reports

Business Objects

Data Stage

SQL Loader

SSRS / SSIS / SSAS

Database Platforms

MS SQL Server

MS Analysis Server (OLAP)

Sybase SQL Server

Oracle 11g

Teradata

DB2

Languages

SQL, PL/SQL

Cobol

C/C++

T: SQL

PROFESSIONAL EXPERIENCE:

Confidential

Senior Enterprise Solutions Architect

Tools: Powerdesigner 16.5, Oracle 11g, Sql Server 2008, Team Foundation Server 2010 & 2013, Sharepoint 2010 and Team Web Explorer

Responsibilities:

• Identified and presented the existing Infrastructure, Application, Data and System Architecture of the Delaware Judicial Information System.
• Have been responsible and instrumental in planning the Storage, Server purchase and Server Virtualization.
• Negotiated with various vendors for Server and SAN specification and pricing. Identified the missing elements in the SDLC process and formalized the process.
• Created, Data Models for all existing systems and Process flow diagrams for all the Court processes.
• Envisioned, planned, designed and successfully migrated ADABAS database to Oracle 11g.
• Instrumental in prototype development for migrating Natural based CMS system to a Web based application.
• Conceptualized and influenced the design of multiple in house applications.

Confidential

Sr Data Architect Business Intelligence

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

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

Sr Data Architect

Responsibilities:

• Worked on Confidential ’s Health Information Exchange project (HIX).
• Was responsible for identifying the information exchange process between various systems

Confidential, Albuquerque, 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

Technical / Data Architect

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

Responsibilities:

• Responsibilities involve coordinating work between Indiana Office of Technology, Department of Technology Services, Div of Mental Health, 6 Mental Hospitals, 27 CMHC’s and 14 Addiction Treatment Clinics.
• Conceptualization of the project, Project Management, Technology usage decision, Liasoning between Indiana Office of Technology, Dept of Technology Services, 6 Mental Hospitals and 27 CMHC’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.
• Role involves Project management, Technology support, Data collection, OTP billing and System improvement.
• 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, and Data Standard, monitoring Testing and Launching of the Hyper cubes.
• 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.
• Planned, designed the DW Database, Data Mapping and monitored the database migration of Avatar, BHIS, WANG and DSS System of Patient Information Management for six Mental Health Hospitals into DMHA Data Warehouse. Migration from Cache, Oracle to Sql Server 2005

Confidential, Indianapolis, IN

BI Business Tech Analyst / Data Architect

Tools: / Technology/Software used: Oracle / J.D. Edwards & OBIEE

Responsibilities:

• Create Data warehouse and bring data from mainframe and J.D.Edwards application.

Confidential, Indianapolis, IN

Technical Analyst

Tools: / Technology/Software used: Power Designer / Teradata / DB2 / Oracle / SOX Compliance.

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: / Technology/Software used: 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