SUMMARY

• Over 8+ years of IT Professional experience in development of applications built on SQL Server and experience in working with projects driven on SQL, Microsoft Business Intelligence tools, Data Warehousing and ETL processes.
• Expert in T - SQL (DDL, DML): functions, views, triggers, cursors, stored procedures on SQL Server.
• Strong Experience in SQL Server Integration Services (SSIS), Data Transformation Services (DTS),SQL Server Reporting Services (SSRS)and SQL Server Analysis Services (SSAS).
• Good experience with ETL processes, worked extensively on data extraction, data integration and loading into database from different data sources using SSIS.
• Designed, developed and implemented various SSIS Packages and deployed using Deployment wizard.
• Optimize, tune and enhance the SSIS package performance by using Performance Monitor.
• Created numerous simple to complex queries involving self joins, correlated sub-queries, cursors, dynamic T-SQL.
• Extensive knowledge of Normalization and Relational Database Management Systems. Experienced in supporting web based, mission critical applications including Logical and Physical Database Design, Development and Performance Tuning.
• Experienced in migrating Data from Excel, Flat file, Oracle to MSSQLServer using SQL Server Integration Services (SSIS), BCP and DTS utility. Expert in Creating, Configuring and Fine-tuning ETL workflows in SSIS.
• Experience in providing Logging, Debugging and Error handling by using Event Handlers, and Custom Logging, break point, data viewers, check points for SSIS Packages.
• Expert in design of Star and Snowflake Schemas for data warehouse database.
• Excellent Knowledge in Dimensional Data Modeling and analyze Data warehouse by building multidimensional cubes using SQL Server Analysis Services (SSAS).
• Experienced in building data source views, OLAP cubes and data mining models using SSAS
• Expert in building hierarchies, attribute relations, slowly changing dimensions, Drill through actions, Calculated members, Cube partitions using SSAS
• Good experience in writing MDX queries to access cubes data in SSAS
• Expert in developing parameterized, linked, matrix, drill down and aggregation reports with various parameters and filters using SSRS.
• Hands on experience in generating on-demand and scheduled reports for business analysis or management decision using SSRS.
• Experience with software development life cycle (SDLC), Agile, Scrum and Project Management Methodologies.
• Hands on experience in using version control software like VSS, Rational clear case and (TFS) Team Foundation Server.
• Flexible, enthusiastic and project oriented team player with solid communication and leadership skills to develop creative solution for challenging client needs.

TECHNICAL SKILLS

RDBMS: MSSQL Server 2014, 2012, 2008.

Database Utilities: Enterprise Manager, SQL Server Management Studio, BI DevelopmentStudio, Visual Studio, Configuration Manager, SQL Server Profiler SQL Query Analyzer, SQL Server Agent.

BI Tools: MSBI Stack (SSIS, SSRS, SSAS).

Office Tools: MS Word, MS Excel, MS PowerPoint, MS Outlook.

Languages: C#, SQL, MDX, HTML, XML.

Operating Systems: Windows.

PROFESSIONAL EXPERIENCE

Confidential, Overland Park, KS

MS BI/ SQL Server Developer

Responsibilities:

• Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2012 and Flat files.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Responsible for ETL Operation which extracts and transforms the data to Data Warehouse using SQL Server Integration Services (SSIS).
• Used various Transformations such as For loop container, For Each loop container, Execute package task, FTP task, Bull Insert task, Script task In SSIS Control Flow and Row sampling, Fuzzy Lookup, Fuzzy Grouping in SSIS Dataflow.
• Designed and formatted SSRS Reports using Parameters and Expressions for the Reports
• Involved in ETL architecture enhancements to increase the performance using query optimizer.
• Implemented Event Handlers and Error Handling in SSIS packages.
• Created SSIS packages for Data Conversion using data conversion transformation.
• Configured the loading of data into slowly changing dimensions using Slowly Changing Dimension wizard.
• Experience in creating Tabular reports, Matrix reports, List reports, Parameterized reports, Sub reports, Ad hoc reports (SSRS).
• Advanced extensible reporting skills using SQL Server 2008 Reporting Services (SSRS).
• Designed and created Report templates, bar graphs and pie charts based on the financial data regarding competitive rates and financial market.
• Understanding the OLAP processing for changing and maintaining the Warehousing, Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Developed various types of complex reports like Drill Down, Drill through, linked reports, cascading parameter reports for business loan, first time buyer or refinancing home mortgage.
• Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS 2008.
• Involved in designing Parameterized Reports and Matrix Reports for generating Ad-Hoc reports as per the client requirements.
• Automated the execution of SSRS reports using Subscriptions and Data-Driven Subscriptions
• Involved in Troubleshooting system issues, monitored scheduled jobs and set up maintenance plans for proactively monitoring the performance of SQL Server databases
• Coordinated with front-end for implementing logic in stored procedures and functions.
• Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Joins, Constraints, DDL, DML, MDX and User Defined Functions to implement the business logic and also created clustered and non-clustered indexes.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Involved in upgrading from SQL Server 2005 to SQL Server 2008.
• Advised optimization of queries by looking at Execution Plan for better tuning of the database.

Environment: SQL Server 2012/2008R2 Enterprise Edition, SSIS/SSRS/SSAS 2008, Visual Studio 2008, VB.net, PL-SQL, TSQL, .Net framework, MS Access, Windows Server 2003.

Confidential, Irving, TX

Server (SSIS/SSRS) /BI Developer

Responsibilities:

