Enterprise Business Intelligence Architect Resume
CA
OBJECTIVE:
Fully utilize and enhance my background in Enterprise Data Warehouse (EDW), Database Administration, Business Intelligence Data Architecting, Enterprise Application 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:
- Over 25 years of professional experience in Advanced IT Application Software Architecture design, development methodologies, DevOps engineering, testing and implementation and management of projects.
- More than 7 years of experience in Software support, operation and development for Healthcare industries with clients including California Department of Healthcare Services(DHCS - CAMMIS) and DHS of LA County, Confidential, Anthem Confidential
- Deep understanding of Enterprise Architecture principles, standards, and enterprise strategy development and well-versed in The Open Group Architectural Framework (TOGAF), EABOK, EACOE, the Confidential Framework, The Federal Enterprise Architecture, and Confidential 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 ( Bill Inmon (Top Down) & Kimball( Bottom-up), Hybrid and Federated approach) & 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 developing architecture reference models for data governance, controls, and peer reviews in regards to data, security, and 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
- Experienced in complex migration plan and designing cut-over strategies and policies
- More than 18 years of experience with Data Warehouse and Business Intelligence systems; extensive experience for collecting business requirements from customers, and transforming the requirements into data processes and data schemas.
- Excellent knowledge of understanding of a wide variety of analytical processes (governance, measurement, information security, etc.)
- Extensive experience providing technical direction on information and analytics platforms in conjunction with EDW tools and technologies.
- Expert in project management, Information Technology Infrastructure Library (ITIL), Agile methodologies and waterfall modeling techniques
- Sound knowledge of Confidential departments, operations, and administrative processes including knowledge and prior experience with State Administrative Manual (SAM), Statewide Information Management Manual (SIMM), The Medicaid Information Technology Architecture (MITA) as they pertain to state IT projects.
- Expert in Microsoft SQL SERVER 2005/2008R2/2012/14/16, ORACLE 10g/11g/12c, IBM DB2 (Mainframe and UDB), OBIEE, MySQL database administration (Installing, administering, clustering, performance tuning, partitioning, implementing and troubleshooting), design, security & audit and logical & physical modeling
- Vast experience on Extraction, Transformation and Load (ETL) strategy, architecture & design, staging and implementation including ETL across different platforms for VLDB databases and flat files with tools like, SQL Server Integration Services(SSIS), Oracle Data Integrator (ODI), Informatica Power center, Power Exchange, PL-SQL, T-SQL, DTS package, Business Object Data Integrator, Pentaho Integration Services, IBM DataStage
- Experience on Meta data definition, implementation and maintenance, new business rules identification and implementation to data rules and maintaining data quality, data profiling
- 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 SQL, PL/SQL, SQL-Plus, Microsoft T-SQL knowledge, creating and optimizing all database objects stored procedures, tables, views, triggers, indexes, user-defined functions
- Specialized in Business Intelligence Technologies & Data Visualization tools like, OBIEE (11g, 12c), Oracle Hyperion BI Suites including (Enterprise/Essbase Analytics, BI Interactive Reporting Tools, Web Analysis, and Hyperion Planning etc.), MS OLAP (SSAS), SSRS, SAP Business Object XI/3.0/4.x, Tableau, Pentaho Business Analytics & Reporting Services, IBM Business Intelligence (Cognos)
- Strong experience in Database design and multi-dimensional modeling (star schema and snowflake schema, normalized and de-normalized models; handling “slow-changing” dimensions/attributes: Kimball methods), data cleansing, scrubbing and integration with tools like CA Erwin, Infosphere Data Architect (IDA), Sybase Power Designer, Oracle SQL Developer Data Modeler, Sparx Enterprise Architect, Embarcadero ERStudio, Microsoft Visio etc.
- Hands-on experience with Microsoft Active Directory Service, ADSI API, LDAP, Novel eDirectory etc., Networking
- Sound knowledge of Computer Security fundamentals, security and encryption methodologies, compliance, access control, and governance requirements, including encryption algorithms and standards, AES/GCM, HSMs, key management, IAM, MFA, SSL/TLS, NIST & SOX
- Experienced in Oracle Enterprise Service Bus, Oracle B2B, SOA, Oracle Application Integration Architecture (AIA) methodologies, Clustering, files and WebServices
- Excellent Language skills to read, analyze, and interpret general business periodicals, professional journals, technical procedures, or governmental regulations, to write reports, business correspondence, and technical specifications and to effectively present information and respond to questions from groups of managers, internal team members, and vendors
- Extremely strong in analytical and problem-solving skills and to work effectively across internal & extremal functional areas.
- Excellent communication (verbal, written, and visual presentation skills), interpersonal, and leadership skills with the ability to develop cohesive working relationships with internal and external clients
- Hand-on-Experience in Project Management Methodology using Microsoft Project, Word, PowerPoint and Excel with ability to manage multiple deliverables in a highly energized and fast-paced environment within a framework of constantly shifting deadlines and deliverables
- Experience of managing off-shore team, a team of 40 software engineers and more than 200 staffs
- Strong Functional Experience in Media streaming, Govt. Sector, Healthcare Industry, Banking, Finance, Budgeting, Sales, Asset management, Content Management, inventory control management in Manufacturing industries
TECHNICAL SKILLS:
Hardware: IBM/HP/DELL PCs, Power Servers, Virtual Servers and compatibles
Operating Systems: UNIX, Red Hat Linux 5.2/7.2, Centos, IBM-AIX, Sun Solaris, Oracle Linux, Oracle Solaris, OS X, Z/OS, MS-DOS, Windows XP/7/8.1/10, Windows Server 2000/2003/2008 R2/2012R2/2016, WinNT
Programming Languages: VISUAL BASIC 6.0/VB.NET, VBA, Visual C#, Java, JSP, NodeJS, Spring, EJB, C & C++, Visual C++, MFC, ATL, HTML, XML, XSL, CSS, ASP, ASP.NET, .NET Framework, Python, PHP, R, Perl
Scripting Languages: PowerShell, JavaScript, VBScript, Perl Script, Bash Shell, Zsh, C-Shell, OS X script, other Unix Shell Script, JASON (Java Script object notation)
Relational Databases: Oracle 8/8i/9i/10gR2/11gR2/12C, SQL Server 2005/2008R2/12/14/16, DB2 UDB & Mainframe, Sybase 11/12, Informix, MySQL, MS-ACCESS 2007/2010/2013/2016, PostgreSQL 9.x
MPP Databases: Teradata, Netezza, Amazon Redshift, Oracle Exadata, HPE Vertica, Microsoft PDW (Parallel Data Warehouse)
OLAP Databases: Microsoft OLAP Services, Oracle Hyperion Essbase Analytic Server, DB2 OLAP Server, Cognos Power Play, IBM Cognos TM1, Oracle Database OLAP Option, MicroStrategy Intelligence Server
NO SQL Databases: MongoDB, Hbase, DynamoDB, Azure DocumentDB, Couchbase, Cassandra, CouchDB, Vertica
Big Data and Tools: Hadoop, Map Reduce, Spark, Scala, Hive, Presto, Oozie (workflow scheduler), Flume (Distributed Log collection), Cloudera
Cloud Platform: Microsoft Azure Cloud Services, Microsoft Azure BI Stack, Amazon Web Services (AWS), Amazon Simple Storage Services (S3), Amazon Elastic Compute Cloud (EC2), Google Cloud, Google BigQuery, Google Compute Engine, Google App Engine, IBM CAL Cloud
ETL/ELT Tools: Oracle Data Integrator (ODI 11g/12c) & Warehouse Builder (OWB), Informatica Powercenter & Power Exchange 5.x/7.x/8.x/9.x/10.x, SQL Server Integration Services (SSIS), SAP Business Object Data Integrator, Hyperion Essbase Integration Services, IBM DataStage, Pentaho Data Integration Services
BI Reporting Tools: OBIEE 11g/12c, Hyperion BI Suites including (Enterprise Analytics, BI Interactive Reports, Web Analysis, Analyzer, SmartView, Financial & SQR Reports, and Hyperion Planning etc.), IBM Business Intelligence (Cognos), SAP Crystal Reports/Analysis 10/11/12/2013, Pivot Table, Hyperion Performance Suite (Brio), Business Object XI/3.x/4.x, Microstrategy BI Reporting Services, Tableau (9.x/10.x) Data Visualization, Microsoft SQL Server Reporting Services (SSRS), Microsoft Power BI Desktop, Microsoft Power BI Gateway, Power BI with Microsoft Excel, Pentaho Business Analytics and Reporting Services
Data Tools: Informatica (MDM, IDQ, IDD and Metadata Management services 9.x/10.x), IBM Infoshere MDM Service, Microsoft MDM and Data Quality Services, Data Profiler, SQL Developer, TOAD (for Oracle database, IBM DB2, MS SQL Server and MySQL), PL-SQL, Transact-SQL (T-SQL), SQL Plus, Rapid SQL, DB2 Control Center, DB2 Connect,Tivoli Monitoring and Backup Services, RMAN, Data Guard
Modeling Tools: Erwin, Embarcadero ERStudio, Sparx Enterprise Architect, Visio 20072013/2016, Sybase Power Designer 9/10/11/15/16, IBM Rational Data Architect (IBM Rational Rose), RUP, UML, InfoSphere DATA Architect, Open System Architect, Toad Data Modeler, Archmate Modeling, Open ModelSphere, Oracle SQL Developer Data Modeler, Informatica ActiveVOS (BPM), SQL Power Architect, Oracle BPM Suite 12c
App Dev Tools: Microsoft Visual Studio, Eclipse, Oracle JDeveloper, IBM Rational Application Developer (RAD), TIBCO Business Studio, Informatica Designer, Visual InterDev, ODI Designer
DevOps Tools: Bamboo, Oracle Primavera, Ansible, Docker, Gradle, Jenkins, Maven, Mesos, Microsoft Visual Studio Team Server, JIRA
Web Servers: Microsoft Internet Information Server (IIS), Apache Web Server, Tomcat Web Server, IBM WebSphere Server 6.1/7.0/7.5, Oracle Web-Logic Application Server, JBoss Application Server
Business Applications: PeopleSoft CRM and Tools, Lawson CRM Suites, Oracle E-Business Suite (EBS), SalesForce, Guidewire Insurance Suite, PolicyCenter & ClaimCenter, Cerner EHR Suites, Affinity EHR, Oracle ERP & CRM, Siebel Customer Relationship Management (CRM) Applications, Microsoft Office (Project, Word, Visio, PowerPoint and Excel) 2007/2013/16, Market Vision, Apache OpenOffice
Version Control Tools: Git, Microsoft Team Foundation Services, Subversion (SVN) 1.7, ClearCase, CVS, Visual SourceSafe 6.0 (discontinued), AccuRev
Messaging Tools: IBM MQ Server & Client, Microsoft Exchange Server, and Microsoft Outlook 2013/2016, Lotus Notes 8.0/9.2, Sametime, Microsoft Lync
Testing Tools: HP (Mercury) Load Runner, Rational Robot, Jasmine, Rational ClearQuest, IssueTrak, TestTrack, Impact Issue Tracking Suite
Other Tools: Oracle SOA, Tivoli Identity Manager (TIM), Tivoli Access Manager, Imperva Security Audit, VMWare, OpenBox, MTS, ActiveX, SOAP UI, OOD, ADO, DAO, RDO, COM/DCOM, CDO, Web class, ODBC, JDBC, JDK, Samba, Extra Office Client (Attachmate) 6.4, TCP/IP, HTTP, FTP, SMTP, NFS, FrontPage, Adobe Fireworks, Adobe Photoshop, Webex, Skype, TeamViewer, Adobe Acrobat and its APIs
PROFESSIONAL EXPERIENCE:
Confidential, CA
Enterprise Business Intelligence Architect
Responsibilities:
- Collaborated with data processing manager, supervisors, directors and enterprise architects to develop and execute enterprise data strategy, including the architecture and development of master and reference data management capabilities
- Defined and implemented the strategy roadmap for enterprise data implementation and data management for current data sources (CSE), business-to-business partnerships, and data analytics systems.
- Worked with staff and customers to understand the business requirements and business processes, design enterprise data warehouse schema, and define extract-translate-load (ETL) and/or extract-load-translate (ELT) processes for DW.
- Performed data discovery to bring significant value data understanding.
- Acted as a liaison with other functional and application leaders to ensure they were fully informed of objectives, purposes, and achievements of enterprise data architecture.
- Functioned as a technological evangelist, discovering, facilitating discussion, and introducing new ideas, technologies, data usage, etc. to the business, resulting in new product ideas and influencing software development activities.
- Established standards and guidelines for the design & development, tuning, deployment and maintenance of information, advanced data analytics, and logical and physical data models.
- Documented end to end data flow and prepared conceptual and logical model for BI application.
- 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
- Design of ETL Architecture and Implementation of Informatica Enterprise Architecture
Environment: AIX 6.1, Redhat 7.2, Windows 2012, Sybase Power Designer 16, UML, Microsoft Project/Visio 2016, DB2 UDB 9.7, Oracle 11gR2/12C, SQL Server 2012/2016, Informatica 9.6.1/10.x Power center, Power Exchange, Informatica Data Quality(IDQ), MDM, WebSphere 7.0, TOAD, Microsoft SQL Server Integration Services (SSIS). Hyperion Interactive Reporting Services, CalCloud, Azure
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 Confidential 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 (IDA) MDM, Erwin 9.6, UML, Informatica Data Quality(IDQ ), 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, HIPAA X12
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 CAMMIS 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 data sources and 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 IBM 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 Power Center 8.5.1/7.1.1 & Informatica Data Quality(IDQ), Autosys 4.0/5.0 RAD, SVN, Rational Enterprise Architect,, Window 2003 (ADS), WebSphere 6.1, TOAD, Business Object 6.5/XI/XIR2/XIR3, IBM Cognos 10.2, Microsoft SQL Server Integration Services (SSIS). SSL3.0, OLAP, OLTP, Python, MITA 3.0, SIMM, Seibel Analytics and CRM, HIPAA X12, MDM
Confidential, Sacramento, CA
Application/Data Architect
Responsibilities:
- Developed and designed software implementation strategies for Confidential (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 Confidential 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 Confidential 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), MDM, 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, IBM 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, RANCHO CORDOVA, CA
BI Data Architect
Responsibilities:
- Managed the project and deployed it successfully.
- 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: IBM-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, IBM-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