SUMMARY:

• Over 15 plus years of extensive experience with great success in designing, architecting, developing, managing and leading high quality SaaS, B2B, B2C, e - commerce, OLTP, Data Warehouse, Business Intelligence, Master Data Management, Data Virtualization, Data Quality, Data Profiling, data patterning, data projection, predictive analytics, trend analytics and messaging applications.
• Experience in architecting and governing large amounts of structured and unstructured data. Extensively involved in Big-Data RFP review process and scoring metrics to help business in selecting right vendor for right job in achieving innovative foundational architecture for the enterprise platform which business can rely on.
• Innovation award winner, most comfortable out-of-the box thinker and outstanding performer. Deadline-driven agile delivery by focusing on business priorities, motivating teams, driving change, cutting waste, and delivering as promised. Strong business/technical communicator who persuades executives to commit. Built high-performance offshore Data Architect and Database Administrator team committed to continuous improvements.
• Designing, architecting, developing, managing and leading enterprise base data warehouse/Data Lake, Big Data, ETL/ELT, Data Marts, BI, MDM, data governance, data modeling (conceptual, logical, physical), data mining, Data quality, data governance, application development projects on multi-tenant platform and custom built search engine capabilities.
• Expertise in Supply Chain, Ecommerce, Emerging Business Services, Media, Banking, Material Management, Payroll, Financial Accounting, Fixed Deposit, Loan, Credit Safe Credit Information System products.
• Hands on experience in Media Supply Chain Management.
• Providing innovative solutions across different databases, Data Warehouse, Data Vault, ETLs, Application servers and visualization platforms such as Oracle(7.3 to 12c) Greenplum (4.1 and 4.2), Netezza, Oracle Data Integrator, Panopticon, Weblogic, Tomcat, Unix, Linux and windows.
• Erwin, Power designer and ER/Studio data modeler tools to design and develop enterprise base OLTP, Data Warehouse, Data-Marts and BI applications.
• Engaged as team player that collaborates closely with product, dev, qa and support teams and drives for success.
• System design life cycle to drive waterfall and agile based projects across different platforms.
• Database administrator, capacity planner and information lifecycle management (ILM).
• Database/Application tuning over 12 TB OLTP/Warehouse database, Shell Scripting, PL/SQL, SQL, PL/pgSQL.
• Designed and developed Performance test plans for OLTP and Warehouse applications.
• Providing valuable guidance to development team, team leads and application architects.
• Rolling out standards for OLTP and Data warehouse designs.

TECHNICAL SKILLS:

Specialties: Enterprise Data Architect, Data Warehouse, Data Vault, Data-Mart, MDM, BI, Data Modeling, Data Virtualization, VLDB, Big Data, Statistics, Meta Data Management, Workable Data Governance, Enterprise Data Dictionary, Erwin, Power Designer, ER/Studio, SQL, PL/SQL, PL/pgSQL, Oracle, Greenplum, Netezza warehouse Appliance, Panopticon Visualization, Unix, Project Management and Microsoft Excel analytics.

Technology: Oracle, Greenplum, Netezza, DB2, MS-SQL, Oracle Forms, SaaS, PL/SQL, PL/pgSQL, SQL, Oracle Data Integration (ELT tool), Informatica on cloud, Panopticon Visualization, Erwin, Power Designer, ER/Studio, WebServices, EDI, GIS (Gentran Integration Suite), Tealeaf, Siebel, salesforce.com, Crystal Report, Weblogic, Tomcat, Aix, Sun Solaris, Linux, Windows Server, Perl, Java, C and C++.

PROFESSIONAL EXPERIENCE:

Confidential

Manager, Enterprise Data Architect / Head of Data Architecture Department

• As an Enterprise Data Architect leader excelled in many initiatives which leads into concrete business outcomes such as 360 degree view of the consumers, Campaign Management, Confidential NOW/GO analytics, Master Data Management, Workable Data Governance, Cross Platform Analytics, Innovatively built Search Engine platform, Program Analysis & Exploration, Universal Data Layer, Big Data initiatives, Micro-services architecture, Web-service architecture, data virtualization, structured / unstructured data (Social Media Data) integration architecture.
• Explicitly leading and managing Master Data Management program, Universal Data information management, CMDB program by
• Leading departmental budget, defining vision, strategy and principles for data management.
• Defining architectural standards for engineering, modeling, naming, describing, governing, managing, cleansing, enriching, transforming, moving, storing, searching and delivering media supply chain reference, master and universal data within the enterprise.
• Severing as the liaison between data consumer representatives and data solution development, integration and workable governance teams.
• Understanding how data is, or will be, used and its implication on business and technology.