• Involved in Analysis, Planning and Defining data based on business requirements and provided documentation.
• Extensively worked in analyzing Stored Procedures on Legacy Environment, produce documentation and re-create them on new environment
• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel format using SSRS 2008.
• Designed different kinds of reports like Linked, cascaded and parameterized reports and Worked on Drill Down and Drill-through Reports, Tabular, Matrix etc.
• Created SSIS package to load data from Flat File to Flat File and Flat File to SQL Server using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation and Un-pivot Transformation.
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes.
• Involved in loading the partner flat files into the OLTP database. Also, developed the T-SQL stored procedures/functions to process these data and populate them in the appropriate destination tables.
• Created different Parameterized Reports (SSRS 2005/2008) which consist of report Criteria in various reports to make minimize the report execution time and to limit the no of records required.
• Report parameters included single valued parameters, multi-value parameters which also consist of different parameter types like hidden, internal, default (queried and non-queried parameters)
• Worked on all types of report types like tables, matrixes, charts, sub reports etc.
• Created Linked reports, Ad-hoc reports and etc. based on the requirement. Linked reports are created in the Report Server to reduce the repetition the reports.
• Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server2008 R2 and Flat files.
• Built efficient SSIS packages for processing Fact and Dimension tables with complex transforms and type 1 & type 2 changes.
• Design, deploy, and maintain various SSRS Reports in SQL Server 2005.
• Involved in the preparation of detail provider/ KPI/ Specialty etc. reports using SSRS.
• Developed Scorecards/Reports for the system using SSRS, Power BI.
• Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional, Split, Derived columns etc.
• Wrote T-SQL scripts to validate and correct inconsistent data in the staging database before loading data into databases.
• Good knowledge and experience in Data warehouse Environment.
• Implemented security to restrict the access to users and to allow them to use only certain reports.

Environment: MS SQL Server 2012/2008R2, SSRS, SSIS, SSAS,, TSQL, Visual Studio 2008.

Confidential, St. Louis, MO

MS SQL SERVER/SSIS/SSRS DEVELOPER

Responsibilities:

• Created database objects like Tables, Views, Stored procedures, Functions, Joins, Indexes and Triggers in T-SQL based upon the functional specifications.
• Implemented performance tuning of slow running queries and stored procedures using Sql Profiler and Execution plan.
• Created and scheduled SSIS packages to pull data from SQL Server and exported to various data sources like Excel Spreadsheets, Flat File and vice versa.
• Implemented Package Configurations, Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Scheduled SQL jobs to run SSIS packages on a daily, weekly, monthly basis using MS SQL Server Integration Services (SSIS).
• Responsible for Gathering/Refining requirements from the customer for developing reports.
• Developed Report Models using report builder and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio.
• Developed and deployed different reports such as drill down, drill through, parameterized reports and implementing different visualization like bar chart, Pie charts, tabular presentation using SSRS.
• Worked on DUNDAS chart and applied financial and statistical formulas within the share point design.
• Involved in development & Deployment of SQL Server Analysis Services (SSAS) Cubes and Monitor Full and Incremental loads and support any issues.
• Created bottom count, top count, cross join, non-ascendants and log MDX queries for creating Calculations and KPI’ Confidential on a SSAS cube.
• Expertise in creating Perspectives, Partitions and Design Aggregations in cubes using SSAS.
• Performed Unit and system testing, Trouble shooting and bug fixing in development and QA environments.

Environment: MS SQL Server 2008R2/2012, Business Intelligence Development Studio (BIDS), DUNDAS Dashboard, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), MS EXCEL, SQL Server Profiler, Team Foundation Server (TFS).

Confidential

MS SQL BI DEVELOPER

Responsibilities:

• Created new database objects like stored procedures, Functions, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2008.
• Migrated DTS packages from SQL Server 2000 to SQL Server 2008 as SSIS Packages.
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
• Created efficient, robust SSIS packages for data movement and loading with error checking and well documented code.
• Created SSIS Packages to integrate data coming from Text files and Excel files.
• Created SSIS packages to validate, extract, transform and load data to data warehouse databases.
• Built connections to/pulling data from AS400, mainframe/db2 and Oracle.
• Migrated old data from MS Access into SQL Server 2008 using SSIS Packages in Business Intelligence Development Studio.
• Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups using SSIS tasks.
• Data management and data processing solutions using SSIS, this includes Error Handling and Slowly Changing Dimensions.
• Worked on Database Compression for different databases to save space across different environments.
• Wrote many stored procedures for cleaning, manipulating and processing data between the databases.
• Extensively used Joins and Common Table Expressions to simplify complex queries involving multiple tables.
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
• Experience in creating Multidimensional cubes using SSAS and designing DW schemas.
• Created DSV, Cubes, and Dimensions, DMX/MDX for SSAS Reports.
• Repaired/recreated PPS reports damaged in the conversion process.
• Scheduled the Packages in SQL Server Agent on daily/weekly/monthly basis.
• Document new SSIS packages and Train Senior Analyst on basic SSIS concepts.
• Interacted with vendors, developers and customers to manage the business requirements.
• Verified business requirements and functional specifications.

Environment: Data Transformation Services (DTS), SQL Server 2008 Enterprise Edition, ODBC, OBIEE, BIDS, Business Objects, SSIS, SSAS, XML, Visual Basic 6.0.

Confidential

SQL SERVER DEVELOPER

Responsibilities:

• Created Database objects - Tables, Views, and Functions and developing procedures for implementing application functionality at the database side for performance improvement.
• Performed query plans and making sure each and every query is using appropriate useful Indexes.
• Created and Modified T-SQL Stored Procedures/Triggers for validating the integrity.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Excellent report creation skills using Microsoft Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
• Extensive experience in multidimensional data modeling, such as star schemas, snowflakes, de-normalized models, handling slow-changing dimensions/attributes.
• 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 Management Studio 2008/2005, MS SQL Server Integration Services (SSIS), MSSQL Server Analysis Services (SSAS), MS SQL Server Reporting Services (SSRS), Microsoft Visual source Safe.