SUMMARY:

• Over 18 years of strong Confidential, Solution Architect, Data Modeling, Data Integration, Project Lead, Business Analysis, Data Warehouse and Business Intelligence experience.
• Strong Data Integration Architect, Data Warehouse Architect and BI Architect with hands on capability to move project from requirements gathering and design through implementation.
• Very strong Data Architecture, Data Warehouse, BI & Team Leadership experience.
• Database Design (Conceptual, Logical & Physical) using Erwin, Sybase Power Designer and Embarcadero ERstudio.
• Very strong Relational and Dimensional Data Modeling experience.
• ETL and Reporting Architecture, Design and Development using various tools.
• Data Warehouse Design (Star and Snowflake schema) using Kimball methodology.
• Strong experience with Oracle 11g, 12c and MS SQL Server 2008/12, Teradata, HP Vertica and UDB/DB2 databases, various ETL and BI/Analytics/Reporting tools.
• Strong Vendor and Client Management experience.
• Excellent Communication, Team Leadership, Management & Inter - personal skills.

TECHNICAL SKILLS:

Hardware: COMPAQ Servers (Proliant), Sun Ultra 7, Sun Sparc 5Operating Systems Windows NT 4.0, 2000, UNIX, Solaris 2.7, 2.6

Relational Databases: Oracle 7.x, 8.x, 9i, 10g, 11g, MS SQL Server 7/2000/5/8/12, Teradata, DB2, HP Vertica

Web Technology: Java, C++, ASP, Perl, JDBC, Java Web Server, IIS, WebLogic

Languages/Tools: Power Designer 16.5, 15.x, Erwin 4.1.4, 3.5, Oracle Designer 6i,

PROFESSIONAL EXPERIENCE:

Confidential,PA

Responsibilities:

