OBJECTIVE:

Fully utilize and enhance my background in Database Administration, Business Intelligence Data Architecting, Project Management and Information Technology to help organizations get the most out of their technology investments. Leverage my overall business experience to help companies to design and execute business strategies and solutions.

SUMMARY:

• IT Enterprise Data Architect with over twenty (25+) years of cross - functional execution experience in strategic and tactical planning, business and technology including software development & quality assurance, infrastructure refinements, realization of operations improvement strategies, introducing new products, services and technologies.
• I have directed global technology implementations, Business Intelligence Solution, Data warehouse & Analytics solution, Development of complex applications and post-merger integrations for various companies including public sectors for example DMV, Bureau of Automotive Repair, Confidential, CA Lottery, California Department of Healthcare ( Confidential ) and Confidential of LA County.
• Out of 25 years of experience working in IT industry both in private (16 years) and public sector (9 years)
• I have played various roles as Dy. Manager, Enterprise Data/Application Architect, Business Intelligence Architect, DBA, Quality Assurance Lead, Technical Lead, Business Analyst, Project Manager, Operation Manager, Testing Manager and Application Development Manager.
• Over 25 years of professional experience in Advanced IT Application Software Architecture design, development methodologies, DevOps engineering, testing and implementation and management of projects.
• Extensive knowledge of/experience with data integration, data quality, and distributed systems integration.
• Sound understanding of cloud computing using publicly available services
• Sound understanding of application, server, and network security and compliance requirements such as HIPAA
• Excellent experience of leading or developing high quality, enterprise scale software products using a structured system development lifecycle
• Deep understanding of Enterprise Architecture principles, standards, and enterprise strategy development and well-versed in The Open Group Architectural Framework (TOGAF), the Zachman Framework, The Federal Enterprise Architecture, and Gartner methodology
• Expert in design and creation of a Decision Support Systems (DSS), Data Analysis & Modeling, Budget Forecasting Application, Development of Data Model (including Conceptual Model, Logical Model, Physical Data Model, Canonical Models, Messaging Models and Process Data Models), Data governance Policies, Data Audit policies, Data quality Policies and Data Retention Policies, Meta-Data Repository definition, Business Intelligence Modeling & Data Warehouse Architecture Design & Solutions
• Expert in building and articulating a data architecture and delivery roadmap indicating current, transition, and future state architectures, focused around clear benefits to both IT and business users
• Proven experience in architecture governance, controls, and peer reviews in regards to data, security, and cloud
• Experienced in developing architecture reference models for data governance and control
• Experienced in SOA, with a deep understanding of web services (XSDs, WSDLs) used within an Enterprise Service Bus
• Expert in Confidential DB2 (Mainframe and UDB), OBIEE, ORACLE 8i/9i/10g/11g/12c, SQL SERVER 2005/2008/2014 , MySQL, Sybase, Essbase/DB2 Analytics OLAP data administration, design, tuning, partitioning, security and modeling
• Experienced in performing data classification, and identifying storage platforms and hardware based on data requirements.
• Experienced in Customer Data Analysis, Predictive Analysis, Product and Price Analysis
• Expert in agile methodologies and waterfall modeling techniques
• Expert in ETL architecture & design, staging and hands on experience with tools like Oracle Data Warehouse builder (OWB), Informatica Power center, PL-SQL, SSIS, T-SQL, DTS package, Business Object Data Integrator etc.
• Expert in SQL, PL/SQL, SQL-Plus,, Microsoft T-SQL knowledge, creating and optimizing all database objects stored procedures, tables, views, triggers, indexes, user-defined functions
• Excellent experience in database administration (Installing, administering, clustering, performance tuning implementing and troubleshooting) for ORACLE 8i/9i/10g/11g/12c, SQL Server 7/2000/2005/2008/12/14 and DB2 UDB and Mainframe.
• Specialized in Business Intelligence Technologies & Data Warehousing tools like, OBIEE, Hyperion BI 9+ Suites including (Enterprise/Essbase Analytics, BI Interactive Reporting Tools, Web Analysis, and Hyperion Planning etc), MS OLAP (SSAS) Business Object XI, Actuate, Cognos Powerplay etc.
• Hands-on experience on Hyperion Enterprise application including monthly rollover support, implementation and configuration of Hyperion planning, EIS Analyzer, Reports, and Application Link.
• Strong experience in Database design and multi-dimensional modeling (star schema and snowflake schema), data cleansing, scrubbing and integration with tools like Erwin, Sybase Power Designer, Oracle Designer, Enterprise Architect, Microsoft Visio etc.
• Identification of facts, measures, dimensions and hierarchies for OLAP models.
• Hands-on expertise on creation and distribution of reports using Essbase Excel Add-In, Hyperion Enterprise Web based Reporting tool & Planning.
• Hands-on experience with Microsoft Active Directory Service, ADSI API, LDAP, Novel eDirectory etc., Networking
• Creation of reports for facilitating What-if Analysis, Forecasting, Budgeting, Financial Reporting and Analysis etc.
• Excellent communication, interpersonal, and leadership skills, with Team Lead and Solution Architect level roles.
• Hand-on-Experience in Project Management Methodology using Microsoft Project, Word, PowerPoint and Excel
• Experience of managing off-shore team, a team of 40 software engineers and more than 200 staffs
• Strong Function Experience in Finance, Budgeting, Heath Industry, Sales, Asset management, Content Management, inventory control management in Manufacturing industries

