SUMMARY:

• Possess extensive experience in information architecture, data architecture, data modeling, data warehouse architecture / modeling and architecture governance processes/procedures.
• 25+ years of maintaining Operational Systems and ensuring the architecture standards are maintained well within IT and in complying with business strategy and vision. This includes Business Transformation, Organization Realignment, Organizational Change Management and Business Process Improvement.
• 18+ years of requirements & business process management, executive management, communication, and reporting skills.
• 18+ years of extensive experience in developing Conceptual Data Model (CDM), Logic al Data Model (LDM) and Physical Data Model (PDM).
• 18+ years of leadership experience in data migration, data acquisition, data convergence, Master Data Management (MDM) and data warehouse projects/initiatives.
• 16+ years of Solution Architecture, Business Architecture, Application/Data Architecture, and Technology Architecture along with Architecture Governance.
• 15+ years of architecture governance processes / procedures (Checkpoint 1, Checkpoint 2 and Checkpoint 3 related to enterprise architecture, information architecture and data architecture).
• 15+ years of data modeling and dimensional modeling using multiple technologies by using PowerDesigner, ER Win, Oracle Designer and System Architect / IBM InfoSphere Data Architect tools.
• 14+ years of Agile Scrum Management and Project management.
• 12+ years of Data Warehousing and Business Intelligence experience with tools such as Informatica, OBIEE, OBIA, BI Publisher, Cognos, ODI, DataStage, PowerBI (Power BI).
• 8+ years Data Cleansing and Data Profiling with SAS Dataflux, IBM QualityStage, SAS and SAS Analytics.
• 6+ years Peoplesoft experience - Financial Management, Supply Chain Management, Supplier Relationship Management, Enterprise Services Automation modules.
• Knowledge and Awareness with Cloud based technologies such as Azure, AWS and other tools and architectures.
• Knowledge and limited experience with BigData based technologies such as Exadata, Hadoop and Cloudera tools and architectures.

TECHNICAL SKILLS:

Data Modeling: OLTP, OLAP, ROLAP, MOLAP, Star Schema, Snowflake Schema, Dimensional Modeling, Data Modeling,Physical and Logical Data Modeling, ER Win, ER/Studio, Toad, SQL Navigator

ETL Tools: Informatica 8.x/9.x, DataStage 8.x/11.x, OWB 10.x, SSIS, ODI (Oracle Data Integrator 11 g/12c)

BI Tools: Business Objects, Cognos 8.x/10.x/11.1.7, Tableau, PowerBI, MicroStrategy 9.x, OBIEE, BI Publisher, Hyperion Essbase 9.x, Crystal Reports 11, SAP BW/BI, Cognos PowerPlay, Cognos Reportnet, SAS, Advanced Analytics, SSAS, SSRS, MotioCI, MotioPI, MotioCAP

Databases: Oracle 11g/12c, SQL Server 2008/2012, Sybase, DB2, Teradata V2R12, Microsoft Access, MySQL

Operating Systems: Sun Solaris 7/8, AIX, HP-UX, Windows 2012/2016, Mainframe Systems, Windows XP/Vista/7

Programming: SQL, PL/SQL, Oracle Forms, T-SQL, HTML, C, Pro*C, SQL Plus, UNIX Shell Script, Java, XML, COBOL, JDBC, PERL, EJB, J2EE

Web Servers: WebSphere, IIS, Oracle WebLogic Servicer 11g/12c

Case Tools: PowerDesigner, Dataflux, ER Win, Oracle Designer, UML, Toad, SQL Developer, SQL Developer Data Modeler

Methodology: Agile Methodology, Iterative Methodology, Software Development Life Cycle (SDLC), Project Management Life Cycle (PMLC), Summit, Waterfall, Rational Unified Process, OMT

