SUMMARY

• Over 8 Years of working experience as SQL Server Database developer in various domains
• Comprehensive knowledge and exposure to different phases of Software Development Life Cycle (SDLC).
• Master in T - SQL Programming, SQL stack including SSIS, SSRS and SSAS.
• Experienced in RDBMS concepts, DDL, DML, constructing normalized and de-normalized tables, user defined functions, complex and dynamic stored procedures, views, triggers, synonyms, cursors and Indexes.
• Expertise working on Online Transaction Processing (OLTP), Data Warehousing and Online Analytical Processing (OLAP) environments.
• Designed SQL Server database objects (tables, stored procedures, functions and views) to support outsourcing data integration (SSIS), analysis, and various business processes.
• Experience in Importing/Exporting Data from various data sources like MS Access, Excel Files, Oracle, DB2, XML Files and Flat Files using DTS utility. Involved in ETL transformation of OLTP data to the Data Warehouse implementing all transformations using SSIS and SQL commands.
• Hands on experience on parsing XML files to SQL Server tables using Open XML commands.
• Mastery in migrating DTS packages, deploying and scheduling SSIS packages as jobs using SSIS 2005/2008 as batch process.
• Experience in installing, configuring, developing and deploying reports using SQL Server Reporting Services (SSRS). Created various reports like table, matrix and chart formats.
• Extensive work experience in development of SSRS, Power Pivot Reports.
• Expert in Ad-hoc reports, drill down and drill through reports and cross tab reports.
• Expert in T-SQL coding, testing functions, ad-hoc SQL queries, views, triggers, cursors, data types, indexes, and system tables.
• Experience in Created and managed Interactivity to reports by using Reporting Service SSRS.
• Experience in configuration of report server and report manager scheduling, give permissions to different level of users of financial and banking in SQL Server Reporting Services (SSRS).
• Experience in designing Star Schema and Snowflake Schema with Facts, Dimensions, Measures and Cubes using SSAS for enterprise and insurance domains.
• Modified existing OLAP cube to extract historical data to support healthcare cost utilization analysis and actuarial reporting (SSRS).
• Strong knowledge in reporting implementation of Crystal Reports/Webi Reports/ SQL server Reporting Services SSRS and SQL server Analysis Services (SSAS).
• Involved in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other tasks using SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands.
• Tuning poorly performing queries, long running queries by capturing the events through Profiler.
• Knowledge of high availability SQL Server solutions, including Log shipping, Replication and SQL Server clustering.
• Experience in the Installation, Registration, Configuration, Database Backup/Recovery and Disaster Recovery procedures for MS Server 2000/2005/2008/2208 R2/2012
• Experience in ASP.NET coding.
• Designed and documented reporting and information management strategies for various industrial, financial, healthcare and insurance domains.
• TEMPEffective working as individual or as a cooperative team member with good communication and interpersonal skills.

TECHNICAL SKILLS

Operating System: Windows NT 4.0, Windows 2000 Enterprise/Advanced Server, Windows Server 2003, XP Professional, Windows 7, UNIX

Databases: MS SQL Server 2008 R 2/2008/2005/2000 , MS Access, Oracle 9i

Programming Languages: SQL, T-SQL, PL/SQL, MDX, C

Business Tools: Word, Excel, PowerPoint, Access, Visio, Outlook

Database Tools: SQL Server Enterprise Manager, SQL Query Analyzer, SQL Profiler, SQL Alerts, Index Tuning Wizard, BCP, DTS, Import/Export Wizard, SQL Mail, SQL Server Management Studio, SSIS 2008/2005, SSRS 2008/2005,Power Pivot, Index Analyzer, SQL Client Utility

PROFESSIONAL EXPERIENCE

Confidential, LA

MS SQL Server Developer

Responsibilities:

• Actively participated in interaction with users, team lead, DBA’s and technical manager to fully understand the requirements of the system.
• Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source (Oracle), Excel Spreadsheet to SQL Server 2008R2
• Created SSIS log files and configuration files to store configuration and to log execution of packages.
• Involving in developing Data models, Data dictionaries, mapping documents and cross functional documents across systems for all the ETL needs.
• Reviewed, developed and designed data models, in conjunction with the application development team.
• Used Sybase Power Designer as a Data Modeling tool.
• Created and maintained the Data Model repository as per company standards.
• Developed various T-SQL stored procedures, triggers, views, and adding/changing tables for data extraction, data loads and transformations.
• Created various database objects such as tables, indexes and views based on the requirements.
• Created ETL packages with different data sources (Flat Files, Excel source files, XML files etc) and tan loaded the data into destination tables by performing different kinds of transformations using SSIS Developed the packages with monitoring features and logging so dat audit information of the packages and their execution results are loaded in to the audit table.
• Done performance tuning of complex queries and also the SSIS packages.
• Create scripts for the scheduled Execution of the SSIS packages.
• Design, program, and implement software packages customized to meet business needs
• Review and repair software packages to ensure technical accuracy & reliability of programs
• Generated Reports using Global Variables, Expressions and Functions for the reports using SSRS.
• Developed Query for generating drill down reports in SSRS. Prepared AD HOC reports through report builders.
• Automate Reports using procedures, triggers, functions on RDBMS
• Assisted in providing production support for SQL server or SSIS technical issues.
• Assisted and worked along with ETL team working on Implementing the Extract, Transform and Load (ETL) data to the different fact tables and the Slowly Changing Dimensions logic in SAP BO Data Services.
• Provide and knowledge transfer to internal staffs.

Environment: SQL Server 2008R2/2012, SSRS, SSAS, SSIS, Oracle, MS Access, Excel, Windows Server 2008, VSS, ERWIN, Microsoft Visual Studio, Power Pivot,MS Visio, MS Integration, Analysis and Reporting Services, Management Studio

Confidential, Atlanta, GA

MS SQL Server /BI Developer

Responsibilities:

• Implemented triggers and stored procedures and enforced business rules via checks and constraints.
• Created indexes on selective columns to speed up queries and analysis in SQL Server Management Studio.
• Worked on querying data and creating on-demand reports using Report Builder in SSRS reports and send the reports via email.
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
• Created Cross-Tab, Drill-down and Sub-Reports using RDL. Promoted RDLs to Reporting Service Server.
• Developed Power Pivot Dashboards by writing Complex queries as per the requirement.
• Built efficient SSIS packages for processing fact and dimension tables with complex transformations and type 1 and type 2 changes.
• Defined the logging process for all the packages, populated it with entries like inserted record, updated record and error record.
• Created SSIS Packages usingcontrol flow transformationto generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Performed data transfers using BCP and BULK INSERT utilities. Was involved in the design and implementation of Disaster Recovery.
• Involved in Data migration (import & export - BCP) from Text to SQL Server. Used scripts and variables, email notifications for ETL process using Data Integrator in SSIS, SSAS.
• Created jobs, alerts to run SSAS, SSRS packages periodically. Created the automated processes for the activities such as database backup processes and SSAS, SSRS Packages run sequentially using SQL Server Agent job.
• Created and Designed Data Source and Data Source Views Using SQL Server Analysis Services (SSAS).
• Involved in Cube Partitioning, Refresh strategy and planning and Dimensional data modeling in Analysis Services (SSAS).
• Implemented the error threshold using precedence constraints and variables in SSIS packages using business rules as .
• Involved in managing developers, advising other groups in organization on SSIS development, data warehouse development, and ETL development best practices.
• Created an automated ETL summary report which consists of the summary information for all the loading activities done each day and month.

Environment: Microsoft SQL Server 2008, SSIS, SSRS,SSAS,BIDS, Power Pivot,DTS, SQL Profiler, MS Access, ODBC, Oracle 10g, Microsoft Visio, TFS, Erwin, MS Office.

Confidential, OHIO

MS SQL Server Developer

Responsibilities:

• SSIS (SQL Server Integration Services)
• Designed and developed ETL process for extracting data flat file to SQL server 2005 using SSIS.
• Developed transformation services to bring the data into SQL server
• Extracted data from heterogeneous data source to SQL server database.
• Populating the data from OLTP process to data mart and data warehouse.
• Created lookup table to the data before loading to the target system.
• Involved in cleansing on the data.
• Created packages to use the same functionality in different servers.
• Created workflow (Control flow) to link the series of operations.
• Schedule the workflow to run the process.
• SSRS (SQL Server Reporting Services)
• Created interactive, graphical and free-form reports using XML/relational database sources
• Design the report layout, creating the report dataset and publish the reports to report server/SharePoint server.
• Worked on the report builder 2.0 to handle the complex reports such as free-form and tabular reports.
• Provided the option to export the reports in .pdf, .xml, .html and .csv format.
• Provided options to print the reports online with the preferred format available with the printer.
• Extensively worked on developing Power Pivot Dashboards by writing Complex queries as per the requirement.
• Worked on designing and developing Stored Procedures, Functions and triggers using T- SQL.
• Fine tuned database queries.
• Worked on Factory SQL to trigger the bits from PLC in to the database.

Environment: Microsoft SQL Server 2008, SSIS, SSRS,SSAS,BIDS, DTS, SQL Profiler, MS Access, ODBC, Power Pivot,Oracle 10g, Microsoft Visio, TFS, Erwin, MS Office.

Confidential, Dallas, TX

MS SQL Server Developer

Responsibilities:

• Gatheird business requirements, definition and design of the data sourcing and data flows, data quality analysis, working in conjunction with the data warehouse architect on the development of logical data models.
• Installed and configured MS SQL Server 2005 along with Visual Studio on a network domain system.
• Created logical and physical data models using Erwin for new requirements after discussion with technical team and application users.
• Designed and implemented complex SSIS package to migrate data from multiple data sources for data analyzing, deploying and dynamic configuring of SSIS packages.
• Created OLAP cubes and dimensions for the analysis of student’s registrations in specific areas using SSAS.
• Developed and maintained a combined data store for reporting purposes.
• Generated reports using Global Variables, Expressions and Functions using MS SQL Server Reporting Services 2005.
• Identified the database tables for defining the queries and defined datasets for report generation.
• Defined report layouts including report parameters and wrote queries for drill down reports using SSRS 2005.
• Created parameterized, drill down and aggregation reports in MS SQL environment using SSRS 2005.
• Generated daily, weekly and monthly reports for the managers.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2005.
• Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Extensively used performance monitor/SQL profiler to solve dead locks/long running queries.
• Tested the reports and fixed bugs in the stored procedures.
• Responsible for the Performance tuning of the SQL Commands and the troubleshooting of the technical problems in MS SQL Server 2005 with the use of the Query Analyzer and Database Engine Tuning Wizard.
• Established backup and recovery of MS SQL server 2005 by using SQL Server Agent Jobs for periodic Backups with backup devices, database maintenance plans and recovery.
• Used Visual Source Safe (VSS) for version control.

Experience: MS SQL Server 2005, SSAS 2005, SSRS 2005, SSIS 2005, T-SQL, Visual studio 2005, DTS, Data Analyzer, MS Access, Excel, SQL Profiler, Windows XP, Erwin v4.2, VSS 2005

Confidential

MS SQL Server Developer

Responsibilities:

• Verified the databases for data entry errors
• Created and managed schema objects such as Tables, Views, Indexes and Stored Procedures
• Created database triggers in T-SQL to check the referential integrity of the database
• Worked with the developing team in the writing functions in Visual Basic 6.0 for Upload and download functionality, Data transfer and migration
• Transformed data from one server to other servers using data transformation services (DTS)
• Developed SQL queries to fetch complex data from different tables in remote databases using joins
• Actively involved in Normalization & De-normalization of databases
• Managed version control and documentation of all SQL Server objects
• Creation, manipulation and supporting the SQL Server databases.
• Involved in the Data modeling, Physical and Logical Design of Database
• Created tables, indexes, sequences, constraints, triggers and procedures.
• Stored procedures and triggers were used to implement business rules.
• Helped in integration of the front end with the SQL Server backend.
• Used DDL and DML for writing triggers, stored procedures and data manipulation.
• Import & Export of data from one server to other servers using tools like Data Transformation Services (DTS).
• Write T-SQL statements for retrieval of data and involved in performance tuning of TSQL queries.
• Managed rollback segments, and table spaces to ensure less space used by the database.
• Created documentation on the all the tables, stored procedures, views and user defined functions.

Environment: SQL Server 2000/2005, SQL Profiler, T-SQL, Windows 2003, MS Access, Visual Studio.