TECHNICAL SKILLS:

Hardware: Confidential PCs, Servers and compatibles

Operating Systems: UNIX, Red Hat Linux 5.2/7.2, Confidential -AIX, Sun Solaris

MS-DOS, Windows / 2000/2003/2008/ XP/7/8.1 and WinNT4.0:

Languages: Java, C & C++, JavaScript, JSP, VISUAL BASIC 5.0 & 6.0/VB.NET, C#, Visual C++, MFC, VBScript, HTML, XML, XSL, CSS, ASP, ASP.NET, .NET Framework, Python with Pointers, R

Databases: Oracle 8/8i/9i/10gR2/11g/12C, DB2 UDB, Sybase 11, Informix, MySQL, SQL Server 7.0/2000/2005/2014 , MS-ACCESS 2007/2013, Teradata, Netezza, Hadoop

BI Tools: Confidential Business Intelligence (Cognos), OBIEE , Hyperion BI 9+ Suites including (Enterprise Analytics, BI Interactive Reports, Web Analysis, and Hyperion Planning etc),Hyperion Essbase/DB2 OLAP Server, Analyzer, Crystal Reports/Analysis 10/11, Pivot Table, Hyperion Performance Suite (Brio), Hyperion Planning, Integration Server and SQL Server Analytic Services(SSAS)OLAP, Business Object XI, Actuate, Siebel Analytics, Microstrategy, Tableau

Data Tools: ORACLE Data Warehouse Builder (OWB), SQL Developer, PL-SQL, Informatica Powercenter, Transact-SQL (T-SQL), SQL Server Integration Services (SSIS), Data Integrator, SQL Plus, Rapid SQL, DB2 Control Center, DB2 Connect, TOAD, Data Mirror TS 6.0, MDM, Google Big Query, Cloud Storage, Cloud Data Flow, Amazon AWS

Data Modeling Tools: Erwin, ERStudio, Confidential Rational Data Architect ( Confidential Rational Rose), Enterprise Architect, Visio 2002/2003/2016 , Sybase Power Designer 9/10/11, RUP, UML, XML, SOAP, InfoSphere DATA Architect

Other Tools: Eclipse, RAD 7.54, TIBCO Business Studio, TIBCO Designer, MTS, ActiveX, SOAP UI, OOD, ADO, DAO, RDO, COM/DCOM, CDO, Web class, ODBC, Samba, Extra Office Client (Attachmate) 6.4, Shell Scripting, TCP/IP, HTTP, FTP, SMTP, NFS, Visual InterDev, FrontPage, Fireworks 4.0, Dream weaver 4.0, Photoshop 6.0, WMS 6.0, ClearQuest, Rational Robot, Mercury Load Runner.

Web Servers: IIS 3.0/4.0/5.0/6.0 , Apache, Tomcat, Confidential Web Sphere 6.1/7.0/7.5, Web-Logic, Oracle App Server

Business Applications: Microsoft Office / 2000/2007/2013/16 , Confidential Tools 8.14, and Seagate Crystal Reports, Market Vision, Microsoft Project, Word, Visio, PowerPoint and Excel, Business Object XI/4.0, Oracle ERP, Oracle CRM, EBS

