SUMMARY

• Enthusiastic, Flexible and Goal oriented team player with more than 7+ years’ experience as a Microsoft SQL server developer.
• Strong experience in developing applications, database solutions and experience on various business domains like Healthcare, finance, retailer.
• Expert in design, developing and deploying the reports using SSRS.
• Experience in report writing using SQL Reporting Services (SSRS) and creating various types of reports like drill down, drill through, table, matrix, charts, and sub reports.
• Designed and implemented parameterized, cascading and conditional reports and expert in developing reports using the data driven subscription and snapshot.
• Experience in creating and maintaining SSIS Package (ETL) to Extract and Transform data from, Flat File or CSV, Excel file to Excel file, multiple Excel files and to load into Staging Database.
• Used execute SQL task, execute package task, execute process task, FTP task, send mail task, web service task, for loop container in control flow.
• Expert in deployment of SSIS package atomized in the multiple environments like file system and SQL server
• Strong experienced in SSIS. Extract Transform Load (ETL) process tools to deploy packages with different data sources and various transformations.
• Experience in creating and deploying SSIS (ETL process) packages using various Transformations such as Multicast, Merge Join, Fuzzy Lookup, Conditional Split, Aggregate, Derived Column, and Data Conversion Transformations.
• Extensively worked on Developing SSAS Cubes and Deploying Processing SSAS objects.
• Designing, develop the BI data models and deploying the cubes in SQL server data tools.
• Defined data warehouse (star and snow flake schema), fact tables, cubes, dimensions, measures using SQL Server Analysis Services (SSAS).
• Excellent experience in installing and designing, maintaining various RDBMS like T - SQL Server 2005/2008/2008 R 2/2012/2014/2016.
• Strong experience on T-SQL objects like tables, indexes, triggers, joins, views, stored procedure with MS SQL 2005/2008/2008 R 2/2012/2014/2016.
• Extensive hands-on Complex Queries, T-SQL Programming, query optimization and performance tuning in working with large databases.
• Excellent communication and inter-personal skills and multitasking analytical thinker with ability to work on fast paced work environment.

TECHNICAL SKILLS

• Microsoft SQL Server 2005/2008/2008 R 2/2012/2014/2016 MySQL
• MS Access
• SQL Server SSRS
• SSIS
• SSAS
• SQL Server Development Tools (SSDT)
• BIDS
• Microsoft SQL Server Management Studio
• SQL Query Analyzer
• SQL Server Profiler
• Eclipse IDE
• Structured Query Language (SQL)
• Transact-SQL
• PL-SQL
• C and C++
• Core Java
• MS Office Suite 2003/2007/2010/2013
• MS Visio
• MS Outlook
• Windows 2008/2003/Window XP/VISTA
• HTML
• XML.

PROFESSIONAL EXPERIENCE

Confidential, Austin TX

BI Developer

Responsibilities:

• Gathered and documented business requirements, security requirements, enterprise data sources and external data feeds.
• Designed and developed the SSIS packages.
• Created SSIS package to load data from Excel File, Flat File to Data warehouse and Report- Data mart using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation and Slowly Changing Dimension
• Performed Data cleansing by creating tables to eliminate the dirty data by using SSIS
• Actively involved in creating Job Alerts, and Job Scheduling for the packages in SSIS
• Designed, deployed, and maintained various SSRS Reports.
• Created various SSRS Reports involving variety of features like matrix, Charts, Gauges, Filters, indicators, Sub-Reports, Drilldown, Drill-Through, Multi-valued parameters etc.
• Involved in designingParameterized Reportsand alsocascaded Parameterized Reports.
• Created reports using stored procedure. Involved in scheduling, creating snapshots and data driven subscriptions for the reports.
• Developed multi-dimensional objects (cubes, dimensions) using SQL Server Analysis Services (SSAS).
• Identified the dimension, fact tables and designed the data warehouse using star schema.
• Writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors and User Defined Functions to implement the business logic.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Optimized queries by looking at Execution Plan for better tuning of the database.

Environment: T-SQL, MS SQL Server 2012/2008R2 SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Service, MS Excel, Windows 2008.

Confidential, Irving, Texas

BI Developer

Responsibilities:

• Involved in gathering the requirements and developed the physical and logical data models.
• Developed DTSX packages to extract, transform and load into database from OLTP database using SQL Server Integration Services (SSIS).
• Created SSIS packages to import and export data from Excel Spreadsheets, Text files, and CSV files.
• Scheduled the SSIS packages through SQL agent jobs.
• Created parameterized reports, cross-tab reports, drill down, reports and summary of reports by using SSRS.
• Created reports from OLAP, sub reports, bar charts, matrix, tabular reports and applied the indicators.
• Used various formatting techniques like interactive sorting, grouping to created user friendly reports.
• Created the security level permission at report server level, folder level and report level and developed an automated report subscription process using SSRS.
• Developed the cubes and designed dimensional modeling using SSAS packages for end user.
• Created hierarchies in dimensional modeling and defined the appropriate measure groups, KPI’s and deployed cubes.
• Created T -SQL functions, cursors, views, indexes, stored procedures, and triggers.
• Used performance monitor and SQL profiler to optimize queries and enhance the performance of the database server.

Environment: MS SQL Server 2012, T-SQL, SSAS, SSRS, SSIS packages, OLAP, OLTP windows 2008.

Confidential - Houston, TX

BI Developer

Responsibilities:

• Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis.
• Created SSIS package for extraction and load data into the Data warehouse and Report-Data mart.
• Responsible for coding SSIS processes to import data into the Data Warehouse from Excel Spreadsheet, Flat Files and OLEDB Sources.
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split,and Send Mail task etc.
• Developed and delivered dynamic reporting solutions using MS SQL Server 2008/2012 Reporting Services (SSRS).
• Generated Drill down, Drill through, Matrix Reports, parameterized reports using SSRS.
• Deployed and scheduled reports using SSRS to generate all daily, weekly, monthly and quarterly reports including current status.
• Retrieve and modify data using SQL Server2008 and SSIS/SSRS from different database and generated different business reports.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization using SQL server profiler.
• Using different databases cross-reference other database with Primary Key, Foreign Key and linking their related knowledge together.

Environment: MS SQL Server 2008, SSIS, SSRS, MS Excel windows XP, MS Excel.

Confidential, Wilmington, Delaware

BI Developer

Responsibilities:

• Created SQL Server Reports using SSRS 2008. Identified the data source and defined them to build the data source views.
• Generated several drill down, drill through, parameterized reports, linked reports, charts, graphs.
• Created reports that call sub reports in SSRS and developed the reports with different properties like chart controls, filters, indicators, interactive sorting.
• Designed the data driven subscription for the report and created report snapshots to improve the performance of SSRS.
• Developed the reports using Reporting services, Report model and ad-hoc reporting using Report builder.
• Created Databases, Tables, Unique/Check Constraints, Views, Stored Procedures, User Defined Functions, Triggers.
• Wrote efficient stored procedures for the optimal performance of the system.
• Monitored performance and optimized SQL queries for maximum efficiency.
• Responsible for Creating and Modifying T-SQL stored procedures/ triggers for validating the integrity of the data.
• Created indexed views and appropriate indexes to reduce the running time for complex queries.

Environment: MS SQL Server Management Studio (SSMS), MS SQL Server 2005/2008/2008 R2, T-SQL, SQL Server Reporting services, MS Excel, windows XP.

Confidential

SQL Server Developer

Responsibilities:

• Interacted with Team and Analysis, Design and Develop database using ER Diagram, Normalization and relational database concept.
• Worked as adeveloperin creating complex Stored Procedures, Functions, Triggers, Cursors, Tables, Views, Indexes andSQLjoins.
• Developed complex T-SQLcode for data retrieval and user defined functions.
• Optimized the query performance with modification in T-SQLqueries, removing unnecessary columns, eliminating redundant and inconsistent data, establishing necessary joins, creating useful clustered index and non-clustered indexes.
• Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler.
• Worked withSQLqueries for data manipulations, Data extraction and Data Mapping. Experience in SQLjoins, sub queries, tracing and performance tuning for better running of queries.
• Worked on existing complexSQL Codes to fix the errors and change the procedures to match the requirements for various business reasons.
• Applying constraints and writing triggers to apply the business rules. Backing Up & Restoring User Databases.
• Prepare detailed statistical in MS Access and MS Excel to track progress of weekly, monthly, and quarterly customers and sales growth.

Environment: SQL server 2005/2008, Query Analyzer, SQL Profiler, MS Excel windows XP.