SUMMARY

• Total 13 years of IT experience in the Analysis, Design, Development, Testing, Implementation and Support for Online Transactional Processing (OLTP), Service Oriented Architecture (SOA), System of Record (SOR), and Datawarehousing analytical processing (OLAP, ROLAP, MOLAP) projects with various industries.
• Over 8 years of Data Architecture experience for OLTP, SOR, and Datawarehouse system using Star and Snowflake Dimensional Modeling, Third Normal form Business Logical and Physical data modeling, with 5 years of experience in Metadata Management and Master Data Management (MDM).
• Around 10 years of experience in designing and developing solutions using ETL Methodology/Tools, and BI Reporting Tools for SOR, ODS, OLAP and OLTP Systems.
• Around 8 years of programming experience using PL/SQL, UNIX Shell Scripting (K Shell, Bourne Shell, K Shell, BASH), SQL*Plus, ISQL, TSQL.
• Experience in Unified Modeling Language (UML), Object - Oriented Analysis and Design (OOAD), Java, .NET, SOA, web services and enterprise service bus implementation.
• Excellent communication skills, good team player with superior interpersonal and analytical skills.

TECHNICAL SKILLS

Data Modeling Tools: ER Studio, Erwin, Oracle Designer, SQL Data Modeler

ETL Tools: Accentual Data Stage, Informatica PowerCenter/PowerMart, SQL*Loader, Integrity, MetaRecon, Orchestrate Parallel Extender, Ab Initio.

Reporting Tools: Microstrategy, Cognos, Business Objects, Brio, Seagate Crystal Reports, MS Access Reports, Web Focus.

Database: Oracle, DB2, Sybase, MS SQL Server, MS Access, Teradata, Netezza

Programming Languages: VB, XML, VC++, VBA, JAVA, J2EE, VB Script, JAVA Script, UML, SQL, TSQL, PL/SQL, XML, ISQL, Perl, UNIX Shell Script.

Operating Systems: Windows NT, Sun Solaris, HP-UX, IBM AIX

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

Senior EDW/Data Architect

Responsibilities:

• Developed the Enterprise Data warehouse (EDW) and Shared Services conceptual design for functional areas.
• Partnered with Business users in defining reporting needs, key performance indicators (KPIs), conducted end user interviews to discover the intelligence analytics for various functional areas like HR, Transpotation, IT metrics, Real Estate, and Tax.
• Designed EDW architecture, data aquistion methodology and shared services solution to the TW management.
• Established the enterprise Informatica ETL and Business Objects (BO) Reporting architecture, standards and data blueprint, physical and logical standards, physical database design, and architecture guiding principals.
• Designed the enterprise datawarehouse and shared components for Human Resources, Financial, Transportation and Logistics, Real Estate, Tax, Business Continuity Planning, IT Metrics using Ralph Kimball Dimensional Methodology including Conceptual, Logical and Physical Data Model.
• Identified the Master Data Management (MDM) components for HR, Vendor Management System, Location, Product. and designed the strategy to implement MDM.
• Established procedures to plan progress of master data, metadata and ensured the reduction of data redundancy and fragmentation, effective data sourcing, enhanced data quality, data integrity, scalability, flexibility.
• Developed data flow and process flow diagrams for various functional areas like HR, Tax, Transport Logistics.
• Reviewed data models and established approval process for data models review ensuring proper use, reuse of master entities, shared reference, and transaction across functional areas.
• Developed the Security standards for different users groups like power users, central users, executives to user access at module, entity, row and attribute level in the respective functional areas.
• Designed reusable ETL components, flexible and scalable functional area BO Universe .
• Reviewed and approved the low level ETL and reporting design, ETL code, Business Objects reporting objects defintion, report design.
• Designed the reporting environment to suit the end user need canned /Ad Hoc Reports using Business Objects, Web Intelligence, Crystal Reports and Crystal Xcelsius tools.

Environment: ErWin r8, Informatica 9.1, Business Objects 4.0, Netezza 4.5, Oracle 11g, SSIS, SQL Server 2008.

Confidential, Storrs, Connecticut

Enterprise Data Architect

Responsibilities:

• Developed the Data warehouse and Reporting Strategy and roadmap dat encompass using simple and robust architecture and design methodology for Financial Data Mart.
• In Depth requirements analysis covering wide range of needs for financial reporting system.
• Established Universal Data Policy, Standards and the technical solution for the management, storage, access, navigation, movement, and transformation of university financial data.
• Developed the Data warehouse Strategy dat includes reporting data warehouse using simple and robust architecture and design methodology for Financial Data Mart.
• Designed the Universal Financial System (UFS) Conceptual, Logical Data Model and Physical Data Model for subject areas like General Ledger, Financial Processing, Capital Asset Management, and Budget Construction.
• Established measures to chart progress related to completeness and quality of master data, metadata for university enterprise information, to support reduction of data redundancy and fragmentation, elimination of unnecessary movement of data, improvement of data quality, data naming standards, data integrity and information taxonomy, reviewed data models and established approval process for data models review.
• Put in place CFO, budget office, procurement data governance processes around meta-data, approval workflow, to ensure an integrated definition of data for enterprise information, and to ensure the accuracy, validity, and reusability of metadata, also designed and developed data flows for various subject areas including invoicing.
• Consolidated existing 7000 reports to around 400 reports, including recommendation of converting reports to improved format, dashboards, scheduled reports and ad hoc capability.
• Created Dimensional data model using Organization, Object, Project, Vendor Dimensions, General Ledger, Labor Ledger, and Accounts Payable Accumulated Snapshot Facts.
• Designed the ETL architecture, created source to target mappings and developed coding standards for subject areas like General Ledger, Labor Ledger, Budget Construction, converting legacy FRS data to Financial Mart.
• Defined indexes, partitions, views to improve the performance of Financial Data Mart.
• Established Security standards for different users groups like power users, central users, executives to user access at module, entity, row and attribute level.
• Performed Performance tuning of Stored Procedures, SQL Queries, and ETL Code.