Version Control Tools: Visual SourceSafe 6.0, ClearCase, CVS, Subversion 1.6

Messaging Tools: Confidential MQ 5.3 Server & Client, MS Exchange 2000 Server, and MS Outlook 2000/2002/2007/2013 , Lotus Notes 8.0/9.2

PROFESSIONAL EXPERIENCE:

Confidential, CA

Enterprise Business Intelligence Architect

Responsibilities:

• Data Governance at Enterprise Level
• Enterprise Database Management system
• Data Quality Management and Data Profiling
• Master Data Management (MDM)
• Metadata Management
• Business Intelligence Analytics and Enterprise Data Warehouse
• Maturity Model for Data Governance, Data Quality Management, Enterprise Data Management(EDM), Business Intelligence and Master Data Management
• Design patterns and best practices for data and the integration of data through the enterprise
• Reference architecture, and roadmap for Business Intelligence and MDM
• Collaborated with leadership and management to develop and execute enterprise data strategy, including the architecture and development of master and reference data management capabilities
• Documented end to end data flow and prepared conceptual and logical model for BI application.

Confidential, CA

Enterprise Data Warehouse Architect

Responsibilities:

• Responsible for providing program and project management for IT operations, systems and network engineering, data center operations, software selection, software design and development, technical, or functional management support on CEDAR projects
• Led as a member of a development team to provide business data requirements analysis producing conceptual, logical and physical data models, using a Erwin tool to fully document and maintain models and ensuring integration into existing data architectures
• Performed source system analysis, identification of key data issues, data profiling and development of normalized and star-snowflake physical schemas
• Played various roles on Projects that required Data warehouse Consulting which include Data Warehouse Enterprise Data & ETL Architect, Project/Program & Technical Lead
• Led design reviews with Client and participate in Data Warehouse & ETL and reporting requirements meetings
• Managing database monitoring tools, examining performance metrics and functionality of databases, and tuning the database to ensure optimal business user experience.
• Development of database strategies to maintain highest database quality and continuously meet necessary functionality for the business
• Designing and creating database structure (logical design) partnering with development teams for business partner data and requirements analysis
• Utilizing the logical design to develop the physical database design, and creation of the highest performing, optimized database
• Collaboration with developers post-implementation for quality control assurance; and to ensure developer understanding of data and access methods
• Directing and executing physical database changes required by applications.
• Maintaining database schema’s and data descriptions in Data Dictionary
• Establishing, creating, and maintaining business continuity, and disaster recovery policies, procedures, and plans; creating and facilitating test case scenario of all backup/recovery planning
• Partnering with users to determine, and develop data models for user reporting needs, and ad-hoc reporting based on queries; eradicating existing user data misuse or user data conflicts
• Responsible for DBMS and other database related tools including end to end planning, management and execution of upgrades.
• Planning and coordinating database security measures in order to maintain data integrity
• Set the strategic direction for data use policy and defined the data governance model.

Environment: : AIX 7.1, Redhat 6, Windows 2008/2012, Erwin, InfoSphere Data Architect (RDA) MDM, Erwin 9.6, UML, Microsoft Project/Visio 2013 , Oracle 11gR2/12C, SQL Server 2008/2012/2014 , Oracle Data Integrator (ODI) 11GR2, OLTP, OLAP, RAD, SVN, Rational Enterprise Architect, TOAD, SSL3.0, Vault system for 11GR2, HIPPA, HDWF, PL-SQL, ETL, SQL Developer, MySQL, Oracle SOA, B2B engine, Agile Development Methodology, Java/J2EE, Python, SQL, Data Warehouse, Enterprise Data Architectural Modeling, MITA 3.0, SIMM, Hadoop, Oracle CRM

Confidential, Sacramento, CA

Data Architect

Responsibilities:

• Defined and designed strategies to provide enterprise-wide information capabilities for Confidential
• Aligned and designed the plans to meet enterprise-information requirements and provides enterprise data flow diagrams.
• Assisted in evaluation of technologies for new data capabilities and application software for the enterprise.
• Aligned information architecture with enterprise architecture by selecting appropriate tools and techniques to capture this information.
• Documented roadmaps transition strategy from current to new architecture, including integration from current data and information systems
• Developed migration and cut-over strategies and policies
• Migration: Migration of Application, Security System and databases across the Operating Systems like AIX, Solaris, Linux, Windows.
• Migration of Database server, application server, ETL (Informatica) server, reporting servers etc.
• Directed solutions requiring integration of multiple platforms, operating systems, applications, and databases across the enterprise to reduce costs and improve information flows
• Installation, Upgradation and Configuration of 10g/11g Database Server Administration tools like OEM and EM controls
• Designed and implemented high availability solution for our client running in Oracle10g/11GR2 using Oracle Real Application Clusters (RAC) and RMAN.
• Oracle Database Installation, Design, creation and configuration, allocation and maintenance of rollback segments, tablespaces, data files, redo log files, mirroring of redo log files and control files across multiple disks and multiple instance maintenance.
• Facilitated discussions between groups of IT and business partners at different levels; recognize issues of conflict and inconsistency between data requirements and pursue a resolution of these issues
• Developed a consolidated enterprise information architecture for shared data with client and business partners
• Installed and configured Business Objects 6.5/XI/XIR2/XIR3.1, CMC with Infoview, Deski, Webi
• Migrated all Business Objects reports and configured BO clusters.
• Performed system integration tasks for various applications and servers
• Managed and coordinated hardware remediation for failed components for database and application servers
• Set up multi-site DR clusters performed Data backup / replication using SAN Replication
• Developed high-level database architectures and ensured that database designs are consistent with Enterprise architecture and information management standards as well as industry standards.
• Led as a member of a development team to provide business data requirements analysis producing conceptual, logical and physical data models, using a Erwin tool to fully document and maintain models and ensuring integration into existing data architectures
• Developed Hierarchical modeling and dimensional modeling constructs; and maintained the Data Warehouse Bus Matrix Architecture;
• Responsible for coordination among enterprise data governance, data custodian, data stewards, data analyst, data and system architects
• Developed and Maintained Data Mapping documents, Bus Matrix and other Data Design artifacts that define technical data specifications and transformation rules
• Design and govern data services messaging constructs in XSD format.
• Performed source system analysis, identification of key data issues, data profiling and development of normalized and star-snowflake physical schemas
• Performed data quality audits on Confidential data for inconsistent data, incomplete data, business rule violations, incorrect data, etc.
• Performed Customer Data Analysis, Predictive Analysis, Product and Price Analysis.
• Provided in-depth technical consultation to clients and IT management to ensure development of efficient data models, ETL model, data policy, data governance
• Responsible for development of plans and strategies for data management processes, Data warehousing, Decision Support Systems (DSS), Business Intelligence & Analytics using OBIEE, Business Object Reporting tools and programs and provided direction and consultancy.
• Installed and configured Imperva Security Audit system for all databases (29) and applications
• Installation and configuration of Imperva Agent on all database servers
• Installation and configuration SSL certificate on database server and Imperva servers
• Led various large-scale or highly complex database auditing, logging and management activities including:
• Designing highly complex logging and monitoring processes for databases
• Developing Security audit log policy and implantation of Imperva audit system
• Developing management policies, procedures and standards
• Business requirements identification, analysis and development.
• Providing mentoring, guidance and general oversight to less experienced staff in a variety of database logging and monitoring
• Administration of DB auditing activities.
• Developed a consolidated enterprise information architecture for shared data with client and business partners
• Developed and implemented IT and System Architecture for CRM and OBIEE application
• Planning implementation of Disaster recovery plan through real-time SAN replication
• Day to day support to operation and maintenance of the system
• Upgrade of Business Objects clusters.
• Managed data security for reporting and analysis data structures
• Established processes and recommend tools to ensure data quality
• Measure key performance indicators to assist with operational and strategic planning
• Provided training and assistance to users with data analysis and reporting functions
• Managed data dictionaries and data definitions
• Maintained catalogs of dat a sources an d data mappings
• Maintained catalogs of reports and analysis tools
• Work with Microsoft SQL Server/DB2 and Oracle database technologies
• Work with application data, including Rebate accounting systems and other financial systems
• Troubleshoot and optimize relational and OLAP databases
• Installed and configured Confidential Cognos BI Reporting tool