• The solution is being implemented on SQL Server database using Informatica and BODS (Business Objects Data Services) as data integration tools.
• Worked with business users and stakeholders to identify PHLY’s data needs.
• For Release 1, sources Rapidsure and Billing Center, including lines Personal Auto, custom LOB’s (Collector Vehicle, supported by Personal Auto, Fitness Studio (GL, IM), Fitness Trainer (GL) and Billing Center (Commissions, Funds Transfer, Outgoing Payments, Hold, Region, User Information Services.
• For Release 2, sources AQS, OneShield (Philly Bond System) and Policy Decision, for ISO Lines (GL, Commercial Auto, Property) and for custom LOB’s (Surety, Excess Liability, Non-ISO GL, Non-ISO PR, IM, D&O, E&O, EPL, Cyber Security Liability, BOP (ISO based and Custom), Medical Liability, Crime, Umbrella, Manufactures Liability)
• Created Logical and Physical DataHub Integration Architecture
• Document the as-is and to-be System Architecture
• Document Data Flows and Process Flows.
• Defined the to-be architecture to support PHLY’s data integration and reporting needs
• Created Pre-Landing Zone (PLZ), identical to source, Landing Zone (LZ), pipe delimited files, for landing of source data into TRF tables before loading it into DataHub using BODS and then InfoCenter.
• Adhering to established data modeling standards and best practices.
• Defined the ETL architecture for the movement of data across various systems.
• Capacity planning. Database sizing and growth estimates.
• Worked with data analysts to analyze the source system data
• Using predefined templates to capture source to target data mapping.
• Policy Event Handler to log all Policy transactions as XML messages through service on Enterprise Service Bus (ESB) for all LOB’s into PLZ
• Each transaction (XML message) stored as one row in the table and XML content is stored in a single xml column.
• Leveraging XQuery and XPath to parse XML messages from source system
• Creating database views to represent the relational structure of the message.
• These views (PLZ) facilitate extraction of data in a format that represents various entities, attributes, and relationships of source data in relation format that is suitable for ETL
• Data extracted directly from XML via XQuery and transformed using Informatica to be consumed by DataHub
• Worked with ETL developers to extract/load data from various sources into DataHub using Informatica.
• Working with QA team for profiling data, identifying and resolving issues.
• Worked with the reporting team to identify the data and reporting requirements
• Creation of staging tables and views to support outbound data integration needs for downstream applications
• Created tables, partitions, indexes and other database objects
• Work closely with DBA’s to monitor and improve performance, etc.
• Implemented database design, ETL and Reporting deliverables in an agile environment.
• Metadata creation, management and publishing
• Helping in Project Planning.

Environment: ERStudio Data Architect 9.5, SQL Server 2012, Guidewire DataHub 8.3, Guidewire InfoCenter, BODS 4.2, Informatica, MS Project, Visio

Confidential, Albany, NY

• Interviewed the SME’s and business users.
• Conducting JAD sessions to get the data requirements.
• Worked with business users and stakeholders to identify NYSDOH data needs.
• Working with users in identifying Tier1 and Tier2 edits to X12 and NCPDP formatted data to increase the quality of data for Post Adjudicated Claims Data Reporting (PACDR).
• Worked with Business users to define and document the requirements.
• Document Data Flows and Process Flows.
• Established data modeling standards and best practices.
• Created Conceptual, Logical and Physical data models using Erwin for EIS from scratch.
• Develop new data structures to store the historical PACDR data for all the EDI X12 837’s (298-Professional, 299-Institutional, 300-Dental) and NCPDP data formats for QHP (Qualified Health Plans) and MMC (Medicaid Managed Care).
• Defined the ETL architecture for the movement of data across various systems.
• Creating Templates to capture source details and source data elements.
• Created source to target data mappings for ETL.
• Worked with ETL developers to extract/load data from various sources into/from EIS.
• Loading various data files including Member Validation data from eMedNY.
• Created the ETL mapping for generating the MAEE (Medicaid Analytical Extract) extract from EIS (Encounter Intake System) for MDW (Medicaid Data Warehouse).
• Working with QA team for profiling data, identifying and resolving issues.
• Identify and source data from external data sources.
• Worked with the SME’s to identify the data and reporting requirements of the NYSOH.
• Worked on reports using Cognos.
• Working on the data management plan and data security plan for confidential and restricted information and PII.
• Created tables, partitions, materialized views, indexes and other database objects
• Work closely with DBA’s to monitor and improve performance, etc.
• Manage various work environments, Development, Test, UAT, Arch and Production.
• Implemented database design, ETL and Reporting deliverables in an agile environment.
• Metadata creation, management and publishing
• Helping in Project Planning.

Environment: Erwin 9.5, Oracle 11gR2 (11.2.0.1), IBM InfoSphere Data Architect 8.1, IBM Data Stage 8.1, IBM Data Studio 3.1, MS Project 2007, Visio

Confidential, West Des Moines, IA

• Interviewed the SME’s and business users, for both Multi-peril Crop Insurance (MPCI) and HAIL lines of business within Crop Insurance to get the data requirements.
• Worked with business users and stakeholders to identify FMH’s reporting and data needs
• Created the data warehouse architecture and roadmaps and got buyin’s from the upper management and other team members.
• Did various tool evaluations, POC’s and Vendor selection for both ETL/Data Integration tools and Reporting tools.
• Defined and document the requirements using use cases.
• Document Data Flows and Process Flows.
• Analyzed the newly developed source system CloudNet and its data structures.
• Created the BUS Metrics for the various business processes across FMH and identify the Dimensions and Facts to be used across these business processes.
• Designed the Enterprise Data Warehouse including various dimensions and fact tables using Kimball methodology
• EDW also housed some of the historical information from retired systems (TIP, AS400), P&C (Garvin Allen) and ReInsurance (SICS).
• Created STAR schemas for Policy, Agency, Claims, Reserves, Financial data marts.
• Established data modeling standards and best practices and created Conceptual, Logical and Physical data models using Sybase Power Designer.
• Defined the ETL architecture for the movement of data across various systems.
• Creating Templates to capture source details and source data elements.
• Created source to target data mappings for ETL.
• Worked with ETL developers to load data from source systems.
• Working with DQ team for profiling data and resolving issues.
• Working with source system experts and data stewards to resolve data issues.
• Worked with the SME’s of source systems to satisfy the data and reporting requirements of the government body RMA (Risk Management Agency), NCIS and other third parties.
• Conducted various POC’s and user focus groups for Agents and Adjusters for getting the dashboards and reporting needs using LogiXML (Logi Info and Logi Adhoc).
• Identifies the reporting needs from the workflow and document management system ImageRight and its data integration needs with CloudNet.
• Worked on reporting needs for Geospatial and GIS information in ESRI with CloudNet
• Worked on variety of old systems to be retired (TIP, AS400) to move their data in EDW.
• Working on the data security plan for confidential and restricted information and PII.
• Implemented user level reporting security based on user types, roles and permissions for controlling access to users.
• Helped with conversion effort from old policy admin system eCrop to CloudNet.
• Created tables, partitions, materialized views, indexes and other database objects
• Work closely with DBA’s to monitor and improve performance, etc.
• Manage various work environments, Devlopment, Test, UAT, Hot Fix and Live.
• Implemented database design, ETL and Reporting deliverables in an Agile environment.
• Metadata creation, management and publishing
• Helping in Project Planning.
• Vendor evaluation and vendor management.

Environment: Sybase Power Designer 16.5, 16.1, Oracle 11gR2 (11.2.0.1), TOAD 11, 10.5, Astera Centerprise Data Integrator 5.1, Log Analytics (LogiXML) 11.x, Pervasive Data Integrator, ASP.NET, Perforce, MS Project 2007, Visio

Confidential, Des Moines, IA

• Working for Wells Fargo at their Home Mortgage head quarters as a Team Lead for ‘Sourcing Workstream’ for sourcing and integration of data from 40 Home Mortgage related source systems for MIDE (Mortgage Integrated Data Environment) project. MIDE project is being implemented in Teradata environment for high volume parallel processing of data to support business needs.
• Working as Solution Architect Lead for Sourcing Workstream leading team of 10 Analysts
• Worked with the SME’s of source systems including Loan Origination, Servicing, Correspondent and Wholesale, Institutional Lending, Sales systems, etc
• Meet with SME’s of source systems including LIS, LPS, AS400, PCLS, SMS, CORE, C&W Standard, IL Online, MSP/Fidelity, Phoenix, Profiler, Arrow, ACAPS, SalesLogix, CTS, AOW, ECPR, MYBOB, Oracle GL, PeopleSoft, etc.
• Meet with SME’s of various users to help identify what data should be sourced into MIDE.
• Worked on variety of source system platforms including Mainframes, Oracle, SQL Server, Sybase, Extracted data files, User Maintained data, etc.
• Setup meetings and work with the SME’s to identify and get the system of record (SOR) data sourced into MIDE from the respective source systems.
• Interviewed the SME’s & business users of all the 40 source systems to get requirements
• Defined and document the requirements using use cases.
• Document Data Flows and Process Flows.
• Creating Templates to capture source details and source data elements.
• Creating Conceptual, Logical and Physical data models using Sybase Power Designer.
• Help with Metadata creation, management and publishing.
• Managing process for loading of metadata into EMR (Enterprise Metadata Repository).
• Help in creating source to target mappings.
• Help in documenting source databases, business rules, transformations and data mappings from source to target data structures.
• Worked with ETL developers to load data from various source systems.
• Working with DQ team for profiling data and resolving issues.
• Working with source system experts and data stewards to resolve data issues.
• Helping in Project Planning

Environment: Sybase Power Designer 15, Teradata, DataStage 8, MS Project 2007

Confidential,Des Moines, IA

• Meet with users to identify the requirement for the Predictive Modeling project.
• Interviewed the business users and stake holders to get the requirements
• Defined and document the requirements using use cases.
• Document Data Flows and Process Flows.
• Creating Logical and Physical data models using Erwin.
• Metadata creation, management and publishing.
• Followed the Agile methodology for the Predictive Modeling Project
• Worked with ETL developers to load data from third party vendors.
• Working on the PII (Personally Identified Information) project. Analyzing various applications and identifying as well as controlling access to users.
• Working on various another projects and involved in tool evaluation.
• Supported other application data models on DB2/UDB databases.

Environment: Erwin 7.1, Oracle 10g, DB2/UDB, Informatica PowerCenter 8.1.1, PL/SQL, TOAD 9.6, MS Project 2007, Visio

Confidential, Minneapolis, MN

• Involved in maintaining the project plan, defining the tasks & identifying resource needs.
• Interviewed the business users and stake holders
• Worked on the Data warehouse Bus Architecture identifying various business processes.
• Define and document requirements using use cases, Document data and process flows
• Doing business analysis, identifying business data needs and reporting needs and obtaining sign-off from client on specifications
• Conducting Joint Requirements Development (JRD) sessions.
• Designed/Created various templates for conformed dimensions and facts.
• Involved in work allocation to resources for ETL and Report Development.
• Worked with the data modelers to design the ODS tables and star schemas for custom tables in Oracle Applications supporting MoneyGram specific business needs.
• Create Logical and Physical data models.
• Created various tables to support the data needs of the ancillary applications which the data warehouse was supposed to feed.
• Designed structures around basic Customer Setup for various business units Credit Management and Recovery, Legal Fraud & Compliance, Agent Servicing and Operational Support, Settlement Servicing, Product Management & Marketing, Finance and Accounting, etc
• Designed hierarchies for Agent and their relationships over time, Sales Rep, etc.
• Help resolve the data issues by interacting with the SME’s and the business users.
• Create data mapping documents and extract specification documents for enhancement to OOB Jaros data warehouse and custom OA tables.
• Worked with Informatica ETL developers to get the required data loaded, both, ‘Near Real Time’ in ODS and ‘Nightly’ in the Data Mart.
• Created and maintained the control tables and other details for sourcing the data from the Oracle Applications source table.
• Technical Project Lead with Strong hands on capability to move project from requirements gathering and design through implementation
• Provides project status updates and Report development status to the Project Manager.
• Monitor the overall development process and made sure deliverables are on time.
• Used Jaros Information Directory Services (IDS) to define relationships between various entities and publish the model in Cognos Framework Manager.
• Used Jaros Metadata Manager (MDM) to define and maintain the metadata so it can be published by the Jaros Help System for the business users.
• Applied Fixes for enhancement to the OOB Jaros data warehouse solution using the Jaros Fixes Tool
• Identify sensitive data elements and implement the information security policies
• Decryption of the encrypted data elements in the Cognos Reports and Auditing the information both at record level and the request criteria level for PCI compliance.

Environment: Sybase PowerDesigner 12.5, Oracle 10g, Oracle Applications v11i, Informatica PowerCenter 8.1.1, Cognos 8i, TOAD 8.5, 9.6, PL/SQL Developer 7.1.4, MS Project 2007, Visio, WinCvs 2.0.2.4, HP Project and Portfolio Management (PPM) v 7.1 Jaros Analytics v 3.0.3, Jaros AMDR 1.19.7

Confidential, Purchase, NY

• Involved in creating and maintaining the project plan, defining the tasks and dead lines and identifying resource needs.
• Defined and document the requirements using use cases.
• Document Data Flows and Process Flows.
• Interviewed the business users and stake holders
• Conducting Joint Requirements Development (JRD) sessions.
• Doing business analysis, obtaining sign-off from client on requirements & specifications.
• Introduced a data warehousing methodology to be followed in the project for conformed dimensions and fact definition/computation
• Designed/Created various templates for conformed dimensions and facts.
• Worked on the Data warehouse Bus Architecture identifying various business processes.
• Analyzed source system SABRE, GDS, CRM and historical information from Navitare and information from Traverse in the form of API’s.
• Involved in work allocation to resources and work monitoring.
• Designed star schemas for Guest, PNR and VCR.
• Created Logical and Physical data models.
• Help the resolve the data issues by interacting with the source system experts and the business users.
• Create data mapping documents and extract specification documents.
• Worked with C# Sharp and .Net developers and business users to identify the reports and cubes needed.
• Technical Project Lead with Strong hands on capability to move project from requirements gathering and design through implementation
• Provides project status updates to senior IT management
• Monitor the overall development process and made sure deliverables are on time.
• Metadata Management.

Environment: SQL Server 2005, Erwin 4.1.4, SSIS, SSRS, SSAS, MS Project 2003, Visio