SUMMARY:

• Senior IT Leader with significant progressive experience in Big Data Hadoop System Architect/Administration, Database Architect, Data Warehousing, System Administration and Benchmarking.
• Strong analytical skills complimented by excellent database technology skills.
• Demonstrated expertise in Analysis, Design, Database Administration and Development of Management Information Systems for complex projects utilizing Software Engineering Life Cycle.
• Effective communicator and relationship builder, providing forward - thinking, innovation, and professionalism at all times.

CORE COMPETENCIES:

• Database Architect
• Big Data
• Database and System Administration
• Data Warehousing

TECHNICAL SKILLS:

• DB2/V10.5
• Oracle 10g/11g
• Sybase
• MSSQL 2005
• Perl, Korn
• DMS/DPS1100
• Informatica
• PeopleSoft
• HTML, Java
• SQL/SQR
• C, C++
• MQSeriesSRDF
• MS Project
• MicroStrategy
• WebSphere, J2EE
• Unix/Linux
• TeraData/DataStage
• Red Hat, AIX
• Confidential
• Windows
• SAS, Q REP
• Mainframe
• Vertica
• Solaris

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

Big Data Analytics/Architect

Responsibilities:

• Production Architect/Admin Support for Hadoop Cluster and NoSQL Cassandra.
• Responsible for Design & Architecture of Hadoop/Kafka Data Domain Project.
• Managed Banking Center/ATM Database using multiple technologies including DB2, SAS,Q-REP and Hadoop environment for SAS Fraud Management applications.
• Worked with Data Warehouse applications using Confidential, Teradata, DB2 and Vertica.
• Facilitated migration project using Cloud Architecture.
• Managed various migration projects moving from AIX to LINUX with Cloud Architecture. Responsible for strategic planning and implementation Hadoop Cluster.

Confidential, Fishkill & Yorktown Heights, NY

Senior Database Consultant/Senior Database Architect

Responsibilities:

• Responsible for Confidential Database migration for DB2 Databases/Warehouse applications with Confidential environment for Confidential project DC2015; worked 24X7 for this migration.
• DC2015 is Data Center migration from one location to another physical location including new hardware, OS level and version of DBMS software with new production applications including Data Warehouse application on Confidential in the new location.
• Responsible for final migration, pre migration test, quality assurance, performance tuning and testing. Migration was completed on time for the complete project.
• Mainly involved in Database Design and Architecture for new applications and current Database.
• Architecture on new Hardware/Software Platform for High Availability DR setup.
• Responsible for 5TB database Administration and supporting 700 servers for AIX support. Data/server migration, reporting, server maintenance and database maintenance.
• Maintained critical applications on DB2 with HADR and HA Clustering production database using TSA.
• Managed Database Design and Migration and 24X7 production support.
• Responsible for database architecture in a Global Storage Architecture Environment.
• Managed all customer requirements effectively for Chip Design Data Warehouse application. Involved in Data Quality and Data Assurance from various sources.

Confidential, Long IslanD City, Ny

Lead Database Engineer

Responsibilities:

• Responsible for Confidential Database migration for DB2 Databases/Warehouse applications with Confidential environment for Confidential project DC2015; worked 24X7 for this migration.
• Responsible for Database Design and Architecture of new applications on new hardware platform for many Data Warehouse applications using Informatica for Meta Data Management and ETL.
• Managed a team of up to 25 DBAs supporting 3 LOB critical applications and Data Warehouses in a production environment.
• Provided support for DB2,Oracle & MSSQL; Installed DB2, Oracle, MSSQL software for many application databases.
• Supported AIX software maintenance, performance tuning, problem determination and resolution for many critical application databases.
• Responsible for upgrades and involved in database migration from old P690 servers to P595 servers.
• Managed Sev1 Critical Issues and resolution. Used SRDF Technology for some applications.
• Worked with Confidential V8, V9 in HADR and HACMP clustering environment. Worked with various storage setup including EMC, Shark and other storage devices.
• Worked with Java, WebSphere, J2EE application Architecture.
• Responsible for Data Quality and Data Governance for many applications.

Confidential, Poughkeepsie, Ny

Production DBA Consultant

Responsibilities:

• DBA Support on DB2/EEE & DB2/EE, LINUX/UNIX/AIX and Windows for internal and external customers.
• Extensively provided DBA support on AIX, Linux and Windows; resolved issues on time.
• Very good experience problem solving for all DBA issues for commercial accounts; acquired multiple skills to handle all technical difficulties for the customers.
• Worked with all DB2 versions up-to-date from 5 to 8 and supporting more than 300 servers for all projects assigned.
• Worked with various storage including EMC, Shark, SAN and TSM. Responsible for all Data Warehouse applications and databases for all financial accounts.
• Worked with WebSphere, J2EE applications extensively for Design and Architecture. Involved in Design and Modeling Data warehouse applications for financial customers including Meta Data Management. Involved in Data Quality Assurance and Data verification test.