SUMMARY:

• Highly - analytical, performance-focused and results-driven professional, offering comprehensive experience in project management, object modeling, database administration, and data warehousing architecture.
• Adept at developing enterprise database models and integrating business silos systems.
• Articulate communicator capable of working with key stakeholders and promoting the need for architecture.
• Strong experience in leading and mentoring to analyze, extraction, transformation, data sanity, data integration, Big Data and MDM.
• Extensive knowledge and experience in business requirements analysis and quantitative data analysis.
• Exemplify strong competency in designing complex applications and systems for various industries such as financial, sales, banking, health and human welfare services and manufacturing.
• Has excellent Time Management and Task management capabilities to work on multi-faceted roles and multiple projects.
• Strong technical experience to develop, design and implement various facets of SLDC.
• Versatile and flexible to learn and improve work performance, efficiency and knowledge constantly.
• Knowledge of Big Data, AWS Solution Architect and Cloud Computing.

TECHNICAL SKILLS:

Databases: IBM DB2 LUW, IBM DB2/Z-OS, Oracle, Microsoft Access, Microsoft SQL Server, DB2 Q-Replication,MySQL,EssBase, SMSS, SSIS

Programming Languages: C, C++,C#, COBOL, SQL, JCL, CLIST, REXX, HTML, Java, Perl, AWK, JSP, JSON, Shell Scripts, Phython

ERP/E-Business: Ariba, I2 Knowledge Computing, SAP R/3, Peoplesoft, and SAP BW

Case Tools/ DataWarehouse/ DataModeling: ER-Win, COGNOS, Business Objects, SAS for Analytics, MS Visio, Rational Rose(Booch), DBArtisan, BMC Tools, ER/Studio, UML, Allfusion Model Manager, Websphere MQ, Kafka

Change Management Tools: ClearCase, Remedy, IBM Change Management,Dimensions, JIRA

Debugging Tools: TOAD, Debugger, Windows Debugging

Reporting Tools: SQR, Crystal Reports, SAP Business Objects, SalesForce,Qlik, Epicor, MicroStartegy,YelloFin,Tibco

Software: PowerBuilder, .NET, TSO/E, ISPF,CICS, ODBC, JDBC, Netwise, Version Control, SAS, MQFT, MQ Series

Hardware: PC, Xeon, IBM Power Series, Sun Sparc

Architecture: Multi-tier, Internet/Intranet/Extranet, Client/Server, Object Oriented, Messaging, MicroService Oriented

ETL Tools: Manual transformation and load process, Informatica PowerCenter and PoweExchange, Ab Initio

Operating Systems: Unix, AIX, Linux, IBM Z-OS, Windows, Virtual Machines

Software Development Lifecycle: Waterfall, Agile, Evolutionary, Continuous Integration and Continuos Development.

Cloud Computing/ Virtualization: VM Ware, AWS, BIGDATA Tools, Cloud Computing, Hadoop, AWS, Spark, NO SQL Databases, MapReduce, Docker, Stata, R, MatLab, IBM Infosphere Products for DataAnalytics and DataManagement, IBM PureData Analytics, IBM BigInsights, Splunk, GIT, Jenkins, Ansible, Puppet, Docker, DevOps, Apache WebServer, Apache Spark,Chef.

PROFESSIONAL EXPERIENCE:

Confidential, DC, VA

Sr. Data Architect/ Sr. Database Administrator

Responsibilities:

• CBP automated systems facilitate the electronic importing and exporting of goods, the Automated Commercial Environment (ACE).
• Rendered effectual support to the trade modernization to be used on all transportation technologies in support of the project Java, Hibernate, Weblogic, Oracle, Oracle EPM, Essbase, Hyperion, IBM DB2 9.5 DPF, v9.7 DPF, 10.5 LUW & OLTP, IBM BLU, IBM Portal, WebSphere, Datawarehousing, DataReplication, VM ware, Toad SQL for Developers, SQL Server, SMSS, SSIS, and ERwin tools. DataIntegration/Conversion from various Legacy systems, SAP, Peoplesoft systems and Unstructured Data to the Modernized system.
• Architect with Engineering Teams and System Teams for business functionality needs. Maintain Data Models for both Transactional and Enterprise Data Warehouse using ERWin.
• Providing MDM solutions including source identification, data collection, data transformation, normalization, rule administration, error detection and correction, data consolidation, data storage, data distribution and data governance. Applying MDM for CDI ( Customer Data Integration).
• Architect DataMart’s for Business Analytics and Reporting for Auditing, Data Changes. Data Integration Techniques and Solutions.
• Monitor and support 24X7 Production Databases on Very High Transactional Systems, 25 node DPF Data warehouse along with other 100s of Transactional Databases
• Write Scripts for Creating Instances & Databases, Maintenance (Backup, Runstats, Reorgs) and Monitoring of large number of Databases supporting various business verticals teams.
• Install and support upgrades SQL Servers Cluster for High Availability, DB2 LUW APARs, Performance Tuning, Full lifecycle Development/Maintenance of databases and support 24X7. Support Replication and Data Mirroring.
• Lead efforts for Data Extraction ( ETL), Data Analysis, Data Masking, Data Auditing and resolving Data Anomalies.
• Design and Architecture very large Data Conversions efforts from different sources Legacy and Other COTS products system like SAP, Oracle. Maintain Data Integrity and Business Integrity during conversion efforts.
• Working with Security, Development and Auditing Teams to identify appropriate access to developers and users as per customer requirements. Creating Databases and Granting appropriate Roles to users and groups.
• Work on SOP identifying detailed Methodology and Procedures, Scope and Applicability, Risks and Issues.
• Design and document efficiently UML, HLD ( High Level Design) and LLD ( Low Level Design).
• Work with Oracle Tech Support to identify PSEs and PSUs ( fixes) for realtime issues, Testing and Applying it.
• Study and Identify new Technology to broaden and Improve Business Analysis, Data Movement, Data Integration.
• Communicating with Program Managers the solution details with risks/issues, escalating and involving vendor technical support teams for resolution.

Confidential, Baltimore,MD

Sr. Database Architect/ Sr. Database Administrator

Responsibilities:

• Offered support in maintaining database models for all environment lifecycle. Technology used Java, Weblogic, Oracle, Hyperion, IBM DB2 9.5 DPF, v9.7 DPF, 10.5 LUW, IBM Portal, WebSphere, Datawarehousing, DataReplication, VM ware, Toad SQL for Developers, SQL Server, SMSS, SSIS, and ERwin.
• Led the development of procedures and scripts to install system test/integration databases.
• Maintaining and supporting 24X7, creating schemas and tables on DB2 Z/OS, Performance tuning and Maintenance using JCL, Rexx, Clists and Spufi for Backup, Restore, Reorgs and Runstats.
• Reports for Business Analytics / Intelligence Tools and support Enterprise Data warehouse efforts.
• Conceptualized support, change management, and lifecycle deployments throughout all database systems while maintaining regular reports for Data Dictionary and attribute differences using ERwin.
• SAS and MatLab to perform Analytics reports for Users and Business needs for Claims Trends, Fraud Prevention.
• Lead efforts for Data Extraction ( ETL), Data Analysis, Data Masking, Data Auditing and resolving Data Anomalies. Working on different business silos towards Enterprise Data Model.