SUMMARY:

• Confidential is an experienced Business Analyst and an Enterprise Data/Information Architect with over 15 years of progressive experience focusing mainly on Business Intelligence (BI), Data Analysis, Data Modeling, Data/database Architecture, Data Mining, Data profiling, Database Administration, and Data Facilitation.
• He currently performs as the Enterprise Data Architect working directly for the Confidential Chief Architect supporting the Agency’s Enterprise Architecture.
• His recent notable accomplishments include Analysis of Confidential ’ Enterprise Data Warehouse and adjacent data sources and developing a logical Data Model for the entire Enterprise.
• Noted as major successes at the Confidential, he has been tasked to perform the same task for the Confidential Geospatial Management Office (GMO). Through his Commercial and Federal Experiences, Confidential is able to bring a multi - dimensional perspective to solving Data related challenges. He is well versed in using industry leading tools and has experience and domain expertise such as CRM, ERP, and Siebel to name a few.
• Over 15 years of progressive experience focused on Information Architecture, Data Governance, Data Analysis, Data Modeling, Data/Database Architecture, Data Quality, Data Mining, Data profiling and Data Facilitation.
• Experienced Information / Data Modeling Architect, Data Modeling (Logical, Physical, Star Schema, etc.) and proficient with tools such as ER-Win, IBM Rational Dara Architect, ER Studio Data Architect, Designer 2000.
• Technology expert providing CxO consultation for IT investment recommendations through Risk Assessment and ROI Evaluation.
• Experienced in complex ETL, Data Analytics, Data Transformation, Data profiling & Standardization.
• Conducted Market Analysis/Survey of Enterprise Architecture Tools specifically Mega, SPARX, Adaptive, Troux, Alphabet and IBM System Architect by interviewing the vendors and analyzing the Data collected using techniques like Rank Score Analysis etc.
• Excellent communicator with diverse experience working closely with Senior Business and Technology Stakeholders and supporting Project Teams at various organizational levels and technical capabilities.
• Used Finance Decision Criteria like NPV, Payback Period, IRR to evaluate projects

TECHNICAL SKILLS:

Domain Expertise & Solutions: CRM, ERP, Siebel 7 Certified Professional, Application Development, Database, Design, Data Modeling and Integration, Data Conversion, Data Migration

COTS packages: Siebel, SAP, CRM, ERP, Data Modelling (ER-Win, ER Studio, etc.)

Databases: Oracle 6,7,8,9i,10g, 11g, Microsoft SQLServer, TeraData, UDB DB2, Access, InformixColumnar database - SAP HANA

Operating Systems: Windows, UNIX Linux

Trained in: DataWarehouse, Informatica, Business Objects, Data Stage, Cognos, Brio

Programming Languages & Tools: SQL, PL/SQL, Perl, PowerBuilder, UNIX Shell Scripting, HTML, VB Script, C, JavaScript

Other: ClearCase and ClearQuest, MS Office

EA Methodologies: TOGAF, Zachman Framework, FEA, Common Approach

PROFESSIONAL EXPERIENCE:

Manager Enterprise Data Architect

Confidential

Responsibilities:

• Managed the requirements gathering and vision elaboration for the Data Strategy underpinning the Forest Service Enterprise Architecture
• Led multiple Joint Requirements Development sessions with C level and senior leadership at Forest Service and affiliated offices and agencies (NRM, NASS etc.)
• Led Analysis of alternative initiatives for selection of technologies and products such as Data Quality, Data architecture, data modeling and EA Management and repository tools. This included conducting Market Research of Third Party Data Architecture tools like ER-Studio Data Architect from Embarcadero, IBM InfoSphere Data Architect etc. using techniques like Rank Score Analysis (RSA).
• Developed Forest Service wide, Enterprise Information Architecture Conceptual and Logical Data models Integrating several Enterprise wide Transactional Data Assets as well as Logical models for several Business Intelligence-related Data Assets.
• Led the Data Domain initiatives of the EA Data strategy for Forest Service and supported other domains to include development and maintenance of:
• Enterprise Architecture Project EA Roles, Responsibilities and Skill Plan"
• Enterprise Architecture Project Governance Plan
• Enterprise wide Forest Service Logical and Conceptual Data Design
• Enterprise Architecture Project Communications Plan
• Enterprise Architecture Project Risk Management Plan
• Enterprise Architecture Project QA Plan
• Enterprise Architecture Project EA/CPIC Integration Plan
• Business Analysis
• Data Quality
• Data Integration
• Master Data Management
• Meta Data Management
• Business Intelligence
• Enterprise Reporting
• Dashboards & Analytic
• Business Process Engineering and
• Business Rules Development
• Data Modeling
• Data Lineage
• Content Management
• Data Delivery

