Ravi Teja Kosuri

551-***-****

LinkedIn: https://www.linkedin.com/in/ravi-tej-589a1bb7/

PROFESSIONAL PROFILE

About 8 Years of professional experience in IT industry in various fields like Financial, telecom, Logistics and Manufacturing. Comprehensive Experience as a Data Analyst having hands on experience in Data modeling, Database Administrator/Developer on SQL Server 2008/2014/2016/2019, Oracle 9i/10g/11g, PostgreSQL 9.0/9.1.

Expertise in Data modelling, Development and Analysis for DataMart development, OLTP and Data Warehousing applications using Erwin, Power designer and ER Studio in several projects.

Involved with Architect and Business teams in designing the logical and physical models of the databases.

Expertise in Data Modeling Concepts like Star Schema Modeling, Normalization methodologies, Snowflake Modeling, Fact and Dimension tables.

Implemented Extraction, Transformation and Loading of data from Source to Target either in Flat Files or Database objects using Informatica and Microsoft SSIS.

Extensive experience in Project Management methodologies like Agile methodology and SDLC including requirement gathering, development, testing, debugging, deployment, documentation and production support.

Good Understanding in the Data Lake Concepts from raw data to transformed data which is used for various tasks including analytics, visualization and reporting.

Extensive knowledge on database administration of Oracle 8i, 9i, 10g, 11g with experience within very large-scale database environment.

Expertise in installing and configuring Oracle Database Server on various Linux Platforms such as OEL, RHEL, HP-UX, and AIX and in upgrading the databases from Oracle 9i to Oracle 10g/11g/12c.

Performances tuning of the database - SQL Tuning using Tuning utilities like TKPROF, EXPLAIN PLAN, AWR, ADDM, and ASH.

Expertise in PL/SQL, SQL and UNIX Scripting (Used to write UNIX Scripts & implemented by Using CRONJOB for Day – to – Day activities.).

Prepared Technical Documents (TDD) based on Functional Documents (FDD) provided by the Functional Team.

Team player with good communication and written skills, also a self-motivated individual with exemplary analytical and problem-solving skills.

TECHNICAL SKILLS

Languages : SQL, PL/SQL, C, UNIX Shell Scripting, XML, HTML, CSS.

Databases : Oracle 10g/11g/12c, MySQL, PostgreSQL 9.0/9.1, SQL Server 2014/2016/2017, DB2.

Operating Systems : HP-UX 10.x, 11.x, Sun Solaris 9.0/10.0, Red Hat Linux RHEL 2.1, 3.x, 4.x,

5.x and Windows 98/NT/2000/2003/XP/Vista/7/8.

Data Modeling Tools : Erwin r9.64/9.8, ER Studio V16.0/16.5 and Power Designer.

ETL Tools : Microsoft SSIS and Informatica 9.1/9.5/9.6.

Database Tools : SSMS, TOAD, SQL* Loader, SQL developer, PostgreSQL, SQL Compare, Real Application

Clusters, RMAN, Patch Management, SQLNET, Data pump.

Version control Tools : Tortoise SVN and SQL Source Control.

Tuning Utilities : TOAD, Explain Plan, AWR, ADDM and ASH.

Job Scheduling Tools : Harvest, Redwood Cronacle and Crontab.

PROFESSIONAL EXPERIENCE

Employer: MicroNet IT Solutions, Inc.

Client: YRC Worldwide

Role: Sr Data Analyst June 2017 – Present

Roles & Responsibilities:

Create Logical, Physical and XSD models for both OLTP and OLAP systems using Erwin Data Modeling tool.

Review the data model with the ETL team, DBA, Testing team to provide the business requirements and have a better understanding of the data model and Proficient in writing transformation logics in the ETL mapping documents.

Develop scripts to import the data dictionary from Erwin and create standard (S2T) mapping documents for the ETL team to develop the SSIS packages.

Design Star and Snowflake data models for Enterprise Data Warehouse and Performed normalization of the existing OLTP systems to the 3rd NF.

Create packages using SSIS for data extraction from Flat Files, Excel Files, and OLEDB to SQL Server.

Active participant in all data architect and business meetings to understand the project requirements and was involved in Agile methodology throughout the project life cycle.

Use advanced data modeling concepts such as Outriggers, Degenerate Dimensions, Conformed dimensions, Snowflakes and Bus matrix in accordance to Kimball’s approach to handle complex situations.

Took the ownership of administering Trillium Software to profile the data. Implemented and Upgraded the Trillium Discovery Center and configured the repositories to every Data Analyst for Data profiling.

Active participant in brain storming session with developers and DBAs to discuss tuning the database objects using different features like Explain Plan, modifying the code, Partitioning, Indexing, de-normalization to speed up the performance.

Forward Engineer the Data model by generating the DDL, Created the objects in the Development environment and involved in migrating the objects to the production.

Implement the company standard naming conventions for OLTP and OLAP entities and attributes of model and participated in weekly Data Analyst meetings to update the standards and utilize new modeling features.

