SUMMARY

• Over 7 (Seven) of extensive experience in the IT industry as a MS SQL Developer/BI Developer (SSRS, SSIS) in MS SQL Server 2012/2008R 2/2008/2005/2000
• Extensive experience in using all types of SQL Server Constraints, SQL Server Database design, Database maintenance, developing Transact - SQL queries, stored procedures, and triggers using SQL Servers.
• Excellent noledge in Dimensional Modeling, ER Modeling, Data Marts, Star Schema / Snowflake Schema, FACT and Dimensional tables.
• Expert in creating indexes, Stored Procedures, user defined functions, common table expressions (CTEs) and Triggers to facilitate efficient data manipulation and data consistency.
• Experience across all phases of SDLC from project initiation to post-implementation.
• Expert in developing, deploying packages and extracting data using SSIS from OLTP to OLAP.
• Experience in ETL Processes. Worked extensively on data extraction, cleansing/data integration, and loading from different data source using SSIS.
• Created SSIS Packages using Various Transformation like Lookup, Derived Columns, Condition Split, Data Conversion, Aggregate, Merge Join, Sort, Execute SQL Task, Data Flow Task, and Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Experience in Importing/Exporting Data from various data sources like Excel, XML and Flat file using SSIS utility. Involved in transformation of OLTP data to the Data Warehouse using SSIS and SQL commands.
• Experience in deploying and enhancing the SSIS Packages from development server to production server.
• Experience in Performance Tuning, Query Optimization, Database consistency checks using DBCC utilities. Also, experience in Optimizing MS SQL Query using tools like SQL Server Profiler, Database engine tuning advisor, and Dynamic management views.
• Experienced in creating packages, Jobs, sending alert mails, scheduling reports and running packages, designing, compiling and testing.
• Efficient in generating Tabular, parameterized reports, drill down, drill through, cascading parameterized, and matrix reports using SSRS 2012/2008R2/2005.
• Experienced in using global variables, expressions and functions for the reports.
• Experience in generating on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services (SSRS).
• Experienced in sorting the data, defining data source and subtotals for the reports.
• Proficient in Installation, Configuration and migrating and upgrading of data from MS SQL Server 2000 to 2005 and 2008 to 2008 R2 and 2008r2 to 2012.
• Experienced in Cube designing in Business Intelligence Development Studio to edit various properties of a cube, including the measure, cube dimensions and dimension relationships, calculations.
• Responsible for interacting with the client, understanding their requirements and implementing the necessary changes in the program.
• Excellent communication and inter-personal skills with ability to develop creative solutions for challenging client needs using agile methodologies.

TECHNICAL SKILLS

• MS SQL Server 201 2/2008/2005/2000
• MS SQL Server Integration Service (SSIS)
• MS SQL Server Analysis Services (SSAS)
• MS SQL Server Reporting Service (SSRS)
• T-SQL
• PL-SQL
• SQL Server Management studio (SSMS)
• MS SQL Server Index Tuning Wizard
• SQL Profiler/Analyzer
• Bulk Copy Program (BCP)
• Database Engine Tuning Advisor
• SQL Agent
• Service Manager
• Visual Studio
• C#
• Team Foundation Server(TFS)
• MS Office

PROFESSIONAL EXPERIENCE

Confidential, Englewood, CO

SQL Server BI Developer

Responsibilities:

