SUMMARY:

• Over Fifteen (15) Years of IT full life - cycle experience managing, designing, implementing performance oriented database design & development, database administration, data analysis, data acquisition, conceptual / logical / physical / multidimensional data modeling, data warehousing working as Database Developer / Data Modeler / Data Architect.
• Performed Database Development of Oracle Databases for nine years.
• Performed Database Development of PostgreSQL Databases for one year.
• Performed Database Development of Microsoft SQL Server Databases for five years.
• Performed Database Development of DB2 Databases for seven years.
• Performed Data Architect role for six years.
• Executed UNIX/Linux Kernel parameters tuning, SQL query tuning and capacity planning.
• Developed and implemented PL/SQL programs, SQL, UNIX/Linux shell scripts, Windows scripts.
• Performed Data Migration from IBM Cúram 5.2 system to IBM Cúram 7.02 system for Oracle 12cR1 database.
• Performed Data Migration from IBM Cúram 6.1 system to IBM Cúram 7.0 system for DB2 10.5.6 database.
• Built data processing platforms utilizing Amazon Web Services Redshift, RDS, PostgreSQL, MySQL and MongoDB.
• Designed conceptual, logical, physical, multidimensional data model utilizing Erwin, Sybase Power Designer case tool.
• Developed and implemented Physical Data Models for Oracle, SQL Server, Teradata and DB2 databases.
• Interfaced with business analyst, subject matter expert, end user and developer. Gathered and Analyzed Business data requirements.
• Analyzed various data sources, and designed source to target field level mapping document.
• Managed, designed and implemented Microsoft SQL Server Integration Services (SSIS) Automated Jobs utilizing Extract Transform Load (ETL) packages and stored procedure scripts for moving data from data sources to Data Warehouse.
• Performed Data Analysis, resolved data quality issues and developed cleansing strategies in the source systems.
• Developed SQL Queries, Stored Procedures, Functions, Views, Triggers, DTS Packages & Automated Jobs.
• Completed Big Data & Hadoop and Data Science in Programming R instructor led live online interactive training courses.

TECHNICAL SKILLS:

Operating Systems: UNIX, Linux, Windows, AIX, HP-UX 11.x, SUN SOLARIS 5.x, VAX/VMS 6.x, AS400.

Data Bases: Microsoft SQL Server 2012/2008/2005/2000/7 , Oracle Database Server 12c/11g/10g/9i/8i/7, DB2 Database Server 10.5.6/9/8, Teradata 12, Sybase 11/10, AWS-Redshift, AWS-RDS, PostgreSQL 9.6, MySQL 5.6, MongoDB 3.6.

Case Tools: Erwin 9.x/7.x/4.x Data Modeler, Oracle Data Modeler 18.1, Sybase Power Designer 16.5 E/R Studio.

Admin/Developer Tools: IBM Data Studio 4.1, Oracle SQL Developer 17.4.0, Jenkins AIX 7.1, WinSCP 5.2.1, Erwin Web Portal Metadata Manager, Toad for Data Analysts / Oracle / DB2 / SQL Server, Teradata Administrator, Teradata SQL Assistant, DB2 Client, Eclipse for Java, SQL Server Integration Services, Informatica Data Explorer 8.6.2, SQL Server Enterprise Manager, Oracle Enterprise Manager, Crystal Reports XI, DBeaver Community Ed 5.3.1

Software: UNIX/Linux Shell Scripting, SQL, PL/SQL, Java, Visual Basic, C, Pro*C, Power Builder.

PROFESSIONAL EXPERIENCE:

Sr. Oracle Database Developer

Confidential, Princeton, NJ

• Managed and implemented Electronic Adjudication Management System (EAMS) Project utilizing Oracle databases and PostgreSQL databases.
• Performed Data Analysis and Data Migration from IBM Cúram 5.2 system having Oracle database 11gR2 to IBM Cúram 7.02 system having Oracle database 12cR1.
• Performed schema comparison of source and target databases.
• Managed and Implemented Oracle Database Backups, Restores, Data Pump Exports, Data Pump Imports.
• Interfaced with business analyst, subject matter expert, end user and developer. Gathered Business data requirements. Analyzed the business requirements and designed conceptual, logical, physical, multidimensional data models.
• Extensively utilized Erwin tool features of Reverse Engineering, Complete Compare, Bulk Editing, Naming Standard Template using Standard Abbreviation file, DDL script Generation, Resolving Many-to-Many, Supertype-Subtype Identity, Roll-Down & Roll-Up Denormalization Transforms.
• Built data processing platforms utilizing Amazon Web Services Redshift, RDS, PostgreSQL, MySQL and MongoDB.
• Developed and implemented PL/SQL programs, SQL, UNIX/Linux shell scripts, Windows scripts.
• Performed data correction updates on large tables.

