SUMMARY

• Core strength of Data Architecture and Business Intelligence Architecture, analysis, design and support expertise in client server and web Technologies framework.
• Diverse experience as a AVP of technology, project/team leader, techno functional lead, BI and Data/Big Data Architect, DBA and ERP application developer with exposure to Manufacturing, Banking, Insurance, Retail, Energy, Utilities, Financial,, Airlines, Shipping and Education domains.
• Certified, client - focused IT Professional with proven success developing strategic and operational technical objectives, priorities, tradeoffs, and risks to meet or exceed the organizational mission.
• Possess expertise in relationship building, business growth, global cross-functional team development/management, client implementation, marketing, and creation of technology solutions to support business goals and meet customer demands.
• Additional talents include Project Management, Oracle Development, Data Architecture, ORM Data Modeling, Data Management, Data Governance, Business Intelligence, Data Warehousing, Predictive/Cognitive Analytics, Data Visualization/Business Discovery Analytics, ERP Applications, Proposal Management, Data Modeling, Risk Management, and Agile Project Methodology used in development of global projects.
• Superior communication skills allow easy interaction with C-level executives, stakeholders, regulatory agencies, clients, vendors, engineers, and staff.

TECHNICAL SKILLS

• Microsoft Office
• Oracle
• OBIEE
• Tableau
• MDM
• PL/SQL
• Agile Scrum
• MOLAP
• ROLAP
• Dimensional
• ORM Modeling
• Product Management
• IT disciplines.

PROFESSIONAL EXPERIENCE

Confidential

Big data Architect

Responsibilities:

• Architecture of Enterprise Data Warehouse..
• Data model of a data lake and architecture design of different source systems such as Siebel, Oracle 11i, Oracle R12, Peoplesoft and various others using Cloudera, Impala, Hive, SQL on Hadoop and Oracle Databases.

Technologies: Oracle, Hadoop, Sqoop, Hive, Cloudera, HiveQL

Confidential

Consultant Data Architect

Responsibilities:

• Architecture of Database for the Loan Portfolio Application which is part of Capital Markets Securitized Products group..
• Data architecture, data model design of database application called Prism which evaluates loan positions for RWA calculations and provide reports in reporting platform called Piper.

Technologies: Oracle 11g-RAC, PL/SQL, SQL*Loader, Toad

Confidential

Enterprise Risk Architect

Responsibilities:

• Responsible for Enterprise Risk management and Architecture for Retails Bank, Investment Bank, and Insurance entities of Confidential in the Risk domain.
• Responsible for MDM, Information/Data Governance.
• Performing TOGAF SABSA Architecture Development Methodology using Rally in Agile sprints cycles.
• Technologies: Oracle, Hadoop, Sqoop, Hive, Cloudera, Spark, HiveQL, inDesign, Netezza, Neo4J, Tableau

Confidential

Consultant Data Analyst/Architect

Responsibilities:

• The Derivatives Result Database (DRD) is astrategic central repository for Front Office (FO) Valuation data for OTC trades. DRD stores daily valuation results from front office Risk Management Systems (RMS) as well as hooking into trade repositories to enrich this valuation data with booking and economic data.DRD is a critical system in the Confidential front-to-back architecture, and provides delivery ofProduct Control, Risk Management, and Collateral Management valuation data to key consumers.
• Analyzed data oriented application called DRD which provides a read only layer on the DRDv3 database providing reports. These reports provide End of Day Reports such as Daily P&L. Designed, developed, and coordinated enterprise metadata strategy repository implementation and maintenance.
• Automated databse deployments.

Technologies: Oracle 11g-RAC, PL/SQL, SQL*Loader, Toad, XML, Shell Script, CronTab, UML, Visio

Confidential

Lead Oracle Software Engineer/Architect

Responsibilities:

• Performed internal risk model changes as per BaFin regulations and optimized Back tester applications to address regulatory market conditions, which allowed the bank to cut its risk - weighted asset (RWA) by 55 billion euros in the fourth quarter of 2012, raising its core tier one capital under Basel III rules to 8% at the end of 2012 from under 6 percent at the end of 2011 and also eliminates the need for multimillion euros worth of costs in hardware replacements by system performance optimization.
• Performs query optimization in complex scenarios and leads global teams in Oracle development, Data Modeling, Oracle development, Business Intelligence Architecture, and Conceptual/Logical/Physical modeling design to develop client server and web technology frameworks using Agile methodology.
• Designs, develops, and coordinates Enterprise Metadata Strategy, including repository implementation and maintenance
• Technical level expert in analysis, design, development, unit testing, release, implementation, and support of, Columnar Dimension Modeling, Big data ecosystem design, ODS Design, Big Data Warehousing, MDM, Reference Data, Database Analysis, and ERP Application projects.
• Ensures software, hardware and database management systems/architectures support current and future business requirements by recommending version specific upgrades based on technical trends or application/system changes.
• Restructures, retools, and deploys Enterprise-based solution architectures to fulfill expanding customer needs and requirements while attending or overseeing global change management, design, code review, and infrastructure, compliance, and QA meetings.
• Authors strategic reporting infrastructure, requirements gathering, design/program/test standards, release process and other documentation procedures for IT environment as member of Financial Risk Management team.
• Oversees application implementation enhancements from data center migrations to virtual server.

Technologies: OBIEE 11G, Oracle 10G/11g-RAC, PL/SQL, Tableau, Hive, Sqoop, Hadoop, Yarn, Toad, Shell Script, CronTab, Erwin

Confidential, Seattle, WA

Lead Data Architect

Responsibilities:

• Performed application enhancements using partitioning, aggregate tables, and caching in VLDB environment to deliver the most state of the art software used to power Confidential 's network and hardware infrastructure.
• Designed and architected the conceptual/logical/physical data model, MDM, metadata repository used to deliver Confidential customers timely, flexible, and structured access to their data to enhance on - line infrastructure monitoring experience.
• Provided analysis, dimensional data modeling, and enhancements to global infrastructure components in areas of availability, performance, efficiency, and allocation to improve performance metrics while handling data related to Remedy troubleshooting tickets.
• Collaborated with business customers and implemented analytical and reporting solutions to support their technical needs.
• Successfully met an SLA of 30 seconds response time for the dashboard using more than 800 Terabytes of data.
• Designed and implemented infrastructure platform using third-party and in-house reporting tools utilizing Oracle Business Intelligence Enterprise Edition (OBIEE) on Tomcat, Apache platform including, shell scripting on the Confidential 's build and deployment.

Technologies: Oracle 11g-RAC, PL/SQL, Toad, UML, Erwin, OBIEE 10G, Shell Script, CronTab

Confidential

Business Applications Analyst/Architect - Oracle

Responsibilities:

• Collaborate with business areas and data owners to successfully implement and maintain enterprise level business analytics and data warehousing solutions.
• Developed front - end, metadata repository and ETL specification to support business requirements for reporting across the organization.
• Used OBIEE Administration Tool for data modeling and modify the Physical, Business and Presentation layers of metadata repository in MUD environment.
• Developed custom reports/Ad-hoc queries using Answers, Delivers, Java Script, and
• Interactive Answers and assigned them to application specific dashboards.
• Configuring interactive Dashboards with drill-down capabilities using global and local Filters, Security Setup (Roles, groups, access / query privileges)
• Metadata objects and Web Catalog Objects (Dashboard, Pages, Folders, Reports, KPIs).
• Performed capacity planning for OBIEE implementation.
• Implemented horizontal and vertical scaling of OBIEE Server.
• Experience in MDM, Extraction, Transformation and Loading of data from data sources to data warehouse using PL/SQL. Deployed Informatica workflows to Oracle DW Application Console (DAC).
• Architected Conceptual, Logical and Physical star schema models.
• Analyzed data governance concepts, practices, and procedures.
• Adapted a mix of Kimball and Inmon datamart structures.
• Architecture, development, enhancement, maintenance and performance tuning for the web based Energy and Transmission products.
• Analysis of the problems encountered in the software at all locations and providing robust solutions.
• Designed, developed, tuned, tested, and implemented the version/ upgrade releases of the application onsite. Providing assistance and support to team members as required.
• Use project management techniques, company business, applicable policies, procedures, and practices. Performed risk management for the multimillion dollars project.
• Managed stakeholders meetings and a team size of five team members.
• A team player having a sense of team integrity in critical and complicated situations.
• Committed in contributing to refining the quality standards.

Technologies: Oracle 9i/10G/11g-RAC, PL/SQL, Toad, Oracle Forms, SQL*Loader, PL/SQL, OBIEE 10G/11G, DAC, Informatica, CA ERWin, Java Script,UML, Erwin, Weblogic, Shell Scripting

Confidential

Consultant

Responsibilities:

• Managed the assigned client relationship.
• Performed ORM data modeling and database design using ERWin
• Development, maintenance, application and database performance tuning for the proposed product for trading, trade confirmation and accounting on SunGard Invest One accounting system on mainframe.
• Analyzed the problems encountered in the software at all locations and providing robust solutions.
• Developed programs using PL/SQL stored procedures, shell scripts with Oracle 9i on RAC multiple instance multi - processor servers in the back-end on Sun Solaris 9.2.
• Developed, testing and implementing the version/ upgrade releases of the application onsite.
• Communicated the requirements, assigned/ reviewed tasks and imparted technical assistance.

Technologies: PL/SQL, Oracle 9i (RAC), Shell Script, PL/SQL Developer, SQL Loader, Sun Solaris 9.2, CA ERWIN, spring, Hibernate, UML, Erwin

Confidential

Systems Executive

Responsibilities:

• Managed the assigned client relationship and providing support to users of enterprise management software deployed at client locations worldwide, ensuring excellence in service and satisfied customers.
• Analyzed the problems encountered in the software at all locations and providing robust solutions.
• Understand Data flow and modeling data for business intelligence reporting requirements.
• Developed, tested, and implemented version/upgrade application releases (developed by the previous vendor) onsite. Prepared development plans and resource requirements for the assigned modules and activities and assisting the project manager in monitoring and control activities.
• Led a technical team, communicating the requirements, assigning/ reviewing tasks and imparting technical assistance.
• Refined the quality standards (SQA) and enhancement of software development processes.
• Created Forms and Discoverer Reports for AP, AR and GL modules of Oracle Apps.

Technology: Oracle 9i, Shell Script, PL/SQL, Forms 6i, Reports 6i, Oracle Application Server, Toad, Apache, Sun Solaris 9.2, AIX 4.0, Oracle 6i/4i Discoverer, AP, AR and GL modules of Oracle Apps, ER Modeler.

Confidential

Analyst Programmer

Responsibilities:

• Interacted with the client to map workflow and prepare technical specifications for development of an add - on module Sales Data Processing for the existing product called REVERA .
• (This module is a key part of Revenue Accounting System and Airlines Passenger Solutions and is being used by a number of clients).
• Led a team during system analysis, design, and application coding and testing.
• Integrated the module with the application, ensuring seamless user experience.
• Prepared UTP for ATAC Data Loading Project within a short duration of 15 days.

Technology: Oracle 8i, Shell Script, PL/SQL, Tomcat, Apache, Sun Solaris 7.0, Pro*C, Forms 4.5, Reports 2.5, Sql Navigator, PVCS