Environment: : AIX 6.1 , Solaris 8/9/10, Redhat 5.5, Windows 2003, InfoSphere Data Architect (RDA), Erwin 7.3, RUP, UML, Microsoft Project/Visio 2007 , DB2 (Mainframe), DB2 UDB 9.5, Oracle 8i/9i/10gR2/11gR2,SQL Server 2000/2005/2008/2012 , OBI, Informatica 8.5.1/7.1.1 , Autosys 4.0/5.0 RAD, SVN, Rational Enterprise Architect,, Window 2003 (ADS), WebSphere 6.1, TOAD, Business Object 6.5/XI/XIR2/XIR3, Confidential Cognos 10.2, Microsoft SQL Server Integration Services (SSIS). SSL3.0, TDE, Vault system for 11GR2, OLAP, OLTP, Python, MITA 3.0, SIMM, Seibel Analytics and CRM

Confidential, Sacramento, CA

Application/Data Architect

Responsibilities:

• Developed and designed software implementation strategies for WSI (website infrastructure) involving web portals, SOA, data management, management dashboard, collaborative environments, and content management systems
• Responsible for developing and managing multiple projects/programs leading the overall data quality and data integrity across platforms and enterprise models.
• Worked primarily with Database Analysts, Business Analysts, Database Administrators, DMV Data Architects and application development teams supporting the development WSI projects.
• Participated in development of plans and strategies of data management processes and programs and provided direction and consultancy on data architecture topics.
• Facilitated improvement solutions by working with all levels across enterprise to determine database technology solutions that align with Business strategies, IT strategic directions and compliance objectives.
• Led as a member of a development team to provide business data requirements analysis producing logical data models, using a CASE tool to fully document and maintain models and ensuring integration into existing data architectures.
• Facilitated discussions between groups of IT and business partners at different levels; recognize issues of conflict and inconsistency between data requirements and pursue a resolution of these issues.
• In corporate project models into a master model by comparing and reconciling differences to achieve a consistent integrated view of the whole business information requirements.
• Ensured adherence to data modeling guidelines, best practices and Standards.
• Led and conducted the necessary research and analysis on projects to identify and promote the reuse of existing standards, as well as the identification and development of new data standards.
• Assessed industry standards for information/data models with existing modeling standards, and where appropriate incorporated them into DMV information architecture standards.
• Defined a Meta-Data strategy to describe and administer data, and provide data lineage tracking ability and Data Life Cycle Management
• Developed and maintain data interoperability standards and interfaces
• Developed processes for data migration and integration between systems
• Contributed with standardizing the definition of data for reuse across the enterprise and works with application development and business partners to establish and maintain consistent data domain and data element definitions across lines of business.
• Established and applied the principles of data management - to develop a consistent, integrated, non-duplicated business-wide view of information and data to meet short and long term business requirements so that systems are developed which will require minimized maintenance and re-development in the future.
• Provided full hand over of the logical data model to the application development teams, as well as the DBA for the physical design and database build work.
• Led and participated in peer reviews of completed data models and plans to ensure quality, and identify alignment opportunities across portfolios or regions.
• Analyzed the requirement, business rules, use cases, and object models and developed Conceptual, Logical and Physical Enterprise Data Models and delivered it to project team.
• Developed Software detailed design document for entire application including Security Model, LDAP Architecture (ADSI), Layer 7 SOAP XML Gateway
• Developed and maintained Business Information Model and Data Flow Architecture for the various business domains within the organization.
• Developed data management strategy and process around data governance, custody, stewardship and security
• Defined and identified reference data, and provided strategy and process to harmonize Master Data creation and access across the enterprise
• Provided data validation, verification and reconciliation strategies
• Defined processes for Data Virtualization, using Service-oriented technologies.
• Collaborated and communicated with team members in other areas of IT like Java UI team, Data Administration, and Infrastructure team
• Data Mapping from UI layer to Service to Daas and Database layer for WSI application
• Development of a centralized data dictionary
• DB2 SQL Explain Plan Analysis and performance tuning
• Source Data Analysis and Data Profiling
• Transitioned Physical Data Model to Mainframe DBA.
• Coordinated with DBA in design and implementation of the Database.
• Performed system integration tasks for various applications and servers
• Managed and coordinated hardware remediation for failed components for
• Database monitoring, backup and performance tuning, installation and configuration of RAC, RMON etc.

