SUMMARY:

• A senior level Information Technology professional with 11 years of experience in Data Architecture, Data Modeling (Conceptual, Logical, and Physical) Data Warehouse/Database Design, Reverse/forward Engineering, Data Management, Data Warehousing, Data Mart and Data Quality projects worked for government and non - government organizations. Successfully contributed and often played lead roles in Data Management, Data
• Quality Engineering, Metadata/Data Asset artifacts collection and management, Business glossary development and metadata repository population, Data Stewardship and Governance, PL/SQL development, Business Analyst, Data Migration, Data Mining, Data Staging, Generating Reports, Advanced Hyperion Essbase Developer, Fiserv Knowledge Share (Brio) developer. Pro-active, innovative and result oriented IT professional. Equally performs both as a team player and independently. Effective in work situations requiring an ability to manage multiple, concurrent and senior level projects and responsibilities.
• Create/maintain/review/approve Enterprise data models- logical, physical, conceptual and generated DDLs (data definition language) for database builds. Used reverse and forward engineering methods to export/import data models. Gather, review, and update business requirements to capture data requirements for reporting and business needs. Organized, attended, hosted JAD sessions to gather to define projects, business requirements, SOW (statement of work), tasks, resource requirements, discuss policies and resolve issues Standardization and governance of data models, artifacts, data architecture policies, data mappings, data flow diagrams, XML, data elements (entities, attributes, tables, columns, data dictionaries etc). Data attestation includes identifying authoritative source of data and maintains MDM (Master Data Management) which include
• Common data element or master data objects in UML. Developed complex SQL script using TOAD, SQL Developer, and PL/SQL to extract data, perform data analysis, data validation and audit. Worked on Data Governance Policies, wrote process document, metadata management policies and data standards.

TECHNICAL SKILLS:

Design/Modeling/Methodologies/Standards: ER studio, Erwin, Oracle SQL Developer Data Modeler, NIEM, XML, UML, AGILE, Water Fall, SOA, Relational, Multi-dimensional- Snow flake/Star schema etc.

Data mining/data quality: Oracle Data Profiling and Data Quality for Data Integrator, Trillium Software System

BI/Data warehousing/CRM: BRIO, KnowledgeShare, Hyperion Essbase, PowerShare (FiservInformnt), PL/SQL, Crystal reports.

Operating Systems: Windows, UNIX.

DBMS/Tools: Oracle, SQL Server, Sybase, MS Access, Teradata, SQL Developer, TOAD, SQL Plus Loader

Documentation & Presentation: PowerPoint, Word, Excel, Visio, MS Project.

Other Tools: Advanced MS Excel Macros, VBA Excel Add in, Serena Dimension (for Version control), Test Track (for defect or change tracking)

PROFESSIONAL EXPERIENCE:

Confidential

Senior Data Architect / Sr. Data Quality Analyst

Responsibilities:

• Analyze business and technical requirements and collaborate with subject matter experts, technical consultants, solution architects and developers to drive the design and development process of the database
• Assists in standardizing and managing data elements, includes working with multiple resources to achieve commonly defined and shareable data, as well as proposing and drafting data elements for standardization
• Created and setup data profiling jobs using Oracle Data Profiling and Data Quality for Data Integrator tool and produced reports for data quality highlights in areas such as completeness, uniqueness, referential integrity, frequency, range, cardinality and business rules validation checks.
• Responsible for developing metrics to track the overall integrity of data for the E-Form and FISM project ensuring compliance, accuracy and completion
• Developed complex SQL scripts for data validation/audit
• Evolve and manage enterprise data models ensuring they are viewed, interpreted and used in a consistent and effective manner and are integrated into the SDLC.
• Develop and maintain a formal description of the data and data structures, which includes data models and database designs, data flow diagrams and eXtensible Markup Language (XML) schema definition.
• Perform data cleansing based on requirement, business rule and data rules provided by subject matter experts (SME’s)
• Coordinate with business users and source system owners to derive business rules and data rules to be used in data quality assessments.
• Produce data assessment documents, data governance framework and process documents and present to ATF customers.

Confidential

Data Management Analyst

Responsibilities:

• Performed data management/data steward/data architect/data quality/ data analysis duties
• Reviews and approve logical, and physical database design using DOS data modeling tools(e.g.-Erwin),techniques, and agency standards
• Modify data models where applicable to reuse data elements from the standard enterprise data model
• Review and approve Data Definition Language (DDL) for new or updated database created by different departments at DOS
• Maintains the Enterprise Data Model, Support conversion/migration of systems, data bases, data marts, data warehouses to the enterprise data model
• Maintain MDM (Master Data Management) which include Common data element or master data objects in UML
• Maintains the Enterprise Data Model and the enterprise data repository
• Designed data governance process flow, wrote data management policies including metadata management, data standards, data quality policies, processes etc
• Interacted with government clients - Subject matter experts (SMEs), Business owners for different lines of businesses (LOBs) and upper management to develop, Data management and Data Quality standards, gather data quality report specifications, data warehouse reporting requirements
• Created logical model for state department metadata repository
• Used TOAD, SQL Developer, and PL/SQL for data extractions, analysis, Database development, lineage, data mapping and reporting
• Worked on data governance policies and wrote process document, metadata management policies and data standards
• Collected and validated business rules being implemented in the data warehouse and maintain metadata for the enterprise data warehouse
• Developed complex SQL scripts for data validation/audit
• Load Data into Enterprise Data Quality environment from multiple data sources in formats such as flat/ascii, Sql server backup, oracle backup, XML, MS access, MS excel etc.
• Managed metadata repository - Archived collected metadata, artifacts, ERDs, data dictionaries, design documents, data files etc.
• Developed data standardization rules for free form fields (names, addresses, phone numbers, SSNs etc) and Standardized data using Oracle data quality tool
• Created data models using Reverse Engineering technique in Erwin for meta data archiving

Confidential

Lead Data Warehouse Steward

Responsibilities:

• Worked as a senior Data Steward and performed duties such as writing reports, analyze profile and monitor enterprise data in databases/ data marts/data warehouses
• Perform data analysis on multiple systems and create as-is lineage, find problems with data flows both in physical and logical designs and provide “To be Lineage” which may be able to correct existing data flow issues
• Create/review/edit/analyze data mapping documents and data flow diagrams using MS excel, MS access and MS Visio tools
• Wrote SQL queries for ad hoc/batch data monitoring jobs, data analysis and scheduled jobs to run daily, weekly, monthly and setup email alerts
• Interview SMEs (subject matter experts) during the process of designing the EDW to understand multiple systems, data and processes while designing or re-engineering a system
• Interacted with operations - controllers, accountants and upper management to develop, Data management and Data Quality standards, gather report specifications
• Translated specs into code and verified data integrity; used Hyperion Essbase, Fiserv KnowledgeShare, SAS, PL/SQL, VBA, batch files, HTML, and schedulers for data extractions, analysis, and reporting; automation of routine Excel and PowerPoint reports using macros and VBA
• Produced accurate and timely overview reports for upper management, developed CBTs/ manuals, for data warehouse and trained data warehouse users, played active role in developing data warehouse and data conversion process.Prepare production data views for use by Authors, Analyzers and Viewers
• Manage Import of data into User Defined Tables in the warehouse as well as Export ofdata to be used by other Confidential applications
• Prepare, sponsor, and/or review Use Cases to document changes to Data Warehousecontent or processes as well as potential source system extract modifications
• Worked asan active participant in the appropriate Change Control process(es) for the revieand approval of - but not limited to - Views, Import/Exports and associated scheduling
• Work with Data Security to ensure data ownership and stewardship requirements areapproved and documented

Confidential

Senior Programmer Analyst/Report developer

Responsibilities:

• Created production reports from data warehouse (consisting of data from many source systems such as General Ledger, Commercial Banking, Retail Banking and mortgage) including data validation to source systems, development of logic, coding, and automation using Brio Knowledgeshare, SQL scripts, advanced excel macros, VBA, batch files, HTML, JavaScript, schedulers, and PDF writer
• Consulted with business area users to define and document usage and reporting requirements
• Developed and managed advanced reporting and analysis objects in the enterprise data warehouse
• Participated in communication meetings with SMEs, Business Owners and disseminate information to LOB point of contacts as appropriate
• Analyzed requirements in light of workable data structure including primary keys and foreign keys
• Worked with Fiserv Model Management to fit the data structure into the current schema
• Worked with both CCB and 3rd party programmers; to spec out files to be loaded to the warehouse
• Maintained release scripts which contain but are not limited to the following: Cutting a release, Compiling rules, Collection frequencies, Trending, and Metadata.
• Prepared and maintained the Business Requirements Lists (BRLs), Functional Specs, and Bill of Materials or other documents as required