SUMMARY

• Over 8+ years of extensive experience working with BI (SSRS, SSIS, and SSAS) and T - SQL using SQL Server 2000/2005/2008 R 2/ 2012/2015 . T-SQL -
• Experience in Writing T SQL (DDL, DML AND DCL), developing/creating new database objects such as Tables, Views, Indexes, Complex stored procedures, function( UDF), cursors, and triggers, locking issues, BCP, common table expressions (CTEs), Backups, Recovery and SQL Server Agent profiler using SQLSERVER 2000/2005/2008 R2/ 2012 .
• Extensive knowledge in dealing with RDBMS including E/R Diagrams, Normalization, Constraints, Joins, Keys and Data Import/Export.
• Performance Tuning in SQL Server - Using SQL Profiler, DTA (Tuning Advisor), HINTS, Effective use of DMV’S/DMF’s, Optimization for AD-HOC Workloads, Plan Guides, Parameter Sniffing, DBCC commands, Partitions & Partitioning, Bulk Loading Data(BCP),Indexed Views & Schema Binding, STATS, Clustered/Non Clustered Indexes. SSRS -
• Created reports such as Parameterized, Cascading, Drill through/Drill down Reports, Charts and specialized in producing Sub Reports using Relational data warehouse and OLAP Cubes.
• Experience in developing several Detail, Summary reports including line and pie charts, trend analysis reports and sub-reports according to business requirements using SSRS.
• Experience as Report Writer for understanding each client business reporting requirement, designing, creating and maintain of simplex to complex reports.
• Experience in generating reports for OLTP and OLAP databases.
• Experience with scheduling and the deployment of the reports and uploading files to a report server catalog from the report manger.
• Experience in generating on-demand and scheduled reports for business analysis or management decision using SSRS.
• Heavy experience in deploying and configuring packages, Error handling and batch logging, check points and troubleshooting Reports using SSRS.
• Hands on experience working with Self Service MS BI end user tools such as Excel 2010 (Power pivot) , Performance Point Server (PPS), Power view .
• Developed the SSAS 2012 Multidimensional and Tabular model reports from Data warehouse using SSDT. SSIS -
• Experience in developing SSIS packages for data migration between different heterogeneous sources such as flat file, excel, Oracle, Sybase, DB2, MS access using SQL Server SSIS 2000/2005/2008 R2/2012/2015.
• Proficient in Extraction Transformation and Loading (ETL) process by pulling large volumes of data (VLDB) from various data sources using SSIS.
• Worked in Migrating of DTS Packages to SQL Server Integration Services (SSIS) from Lower Version (2000/2005) to Higher Version ( 2005/2008/ 2012 ) and troubleshoot migration issues.
• Experience in designed Data Conversions from wide variety of source system using SSIS.
• Experience working with different SSIS Configuration options and Deployment Methods for different environments use.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Experience working with Data Cleansing technique in ETL process.
• Hands on experience working with different types Dirty Data from different sources.
• Hands on experience loading Data warehouse for both Dimension tables and fact tables by initial load/ongoing load process using SCD, MERGE, CDC, Parent/Child SSIS packages .
• Excellent Hands on Logging, Error handling using Event Handlers pre and post for SSIS Packages.
• Strong experience in Creating, Designing and Processing a Multi-Dimensional Analysis Cubes (Configured Cubes, Dimensions, Measures, MDX Queries, DAX Data mining, Data Source, Data Source Views and following Star and Snow Flake schema) using SQL Server 2005/2008/ 2012 Analysis Services (SSAS).
• Excellent hands on experience in creating groups and measures, KPIs.

TECHNICAL SKILLS

Databases: SQL Server 2012/2008R2, 2005 & 2000/7.0, MS-Access 2000, Oracle 11g/10/9i, DB2

Database Tools: SSMS, BIDS/Visual Studio, TOAD

SQL Server Tools: SSMS, Configuration Manager, Enterprise Manager, Query Analyzer Profiler, DTS, SSIS, SSAS, SSRS, Database Tuning Advisor, SQL* Plus

Languages: C, C++, VB.NET, C#.NET, JAVA, PHP, UNIX, SQL, T-SQL, PL/SQL, MDX, DAX, COBOL

RDBMS: SQL Server 2000/2005/2008 R2/2012, Oracle 11g/10/9i

IDE: Visual Studio 2003/2005/2008 R2/2012

OS: Windows 2003 Enterprise, Windows 2000 Datacenter, Windows NT & XP

Other Tools: Erwin/Power Designer (Data Modeling), Visio, Visual SourceSafe, MS Office suite, Quality Control(QC)

Architecture: Relational DBMS, Client-Server Architecture, OLAP, OLTP

Methodologies: Agile, Waterfall, Scrum, SDLC.

PROFESSIONAL EXPERIENCE

Confidential, Portland

Sr SQL BI Developer

Responsibilities:

• Developed complex stored procedures, indexes, triggers, functions and views for different applications using SQL.
• Experience on working with SQL Joins, Common Table Expressions (CTE), Sub queries.
• Used Triggers to generate customized error messages.
• Writing complex SQL queries for data extraction from the source, based on the client requirements.
• Experience in performance tuning of SQL queries and stored procedures by creating Indexes on the columns, which enhances the performance of the code.
• Experience in developing different types of reports such as parameterized, drill down and drill through using SQL Server Reporting Services (SSRS).
• Experience with report deployment, scheduling and uploading files to report server catalog from report manager.
• Validated reports to ensure quality of data and Interacted with business analysts to review reports and obtain continuous feedback.
• Developed SSIS packages to import the data from CSV Files, Text files and Excel spreadsheets.
• Hands on experience in using different transformations like Script task, Fuzzy Lookup, Derived column, Conditional split and Multicast transformation using SSIS.
• Created SSIS packages to load data into Data Warehouse using Various SSIS tasks which includes execute SQL task, bulk insert task, data flow task, file system task.
• Working on C# Scripting to create packages in SSIS based on Client requirements.
• Working on resolving bug fixes in queries, reports and packages which leads to report failure and incorrect data.
• Implemented multidimensional cubes with MDX calculations to support analysis needs and fast data retrieval.
• Extensively worked on Amazon reports conversions from Oracle source to SQL.
• Responsible for performing UAT on the reports after checking in the code into Team Foundation Server (TFS)/ Visual Studio Team Services and deploying the reports to production environment.
• Provide technical support and insight to the improve user experience and solve production issues.

Environment: s: MS SQL Server 2015/2012, SQL Server Analysis Services, Report Builder 3.0, SQL Developer, impromptu reports, online visual studio

Confidential, NewYork

SQL BI Developer

Responsibilities:

• Analyzed the Reports, Tables and ETL process, Various ETL Transformation tools were used for Control Flow and Data Flow tasks.
• Created SSIS packages for Uploading of different formats of files (Excel, Access, dbf) and databases (SQL server, Flat files) into the SQL Server data warehouse using SQL Server Integration Services (SSIS).
• Created packages using SSIS Designer for exporting heterogeneous data from OLE DB Source.
• Configured Server for sending automatic mails to the respective people when a SSIS package fails.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Designed and developed ETL process with SCD (slowly changing dimensions) with T-SQL, SSIS and VBScript.
• Extensively worked on Data Flow transformations like for each Loop Container, Execute process task, Transfer SQL Server Objects task, Transfer Jobs task, Transfer Logins task.
• Based on the required reports, identified various data sources and established the connections using SSIS and constructed data source view.
• Created SSRS reports using Report, Drop-Down, Multi-Valued Parameters and Debugging Parameter Issues in Matrix Reports and Charts.
• Generated reports that can handle dynamic grouping and dynamic sorting.
• Created drill down, drill through, sub reports and many more complex reports.
• Permitted access to the reports based on designation of the viewer like store manager or district manager or associate extra.
• Experience in using SSRS gateway service calls to and from SSRS reports.
• Experience in modifying SSRS rdl (XML) which is the primary role of SSRS gateway
• Involved in creating report models and applying row level security filters for report model.
• Created reports using stored procedure. Involved in scheduling, creating snapshots and subscriptions for the reports.
• Used SQL Server Profiler for troubleshooting, monitoring, and optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA.
• Used Pivot table to provide structure to Reports in proper manner like months etc.
• Designed different kinds of reports like Linked, cascaded and parameterized reports.
• Deployment of the developed reports on to the server for the end users.
• Deployed the developed reports and upgraded the system.
• Responsible for creating Tablix Reports, Matrix Reports, Parameterized Reports, Sub Reports, Linked Reports, and Reports using stored procedures using SQL Server Reporting Services 2012.
• Used SQL Server Agent for scheduling jobs and alerts.
• Worked on Key performance Indicators (KPIs), design of star schema and snowflake schema in Analysis Services (SSAS).
• Created reports by retrieving the data from cube using MDX reports.
• Created calculated measures and dimension members using multi dimensional expression (MDX), mathematical formulas, and user-defined functions.
• Developing OLAP cubes by identifying tables (fact and dimension), Data Source and Data Source Views, attributes and dimension members using SQL Server Analysis Services (SSAS).
• Built cubes for production application, Partitioned Cubes to decrease the processing time and increase the performance of the queries running on front end application using SSAS 2008.
• Written several SQL Scripts such as finding tables with Identity Columns, tables that do not have primary key in order to streamline the process of replication.
• Test data entry into Facets application in the test environment for creating groups, subscribers and family members. .

Environment: s: Windows server 2000/2003, MS SQL Server 2012/2008 R2, SQL Server Analysis Services, Report Builder 3.0, DTS, VMware, ASP.Net, C#, MVC, SQL Server Reporting Services and SQL Server Integration Services, Performance Point Dashboard Designer, MS SharePoint Server 2010.

Confidential

SQL BI Developer/SSIS/SSRS/SSAS

Responsibilities:

