QUALIFICATIONS

Accomplished, analytical Information Technology Architect with 13 years experience in delivery of quality Data Warehouse, Business Intelligence, Data Architecture services and solutions. Key achievements include implementing 9 Data Warehouses, 20 Data Marts, Master Data Management MDM and Metadata Repositories with Service Oriented Architecture SOA . Established high quality Data Architecture standards/services/policies, Data Governance process, Metadata management techniques, Model for Data Lineage and Championing importance of Single Version of Truth . Astute troubleshooting skills, able to discover areas of deficiency and utilize problem-solving acumen and automation processes to streamline operations, cut costs, and accelerate results. Excellent cross-level communication and interpersonal skills, easily performing liaison role between customers and IT professionals, ensuring clear communication and viable resolutions. Expertly managed high-profile clients, including Federal Home Loan Bank, CIT, Wellpoint, and Oracle. Dedicated, hard-working, and handles stressful situations with proven composure.

TECHNICAL SKILLS

PROGRAMMING LANGUAGES: JAVA, C, C , Pro C, Basic, PL/SQL, HTML, XML, UNIX Shell.

DATAWAREHOUSE TOOLS / GUI, ERP: Kalido, Business Objects XIR2, Webi, BO Data Integrator, BO Performance Manager, Composer, Data Integrator, Informatica, DataStage, Metastage, QualityStage, Cognos-PowerPlay, Impromptu, Transformer, MicroStrategy, Discoverer, Sagent Data Mart Suite, PL/SQL, SQL Plus, SQL Loader, Complex Oracle queries, Oracle Analytics, PowerBuilder with PFC, PFC, VB 4.0/5.0/VC . VB, Microsoft Office Word, Excel, Project PeopleSoft, Oracle Apps, SOAP.

RDBMS: Oracle 7.x/8.x/9i/10g, DB2 UDB, Sybase, SQL Server, SQL 2005, MySQL,

MODELING: Logical, Physical, Normalized, Dimensional Modeling using ERwin, Embarcadero, Power Designer, Designer, Visio, UML Rational Rose

METHODOLGIES: SOA, Agile, ESB, OLAP, OOAD.

OPERATING SYSTEMS: Windows 95/NT/2000/XP, Solaris, HP UNIX, AIX.

Work Summary

Senior Business Intelligence Architect

Confidential

• Re-Engineered current process, integrating data from various source systems into Kalido Data Warehouse and removing spreadsheet based data movement within the organization.
• Established periodic compliance audits reviews performed daily compliance supervision.
• Created a Reference Data Management System, Designed Master Data Management for subject areas such as Party, Arrangement and Product. Designed and developed the MDM Application based on SOA to serve to/from the Master Data Repository with other applications.
• Worked with client manager for project/resource planning. Worked with management for establishing goals, expectations Data Governance and fostering data management culture.
• Designed model for Metadata Repository and Data Lineage.
• Fostered Data Management and Architecture culture promoted data integrity and reuse at all levels.
• Guided for rapid ETL development with first iteration getting released in 3 months
• Convinced management of the need for Enterprise Logical Model which would be used for Master Data, Data Warehouse DW , Data Management DM , and for creating any new application system. Created and maintained Conceptual, Logical and Physical Model through out the project.
• Adhered to and refined data standards, policies ensuring SOX compliance.
• Performed source system data analysis, cleansing, data profiling and metadata management.
• Conducted JAD sessions and meetings with users, management and developers to review models.
• Responsible for logical architecture of data and metadata from data entry, usage, persistence and exit from organization.
• Wrote Complex Oracle PL/SQL programs, utilities, and reports using Oracle analytic functions.
• Created Business Objects Universe and Webi reports using materialized views and merge statements.
• Developed CBE's, Transaction Data Sets, File definition, Reference Data Load, Query Definitions, and Model Master using Kalido DW.
• Designed ETL mapping in Business Objects BO Composer in collaboration with ETL team.
• Created and maintained Change Control Process trained power users on reporting tool.
• Assisted in QA and user acceptance testing trials fixed issues raised during testing.

Confidential

Sr Data Architect / Consultant

• Created DW for Capital Finance from requirements gathering to implementation gathered financial data of Leasing Business and implemented standards and policies for implementing DW and DM.
• Reduced development time 20 by using experience in implementing Data Warehouse.
• Promoted data integrity and reuse at all levels of the organization adhered to and refined data standards ensuring SOX compliance.
• Performed source system data analysis, cleansing and data profiling.
• Designed and developed the Reference Data Application based on SOA to serve to/from the Master Data Repository with other applications.
• Created and maintained conceptual, logical and physical model throughout the project.
• Responsible for all activities related to the logical architecture of data, metadata and its lifecycle from data entry into the organization, usage, persistence, and exit from the organization.
• Wrote Oracle PL/SQL programs/utilities, reports using Oracle analytic functions

Confidential Sr Data Architect / Consultant Continued

• Collaborated with ETL team on ETL Architecture created ETL mapping documents and wrote ETL Code in Oracle PL/SQL to load data from DW to DM.
• Implemented physical model for DW and DM in collaboration with DBA.
• Collaborated with vendor to ensure compatibility of data model with Business Objects universe.
• Created DW Website to facilitate all teams in HTML and ASP.
• Managed team of 4 personnel and directed client relations conducted full operations training from investments insurance to financial tax planning.

Confidential

Senior Data Architect

• Created an end state operational model for Claim Processing System based on ANSI Standards which handles 500,000 claims per day designed, created and maintained logical and physical data models.
• Collaborated with users and IT Business Analysts on requirements definition and applications design.
• Realized physical data structures working with database administrators and object-oriented modelers.
• Employed modeling techniques that ensure adherence to modeling standards.
• Created or provided input to the creation of accurate and appropriate project plans.
• Completed work assignments by deadlines agreed upon by incumbent and management.
• Ensured policies regarding technical guidelines and change management processes were followed.
• Analyzed data sources using data profiling tool.

Confidential

Lead Data Architect

• Created end-state-Logical / physical data model for Integrated Credit Reporting System ICRS project which gathered credit exposure information from 16 different source systems to create a central data warehouse.
• Educated Business Users and Executive Managers on Enterprise Data warehousing Process.
• Designed and developed the Reference Data Application based on SOA to serve to/from the Reference Data Repository with other applications.
• Lead a team of 4 data modelers and facilitate group meetings.
• Created the logical / physical dimensional data model.
• Collaborated with ETL team in the definition of the data collection, transformation, distribution, and loading of the ICRS data model.
• Collaborated with DBA team in the deployment of the physical model.
• Created, maintained, and collaborated on the use of enterprise metadata such as Business rules, Entity, Attribute definitions, transformation, and mappings.
• Adhered to and refined the Union Bank of California data policies, standards, and procedures.
• Managed data model needs through the ICRS project development lifecycle.
• Ensured user satisfaction with ability to retrieve data from data model by working with partners interfaced with technical lead to ensure stability and growth potential of data model and database.