Other Software Tools: Guidewire, Oracle Fusion Middleware, QlikView, Trillium, Siebel, Designer 2000, MS Project, Vitria, OIT, CodeCenter, WinRunner, Oracle Financials, SQL Navigator, Toad, OpenText s LiveLink, MS Project Server 2003, Brio, SAP, PeopleSoft, Power BI, SAS, SAS Analytics,, Data Warehousing, Analytical SQL, SQL Developer 17x and SQL Developer Data Modeler 17x

PROFESSIONAL EXPERIENCE:

Application Architect

Confidential

Responsibilities:

• Standardized the best practices and applied at the required environments at ESC and resulted in 50%-60% faster deployments by adopting Agile methodology.
• Created and configured load-balancing Siebel solution in a clustered environment that resulted in deploying business requirements in a faster turn-around at GAC with multiple gateway, application interface, EAI and Database servers.
• Proposed a solution for USA financial clients with emerging technologies using microservices, bigdata and cloud technologies.
• Business Architecture (Conceptual/Logical), Information Architecture (Conceptual/Logical/Physical), Data Architecture (Conceptual/Logical/Physical): Current State and Transition State.
• End-to-end solutions from source (PROD COPY) to LANDING to Datamart (IC) to Analytic Layer to Reporting Layer - Business Case, Proof of Concept (PoC), Business/Data /Technology/Infrastructure/Solution Architecture teams.
• Reviewing organizational assets such as current Architecture Roadmap, Implementation and Migration Plan, Integration Strategy, Architecture alignment, Transition Architecture Roadmap, Architecture Capability, Solution Capability, and Solution Data Identification (SDI).
• Soft Skills applied: Scheduling, Facilitation, Project Management processes, AGILE SCRUM Processes (daily stand-ups, sprint planning, user stories, grooming, retrospectives and demos/presentations), working with business stakeholders, technical stakeholders such as environment, architecture and operational teams.
• Setting the project with resources and infrastructure along with tools and practices to support the dynamic nature of the organization. Led a team of four architects/designers/SMEs and an offshore team.
• Scope Definition (BRD), architecture, data modeling, dimensional modeling, data mapping, and design documents from source data elements to the target reports - using ER Win and Oracle Data Modeller tools.

Technologies: MuleSoft, Agile Methodology, DevOps, REST API, Oracle 12c Server, Oracle ODI, OBIEE, PowerBI (Power BI), PL/SQL, MS SQL Server 2012, Toad, SQL Developer, SQL Developer Data Modeler, MS Office, Azure, AWS, Power BI, BigData, Visio, Agile Scrum Methodology, Unix/Linux, Windows Server/Client, Korn/Bash shell, ER Win, Agile Scrum Methodology.

Business Intelligence SME/Architect (CONTRACT)

Confidential

Responsibilities:

• Attended JAD Sessions, Requirements review sessions with business and SME to Guidewire - ClaimCenter OOTB functionality with customizations. Proposed solutions for the customizations and downstream impacts with Data Warehouse and Business Intelligence Reporting benefits.
• Guidewire - Claim Center functional system, EIW/PDM/ODM, RFM, DataHub, InfoCenter, Data Warehouse, and Business Intelligence reporting and Analytics environments, and Operationalize Data Governance with Business, Architecture, IT and Operations team.
• Configured CAD, DataStage, IBM Cognos and Guidewire (ClaimCenter) tools with LDAP, MSAD (MS Active Directory), IHS (IBM Http Server), and OVD (Oracle Virtual Directory).
• Business Architecture (Conceptual/Logical), Information Architecture (Conceptual/Logical/Physical), Data Architecture (Conceptual/Logical/Physical), Technology Architecture (Conceptual/Logical/Physical): Current State and Future State.
• End-to-end solutions from source (Mirror) to ODS (DataHub) to Datamart (IC) to Framework Manager to Cognos reports - Business Case, Proof of Concept (PoC), Business Requirements Document, Use-Case Scenarios, Business Architecture, Data Architecture (Data Integration Architecture, DW/BI Architecture, Enterprise Data Models, Meta-Data Architecture), Technology Architecture and Solution Architecture.
• Identify, define and Analyze Integration Solution Architecture
• Architect and Design Integration for performance, scalability and availability based on industry standard patterns Solution, Design and Develop Data Integration approach, patterns, methods, payload models, process and components, and configured with REST APIs.
• Be accountable for the technical integrity of the project architecture/design.
• Provide hands-on technical direction to other developers to review code and resolve issues.
• Architecture Roadmap, Implementation and Migration Plan, Architecture alignment, Transition Architecture Roadmap, Architecture Capability, Solution Capability, Solution Data Identification (SDI), Gap Analysis and identifying constraints.
• Perform benefit analysis of solution options and technology.
• Socialize Integration solution architecture with the stakeholders.
• Model and Design building blocks for Integration solution.
• Guide Developers perform review of work products and provide oversight.
• Define and review Standards, Architecture design principle and processes.
• Soft Skills applied: Scheduling, Facilitation, Project Management processes, working with business stakeholders, technical stakeholders such as infrastructure, environment, architecture and operational teams.
• Business Requirements Documents (BRD), architecture, data modeling, dimensional modeling, data mapping, data lineage, design documents from source data elements to the target reports - using ER win and PowerDesigner modeling tools.
• Delegated and performed Cognos Analytics on Cloud platform with IBM SaaS/PaaS/IaaS options and identified the bottlenecks for the architecture group to identify the strategy around it.
• Identify/fix defects, regression testing, work-around solutions, Solutions to the DataStage performance, Cognos security, SSO.

Technologies: Datahub, SAP, REST API, Guidewire (ClaimCenter), ITIL, ITSM, IBM IS IGC, Oracle 12c Server, Oracle Http Server (OHS), PL/SQL, SAS, SAS Analytics, Cognos 8.4/10.1/10.2/11.0.6 (Cloud PoC), DataStage, SAP BODS 4.2, MS SQL Server 2012, Toad, SQL Developer, SQL Developer Data Modeler, MS Office, Visio, Agile Scrum Methodology, Unix/Linux, Windows Server/Client, Korn/Bash shell, ER Win, PowerDesigner, CAD, HP QC.

Solution Architect (CONTRACT)

Confidential

Responsibilities:

• Business Architecture, Information Architecture, Data Architecture, Technology Architecture: Current State and Future State
• End-to-end solutions from sources to Staging1 to Staging2 to OCDM/OBIA to RPD to OBIEE Reports, Business Case, Proof of Concept (PoC), Business Requirements Document, Use-Case Scenarios, Business Architecture, Data Architecture, Technology Architecture and Solution Architecture, Architecture Vision, Request for Architecture Work, Architecture Roadmap, Implementation and Migration Plan, Architecture alignment, Transition Architecture Roadmap.
• Perform benefit analysis of solution options and technology.
• Socialize Integration solution architecture with the stakeholders.
• Model and Design building blocks for Integration solution.
• Guide Developers perform review of work products and provide oversight.
• Ensured SOAP/REST API/Web Services to communicate with the parent web application to allow for Single Sign-On (SSO) and the maintenance of user sessions.
• Define and review Standards, Architecture design principle and processes.
• Soft Skills applied: Scheduling, Facilitation, Project Management processes, communication with business stakeholders, and technical stakeholders such as infrastructure, environment, architecture and operational teams.
• Business Case, Proof of Concept (PoC), Business Requirements Document, Use-Case Scenarios, Business Architecture, Data Architecture (Data Integration Architecture, DW/BI Architecture, Enterprise Data Models, Meta-Data Architecture), Technology Architecture and Solution Architecture.
• Delegated and performed Solution Architecture with industry leading OBIA, OBIEE and OCDM architectures, and identified the bottlenecks for the Data and Management teams to resolve in order to meet the long-term strategy and goals.
• Performed OBIEE Administration including Automating Service shutdown/start-ups, Release Management / Configuration / tuning, Support multiple environments (development, testing,, and production), Log file analysis (BI Publisher services), System monitoring, Server cleanups (log files).
• Configured, implemented and processed data for PeopleSoft HRMS - Department Component, Job Code, Job Code Task, Job Code Task component and Location Component.
• Performed the performance tuning and system optimization activities related to the OBIEE / BI Publisher tools.
• Designed solution with the help of OCDM and ODI/OBIEE tools in configuring the Exalytics/Exadata server. Mapped and Configured the SDI data sets to OCDM tables/columns based on the Telecommunication applications needs and business rules.
• Designed the repository (RPD) for the presentation layer and created BMM layer along with the physical layer. Then, deployed solution with reporting artifacts in OBIEE Catalogs.
• Configured the ODI and OBIEE tools to provide Data Lineage from sources to the intermediate data layers to the target data layers to the presentation layers. Identified the security requirements and assisted in configuring these requirements in OBIEE (security policies) tool along with LDAP security policies.
• Designed and developed ODI interfaces and work packages, and OBIEE drill-down reports/dashboards/RPD/Catalog artifacts.