• Conducted logical and physical database design including data modeling, maintenance, problem diagnosis and resolution. Analyzed business requirements and built logical data models dat describe all the data and relationships between the data.
• Wrote T-SQL, created the stored procedures, triggers, tables to meet the business and audit specifications.
• Generated test data and tested database to meet the functionalities deliverables in the project documentation and specifications.
• Generated parameterized, drilled through and drill down reports using SSRS and deployed the same through report manager.
• Involved in deploying, configuring and managing reports using Report Manager and Report Builder.
• Formatted the reports using the Global variables and expressions.
• Designed and developed different type of reports including: Tabular forms, Matrix (cross Tab report) form, Conditional, List items, Charts and Sub reports, Drill down reports.
• Maintained databases, performed software installations and upgrades, monitored database performance, performed capacity planning, and SQL Server clustering, managed database quality assurance including database consistency check.
• Extracted data from various data source including OLE DB, Excel, flat files and XML in SQL Server 2005/2008 Integration Services (SSIS). Designed and populated the dimension tables with data extracted from various sources. Performed validations and handled the errors. Also performed incremental extractions
• Provided database and Dimensional Data Modeling support to business operational models such as online ordering
• Scheduled the reports to run on a daily and weekly basis in Report Manager and then provided them to the analysts to review in Excel Spread Sheet
• Ensured developers coordinated their efforts in managing and maintaining different application databases
• Troubleshot databases and custom application issues.
• Managed administrative work through automatic script, performing daily/weekly backups.
• Reduced systems downtime risk through automatic offsite backup and recovery over network.
• Monitored strategies, processes and procedures to ensure the data integrity, optimized and reduced data redundancy, maintained the required level of security for all production and test databases.

Environment: SQL Server, Windows, Microsoft Management Studio, Visual Studio, SSIS (SQL Server Integration Services), SSRS (SQL Server Reporting Services), XML, Microsoft Office, Erwin, SQL Profiler

Confidential, Erie, CO

SQL Server BI Developer

Responsibilities:

• Designed and developed ER diagrams (Physical and Logical using MS Visio) and mapping the data into database objects.
• Scheduled the reports to run on a daily and weekly basis in Report Manager and then provided them to the analysts to review in Excel Spread Sheet
• Expertise in developing advanced reports with functions, formulae, parameterized reports, sub reports, summary reports, cross tabs, ranking and conditional formatting.
• Created, insert, update and delete triggers on some tables in order to capture any DML activities happening on some crucial and confidential data.
• Implemented indexes such as clustered index, non-clustered index, covering index appropriately on data structures to achieve faster data retrieval.
• Involved in creating various scripts to load the data to and from production servers to the development servers.
• Designed and developed different type of reports including: Tabular forms, Matrix (cross Tab report) form, Conditional, List items, Charts and Sub reports, Drill down reports.
• Maintained Batch logging, Error logging tables and handled errors using Event handlers.
• Created stored procedures, views, triggers, user defined functions to incorporate the flow of business and called various stored procedures
• Involved in deploying, configuring and managing reports using Report Manager and Report Builder.
• Formatted the reports using the Global variables and expressions.
• Created OLAP models based on Dimension and Facts for efficient loads of data based on Star Schema structure.
• Reviewed and fine-tuned stored procedures and triggers before production migration.
• Improved Performance by creating Clustered and Non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler.

Environment: MS SQL Server, SQL Server Reporting Services (SSRS), SQL Profiler, Query Analyzer, MS Office

Confidential, Springfield, NJ

SQL Server BI Developer

Responsibilities:

• Based on the data models created all the objects in the database including tables, views, keys and constraints
• Generated reports using MS SQL Server Reporting Services 2005/2008
• Used SSRS to create, execute, and deliver tabular, matrix, and charts reports.
• Designed, developed, modified and enhanced the database structures and database objects.
• Created new logical and physical design of database to fit new business requirement and implemented new design into SQL Server 2005.
• Generated various Report models on Views and deployed them on to the production reporting server
• Improved Performance by creating Clustered and Non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler.
• Used complex expressions to Calculate, Group, Filter, Parameterize, and Format the contents of the report according to the requirement.
• Created standard report Subscriptions and Data Driven report Subscriptions
• Transferred data into various formatted files and immediately updated my managers with the automated email systems.
• Tuned several slow running queries in Production. Implemented Indexes and re-indexed to achieve time performance.
• Created, insert, update and delete triggers on some tables in order to capture any DML activities happening on some crucial and confidential data.
• Optimized queries by looking at Execution Plan for better tuning of the database.
• Monitored, optimized and Performance Tuning of Regression Servers using Performance monitor, SQL Profilers, Activity Monitor.
• Tested applications for performance, data integrity, validation issues, job scheduling and alerts.
• Created stored procedures, views, triggers, user defined functions to incorporate the flow of business and called various stored procedures from DTS to make the flow of DTS TEMPeffective.
• Reviewed and fine-tuned stored procedures and triggers before production migration.

