SUMMARY

• 7+ plus years of professional experience in the IT industry as a MS SQL/BI Developer.
• Highly proficient in the use of T - SQL for developing and debugging complex stored procedures, triggers, tables, user functions, user profiles, relational database models and data integrity, SQL joins and query writing.
• Proven ability in Performance Tuning, Query Optimization and running Database.
• Experience in MS SQL Server 2005/2008, SSRS, SSAS, SSIS packages.
• Profound knowledge and ability to write stored procedures, temporary tables, views, indexes, triggers when required and complex queries including correlated queries and queries with complex joins and aggregate functions. Expertise with DDL and DML statements, RDBMS’s, data dictionaries and normal forms.
• Proficiency and Expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.
• Worked on administration tasks such as data loading, batch jobs, configuring IIS, data uploading, backup & recovery, Database mirroring, Log shipping, user and application table management, upgrades, creating database partitioning, databases/file groups/files/transaction logs.
• Experience in query optimization (SQL tuning) using SQL Profiler, Database Tuning Advisor (DTA), Index tuning wizard and Performance monitor for performance tuning.
• Experience in building Data Integration, Workflow Solutions and Extract, Transform, and Load (ETL)solutions for data warehousing using SQL Server Integration Service (SSIS)
• Developed ETL process using SSIS with various control flow, data flow tasks and store procedures for work order validation process.
• Experience in providing Logging, Error handling by using Event Handler, and Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Experience in creating jobs, SQL Mail, Alerts and schedule SSIS Packages using SQL Server Agent.
• Creating SSIS Packages and involved in Package configurations and deployments between Development and QA and Production servers.
• Extensive experience in report generation using SQL Server Reporting Services (SSRS) from both relational databases and OLAP cubes.
• Expert in designing and generating reports using SQL Server Reporting Services (SSRS) and Excel Pivot table based on OLAP cubes which make use of multiple value selection in parameters pick list, matrix, dynamic reports and other features of reporting service.
• Good understanding of Microsoft Reporting Service(SSRS) with Report authoring, Report management, Report delivery and Report security.
• Hands on experience in developing Custom Reports and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Expert in creating parameterized reports, Drill down, Drill through, Sub reports, Linked reports, Snapshot, Cached, Adhoc reports using SSRS.
• Expert in writing MDX queries with extensive experience in creating and customizing Cubes using SQL Server Analysis Services (SSAS) 2005/2008.
• Experienced in working with Star Schema modeling to develop ROLAP/MOLAP Cubes using SQL Server 2005/2008 Analysis Services.
• Experience in Cube designing in Business Intelligence Development Studio using SSAS.
• Strong experience in defining Referenced relationships in SSAS.
• Experience in Application Development Analysis, Requirement Analysis, Scoping, Developing, Debugging, Testing and Documentation of various phases in a project life cycle of Client/Server Applications.
• Good knowledge of Computer Science theory & strong in modern programming languages.
• Manage multiple tasks and responsibilities in high-pressure environments.
• Track record of taking projects to successful completion.
• Excellent analytical, problem solving skills and a team worker with a strong customer focus.

TECHNICAL SKILLS

SQL Server/BI Tools: SQL Profiler, Query Analyzer, BIDS, Export & Import (DTS), SQL Server Reporting Services (SSRS), SQL Server Integrating Services (SSIS), SQL Server Analysis Services (SSAS)

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

Languages: C, T-SQL, Visual Basic 6.0

Tools: Visual Studio 2005/2008/2010 , Erwin 7.2

Application Packages: MS Office, MOSS 2007, PPS 2007

Operating Systems: Windows 2000/NT/XP, UNIX, Windows Server 2003

Architecture: RDBMS, OLAP, OLTP

PROFESSIONAL EXPERIENCE

Confidential, MD

Sr. SQL/BI Developer

Responsibilities:

• Developed SSIS packages to Extract, Transform and Load (ETL) data into the data warehouse database from heterogeneous sources.
• Used various transforms in SSIS to load data from flat files andExcel files to the SQL databases.
• Developed and maintained critical applications for sales auditing team by balancing sales and settlements of credit amounts with the bank on a day to day basis.
• Wrote stored procedures and User Define scalar Functions (UDFs) to be used in the SSIS packages and SQL scripts and SSRS reports.
• Created packages with different control flow options and data flow transformations such as Conditional Split, Multicast, Union all and Derived Column etc.
• Created SSIS packages for File Transfer from one location to the other using FTP task with MasterSSIS Package to run all other packages.
• Implemented database standards and naming convention for the database objects and documentation of all the processes involved in maintaining the database for future reference.
• Used Bulk Copy program (BCP) to import and export large amounts of data in and out of SQL Server databases.
• Designed and built Star and Snowflake dimensional models creating facts, dimensions, measures, cube and established data granularity.
• Worked on multidimensional data modeling.
• Involved in Analyzing, designing, building & testing of OLAP cubes with SSAS and in adding calculations using MDX.
• Involved in SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL
• Participated in Databases Architecture and data modeling design.
• Reviewed and developed data models and database designs with development teams
• Created Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Monitoring Performance of SQL server using SQL Profiler, Query Analyzer, Database Engine Tuning Advisor (DTA) and Performance monitoring.
• Developed various types of reports like Drill down, Drill through and parameterized reports using SQL Server Reporting Services 2008 R2.
• Inspected the reports and fixed bugs in stored procedures and also tuned Reporting Services to the T-SQL.
• Worked on Change Management Cases to resolve the production change request issues based on the Specifications provided.
• Worked on call support to resolve issues whenever needed.
• Worked on Agile Methodology and Microsoft Team Foundation Server (TFS)

Environment: SQL Server 2008R2 & 2012 Enterprise Edition, SQL, T-SQL, MS Access, MS Excel,& Windows 2003 server, Business Intelligent technologies like SSIS,SSRS,SSAS.

Confidential - Mason, OH

SQL/BI Consultant

Responsibilities:

• Developed SSIS Packages to extract data from various data sources such as MS Access, Excel and flat files into SQL server 2008 using different transformations, Derived column, Sort, Row count.
• Developed, deployed and monitored SSIS Packages.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Made SSIS packages parameterized using Configuration files.
• Experience with SSIS performance tuning using counters, error handling, event handling, re-running of failed SSIS packages using checkpoints.
• Created SSIS packages for data Importing, Cleansing, and Parsing etc. Extracted, cleaned and validated.
• Used efficient task objects/connections/work flows in packages based on data volumes and data sources.
• Studied the existing OLTP system(s) and Created facts, dimensions and Star Schema representation for the data mart.
• Responsible for identifying and defining Data Source and Data Source views.
• Created cubes and defined the dimensions.
• Optimized cubes for better query performance.
• Created and integrated User defined functions and stored procedures for reporting purposes.
• Generated reports dat can handle dynamic grouping and dynamic sorting.
• Used SQL Server Profiler to tune the performance of the stored procedures and functions to improve the report generation time.
• Defined relationships between Dimensions and Measure groups.
• Expert in calculating measures and dimension members using mathematical formulas, and user-defined functions.
• Created Cross-Tab, Drill-down, Drill-through and Sub drill down reports -Report using RDL. Promoted RDLs to Reporting Service Server.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Generated reports using SQL Server Reporting Services 2005/2008 from OLTP and OLAP data sources.
• Designed and developed Datamart using SSAS.
• Build Cubes on Enterprise Date Warehouse (EDW).
• Analyzed and created Multidimensional Cubes in Facts and Dimension Tables using SSAS.
• Scheduled Backups and performed Restore operations for system test data.

Environment: MS SQL Server 2008 Enterprise Edition, MS SQL Analysis Services 2008,MS SQL Reporting Services 2008, MS Access, MS SQL SSIS/SSRS/SSAS 2008, Windows XP Professional, Relational DBMS, data warehousing, Insurance Systems.

Confidential - Harrisburg, PA

SQL BI DEVELOPER

Responsibilities:

• Created/Updated database objects like tables, views, stored procedures, function, packages,
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Developed tablix reports, chart reports, line reports, parameterized reports, sub reports using SQL Server Reporting Services 2008.
• Designed reports using Pivot-tables, bar-charts, Line-charts and Pie-charts on data from cubes and SQL Server in Excel 2007.
• Integration of SSRS Reports using various web parts into SharePoint and various delivery mechanisms.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
• Deployed SSRS reports onto Microsoft Office SharePoint Server2007(MOSS).
• Designed and developed packages for data warehouse using Integration Services (SSIS) SQL Server 2008/2008R2.
• Involved in providing ETL support for the production server.
• Migrated DTS packages from SQL Server 2008 to SQL Server 2008R2 as SSIS Packages.
• Involved in creating SSIS jobs to automate the reports generation and cube refresh packages.
• Querying and manipulating multidimensional cube data through MDX Scripting (SSAS).
• Enhanced the functionality of OLAP cube by creating actions and perspectives from huge dataset using SQL Server 2008 Analysis Services.
• Created SQL Server Profiler traces & used with Database Tuning Advisor (DTA) for optimum performance of T-SQL and MDX queries.
• Created logical and physical database design, data structures and maintained it by writing stored procedures, user defined functions, views, T-SQL script.
• Optimize the database by creating various clustered, non-clustered indexes and indexed views.

