SUMMARY:

• Around 25 years of experience in design, development and implementation of variety of application software such as Financial Systems, Health Care Systems, Telecommunications Ordering Systems, Customer Information Systems, Sales Monitoring Systems, Banking Systems, Transaction Information Systems, Shipping Systems and Payroll Systems as a Tech Lead/Senior Data Architect/ Data Analyst / Business Analyst and Oracle Developer.
• Experienced in data analysis, developing process flows, data flows and creating Conceptual, Logical and Database Physical Data Models (Relational and Dimensional) using ER Studio, Erwin and Visio. Created objects using forward and reverse Engineering techniques with Erwin and ER Studio. Experienced in gathering Business requirements and defining Functional and System requirements and System Interface Documents.
• Experienced working in all phases of the SDLC of the projects with different software methodologies like Waterfall, Agile, Rapid Application Development (RAD) and Prototyping.
• Experienced in Administration and development of Data Virtualization Tool (Denodo)
• Working knowledge of Big Data (MongoDB, ParAccel/Matrix).
• Experienced in developing packages, procedures, functions and triggers in Oracle database.
• Worked on SOX Sec1 implementation.
• Experienced in performance tuning in Oracle, UDB/DB2, SQL Server and Sybase.
• Experienced with CMM standards.
• Experienced in using RUP tools.
• Experienced in defining USE Cases.
• Experienced in Defining Service Level Agreements (SLA) and Data Profile Questionnaires (DPQ).
• Provided production support to the customers for the applications in - person and remotely.
• Efficient in Project Management. Liaison with management, end users, analysts and testing teams and arranging the meetings for reviews and schedules and following up with all the teams to deliver the applications within the scheduled dates.
• Worked with the testing team performing integration and system testing applications by using automation tools like SQA Team Test (SQA Robot, SQA Manager) and WinRunner.
• Excellent knowledge in using Data Warehouse tools i.e. Informatica, Tableau and Business Objects and EDI tools i.e. Mercator.
• Experienced in using change managements tools i.e. GIT/Teamforge,Clear Case, Clear Quest,ServiceNow and Remedy.
• Was ed the “ of Excellence” by Confidential & Confidential systems Confidential & Confidential Middle Town, NJ

TECHNICAL SKILLS:

RDBMS: ORACLE 12C/11G/10g/9.x/8.x/7.x6.x, MS-ACCESS 2.0/7.0, Postgres, Teradata, Sybase15,12.5, 12.0,11.5, DB2/UDB7.x,8.x,9.x, SQL Server, ParAccel.

SOFTWARE: ER Studio17.x/16.x/6.x,7.x,8.x,9.x, Data Virtualization(Denodo 7.x/6.x),ERWIN 9.x/7.X/4.x/3.x, Sparx Enterprise Archtiect 14.x, Data Vault, Power Designer, DESIGNER 2000 and VISIO, SQL, PL/SQL, XML, VISUAL BASIC, ASP, C, C++, Java and JSP, INFORMATICA9.x/6.x/5.x (PowerMart/PowerCenter) WAREHOUSE BUILDER, DBArtisan, Rapid SQL, Change Manager, TOAD, ORACLE APPLICATIONS 11i FINANCIALS (GENERAL LEDGER, ACCOUNT PAYABLES, ACCOUNT RECEIVABLES, FIXED ASSETS), Tableau 2018, BUSINESS OBJECTS 5.x, COGNOS 7.x/6.x/5.x, SQA, WinRunner, LoadRunner, Silk, and Silk Performer, Mercator 6/x/5.x, SAP/SAP BW R3, ALE, IDocs

OPERATING SYSTEMS: SOLARIS,HP, AIX, MS-WINDOWS, Mainframes and NT

EXPERIENCE:

Sr Data Architect/Data Modeler/Systems Analyst/Consultant

Confidential, Mclean, VA

Responsibilities:

• Worked on CDW ( Corporate Data warehouse), Investment and Capital Markets, Single Family, Multifamily, Financial and Accounting (FAS140 FIN46) Applications.
• Working with Business Teams and Application Architects for gathering data requirements for adding new entities and attributes and modifying the BIM/CDM (Business Information Model/Canonical Data Model).
• Developing the Conceptual, Logical and Physical models based on the requirements and data analysis using appropriate data modeling methodologies and data design tools using MISMO standards. Coordinating and integrating corporate level data definitions and designs. Synch up the project level models with CDM for SOA implementation. Coordinating promotion of data reusability across application development teams.
• Integrated Taxonomy with Business Information Model (BIM)
• Defining Star and Snowflake schemas models as per the requirements. Reviewing the data models with DRB, business, development and testing teams. Used Forward and Reverse Engineering techniques to generate schema objects with Erwin and ER Studio. Create and executing the DDLs in the development database for creating database objects. Converted data models from Erwin to ER Studio. Generating XML schema for DSI projects.
• Worked on the requirements of SOX Sec1 compliance implementation.
• Coordinating the UAT and Production releases of the applications working with DBAs and Application teams responsible for migrating data structures from Development databases to Testing databases and from Testing to Production databases. Worked with development team and DBAs for tuning the database performance.
• Mentoring new hires and peers.
• Capturing business and technical Metadata in the models and loading Metadata to Meta Data Repository (MDR).
• Worked as Baseline Integrator for promoting baselines to integration stream for the files version control. Used GIT, Rational Clear Case and Clear Quest for the source control maintenance.
• Working in-group to design and develop the system. Analyzed the module requirements based on the standards of the company.

ENVIRONMENT: Erwin, ER Studio, Oracle, Sybase, SQL Server, DB2/UDB, MongoDB, ParAccel, Rapid SQL, DBArtisan, Change Manager, Teamforge/GIT,Clear Case, Clear Quest, Remedy, ServiceNow, DOORS, UNIX, Mainframes and Windows