Technologies: SAP, DataHub, REST API, ITIL, ITSM, OBIEE 11.1.1.7(RPD, Catalog), OBIA, OCDM, BigData, Oracle Exalytics/Exadata Server, PL/SQL, ODI (Oracle Data Integrator), Oracle Fusion Middleware, WebLogic, Toad, SQL Developer, SQL Developer Data Modeler, PeopleSoft, Oracle Financials, BI Publisher, Informatica 9.6.1, SQL Developer, MS Office, Visio, Agile Scrum Methodology, Unix(AIX), Windows Server/Client, Korn shell.

Solution Architect

Confidential

Responsibilities:

• Model and Design building blocks for Integration solution using REST APIs. Identify, define and Analyze Integration Solution Architecture.
• Architect and Design Integration for performance, scalability and availability based on industry standard patterns Solution, Design and Develop Data Integration approach, patterns, methods, payload models, process and components, and configured with REST APIs.
• Architecture Roadmap, Implementation and Migration Plan, Architecture alignment, Transition Architecture Roadmap, Architecture Capability, Solution Capability, Solution Data Identification (SDI), Gap Analysis and identifying constraints.
• Guide Developers perform review of work products and provide oversight.
• Worked on the GIS Spatial data integration business case with the location addresses.
• Target Business Architecture, business goals, strategic drivers, Request for Architecture Work, Architecture Roadmap, Baseline and Target Business Architectures, Statement of Architecture Work, Logical Data Model, Physical Data Model, Compliance with Business Architecture and Data Architecture, business cases, options analysis, recommended migration methods.
• Risk Analysis, Risk Management, Impact analysis, Business Strategy, Infrastructure Architecture (Current Vs Future), Architecture Landscape, Strategic Architecture, Segment Architectures, Transition Architecture, Capability Architecture, Segmented Requirements, Capability Requirements, Data Architecture, Technology Architecture, ETL mappings design, End-to-End data mapping, Logical Data Model, Physical Data Model, Business Architecture, Data Security requirements, Migration Project plans.
• Business Case, Proof of Concept (PoC), Business Requirements Document, Use-Case Scenarios, Business Architecture, Data Architecture (Data Integration Architecture, DW/BI Architecture, Enterprise Data Models, Meta-Data Architecture), Technology Architecture and Solution Architecture.
• Designed and developed several different types of Informatica mappings, sessions and workflows to satisfy the project requirements. Developed shell scripts and SQL / PLSQL scripts in a dynamic working environment. Supported the project changes requests and supported the testing teams.
• Defined and documented Data Security requirements, implement security and access controls on the data objects, implement audit logging mechanism to track security controls activities in the data governance repository.
• Attended review meetings, decision making meetings and presentations to the executive management teams for Location Master, Building Master and Customer Master Data mart and BI solutions.
• Involved in Informatica PowerCenter and PowerExchange Change Data Capture (CDC) implementation and configuration on DB2 relational database.
• Proposed List, Cross-tab and Chart Reports using Drill-Through, Master-Detailed and Customized reports using dynamic Prompt functionalities. Cognos Reports/Dashboards/Cubes.
• Designed functional and system requirements, wrote ETL specification design documents and assisted developers in developing Informatica mappings / sessions / workflows.
• Logical Solution Architecture, Physical Solution Architecture, Gate-1 Presentation and Business Case artefacts, Architecture Capability, Solution Capability, Technology Architecture (Logical and Physical).
• Soft Skills applied: Scheduling, Facilitation, Participation, Contribution, Project Management processes, communication with business stakeholders, and technical stakeholders such as infrastructure, environment, architecture and operational teams.
• Designed and developed infrastructure solution for upgrade from AIX 5.3 to AIX 6.1 with IBM P595 Serius 6 to Serius 7, Informatica Upgrade to Power Center Advanced Edition 9.1.0 along with Metadata Manager + Metadata exchanges for Cognos, SAP and Oracle.
• Acted as Liaison with vendors such as Informatica to determine current inventory and see the delta changes to the future environment snapshot.