Environment: SQL Server 2008 Enterprise Edition, BIDS, SSAS, SSIS, SSRS, T-SQL, MOSS 2007, MDX, ETL, VB.Net, ASP.Net, C#, Oracle 9i, Performance Point Server 2007, Erwin 7.2.

Confidential - Irving, TX

SQL/ETL Developer

Responsibilities:

• Formulated and documented the physical ETL process design based on business requirements and system specifications with strong ETL design skills, including source to target mappings, transformations, lookups, aggregations, expressions.
• Design and develop SSIS packages, store procedures, configuration files, tables, views, and functions; implement best practices to maintain optimal performance.
• ETL through SSIS and responsible for loading Data to DB from different input sources.
• Built SSIS packages with EXCEL and FLAT file source with validations to capture any kind of errors in the source.
• Migrated data from Oracle source to SQL server tables using SSIS.
• Deployed SSIS packages for various environments.
• Created packages in SSIS with error handling as well as created complex SSIS packages using various data transformations like conditional split, fuzzy look up, for each loop, multi cast, column conversion, fuzzy grouping, and script components for de-duplication of data.
• Designed, created and distribute reports in multiple formats such as Excel, CSV using SQL Server 2008 Reporting Services.
• Schedule Jobs to run SSIS package using UC4 scheduler.
• I has created dynamic connection script using C# to dynamically set connection strings and make the packages more portable.
• I has used script tasks and script components using C# dat allow custom logic in control flows.
• Used DTS Migration Wizard to convert DTS to SSIS packages and develop new SSIS packages.
• Generated server side T-SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances.
• Modified existing databases by adding/removing tables there by altering referential integrity, primary key constraints and relationships according to requirements
• Created trace in SQL Profiler and used Data base engine tuning advisor for Performance tuning on stored procedures and Scripts.
• Fixes Production issues and monitoring the whole job process to deliver committed work.
• Wrote documentation for the packages and scripts and job created for migrate data.
• Deployed reports to Report Manager and Troubleshooting for any error occur in execution.

Environment: SQL Server 2008, Windows 7, T-SQL, SSIS, SSRS, ASP.Net

Confidential - Long Beach, CA

MS SQL Server / SSIS/SSAS/SSRS Developer

Responsibilities:

• Scheduled the packages to run automatically for incremental data and deploy them to their destination servers
• Developed tables, Views, Stored Procedures, Functions, Indexes and Triggers using SQL Server Management Studio.
• Understanding the OLAP processing for changing and maintaining the data warehouse, optimizing dimensions, hierarchies and adding aggregations to the cube.
• Deployed SSIS package into production environment and used package configuration to export various package properties to make package environment independent.
• Developed SQL scripts to insert, update and delete data in MSSQL database tables in OLTP environment.
• Performed data consistency and performance tuning effectively with SQL Profiler, Index Tuning Wizard.
• Developed Report Models using report builder and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Improved data load performance by analyzing database design and query plans.
• Performed changes in the schema of the proposed database as required and informed those changes to the application development team.
• Created numerous efficient Stored Procedures to perform data cleansing and loading task when data is loaded into staging area.
• Documented different stages of data transformation, procedures and scripts.
• Optimized the query performance with modification in T-SQL queries, removing unnecessary columns, eliminating redundant and inconsistent data, establishing necessary joins, creating useful clustered index and non-clustered indexes.

Environment: SQL Server 2005(Enterprise Manager, Query Analyzer, SQL Profiler, Index Tuning Wizard, Data Transformation Services (DTS), Crystal Reports 8.0, XML, ASP.Net, VB Script.

Confidential

Jr. SQL Server Developer

Responsibilities:

• Interacted with Team and Analysis, Design and Develop database using ER Diagram, Involved in Design, Development and testing of the system
• Developed SQL Server Stored Procedures, Tuned SQL Queries( using Indexes)
• Created Views to facilitate easy user interface implementation and Triggers on them to facilitate consistent data entry into the database.
• Implemented Exceptional Handling
• Worked on client requirement and wrote Complex SQL Queries to generate Crystal Reports
• Creating and automating the regular Jobs.
• Tuned and Optimized SQL Queries using Execution Plan and Profiler
• Rebuilding IndexesandTables as part of Performance Tuning Exercise
• Involved in performing database Backup and Recovery
• Worked on Documentation using MS word

Environment: SQL Server 2000, SQL, T-SQL, BCP, Visual Basic 6.0/5.0, Crystal Reports 7/4.5, ASP/VB.NET