SUMMARY:

• Around Sixteen years of software development experience in a wide range of skill set, roles and industry verticals.
• Extensive experience in Enterprise Data architecture, Data modeling (Conceptual, Logical, Physical) in OLTP and OLAP environments, database design, database development, Object Modeling and Abstraction modeling SOA, Batch/Bulk data, Service Bus and Integration Bus.
• Extensive involved in creating Proof of concepts in various data related areas.
• Define and implement Frameworks for data throughout the enterprise
• Proficient in analyzing and translating business requirements to technical requirements using various tools like Visio, Rational Rose and Other Case tools.
• Good Database administration and Performance tuning skills.
• Extensive experience in Database Programming (Oracle PL/SQL).
• Batch/Bulk data processing working experience.
• Data Analyst, Data profiler for legacy systems (Mainframe and other Legacy systems).
• Good database development knowledge and experiences in very large Transactional Date warehousing databases.
• Experience in disparate Industry domains starting from Financial Services (Insurance, Investment and Retirement Products), Health Care, Billing, Banking, Hospitality, Order and Inventory Management (SCM).
• Good front end development experience like Oracle forms, Reports, VB, ASP, Power builder and many reporting tools like Oracle Reports and Actuate.
• Good team player, team leader, motivated, Client friendly, management skills.
• Good communication skills, interpersonal skills, self - motivated, quick learner, team player.
• Hard working and flair to succeed.
• Pursuing s in various areas like, Hadoop, Java and SOA.

TECHNICAL SKILLS:

FRAMEWORK: Data Governance, Bulk Data, SOA - Service Integration, Integration Bus, Hadoop.

RDBMS: ORACLE 12c, 11g, 10g, 9i, 8i, 8.0/7.X, PROGRESS 2.5, MS SQL Server6, MS Access and Teradata, HBase, HDFS

Front End Tools: FORMS 5.0,4.5/4.0/, POWER BUILDER 6.5 w/ PFC, VB6.0, ASP and Remedy AR.

CASE /UML Tools: SQL Data Modeler, Erwin, Oracle Designer, Power Designer, Rational.

Applications: Oracle 10SC, Siebel CRM and Remedy AR.

DBMS: FoxPro 2.5

O/S: WINDOWS NT3, 4.0, 2000, 98/95, WINDOWS 3.11 FOR WORKGROUPS, UNIX.

Languages: C, C++, PL/SQL, SQL, XML, Java

Domain Expertise: Retail, Health Care, Billing, Banking, Financial, Hospitality, Stock Market, Logistics, Order and Inventory Management (SCM), financial services and Investments.:

PROFESSIONAL EXPERIENCE:

Enterprise Data Architect

Confidential

Responsibilities:

• Define Data Architecture Framework for various Oracle Retail product areas.
• Creation of POC based on Cloud, Big data and Batch framework.
• Created ground work for Enterprise Data Model and Enterprise Data Warehouse.
• Data Analysis, Data Quality, Data Integration, Data Sourcing and Data Mapping.
• Meta and Master Data Management.
• Data Modeling - Conceptual, Logical, Abstraction both OLTP and OLAP environments.
• Source to target mapping i.e., Data Mapping.
• Abstraction modeling for SOA in service layer.
• Business Requirements discussions/ Client interviews.
• Create Object Models using Rational tool RSM.
• Process flow diagrams.
• Multiple Recommendations and Solutions based on the budget.
• Performance Analysis and recommendations from Data Architecture perspective.
• Best practices recommendations from Data Architecture perspective.
• Data Governance, Metadata management.
• Big Data Proof of concepts, Hadoop (Hbase, HDFS, Hive, MapReduce using Java), Workflow using Apache Oozie.
• Data Architecture Road shows.
• Integration Architecture and Development (Retail Integration Bus, Retail Service Bus, Bulk Data).
• Supporting Project related build process using Gradle.
• Bulk Data Integration using Oracle Data Integrator and Hadoop connectors.
• Bulk/Batch processing, catalog creation.