Environment: RHEL 4/5, Oracle 11g/12c, SQL Server 2016/2017, DB2, PostgreSQL, Informix, SSIS/SSMS, Erwin 9.64/9.8, SQL*Plus, PL/SQL, SSIS, SSRS, SQL*Loader, PowerBI, EXPLAIN PLAN, TKPROF, STATSPACK, Toad for Data Analyst, SQL Source Control, Trillium Data Profiling, TFS Source Control.

Employer: Strategic IT Experts, INC.

Client: Wells Fargo

Role: Sr Data Analyst Nov 2015 – June 2017

Roles & Responsibilities:

Review the Conceptual model of the Enterprise Data Warehouse (EDW) and involved in Data Model reviews with Business teams to get a better understanding of the requirements and made necessary improvements to be in-line with the business requirements.

Reverse Engineered and Analyzed Logical/Physical Model for the OLTP application using Erwin and Used Forward Engineering to Create the physical model with DDL in the Test and Dev environments and there by promoting to production.

Migrated the Star schema data model (i.e. Dimensions and Fact Tables) from SQL Server (Source) to Oracle (Target) using Erwin.

Collaborate with Developer, ETL, Business and DBA teams to address, analyze and discuss solutions to the Data Issues to Enhance the data model.

Responsible for administration and supporting very large size (Multiple TB of Size) Oracle 11gR2/12c RAC and Non-RAC databases.

Practical knowledge of tracing and debugging. This included generating trace file reports and interpreting them to optimize the performance of the databases.

Database upgradations from 10g to 11g and 11g to 12c.

Coded PL/SQL Procedures, table Packages and UNIX shell scripts for selecting data from oracle database and automated several jobs using Shell/HTML Scripting.

Expertise on creating Oracle maintenance jobs on Autosys and promoting the jobs to different environments using tools such as Harvest and Anthill. Also, expertise on other job scheduling tools such as Redwood Cronacle and Crontab.

Application Code installations in production by following ITIL process such as problem and change management and using version control tool such as Tortoise Subversion.

Environment: Erwin 9.64, RHEL 4/5, Oracle 11g/12c, SQL Server 2014/2016, SSIS/SSMS, Oracle Partitioning, PL/SQL, SQL*Loader, EXPLAIN PLAN, TKPROF, SQLT, AWR, ASM, ASH, ADDM, Toad, Cronacle and Autosys.

Employer: Tata Consulting Services Sep-2013 – Aug 2014

Role: Data Analyst

Responsibilities:

Created Logical/Physical Models to Generate database in the form of DDL scripts using ER Studio to map from Source to Target.

Gathering the business needs, designed a Star schema for the DataMart and created the Data Model as per the Company standards.

Troubleshooting the defects in the Source system (Measures, Dimensions and Facts) by Reverse Engineering the reports and Enhancing the reports for the business needs.

Migrated database objects between different databases like Oracle and SQL Server. Schemas refresh using Export/Import.

Worked with ETL to create Source to Target (S2T) mappings and Performance monitoring and tuning for optimized results using tools like EXPLAIN PLAN, SQL*Trace, TKPROF, STATSPACK, AWR, ASH, ADDM.

Installed Oracle 11g Enterprise Manager (OEM) (Grid Control) for diagnosing and monitoring performance related problems and manage users, privileges, profiles, schemas using Oracle Enterprise Manager (OEM).

Updated the physical names and Definitions based on Oracle Standards.

Involved in creating business standards for the naming conventions and model management.

Environment: SSIS, Solaris 9.0/10.0, Oracle 10gR2/11g/12c, SSMS, Oracle Enterprise Manager, Oracle Partitioning, Oracle Replication, Hot Standby, SQL*Plus, PL/SQL, SQL*Loader, Toad, ER Studio and SQL Navigator.

Employer: Mphasis Apr-2011 to Sep-2013

Role: Jr. Database Administrator

Responsibilities:

Responsible for installing, upgrading and configuring the Oracle server.

On call support for production support DBA and offshore support model.

Efficiently used Transportable (XTTS)/Data pump in 10g migration from prod to test and test to prod.

Applied the bundle and CPU patches to all test, development and production databases.

Restore and Recover, Cloning and Duplicating databases using scripts as well as with RMAN.

Replicating schema/table level database using Streams. Performed entire database replication using Streams.

Experience with handling of medium to large Oracle OLTP (Online transaction processing).

Schemas refresh using Export/Import. Creating the database, table spaces, tables, indexes, settings privileges and user logins for prod/dev/test databases.

Trouble shooting various database performances by proper diagnosis at all levels like SQL, PL/SQL, database design, database tables, indexes, instance, memory, OS and java calls.

Creating Database Monitoring scripts and batch files for schedule jobs.

Creating user accounts and appropriate privileges as well as maintaining database security.

Assisted in writing scripts for database jobs and scheduling them through CRON utility.

Environment: ORACLE 9i/10g/11g, SQL, PL/SQL, Toad, Pl/SQL Developer, Cronjob, RMAN, Import/Export, UNIX AIX 5.1,

Sun Solaris, Windows NT.

Contact this candidate