SUMMARY

• About 5 years of extensive experience as a SQL developer in SQL server 2008/2008R2/2012.
• Experience with various business domains such as banking, telecommunication and finance.
• Experience in installation, Upgrade and configuration of MS SQL Server database.
• Experience in building recursive queries using Common Table Expressions
• Expertise in RDBMS, tables and relationship, T - SQL queries.
• Experience in data warehouse environments, data marts, dimensional modeling and data mining.
• Expertise in using SQL Server Management Studio with aspects such as query editor, object explorer, Solution explorer and SQL server agent
• Experience in using SQL server configuration tools, Integration service import/export wizard and performance tools (database engine tuning advisor and SQL server profiler).
• Experience in creating tables, stored procedures, views, indexes, joins, cursors and triggers.
• Good understanding of Normalization /De-normalization, Normal Form and database design methodology in order to reduce redundancies in database.
• Experience in installing multiple SQL instances in windows cluster environment.
• Experience in querying and managing XML data.
• Experience in performance tuning and query optimization.
• Experience in migration from SQL Server 2008 R2 to SQL Server 2012.
• Experience in writing MDX queries for multidimensional Analysis.
• Experience in ETL solutions for Data warehousing applications.
• Ability to design and implement data flow, control flow and manage SSIS packages.
• Worked on Microsoft access for database management.
• Hands on experience with Crystal Report and Crystal Analysis
• Experience in creating jobs, SQL Mail, Alerts and schedule SSIS Packages using SQL Server Agent
• Experience in using SSIS Transformations like Conditional Split, Lookup, Merge Join and Sort and Derived Column for validating data.
• Extensive experience in creating several reports such as drill down reports, tabular reports, linked reports, sub reports, Matrix Reports and Chart reports using SSRS
• Experience in creating and configuring data source, dimensions and cubes in 2012/2008 R2/2008 SSAS
• Ability to adapt to the latest technologies with problem solving and data analysis skills.

TECHNICAL SKILLS

Databases: SQL Server 2012/2008R2/2008, MS-Access 2007.

SQL Server Tools: SQL Server Management Studio, Enterprise Manager, Query Analyzer, Database Tuning Engine Advisor, SQL Server Profiler

Languages: C++, C#, T-SQL, XML,SQL, Python

Reporting Tools: MS SQL Server Reporting Services (SSRS), Crystal Reports, Actuate

Data Modeling: Erwin, Logical Modeling, Physical Modeling, Relational Modeling, ER Diagrams, Dimensional Data Modeling

PROFESSIONAL EXPERIENCE

Confidential, Alabama

SQL BI Developer

Responsibilities:

• Developed complex T-SQL queries, user defined functions, stored procedures and triggers.
• Worked on extracting, transforming and loading data using SSIS Import/Export Wizard
• Created SSIS Packages to load Data from Existing Data Model to new Data Model and Data Ware House
• Involved in designing complex packages, moving data from various servers and environments using SSIS which also involved data from XML, Flat Files, CSV Files and SQL Server Databases.
• Created Stored Procedures for report processing
• Created report models for Report Builder and managed reports using Report manager.
• Created master child packages in SSIS.
• Developed a view with a query that joins and aggregates data and created a clustered index on the view.
• Used SQL server data tools to add any missing functionalities.
• Worked with SSIS control flow, data flow and bulk insert tasks.
• Worked with different kinds of transformation such as conditional split, lookup, merge, multicast in SSIS.
• Tuned stored procedures by adding the try catch blocks for error handling.
• Using SSRS 2012 developed tabular reports, sub reports, matrix reports and drill down reports and supported full reporting life cycle.
• Modified report content and created reports using SSRS and scheduled the reports to run on daily/weekly/monthly basis.

Environment: SQL Server 2012, DTS, T-SQL, SSIS, SSAS, SSRS, Erwin, SQL Profiler, SQL Server Migration Assistant-SQL, ASP .net 3.5, SQL server data tools, XML

Confidential, Louisiana

SQL BI Developer

Responsibilities:

• Participated in developing logical model and implementing requirements on SQL Server 2008 R2.
• Created user defined variables in SSIS
• Identified the dimension, fact tables and designed the data warehouse using star schema.
• Worked with different components of SSIS including control flow, data flow, transformations.
• Used Event Handlers for Exception Handling in SSIS packages.
• Used SQL Query Analyzer to view the performance of indexes and tuned SQL queries for data load.
• Migrated data from various file formats such as excel, csv files, access to SQL Server databases using SSIS.
• Created Database Triggers as per the business requirements.
• Created configuration Tables, Stored Procedure, User Defined Function in SQL Server Management Studio to support the whole SSIS process workflow.
• Created report snapshots to improve the performance of SSRS
• Built ad-hoc reports using SQL Server Reporting Services (SSRS)
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS
• Using SSAS 2008 created cubes using cube wizard needed for analysis.
• Created MDX scripts to create datasets including drill down reports and dashboard reports.

Environment: SQL Server 2008R2, BIDS, MS SQL query analyzer, SQL profiler, Report builder 3.0, SQL crystal reports, XML, VBScript, MDX, HTML, DTS, ETL, MS visio, MS Office 2010, Visual Studio 2008, ASP .net 3.5

Confidential, Texas

SQL BI Developer

Responsibilities:

• Involved in requirement gathering and interacted with the end users.
• Migrated data from text based files, excel and access files to SQL server using import/export wizard.
• Developed and optimized database structures, stored procedures, views, triggers, and user-defined functions
• Managed version control and documentation of all SQL Server objects.
• Interact and co-ordinate with end users on their requirements
• Using ETL designed and worked with simple to complex SSIS packages.
• Populated the data warehouse/data-mart facts and dimensions using complex ETL strategies.
• Used For loop containers and for each loop containers to perform tasks in SSIS.
• Using SSRS created various forms of report such as tabular, matrix, charts and graphs.
• Using SSRS implemented report builder to build the report and scheduled to run the reports daily, weekly and monthly basis for investors and managers.
• Using Star Schema and snowflake schema worked on dimensional modeling.
• Troubleshoot system issues, monitored scheduled jobs and set up maintenance plans for proactively monitoring performance of SQL Server databases
• Cleaned-up DTS Packages and other objects in SQL Server Environment.
• Created scripts for Fuzzy lookup and Lookup Transformation to check for duplicate records.
• Created SQL Queries to get results in XML Format.
• Designed and implemented Parameterized and cascading parameterized reports usingSSRS.

Environment: Microsoft SQL Server 2008 R2, Visual Studio 2008, TOAD, T-SQL, BIDS, Erwin, Crystal Reports, VBScript, TFS, MS Visio

Confidential, Louisiana

SQL Developer

Responsibilities:

• Created new database and modified existing database to fit new business requirement by adding tables and relationship.
• Defined check constraints to prevent violation between constraint and data.
• Created new database objects like store procedures, function, triggers using T-SQL.
• Created views for extracting data using T-SQL.
• Involved in performance tuning using indexing (Cluster index, Non cluster index).
• Wrote T-SQL procedures to generate DML scripts.
• Writing complex SQL queries using table joins, temporary tables and table variables.
• Used Migration Wizards like Import and Export Wizard and Migration Wizard.
• Used SQL server agent to schedule jobs and alerting.
• Used SQL Profiler for performance tuning purpose.
• Participated in team meetings to update on weekly and monthly status of project.

Environment: SQL Server 2008, SQL Profiler, SQL server agent, T-SQL, Visual Studio 2008, SSMS 2008, ASP .net3.5, Enterprise manager, Visual studio 2008, MS Visio 2007, DTS, XML, ERwin data modeler

Confidential, Louisiana

SQL Junior Developer

Responsibilities:

• Actively involved with the front end developers for gathering and analyzing the needs of user requirement
• Modified existing database to fit new business requirements by adding tables and relationships.
• Participated in developing logical and physical database development using Erwin.
• Created normalized database structure (3NF).
• Developed and modified scripts for creating objects and fixing data errors.
• Monitored Index Defragmentation both internal and external.
• Created views, stored procedures, index and user defined functions.
• Used joins to get the data across multiple tables using inner joins, cross joins, outer joins.
• Created technical documentations using MS office Visio 2007.
• Worked with variety of file sources such as excel files, flat files and XML files.
• Imported historical data from different data sources such as excel, access to SQL server using SSMS.
• Scheduled database backup and configured the server to automatically send mails to respective customers.
• Worked in Enterprise manager for tasks including job scheduling.
• Attended team meetings to introduce issues to the development team.

Environment: SQL Server 2008, SQL Profiler, SQL Query Analyzer, T-SQL, TFS, Visual Studio 2008, SSMS 2008, ASP .net 3.5, Enterprise manager, Visual studio 2008, MS Visio 2007, DTS, XML, ERwin data modeler 7.2, Windows server 2005