SUMMARY:

• Over 5 years of SQL Server database and SQL Business Intelligence Development experience in different domains like games an entertainment, financial, healthcare etc.
• Expert in Extraction, Transforming and Loading (ETL) data flows using SSIS; creating mappings/workflows to extract data from SQL Server and Flat File sources and load into various Business Entities.
• Expert in Extracting and Transforming data using DTS, SSIS in SQL Server 2005/2008/2008 R2 and SQL 2012 Data Tools.
• Expert in writing T - SQL, working on DTS, SSIS, SSRS, Data Cleansing and Data Migration.
• Expertise in developing Parameterized, Chart, Graph, Linked, Dashboard, Drill-down and Drill-through reports using SSRS.
• Extensive experience and knowledge in T-SQL - DML, DDL, Transactions, Stored Procedures, Triggers and Functions
• Experience in installation and configuration of MS SQL Server 2005, 2008 and 2008R2 versions
• Hands on experience in troubleshooting database issues, debugging SQL Server stored procedure/triggers and documenting issues/resolutions of SQL Server Applications.
• Knowledge in Performance Tuning, Query Optimization.
• Experienced in OLTP & OLAP environment that includes Production (24x7), QA and development databases in SQL Server
• Expert in creating indexes, Views, complex Stored Procedures, user defined functions, cursors, derived tables, common table expressions (CTEs) and Triggers to facilitate efficient data manipulation and data consistency
• Good hands-on working experience with using all kinds of SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Checks, and Unique), Writing Transact SQL (T-SQL) Queries.
• Knowledge in Tuning SQL queries, T/SQL queries & improving the performance of the Database
• Experience in creating Clustered and Non Clustered indexes on tables
• Good knowledge of System Development Life Cycle (SDLC)
• Knowledge of SQL Profiler for Monitoring and Tuning SQL Server Performance
• Experience in creating Jobs, Sending Alerts using DB Mail
• Extremely attentive, strong team player with ability to take new roles and work in high pressure environments
• Strong analytical and problem-solving skills coupled with excellent written, verbal and inter-personnel communication skills.
• Practical knowledge of writing Oracle Sql script using Oracle SQL Developer.
• Expertise in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) with good knowledge on SQL Server Analysis Services (SSAS) .

TECHNICAL SKILLS:

Databases: MS SQL Server 2016/2012/2008 R 2/2008/2005/2000, MS Access

SQL Server Tools: Management Studio, Business Intelligence Development Studio, Integration Services (SSIS), Reporting Services (SSRS), SQL Profiler, SSAS

BI and Other Tools: Visual Studio 2005/2008, TFS, Oracle SQL Developer,SSAS

Languages: T-SQL,SQL,VB 6.0,C#

Operating Systems: Windows 2008R 2/2008/2003/2000/ NT 4.0,Windows XP/VISTA/7

PROFESSIONAL EXPERIENCE:

Database Developer

Confidential, Addison, TX

Responsibilities:

• Created SSIS packages to Extract, Transform and load data using different transformations such as Lookup, Derived Columns, Condition Split, Aggregate, Pivot Transformation, Merge Join and Union all.
• Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple information sources (CSV, Excel, Text, DB2, MySQL, SQL 2000, SQL 2005 and 2008 and 2012).
• Created Configurations to make package portable and created Event handlers for handling package error.
• Used For-Each Loop Container, Sequence Container, Script task, Expressions, Execute SQL task, Variables, Send Mail Task, Package Execution task to achieve business needs.
• Created and modified various Stored Procedures used in the application using T-SQL.
• Scheduled and maintain packages by daily, weekly and monthly using SQL Server Agent in SSMS.
• Created Project Expense Statements in all Financial Reports using SSRS. Developed yearly and quarterly company expense reports.
• Tuning SQL query for better performance using SQL Profiler.
• Created report for the CP and Campaign team using the SSRS, parameterized procedures and views.
• Practical knowledge of writing Oracle SQL script using Oracle SQL Developer.
• Created multidimensional cubes using SSAS for the reporting purpose.

Environment: MS SQL Server 2008/2012/2014, SSIS, SSRS, SSAS, Windows 2008R2, Dataflaux, SSIS, BCP, SQL-Profiler, TFS (Team Foundation Server)

SQL Server Developer

Confidential, Grapevine, TX

Responsibilities:

• Worked with Business analyst, Data architect and business users to understand business processes, document project requirements and translate them into functional and non-functional specifications for BI reports and applications
• Worked with Business Analysts in gathering and documenting requirements with development perspective.
• Wrote transformations to extract data from multiple homogeneous and heterogeneous information sources (CSV, Excel, SQL 2005 and 2008).
• Created packages in SSIS with error handling as well as created complex SSIS packages using various data transformations like conditional split, lookups, aggregations, expressions, fuzzy look up, for each loop, multi cast, column conversion, fuzzy grouping, script components
• Worked with tabular, matrix, chart reports, drills down reports as well as interactive reports according to business requirements.
• Scheduled and maintain packages by daily, weekly and monthly using SQL Server Agent in SSMS.
• Designed and developed report with running value, interactive sorting as well as conditional formatting.
• Created sub-reports to present more detailed information about the summary.
• Experience on creating SSRS reports using stored procedure. Involved in scheduling, creating snapshot and subscription for the reports and triggers to facilitate consistent data entry into the database.

Environment: Microsoft SQL Server 2005/2008/2008 R2 Enterprise edition SP3, BIDS, SSMS, Windows 2008 Server, Internet Information Server (IIS), Red gate Inc. tools (i.e. Sql compare, Sql data compare), SharePoint, Team Foundation Server(TFS) 2008/2010