Skill/Tool: SQL Data modeler, MS Office, Visio, Rational Rose RSM 7.1, Power Point/, Oracle data integrator, Oracle Enterprise Repository, ODI 11,12c, Oracle 12c, 11gr2 DB, WLS 12.1.0, Java SE 1.7, 1.8.

Enterprise Data Architect, Data Analyst, Data modeler

Confidential, Minneapolis, MN

Responsibilities:

• Data Analysis, Data Quality, Data Integration, Data Sourcing and Data Mapping.
• Meta and Master Data Management.
• Data Modeling - Conceptual, Logical, Abstraction both OLTP and OLAP environments.
• Source to target mapping i.e., Data Mapping.
• Abstraction modeling for SOA in service layer.
• Business Requirements discussions/ Client interviews.
• Create Object Models using Rational tool RSM.
• Process flow diagrams.
• Multiple Recommendations and Solutions based on the budget.
• Performance Analysis and recommendations from Data Architecture perspective.
• Best practices recommendations from Data Architecture perspective.
• Interaction with DBA and Data Integration team and support hand over tasks.

Skill/Tool: Erwin 7.2, Power Designer, MS Office, Visio, Rational Rose RSM 7.1, Power Point/

Data Architect, Database Analyst, Consultant, DB Programmer

Confidential, Charlotte, NC

Responsibilities:

• Understand the Client Requirements, client interviews.
• Prepare technical design documents
• Analysis of the existing functionality.
• Efficient data solution and suggestion to existing problems and recommendation.
• Data modeling using Erwin, Architecting, Data Analysis, Gap Analysis of existing systems and legacy apps.
• Creation of Conceptual, Logical data models for various enterprises wide apps.
• Involved in non functional design and SOA designs.
• Leading a team of five for eB1 and CDI.
• Database Programmer.
• Generation of DB objects
• Back End Stored Procedures Functions, DB Triggers, EOD Jobs
• Performance/Query tuning
• Supporting testing activities both functional and database.
• Database Recommendations for StateDaemon.
• Pre and Post go live production support.
• Create Informatica workflow, Mappings. Create ETL Process and Mappings using SQL Loader and PL/SQL Packages.
• SQL Loader process to load the data from flat files.

Data Architect, Data modeler, Database Analyst

Confidential, New York

Responsibilities:

• Understand the Client Requirements./Interact with the client
• Data modeling, Architecting, Data Analysis.
• Creation of Logical and physical data models for ASO app.
• Sizing estimation and Data profiling.
• Generation of DB objects
• Back End Stored Procedures Functions, DB Triggers, EOD Jobs
• Performance/Query tuning on Database and SQL queries
• Testing -Functionality.
• Supporting testing activities.
• Critical role in Disaster recovery exercise from application perspective.
• Developing reports using Crystal reports.

Skill/Tool: Oracle 8i R2, SQL PLUS 8.1.6, PL/SQL 91, StatsPack, TKPROF, Oracle Expert, PL/SQL Developer, Developer 2000, Shell scripts, Crystal Reports, SQL Loader.

Data modeler, Data Architect, PL/SQL developer, Database Analyst, Consultant

Confidential, Findlay, Ohio

Responsibilities:

• Understand the Client Requirements./Interact with the client
• Data modeling, Architecting, Data Analysis, Gap Analysis of existing systems and legacy apps (mainframe, Adabas).
• Creation of Conceptual, Logical data models for various Order and Inventory apps.
• Involved in non functional design and SOA designs (sizing estimates, backup recovery, DR).
• Generation of DB objects.
• Back End Stored Procedures using PL/SQL Functions, DB Triggers, EOD Jobs
• Performance/Query tuning
• Testing -Functionality.
• Supporting testing activities.
• Production support.
• Oracle Forms and Reports.
• Shell Scripts.
• Recommendation for future enhancements from application and database perspective.

