SUMMARY

• 5+ years of experience as a SQL Developer wif extensive experience of analytical techniques.
• Experience wif software development life cycle (SDLC), Agile / Scrum and Project Management Methodologies.
• Experience in installation, configuration of Oracle, MySQL, MS Access, MS SQL Server 2012/2014/2016/2017, MongoDB and DB2.
• Expertise in Client - Server application development using Oracle11g/10g, PL/SQL, SQL *PLUS, TOAD
• Hands on experience in monitoring SQL Server Performance tuning in SQL Server 2012/14/16/17 using SQL Profiler, Query Analyzer, Enterprise Manager, Index Tuning Wizard, and Windows Performance Monitor.
• Knowledge of Relational Database Management systems.
• Experienced in creating and using Stored Procedures, Triggers, Views, User Defined Functions, Sub - Queries and Joins for complex queries involving multiple tables and exception handlers.
• Proficient in SQL Server and T- SQL (DDL and DML) in constructing Tables, Normalization/ Denormalization Techniques on database Tables.
• Having experience in Database administration like creating the roles, users and giving the permissions for the database, tables, functions etc.
• Expertise in developing Parameterized, Chart, Graph, Linked, Dashboard, Scorecards, Drill-down, Drill-through and Cascading reports using SSRS.
• Very good experience in Oracle tools likeSQL Plus, SQL Loader, SQL DeveloperusingTOADin secure databases.
• Well versed inOracle Databaseand worked on various versions11g/10g.
• Very good noledge ofSQL, PL/SQLespecially writing queries wifJoins, Sub-Queries, Rollups, Cubes, Set Operators.
• Prepared flow charts, database ER diagrams using diagramming tools likeMicrosoft Visio.
• Good interpersonal, Analytical and Communication skills.

TECHNICAL SKILLS

Operating Systems: Windows, Linux, Unix

Databases: Oracle, SQL Server, MySQL, MS Access, MongoDB, DB2

Languages: SQL, PL/SQL, Unix Shell scripting

Reporting Tools: Crystal Report, SSRS

Tools: SQL *Plus, SVN, CVS, Microsoft Visio, TOAD

Methodologies: SDLC, Agile, Scrum, Waterfall

PROFESSIONAL EXPERIENCE

Confidential, IL

SQL Developer

Responsibilities:

• Developed highly optimized stored procedures, functions, and database viewsto implement the business logic and also created clustered and non-clustered indexes.
• Involved in performance monitoring, tuning and capacity planning.
• Extensively used high level backendPL/SQLprogramming involving different databases.
• Responsible for implementation of data viewers, Logging, error configurations for error handling the packages. Involved in complete life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Designed, deployed, and maintained complex canned reports using SQL Server Reporting Services (SSRS).
• Optimize the PL/SQL code using collections and bind variable for bulk operations.
• Writing analytical queries for faster processing and better performance.
• Creating sample data for unit and integrated testing for end-to-end process.
• Perform functional testing to ensure technical accuracy based on functional specification document.
• Extensively used Oracle, PL/SQL language to develop complex stored packages, procedures, functions, triggers, Text queries Text Indexes etc. to process raw data and prepare for the statistical analysis.
• Involved in analysis, design and coding of Oracle processes inPL/SQLto buildPackages.
• Frequently used advanced Oracle and PL/SQL features like Dynamic SQL, Ref-Cursor, Bulk collect, Analytic functions e.g. ratio-to-report, rank etc. in the new routines as well as to modify the existing routines work more efficiently.

Confidential, IL

SQL Developer

Responsibilities:

• Database design and development includingTables, Primary and Foreign Keys, IndexesandStored Procedures.
• GeneratedSQL and PL/SQL scriptsto install create and drop database objects, including tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms.
• Maintained a series ofUNIX Shell Scriptsto manage batch order processing.
• Database performance monitoring and identifying bottlenecks hindering the performance of the database.
• Created SQL statements using hints for maximum efficiency and performance, create and Maintain/modifyPL/SQL Packages, mentor others wif the creation of complexSQL Statements, perform data modeling and create/maintain and modify a complex database.
• Created changes in the database according new requirements.
• Developed Shell scripts for job automation and daily backup.
• Utilized tools likeTOADduring development of the application.
• Writing SQL queries,Cursorsusing embedded SQL, PL/SQL.
• Responsible forcoding, testingandmaintainingOracle, PL/SQL code. Involved indatabase design, performance tuning, code standardization, and day-to-day activities on Oracle database forbetter performancein processing time of SQL and PL/SQL statements.

Confidential

SQL Developer

Responsibilities:

• UsedCrystal Reportsto create various business reports.
• Working as SQL Server Analyst / ETL Analyst using SQL Server.
• Writing Triggers, Stored Procedures, Functions, define User Defined Data Types, TSQL, and Create and maintain physical structures.
• Creating SSIS Packages, Configure SSIS packages for different environments using DTS Config.
• Produce CSV, utilize CSV files as part of ETL Process.
• Implement Security, Roles, Logins, and Permissions.
• Extract-Transform-Load data into SQL Server Normalized database from various sources.
• Design UML Use Case diagrams, Conceptual Flow Diagrams, ER Diagrams by reverse engineering the databases using Microsoft Visio.
• Collecting Server Inventory data from users using InfoPath into SQL Server.
• Installing and Configuring SQL Server on Virtual Machines.
• Migrated hundreds of Physical Machines to Virtual Machines.
• Conduct System Testing and functionality after virtualization