SUMMARY

• About 6 years of professional experience as a SQL Server in Analysis, Design, Development and Support using MS SQL Server 2000/2005/2008/2012.
• Experienced in developing T - SQL (DDL, DML) and in developing and deploying packages within SSIS.
• Hands on experience in writing T-SQL queries, Stored Procedures, User Defined Functions (UDF), Cursors, Derived Tables, Views and Triggers.
• Experience in Data Analysis, Design, Implementation, Administration and Support of Business Intelligence, OLTP (Batch Processing, Online Processing), OLAP, ETL, Data warehousing, Data mining, DBMS and Data Modeling using Microsoft SQL Server 2012/2008R2, SSIS, SSRS and SSAS.
• Experience in Query tuning and performance tuning using SQL Profiler, Clustered and Non-Clustered indexes on tables for faster query retrieval as DBA role.
• Experience in configuration and maintain Report Manager and Report Server for SSRS, Deployed and Scheduled the Reports in Report Manager.
• Extensive knowledge in RDBMS concepts, logical/physical data models, indexes and data integration routines.
• Involved in all phases of Software Development Life Cycle (SDLC): analyze, design, implementation, testing and maintenance.
• Knowledge in Performance Tuning, Query Optimization and maintaining database systems using SQL Profiler and Database Engine Tuning Advisor.
• Experience in migration of Data from Excel, Flat files, Oracle RDBMS to MS SQL Server by using MS SQL Server DTS and SSIS packages/tasks.
• Able to install, upgrade and configure Microsoft SQL Server and Oracle Databases.
• Experience in enhancing and deploying the SSIS Packages from development server to production server.
• Flexible, enthusiastic and project oriented team player with excellent communication and leadership skills.
• Able to manage changing responsibilities and deliver time critical projects on schedule.
• Strategic vision, analytic, imaginative and procreativity ability to formulate and validate solutions.
• Excellent verbal & oral communication, analytical and inter personal skills to learn new ideas.

PROFESSIONAL EXPERIENCE

Confidential, Denver, CO

SQL Developer

Responsibilities:

• Involved to work with troubleshooting the stored procedures, functions, views, triggers and part to be increasing the performance tuning.
• Wrote several SQL Scripts such us finding tables that have Identity Columns, finding tables that do not have primary key.
• Developed and performed data modeling studies, support data selection, extraction and cleansing of mediation applications.
• Developed SSIS ETL packages to meet data flow needs.
• Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables from different databases.
• Automated the SSIS jobs in SQL scheduler as SQL server agent job for daily, weekly and monthly loads.
• Created Parameterized reports and Linked reports and thorough knowledge of report serving architecture using SSRS from SSAS Cubes.
• Extensively involved in replication and implemented Snapshot, Merge and Transactional Replications.
• Developed SSIS ETL Packages to meet data flow needs and building platform with the using of SSIS to feed in BIDS and SSAS cubes.
• Managed source code, keeping track of project deliverability such as defects, requirements, tasks and versioning control with the using of Team Foundation Server.
• Used Index usage statistics to determine how useful an index is and if an index is improving or hindering application performance.
• Designed SQL SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL Server 2012 R2 for further Data Analysis and Reporting by using multiple transformations, scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks.
• Enhanced performance of databases using optimization techniques-normalization, indexing and Transaction Isolation levels, monitoring logs to ensure the completeness of batch processes, scripts and processes.
• Supported Application Development team with any database issues, updates or new releases and deadlock issues, best practices in structuring SQL Queries, debugging unexpected SQL results, etc.

Environment: MS SQL Server 2012 R2, MS Access, SSIS, SSRS, SSAS Query Analyzer, Erwin, DTS, BCP, SQL Profiler, TFS.

Confidential, Louisville, TX

SQL Developer

Responsibilities:

• Created SSIS packages to load data from numerous sources to the application database.
• Designed stored procedures, tables, cursors, and joins by using T-SQL.
• Assisted daily for troubleshooting and nightly processes.
• Troubleshooted daily for any failure in nightly processes and executions.
• Assisted other teams for loading data with various environments and also created numerous stored procedures for other team members.
• Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Assisted the team in building a brand new data warehouse for de-identifying data project for all PHI and HIPAA regulated data.
• Optimized the database by creating various clustered and non-clustered indexes.
• Performed Logging and Error handling in SSIS and T-SQL.
• Updated T-SQL scripts after testing within the development environment.
• Worked closely with Business Analysts to update specifications and requirements.
• Assisted Business Analysts to create user stories before every sprint.
• CreatedLogins, users & rolesand involved in DailyUser Maintenance.
• CreatedDatabase Maintenance jobsto performfull & transactionlog Backupsand scheduled them with the SQL Server agent job scheduler.
• Worked as a leader in many scrum meetings, retrospective meetings and daily meetings in order to build a strong communication bridge between various project team members.
• Created SSRS report as per service request.
• Worked with Index and Performance tuning SQL Queries.
• Used various transformations like Data conversion, Conditional Split, Derived column, file system task, row counts, OLE DB Source, OLE DB Destination, OLE DB Command, Merge Join, Look up, Sort, Data flow task and so on.

