PROFESSIONAL SUMMARY

• Over 7 years of experience in the Analysis, Design, Development, Implementing and Testing Client/Server applications using different versions of Microsoft Technologies like SQL SSIS/SSAS/SSRS 2005 to 2012.
• Excellent experience and expert knowledge in Microsoft Business Intelligence framework SSIS, SSAS, SSRS, SQL Server .
• Expert experience with the concept, design and development of Data Marts, Data Warehouse using Star Schema and Snowflake Schema in implementing DSS.
• Experienced in Visual Source Safe, control system product that delivers restore point and parallel collaboration capabilities, thus allowing application development organizations to work on several versions of software simultaneously.
• Expertise in query optimization performance tuning. Used Performance tools like SQL Profiler, Index Tuning Wizard and Database Engine Tuning Advisor.
• Wrote Complex Queries, heavy stored procedures, Batch Scripts, Triggers, and Functions using T-SQL
• Excellent T-SQL Programming skills. Experience in query optimization performance tuning. Used SQL Profiler, Execution Plan.
• Expert in creating 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.
• Extensively used Report Wizard, Report Builder for developing and deploying reports in SSRS.
• 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 .
• Experienced in sorting the data, defining subtotals for reports and designing report layout.
• Proven ability in generating Drill down and Drill through reports with Drop down menu option.
• Responsible for interacting with the client, understanding their requirements and implementing the necessary changes in the program.
• Good experience in trouble shooting the SSRS Report Servers in SharePoint Integrated Mode.
• Wrote MDX Queries and expressions in Cubes for use in front end Business Intelligence applications.
• Great Knowledge in Dimensional Modeling, applying Kimball's methodology, Star Schema/Snowflake Schemas. Experience in Performance Optimization of SSAS cubes.
• Experience in tuning the reports that includes modifying, Testing the required TSQL and MDX queries using Dynamic Management View's and creating the necessary environment for Deployment.
• Excellent communication and inter-personal skills with ability to develop creative solutions for challenging client needs using agile methodologies.

SKILLS / TOOLS

MS SQL Server 2012/2008R2/2008/2005, MS SQL Server 2008/2005 Analysis Services SSAS , MS SQL Server Integration Service SSIS , MS SQL Server Reporting Services SSRS , Business Intelligence Development Studio BIDS , BCP, SQL Profiler, Enterprise manager, Management studio, Microsoft Access 2000, ERWIN 4.0/4.1/4.2/7.2, Microsoft Visio 10.0/11.0, T-SQL, HTML, Oracle 9i/10g, Crystal Reports 8.5/9/10/11, Visual Source Safe 2005, MS office 2013/2010./2007/2003, Professional, Windows NT 4.0 Server, Microsoft Project Professional 2010/2013.

PROFESSIONAL EXPERIENCE

Confidential

SQL Developer SQL Server/SSMS/SSIS

Responsibilities:

• Created highly complex SSIS packages with File Watcher Task and used various Data transformations like conditional splitting, , For Each Loop, Multi Cast, Data conversion, error handing to import client data from multiple flat files and post into staging tables for processing.
• Merged and converted historical data from multiple flat files, current database, and FoxPro database into a new master database.
• Identified the changes and constraints in new schemas that includes new columns, tables, primary and foreign keys and used T-SQL to write scripts to apply changes, transform the data and developed T-SQL procedures and triggers to modify the data and to truncate, create and import data/
• Designed, developed, implemented Stored Procedures and Triggers for automating tasks, and debugged stored procedures in MS SQL Server 2012 to load the data into consolidated database.
• Developed T-SQL queries for table creation, created stored procedures, views, triggers, and tested tables by using input values in banks BI schema structure.
• Used complex query statements like sub queries, correlated queries, derived tables, CASE functions to insert the data depending on the criteria into the tables of hub. Extensively used BCP and BULK INSERT to import and export data from flat files, Excel and MS Access to MS SQL Server databases.
• Maintained the table performance by following the tuning tips like Normalization, Creating Indexes.
• Environment: MS SQL Server 2012/2008R2, SQL Integration Services 2012/2008R2 , SCRIPT, Windows 7, Visio, MS Excel, CSV

Confidential

MS SQL Server/ BI Developer SSIS/SSAS/SSRS

Responsibilities:

• Created SSRS dashboard report out of control table to monitor package runs for CDC process by matching row counts on source and destination tables.
• Created Merge queries to handle INSERT/DELETE/UPDATE flags from CDC inflow data and updating target table accordingly
• Added several calculated fields while importing this data as business requirements.
• Created data manipulation, messaging scripts and procedures to ensure data quality and integrity
• Created data retention queries and SSIS packages to ensure amount of history to be stored in all CDC database.
• Identified key business sales issues developed appropriate business cases and created action plans from multi-disciplinary perspectives.
• Implement logical Delete functionality in all tables, when data is deleted from source table it will be flagged Delete but still store that data in separate table for history.
• Created Star schema dimensional modeling for the data mart using Visio and created dimension and fact tables based on the business requirement.
• Gathered report requirements and determined the best solution to provide the results in either a Reporting Services report, Analytical Cube or an Excel pivot table.
• Designed SSIS packages to Extract data from different sources like SQL server 2012/2008R2,MS Excel, MS Access, transform and then load into Dimension and Fact tables in Data Warehouse using SSIS .
• Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Cache Transform, Conditional Split and Derived column etc.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc. to generate data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Developed SSIS packages using For Each Loop in Control Flow to process all excel files within folder, File System Task to move file into Archive after processing and Execute SQL task to insert transaction log data into the SQL table.
• Generated monthly and quarterly reports as bar charts for management using different techniques like data filtering, adding interactivity, deploying reports to report server using SSRS.
• Converted manual reports pasted together into parameter driven stored procedures to be used with Microsoft Reporting Services 2012/2008R2.
• Developed functional and technical documentation to assist in the design, development and maintenance of deliverables.
• Created SSRS Data Model projects using Microsoft Visual Studio 2010 and using Report Builder for report server to create reports.
• Generated Sub-Reports, Cross-tab, Conditional, Drill down reports, Drill through reports and Parameterized reports using SSRS 2008.
• Environment: MS SQL Server 2012/2008R2, SQL server Reporting Services 2012/2008R2, SQL Integration Services 2012/2008R2, Microsoft Visual Studio 2010/2008, SQL Server Management Studio, MS Excel, T-SQL, Visio.