• Involved in writing stored procedures, Triggers, User-defined Functions, Views and Cursors for both Online and Batch requests handling business logic and functionality of various modules
• Involved in performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to Parallel data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases.
• Created SQL server jobs to execute SSIS packages according to the load type of the data.
• Involved in writing stored procedures to create table structures in stage and pulling data from metadata.
• Involved in creating marts and developing mart views used for the report building.
• Created SSIS packages templates to clean and load data to parallel data warehouse, including error handling and metadata management.
• Designed and deployed reports with Drill Down, Drill Through, Matrix Reports, Chart Reports and Drop down menu option and Parameterized and Linked reports.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports.
• Implemented Extraction Transformation and Loading (ETL) process by pulling large volume of data from various data sources using SSIS.
• Designed and developed SSIS Packages for loading data from text files, CSV files to SQL Server databases using SSIS.
• Scheduled the SSIS jobs using SQL server agent for daily, weekly and monthly loads.
• Migrated data between different heterogeneous sources such as Flat file, Excel 2012 using SSIS.
• Used different data flow elements like Flat File, OLEDB, Excel Sources, Destinations and Data Flow Transformations like Data Conversion, Conditional Split, Derived Column etc.
• Deployed different SSIS packages on test and production servers.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user environments.
• Created Clustered and Non Clustered Indexes on tables for performance optimization of complex stored procedures.
• Did lot of Performance Tuning by using unblocking Transformations and row transformations for better performance of SSIS packages.
• Created the SQL server users and file server users with required permissions by including them in the scripts.
• Created Cross-Tab reports, Summary reports by using SSRS and designed reports using Crystal Reports.
• Worked on SSIS script task, look up transformations and data flow tasks using T- SQL and C# scripts.
• Created Master SSIS templates for Dimensions and Facts.
• Used various control flow tasks such as FTP, bulk insert task, transfer job task and different data flow tasks.
• Configured Server for sending mails when a SSIS process fails.
• Used the SSIS Configuration files to make the packages connections, variables etc. configurable and maintained the same on Test and Production environments.
• Involved in designing reports and delivering them by any of the delivery methods like standard subscriptions, data-driven subscription, URL access etc
• Experience in using SSRS gateway service calls to and from SSRS reports.
• Experience in modifying SSRS rdl (XML) which is the primary role of SSRS gateway.

Environment: SQL Server 2012, SSIS (2012), SSRS (2012),SSAS, T-SQL, SSMS, Maestro Jobs, Visual Studio 2010/2013, MS Excel 2010, Power Designer.

Confidential - Plano, TX

SQL Server Developer |SSIS|SSRS Developer

Responsibilities:

• Involved in writing stored procedures, Triggers, User-defined Functions, Views and Cursors for both Online and Batch requests handling business logic and functionality of various modules
• Did SQL performance monitoring and tuning of reporting data by optimizing indexes and stored procedures
• Involved in performance tuning of T-SQL queries and Stored Procedures.
• Generated multiple Enterprise reports using SSRS from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports (Hyperlink) etc.
• Created different Parameterized Reports (SSRS 2000/2005/2008 /2012) 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 consisted of different parameter types like hidden, internal, default (queried and non-queried parameters).
• Created Ad-Hoc Reporting with Report Builder and Programming Reporting Services.
• Designed and deployed reports with Drill Down, Drill Through, Matrix Reports, Chart Reports and Drop down menu option and Parameterized and Linked reports.
• Generated parameterized queries in SSRS 2008 R2/2012 using data from SSAS Cubes and various heterogeneous data source
• Worked on all types of report types like tables, matrix, charts, sub reports etc.
• Implemented Extraction Transformation and Loading (ETL) process by pulling large volume of data from various data sources using SSIS.
• Designed and developed SSIS Packages for loading data from text files, CSV files to SQL Server databases using SSIS.
• Scheduled the SSIS jobs using SQL server agent for daily, weekly and monthly loads.
• Migrated data between different heterogeneous sources such as Flat file, Excel 2005 using SSIS.
• Used different data flow elements like Flat File, OLEDB, Excel Sources, Destinations and Data Flow Transformations like Data Conversion, Conditional Split, Derived Column etc.
• Deployed different SSIS packages on test and production servers.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user environments.
• Created Clustered and Non Clustered Indexes on tables for performance optimization of complex stored procedures.
• Did lot of Performance Tuning by using unblocking Transformations and row transformations for better performance of SSIS packages.
• Upgraded existing packages developed using SSIS 2005 to SSIS 2008 packages.
• Developed various types of reports like Drill down, Drill through and parameterized reports using SQL Server Reporting Services 2008 R2/2012.
• Involved in development &Deployment of SSAS Cubes and Monitor Full and Incremental loads and support any issues.
• Create ad-hoc SQL queries for customer reports, executive management reports
• Created Reports, Report model Definitions, Scorecards, KPIs, and Dashboards utilizing Performance Point Server 2007/SharePoint Server

Environment: SQL Server 2012, SSIS (2012), SSRS (2012), Maestro Jobs, Visual Studio 2010/2013, MS Excel 2010, Power Designer.