SUMMARY:

• Accomplished and dynamic professional with 20+ years of experience, recognized for consistently achieving organizational goals, and ability to deliver various aspects of operations with extensive experience in handling enterprise Big data architecture, database and data warehouse architecture, data modeling, and project management and coordination. Dependable and exercises independent judgment and decision making abilities in designing, implementing and maintaining database architecture, data standards and strategy across the enterprise. Highly reliable and detail - oriented professional with excellent project management skills with a high sense of diligence and ability to effectively multi-task several complex assignments with tight deadlines. Proactive, with a team-oriented attitude possessing strong analytical and interpersonal skills coupled with excellent written and oral communication skills.
• Software & Application Design System Implementations Expertise in Big Data / Hadoop Ecosystem technologies Data Lake Design & Implementations Data Warehousing & Administration Troubleshooting & Technical Support Database Design & Implementations Systems Assessment & Configuration Data Modelling Expert - Star & Snowflake schema designs. Project Management

TECHNICAL SKILLS:

Technology and Tools: Oracle 10g, 9i, DB2/DB2 UDB 8/9x, SQL Server 7/2000/2005/2008 R2 PDW, Teradata, Sybase Sql Server Reporting Services, Cognos Reportnet, Business Objects (Reporter, Designer, Supervisor) XIr3.1, 6.x, Micro Strategy Sql Server DTS, SSIS, Informatica Power Center 6.1/7.1/8.1.1/8.4 & 9.0, Cognos Decision Stream/data manager 7.1/8.3/8.4, PL/SQL, PIG 0.10.1, Hive 0.11.0, HBase 0.94.8, ZooKeeper 3.4.5, Sqoop 1.4.2, Flume 1.3.1, Mahout 0.7, Oozie 3.3.2, PivotalHD 1.0.1 ER/Studio 7.1, 8.0, 8.5, 9.0 data architect, ERWIN 7.2, Visio, Architecture Framework TOGAF/ ZACHMAN, SMP/MPP VERITAS net back up, SQL Litespeed, MS Project, SQL, TOAD (Tools for Oracle Application Developers), DBArtisan, Visual Basic 4.0/5.0/6.0, Cobol, Pascal, SQL, HTML 4.0/XML, C, C++, C#, Java, JavaScript, ColdFusion 4.0, Broadvision 4.1, 5.0, 5.5, 6.0, CICS, TSO/ISPF, MVSJCL, Datamirror Transformation Server, Documentum WebTop, Documentum xDB.

PROFESSIONAL EXPERIENCE:

Confidential, New York, NY

Information / Big Data Architect

Responsibilities:

• Working as Big Data Architect with DESS (Digital Enterprise Services & Solutions) team to provide quality tech solutions to multiple clients on Analytics & Big Data/Hadoop technologies with primary focus on Information & Big Data Architecture. Currently leading Axa USA Big data team to implement Big data architecture initiative & Data lake on Cloudera CDH 5.3.2
• Designed & implemented two Big data Platforms, BigPlay and DaaS to support the whole lifecycle of data projects. The BigPlay platform will be primarily used by Data scientists to dig into real data on test & Learn and define the algorithm, develop predictive models that brings value to the Business. The DaaS platform is production mode where predictive models are packaged and deployed as an application. The applications will run automatically to provide fresh inputs to the targeted business operational systems.

Environment: -- CDH 5.4.5, PIG, HIVE 0.13.1, Beeline 0.13.1, Sqoop 1.4.5, Flume, Oozie 3.2, Sentry 5.3, Impala 2.1.2, Hue 3.7.0, Map Reduce, Cloudera Navigator, NoSQL HBASE, Solr 5.2.1, Spark, R 3.1.2, Python 2.6.6.

Confidential, New York, NY

Enterprise Data / Solution Architect

Responsibilities:

• Primary objective of the ACT initiative is to modernize current aging Agency Compensation and Agency/Producer Administration technology platforms. Business vision is to establish a shared service model delivering common compensation and producer administration processes across all profit centers. Major focus of this project revolves around Customizing & deploying a single vendor solution for Compensation calculations and Agency/ Producer Administration ( Confidential ).
• Designed Operational data store (ODS) to host & consolidate the compensation data (Transactional & ) from multiple sources which in turn will serve as the source of agency/agent and compensation data for ACT platform. Established centralized data definitions and controls by governing ODS data access by application architecture principles thus minimizing the data duplication across BTS areas.
• Established ODS Governance to involve all consumers and service providers in decision making.
• Assist business in performing data cleanups based on ODS audit & recon report;
• Played a key role in Implementation of Confidential , Inc. ’s Sales Performance Manager (SPM) as a new Compensation and Producer/Agency Administration platform which involvedDesign & implementation of various interfaces to add commissionable policy transactions to ODS to be used by Comp vendor package ( Confidential ).
• Designed & implemented POC by moving the Agency/Agent/Policy data into Hadoop & built the predictive model for forecasting.

Environment: DB2 9.7/10, Sql Server 2008 R2, Oracle 11g, IMS, Informatica 10, SSIS, Business Object XIR3.1, Windows 2008, AIX 5.3, Autosys, ERWIN Data Modeler 7.3, Toad for Oracle & DB2, Java,/Web Services, C# .Net, CDH 4.1, Pig, Hive, Sqoop, Flume, Oozie, MapReduce, Python

Confidential, Peapack, NJ

Enterprise Data Architect

Responsibilities:

• Designed Data Warehouse (Multi-dimensional Star schema) for PGM Quality Operations, comprising of PfLICC ( Confidential Library of Product Information & Change controls), PCOM (Product Complaints) and PDOCS (Products Documents management control systems) applications. The new Quality Operations DW will be replacing cognos with business objects as a part of Enterprise reporting tool for all Confidential BI applications. DW is designed to povide a global view of QOP information across Confidential, legacy Wyeth and CLIENT sites.
• Designed & implemented MDM Hub for Product data in order to maintain the product hierarchy for the Confidential /Wyeth merger.

Environment: Oracle 10g, Informatica 8.4/9, Business Object XIR3.1, Windows 2003/2008, AIX 5.3, Cognos Data Manager 8.4, Report net Studio, ERStudio Data Architect 9.1, MDM, Autosys, OBIEE 10 g, Data flux 8.0, Toad for Oracle, Documentum xDB

Confidential, Memphis, TN

Enterprise Data Solutions Architect / Lead COE BI

Responsibilities:

• Designed CIS (Customer information system) to provide the Corp Customer View involving the key customer data such as individual/property/address info/ demographics & psychographic information’s embedded with the scoring information for the customer. This also involves integration of the CIS with the Ecommerce CIS application. Responsible for providing seamless integration of the major brands(Trugreen & Terminix) data coming from the db2/400 systems with other brands data coming from SQL2005/Oracle 10g & load into SQL server data marts & EDW on oracle on AIX platform.
• Lead the center of excellence for BI in Confidential . Responsible for Defining, designing, implementing & maintaining the enterprise database architecture, data standards & strategy across the enterprise. Set up the Data mart/EDW Designs & ETL standards in order to provide structured environment for the data warehousing, ETL & Reporting processes.

Environment: SQL Server 2000/2005, DB2 UDB 8.1, Oracle 10g, MDM, Windows 2003, AIX 5.3, SSIS, Cognos Data Manager 8.3, Report net Studio, OWB 10.2.1, Business Object 10, Sql Lite Speed 2005, Embarcadero DB Artisan, ERStudio Data Architect 8.5, 9.0.1, C#.Net, SAS 9.1

Confidential, Saint Joseph, MO

Enterprise Data Solutions Architect / Project Lead

Responsibilities:

• Responsible for identification of business processes, applications and data sources that will feed the EDW. Defined and created auditable processes and documentation for all DW activities. Designed data storage and processes that allow content management & allow business performance analysis across business lines. Identified data entities that should be generic across business lines for analysis and reporting of account and chase performance.
• Designed & implemented the Change Data Capture (CDC) process for the ODS data load from the transactional system.

Environment: SQL Server 2000/2005, Sql Lite Speed 2005, DB2 UDB 8.1, Oracle 9i/10g, Windows 2000/2003, Informatica 7.0/7.1, Business Object 6.5, Embarcadero DB Artisan, ERStudio 7.0 / Data Architect 8.0, C#.Net .

Confidential, Sturtevant, WI

Data warehouse Architect

Responsibilities:

• Designed the process to integrate the sell-through data from the BPCS system with direct sales data from the DSIS system & load it to the ODS JDESales Data mart. Responsible for designing the ETL processes for loading sales transaction and customer/Product master data related to open order/ invoice order facts to JDESales Data mart. Provided help & expertise to replicate the data from the db2 sources to the staging central repository using the Data Mirror Transformation server & then design ETL strategy to load into the JDESalesDM using informatica.

Environment: MS SQL Server 2000, Windows 2000, Data Mirror 5.1 Enterprise Administrator server, Autosys, Informatica 6.2.1, MDM, Business Object 5.1.6, DB2 UDB 8, OS400

Confidential, Jacksonville, FL

Data warehouse / Database Architect

Responsibilities:

• Designed and Developed oltp/olap databases to support vertical automotive industry business application products in a portal for an industry leading data acquisition and Product development Company, Confidential, LLC. The portal provides access to clients to all licensed applications in a single sign-on mode, and all security is handled by role based in each application. Primarily involved in designing all application databases of the portal, Data Engine, Lender Penetration and Business Development Center.

Environment: MS SQL Server 2000, Windows 2003 and Crystal Reports 9.0, MS Analysis services.

Confidential, Dallas, TX

Data warehouse Architect

Responsibilities:

• Lead an onsite-offshore data-warehousing project for JCPenney. Developed & implemented a custom event planning application database that supports the creation of the event planner, allocation of media, projection of the advertisement spend by media & event, allocation of the advertisement spend, & media responsiveness analysis in order to support the Marketing Event Planning.

Environment: MS SQL Server 2000, Windows 2000, DB2, Teradata, Access 2000, Oracle 8i, Informatica 5.1, JCL.

Confidential, Franklin lakes, NJ

Data Architect / DBA.

Responsibilities:

• Designed a database supporting the Drug coverage & drug pricing engine along with the details for an online pharmacy application for Merck written in JavaScript, C++ and Broad vision with a backend as Oracle. Confidential t and Prescribers information is stored and displayed online through Internet.

Environment: MS SQL Server 2000/7.0/6.5 , Windows NT 4.0, MS Analysis Services, Oracle 8i.

Confidential, Bentonville, AR

Data Warehouse developer / DBA

Responsibilities:

• This project mainly involved DW data migration from existing Teradata server to new Teradata server of higher capacity (45TB). Responsible for Standardization and externalization of JCLs, cloning existing JCLs and creating parallel jobs for loading of new Teradata db server. Develop/modify existing ETL code for faster data loads & performance tuning, Designed & deployed the data archival, back up & restore strategy.

Environment: MS SQL Server 6.5 /7.0, Windows NT 4.0, DB2, Teradata 2.x, Sybase 11.9.2, VS COBOLII, JCL.