SUMMARY

• Over 6+ years of strong SQL Server developer and Business Intelligence experience.
• Experience in Telecom, Banking domains with expertise in MS SQL Server 2012/2008/2005 /2000 suite of products like SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS).
• Proficient in writing stored procedures, Views, Indexes and effective User Defined functions and appropriate Triggers to facilitate data manipulation using T - SQL.
• Experience with Data Transformation Services (DTS) an Extract Transform Load (ETL) tool of SQL Server to populate data from various data sources by creating packages for different data loading operations for each application.
• Extensively worked on SSIS Control Flow Tasks such as for each Loop Container, For Loop Container, Data Flow Task, File System Task, Script Task, Execute SQL Task, FTP Task, and Send Mail Task.
• Experience in Huge Data Migrations, using SSIS, Bulk Copy Program (BCP) and Bulk Insert (BI).
• Expert in using Data flow transformations like OLEDB command, derived column, conditional split, script component task, audit, lookup, merge join, sort and union all.
• Experience in Error and Event Handling: Event Handler, Precedence Constraints, Break Points, Check Points, Logging.
• Strong Experience in data warehouse requirements gathering, analysis, design, conversion of business requirements into high level functional specifications, design of Star Schema and Snowflake Schema.
• Designed, Build the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS).
• Expert in calculating measures and dimension members using multi-dimensional expression (MDX) in SSAS
• Expert in designing Enterprise reports using SQL Server Reporting Services and Excel Pivot table based on OLAP cubes.
• Expert level skills in Data Modeling, Normalization, Optimization and Performance Tuning.
• Monitored and Tuned MS SQL Server databases with tools like SQL Profiler and Windows Performance Monitor for optimal Performance.
• Experienced in designing and developing Drill-through, Drill-down, Linked Reports, Chart Report, Sub-Report and Ad-Hoc Reports using SQL Server Reporting Services (SSRS).
• Knowledge of Software Development Life Cycle (SDLC).
• Self-motivated and also worked in a technically challenging environment.
• Excellent communication, interpersonal and analytical skills.

TECHNICAL SKILLS

Databases: MS SQL Server 2012/2008/2005 , Oracle, MS Access, MS Excel.

ETL Tools: SQL Server Integration Services (SSIS)

Reporting Tools: SQL Server Reporting Services (SSRS)

Analysis Tools: SQL Server Analysis Services (SSAS)

Database Utilities: Enterprise Manager, SQL Profiler, SQL Query Analyzer, DTS import/ExportBIDS, SQL Agents, SQL Jobs, TFS, SVN

Data Modeling: ER-Win v 4.0., Microsoft Visio.

Languages: SQL, T-SQL, C, C++, VB.NET, C#.

Operating Systems: Win 2003, Win NT, Win XP, Win 7, UNIX, Linux.

Other Tools: Microsoft Visual Studio 2008/2005/2003

Network Topologies: TCP/IP, SNMP, FTP, RDP, SMTP

PROFESSIONAL EXPERIENCE

Confidential, Richardson, TX

MS SQL Server Developer/ SSRS, SSIS, SSAS

Responsibilities:

• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules.
• Comprehensively worked on SQL scripts using local and Global Temp Tables, Variables and Table Variables, Common Table Expressions (CTE).
• Created complex stored procedures and user defined functions, designed many reports using MDX and T-SQL queries.
• Designed parameterized reports inclusive of complex default parameters and cascading parameters.
• Included Report Design and Coding for Standard Tabular type reports, including Drill Down and Drill through functionality and Graphical presentations such as Charts and Dashboard type metrics for effective analysis.
• Designed and implemented reports with different layouts using SSRS and exported them into Excel, PDF and HTML
• Generated reports that exported report headers/parameter info to the header section of Excel to eliminate cell merging.
• Performed Report Testing and Verification as per Internal Reporting system requirements.
• Designed the Security for the reports in the report manager
• Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard for managerial purposes.
• Identified and defined the datasets for Report generation.
• Designed and developed database models with MS Visio.
• Loaded data from various data sources like Flat File, Excel File and Oracle
• Used various SSIS tasks such as FTP, Script, Conditional Split, Derived Column, Lookup, Slowly Changing Dimension, Sort, Merge Join etc., which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Worked on SSIS performance tuning using error handling, event handling, re-running of failed SSIS packages using checkpoints.
• Strong understanding in the principles of Data ware housing using Fact Tables, Dimension Tables, star schema modeling and snowflake schema modeling, Slowly changing dimensions
• Created and Configured OLAP Cubes using SSAS.
• Created dimensions, measures, measure groups, key performance indicators (KPI), perspectives, partition aggregations and deployment
• Scheduling Jobs and Alerting using SQL Server Agent

