SUMMARY

• Around 5+ years of IT experience as an SQL Developer Development & Support of Oracle Database in Production, staging and Development environments.
• Experience in all phase of SDLC like Requirement Analysis, Implementation and Maintenance, and extensive experience wif Agile (SCRUM).
• Proficient in Query/application tuning using optimizer Hints, Explain plan, SQL Trace, TKPROF.
• Experience in database design using PL/SQL to write Stored Procedures, Functions, Triggers and strong.
• Generating SQL and PL/SQL scripts to install create and drop Trading Exchange Connection database objects including: Tables, Views, Primary keys, Indexes, Constraints, Packages, Sequences, Grants and Synonyms.
• Expert in creating Public Synonyms, DB Links.
• Managing security by creating and granting Roles and Privileges to users.
• Experience in developing external Tables, Views, Joins, Cluster indexes and Cursors.
• Proficient in advance features of Oracle for PL/SQL programming like Using Cursor Variables, Ref Cursors, Nested Tables and Dynamic SQL.
• Experience in creation of table Partitioning by range, list, hash, composite methods and Indexes for managing large tables.
• Extensive experience in using Oracle seeded packages like DBMS OUTPUT, DBMS SCHEDULER, UTL FILE, DBMS SQL and DBMS STATS.
• Expertise in handling errors using Exceptions wif RAISE application clause.
• Knowledge of Materialized Views.
• Proficient working experience wif SQL, PL/SQL, Database objects like Stored Procedures, Functions, Packages, Triggers and using teh latest features to optimize performance like Bulk Binds, Inline views and Global Temporary Tables.
• Very good experience in Oracle tools like SQL*Plus, SQL*Loader, SQL Developer using TOAD in secure databases.
• Very good noledge of SQL, PL/SQL especially writing queries wif Joins, Sub - Queries, Rollups, Cubes, Set Operators. experience in writing complex queries, using Oracle, SQL Server and MySQL.
• Developed new Reports which are used to extract data from different systems and criteria.
• Automated teh process through teh UNIX Shell Scripting and auto sys job scheduling.
• Strong analytical, communication, interpersonal skills and ability to work wif proven problem-solving skills.
• Extensively involved in fixing production issues and support.

TECHNICAL SKILLS

Languages: T-SQL, C, C++, C#, Visual Basic, VB.net, C#.net, ASP.Net HTML5, Shell Script, CSS3, AJAX, me Frames, UML

Data Modelling: Erwin, MS Visio, MS Access

