SUMMARY

• Core strength of Database Applications development Development, Architecture, analysis, design, development 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 Architect, DBA and ERP application developer with exposure to Insurance, Banking, Utilities, Financial, Manufacturing, 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, Architecture, Data Modeling, Business Intelligence, Data Warehousing, 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.
• Technically proficient in Microsoft Office, Oracle, OBIEE, PL/SQL, Agile Scrum, MOLAP, ROLAP, Dimensional Modeling, Product Management, and other IT disciplines. Recipient of Oracle Corporation s Thought Leadership award in 2011.
• Fluent in English and Hindi languages.
• Attended training in Project Management Programme Fastrac, Astrowix Corporation, USA.
• Formally Trained in Oracle Business Intelligence Suite Enterprise Edition 11G (OBIEE) by Oracle and 10G by an Oracle partner.
• Formally Trained in EBS Functional and Informatica.
• Having full ETL concepts and implementing them in high paced BI environment.

WORK HISTORY

Confidential, Morrisville, NC

Consultant Oracle Developer

Responsibilities:

• Architecture of Database for the Loan Portfolio Application.
• Front End of Marking Tool is a Java application. Data is sent via xml using JMS web services to interact with loan valuation database engine.
• Leading PL/SQL development of Prism Application with complex SQL, Packages and Procedure coding.
• Data model design of database application called Prism which processes scenarios of the loan positions for
• Loan valuation and subsequent RWA calculations and provide reports in reporting platform called Piper.

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

Confidential, San Antonio, TX

Enterprise Database Developer

• Responsible for Enterprise Risk management and Architecture and development for Retails Bank, Investment Bank, and Insurance entities of Confidential in the Risk domain which includes Compliance, Audit, Regulatory reporting such as Dodd-Frank, Basel III, BCBS 239, FED Remediation, Solvency II.
• Responsible for Information/Data Governance in Chief Risk Office.
• Performing TOGAF SABSA Architecture Development Methodology using Rally in Agile sprints cycles.
• Used PLSQL for data readiness into Oracle database before Data Ingestuion to Hadoop.

Technologies: PL/SQL, SQL, XML, Business Objects, Netezza, Oracle, Hive, Hadoop

Confidential, NC

BI Database Development Lead

• Managing the Enterprise IT development and processes and all aspects of BI implementations in forty four countries in the following areas.
• Used PL/SQL for complex business logic in ODI for OBIEE Reporting.
• D2D, R2R, Q2C, O2C, P2P, STC, SCM.

Technologies: PL/SQL, SQL, XML, SQL Loader, ODI 11G, OBIEE 11G

Confidential , Morrisville, NC

Consultant Oracle Developer

• The Derivatives Result Database (DRD) is a strategic 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 of Product Control, Risk Management, and Collateral Management valuation data to key consumers.
• Analyzed, designed and developed ETL using PLSQL 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.

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

Confidential, NC

Lead Oracle Software Engineer

• 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 PL/SQL, SQL*Loader, Informatica, Dimensional (Star/Snowflake) Modeling, RPD Modeling, ROLAP, MOLAP design, ODS Design, Data Warehousing, MDM, Reference Data, OBIEE, 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: Oracle 10G/11g-RAC, PL/SQL, SQL*Loader, Toad, OBIEE 11G, Shell Script, CronTab

Confidential, Seattle, WA 

Lead Data Architect

• 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.
• 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, OBIEE 10G, Shell Script, CronTab

Confidential, Seattle, WA 

Business Applications Analyst- Oracle

• 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, Weblogic, Shell Scripting

Confidential, Pasadena, CA

Consultant

• Provided services/support to users of above financial applications in USA, UK and Singapore.
• Managed the assigned client relationship.
• Performed 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.

Confidential, Columbus, IN 

Systems Executive

• 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.
• Achievements: Provided services/support to users of banking applications at Deutsche Bank in USA, UK, Germany, Singapore, Italy. Provided services/support to users of Finance applications at Cummins Inc in USA, UK, Mexico.
• 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.

Analyst Programmer

• 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.
• Implemented and supported the module for six clients, including Qatar Airways, CNorth, Air Luxor and Travel Cuts.

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

DBA/Analyst Programmer 

Senior Programmer 

• Conducted system analysis of the ERP system developed by the client Al - Aqili
• Information Systems of Dubai, to develop add-on modules and databases.
• Designed and created large and complex physical and actual tables and queries.
• Conducted database modeling, design and administration and wrote scripts for task automation.
• Carried out regular performance tuning and backups to ensure space and cost optimization and database integrity.
• Maintained quality systems documentation and provided support to the users.
• Was deputed to Al-Aqili Information Systems from April 2000 to August 2000, to implement the projects on-sit
• National Railway museum, New Delhi.

Technology: Oracle 8i, Shell Script, PL/SQL, Sun Solaris 6.0, Pro*C 8.1.6, Forms 6.0, Reports 3.5, Toad

Programmer

• Developed several applications for internal and external clients, to manage various functional aspects of the enterprise.
• Involved in all stages of the projects from requirement study and system analysis to coding, testing and implementation.
• Interacted with the users to prepare functional requirements and also prepared the technical specifications.
• The important projects worked on include Development of several add - on modules for the sales management system deployed internally.
• The new modules developed were stores and inventory module, stock management module. The invoice generation module was modified. The application was also migrated from Oracle 7.0 backend running on HP 9000 business class of server with HP UX operating system onto Oracle 7.3.6 and made Y2K compliant.
• Developed the Production and Planning Control System as a part of the computerization of T G Head Quarter (Army), New Delhi.

Technology: Oracle 7.x, PL/SQL, Forms 4.5, Reports 2.5, HP 9000 Server, HP-UX