PROFESSIONAL SUMMARY:

• Over 8 years of IT experience which includes Analysis, development, design, support, Testing and implementation of applications, Reports and Databases of Microsoft SQL Server 2014, 2012, 2008R2, 2005 in Production ENVIRONMENT.
• Experience in Software Development Life Cycle (SDLC), Software Test Life Cycle (STLC) and Defect Management Life Cycle.
• Expert in writing T - SQL, working on DTS, SSIS, SSRS, SSAS, Data Cleansing, Data Scrubbing and Data Migration.
• Proficient in designing highly flexible Database Architectures and Data Modeling, Data Mapping, Table Normalization, Optimization and Tuning.
• Extensive experience in writing and debugging complex stored procedures, cursors, triggers, Inner Joins & Outer Joins, views and user-defined functions.
• Expertise with continuous integration and nightly deployments using TFS with a Test Driven Design approach
• Experience in designing the logical data model and physical data model.
• Good understanding and designing of Star and Snow Flake data models Schema used in relational, dimensional and multidimensional data modeling.
• Involved in designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the insurance data from various source systems
• Excellent understanding of data mining algorithms, high performance and optimal algorithms.
• Used multiple transformations in SSIS to meet the business requirements by collecting data from various sources.
• Migrated data in various formats like text based files, Excel spreadsheets, to SQL Server databases using SQL Server Integration Services (SSIS) to overcome the transformation constraints.
• Good knowledge on tableau reports.
• Very good experience in developing reports using SQL Server 2008 Reporting Services (SSRS).
• Hands on experience in creating Parameterized reports and Linked reports with thorough knowledge of report serving architecture. (Table, chart and matrix report).
• Proven ability in generating Drill down and Drill through reports with Drop down menu option, sorting the data, defining subtotals in SSRS 2012.
• Experienced in sorting the data, defining data source and subtotals for the reports.

TECHNICAL SKILLS:

Programming Languages: T-SQL, PL/SQL, C#, C, C++, Java, UNIX shell scripts, XML, HTML

Database Application Software: My SQL/SQL Server 2014/2012/2008 R2/2008/2005, MS Access.

DB Utilities: SQL Server Management Utilities, Query Analyzer.

GUI: DTS Import/Export, SQL Server BIDS.

Reporting: MS Access, Excel, SSAS, Crystal reports.

ETL Tool: SSIS

Application Software: Microsoft Office, macros, Visual Studio.

Change Management Tool: Visual Source Safe (VSS).

Modeling Tool: Database designer, UML, Visio, ER-Win.

Operating Systems: Windows Server 2008/2003/Vista/XP.

PROFESSIONAL EXPERIENCE:

Confidential, Sugar Land, TX

SQL Server BI Developer

RESPONSIBILITIES:

• Actively collaborate with users, Team leads, and technical managers to fully understand the requirements of the system.
• Creating various reports on Daily, Weekly and Monthly basis.
• Server maintenance and support of SAS, SQL Server and MYSQL Server
• Performing Replication, Backup compression for individual tables and indexes and reducing the disk usage.
• Work with MYSQL and SQL transferring and reviewing data from heterogeneous sources like (Flat file, Excel, CSV)
• Maintenance and support of existing systems on day to day basis.
• Well Versed with views, joins, stored procedures, scheduling Jobs and alerts using SQL Server Agent
• Develop the reports using SQL Squirrel, MYSQL Database and analytical reports.
• Assign roles and granted permissions to users and groups and responsible for administration tasks.
• Server monitoring and capacity planning to ensure adequate disk space and memory on all servers.
• Using TOAD for SQL and MYSQL developer tools for faster application design and developments.
• Using SAS develop the reports in SQL, and MY SQL.
• Responsible for data integrity throughout the application SQL and MYSQL
• Using MYSQL and SQL Server as backend database for MS Access and MS Excel applications.
• Using SSRS to create, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports.
• Create standard Reports and Cross Tab Reports and Drill Through reports.
• Generate Reports using Global Variables, Expressions and Functions for the reports.
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Installing different hot fixes for deadlocks, blocking and indexes.
• Monitor testing servers for long running stored procedures, queries using profiler and recommended clustered and non-clustered indexes using DTA.
• Improve query performance by adding covered indexes, adding file groups.
• Performing daily tasks including backup and restore by using SQL Server 2014/2012 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.