Confidential

MS SQL Server/ BI Developer SSIS/SSRS

Responsibilities:

• Designed, developed, debugged and tested SSIS packages, SSRS reports and T-SQL Stored Procedures.
• Designed, modified database objects such as tables, views, indexes, Stored Procedures, defaults, user defined data types and functions
• Extracted and transformed data from various sources such as Pervasive database, SQL server, Excel, Access and flat files using SSIS into destination tables as per the business requirements.
• Wrote T-SQL queries for data analyzing, research, unit testing and identifying and resolving bugs.
• Implemented performance tuning T-SQL queries, Stored Procedures and SSIS Packages, Peer reviewed T-SQL code/SSIS packages.
• Examined execution plans, created covering indexes and filtered indexes when necessary for tuning SQL queries.
• Developed Parent Child packages to load data, ensuring restart ability anytime without having to manually delete partially loaded data from the destination tables.
• Performed unit integration and functional testing of the SSIS packages, T-SQL and Stored procedures.
• Implemented SQL to keep data in sync between tables across different databases.
• Implemented data mart, facts, dimensions, snowflake schema and OLAP cubes.
• Wrote production implementation documents and provided Production support when required.
• Implemented MS SQL Server Analysis Services setup, tuning, cube partitioning, dimension design including hierarchical and slowly changing dimensions.
• Wrote MDX queries for OLAP cube.
• Created report in Excel using SSAS with SQL server.
• Environment: MS SQL Server 2008R2, T-SQL, SSRS/SSIS, BIDS, MS Office, Windows Sever 2003, 2007/XP/2008, SQL Plus, ERWIN, SSAS, Crystal report, Share Point.

Confidential

MS SQL/BI Developer SSIS/SSAS/SSRS

Responsibilities:

• Troubleshot the stored procedures, functions, views, triggers, etc.
• Wrote SQL Scripts such as finding tables that have Identity Columns, finding tables that do not have primary key.
• Developed and performed data modeling studies, support data selection, extraction and cleansing of mediation applications.
• Developed SSIS ETL packages to meet data flow needs, automated the SSIS jobs in SQL scheduler as SQL server agent job for daily, weekly and monthly loads.
• Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables from different databases. Proven ability in generating Drill down and Drill through reports with Drop down menu option, sorting the data, defining subtotals in SSRS 2008.
• Created Parameterized reports and Linked reports and thorough knowledge of report serving architecture using SSRS.
• Designed and implemented Disaster Recovery Procedures like Log Shipping and mirroring between production and DR servers.
• Extensively involved in replication and implemented Snapshot, Merge and Transactional Replications.
• Developed SSIS ETL Packages to meet data flow needs building platform with the using of SSIS.
• Reduced the T-SQL overhead successfully by avoiding unnecessary use of The UNION, , statement using the TOP operator to limit the Select statement in certain queries.
• Used Index usage statistics to determine how useful an index is and if an index is improving or hindering application performance.
• Designed SQL SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL Server 2008R2 for further Data Analysis and Reporting by using multiple transformations, scheduled and maintained daily and weekly loads of data by creating the corresponding job tasks.
• Enhanced performance of databases using optimization techniques-normalization, Indexing and Transaction Isolation levels, monitoring logs to ensure the completeness of batch processes, scripts and processes.
• Supported Application Development team with any database issues, updates or new releases and deadlock issues, best practices in structuring SQL Queries, debugging unexpected SQL results, etc.
• Environment: MS SQL Server 2008R2,MS Access, Query Analyzer, SSIS, BCP, SQL Profiler, Import Export Data.

Confidential

MS SQL BI Developer

Responsibilities:

• Created control and ESP databases in SQL Server 2008. The data received in Script format is loaded into Oracle control database using SQL Server's SSIS.
• Utilized XML to import and export of data into SQL Server database.
• Created jobs for periodic backups of existing Databases, transaction logs and execution plans, as well as migration from Oracle, and other Database systems into MS SQL Server 2008 using SSIS.
• Formulated and documented ETL process design based on business requirements and system specifications including source to target mappings, data dictionaries and transformations.
• Directly responsible for the Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse.
• Created highly complex SSIS packages using various Data transformations like conditional splitting, Fuzzy Lookup, For Each Loop, Multi Cast, column conversion, error handing.
• Developed various complex reports and manage those using SQL Server Reporting Services.
• Created Tabular reports, Matrix reports, List Chart reports, Parameterized reports, Sub reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment.
• Wrote and integrated stored procedures to generate the special reports according to client's need.
• Used T-SQL to write scripts to transform the data and developed T-SQL procedures and triggers to modify the data and to create import files. The data in the import files was imported into ESP database.
• Used slowly changing dimensions to track certain dimensions like sales.
• Reconciled the data and presented the data according to the requirements of the client along with the reconciliation reports.
• Merged the converted ESP database with the existing client database.
• Environment: Oracle 10g/9i, SQL, PL/SQL, XML, SQL Server 2008, SCRIPT, Windows Vista.