Environment: : AIX 5.3 , InfoSphere Data Architect (RDA), Erwin 7.3, Enterprise Architect, RUP, UML, Microsoft Project/Visio 2007 , Microsoft Word/Excel/PowerPoint 2007, DB2 (Mainframe), DB2 UDB 9.5, Oracle 10GR2, TOAD, TIBCO Business Studio & Workflow, RAD, SVN, Rational Enterprise Architect, Visual Explain Plan for DB2, Window 2003 (ADS),SQL Server, WebSphere 6.1, Web-Logic, ALU Publisher, SecureSpan XML Gateway, Oracle EBS

Confidential, Phoenix, AZ

BI Architect/Performance Analyst

Responsibilities:

• Assisted in Installation and configuration of Hyperion BI Suites
• Involved in Development of BI conceptual, Security, Component, Hardware Architectures
• Integration of Hyperion BI suites with Microsoft Active Directory Service for single sign-on authentication
• Configuration of ODBC connectivity for Essbase Analytics and BI Servers.
• Clustering of Print Servers and BI Repositories (Oracle Database)
• Assisted in Creation of Essbase Application, Cubes and Rules
• Performance tuning of Essbase Analytics, and Decision Support Systems (DSS),
• Performance Tuning of BI Server with JVM parameters
• Capacity planning for Essbase and BI servers.

Environment: Sun Solaris 5.10, Redhat Enterprise 5.1, Windows 2003 Server (ADS), Hyperion Enterprise BI 9+ Suites, Hyperion Finance Reports, HFM, Planning, MDM, Essbase Analytics, ORACLE 10G , PL-SQL , TOAD, Hyperion Essbase Analytics, Integration Services, Confidential Websphere 6.1

Confidential, Sacramento, CA

BI Solution/Data Architect

Responsibilities:

• Created and delivered workshops for BI opportunities in the Lottery
• Developed BI business opportunity matrix
• Development of BI conceptual, Security, Component, Hardware Architectures
• Designed Business Intelligence Readiness Review Model and analyzed the readiness.
• Development of Conceptual (ER & Dimensional)Data Model
• Architecture of ETL process including Staging Architecture
• Source Data Analysis and Data Profiling
• Developed policy for Data Governance and data quality and metadata management.

Environment: Microsoft Project 2003, SQL Server 2005, SSIS, T-SQL DB2 (Mainframe), TOAD, Erwin, Microsoft Office, Visio

Confidential, Sacramento, CA

Solution/BI Data Architect

Responsibilities:

• Development of BI conceptual, Security, Component, Hardware Architectures
• Designed Business Intelligence Readiness and Decision Support Systems (DSS) Review Model and analyzed the readiness.
• Designed and developed system design document
• Defined the business rule and use cases with interaction with business users.
• Development of Conceptual and Physical (ER & Dimensional)Data Model
• Architecture of ETL process including Staging Architecture
• Preparation of project, Test case development and Test Execution plan
• Coordination of development team, infrastructure team, Business Users and QA team.
• Design and development of Performance/Functional and System Integration Testing Strategy for Data warehouse, and reporting system.
• Wrote complex test queries and developed procedures, functions, packages and triggers
• Integration of BI system with Microsoft Active Directory Services for single sign-on.

Environment: Microsoft Project 2003, Hyperion BI 9+ Suites, OBIEE, Windows 2003 Server, ORACLE 11G, PL-SQL, Oracle Designer, TOAD, OWB, Essbase Analytics, Sun-Solaris, Oracle App Server

Confidential, Torrance, CA

BI Data Architect

Responsibilities:

• Defined the business rule and use cases for Decision Support Systems (DSS) with interaction with business users.
• Development of Conceptual and Physical (ER & Dimensional)Data Model
• Architecture of ETL process including Staging Architecture
• Preparation of project, Test case development and Test Execution plan
• Coordination of development team, infrastructure team, Business Users and QA team.
• Design and development of Performance/Functional and System Integration Testing Strategy for Mainframe, Data warehouse, and reporting system.
• Source Transaction Data Process Analysis and Data Cleansing
• Wrote complex test queries and developed procedures, functions, packages and triggers