Environment: Erwin 9.7 with Model Mart, Database Server Oracle 11g/12c for Linux x86 64, SunOS 5.10, AWS-Redshift, AWS-RDS, PostgreSQL 9.6, MySQL 5.6, MongoDB 3.6, Windows Operating Systems, Oracle Enterprise Manager, Oracle SQL Developer 17.4.0, Oracle Data Modeler 18.1.0, Redgate Schema Compare for Oracle 4.0.8, DBeaver 5.3.1, Jenkins AIX 7.1, WinSCP 5.2.1, TortoiseSVN 1.9.2, FileZilla 3.31.0, Agent Ransack 2016.

Confidential, Little Rock, AR

Sr. DB2 Database Developer

• Managed and implemented Eligibility & Enrollment Framework (EEF) Project utilizing DB2 databases.
• Performed Data Migration from IBM Cúram 6.1 system to Cúram 7.0 system for DB2 10.5.6 database.
• Performed schema comparison of source and target databases.
• Interfaced with business analyst, subject matter expert, end user and developer. Gathered Business data requirements. Analyzed the business requirements and designed conceptual, logical, physical, multidimensional data models.
• Extensively utilized Erwin tool features of Reverse Engineering, Complete Compare, Bulk Editing, Naming Standard Template using Standard Abbreviation file, DDL script Generation, Resolving Many-to-Many, Supertype-Subtype Identity, Roll-Down & Roll-Up Denormalization Transforms.
• Designed/Recommended Database Security Policy.
• Managed and implemented database schema data validation script.
• Developed and implemented UNIX/Linux shell scripts, Windows scripts.

Environment: Erwin 9.7 with Model Mart, Database Server DB2 10.5.6 for AIX 7.1, Windows Operating Systems, IBM Data Studio 4.1, Toad for IBM DB2 6.3, DBeaver 5.3.1, Jenkins AIX 7.1, WinSCP 5.2.1, TortoiseSVN 1.9.2, FileZilla 3.31.0, Agent Ransack 2016.

Sr. SQL Server Database Developer

Confidential, San Francisco, CA

• Managed, designed and implemented Employee and Financial Data Warehouse utilizing SQL Server databases.
• Interfaced with business analyst, subject matter expert, end user and developer. Gathered Business data requirements. Analyzed the business requirements and designed conceptual, logical, physical, multidimensional data models.
• Analyzed various data sources, and designed source to target field level mapping document.
• Performed database Administration of SQL Server Databases on Windows platform.
• Managed, designed and implemented Microsoft SQL Server Integration Services (SSIS) Automated Jobs utilizing Extract Transform Load (ETL) packages and stored procedure scripts for moving data from data sources to Data Warehouse.
• Managed Data Governance, Metadata Integration, Mapping, Data Lineage and Impact Analysis utilizing Erwin Web Portal Metadata Manager.
• Extensively utilized Erwin tool features of Reverse Engineering, Complete Compare, Bulk Editing, Naming Standard Template using Standard Abbreviation file, DDL script Generation, Resolving Many-to-Many, Supertype-Subtype Identity, Roll-Down & Roll-Up Denormalization Transforms.

Environment: Erwin 9.64 with Model Mart, Erwin Web Portal Metadata Manager, SQL Server 2012/2008 R2, Microsoft SQL Server Integration Services, SQL Server Management Studio, Visual Studio.

Data Architect

Confidential, New York, NY