Technologies: DataHub, SAP, ITIL, ITSM, ER Win, Oracle RAC 12c/11g, BigData/Hadoop, Oracle Fusion Middleware, Teradata, Siebel, ODI, SAP HCM, SQL Server, SAS, Informatica 9.6.1, Toad, SQL Developer, SQL Developer Data Modeler, Windows Service, PowerShell, Trillium, DB2, SQL Server, Dataflux, PowerDesigner, EPM, DB2, PeopleSoft HRMS, PL/SQL, MS Office, Visio, AS/400, Agile Scrum Methodology, Windows Server/Client, Korn shell, PowerShell.

Data Architect (CONTRACT)

Confidential

Responsibilities:

• Business requirements, Non-functional requirements, Business Processes, Data Mapping, Business Rules, Policy Rules, Architecture Roadmap, Architecture deliverables, Business Architecture, Information Architecture, Technology Architecture and Security Architecture. Logical Data Modeling, Physical Data Modeling, Data Profiling standards, ETL mappings and wireframes.
• Soft Skills applied: Scheduling, Participation, Contribution, Project Management processes, communication with business stakeholders, and technical stakeholders such as infrastructure, environment, architecture and operational teams.
• Data Architecture (Data Integration Architecture, DW/BI Architecture, Enterprise Data Models, Meta-Data Architecture), Technology Architecture and Solution Architecture.
• Assisted with RPD design/development and Data Modeling. Collaborated with Business Analysts, Technical teams and Development teams. Supported Business Analytical Model for the reporting layer.

Technologies: SQL Server, Oracle, DB2, Cognos, OBIEE, SQL Server, Toad, SQL Developer, SQL Developer Data Modeler, Informatica, PeopleSoft, SAP, OWB 11.1, DB2, RPG, Teradata, Dataflux, SUN Solaris, ER Win, PowerDesigner, EPM, DB2, Cognos, Crystal Report Writer, PL/SQL, MS Office, Visio, AS/400.

DW Specialty - BI Specialist (CONTRACT)

Confidential

Responsibilities:

• Soft Skills applied: Scheduling, Facilitation, Participation, Contribution, communication with business stakeholders, and technical stakeholders such as architecture and operational teams.
• Designed, created and customized ODI objects such as models, data stores, mappings, procedures, variables, packages and load plans of the financial applications.
• Integrated Cognos with its third-party tools such as databases, authentication providers by using MotioCAP for database authentication, SSO (Single Sign-On) and multi-factor authentication for the day-to-day business.

Technologies:Oracle 11g, Informatica, Siebel, Toad, SQL Developer, SQL Developer Data Modeler, OWB 11.1, DB2, Oracle Data Integration (ODI), Teradata, Dataflux, SUN Solaris, ER Win, Designer, EPM, DB2, Cognos, MotioCI, MotioPI, Crystal Report Writer, PL/SQL, MS Office, Visio, AS/400.