Environment: Microsoft Project 2003, Hyperion BI 9+ Suites, Windows 2003 Server, ORACLE 9i/10g, PL-SQL,, Informatica Power Center 7.1/8.3, Oracle Designer, Rational ClearCase, Clarity, People soft 8.9, DB2 (Mainframe), TOAD, WINSQL, Redwood Scheduler, RUMBA, Lotus Notes, Data Mirror TS 6.0

Confidential, ROSEVILLE, CA

BI Data Architect/Teach Lead

Responsibilities:

• Managed and deployed the Confidential Business Intelligence Initiative and Decision Support Systems (DSS) Project successfully.
• Defined/authored Software Requirement Specification documents for releases of Business Intelligence Project. Work closely and collaborate with members of other product development organizations to provide cross-product integration for new features. Documenting details on how each feature was to be implemented and how it would fit within the current product offerings, taking into account Development resources available.
• Collaborated with the Hyperion, Oracle and Confidential Sales team for procuring the software.
• Responsible for System architecture (Including Hardware) & design analysis KSI, Sales Metrics, Subscribers Metrics and ADP(Advance Drop Placement) Revenue Assurance Metrics Reports, Dimension & OLAP Model
• Development of Conceptual and Physical (ER & Dimensional)Data Model
• Installation and configuration of Hyperion BI 9+ Suites (Enterprise Analytics, Interactive Reporting, Shared Services, Admin Services, Integration Services, Web Analysis, Reporting Metrics etc)
• Architecture of ETL process including Staging Architecture
• Source Transaction Data Process Analysis and Data Cleansing
• Development & deployment of OLAP Cubes
• Development of Load Script and loading and monitoring of Hyperion Analytics Server
• Migration of Old cubes on new system

Environment: Microsoft Project 2003, Redhat Linux, Hyperion BI 9+ Suites, Windows 2003 Server, SQL Server 2005, ORACLE 10g, PL-SQL,, ORACLE DATA WAREHOUSE BUILDER (OWB-10gR2), Erwin, People soft 8.9, Genesys (Local Proprietary System), Sybase 11 Database, Verisign, TOAD

Confidential, CA

BI Data Architect

Responsibilities:

• Responsible for architecture & design analysis ODSBI Reports & OLAP Model
• Development of Conceptual and Physical (ER & Dimensional)Data Model
• Installation and configuration of Essbase OLAP Server, Admin Server, Integration Services, Analyzer, Hyperion Performance Suite 8.5
• Creation of custom ETL process
• Source Transaction Data Process Analysis and Data Cleansing
• Data Gap Analysis, data reconciliation and consolidation
• Creation of physical database schema and population of tables
• Development & deployment of DB2 OLAP Cubes
• Development of reporting strategies with Analyzer and HPS.
• Development of Load Script and loading and monitoring of Essbase OLAP Server

Environment: Confidential -AIX, DB2(Essbase 7.1.5) OLAP, ORACLE 9i/10g, PL-SQL, Analyzer(7.2), ORACLE DATA WAREHOUSE BUILDER, Erwin, Essbase Hub, Essbase Integration Server 7.1, Hyperion Performance Suite (HPS), TOAD, Pivot Table, Excel-Ad-Ins for Essbase

Confidential, Rochester, MN

BI Solution/Data Architect

Responsibilities:

• Responsible for architecture & design analysis
• Development of Conceptual and Physical (ER & Dimensional)Data Model
• Installation and configuration of SQL Server 2000, MSOLAP, Essbase OLAP Server, Admin Server, Integration Service & Analyzer
• Source(Lawson) Transaction data Process Analysis
• Data Gap Analysis, data reconciliation and consolidation
• Lawson & DB2 schema mapping
• Creation of custom ETL process
• Development & deployment of DB2 OLAP Cubes
• Development of Reporting strategies
• Implementation of log shipping, data replication and configuration.

Environment: DB2 Connect, DB2 OLAP server 8.2 (Essbase 7.1.2), ORACLE 9i, PL-SQL, Confidential -AIX, Analyzer(7.1), DB2 Mainframe/UDB Database, Erwin, Lawson, Crystal Report 10/11, Crystal Enterprise 11, Crystal Analysis 10/11, Essbase Integration Server 7.1, Hyperion Planning, Rapid SQL 7.3,, Business Object XI, Business Object Data Integrator, SQL server 2000, MSOLAP, MDX, Pivot Table, Excel-Ad-Ins for Essbase, Web Sphere, Tomcat