SQL Server Tools: SQL Server Management Studio (SSMS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Export & Import wizard, DTS, SQL Server Profiler, Power BI, SQL server configuration manager

SQL Developer Tools: SQL Developer, SQL*plus, Toad

Web Servers: Apache Server, Windows IIS Server

Other Software/tools: Visual Studio, WinSCP, Putty

Reporting Tools: MS SQL Server Reporting Services (SSRS), Business Object Crystal Reports, Excel PowerPivot

Databases: SQL Server, Oracle, DB2, MySQL, Mongo DB

Operating system: Windows, UNIX, Mac

PROFESSIONAL EXPERIENCE

Confidential, Pittsburgh, PA

SQL Developer

Responsibilities:

• Actively involved in scrum meetings for requirement analysis, task analysis, progress discussions.
• Stored Procedures, User Defined Functions, Views, T-SQL scripting for complex business logic. Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data warehouse.
• Conducted performance monitoring and tuning using SQL Profiler and windows performance monitor.
• Performed installation, administration, configuration and development upgrades.
• Creating and editing teh database objects (tables, relationships, trigger, store procedure, and user define functions) by using DDL.
• Experience in Resolving teh Memory contentions using SQL Min/Max Settings, SQL Resource governor and Lock pages In Memory settings, Page File settings, Memory related DMV’s.
• Editing teh data in teh database system by using DML.
• Environment: MS SQL, MS Visual Studio, MS Visio, SQL Server Integration Service (SSIS), SQL
• Server Reporting Service (SSRS), SQL Server Analysis Service (SSAS), MS Visual Studio, Windows Server.
• Identify deadlock, blocking scenarios and Perform Reindexing and Index defrag operations for teh maintenance of large tables to resolve performance issues.
• Controlling Database Server file system management for data storage capacity and authority on SAN and RAID levels.
• Worked on Requirement analysis, design and development of modules using Power BI, Tableau, SSIS, SSRS.
• Used SSIS to create ETL packages to validate, extract, transform and load data into data warehouse and data marts.
• Backup and recovery of production databases (using 3rd party tool LightSpeed) on daily /weekly basis to ensure data integrity, striping teh backups to ensure easy backup management.
• Perform database monitoring data and log growth, Jobs, Alerts, disk usage and clean-ups, using various custom scripts in SQL Server Agent jobs, setup of Database Mail /operators for alerting.
• Database Code - reviewing\approving database code before moving to production.
• Building, publishing customized interactive reports and dashboards, report scheduling using both Power BI and Tableau server.
• Production Performance - reviewing production performance metrics to determine if\how changes are needed to prevent issues. Work wif Tech services Database administration as needed.
• Generated stored procedure using OPEN XML clause to update teh database. It accepts input parameter as XML which serialized from business object and it also uses FOR XML clause to return XML as a dataset and data access layer de-serialize into business object.

Environment: T-SQL, PL/SQL, SQL Developer, SQL Server, SQL*Plus, Microsoft SQL Server Integration Services (SSIS), Microsoft SQL Server Reporting Services (SSRS), Microsoft SQL Server Analysis Services (SSAS), TOAD, Oracle, Power BI, Windows.

Confidential, San Diego, CA

SQL Developer

Responsibilities:

• Involved in complete Software Development Life Cycle (SDLC) process by analysing business requirements and understanding teh functional work flow of information from source systems to destination systems.
• Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server and Flat files.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing teh packages in both teh environments (Development and Production).
• Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers and Fuzzy Lookups etc.
• Optimization and standardization of teh ETL packages while using SQL server Integration Services.
• Understanding teh ETL frame work and design teh solutions accordingly.
• Create reports, dashboards, stories and visualization reports by using SSRS, Power BI and Tableau Reporting.
• Improved Performance by creating Clustered and Non- clustered Indexes and by optimizing teh T-SQL statements using SQL profiler.
• Developed Tableau visualizations and dashboards using Tableau Desktop.
• Developed Tableau workbooks, Power BI reports and dashboards from multiple data sources using Data Blending.
• Worked to setup a process to create and share various reports on weekly and ad-hoc requests.
• Coordination wif other team mates on day-to-day basis and any project related concerns.
• Tune SQL statements using hints for maximum efficiency and performance, create and maintain/modify PL/SQL Packages, mentor others wif teh creation of complex SQL Statements, perform data modelling and create/maintain and modify complex database Triggers and Data Migration scripts.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Involved in upgrading from SQL Server.
• Created and Developed Power BI Reports of companies Hotfix pipeline.
• Writing SQL queries, Cursors using embedded SQL, PL/SQL.
• Extensive use of T-SQL including Stored Procedures, views, triggers and column store indexes.
• Involved in ETL architecture enhancements to increase teh performance using query optimizer.
• Implemented Event Handlers and Error Handling in SSIS packages.
• Created SSIS packages for Data Conversion using data conversion transformation.
• Coordinated wif front-end for implementing logic in stored procedures and functions.
• Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement teh business logic and also created clustered and non-clustered indexes.
• Performed ETL mappings using MS SQL Server Integration Services.
• Ability in developing XML applications using Open XML standards.
• Served as DBA in teh completion of implementations, managing projects from business requirements analysis to solutions delivery and support.
• Configured teh loading of data into slowly changing dimensions using Slowly Changing Dimension wizard.
• Advanced extensible reporting skills using SQL Server Reporting Services (SSRS).
• Developed various types of complex reports like Drill Down, Drill through, Cross tab reports.
• Involved in scheduling, creating snapshots and subscriptions for teh reports using SSRS.
• Involved in designing Parameterized Reports for generating Ad-Hoc reports as per teh client requirements.
• Advised optimization of queries by looking at Execution Plan for better tuning of teh database.

Environment: SQL Developer, SQL Server, SQL*Plus, Microsoft SQL Server Integration Services (SSIS), Microsoft SQL Server Reporting Services (SSRS), Microsoft SQL Server Analysis Services (SSAS), TOAD, Oracle, Power BI, Windows.

Confidential, Chattanooga, TN

SQL Developer

Responsibilities:

• Performed daily tasks including backup and restore by using Tivoli TDP, SQL Server Management Studio.
• Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved scheduling of jobs to re-index and update statistics in databases.
• Installation, configuration and maintenance of teh MS SQL.
• Performance and tuning of SQL servers and application issues related to migration.
• Testing of applications for performance, data integrity and validation issues.
• Performed teh database clean-up tasks.
• Scripting teh database consistency checks (DBCC), scheduling teh scripts to run daily and weekly basis.
• Utilized SQL*Loader to perform bulk data loads into database tables from external data files.
• Designed and developed a custom database (Tables, Views, Functions, Procedures, and Packages).
• Monitoring existing SQL code and performance Tuning if necessary.
• Interact wif business analysts to develop modelling techniques.
• USED SQLCODE returns teh current error code from teh error stack SQLERRM returns teh error message from teh current error code.
• Experience in using DMVs for finding out long running queries
• Troubleshooting and resolving day to day issues such as Job failures, Transactional log issues, Database full, Blocking and deadlock issues, Permission issues etc.
• Performed data Extraction, Transformation and Loading (ETL) between systems using SQL tools such as SSIS.
• Handling Memory configurations for SQL Server and SQL Server on Windows.
• Designing and creating databases for Testing, Development, Pre-production and Production environment.
• Working noledge in Analysis Services (SSAS), Reporting Services (SSRS) and Integration services SSIS.
• Recovering teh databases from backup in disasters. Implementing Point-In-Time Recovery solutions
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Implementation of SQL Logins, Roles and Autantication Modes as a part of Security Policies for various categories of users.

Environment: SQL Server, SSIS, SSRS, SSAS, PL/SQL, SQL*PLUS, SQL Developer, SQL Server, UNIX, ERWIN, Oracle, Windows.