SUMMARY:

• Over 17 years of experience, providing data solution aligned with the enterprise goals and objectives and follows industry best practices and standards.
• Expert in comprehensive applications analysis, design, development, testing, implementation, Systems Integration, Data Migrations, Data Conversions, Decision Support/Reporting Systems, Performance tuning and some Oracle Database Administration, using the Oracle RDBMS on UNIX and LINUX platforms.
• Worked with companies associated with the industries: Insurance, Advertising, Financial Services, Banking and Finance, Telecommunications, Manufacturing, and Risk Management and Credit Analysis etc.
• Record of accomplishment for successfully creating short - and long-term IT vision that is relevant to diverse and complex businesses, communicating it to the leadership in a powerful and persuasive manner, and systematically implementing the vision.
• Sparks new initiatives that provide cumulative positive effect and builds morale along the way; eventually reduces operational costs through transparency and consensus.
• Worked on development of business and information architecture governance structures and compliance activities, ensuring that Enterprise Architecture is recognized as a game changer by appropriately balancing “what is right” with “what is realistic” through practical project governance and guidance while keeping the eye on the big picture.
• Provide strategic and operational direction for the planning, designing, implementing, and maintaining information technology environment including disaster recovery.
• Proactive, dynamic, and well-rounded IT professional with outstanding personal, communication, execution, and leadership skills. Performed mentoring sessions.
• Worked with business and outsourced partners to achieve corporate goals and able to motivate people and manage large teams in mission critical environments.
• Experienced in cross-disciplines of information, application, technology, and business architectures and bringing consensus across stakeholders and team members.
• Self-Starter and can work independently under minimal guidance with regular alignment with Global Lead for Enterprise Business & Information Architecture

TECHNICAL SKILLS:

Data Modeling: Relational, Dimensional, Objects & NoSQL