Skill/Tool: Oracle 8i R2, SQL PLUS 8.1.6, PL/SQL 91, StatsPack, TKPROF, Oracle Expert, PL/SQL Developer, Developer 2000, Shell scripts

Data modeler, PL/SQL developer, Database Analyst, Consultant

Confidential, Memphis, TN

Responsibilities:

• Understand the Client Requirements./Interact with the client
• Creation of Process Models, Logical data model for pricing.
• Generation of DB objects
• Back End Stored Procedures Functions using PL/SQL, DB Triggers, EOD Jobs
• Performance/Query tuning using Stats pack Instance tuning and SQL script tuning.
• Database Testing - Functionality and performance.

Skill/Tool: Power Designer, Oracle 9i R2, SQL PLUS 8.1.6, PL/SQL 91, Stats Pack, TKPROF, Oracle Expert, PL/SQL Developer

Data modeler, PL/SQL developer, Database Analyst, Consultant

Confidential, Boston, MA

Responsibilities:

• Understand the Client Requirements./Interact with the client
• Created Logical and Physical ER Diagram on as per Fidelity DB standards using Designer 2000.
• Comprehensive Volumetric Analysis for Table space calculation/Partition.
• Generation of DB objects tables
• Data Migration from Legacy system Data Maintenance.
• Managing Change request.
• Back End Stored Procedures Functions, DB Triggers, EOD Jobs
• Support Activity (User Creation and Database Dumps Data migration).
• Performance/Query tuning, using Stats Pack, Oracle Expert and TKPROF
• Import & Export Activity.
• ETL Process using SQL Loader and PL/SQL Packages.
• Testing -Functionality.
• Day to Day DBA check list activities.
• Key role for Onsite Support .

Skill/Tool: Designer 2000 9i, Oracle 9i R2, SQL PLUS 8.1.6, PL/SQL 91.,SQL Loader, Stats Pack, TKPROF, Oracle Expert, TOAD

Data modeler, PL/SQL developer, Database Analyst, Consultant

Confidential

Responsibilities:

• Understand the Client Requirements.
• Created Logical and Physical ER Diagram.
• Generation of DB Reports using ER Win.
• Meta Data Creation Data Maintenance.
• Managing Change request.
• Comprehensive Volumetric Analysis.
• Performance Tuning (Query tuning and Optimization).
• Back End Stored Procedures Functions, DB Triggers, EOD Jobs.
• Support Activity (User Creation and Database Dumps Data migration).
• Import & Export Activity.
• Data Porting and migration loading using SQL Loader.
• Testing -Functionality.

Skill/Tool: Erwin 3.5.2, Oracle 9.0.1.1.1, SQL PLUS 8.1.6, PL/SQL 8.1.6,SQL Loader 8.1.6,TOAD

Project Leader, Project Management

Confidential, ca

Responsibilities:

• Understand the Client Requirements Information gathering.
• Preparing Project Management Plan, SRS, SDD, SCR, Project Tracking
• Designing the Project, Interact with Client for Clarifications and other necessary Inputs needed for the Project.
• Guide the Team in all areas from GUI to the Functionality in accordance with ISO standards. *Testing -Functionality and UI.
• Managing Change request.
• CFOAnalytics Package Conversion using Install shield.

Skill/Tool: MS VisualStudio,VB6,VB Script, SP, COM, Java script, Business Objects, SQL Server, MS Access 2000,InstallShield,ERWin,Oracle8i,Visual Source Safe.

DB Programmer, Remedy Developer

Confidential

Responsibilities:

• System study and identify the main modules of the system and know the level of security needed.
• Working with Action Request system - using Remedy escalation will talk to the Oracle DB
• Writing procedures and functions for the Backend requirements using Oracle PL/SQL
• End user and Documentation

Skill/Tool: Environment: H/W Pentium pro, 64 MB RAM; O/S -MS WINDOWS 95;Case

