EXPERIENCE SUMMARY:

• 15 years of experience in the field of data modelling, database design, data migration and programming in Oracle and SQL Server.
• 5 years as Technical Leader and Database Architect
• 2 years as System Analyst
• 12 years as Database Programmer
• Expertise in analysis, design, development, implementation, support and maintenance of full life cycle of different OLTP and OLAP database projects and applications.
• Strong knowledge on database design related activities starting from scratch such as designing logical & physical data model; develop programming specs, designing ER diagrams, written technical design documents, pl - sql coding, query optimization and data migration etc.
• Experienced in working on both Kimball and Inmon data warehouse designing approach.
• Deeply Worked in development of application projects using Oracle 10g, 11g & 12c (SQL,PL-SQL), Developer 2000 (Forms & Reports) and MS SQL Server 2018.
• Worked extensively on Erwin, MS Visio, TOAD, SQL Loader, Oracle SQL Developer, Alteryx, ThoughtSpot, Informatica 10.1, InformEnt 8.0 and Control-M.
• Experienced in working on Scrum, Azure DevOps(formally known VSTS) & Jira tool.
• Actively involved in collaborate all business users to gather requirements and translate into design documents in order to design ETL mappings, defining source and target and creation of jobs in Control-M scheduler.
• Provide support to all ETL schedule and maintain compliance to same and develop and maintain various standards to perform ETL codes and maintain an effective project life cycle on all ETL processes.
• Document all test procedures for systems and processes and coordinate with business analysts and users to resolve all requirement issues and maintain quality for same.
• Providing technical guidance to the team members and help them to maintain of quality standards as per S&G Document
• Actively participated in the evaluation of business requirements and interfaces with other technology team, SMEs to understand data and data definition in order to defines data elements.

MAJOR COMPETENCIES:

• Data Analysis & Modelling
• Data Warehouse & ETL Design
• InformEnt ETL tool
• SQL, PL - SQL Programming
• Database Query Optimization
• Data Migration
• Metadata Management
• Alteryx
• ThoughtSpot
• Informatica

TECHNOLOGY EXPERIENCE:

• Oracle 10g, 11g, 12cMS SQL Server 2018And PostgreSQL
• SQL, PL - SQL and T-SQL
• TOAD 8.0, Microsoft Visual SourceSafe 6.0 & Microsoft Visio 2003. Erwin, JIRA, SVN, Control-M, Alteryx, ThoughtSpot, Informatica 10.1, Azure DevOps, InformEnt 8.0
• Developer 2000 (Forms 4.5,6i & Reports 3, 6i)
• SCO Unix, SCO UnixWare Windows 2003 Server & NT, Linux
• Analysis, SCRUM, ETL Design, DevelopmentTesting & Data Modelling

PROFESSIONAL EXPERIENCE:

Confidential, Tampa, Florida

Data Architect

Responsibilities:

• Having technical discussions with the business on the requirements.
• Based on the discussions, creating the design and architecture approach based on the requirements by generating the mocks and working with the business to create the roadmap.
• Design and build data marts for different line of businesses for facilitating the insight of the data. So that the businesses can take the decision more effective manner by getting 360 view of the data.
• Helping to create independent data analytic platform for the users.
• The objective of this platform is to give a freedom to the users so that they can create own data analysis model according to their requirements.
• In order to adding new feature in the existing data model, the through impact analysis needed at every data point in both upstream and downstream applications.
• Ensuring data standard, quality and defining the roadmap of data governance.
• Collaborating with fellow developers, business analysts, data analysts, QA analysts, project leads and technical operators to solve data issues. (30% of daily work)
• Attending meetings / working sessions with the integrating applications for resolving the issues and finding the root cause.
• Raising the tickets using SharePoint links to engage the teams for technical issues resolution.
• Working with the teams assigned closely for root cause analysis for any database design or configuration issues related to table format or data structure issues etc.
• In a corrective measure, if required, adding new mapping rule between data to avoid any issue further.

Technology Area: Oracle 12c, MS SQL Server 2018, Linux, Informatica 10.1, MS Visio, Alteryx, Azure DevOps(VSTS), TOAD & ThoughtSpot.

Confidential, Green Bay, Wisconsin

Responsibilities:

• Creating LLD docs which are defining new source and destination mappings after getting the HLD from the business on that.
• Designing physical data model
• Details impact analysis before any change applies in the Database.
• Defining mappings and rules in InformEnt Warehouse Architect
• Implement the new mappings and rules in the database
• Preparation of UTC and release documents
• Scheduling report by using InformEnt Knowledge Share
• Performance tuning of database queries which are using in reporting purposes. For that if required then we need to coordinate DBAs.
• Daily operation support on 24x5 basis to Confidential in Production, UA
• Writing stored procedures and scripts by using sql or pl-sql, specially to creating views, data analysis, performance tuning, table partition and data loading.
• Providing technical guidance to the team members
• Team management activities and maintain of quality standards as per company guidelines

Technology Area: Oracle 11g/12c, SQL Developer, Linux, InformEnt 9.0, Erwin, MS Visio, Control-M, ITSM Tool and SVN

Confidential

Responsibilities:

• Designing both logical and physical data model using MS Visio as per requirement specification
• Creation of DDL Script as per S&G
• Preparation of technical design documents
• Providing development guidance to the database team members
• Writing stored procedures and packages by using pl-sql in order to process and retrieve the required data.
• Support to application development team

Technology Area: Oracle 11g, TOAD, UNIX, JIRA, Microsoft Visual SourceSafe 6.0 and Microsoft Visio 2003

Confidential

Responsibilities:

• Data analysis of existing database
• Designing both logical and physical data model using Oracle SQL Developer Data Modelling tool as per requirement specification
• Creation of DDL Script as per S&G
• Preparation of technical design documents
• Providing development guidance to the database team members
• Writing stored procedures and functions in pl-sql in order to facilitate faster data retrieval by front end applications.
• Support to application development team

Technology Area: Oracle 10g, Microsoft Visual SourceSafe 6.0, Oracle SQL Developer Data Modelling, Oracle SQL Developer.

Confidential, Atlanta

Responsibilities:

• Database Design
• Preparation of Design Documents and Unit test Cases
• Writing stored procedures in tsql to staging and processing the data
• Impact analysis and time estimate

Technology Area: Windows 2003 Server, IIS 6.0, .Net Framework 3.0, Microsoft SQL Server 2005 Enterprise Edition, Microsoft SQL Server Reporting Services, Microsoft SQL Server Integration Services, Microsoft Visual SourceSafe 6.0 & Microsoft Visio 2003

Confidential, Florida

Responsibilities:

• Writing software design specification(pseudo code) and unit test plan of existing database objects like packages, procedures, functions & views
• Developing reports using PL-SQL
• Preparation of Unit Test Plan & dummy data script for testing those reports

Technology Area: Oracle 10g, Unix, Toad 7.1, Perforce Release 2006.1 & Microsoft Visio 2003

Confidential

Responsibilities:

• System Study & Analysis
• Preparation of Technical Documents
• Developing user interface and reports using Forms 6i & Reports 6i
• Developing stored procedure using pl-sql to consolidate the data

Technology Area: Oracle 9i, Developer 2000 (Forms 6i & Reports 6i), Windows 2003 Server, Toad 7.1, Microsoft Visual SourceSafe 6.0