ENVIRONMENT: SQL Server 2014/2012, MY SQL, TOAD, T- SQL, MY SQL, SAS, Toad, SSRS, Windows Enterprise Server 2007, Linux, Hadoop, MS-Access, Excel, VBA.

Confidential, Richmond, TX

SQL Server BI Developer

RESPONSIBILITIES:

• Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables from different databases.
• Implemented Functions, views, triggers, stored procedures and enforced business rules via checks and constraints.
• Performed Replication, Backup compression for individual tables and indexes and reducing the disk usage and I/O resources.
• Designed SSIS (ETL) Packages to extract data from various heterogeneous data sources such as Access database, Excel spreadsheet and flat files into SQL Server 2008.
• Created the packages in SSIS (ETL) with the help of Control Flow Containers, Tasks and Data flow Transformations.
• Build efficient SSIS packages for processing fact and dimension tables with complex transforms and type 1 and type 2 changes
• Worked with Inbuilt Transformations in SSIS (ETL) like Persistent Lookups to enhance performance for lookups and more utilization of I/O resources.
• Efficiently utilized the Merge Join in SSIS and Merge statement to populate the data warehouse from a source database, which provides efficient and granular level of control.
• Wrote the test conditions and test cases for the Appointments, Payments, Update Claimant
• Developed a data model and implemented the same using ERWIN.
• Performed Data profiling tasks In SSIS (ETL) using the Data Profile Viewer and then clean and standardize the data as appropriate for the Databases.
• Conducted the Error handling in SSIS (ETL) using the Event Handlers.
• Developed custom selection of reports ordering using SQL Server Reporting Services (SSRS)
• Created Ad-Hoc reports using Report Builder.
• Created a tree view application to view the recent reports generated and a scheduler to schedule a selected report to be run on a particular date.
• Used Reporting Services (SSRS) to schedule reports to be generated on predetermined time.
• Running DBCC consistency checks and fixing data corruption in application databases.
• Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
• Used Red gate SQL Compare to create a report and SQL change script with schema differences between production, development and testing servers.
• Used Red gate SQL Data Compare to generate a script with data differences between production servers.
• Strong experience in Software Development Life Cycle.

ENVIRONMENT: MS SQL Server 2012/2008R2, SSIS, SSRS, SSAS, Visual Studio 2008, T- SQL, Windows Server 2008 R2, Visual Source Safe 2005 (VSS), XML, ADO.NET, ERWIN, PL/SQL, MS-Access, MS-Excel

Confidential, Austin, TX

SQL Server BI Developer

RESPONSIBILITIES:

• Extract, Transform and Load source data into respective target tables to build the required data marts.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications following SQL code standards.
• Implemented different types of constraints on tables.
• Designed and applied entity and attributes description and definition for the models.
• Managed indexes, statistics and tuned queries by using execution plan for optimizing the performance of the databases.
• Maintained the physical database by monitoring and optimizing performance, data integrity and SQL queries for maximum efficiency using SQL Profiler.
• Created ETL process using SSIS to transfer data from heterogeneous data sources.
• Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
• Migrated DTS objects to SQL Server Integrated Services (SSIS) environment.
• Designed ETL packages for different data sources (SQL Server, Flat Files, and XMLs etc).
• Managed the entire ETL process involving the access, manipulation, analysis, interpretation and presentation of information from both internal and secondary data sources to customers.
• Created SSIS Packages to import and export data from Excel, Access, SQL Server 2000 and Text files.
• Developed new mappings using Look Up/Aggregation transformations to match the needs of the business case.
• Designed slowly changing dimension transformations (SCD) and customized the existing mappings.
• Built SSIS Packages to transfer data in and out of the Extract, Stage and Production Servers.

