SUMMARY

• With 5+ years of experience and strong verbal and solid analytical skills for writing relational database solutions for businesses to work independently or a team to have a collaborative solution.
• Strong experience with SQL Server and T - SQL in implementing and developing Stored Procedures, Triggers, Nested Queries, Joins, Views, User Defined Functions, Indexes, User Profiles, Relational Databases Models, creating and updating tables and checking the database consistency by executing DBCC commands.
• Very good experience in Oracle tools like SQL*Plus, SQL*Loader, SQL Developer using TOAD in secure databases.
• Excellent knowledge in RDBMS concepts such as table normalization and constructs along with database objects creation like tables, user defined data types, Indexes, User Defined Functions, Stored Procedures, Views and Triggers.
• Very good knowledge with T-SQL (DDL and DML) statements, RDBMS, data dictionaries.
• Experience in SQL server Performance Tuning (Profiler), Client/Server Connectivity, Query optimization, Back-up/Restore and running database consistency checks Using DBCC.
• Exceptional hands-on working knowledge and recent experience working with SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).
• Proficient in implementing Key Performance Indicator (KPI) Objects and partitions in SSAS.
• Well-versed with configuration, maintenance, monitoring, backups and recoveries, develop and debug Stored Procedures and Triggers.
• Good in developing and modifying multi-dimensional cubes using SQL Server Analysis Services (SSAS)
• Experienced in writing parameterized queries for generating tabular reports, formatting report layout, Sub reports using Global Variables, Expressions, Functions, sorting the data, defining data source and subtotals for the reports using SSRS.
• Experience Data analysis and created packages to transfer data between ORACLE, MS ACCESS and FLAT FILES to SQL SERVER using DTS/SSIS.
• Good knowledge in Normalizing and De-normalizing the tables and maintaining Referential Integrity by using Triggers and Foreign Keys.
• Expert in using tools like Bulk Copy (BCP), Data Transformation Services (DTS) in SSIS.
• Hands on experience working with different types of reports, parameter-based reports, cascading parameterized reports, drill down reports, drill through reports, sub reports, and ad-hoc reports, graphical reports, well-formatted reports, matrix reports, chart and tabular, using SSRS.
• Experience in designing and developing Complex Reports in Micro Strategy Desktop, Micro Strategy Web.
• Skilled in design of logical and physical data modeling using Erwin data modeling tool.
• Excellent problem-solving skills, communication, presentation and interpersonal skills. Strong troubleshooting and organizational skills.

TECHNICAL SKILLS

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

Languages: C, C++, JavaScript, SQL, PL/SQL

Web Technologies: HTML5, CSS3, DHTML, XML, XHTML, XSLT, JavaScript, TypeScript, AJAX, JQuery, JSON, Apache

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, SQL server configuration manager

Tools: TOAD, SQL Developer, Erwin, SQL Navigator, SQL*Loader, SQL*Plus, MS-FrontPage, MS Office Suite

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

Data Modelling: Erwin, MS Visio, MS Access

Web Servers: Apache Server, Windows IIS Server

Other Software/tools: Visual Studio, WinSCP, Putty

Databases: Oracle, DB2, MySQL, MongoDB

Operating system: Windows Variants, UNIX, Mac

PROFESSIONAL EXPERIENCE

Confidential, Portland, OR

SQL Developer

Responsibilities:

• Involved in analysis, design and coding of Oracle processes in PL/SQL to build Packages.
• Developed and maintained ETL packages to extract the data from various sources and Responsible for debugging and upgrading of several ETL structures as per the requirements.
• Experience in managing and automating Control flow, Data flow, Events and Logging programmatically using Microsoft .NET framework for SSIS packages.
• Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data warehouse.
• Used various SSIS task such as conditional split, derived column, lookup which were used for data scrubbing, data validation checks during staging, before loading the data into the data warehouse.
• Created SQL server configurations for SSIS packages and experienced in creating jobs, alerts, and SQL mail agent and schedule SSIS packages.
• Used SQL*Loader and UTI File Loader to upload bulk data by writing scripts for the Control file.
• Working on the ETL side of the process to load data into database from different servers.
• Database design and development including Tables, Primary and Foreign Keys, Indexes and Stored Procedures.
• Generated SQL and PL/SQL scripts to install create and drop database objects, including tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms.
• Tune SQL statements using hints for maximum efficiency and performance, create and maintain/modify PL/SQL Packages, mentor others with the creation of complex SQL Statements, perform data modelling and create/maintain and modify complex database Triggers and Data Migration scripts.
• Writing SQL queries, Cursors using embedded SQL, PL/SQL.
• Testing and debugging of the applications.
• Separating of tables and indexes on different locations. Reducing Disk, I/O Contention.
• Applications Tuning of Database using EXPLAIN PLAN, TKPROF, SQL TRACE, ANALYZE, HINTS. Oracle query tuning and optimization.
• Extensive Use of Bulk Binds, Bulk Collect.
• Extensive Use of Pragma Autonomous Transactions.