Confidential, VA

Lead Data Architect Manager

Responsibilities:

• Responsible for collecting data elements for MDM (Master Data Management) and also making sure that Meta Data information is complete in the modules worked. The RDBMS used on the project was Oracle 11g.
• Managed the Data needs analysis, strategy and vision efforts for CDR project.
• Led multiple Joint Requirements Development sessions with senior Directors and Vice Presidents of several divisions.
• Managed and Led the Data Architecture and Data migration and ETL teams.
• Developed Data Architecture Technical Design documents and Naming Standards pertaining to corporate CDW related to mortgages
• Defined and Developed Designs to support departmental and functional data marts.
• Provided thought leadership in the Data Architecture, modeling and physical database development and naming standards.
• Led the team in the review of database structures of proposed business application purchases.
• Worked closely with analytical and reporting infrastructure teams to ensure operational and analytical data warehouses were able to support all business requirements for OLAP reporting across the organization.
• Assisted in the design and administration of the corporate Metadata Repository.

Confidential, VA

Lead Data Analyst Manager

Responsibilities:

• Managed the Reverse engineering of the ETL tool code ( Informatica) into the BRS (Business Rules Spreadsheets)
• Led the Development of the Business Requirement documents consisting of Use Cases after conducting several requirements gathering sessions with various stakeholders including C level leadership and senior management teams.
• Conducted joint requirements planning sessions to obtain requirements and developed logical data models
• Delivered about 100 BRSs which included Fact and Dimension table business rule spreadsheets.
• Performed Data Analysis, Data Profiling & Validity, Data cleansing rules etc. DB2 & SQL Server were the RDBMS.
• Developed mapping spreadsheets that will provide the Data Warehouse Development (ETL) team with source to target data mapping.
• Mentored junior team members

Confidential, Wilmington, DE

Lead Data Analyst/Data Modeler

Responsibilities:

• Led the team in the identification of business users to Define Requirements and develop Use Cases.
• Defined corporate metadata definitions for all Enterprise Data supported databases (operational source systems, data stores and data marts).
• Managed the Performance of Data Analysis, Data Profiling & Validity, Data cleansing rules etc.
• Led the Development of mapping spreadsheets that will provide the Data Warehouse Development (ETL) team with source to target data mapping.
• Led the team in Profiling data in EMPOWER used as a LOS (Loan Origination System) from LPS (Lender Processing Services)
• Led the Data Warehouse Development (ETL) team to research and define existing source to target mapping for the corporate Data Warehouse.
• Developed logical and physical data models that document source data from multiple sources (Client’s internal data systems, external source data systems, 3rd Party Data, Prospect Lists, etc.).
• Defined and developed designs to support departmental and functional data marts. Provided input to data modeling and physical database development standards with the Data Modeling Team. Assisted in the review of database structures of proposed business application purchases.
• Worked closely with analytical and reporting infrastructure teams to ensure operational and analytical data warehouses were able to support all business requirements for OLAP reporting across the organization.
• Assisted in the design and administration of the corporate Metadata Repository.
• Managed the team in Maintaining the Enterprise logical and physical data models, reflective of current environments.
• Took the Responsibility and initiative to make sure that all the data elements used were in line with the MISMO (Mortgage Inductry Standards Maintenance Organization) standards.
• Created an Opportunity to Play with a cutting edge technology from SAP America - Columnar database - SAP HANA

Confidential, New Carlton, MD

Lead Data Warehouse Analyst

Responsibilities:

• Led the Review of project requirements analysis.
• Led the Design and Development of an ETL Data Strategy to perform environment and system integration & validation; including ETL using Informatica, Java Data Access, and web services technology.
• Conducted JAD sessions and Requirement gathering meetings with users, stakeholders, and subject matter experts to define and document Data Modeling requirements.
• Lead and Manage Metadata, Data Dictionary and Data governance efforts. Database used was Oracle 11g.
• Managed and coordinated deployment and testing effort for system integration and user acceptance testing.
• Managed the Support, creation and execution of ETL and Database test cases in each environments and release in the iterative development lifecycle
• Conducted Walk through of Transformation rules document and the test cases to reflect these rules were being tested.
• Led Physical and Logical Data Modeling using IBM Rational Data Architect (RDA) case tool
• Conducted Reverse Engineering of the Physical and Logical Data Model from the transactional database using Data Architect (RDA) case tool
• Provided project management support during SIT.
• Attend daily and weekly SCRUM meetings to track progress and help in issues resolution.