Environment: MS SQL Server 2005/2008, SQL Server Reporting Services, SQL Profiler, Query Analyzer, MS Office

Confidential, NYC, NY

SQL BI Developer

Responsibilities:

• Analyzing the business requirements and building logical and physical data models.
• Creating a high level design of the ETL process.
• Implementing RDBMS concepts and good understanding of database schemas.
• Experience in creating and managingstored procedures,indexes, views, UDF’s, Database Constraints to meet business requirements and policies.
• Involved in the improvement of optimized query performance by creating Indexes and implementing SSDS operations.
• Experience in writing SQL Queries for pulling large volume of records from Facets and claims database using stored procedures, and Extraction Transformation and Loading (ETL) process using SSIS.
• Created packages by testing and cleaning the Standardized Data by using tools in Data Flow Transformations (Data Conversion, Export Column, Merge join, Sort, Union all, Conditional Split and more) for existing/new packages and huge CSV, XML file import from different data sources and other ongoing tasks for mapping.
• Extensively designed the packages and Data Mapping using Control flow task, Sequence container task, Data Flow Task, Execute SQL Task, Data conversion task, Derived Column task and Script Task in SSIS Designer.
• Designed the packages extensively to implement in multiple environments easily using configuration
• Automated various processes by scheduling the packages using SSMS Scheduler and third party tools.
• Experience in Handling Transactional systems for performing various automated processes.
• Experience in extracting the data from SQL Server and using XML and present it to the end user in XML format.
• Experience in working on different kinds of reports Parameterized Reports, Linked Reports, CrossTab Reports, Mailing Label Reports and Ad hoc reports.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Experience in writing Excel macro’s using VBA and delivering Excel reports to the Business analysts.
• Responsible for unit testing, Smoke Testing and creating design documents and uploading it to share point server.
• Excellent verbal and communication skills include interacting with users for requirement gathering and problem solving skills.

Environment: MS-SQL Server 2012/2008 R2/2008 Enterprise Manager, MS Business intelligence (BIDS) SSIS, SSRS, SSAS, MS Visual Studio 2010\2008, SharePoint Server 2010, MS Visio 2010, MS-Office 2010, XML, Windows Server 2008, TFS 2010

Confidential

SQL Server Developer

Responsibilities:

• Experienced in rebuilding and transferring new database
• Created Database Maintenance Plans for the performance of SQL Server which covers Database Integrity checks, update database Statistics and Re-indexing.
• Managed database security and implemented encryption/compression for sensitive data in the database
• Troubleshoot Third party Data migration, DTS, Backups andrestore, tune up systems, upgrade.
• Performed Database Search and Query Strategy design, implementation and testing.
• Performed Stored Procedures development and testing, as well as Database Report design and implementation
• Exported data in Excel to SQL Server 2000 via DTS.
• Run daily, weekly and monthly reports for management consumption.
• Involved in troubleshooting and fine-tuning of databases for its performance.
• Identified, tested and resolved database performance issues.
• Worked with Application Developers to design databases and tables to support Development activities and achieve optimal efficiency.
• Nightly jobs to load data fromstaging database to the OLAP database.

Environment: SQL Server, Windows 2000/2003, Enterprise Manager, DTS Import/Export, Profiler, Excel, Query Analyzer Windows NT/2000 Server &professional.