SUMMARY

• Over 7+ years of professional experience in analyzing, designing and developing Business Intelligence (BI) database applications and various segments of Software Development Life Cycle (SDLC), using MS SQL Server Integration Services (SSIS), Analysis Services (SSAS) and Reporting Services (SSRS).
• Expertise in Extraction, Transforming and Loading (ETL) data using SSIS, creating mappings/ workflows to extract data from SQL Server Excel file, Flat File sources and load into various Business Entities Data Transformation Services (DTS), creating Dynamic packages for Incremental Loads.
• Excellent Knowledge of SDLC, RDBMS, Data Warehouse & Data Modeling concepts.
• Skilled in creating T - SQL objects, working with DDL/DML, perform most of theSQL Server Enterprise Manager and Management studio functionality using T-SQL Scripts and Batches
• Expert in writing Distributed Queries between SQL Servers.
• Experience in creating Indexed Views, complex Stored Procedures, effective functions, and appropriate Triggers to facilitate efficient data manipulation and data consistency.
• Experience in using tools like Index Tuning Wizard, database engine tuning advisor, SQL Profiler, and Windows Performance Monitor for Monitoring and Tuning Server Performance.
• Knowledge in Performance Tuning and Query Optimization
• Experience in creating/deploying Data Transformation Services (DTS), MS SQL Server Integration Services (SSIS) packages, Reporting Services (SSRS) and Analysis Services (SSAS).
• Skilled at Transforming and validating data using SQL Server Integration Service (SSIS) Transformations like Conditional Split, Lookup, Merge Join, Sort and Derived Column.
• Proficiency in Developing SSAS Cubes, Aggregation, KPIs, Measures, Partitioning Cube, Data Mining Models, and Deploying and Processing SSAS objects.
• Well versed in Using MDX (Multi-Dimensional Expressions) Queries to retrieve data from Multi-dimensional SSAS Cubes.
• Create reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector.
• Performed data cleaning, data validation, and data analysis using data analysis expressions (DAX), powerqueryand power Pivot.
• Experience in designing complex reports including sub reports, parametric, drill down, drill through, cascading and formulas with complex logic usingSQL Server Reporting Services (SSRS).
• Skilled in creating scheduled reports for Daily, Weekly, Monthly reports on sales and marketing information for various categories and regions based on business needs using Reporting services (SSRS).
• Excellent report creation skills using Microsoft Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
• Explore data in a variety of ways and across multiple visualizations using Power BI.
• Responsible for creating SQL datasets forPowerBIand Ad-hoc Reports.
• Expert on creating multiple kind ofPowerBIReports and Dashboards.
• Created, Maintained & scheduled various reports inPowerBI.
• Well-organized, goal-oriented, highly motivated effective team member with excellent analytical, troubleshooting, and problem solving skills.
• Excellent communication and interpersonal skills. Proficient in technical writing and presentations and a good team player.
• Ability to work independently or as part of a team to accomplish critical business objectives and to make decisions under pressure.

TECHNICAL SKILLS

Operating System: Operating Systems Windows NT 4.0, Windows 2000 Server, Windows 2000 Advanced Server, Windows 2003 Server, Windows XP, Windows Vista, 7.

Programming Languages Software: SQL, SQL*Plus, HTML, XML,C,C++, DS, Visual Studio 2005, MDX, MS Office 2010/2007, T-SQL, PL/SQL

RDBMS: MS SQL Server 2008/2005/2000 , SQL Server Management Studio(SSMS), SSAS, Oracle 9i, MS Access

ETL Tools: DTS, SQL Server Integration Services(SSIS)

Reporting Tools: SQL Server Reporting Services(SSRS), Crystal Reports 8.0/9.0, SharePoint 2007

Database Query Tools: MS SQL Server Query Analyzer, SQL Profiler, TOAD

PROFESSIONAL EXPERIENCE

Confidential, Chicago

SQL/SSIS/SSAS/ POWER BI Developer

Responsibilities:

• Created various database tables and procedures to update and clean the old data.
• Developed Complex Stored Procedures, Views and Temporary Tables as per the requirement.
• Designed SSIS Packages in SQL Server 2012 to handle data migration (ETL Processes) from transaction System to Dimensional Model.
• Implemented SSIS (ETL) to extract and transform data from RDBMS and Flat files/CSV, SQL Server 2012 instances and to load into staging and then to DW for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Design and develop SSIS (ETL) packages for loading data from Oracle and Flat files (3GB) to SQL Server Database.
• Created SSIS Packages using Lookup, Merge, Sort, Derived Columns, Condition Split, Aggregate, Execute SQL Task, and Data Flow Task, Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel, Text file, XML file to different data Marts.Developed reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Excellent report creation skills using Microsoft SQL Server 2012/2008 Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
• Rendering the reports to PDF formats as per the requirement and printing all the reports in a batch process for Monthly Statements.
• Developed Scorecards/Reports for the system using SSRS, Power BI.
• Created, Maintained & scheduled various reports inPowerBIlike Tabular Reports.
• Explore data in a Variety of ways and across multiple visualizations using Power BI.
• Worked on OLAP Data warehouse, Model, Design, and Implementation.
• Involved in designing, developing, and deploying reports in MS SQL Server environment using SSRS in Business Intelligence Development Studio (BIDS).
• Involved in Creation of Dimensions using STAR and SNOW FLAKE Schema.
• Designed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measures groups and KPIs to analyze performance of Strategic Business Units as well as corporate centers.
• Created several cubes, dimensions and business critical KPIs using SQL Server Analysis Services (SSAS) representing aggregations in several different ways - hierarchically and using custom groupings that the company will use to analyze performance.
• Extensively worked on Dimensional modeling, Data cleansing and Data Staging of operational sources using ETL processes and good experience in SSAS.
• Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS.
• Used Open Query from SQL Server the SSAS Server to combine data from SSAS cube and DW database.
• Created Calculated Measures and Key Performance Indicators in SSAS using MDX.
• Querying and manipulating multidimensional cube data through MDX Scripting in SSAS.

Environment: MS SQL Server-2012/2008 R2/2005, SSIS, SSAS, SSRS, T-SQL, DTS, SQL Profiler, Erwin, OLAP, OLTP, Erwin, Performance Point Sever, Office-2007, MS Excel.

Confidential, San Jose, CA

Sr. SQL/MSBI Developer

Responsibilities:

• Performed T-SQL tuning and optimizing queries and stored procedures, which take longer time in execution.
• Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Extensively used T-SQL in constructing Stored Procedures, Common Table Expressions (CTE’s), User Functions, Views and Indexes.
• Created SSIS packages to extract data from various flat files, Excel spreadsheets and loading into SQL server.
• Created SSIS packages to load data into Data Warehouse using various SSIS Tasks like Execute SQL Task, data flow task, file system task.
• Used data transformations like aggregate, sort, Multicasting, Conditional Split, Derived Column etc. in creating SSIS packages.
• Experience in Logical modeling using the Dimensional Modelling techniques such as Star Schema and Snow Flake Schema.
• Implemented SSIS transformation like Lookup transformation, Derive Column, Conditional Split, Merge Join and Row Count.
• Responsible for creating new reports as well as modifying the existing reports using SQL Server Reporting Services (SSRS).
• Involved in designing, developing and deploying reports in MS SQL Server environment using SSRS-2008 in Business Intelligence Development Studio (BIDS).
• Developed custom ad-hoc reports by using SQL Server Reporting Services (SSRS).
• Created SSRS reports using Report Parameters, Drop-Down Parameters, Multi-Valued Parameters Debugging Parameter Issues Matrix Reports, Charts and Pie Charts.
• Developed report parameters and performed Parameterized and cascading parameterized reports and sorting the data, defining subtotals for the reports using SSRS in Visual Studio.
• Designed complex reports like Drill-Down Reports, Drill-Through Reports, and Parameterized Reports using SQL Server Reporting Services (SSRS) based on client requirement.
• Created various SSRS Reports involving variety of features like Reports, Charts, Gauges, Filters, Sub-Reports, Drilldown, Drill-Through, Multi-valued parameters etc.
• Built effective queries for high-performance reports and rendered them to HTML, XML, PDF and Excel formats using SSRS.
• Involved withQuery Optimizationto increase the performance of the Report.
• Strong analytical ability. Proficiency in quickly identifying the cause and solution of particular database related problem.
• In-depth knowledge of all the widely used operating systems. Able to install and operate databases on different OS platforms.
• Formatted the report layout for the requirement of the end users and deploy the developed reports on to the server for the end users, add reports to the Share Point portals.
• Documented and maintained history of changes for future reference.