Confidential

Manager, Enterprise Data Architect / Head of Data Architecture Department

• As an enterprise data architect, I got an opportunity to work on various initiatives such as data evolution architect, centralized reference data architect, enterprise base data dictionary concepts, data as a service architect and future state architect for the business IT.
• Designed and lead the Application Database Inventory project (small scaled CMDB) to achieve following goals:
• Breaks down the barriers between IT and the business.
• Provides more proactive management.
• Helps better assess risk and improve security.
• Helps keep track of any changes in software.
• Makes compliance easier and more accurate.
• Designing MRI reference data project to achieve centralized reference data store of Confidential Assets and Affiliates to achieve cross-platform associations to meet various following business challenges:
• Reduced business risk.
• Improved efficiency for making changes to reference data and distributing consuming applications.
• Lower support cost.
• Solve reference data needs to meet cross platform reporting and analytical challenges.

Confidential, NJ

Sr. Data Architect and Lead Data Management IT

• Designed and developed new data warehouse coding, data modeling and testing standards for GreenPlum warehouse appliance.
• Led data integration and migration roll-out plan among Oracle and GreenPlum databases.
• Designed and developed relational and dimensional data models for OLTP and Data-Warehouse applications.
• Extensively worked on developing data quality, data analysis (patterns and predictions) and data profiling data models and later presented visually by using Panopticon visualization tool.
• Automated OFAC compliance data analysis for supply chain portal and later submitted over to federal government.
• Responsible in maintaining common data dictionary across the portal.
• Rolling out data modeling (OLTP/Data-Warehouse/Data-mart) and coding standards for IT.
• Defined performance standards to achieve 3 seconds performance across the globe for the portal.
• Responsible to design data-security on multi-tenant portal on centralized database.
• Designed and developed intelligent proactive business process monitors to achieve 99.99% portal availability goal.
• Rolled-out Oracle Data integrator ELT standards to migrate homegrown PL/SQL ETLs to ODI.
• Rolled-out ILM (information life cycle) process for the IT to save over millions of dollars in storage cost.
• Led, designed and developed Industries first multi-tenant BI product for supply chain portal.
• Designed Master Data Management generic data model to maintain data governance around all the master data needs for the portal.
• Actively involved in SOA projects to help in data modeling to satisfy SOA needs for the portal.

Confidential

Sr. DBA and Portal Technical Support Lead

• Architecture review, prototyping and proving solutions for customers.
• Designed, developed and led relational and dimensional data modeling on VLDB.
• Performing detail system audits, hands-on development, review of competitors technical documents.
• Led team in designing high scaled OLTP and Data Warehouse databases.
• Solved many performance issues on SaaS based applications.
• Implemented ILM to reduce disk utilization and compliance data retention policies and saved millions of dollars in storage cost.
• Designed database security protocol utility to manage database access across IT.
• Designed/configured/implemented Portal Health Tool to monitor online application performance.
• Installed Oracle 8i/10g on various Unix/Linux/Windows platforms, created Oracle10g OMS dB, deployed RMAN and configured/implemented backups with TSM/Veritas Backup, implemented StatSpack, Oracle Name Server Configuration, Oracle Connection Managers, LDAP and 10g grid configuration.
• Maintained 24/7 Logistic application which have 8TB of Size using different tools like (Gentran/Cyclone/Prospero/Weblogic/IIS/Tomcat/Appche/SiteScope)

Confidential, NJ

Sr. DBA and Team Lead

• Data migration Form DB2 to Oracle.
• Database administrator, database tuning, performance tuning, backup and restore.
• Database Replications between remote databases.
• Data Modeling (conceptual, logical and physical) using Erwin.
• Data Warehouse (designed dimensional model using Eriwn.)
• Designed Physical and Logical database.
• Backup and Recovery - Implemented cron jobs, backup routines, which includes database exports, tape backup and copying database files for recovery operations
• Written Shell Scripts for RMAN backups and restore.

Confidential

DBA /System Analyst/Programmer

• During this period worked on various projects as oracle PL/SQL developer, system analysis and design, database administrator and data modeler in India for local and international clients.