Oracle, MS: Sqlserver, Teradata, PostgreSQL, MySQL, DB2, Informix. PL/SQL, T-SQL, HiveQL, Pig, Perl, PHP, Python, C, C++, Pro*C. Informatica, Ab-Initio, Oracle Warehouse Builder, Data Integrator, Gloden Gate, Streams, ESB (IBM Web sphere MQ, Mule, JBOSS, Dataflux. Java, J2EE, JSP, PHP, JMS, JSON, HTML, XML, WSDL, SOAP, REST, SaaS.

Hadoop: Hbase/Casandra, NoSql - Mongo/Riak UC4, KSH, CRON, Autosys, Job Schedulers FLUX, QUEUE Manager, Apache Zookeeper, Vmware, Citrix, Virtualbox.:

Oracle Forms: Reports, Discoverer, Tableau, Business Objects, Oracle E-Business Suite, Business Intelligence Oracle Fusion SOA Suite, TIBCO, SAP, SFDC(CRM), SIEBEL. Clear Case, GIT, Tortoise SVN, WinCVS, Perforce, Ant, Maven, Kintana. UtPLSQL, Maui, TestNG, Cruise Control, Hudson, Bamboo, HP Quality Centre, JIRA Mega, Erwin, ER/Studio, Power Designer, MS-Visio:

UNIX: (Solaris, HP), Linux, Windows, DOS, z/OS.

PROFESSIONAL EXPERIENCE

Data Architect

Confidential, Bloomington, IL

Responsibilities:

• Performed data architecture, data modeling and data integration to redefine and redesign the enterprise billing, payments & disbursements systems solutions at Confidential .
• Worked with a force.com (Salesforce’s development platform) development & implementation teams to integrate the organization’s business rules of single source within data movement design for billing and payment systems data movement.
• Defined data movement target architecture for billing and payment systems to convert and synchronize information related to billing, payments & disbursements.
• Organized and lead teams to develop and refine conceptual data information models and extended conceptual models with business rules to develop logical data models.
• Evaluated alternatives for integrating legacy data sources with enterprise relational models and strategies for transactional and analytical systems for effective sharing of data.
• Defined data conversion strategy for the Billing product built on Oracle 11g and 100’s of PLSQL API’s for data load, transform, validate and reconciliation.
• Worked on data profiling, data integrity and analysis, data governance, data quality of Policy Admin Systems Data to convert to STG Billing.
• Identified and defined functional and non-functional requirements in partnership with Business Architects and Business Analysts for the data movement from various sources to Billing and Disbursement systems.
• Lead SOW to identify impact of billing batch processing on operational data store and recommend solutions to optimize the batch processing for huge volume of data 24/7.
• Worked on SOW to evaluate benefits of 4 node Oracle RAC vs. 8 node engineered Oracle Exadata solutions for anticipated data growth and daily volume processing.
• Worked as data Integration designer to define data transformation, matching and cleansing rules under master data workbook for the data elements involved in data movement to billing systems.
• Working on developing data flow, data topology diagrams to help present data placement and movement across different systems using E/R Studio and Mega modeling tools.
• Working on development of conceptual, logical, physical data models in partnership with systems analysts, business partners and business analysts and data designers.
• Working with enterprise architecture team to build enterprise metadata information for data governance, data security, and to support reduction of data redundancy and fragmentation with single source, and improvement of data quality.
• Working on data archival strategy, data recovery, and backup & restore strategies for newly identified data stores and existing data stores.
• Lead ETL architecture solutions to integrate Billing system with multiple subsystems within enterprise using Informatica and Mule/Webshpere ESB.
• Working with lead developers and systems analysts in designing and development of information mappings, sessions, workflows, worklets, re-usable transformations, maplets etc.
• Working on identifying and developing data architecture artifacts and decisions around data movement, integration and replication strategies.
• Worked with data leads on canonical model design for long-term data conversion and integration proof of concept.
• Working with enterprise architects in developing/modifying database policies, guidelines, standards, procedures for data design and allowed values.
• Working with enterprise architects to define standards and mastering of allowed values under metadata access repository and retrieval of these allowed values using different access methods.
• Working with Developers and DBA’s to participate in SQL Performance review, SQL tuning and optimization to reduce CPU consumption and response time and increase integration/operability of systems
• Participate in vendor product reviews, product evaluation, identification of GAPs, solutions recommendation for GAPs and product implementation.
• Working on evaluating data management tools and organizational data management issues.
• Working on decisions to analyze and identify analytic needs within development centers for unstructured data.

Lead Database Consultant

Confidential, San Jose, CA

Responsibilities:

• Worked on developing high level specifications and detailed specifications document development.
• Lead database development effort for config team to implement standard practices of DB development
• Worked on oracle 11g upgrade for real-time code deployment using advanced features online table redefinition etc.
• Worked on identifying needs of development of new schema, tables and indexes required for ongoing development for Q2O and Q2C integration.
• Developed and implemented unit and component test plan and scripts.
• Worked on support related to existing stored procedures, functions and packages as per C3 standards using standard API’s that were related to Service Contracts etc.
• Worked on Q2C and Q2O integration using PLSQL API’s and deployment and automated testing of the code on multiple integrated environments.
• Performance tuned the stored procedures using advanced PLSQL techniques like Function Result Cache, Query Result Cache, Nested Collections, TABLE operator
• Worked with Automatic SQL Tuning, SQL Plan Management, SQL Access Advisor to analyze and tune poor performing PLSQL code
• Worked on oracle 10g to 11g upgrade for real-time code deployment using 11g advanced features online table redefinition
• Wrote stored packages, procedures and functions to implement required business functionality.
• Wrote and Implemented utility for dynamic partition purge and split fast growing log tables.
• Performance tested OLTP SQL queries using SQL object types in PL/SQL collections.
• Extensively used advanced PLSQL techniques of VARRAY, BULK COLLECT, PIPELINED FUNCTIONS, hints, range and interval partitioning, histograms, bitmap and b-tree indexes.
• Worked on design, development and implementation of migration strategy for C3 using PL/SQL API’s
• Engaged in development of Informatica mappings, sessions, workflows, worklets, re-usable transformations, maplets etc.

Lead Database Consultant

Confidential, San Jose, CA

Responsibilities:

• Lead billions of records and complex data structure migration design, development, test and implementation from heterogeneous source databases like SQLSERVER, Oracle and Teradata.
• Lead the effort of schema design on relation database (Oracle) and dimensional database design (TERADATA) using Sybase power designer.
• Worked on performance tuning for poor SQL Queries of high volume batches on oracle non-RAC database to reduce CPU time, Logical & Physical Reads, Undo, Redo size.
• Lead efforts of data model optimization, performance tuning of SQL queries on databases like oracle and Teradata to reduce CPU time, Logical & Physical Reads, Undo, Redo size of each transaction etc.
• Lead the effort of Teradata DB design and performance tuning of existing processes using parallelism and volatile tables.
• Worked on Oracle Gloden Gate proof of concept for change data capture between SQLServer and Oracle.
• Worked on ETL processes scheduled automation using Ab-Initio, UC4, SQL*Loader and Shell/Perl scripts to contribute towards ETL test framework designed for Paid Search.
• Worked with other architects to ensure optimized logical and physical data models for new and current applications to reduce ETL and end-user data access times
• Worked on MySQL DB for for KW ID Service API for millions of Keywords categorization and caching.
• Worked on Teradata tools and utilities: TPT, FastLoad, FastExport, Multiload, TPump, BTEQ, DBQL, Priority Scheduler, TASM, Teradata ViewPoint, SQL Assistant, Teradata Administrator, Teradata Manager, PMON
• Worked on UC4 job scheduling tool for process automation, file transfer, data extract and load, test automation, scheduled job execution, and controlled job monitoring.
• Worked on data integration with Web based application developed using PHP, JAVA which involves SaaS/SOA services and products.
• Worked with In-house Developed Java Scheduler(Queue Manager) and Apache Zookeeper for scheduling, dispatching and controlling of jobs for better performance and handle concurrency using Vmware virtual hosts and multiple application servers.
• Knowledge to work with Hadoop platform for data mining of crawled data received from various source systems like (amazon, shopping.com, google) using MapReduce, Pig, HiveQL, Python scripting.
• Worked on Tableau to design and publish automation reports, review and test published reports related to cost and conversion metrics used for paid search project

Lead MDM Consultant

Confidential, Sunnyvale, CA

Responsibilities:

• Lead the MDM team to provide guidance and support in the development of information analysis, data quality metrics and metadata capture.
• Worked closely with Business project managers and QA Leads and Release Management for project release planning, minor releases, milestones identification for strategic data source and third party downstream services integration & fix pack Planning, Implementation strategies and Schedule .
• Worked on Oracle E-Business Suite - TCA architecture for customers, prospects and partners master data with Oracle Customer Data HUB (CDH) using Oracle Fusion and TIBCO middleware to integrate change data with SFDC (CRM), SAP, Oracle ERP, Siebel, and eDW.
• Implemented Informatica MDM Hub configurations- Data modeling& Data Mappings (Landing, staging and Base Objects), Data validation, Match and Merge rules using Data Quality Workbench & Address Doctor.
• Integrated D&B data feeds to enrich existing customer and partner data and merge/update relationships and hierarchies.
• Ensure accountability across all teams on issues and technical & resource dependencies. Establish clear ownership and resource plans for critical parts of the Integration Architecture.
• Ensure that Business, Data Governance and Integration team leads are deeply involved in critical design issues and decisions.
• Orchestrated BPEL process to integrate Oracle E-Business Suite Receivables and Payables Module with external applications/Flat Files to handle data conversion, transformation and fault handling.
• Worked on Oracle Business Events, Message Queuing and designing integrated business interfaces to transfer data between legacy systems.

Senior Database Developer/Data Architect

Confidential, San Mateo, CA

Responsibilities:

• Completely re-architected, re-designed and re-wrote the Data Warehouse and ETL processes, theirby making them more scalable, reliable and improved process performance by 15 - 20 times. Took complete ownership of the entire project from design to deployment. This projects focus was on large customers with millions of accounts to scale the performance of feed file processing and alerts generation.
• Architected, designed, developed and implemented Alerts Generation process, which allowed millions of users to configure their accounts monitoring for each data element change and alert them by emails etc.
• Designed data marts to transform and load multi-terabyte of data for analytics and reporting.
• Developed and maintained logical and physical data models using CA Erwin as modeling tool.
• Optimized 100+ million records feed files processing USING ETL techniques of data extraction and transformation using PERL scripting, data cleansing and loading using SQL*Loader and PLSQL stored procedures.
• Performance tuned the ETL processes for portfolio wise alerts generation and datamarts update using partition wise processing of millions of records staged. The tuning gave 10x performance to batch process compared to earlier way of processing.
• Extensively used Oracle Enterprise Manager (OEM), Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM), Active Session History (ASH), STATSPACK, TKPROF, and EXPLAIN PLAN.
• Implemented and enabled streams replication on tables/schemas to help implement high availability cluster for alerts generation.
• Implemented locally managed tablespaces, Automatic Segment Storage Management (ASSM), Partitioning, Global temporary tables, Flashback, etc. to support development/testing/UAT/SVT/pre-prod environments.
• Carried out Database cloning, setup data guard, benchmarking before implementing new database features or new functional enhancements or database upgrade/patching involved in different platform projects.
• Optimized automated account review batch process, converted the PL/SQL collections code into GTT INSERTS by breaking big queries into smaller manageable pieces of data with GTT, and improved the performance by 6 x.
• Partitioned the tables with high growth using RANGE, LIST AND HASH partitions for easy data management and backup.
• Worked on design and development of data migration architecture of Premium customers to Upgraded version of database with enhanced features and modified data structures.
• Performed the setting up, Installation and configuration of the complete Analytics platform environment and the required connectivity for seamless integration with the data warehouse.
• Worked on development of subject area RPD models and development of BMM model complex join standards and guidelines.
• Created requests/reports using Answers and embedded them in dashboards for group of users.
• Worked on alerts service and global monitoring service developed using Service oriented Architecture(SOA), EJB, XML, MQ’s
• Designed and developed informatica workflows, sessions, maplets, mappings and transformations to load data from heterogeneous sources using ELT and ETL techniques into multiple datamarts.
• Defined strategy to allocate disk and memory between OLTP and batch nodes for Alerts Service database.
• Did capacity planning for Alerts Service RAC database based on business requirement and growth of data per year.
• Written over 20+ packages to load and transform data from QUEUE’s using PLSQL advance techniques like DYNAMIC SQL, BULK UPDATE, and PARTITION WISE DELETES etc.
• Worked on batch process optimization using advanced plsql techniques like multitable inserts, DMLS error logging, DYNAMIC SQLs, Parallel Query Processing, Bulk Collections with Limit clause, parsing Clob’s etc
• Worked on performance tuning to optimize batch and UI queries to reduce down CPU time, Logical & Physical Reads. Undo, Redo etc on production system.
• Monitoring production system nodes for resource utilization and analysis through iostat, vmstat, sar, AWR and ADDM reports, generating reports through trace analyzer for better performance recommendations of existing Queries
• Wrote around 15 packages and 100+ stored procedures and functions, triggers.
• Developed Shell and Perl scripts to automate data cleansing of feed files and data transposition using awk and sed Scripts