Environment: SQL Developer, SQL Server, SQL*Plus, TOAD, ERWIN, Informatica, SQL Developer, HTML5, UNIX, Oracle, Windows.

Confidential, Richmond, VA

SQL Developer

Responsibilities:

• Extensively used high level backend SQL programming involving different databases.
• Involved in the development of new Procedures, Functions, Packages, Triggers and also updating the old ones based on the change requests.
• Involved in the analysis, design, flow, archiving of data and databases and also with their relationships.
• Developed new Forms which are used to extract data from different systems and criteria. The results are written to a flat file.
• Performed unit testing of data extraction forms.
• Prepared technical specifications document for the Procedures which is used to update the purchase order information from one database to another database.
• Utilized tools like TOAD during development of the application.
• Used Database Trigger for making history of insertion, updating, deletion and all kind of Audit routines.
• Use of EXPLAIN PLAN, ANALYZE, HINTS, TKPROF to tune queries for better performance.
• Wrote UNIX Shell Scripts to automate the daily process as per the business requirement.
• Writing Tuned SQL queries for data retrieval involving Complex Join Conditions.
• Use of EXPLAIN PLAN, ANALYZE, HINTS to tune queries for better performance and also extensive Usage of Indexes.
• Read data from flat files and load into Database using SQL*Loader.
• Created the External Tables in order to load data from flat files and SQL scripts for monitoring.
• Responsible for creating reports based on the requirements using SSRS and defined the report layout and identified datasets for the report generation.
• Created different types of reports including financial reports, cross-tab, conditional, drill-down, sub reports also parameterized reports, ad hoc reports for existing databases.
• Design and created financial report templates, bar graphs and pie charts based on the financial data. Scheduled the monthly /weekly/daily reports to run automatically.
• Developed, implemented and maintained various database objects such as stored procedures, triggers, functions, indexes and views.
• Worked as a team for defining measures and dimensions by creating cubes in SSAS and Responsible for developed MDX queries for faster retrieval historical data from cubes.
• Worked Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file System task, ftp task, send mail task, active script task, Message Queue Task, XML task.
• Created Documentation of development code and the test cases involved.
• Worked extensively on Exception Handling, to trouble-shoot PL/SQL code.

Environment: SQL Developer, SQL Loader, SQL Server, HTML5, ERWIN, TOAD, Oracle, UNIX/Sun Solaris, Windows.

Confidential, Honolulu, HI

SQL Developer

Responsibilities:

• Wrote SQL stored procedures (and triggers) to keep firm database updated.
• Designed databases and ensured their stability and performance.
• Assisted in implementing and defining database standards.
• Analyzed existing SQL queries for improvements.
• Created and configured databases.
• Documented database functionality for employee instruction manual.
• Migrated data from Microsoft Excel to MySQL.
• Troubleshooted and maintained firm SQL database.
• Interpreted business requirements to determine project process and timelines.
• Created table indexes to improve database performance.
• Worked with IT department by extracting and interpreting data from various databases.
• Crafted billable hours reports via Excel to deliver to non-technical client reps.
• Gathered client-relevant data using VLOOKUP formula.
• Performed data analysis using Pivot tables.
• Formatted cells using conditional formatting to automate billing and catch errors.
• Balanced competing needs within department against strict firm-wide deadlines.
• Verified data against PACER (court database) to ensure ongoing accuracy of data.
• Writing and Debugging T-SQL, stored procedures, Views and User Defined Functions.
• Initial application was OLTP done in SQL Server and SYBASE in Windows.
• We just started to use SQL Server when SUN bought us and we converted from MS SQL Server to PostgreSQL/Windows for new customers.
• Responsibilities included the complete conversion from SQL Server to PostgreSQL including all database objects, stored procedures, data, indices, security and obtaining training for the programmers.
• Maintained the database schema, designed tables, wrote stored procedures, analyzed and implemented indices/keys/triggers, wrote and tested SQL using SHOWPLAN and SQL TRACE, fixed/restored corrupt databases, performed on-site client troubleshooting, wrote user guides on how to improve performance and maintain the SQL Server database

Environment: MS SQL Server, SQL Developer, SSIS, SSRS, BIDS, QlikView, C#, Power Designer, Microsoft Outlook, Team Foundation Server, Oracle, Windows.