PROFESSIONAL SUMMARY:

• Over 9+ years of IT industry experience with Microsoft SQL Server 2005/2008/R2/2012/2014
• Have been working as MS SQL Application/Data Warehouse developer with experience of 9 years in development, analysis, administration, database migrations, reporting analysis and data base maintenance.
• Expertise in the implementation of MS SQL Server 2000/2005/2008/2012/2014 Infrastructure.
• Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as Data Transformation Service (DTS), SSIS, SSRS, Bulk Insert, BCP, Mirroring and Replication.
• Expertise in using SQL Integration tools with SQL Server 2000, SQL Server 2005 and SQL Server 2008/2012/2014.
• Very strong Transact - SQL Development Skills which includes creating Complex Business Stored Procedures, Tables, CTEs, Cursors, Views, Indexes, Triggers and Functions. Experience in Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous System using SQL tools (SSIS, Bulk Insert, BCP, XML).
• Worked in development environment, with knowledge of Query estimation, Index tuning wizard and database Optimization techniques, OLTP, OLAP, BI data
• Solid experience with creating alerts, schema management, database reorganization, data loading.
• Experience in Importing/Exporting Data from various data sources like other RDBMS, Excel, PDF, XML, Flat files….
• Expertise in generating reports using MS Reporting Services 2008/2005.
• Experience in configuration of report server and report manager scheduling, give permissions to different level of users in SQL Server Reporting Services.
• Extensive work experience on system analysis, design, development, testing and implementation of projects with full SDLC (Software Development Life Cycle).
• Proficient with Management Studio, Enterprise Manager, scheduling regular and on-demand jobs with SQL Server Agent,
• Experience with high availability systems, 500+ GB databases, hundreds of databases in a highly transactional environment with proper data Archive and Purge processes.
• Maintaining sound backup and restoration policies and procedures.
• Development of automated daily, weekly and monthly system maintenance tasks such as database backup, database integrity verification and index updates.
• Implement and maintain database security by creating the Users, Roles and assign privileges required
• Generating reports from Production server whenever required
• Created various types of simple, complex, parameterized reports using SSRS.
• Developed various types of complex reports likeDrill Down,Drill through, Cross tab reports.
• Involved in designingParameterized Reports andReportModelsfor generatingAd-Hocreports as per the client requirements.
• Experience with SSRS Report Server, Report Manager and SSRS deployment Process Working Experience in preparing documentation as per organizational standards, designing, implementing, and maintaining complex database applications in financial environments.
• Monitoring the temp DB full and transactional log full issues. Involved in moving system databases. Reorganize and Rebuilding Indexes for better performance. Maintaining High Availability of Databases using Mirroring concepts.
• Additional Domain knowledge in Health Care and Insurance.
• Expertise in developing and maintaining of processes and associated SQL scripts/tools for automated build, testing and deployment of the products to various developments.
• Excellent communication, presentation, interpersonal skills, strong troubleshooting and organizational skill.

TECHNICAL SKILLS

Operating Systems: Windows 2003 Enterprise Server, XP, 2000, 2008, 2012, Windows XP Professional, UNIX, Linux

Web Servers: IIS, Tomcat and Apache

Programming skills: C, C++, HTML, JavaScript, T-SQL, PL/SQL, Java, C#, ASP, ASP.NET, VB.NET, XML

Databases: MS SQL Server 2000/2005/2008/2012/2014 , Oracle 8i/ 9i, 10g/11g

ETL Tools: Data Transformation Services (DTS), MS SQL Server Integration Services (SSIS), (SSAS), (SSRS), Import Export Data, Bulk Copy Program (BCP), Talend Open Studio

Tools: Used: SQL Enterprise Manager, SQL Server, Management Studio, SQL SERVER Profiler, Query Analyzer, Database Engine Tuning Advisor, SQL, Prompt, Team Viewer, VNC, Power Designer, Spy Schema.

PROFESSIONAL EXPERIENCE:

Confidential, Glendale, CA

SQL Server Developer

Responsibilities:

• Created complex Stored Procedures, triggers, cursors, tables, and views and other SQL joins and statements for applications by using T-SQL.
• Maintained the table performance by normalization, creating indexes and collected statistics by using query optimization, query execution plans, SQL Server Profiler and Database engine tuning Advisor.
• Worked with Technical Architects and Business analysts for the Design of Summary tables required for efficient Report Design.
• Populate or refresh OLAP database for report on dashboard by running ETL automation processes for user acceptance testing and loading history data into OLTP database.
• Developed ETL processes by T-SQL scripts to add the logic to get the related data from the source DB.
• Designed the functional and technical documents, report templates and reporting standards for the developers to work on the report development
• Developed Cubes using SQL Analysis Services (SSAS) and T-SQL, Involved in creating Named calculations and named queries.
• Created Dimensions with the cube wizard and T-SQL programming. Refreshing the cube to get the latest information updated for OLAP databases. Deployment of Cubes to the production server.
• Generation of reports from the cubes by connecting to Analysis server from SSRS.
• Developed the SQL Server Integration Services (SSIS) packages to transform data from SQL 2008 to MS SQL 2014 as well as Created interface stored procedures used in SSIS to load/transform data to the database.
• Scheduled the DTS package for migration data from old system to MS SQL 2014.
• Performed maintenance of Stored Procedures to improve Performance of different front end Applications.
• Worked on T-SQL programming, stored procedures, user-defined functions, cursors, views setup and management of linked servers to Non-SQL-Server databases.
• For the data warehouse Analysis services and develops the different reports for the analysis.
• Extensively involved in the SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Responsible for logical and physical data modeling, database design, star schema, data analysis, programming, documentation and implementation.
• Extracting the data from the different sources (CSV files, oracle, and MS SQL 2000) and stored the data into the intermediate Staging Database using the SSIS ETL tool.
• Transform the data from the staging database and perform the transformation using the Data Flow Tasks
• Operations and perform the Different required transformation in the Staging Database and make the data ready to load in the Data Warehouse Database.
• Experience in Developing and Extending OLAP Cubes, Dimensions and data source view
• Developed complex stored procedure using T-SQL to generate Ad hoc reports using SSRS.
• Scheduled the Reports to run on daily and weekly basis in Report Manager and also email them to director and analysts to review in Excel Sheet.
• Build database queries and test cases for the testing team to test the reports
• Prepared the reports for the day-to-day as well as weekly/monthly purposes in various formats like MS Excel, PDF, HTML, and XML etc.
• Interacted with the business users to gather information about the report.
• Created numerous sub reports, drill down reports as part of the project according to business requirements using Reporting Services (SSRS 2012/2014).
• Designed multiple stored procedures for the Report data sources.
• Created and maintained User’s Security Permissions and Migration of the database objects from one server to another server.
• Worked with plan administrators to research and resolve data issues and troubleshoot system problems/outages.

Environment: MSSQL Server 2012, 2014, SQL Server Integration Services(SSIS), T-SQL, XML, Data Transformation Services (DTS), Win Server 2008, 2012, Unix, Linux, Win XP/NT, MS SQL Reporting Services(SSRS)

Confidential, Redmond, WA

SQL Server Developer

Responsibilities:

• Experienced in Data Extraction, Transforming and Loading (ETL) using various tools such as Data Transformation Service (DTS), SSIS, SSRS, Bulk Insert, BCP, Mirroring and Replication.
• Involved in requirement gathering, analysis, design, development, change management, deployment and user training and worked Data tables and created audit reports using queries. Manually imported data and have good knowledge on business rules.
• Analyzed the mainframe reports for member/eligibility/claims and mapped the fields with FACETS batch jobs and reports. Tested the changes for the front end screens related to following modules.
• Uploaded Letter/Fax Templates to Dev, QA & Prod using Pharmacy Prior Authorization tool by determining Source and Template keys by using SQL queries.
• Used JIRA to capture, organize team’s issues and to follow team activity during QA and Prod Deployment.
• Experienced in loading/updating the Prior Authorization data into Facets. Involved using the Facets UMI Web Service to look for Prior Authorization data for Database applications. Loading ICD-9 and ICD-10 codes from Excel files to SQL Server tables.
• Created numerous sub reports, drill down reports as part of the project according to business requirements using Reporting Services (SSRS 2012). Involved writing UAT scripts for code deployment.
• Designed Data Mapping documents, DDL scripts, Data Dictionary and meta data of the models and maintained them.Created Error and Performance reports on SSIS Packages.
• Developed SQL scripts for administration task.Maintained SQL scripts, indexes, complex queries for data analysis and extraction.Used .NET provider Data Reader Source Task to Read from RDBMS sources.
• Worked in ASP.NET Web forms, State management and Caching feature.Maintained WCF services across the enterprise and integrating UI using MVC pattern.
• Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts.
• Created SSIS packages to extract data from OLTP and transformed to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Created Alerts for successful or unsuccessful completion of Scheduled Jobs.
• Developed SSIS packages for File Transfer from one location to the other using FTP task.
• Developed DTS packages to copy tables, schemas and views and to extract data from Excel and Oracle using SSIS.
• Used ETL to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS.
• Generated ad-hoc reports using Business Object and Crystal reports.
• Created reports using SSRS from OLTP and OLAP data sources and deployed on report server.
• Conducted weekly Crystal Reports training session for the reports team.
• Developed a dashboard solution for analyzing STD statistics by building SSAS 2008 cubes and Tableau.
• Used MS Report Designer to provide a Report Data pane to organize data used in the reports.

Environment: SQL Server 2012, SSRS 2012, SSIS 2012, Excel, T-SQL, Windows 2008/XP, C#, ASP.NET, Visual studio

Confidential, Colleyville, TX

SQL DBA/ Database Developer

Responsibilities:

• Developing and implementing plan for Disaster Recovery.
• Requirement gathering and analyzing data sources. Assisted in design and implementation of Database.
• Created SQL Server Reports using SSRS 2005 in designing stylish report layout parameterized, performance,
• Ad-hoc reports.
• Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables.
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS. Provided Ad-hoc queries and Reports for Companywide users pulling data from Multi-terabyte data warehousing systems.
• Created reports using SSRS from OLTP and OLAP data sources and deployed on report server.
• Experienced in creating SSAS OLAP Cubes and Partitioning Cubes.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Identified Key Performance Indicators (KPI) and Metrics for Business needs in SSAS. Created Multi Dimensional Cubes using SSAS for the Data Warehouse.
• Created Production Deployment Scripts for SSAS Cube & Roles.
• Conducted weekly Crystal Reports training session for the reports team.Used DBCC commands to check physical and logical consistency of the databases and to rebuild indexes.
• Expert in transforming complex business logic into Database design and maintaining it by using SQL tools like Stored Procedures, User Defined Functions, Views, TSQL Scripting.
• Expert in implementing an extra level of security by creating views and creating stored procedures to query the confidential data.
• Used Execution Plan, SQL Profiler and database engine tuning advisor to optimize queries and enhance the Performance of databases.
• Experience in optimizing the database by creating various clustered, non-clustered indexes and indexed views.
• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS)
• Worked with business users to understand metric definitions, presentation, and usage needs.

Environment: Windows 2000 Advanced Server/Server 2003, SQL Server 2005, 2008, MS Access, Enterprise Manager, Management Studio, SQL Profiler, SQL Query Analyzer, ETL, MS SQL Server DTS, Upgrade Advisor, DTS Designer Tools.

Confidential

SQL Developer

Responsibilities:

• Involved in Table Design and creation of indexes.
• Interact with the users to understand requirements and document them.
• Analyzing the system requirements, business logic and specific line of business.
• Responsible for Daily Data Loads using SQL * Loader and Fast Load Script.
• Involved in Tuning of queries to enhance Performance.
• Involved in the Data migration activities to load the Data into different DB Schemas.
• Effectively supporting for decision making throughout the organization.
• Reviewed many T-SQL issues using management studio for better performance.
• Designed and implemented data access stored procedures and triggers for automating tasks.
• Resolved any deadlocks issues with the Databases/Servers on a real-time basis.
• Created many complex Stored Procedures / Functions and used them in to generate reports on the fly.
• Providing consultation on SQL Server to our development teams.
• Optimization of queries for performance issues. Creating users and granting access privileges.
• Endure that the code is written keeping in mind any security issues such as SQL Injection.
• Develop reports in SQL Server Reporting Services.
• Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables.
• Interacted with the business users to gather information about the report.
• Maintained the table performance by normalization, creating indexes and collected statistics by using query optimization, query execution plans, SQL Server Profiler and Database engine tuning Advisor.
• Performed T-SQL tuning and optimization of queries for reports that took longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Generated reports using SSRS which were sent to different Clients.

Environment: SQL Server v7, SQL Server v2008/2008R2 T-SQL, Win NT v4, win 2000, Win 2003, Teradata Sql Assistant

Confidential

SQL DBA/ Database Developer

Responsibilities:

• Creating table, Writing Stored Procedures, Triggers and User Defined Functions for the benefit of users.
• Creating Indexes whenever it is required by analyzing the queries
• Maintain referential integrity, domain integrity and column integrity by using the available options such as constraints etc.
• Reviewed many T-SQL issues using management studio for better performance.
• Identify columns for Primary Keys in all the tables at the design time and create them.
• Create functions to provide custom functionality as per the requirements.
• Be aware of potential blocking, deadlocking and write code to avoid those situations.
• Installed and Configured SQL server 2005 on windows 2003 advance server system.
• Involved in requirement gathering, analysis, design, development, change management, deployment and user training.
• Designed dynamic DTS and SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Created packages using DTS and SSIS for data extraction from Flat Files, Excel Files OLEDB to SQL Server using ETL Tool.
• Created many rich and highly interactive Web forms for user management module using ASP.Net 2.0, VB and HTML.
• Involved in Performance tuning of ETL transformations, data validations and stored procedures.
• Maintained the table performance by normalization, creating indexes and collected statistics by using query optimization, query execution plans, SQL Server Profiler and Database engine tuning Advisor.
• Designing Cubes, Star Schema and Data models for Data Warehousing Applications
• Upgraded MS SQL Server 2000 database to MS SQL Server 2005, by using Detach/Attach, Back up & Recovery.
• Used the Report Manager to create folder structures, modify data sources, controlling access to Report Services ResourcesOptimized query performance by creating indexes.
• Moved the static data from various text files to SQL Server 2005 database using BCP Import and Export, Bulk Insert.Creating users and granting access privileges.
• Write T-SQL statements for retrieval of data and Involved in performance tuning of T-SQL queries and Stored Procedures.
• Provided support to the application developers on the application databases.
• Configured and Deployed different reports in the Servers using SQL Server 2005 Reporting Services.

Environment: MS SQL Server 2005, ASP.Net 3.5, C#.net 3.5, ADO.Net, Business Intelligence Development studio, Microsoft.NET, MS Office Access 2003, MS Office, MS Outlook 2003, VBScript, Tomcat.

Confidential

Information System Engineer

Responsibilities:

• Extract, Transform and Load data to dashboard as Business Intelligence Web applications.
• Create and run ETL as automation tasks.
• Shell scripting use to call ETL automation tasks and refresh ETL tasks.
• Analysis and Design Logical and Physical Data Modeling, import, export, backup, restore, migration... databases.
• SQL Programming as stored procedures, functions, views, triggers, index, constraints, statistics on relational databases.
• Database server administration, query optimization, stored procedure development and performance tuning.
• Create Entity - relationship and Data Flow diagrams will be employed to model new data import in batch scripting scenarios, combined with command-line scripting in order to transfer, validate and import new information.
• Interface with subject matter experts, customer IT departments and business intelligence experts on a daily basis.
• Lead meetings with stakeholders and other technical team members to gather and analyze application requirements for data reporting and parsing system logs.
• Designing large scale data warehouses in the enterprise and implementation in production.

Environment: Microsoft SQL Server 2000,2005, MS Access, Excel, OLTP, OLAP, DML, DDL, Java, JavaScript, JSP, IIS and Tomcat.