• Managed, designed and implemented various global wealth management application projects utilizing Teradata Data Warehouse and DB2/SQL Server relational databases.
• Gathered business requirements, working closely with business users, business analysts, project leaders and developers. Analyzed the business requirements and designed conceptual, logical, physical, multidimensional data models.
• Extensively utilized Erwin tool features of Reverse Engineering, Complete Compare, DDL script Generation, Resolving Many-to-Many, Supertype-Subtype Identity, Roll-Down & Roll-Up Denormalization Transforms.
• Designed physical data model specific to DB2, Teradata, SQL Server databases for optimum performance. Performed Volumetric analysis and designed storage parameters for tables, tablespaces, indexes. Coordinated with Database Administrator to implement physical database DDL script in development environment.
• Enforced naming standards and data dictionary for logical and physical data models.
• Performed extensive work with moving-mapping data from DB2 to Teradata data warehouse, partitioning, compression.
• Performed SQL Query performance analysis using Client software for DB2, Teradata and SQL Server.

Environment: Erwin 7.3.9 with Model Mart, Sybase Power Designer 16.5, SQL Server, Teradata 12.0, Mainframe DB2-9.1.

Sr. Database Developer

Confidential, Pennington, NJ

• Managed, designed and implemented managed assets application projects utilizing Erwin and IBM Data Architect.
• Gathered business requirements, working closely with business users, project leaders and developers. Analyzed the business requirements and designed conceptual and logical data models.
• Developed data migration and data validation PL/SQL scripts from old system to new system.
• Performed SQL Query performance analysis using Toad Client software for Oracle / DB2 / SQL Server.
• Enforced naming standards and data dictionary for data models.

Environment: Microsoft SQL Server 2008, Oracle Database Server 10g, Erwin 7.3.10, IBM Data Architect 7.5.3, Microsoft Visio 2007, Toad for Data Analysts 2.7, Toad for Oracle 10.6, Toad for DB2 4.7, Toad for SQL Server 5.0.

Data Architect

Confidential, New York, NY

• Managed, designed and implemented various global wealth management application projects utilizing Teradata Data Warehouse and DB2/SQL Server relational databases.
• Gathered business requirements, working closely with business users, business analysts, project leaders and developers. Analyzed the business requirements and designed conceptual, logical, physical, multidimensional data models.
• Extensively utilized Erwin tool features of Reverse Engineering, Complete Compare, DDL script Generation, Resolving Many-to-Many, Supertype-Subtype Identity, Roll-Down & Roll-Up Denormalization Transforms.
• Designed physical data model specific to DB2, Teradata, SQL Server databases for optimum performance. Performed Volumetric analysis and designed storage parameters for tablespaces, filegroups, indexes. Coordinated with Database Administrator to implement physical database DDL script in development environment.
• Enforced naming standards and data dictionary for logical and physical data models.
• Performed SQL Query performance analysis using Client software for DB2, Teradata and SQL Server.
• Utilized Informatica Data Explorer to analyze corporate data to discover relational model and redesign existing system AIS Migration project.
• Implemented data model migration of Model Mart 4.1 to Model Mart 7.3. Verified the accuracy of converted models by comparing Reports of original and converted models.

Environment: ERwin 4.1.4 / 7.3.6 with Model Mart, Teradata 12.0, Mainframe DB2-9.1, SQL Server, Informatica Data Explorer 8.6.2.

Sr. Database Developer

Confidential, Bronx, NY

• Managed, Designed & Implemented Learner-Educator-Administrator-Portal (LEAP) web System; a campus-wide information management system providing information regarding curriculum, courses, grades, skill tests, referrals, student intervention programs, early warning system. The system permits interaction among students, faculty and administrators to analyze, identify solutions. The system reports facilitate administrators conduct department and division-wide analysis for resource allocation.
• Managed, Designed & Implemented Budget online data entry and Reports generation system for Budget Department. Administrator can enter employee profile, part-time, OTPS, budget allocation, and encumbrance data for all the departments. Administrator can view Budget, Encumbrance reports for all departments, Division Summary report. Department Directors can view Budget and Encumbrance reports for their own department.
• Developed Logical and Physical complex data models using Erwin 4.1.
• Designed databases, tables, indexes, views, stored procedures, functions and triggers for data integrity constraints.
• Managed, Migrated College’s mainframe SIMS data to SQL Server database using ETL, DTS packages and Jobs.
• Analyzed, Developed various summary and detailed reports using Crystal Report XI.

Environment: SQL Server / 7, Oracle 10g / 9i, Erwin 4.1, Windows-2003, Crystal Report XI.