Confidential, Washington, DC

Data Modeler & SQL Server DBA

Responsibilities:

• Conducted Evaluation of Data Integration and Business Intelligence-related technologies like Informatica, Microsoft SSIS, OBIEE, Business Objects, Cognos etc.
• Developed Business Requirement documents consisting of Use Cases after conducting several requirements gathering sessions with various stakeholders.
• Physical and Logical Data Modeling using ER-Win Data Modeler
• Database (Oracle 11g) Table partitioning to improve performance
• Routine Database support including Data refresh, data model, database synchronization etc.
• Responsible for Data Dictionary, Metadata definitions
• Performed Data Model walkthroughs with project stakeholders and peer review with other Data Modelers
• Support development team with resolution to Database issues
• Support Informatica Development/Developer

Confidential, Anapolis Junction, MD

Data Analyst

Responsibilities:

• Confidential designed database model for System of Record (SOR), Data Migration routines and functions. Provided SQL scripts as part of these modeling effort which involved end to end testing and validating the data migration rules written by the ETL developer.
• Incorporated details for additional scenarios for each of the above mentioned test cases.
• Performed GUI testing to make sure that data was being displayed in the application forms correctly and worked with the team of Java developers to fix bugs found.
• Reverse Engineered the Physical and Logical Data Model from the transactional database tool - Centralized Screening Gateway (CSG) database using ER-Win case, arranged the entities in logical groups and provided a physical data model to the development team and data administration team.
• Wrote SQL scripts and helped in the scrubbing of Personally Identifiable information (PII) for security reasons.
• Designed, developed and tested migration of documents and letters (appeals, waiver request etc.) into the CSG system.
• Supported the development team with database issues such as user access/privileges for SQL and PL/SQL errors etc.
• Worked briefly on the reports management system (RMS), an Oracle OBIEE based Data Warehouse project to house the investigation program statistics.
• Provided assistance to OBIEE architecture and upgrade activities to OBIEE 11g.
• Attended Oracle OBIEE 11g boot camp by Oracle Corporation in Orlando, FL.
• Delivered an updated Centralized Screening Gateway (CSG) data dictionary.

Confidential, Fairfax, VA

Data Modeler

Responsibilities:

• Reviewed BUCRS(Use Cases) & FRs to understand requirements and business processes
• Collaborated in JAD & design sessions with the stake holders
• Developed Conceptual, Logical & Physical ER-model for the project
• Designed Siebel thick client Objects & Siebel Partner Portal objects in Siebel Tools. Helped with screen mockups
• Helped with Siebel database Schema extensions
• Designed Siebel Correspondence Templates
• Team Lead: Managed a team of five off-shore Siebel Development resources during Design and Analysis phase of the project.
• Responsible for the issues and risks management and resolution
• Responsible for Data Modeling for Conceptual, Logical and Physical models for PCR follow up and completion
• Responsible for the review of DADs (Data Applet Design Documents), Operational Level Processes and business requirements.
• Responsible for managing and designing of Siebel Business Components
• Responsible for updating the PMO with Consolidated weekly Status.
• Participated in requirements gathering and design sessions with the client.

Senior Software Data Analyst/Modeler

Confidential, Compusearch, VA

Responsibilities:

• Gathered data oriented requirements by coordinating with design, development team.
• Performed detailed Data Analysis, Data Profiling, and Data Quality checks
• Created Logical, Physical data models in Oracle 10g
• Performed Back-end testing using SQL Queries in ORACLE
• Tested the application manually by executing Test Cases
• Performed Black Box testing to check the accuracy of Data Structures
• Prepared test data for positive and negative test scenarios for functional testing as documented in the test plan.
• Used HP Quality Center
• Exposed to Siebel Analytics (OBIEE) on the project

Confidential

Manager and Data Architect

Responsibilities:

• Designed and developed a data migration strategy and a detailed design document to migrate Legacy (Agent X) data into Eagle One, specifically products, accounts, service requests, employees and list of values.
• Data Analyst for the Siebel team, collected requirements as to what AS-IS entity should be mapped to what entity in the Siebel Data model (the To-BE system), helped with data mapping at the BC field and column level.
• Developed SQL scripts to extract data from the legacy system and populate staging tables.
• Developed Oracle stored procedures and packages to push data from staging tables to Siebel EIM tables.
• Coached, mentored and lead a small team of junior Developers
• Designed and developed Control Files to load data from external systems into Siebel EIM tables.
• Designed and developed Configuration files to run EIM processes (Export, Import and Delete) for various entities.
• Executed EIM jobs to migrate products, accounts, service requests, employees and list of values.
• Performed Data modeling for the tables affected using ERWIN 4.1, built logical and physical data models.
• Analyzed log files to fix data errors while migrating reference entities.
• Co-ordinated with DBA's with respect to performance tuning, building of indexes, increasing tablespace and rollback segments.
• Co-ordinated with Siebel TAM to finalize and fine tune some of the EIM processes.
• Tracked software requirements, defects and issues via the use of Mercury Quality Center
• Helped in the process of Statement of Work and contract creation to secure new and follow-on work

Confidential, Harrisburg, PA

SQL DBA (Data Migration & Data modeling)

Responsibilities:

• Responsible to help with the data migration effort from their fifty desperate systems into a single database of the FileNet system. The RDBMS being used for the To-Be system is SQL Server.
• Helping out in the requirements gathering (BA - Business Analyst) and testing efforts.
• DBA activities and ETL of Data using DTS packages.
• Performed Data modeling using ER-Win. Built & maintained a Logical and Physical Data Model of the entities and Tables used
• Database creation and management
• Database Backups and Recovery, and SQL Performance Tuning
• Managing database and object security
• Study and Analysis of Legacy Main Frame systems, SQL Server Databases, Access etc.
• Extensive T-SQL scripting for Data cleansing, massaging, Migration Activities
• Wrote stored procedures for Data Migration. Conversion Activities
• Used Visual Studio 2003 for data validation and exception handling
• Developed several DTS packages for data migration.
• Developed Data Migration initial plan document
• Studied data models of various source systems, to get a good understanding of the system and business rules.
• Prepared Entity Mapping documents between the source and destination entities.
• Built & maintained a Logical and Physical Data Model, used ER-Win 3.5 case tool
• Designed a high level plan of action and time line required for the data migration effort.
• Helped in designing a Data Mart for Marketing Campaign.
• Wrote DTS packages to migrated look up tables data from source to destination tables.
• Wrote Transact SQL and Visual Basic code/scripts as part of migration tasks.
• Used DTS (Data Transformation Services), a Microsoft SQL SERVER native ETL tool to extract, transform and load the data from more than thirty source databases to a single destination database.

Environment: SQL Server 2000 and 2005, Windows Server 2003, Visual Studio 2003, ER Win 3.5

Confidential, Vienna, VA

Siebel Administration/Data Architect

Responsibilities:

• Assisted in the Upgrade/Migration of Siebel 6 to Siebel 7.
• Cleaning up the Siebel Repository.
• Installed Siebel Server, Siebel database Server, Gateway Server, Siebel client, Siebel Tools etc.
• Mapping of data from legacy system to Siebel Interface tables
• Performed Data Modeling (ER-Win) and data mapping as the change of phases took place.
• Created extension columns to accommodate the client’s business requirements.
• Used EIM to perform various imports and merging of data related to Opportunities, Contacts, and Products.
• Worked with Oracle DBA in fixing the Data errors occurred while running EIM
• Fixed bugs in the existing system and also helped in enhancements of the system.
• Responsible for schema changes as per the business requirements.
• Configured prototype with selected functionality to demonstrate to the steering committee.
• Developed specifications for each stage of business process to create / customize necessary pplets, views and screens.
• Set up development and testing environment by installing Siebel Tools and Client.
• Created new views and applets using existing business components and business objects.

Confidential

Siebel Developer

Responsibilities:

• Date Mapping of the clients current system to the Siebel Marketing Campaign System.
• Maintaining and updating Entity Relationship diagram using ER-Win Case Tool.
• Built a Logical and Physical Data Model.
• Comparing the client’s requirements to the functionality in Siebel application - identify new and reusable object definitions.
• Designing Siebel Reports prototypes and developed the same in Actuate as per the clients requirements.

Confidential

SAP Consultant

Responsibilities:

• Responsible for studying the client's Business scenarios, developing To-be processes and mapping each To-be process with a SAP process.
• Carried out SAP Configuration to meet the Business requirements and identified GAPs and prepared the Functional Specifications.
• Configured and customizes SAP applications to TO-BE specifications especially SAP HR Benefits.
• Familiar with ABAP4 programming.