\SUMMARY

• Over 6+ years of strong SQL Server developer and Business Intelligence experience.
• Expertise in MS SQL Server 2012/2008R2/2008/2005 and Business Intelligence including SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS)
• Proficient in writing SQL queries, stored procedures, database triggers, exception handlers, SSIS Export & Import.
• Experience in working with SSIS for Data integration services.
• Experience in creating and maintaining Database objects in SQL SERVER 2012/2008 in SQL Server Management Studio.
• Experience in managing Alerts, Operators and Jobs through SQL Server Agent.
• Skilled in writing Transact - SQL in SQL Server Management Studio and Query Analyzer to handle database objects.
• Writing, debugging, and optimizing various complex stored procedures, Views, Triggers, Functions for the mission critical application development.
• Extensive knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, ETL processes, dimensional modeling and reporting tools.
• Experienced in data loads, database integration/conversions, performance tuning and optimization.
• Monitored and Tuned MS SQL Server databases with tools like SQL Profiler and Windows Performance Monitor for optimal Performance.
• Strong Experience in data warehouse requirements gathering, analysis, design, conversion of business requirements into high level functional specifications, design of Star and Snowflake Schema, Business Intelligence Process and data Loading Process.
• Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Points, Logging.
• Experience in migration of Data from Excel, DB2, Flat file, Oracle to MS SQL Server by using BCP and SSIS utility.
• Extensively used various transformations like Conditional Split, Derived Column, Lookup, Sort, Merge Join etc.
• Experience in developing Drill-through, Drill-down, Linked Reports, Chart Report, Sub-Report and Ad-Hoc Reports using SQL Server Reporting Services (SSRS).
• Experience in configuration of report server and report manager scheduling.
• Good understanding of Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report formatting, Report distribution, Report delivery and Report security.
• 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

Database: MS SQL Server 2012/2008/2005, Oracle.

Tools: SQL Server Management Studio (SSMS), Business Intelligence Development Studio (BIDS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Report Builder, MS-Office, Visual Studio 2005/2008, MS Visio, SVN.

Operating Systems: Microsoft Windows XP, Windows 7, UNIX, Linux.

Languages: SQL, T-SQL, PL/SQL, MDX, C, C++, HTML, XML.

Utility: SQL Profiler, Query Analyzer, Windows Performance Monitor.

PROFESSIONAL EXPERIENCE

Confidential, Richardson, TX

MS SQL Server Developer/ SSRS, SSIS

Responsibilities:

• Wrote various T-SQL Stored Procedures that are consumed by SSRS.
• 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.
• Creating functions and developing procedures for implementing application functionality at the database side for performance improvement.
• Loaded data from various data sources like Flat File, Excel File and Oracle
• Used various SSIS tasks such as 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.
• Scheduling Jobs and Alerting using SQL Server Agent
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules.

Environment: MS SQL Server 2012, T-SQL, MS SQL Reporting Services (SSRS), MS SQL Server Integration Services (SSIS)

Confidential, NYC, NY

MS SQL Server Developer/ SSRS Developer

Responsibilities:

• 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 like Lookups, Derived Column, Merge Join, Fuzzy Lookup, For Loop, For Each Loop, Conditional Split, Union all, Script component 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.)
• 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.
• Used Configuration files for changing variables and setting the priority levels for those transcripts based on the level of urgency / requirement.
• Created OLAP models based on Dimensions and Facts for efficient loads of data.
• 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), Business Intelligence Development Studio (BIDS), MS Excel.

Confidential

MS SQL Server Developer

Responsibilities:

• Responsible for getting and understanding the business specifications, preparing technical specifications, DTS Packages.
• Responsible for creating appropriate loaders and relational writes to load the data from SSIS.
• Creating Jobs for scheduling the SSIS packages.
• Getting data from different data sources.
• Using different transformations like excel source, data conversion, lookup, OLEDB command, derived column, OLEDB Destination, etc.
• Loading the data into data warehouse like SQL server.
• Based on the client requirement
• 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.

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 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.