Oracle Webserver Developer, PL/SQL Programmer.

Confidential, Maynard, MA

Responsibilities:

• System study and Identify main modules of the system and know the level of security needed.
• Develop the on line system using Oracle web server V2.0
• Field Validation using Java scripts and HTML
• Writing procedures and functions for the Backend requirements using Oracle PL/SQL
• End user and Documentation.
• Integrated Remedy AR for customer tickets that has been raised.
• Writing Java Scripts for validation purpose.

Skill/Tool -Designer 2000 RDBMS- Oracle 7.1;Internet: Oracle Webserver 2.0;PL/SQL, SQLPLUS, Remedy AR

Powerbuilder Developer, PL/SQL Programmer

Confidential, Denver COLORADO

Responsibilities:

• Interact with end user identifies the key requirements, identify the real problems and explain the benefits of the application.
• Develop the front end application using Power builder 6.5 w/ PFC Design the Tables and Menus with Designer 2000
• Writing stored procedures and functions for the Backend requirements using Oracle PL/SQL.
• End user and Documentation.

Skill/Tool -Designer 2000 RDBMS- Oracle 7.1; Front End GUI -Power Builder 6.5; PL/SQL, SQLPLUS

Powerbuilder Developer, PL/SQL Programmer

Confidential

Responsibilities:

• Interact with end user identify the key requirements, identify the real problems and explain the benefits of the application
• Design the system Using Designer 2000 Writing Process Flow, Logical data model. diagrams, Data flow Diagrams Entity Relation diagrams,
• Physical model, Design the database objects as tables, views and stored procedures.
• Develop user friendly Data entry screens, menus using Developer2000
• End user and Documentation

Skill/Tool: Designer 2000 RDBMS- Oracle 7.1;Front End GUI -FORMS 4.5;PL/SQL, SQLPLUS

PL/SQL Programmer

Confidential

Responsibilities:

• Interact with end user identify the problems in the current system check the efficiency of the current system
• Write Data flow diagrams, Entity Relation Diagram, Process flow Diagram and registration after the system study using Designer 2000;
• Developing user-friendly screens using Developer 2000.
• For online registration and Statement of accounts Oracle Webserver2.1 was used to register customer any where in Singapore and reduced bill statement time by displaying on line bill details on the customer's system itself .
• End user, Documentation Worked in a team of five members.
• Implement Oracle 10SC AR, GL modules.

Skill/Tool: Designer 2000; RDBMS - ORACLE 7.3; Front End GUI - FORMS 4.5,ORACLE WEBSERVER, Oracle 10SC.

Programmer

Confidential

Responsibilities:

• Involved in writing Data Flow Diagram(DFD), Entity Relation(ER) diagrams;
• Developing User friendly data entry, query screens building menus using Forms 4.5 and Report using Report s 2.5.
• End User Worked in a team of three members.

Skill/Tool: WINDOWS 3.11; RDBMS - ORACLE 7.1; Front End GUI: ORACLE FORMS 4.5, REPORTS 2.5, SQL PLUS 3.1

Programmer

Confidential

Responsibilities:

• study the Market system and identify the basic problems and needs,
• Involved in designing the system
• Developing front-end screens using Forms 4.5, build menus .
• End User and Documentation Worked in a team of three members.

Skill/Tool: WINDOWS 3.11; RDBMS - ORACLE 7.1; Front End GUI: ORACLE FORMS 4.5, REPORTS 2.5, SQL PLUS 3.1

Trainee Programmer

Confidential

Responsibilities:

• Involved in writing Data flow Diagrams (DFD), Entity Relation(ER).
• Documentation and writing test cases.
• Developing User Friendly data entry, query, building menus using Forms 4.5.
• End user . Worked in a team of two members.

Skill/Tool: WINDOWS 3.11; RDBMS - ORACLE 7.1; Front End GUI: ORACLE FORMS 4.5, REPORTS 2.5, SQL PLUS 3.1