We provide IT Staff Augmentation Services!

Solution Architect And Solution Designer Resume

SUMMARY:

  • Possess extensive experience in information architecture, data architecture, data modeling, data warehouse architecture / modeling and architecture governance processes/procedures.
  • 10+ 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.
  • 10+ years of requirements & business process management, executive management, communication, and reporting skills.
  • 7+ years of extensive experience in developing Conceptual Data Model (CDM), Logic al Data Model (LDM) and Physical Data Model (PDM).
  • 6+ years of leadership experience in data migration, data acquisition, data convergence, Master Data Management (MDM) and data warehouse projects/initiatives.
  • 6+ years of Solution Architecture, Business Architecture, Application/ Data Architecture, and Technology Architecture along with Architecture Governance.
  • 8+ years of architecture governance processes / procedures (Checkpoint 1, Checkpoint 2 and Checkpoint 3related to enterprise architecture, information architecture and data architecture).
  • 10+ years of data modeling and dimensional modeling using multiple technologies by using Power Designer, ER Win, Oracle Designer and System Architect / IBM Infosphere Data Architect tools.
  • 2+ years of Agile Scrum Management and Project management.
  • 8+ years of Data Warehousing and Business Intelligence experience with tools such as Informatica, OBIEE, OBIA, BI Publisher, Cognos, ODI, DataStage, PowerBI (Power BI).
  • 3+ years Data Cleansing and Data Profiling with SAS Dataflux, IBM QualityStage, SAS and SAS Analytics.
  • 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.
  • Familiarity with DevOps, MuleSoft/Mule.

WORK EXPERIENCE:

Solution Architect and Solution Designer

Confidential

Responsibilities:

  • 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: Agile Scrum, Confluence, DevOps, 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.

Solution Architect

Confidential

Responsibilities:

  • 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.
  • Architecture Roadmap, Implementation and Migration Plan, Architecture alignment, Transition Architecture Roadmap, Architecture Capability, Solution Capability, Solution Data Identification (SDI), Gap Analysis and identifying constraints,
  • 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.
  • Guidewire 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.
  • 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. Proposed Informatica and IBM InfoSphere Information Server (IIS) as an ETL/MDM tool.
  • Configured CAD, DataStage, IBM Cognos and Guidewire tools with LDAP, MSAD (MS Active Directory), IHS (IBM Http Server), and OVD (Oracle Virtual Directory).
  • Configured, implemented and processed data for PeopleSoft HRMS - Department Component, Job Code, Job Code Task, Job Code Task component and Location Component.
  • Identify/fix defects, regression testing, work-around solutions, Solutions to the DataStage performance, Cognos security, SSO.
  • Set-up/Configured/Integrated security privileges for the selected user community from Guidewire and Cognos tools by leveraging industry leading technologies such as Lightweight Directory Access Protocol (LDAP) and MS ActiveDirectory (MSAD) with Architecture and Leadership teams.

Technologies: Agile Scrum, IBM IS IGC, DevOps, Oracle 12c Server, Informatica, 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, Integration and Analytics

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.
  • 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.
  • Architecture Capability, Solution Capability, Solution Data Identification (SDI), Gap Analysis and identifying constraints, 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 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: ITIL, ITSM, OBIEE 11.1.1.7(RPD, Catalog), OBIA, OCDM, BigData, PeopleSoft HRMS, 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.

Confidential

Scheduling, Facilitation, Project Management

Responsibilities:

  • Target Business Architecture, business goals, strategic drivers, Request for Architecture Work, Architecture Roadmap, Baseline and Target Business Architectures, Statement of Architecture Work, LogicalData Model, Physical Data Model, Compliance with Business Architecture and Data Architecture, business cases, options analysis, recommended migration methods,
  • Soft Skills applied: Scheduling, Facilitation, Project Management processes, communication with business stakeholders, and technical stakeholders such as infrastructure, environment, architecture and operational teams.
  • 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.
  • Analyzed the deployment infrastructure, development infrastructure and production databases. Reviewed the best practices and amended the processes whenever and wherever needed upon project leads approvals. Recommended and Established best practices in establishing audit trail, error tracking and automating the processes.
  • 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.
  • Led and collaborated with cross-functional organizations in defining enterprise data and information architecture, data strategy and roadmap, along with Solution Architect, in line with organization strategy. Designed and Developed Common System Architectures for the project to depend on.
  • Assisted business units and recruitment teams with regards to Recruiting and Onboarding, and Core Human Resources and Performance and Compensation SAP HCM modules.
  • 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.
  • Worked on the GIS Spatial data integration business case with the location addresses.
  • 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.
  • 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.

Technologies: 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.

Solution Architect

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. Released/Installed/Configured OBIEE in various environments. Led SIT and UAT testing. Provided production/administration support.

Technologies: SQL Server, Oracle, DB2, Siebel, Oracle Hyperion, 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.

Hire Now