Environment: MS SQL Server 2008, Windows 2003, Microsoft Office Share Point Server, TortoiseSVN, Business Intelligence Development Studio (SSIS), Micro Strategy Solutions.

Confidential, Irving, TX

SQL Developer

Responsibilities:

• Successfully installed configuration and maintenance of the new systems across all environments (Development, Test & Production).
• CreatedLogins, users & rolesand involved in DailyUser Maintenance.
• CreatedDatabase Maintenance jobsto performfull & transactionlog Backupsand scheduled them with the SQL Server agent job scheduler.
• Set upTransactionalReplicationbetween serversand troubleshootthe issues
• Monitored databasegrowthactivities& Troubleshooted Transaction LogIssue.
• Created and configured mirroring in case ofDisaster Recovery problems.
• Installation on clustered environments and createdclustered and non- clustered indexes
• Worked closely with theProjectteam in clarification of requirements and communicated the same to theoffshore team.
• Performedweekly status informationon all the projects to Project Manager.
• Worked withPerformance Tuning/Query tuning, execution plans, traceflags and SQLProfiler.
• Successfully Installed Service packsto all environments.
• As a part of the DBAteam providing24/7 production support tothe clients
• Providing Design, Architecture & Engineeringsupport as well as on-call support for SQL Serverdatabases and servers using SQL Server2000, 2005,2008 R2 and 2012
• PerformingDB backups, restores, clean-up & DB maintenance activitiesin a largelike log file monitoring, statistics update, performance tuning, disaster recovery
• Planned and monitored new SQL Serverimplementations, server-to-servermigrations, andupgrades, including database definition, structure, documentation,andlong-term hardwareandstorage requirement.
• Developed complexStoredProcedures, triggers, tables, and viewsand other SQL joins and statements for applications by using T-SQL.
• Created a variety ofProject Dashboardsfor different managements within FRO.
• Performedaggregations, averageson various groups ofdaily, weekly and monthly datatodisplay theprogressofeach ProjectwithinFRO (Financial Reporting Operations) onweekly and monthly dashboards.
• Convertedexisting Excel templates into SSRS reportsto migrate the reporting model to SQL ServerReporting Services. Also made sure that the SSRS reports wereconsistent with the previous Excel layoutsto avoid any issues while uploading the monthly reports to the Gran Central database.
• DevelopedSub-reportsandDashboardsusingGauges and Chartsto add more detail to the report.
• Built complexAd Hoc,Standard ReportsusingSSRSand worked with tuning the large complex reports on SQL Server Database.
• CreatedData drivenSubscriptions toautomatethe process ofstoring copies of hundreds of parameterized monthly reports to the server.

Environment: MS SQL Server2012/2008R 2/2008/2005/2000, Windows 2000/2003 ServerOperating systems, SSIS, SSRS, Clustering, Performance Tuning, MS SQLReporting Services, Change Management System, Remote Desktop, MS Access, Oracle 10g

Confidential, Fort Worth, TX

SQL Server Developer

Responsibilities:

• Developed stored procedure to load data from legacy to the application for 10 years of data.
• Developed complexStoredProcedures, tables, cursors, numerous SQL joins and statements for applications by using T-SQL.
• Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Converted data type from legacy to the production (application) as required.
• Extensively used mapping logic and data model to map data from legacy system to the production (application).
• Created and managed SSIS packages and Control Flow tasks to load some preliminary tables for the main ETL process.
• Extensively used cursors and temp tables to load each row from legacy to application database.
• Designed error log tables for all the developers in order to catch errors during any kind of loading data.
• Created stored procedures for all the developers to disable and enable constraints within each database as needed by the developers.
• Created functions in order to convert data type for any complex conversion process for the development team.
• Identified the causes of slow running of T-SQL queries for the development team.
• Optimized the database by creating various clustered and non-clustered indexes.
• Performed Logging and Error handling in SSIS and T-SQL.
• Updated T-SQL scripts after testing within the development environment.
• Tested converted data in the development, integration and application environment on daily basis.
• Performed optimization techniques-normalization and indexing ensure the completeness of batch processes, scripts and processes.
• Assisted Business Analyst to test data and GUI according the specifications and technical requirements.
• Administered SQL Server 2008 Management Studio tools including SQL Profiler and Database Engine Tuning Advisor.
• Performed weekly dry runs for the development environment for all the data converted. Dry runs are done in development, integration, testing and production environment.
• Worked closely with Business Analysts to understand the legacy system data in order to convert them correctly for the application to work properly.

Environment: SQL Server 2008R2 Enterprise, Windows Server 2003 Enterprise, Management Studio, Business Intelligence Development Studio (SSIS, SSAS, SSRS), Microsoft Office Share Point Server, OLTP, OLAP