Data Architect/Data Modeler/Denodo Architect/Tech Lead

Confidential, Tysons Corner, VA

Responsibilities:

• Mentoring and supporting the team members for developing the views in Denodo.
• Gathering Business/Data requirements from the Business/Development Team. Develop and modify the Conceptual, Logical and Physical models based on the requirements and data analysis.
• Coordinating and integrating corporate level data definitions.
• Modify the Enterprise Data model for the changes.
• Create and modify the Business Data Model for supporting the Data Virtualization (Denodo) views development
• Create and modify Denodo Architectural artifacts.
• Administration of Repository and ER Studio Server.
• Promoting the ER Studio model to Enterprise Metadata Repository.
• Installed of Denodo Platform Servers on Linux Machines for DEV, QA, PROD and DR environments.
• Install the updates with new patches.
• Creating Roles and Users in Denodo VDP and assigning appropriate privileges to Roles to be granted to users
• Developed views by connecting to different data sources.
• Import the Data Model into Denodo tool for creating the interface views.
• Promoting the Denodo development changes to QA, PROD and DR environments.
• Presented Denodo tool before the management and the user community.
• Configuration of Denodo parameters like port connectivity, JVM options. Memory
• Create use case solution documentation for Denodo development.
• Work with Denodo Support for fixing the issues.

ENVIRONMENT: ER Studio, Tableau, Talend, SQL Server, DB2/UDB, Progress, Postgres, MySQL, Teamforge/GIT, ServiceNow, LINUX, Mainframes and Windows

Data Architect/Systems Analyst

Confidential, Baltimore, MD

Responsibilities:

• Gathering Business/Data requirements from the Business/Development Team.
• Developing the Logical and Physical models based on the requirements and data analysis using appropriate data modeling methodologies and data design tools. Defining Star, Snowflake and Hybrid schemas models as per the requirements.
• Reviewing the data models
• Coordinating and integrating corporate level data definitions and designs.
• Used Forward and Reverse Engineering techniques to generate schema objects with Erwin.
• Coordinating the UAT and Production releases of the applications working with DBAs and Application teams responsible for migrating data structures from Development databases to Testing databases and from Testing to Production databases.
• Working in-group to design and develop the system.
• Analyzed the module requirements based on the standards of the company.

ENVIRONMENT: Erwin 4.x, Oracle, Teradata, DB2/UDB, DOORS, UNIX, Mainframes and Windows

Data Analyst/Technical Analyst

Confidential

Responsibilities:

• Defining and reviewing the Business requirements for getting the right data from the source systems.
• Defining the Technical requirements.
• Working with ETL team for implementation of data transformation rules meeting the requirements.
• Mapping the Meta Data with the source systems.
• Working with interfacing system groups to map the data.
• Working with development and testing team to see the requirements are accurately captured.
• Developing the user input documents for loans and properties.
• Worked on data quality improvement and reconciliation.
• Worked on data integrity and ongoing quality control of delivered reports.

ENVIRONMENT: ER Studio 6.x, Oracle, Sybase, Visio, Rapid SQL, Clear Case, Clear Quest, UNIX, Mainframes and Windows

Confidential, Tampa, Florida

Responsibilities:

• Gathering Business Requirements from the Business team.
• Defining Functional and System Requirements for the application.
• Defined System Interface requirements.
• Creating Conceptual, Logical and Physical Models using Erwin and Visio case tools.
• Writing packages, procedures functions and triggers.
• Used Forward and Reverse Engineering techniques to generate schema objects with Erwin.
• Involved in performance tuning for faster data access.
• Define volume requirements.
• Involved in capacity planning of the database.
• Defining Process and Data flows using Visio case tools.
• Used Rational Clear Case and Clear Quest for the source control maintenance. Working in-group to design and develop the system.
• Analyzed the module requirements based on the standards of the company. Integration and system testing the application.

ENVIRONMENT: Erwin 4.x, ORACLE 9.x, WINDOWS NT, TOAD, MERCATOR, SAP R/ 3 4.6c and UNIX

Confidential, Morristown, NJ

Responsibilities:

• Gathering Business Requirements from the Business team.
• Defining Functional and System Requirements for the application.
• Creating Logical and Physical Data Models using Erwin and Visio case tools.
• Defining Capacity Planning for the databases.
• Used Forward and Reverse Engineering techniques to generate schema objects with Erwin. Involved in performance tuning for faster data access.
• Monitoring the batch jobs and rescheduling for the failed jobs.
• Defining Process and Data flow using Visio case tools.
• Used Rational Clear Case and Clear Quest for the source control maintenance.
• Working in-group to design and develop the system.
• Analyzed the module requirements based on the standards of the company.
• Integration and system testing the application.

ENVIRONMENT: Erwin 3.x/4.x ORACLE 8.0, Sybase, WINDOWS NT, and UNIX

Confidential, Middletown, NJ

Responsibilities:

• Gathering Business Requirements from the Business team.
• Defining Functional and System Requirements for the application.
• Creating Logical and Physical Data Models using Erwin and Visio case tools.
• Defining Capacity Planning for the databases.
• Writing stored procedures (packages, procedures functions and triggers).
• Used Forward and Reverse Engineering techniques to generate schema objects with Erwin.
• Involved in performance tuning for faster data access.
• Monitoring the batch jobs and rescheduling for the failed jobs.
• Defining Process and Data flows using Visio case tools.
• Used Rational Clear Case and Clear Quest for the source control maintenance.
• Working in-group to design and develop the system.
• Analyzed the module requirements based on the standards of the company.
• Integration and system testing the application.

ENVIRONMENT: Erwin 3.x, ORACLE 8.0, Sybase, WINDOWS NT, and UNIX