ENVIRONMENT:: MS SQL Server 2012/2008R2, 2008/2005 SSIS, SSRS, SSAS, Visual Studio 2010/2008, T- SQL, Windows Server 2008 R2, Visual Source Safe 2005 (VSS), XML, ADO.NET, ERWIN, PL/SQL, MS-Access, MS-Excel

Confidential, Sacramento, CA

SQL Server DBA

RESPONSIBILITIES:

• Served as SQL Server DBA and performed SQL Server installations and configuration tasks, together with SQL patching, migration, monitoring, tuning, database security, backup/restore, and general support tasks for the SQL Server environments.
• Led efforts to develop database designs, and database implementation standards.
• Performed database project tasks, and worked on tickets in support of customer database requests.
• Implemented and provided support for SQL Server Always On Availability Groups (AAG).
• Configured and assigned security for the SQL Server Reporting Services.
• Set up database security and user login permissions per approved end-user requests.
• Set up Linked-Servers, and ODBC connectivity for the SQL Server databases.
• Implemented SQL scripts for improving the performance of the database applications.
• Performed database troubleshooting tasks - monitoring for Blocking Locks, and checking the SQL Server error logs, and the Event logs, together with the Performance counters for issues.
• Create intelligent backup scripts for the backup and refreshing of selected user databases and involved in database builds.
• Database performance tuning.
• Day-to-day management, administration and operation of Team-DM SQL and Reporting Services 2008 and 2008 R2 servers.
• Development of automated daily, weekly and monthly system maintenance tasks such as database backup, replication verification, database integrity verification and in indexing updates.
• Used Microsoft Power BI Power Query to extract data from external sources and modify data to certain format as required in Excel, and created SSIS packages to load excel sheets from PC to database.

ENVIRONMENT:: SQL Server 2008/2005 SSIS, SSRS, SSAS, Visual Studio 2005, Windows Enterprise Server 2003, ADO.NET, Power BI, Team Foundation Server (TFS), XML, HTML, Erwin

Confidential, Jackson, MS

SQL Developer

RESPONSIBILITIES:

• Involved in designing the physical databases model on SQL Server 2005 RDBMS using different Data Definition and Manipulation languages (DML/DDL) implementing constraints and triggers for data integrity in development database for personal banking system.
• Installed SQL Server 2005 with latest Service pack and established connectivity with the database created, configured and maintained database maintenance plans and also database backup and recovery.
• After installing the SQL server 2005, migrated the existing DTS packages into SSIS packages using SSIS services provided by SQL Server 2005 Manager studio.
• Import/Export and successfully migrated the Databases such as DB2 to SQL Server 2000 using DTS.
• Worked on other packages of the SQL server 2005 Edition SSRS (SLQ Server Reporting Services),
• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
• Created and maintained Database Maintenance plans and also created logins and assigned roles and granted permissions to users and groups.
• Designed new dynamic DTS Packages to transfer data between servers, load data into database and tuned the existing packages.
• Worked in creating complex Stored Procedures, DTS packages, triggers, cursors, tables, and views and other SQL joins and statements for applications. Developed complex TSQL code for the application.

ENVIRONMENT:: DB2, SQL Server 20005 Enterprise, Windows Enterprise Server 2003, IIS 6.0, .NET framework, Erwin, Microsoft Visio 2003, SFTP, Microsoft Reporting Service (SSRS).

Confidential

Jr. SQL Server Developer

RESPONSIBILITIES:

• Created new tables, Views, Indexes and user defined functions
• Actively designed the database to fasten certain daily jobs and some stored procedure.
• Designed reports, Graph and deployed reports to web applications using SSRS
• Involved in performance tuning of TSQL queries and Stored Procedures.
• Optimized query performance by creating indexes.
• Use the SQL Analyzer and Profiler for studying the SQL statements and Procedures.
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Migrated SQL server 2000 DTS packages to SQL Server 2005 SSIS packages using SQL Server 2005 Upgrade Advisor.
• Perform SQL Server data loads to support ongoing Team conversion efforts.

ENVIRONMENT:: SQL Server 2000 Enterprise, Windows Enterprise Server 2003, SSRS