Environment: MS SQL Server 2012, T-SQL, MS SQL Reporting Services (SSRS), MS SQL Server Integration Services (SSIS), MS SQL Server Analysis Services (SSAS), C#, MS Excel.

Confidential, NYC, NY

MS SQL Server Developer/ SSRS Developer

Responsibilities:

• Involved in full Software development life-cycle (SDLC) followed by Agile methodologies to produce high quality software model
• Created ETL packages using Heterogeneous data sources (SQL Server, ORACLE, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing different kinds of transformations using SSIS.
• Used different Transformations and Tasks like Lookups, Derived Column, Merge Join, Fuzzy Lookup, For Loop, For Each Loop, Conditional Split, Union all, Data Flow task, FTP Task, Execute SQL Task, Script component Task and etc.
• Used Event Handlers for Custom Logging using Complex Store Procedures for various events (On warning, On Pre and Post Execution, On Task Failed etc.)
• Responsible for Deploying the SSIS packages and scheduling the package through Jobs in all Tiers including Dev, UAT and Prod, Setting the Configuration files which is done in the specified tables and created technical specs documents for all the enhancements
• Developed the packages with monitoring features and logging so that audit information of the packages and their execution results are loaded in to the audit table.
• Created OLAP models based on Dimensions and Facts for efficient loads of data.
• Responsible for writing MDX and T-SQL queries to generate reports using SQL Server 2008 Reporting Services (SSRS) and deployed those reports in share point.
• Implemented the complex query techniques of Passing Multi-Valued Parameters and cascading parameters in MDX.
• Created reports using stored procedure and Experience in building Reports on Analysis Services cubes (SSAS).
• Generated database monitoring and data validation reports in SQL Server Reporting Service (SSRS).
• Worked with Report Builder, Report Models and Ad Hoc Reports.
• Scheduled the reports to refresh and run on daily, weekly and monthly basis in the report manager.
• Identified and defined the datasets for Report generation.
• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel format using Reporting Services

Environment: MS SQL Server 2008R2/2012, T-SQL, SQL Server Integration Services (SSIS), SQL Server Data Tools, SQL Server Reporting Services (SSRS 2008), SQL Server Analysis Services (SSAS), Business Intelligence Development Studio (BIDS), MS Excel, Agile, Share Point, .Net Framework 3.5, C#.

Confidential

MS SQL Server Developer

Responsibilities:

• Involved in Migration of SQL Server 2005 to SQL Server 2008
• Responsible for getting and understanding the business specifications, preparing technical specifications, DTS Packages
• Wrote several complex T-SQL queries and stored procedures that are used in the reports.
• Worked with the end users to ensure that the reports are working as per the Business requirements specified
• Managed reports using Report Manager and deployed reports using SSRS
• Responsible for creating appropriate loaders and relational writes to load the data from SSIS.
• Responsible Creating Jobs for scheduling the SSIS packages.
• Loaded data from different data sources to data warehouse using SSIS.
• Using different transformations like excel source, data conversion, lookup, OLEDB command, derived column, OLEDB Destination, etc.
• Based on the client requirement we generate multiple reports using SSRS.

Environment: Data Transformation Services (DTS), SQL Server integration Services (SSIS), SQL Reporting Services (SSRS), SQL Server 2005/2008.

Confidential

MS SQL Server Developer

Responsibilities:

• Actively participated in gathering business requirements and system specifications.
• Created new databases, tables and established relationships between the tables in the database.
• Created efficient stored procedures and functions to support organized data storage and manipulation.
• Created views to display required information on user interface and trigger to validate consistent data entry into the database.
• Extensively involved in writing stored procedures, triggers, common table expressions and functions based on client requirement.
• Used BCP utility to publish table output to text files.
• Identified, tested and resolved database performance issues like monitoring and tuning to ensure database optimization
• Maintained SQL scripts for changes in database objects.
• Involved in running trace from the SQL profiler to troubleshoot database and used DBCC check commands to check the consistency of the database.
• Provided support for database backup/restore and database transfer activity from test environment to production environment.
• Set up SQL mail and created jobs to automate and schedule many tasks.
• Involved in coordinating post-implementation events such as testing.

Environment: SQL Server 2005, T-SQL, MS Access, Visual Basic 6.0, Enterprise Manager.