Environment: SQL Data Modeler 3.0, Data Stage 8.1, Web Focus 7.6, Unix AIX v7, Oracle 11g, DB2 Mainframe.

Confidential

Enterprise Data Warehouse Strategy Architect

Responsibilities:

• Broad analysis of business requirements to warranty for completeness of technical solution and enterprise direction on data conversion to information and technical architecture.
• Established the enterprise strategy and architecture roadmap for Sales, Financial, and Inventory.
• Established data blueprint, domain based business taxonomy, data standards, physical database design, architecture guiding principals and design.
• Developed the conceptual, logical and physical data model, data flow and process flow for quote to cash involving data like products, destinations, plants customers and transactions like jobs, quotes, order and tickets.
• Designed and developed the dimensional data model for Sales Data Warehouse using Ralph Kimball Star Schema approach in Star schema.
• Ensured the reusability of facts and dimensions in the core OBIE model Sales Datawarehouse and created customized facts and dimensions based on Quote to Cash Business Process.
• Established the ETL architecture, standards, and design for quote to cash subject area involving transaction processing like jobs, quotes, order and tickets.
• Involved in designing the dashboard to generate reports for forecast, sales rep performance, top customer, customer attrition and so forth.

Environment: Erwin r7, Informatica PowerCenter 8.6, OBIEE 11g, Oracle eBS, Unix AIX v7, Oracle 11g, SQL Server 2007, DB2 Mainframe.

Confidential, Phoenix, Arizona

Enterprise Data/Data Warehouse Architect

Responsibilities:

• Involved in designing the enterprise data and data warehouse Strategy and architecture, metadata magangement and developed a roadmap to create and maintain a robust data infrastructure across different business capability like Products, Campaigns, Score, AI, MRM, Loyalty Campaign, Package, and Rebates Rewards BI Platforms..
• Designed and Developed the Marketing Resource Management (MRM) Reporting Conceptual, Ralph Kimball Dimensional Model (Star Schema Data Mart), dat encompasses business process like budgeting, campaigns, purchase order and invoice. Developed Open AI Partner dimensional data model (Snowflake Schema Data Mart) to integrate partner information in Open AI datawarehouse, and Rebates and Rewards..
• Involved in designing the enterprise data federation architecture and prototyping "data federation" systems across enterprise master and transaction information reviewing and refactoring, harvesting data and application frameworks using patterns, enterprise bus architecture, and Service Oriented Architecture (SOA).
• Established enterprise data administration standards and processes for data model and repository management, and the publishing of metadata through the ERStudio Portal.
• Designed and implemented the enterprise Master Data Management (MDM) for Package and Product Manager for Market Data, Equity and Security data and then leaning into Product datawarehouse and also set the standards for various source data acquisition, harmonization, retention, establishment, and approval.
• Developed the data flow diagrams to represent enterprise view of Product, Marketing, to Customer Acquisition.
• Classified and Assigned Domain Based Business Taxonomy to enterprise data domain logical models.
• Ensured data profiling, data validation, data mapping validation, Data Migration and source to target mapping for Enlist to Package data migration project. Ensured legal and compliance in Data disclosure, good data quality, reusability, integrity, accountability, scalability, excellent data definitions to entities and attributes, XML schema development, canonical data models and verification for SOA.
• Designed the data flow diagrams and involved in designing the ETL architecture for Package ODS and AI Partner data warehouse, Event Manager, Interactive Excellence portfolios.
• Performed tuning and SQL query optimization for reporting queries, and stored procedures.
• Involved in designing cubes, ad hoc and canned reports for Rebates and Rewards, and Package.

Environment: ER Studio 7.6/7.1, Java 1.5, .NET 3.5, Data Stage 8.0/7.5/7.0, Informatica 8.6, DB2 IMS / UDB 9.2/8, Oracle 10g, Unica, MQ Series, OBIEE 10G (Siebel Analytics), Microsoft Visio, Cognos 8, Microstrategy 9, IBM AIX 5, Teradata v12, MS SSIS.

Confidential, Phoenix, Arizona

Senior Architect

Responsibilities:

• Extensive requirements gathering and analysis for replacement of the legacy system dat gathers medical-related data. Designed new system with improved workflow, metrics, and outcomes, better integration with state system of record, and improved data and technical architecture.
• Converted business into technical requirements for Fact Matching and Drug System.
• Designed and implemented the in bounding and out bounding Fact to Fact Matching, Fact to Dimension, Within Dimension Matching, QCPE and Projections processing systems.
• Designed the data flow diagrams and process flow diagrams for System, File definition and receipt process, Matching process for Drug, and HCE with heavy data processing needs.
• Designed the Matching system using Object Oriented Analysis and Design.
• Reviewed test cases with the business, and also involved in smoke testing, accepting testing.

Environment: ERWin 7.2/4.0, Java 1.2, Data Stage 6.5/ Informatica 7.1, Oracle 10g, Business Objects 7.0, DB2, UDB DB2 8, IBM Linux 2.6, Mercury Test Director, Teradata v2R5.

Confidential, Philadelphia, Pennsylvania

Senior Data Warehouse Architect

Responsibilities:

• Responsible for developing the implementation strategy for SBNR, Intra corp and Producer.
• Involved in discovery sessions to collect information about FACTS, IMAGE, and ICS source systems and performed extensive data profiling on the information contained in those systems.
• Designed logical, physical and dimensional data model for Producer book of records and data mart respectively on Image Commission, Producer and Policy information.
• Developed and designed the Logical and Physical Data Model for the Producer Book of Records, and Dimensional Model, and Data Load Process for source systems like FACTS, IMAGE, and ICS.
• Designed the Intra corp Vendor Information System dat provides claim information to vendors.
• Developed and established high-level data flow diagram, data standards, and naming conventions and evaluated the consistency and integrity of the model and repository.
• Performance tuning for ETL code, and SQL query optimization.
• Designed the process automation and its execution through TWS and UNIX scripting.
• Involved in Producer Online Reporting System design for creating different types of reports like Dashboard summary, list report etc for Producers and Sales.

Environment: ERStudio 3.0, Informatica 7.1, Oracle 9i, MS SQL Server 2000, DTS, Quality Stage, Brio 5, UDB DB2 8, IBM AIX 5, Microsoft Project, Win NT, Mainframes MVS OS/390, Test Director.

Confidential, New York

ETL/Data Architect

Responsibilities:

• Defined the strategy, technical architecture, implementation plan and developed reusable design patterns. Reviewed high-level designs and recommended solutions for project design problems.
• Hands-on experience in full system development life cycle (SDLC): JAD sessions facilitation, assessing user’s needs, analysis, planning, scheduling, systems design, programming, quality assurance, documentation, project implementation, and customer support.
• Designed a logical and physical data model for the Usage ODS with programming specifications to integrate legacy data from multiple in-house systems like PCH, TVPP, etc. dat allowed users to dynamically create classification of sub sampling rules in order to run wat if analysis.
• Managed the development of Member Area for B2B, I2I, and B2I, across multiple operational systems.
• Responsible for integrating data across multiple projects in EWR, Entitlements, Agreements.
• Analysis of requirements and translation of these requirements into dimensional data models. Defined metadata standards and directed the metadata capture and access efforts. Other tasks include naming standards, data analysis and profiling, and develop high-level data flow diagram.
• Prepared ETL standards, naming conventions and ETL process flow documentation.
• Tuned stored procedure, PL/SQL Scripts, and Datastage jobs for better performance and extensively worked with their components for Data cleansing and Conversion.
• Responsible for assuring quality through formal test plans and software inspections.
• Defined the production release requirements and sustain architecture.
• Developed UNIX scripts to execute jobs and screen door programs for data and file validation.
• Evaluated database server's hardware and software and involved in allocating and planning current and future system storage requirements.

Environment: ERStudio 3.5, IBM Data Stage 7.5 (Manager, Designer, Director), Oracle warehouse builder (OWB) Crystal Reports, MS SQL Server 2000, DB2 UDB, Oracle 9i, IBM AIX 5.0, Java WebSphere Administration.

Confidential

Data Analyst/Programmer

Responsibilities:

• Gatheird business scope and technical requirements and interacted with management to identify key dimensions and measures for business performance.
• Involved in defining data transformation rules and identifying required data sources and fields.
• Designed the workflow process to migrate the data between departments.
• Interacted with end users to identify data issues in SAP for Bill of Materials and Material Master.
• Involved in design, analysis, implementation and support of Processes flows and ETL standards.
• Extensively developed stored procedures and Datastage jobs including performance tuning and used Parallel Extender (Orchestrate) for parallel execution.
• Developed PL/SQL and UNIX shell scripts, data import conversions and cleansing routines.
• Performed Manual, Smoke and Regression Testing of ETL code and esnure its integrity.
• Optimized the performance of the mappings, tuned PL/SQL scripts and database performance.
• Creating primary database storage structures and primary objects (tables, views, indexes).

Environment: Informatica 6.0 PowerCenter, MetaRecon, Ascential Data Stage 6.0, Parallel Extender (Orchestrate), Integrity, Cognos Power Play 7.0, Oracle9i/8i, IBM AIX 4.5.