Environment: MS SQL Server Management Studio(SSMS) 2008 R2/2012, MS SQL Server Integration Services (SSIS), MS SQL Server Analysis Services (SSAS), MS SQL Server Reporting Services (SSRS), MS SQL Business Intelligence Development Studio (BIDS), SQL Profiler, Index Tuning Wizard, Team Foundation Server (TFS), Microsoft SharePoint Services 2010.

Confidential, Towson, MD

MS SQL Developer

Responsibilities:

• Created ETL SSIS packages both design and code to process data to target databases.
• Identify and resolve problems encountered during both development and release of the SSIS code.
• Debugging and troubleshooting the technical issues while implementing the applications.
• Extensive experience in developing tools using Access, VBA, Excel environment
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Created packages in SSIS with error handling and worked with different methods of logging in SSIS
• Rewrote many T-Sql scripts to promote parallelism processing on the servers in production
• Creation of custom pipelines and helper classes in .Net - C# and VB
• Created and implemented Cubes, and designed attribute relationships for optimal performance of Hierarchies and Fact Dimensions.
• Developed, Maintained, and Monitored all import/export and Data Transformation into the Staging and Production environments.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages and Updating and maintaining Visual Source Safe.
• Created several MDX queries according to Business requirements.
• Wrote MDX queries and expressions for use in Front End BI Applications
• Created complex Stored Procedures, Triggers, Functions (UDF), Indexes, Tables, Views and other T-SQL code and SQL joins for applications following SQL code standards.
• Responsible for data analysis, loading data from Data feed to Data Warehouse tables.
• Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance.
• Heavily involved in several data quality and Master Data Management (MDM) initiatives using SQL Server Data Quality Services (DQS) and Master Data Services (MDS)
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like Tabular, Matrix, Drill Down, Drill Through and web reporting by customizing URL Access.
• Documented all the work and all the process of integration and reporting services for further references
• Worked extensively on system analysis, design, development, testing and implementation of projects (Complete SDLC).

Environment: MS SQL Server 2012/2008R2, SSRS, SSIS, SQL Query Analyzer, SQL profiler, IIS 6.0,Enterprise Manager,DQS, Windows Server 2003/2008, MDX,VBA,DTS, Share Point Portal Server, HTML, XML, C#, .Net, ASP.NET, Visual Studio 2005/2010, MS Access, Crystal Reports, MS Excel 2007.

Confidential - Pleasanton, CA

SQL Server Developer/SSIS/SSRS Developer

Responsibilities:

• Designed and Created databases, tables, views, stored procedures and triggers.
• Created groups, roles, users and assigning access privileges to users.
• Monitored and scheduled existing/new jobs on production environment.
• Optimizing Database Queries for performance enhancements and Writing T-SQL Views and triggers. Worked to tune the SQL queries using SQL Profiler.
• Migrated data from SSAS environment to SQL Server 2005 with SSIS 2005.
• Created ETL process using SSIS to transfer data from heterogeneous data sources.
• Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
• Migrated DTS objects to SQL Server Integrated Services (SSIS) environment.
• Responsible for gathering business requirements to create business user reports.
• Created Parameterized, Cascaded, Drill-down, Cross-tab and Drill-through Reports using SSRS 2005.
• Developed optimal stored procedures and queries to create data sets for reports.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Played a Content Manager role on report server.
• Worked on performance tuning on existing stored procedures and existing reports for the faster processing of reports.
• Designed SSAS cube to hold summary data for Target dashboards. Developed Cube with star schema.
• Created usage based aggregations in cube to minimize time for query retrieval from client tool Target.
• Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS.
• Performed unit and system testing, troubleshooting and bug fixing in development and QA environments.

