• Over 7 Years of IT experience which includes Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).
• Active participation in Software Development Life Cycle (SDLC) specifically waterfall and Agile Scrum methodology
• Strong experience with T-SQL (DDL & DML) in Implementing & Developing Stored Procedures, Triggers, Nested Queries, Joins, Cursors, Views, User Defined Functions, Indexes, User Profiles, CTE’s, Table Variables, User Defined Data Types, Indexed Views, Relational Database Models,
• Experience in Error handling and debugging coding issues and troubleshoot production problems.
• Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques.
• Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views.
• Extracted, transformed and loaded data from various heterogeneous data sources and destinations like Access, Excel, CSV, Oracle, flat files using connectors, tasks and transformations provided by SSIS.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), and SQL Server Integration Services (SSIS).
• Good knowledge on logical and physical Data Modeling using normalizing Techniques.
• Created Tables, Views, Constraints, Index
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Developed materialized views for data replication in distributed environments.
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
• Partitioned large Tables using range partition technique.
• Created Packages and Procedures to automatically drop table indexes and create indexes for the tables.
• Experience in SQL performance tuning using Cost-Based Optimization (CBO).
• Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes
• Experience in ETL techniques and Analysis and Reporting including hands on experience with the Reporting tools such as Tableau, SSRS.
• Created Shell Scripts for invoking SQL scripts and scheduled them.
• Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.

Technical Skills:

Tools &Packages:

• SQL Server Management studio, Enterprise Manager, Profiler, SQL Server Business Intelligent studio (BIDS), DTS, Report Builder 9.0,

BI Tools:

• SSIS, SSAS, SSRS, Informatica, Power BI, Cognos.

Databases:

• MS SQL Server 2000/2005/2008, MS Access 2003/2005/2008, Oracle, DB2.

Language:

• T-SQL, PL/SQL, MDX,C, C# (.NET), Java, C++, COBOL, JCL, Mainframes.

Application Packages:

• MS Office Suite, MS Outlook, Windows SharePoint Services.

Data Modeling Tools:

• Erwin, MS Visio, EDI

Operating Systems

• Windows vista/XP/2003/2000, Windows Server 2000/2003/2008, UNIX.