Environment: MS SQL Server 2005, Windows 2003 Server, T-SQL, SSIS 2005, SSRS 2005,SSAS 2005, ASP .Net, VB.net

Confidential

SQL/SSRS Developer

Responsibilities:

• Implemented Complex business logic with User-Defined-Functions, Index Views and also created User defined Data type, Clustered & Non-clustered Indexes
• Installed and configure servers and clients using SQL Server 2008,Upgraded SQL databases
• Created complex Stored Procedures, Triggers, Functions (UDF), Indexes, Tables, Views and other T-SQL code and SQL joins for applications following SQL code standards
• Managed indexes, statistics and tuned queries by using execution plan for optimizing the performance of the databases
• Query optimizations (T SQL or Query Analyzer) using query analyzer and Index tuning wizards
• Knowledge of Database Performance monitoring tools
• Created packages in SSIS with error handling and worked with different methods of logging in SSIS
• Created ETL SSIS packages both design and code to process data to target databases
• Created SSIS packages to retrieve data from Legacy sources and also to retrieve user data from the Flat files on monthly and weekly basis
• Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation. Developed, monitored and deployed SSIS packages
• Maintained the physical database by monitoring and optimizing performance, data integrity and SQL queries for maximum efficiency using SQL Profiler
• Monitor SQL Error Logs /Schedule Tasks/database activity/eliminate Blocking & deadlocks user counts and connections/locks etc.
• Implement automated Index Maintenance strategy run as SQL Job on a daily basis
• Resolving any dead locks issues with the Databases/Servers on a real-time basis.
• Designed and developed SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet and flat files into SQL server 2005 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all
• Responsible for the design of the SSIS package for updating the data mart from OLTP database and validation of the aggregate data from the ODS and the OLTP Database

Environment: SQL Server 2005/2008, T-SQL Windows Enterprise Server 2003/2008, Enterprise Manager, SQL Server Management Studio, Oracle 10g, SQL Server Business Intelligence Studio, SQL Server Profiler, XML, BizTalk Server 2004 Erwin, Microsoft Visio 2003, SFTP

MS SQL Server Developer

Responsibilities:

• Worked with application developers and production teams across functional units to identify business needs and discuss solution options.
• Successfully installed and configured MS SQL Server 2005 on the production server.
• Automated the migration of data from Oracle DB to MS SQL Server 2005 DB using Microsoft SQL Server Migration Assistant (SSMA).
• Generated assessment reports to analyze the scope and complexity of the migration projects.
• Converted the Oracle DB objects to MS SQL Server 2005 DB objects like tables, views, and stored procedures.
• Designed a new schema design for the data warehouse using dimensional modeling and developed it using the Erwin tool.
• Migrated the entire schema as well as data into MS SQL Server 2005 and also validated the migration process to ensure that it has been successfully migrated.
• Performed various transformations like conditional split, sorting and included data about the environment using the audit transformation.
• Designed drilldown, drill through, and parameterized report using SSRS.
• Deployed generated reports onto the Report Server to access it through browser.
• Designed, reviewed, and created primary objects such as views, indexes, views and store procedures.
• Worked with User Defined Functions and Triggers to store data into appropriate tables as and when data arrives and created indexes to the tables that have least update to improve the query performance.
• Defined referential relationships with the measure groups and fact tables.
• Documented the development work and production release for future reference.

Environment: MS SQL Server 2005/2008, T-SQL, DTS Designer, MS-Office, MS-Excel, VSS.