SUMMARY

• 5+ years of experience in analyzing, designing, tuning and developing Client/Server, Business Intelligence (BI) database applications and various segments of Software Development Life Cycle(SDLC) using MS SQL Server 2014 /2012/2008 R 2/2008/2005/2000 DTS/SQL Server Integration, Reporting & Analysis Services.
• Extensive SQL Development experience in Banking, Insurance, Healthcare and Telecommunication industries with a strong understating of data & analytics.
• Extensively worked with Team Foundation Server 2012.
• Extensive experience in MS SQL Server 2014/2012/2008 R 2/2008/2005/2000 , BI tools like SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS).
• Developing reports on SSAS & SSRS on SQL Server (2005/2008 R2/2012). Sound Experience and understanding of SSAS, OLAP cube and Architecture.
• Performed Relational Data Modeling, ER Diagrams (forward & reverse engineering), dimensional modeling, OLAP multidimensional Cube design & analysis, define slowly changing dimensions and surrogate key management.
• Azure SQL Automation using PowerShell /runbook for back up, service tier change, performance tuning
• Highly proficient in the use of T - SQL for developing stored procedures triggers and various database objects.
• Worked extensively on Power BI desktop and Power BI Service.
• Well versed in OLTP Data Modeling, Data warehousing concepts.
• Extensive experience in extracting, transforming and loading data using SQL Server Integration Services 2008 R2/ 2012. Extracted data from, and loaded data into different types of databases and files including OLEDB, ADO.net, excel, flat files, XML and web service sources/destinations.
• Experienced in creating SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all etc...
• Extensive experience in working with Tableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau 8.2 8.1, 8.0, Tableau 7 and Tableau 6.
• Strong Experience in ETL Process Design/Development/Deployment using Talend Open Studio.
• Experience in using Talend Big Data components to create connections to various third-party tools used for transferring, storing or analyzing big data, such as HDFS Components, Hive, Sqoop, MongoDB and BigQuery to quickly load, extract, transform and process large and diverse data sets.
• Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), DTS, Bulk Insert and BCP
• Experience with performing various SSIS data transformation tasks like Look-ups, Fuzzy Look-ups, Checksum, Conditional Splits and Event Handlers, Error Handlers etc
• Interpreting and working with data models, data flows and data dictionaries, logical & physical Data modeling, Normalization and De-Normalization techniques for both OLTP and OLAP systems.
• Highly skilled in developing OLAP cubes using SSAS 2005/2008/2012/2014 , calculating measures, measure groups and dimension members in SQL Server Analysis Services using multi-dimensional expression (MDX), mathematical formulae, and user-defined functions
• Proficient in T-SQL programming
• Extensively used ASP.NET Data Grid, Data List, Repeater controls and Telerik controls for displaying the data in a clear format
• Expertise in building data warehouses based on star or snowflake schemas, data marts, and staging areas.
• Proficient with SQL Reporting Services 2005/2008R2/2012 such as, building tabular report, matrix report, chart report, parametric reports, linked reports using report designer/report builder 3.0.
• Expertise in creating complex reports like Drill Down and Sub Reports using SQL Server Reporting Service (SSRS).
• Proficient with SQL Analysis Services 2005/2008 R2 such as, building multi-dimensional cubes, Dimensions, fact tables, Hierarchies, levels, roles, performed drill-up, drill-down, and drill-through and applying cube security. Wrote Multidimensional Expression (MDX) queries to extract data from cubes
• Experience in executing software lifecycles such as Agile (Scrum), RUP Iterative Model, Incremental Model, Waterfall and Object Oriented Methodologies.
• Involved in the designing, development and maintenance of the tracking tools using .net, C#, VB.net, VB.net, ADO.net.
• Extensive knowledge of data warehousing concepts and data integration.

TECHNICAL SKILLS

Languages: SQL, Transact SQL, PL/SQL, Embedded SQL, C, C++ Java, J2EE, ASP.NET,C#.NET,VB.NET,HTML 4.0, DHTML,XML

Databases: SQL Server 2012/2008 R 2/2008/2005/2000 , SharePoint, Oracle 9i/8.x, DB2, MS Access

Reporting Tools: SQL Server 2012/2008R2/2005 Reporting Service (SSRS), Crystal Reports XI/10/9, POWER BIETL Tools: SSIS (SQL Server 2005/2008/2008 R2, 2012 Integration Services),SQL Server 2000 DTS, Import Export Data, Bulk Copy Program (BCP)

Other Software: MS Office- 2010/2007/2003/2000 , MS Project Adobe Professional.

Operating Systems: Windows (updated to 2012), MAC OSX Tiger/Leopard, Unix, Linux (Ubuntu updated to 12.04)

Database Tools: SQL Query Analyzer, SQL Enterprise Manager, Management Studio, SQL Server 2008 Query Editor, Solution Explorer, Analysis Manager, Reporting Server

Methodologies: Logical and Physical Database Design, UML, Database Design and Normalization, Data Modeling

PROFESSIONAL EXPERIENCE

Confidential, Arkansas

BI Developer

Responsibilities:

• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules. Implemented different types of constraints on tables for consistency.
• Created customized dashboard and report sharing using Power BI with claim lag and network summary report for the sales team to analyze trends.
• Generated Reports using Global Variables, report expressions (including simple VB codes) and Functions. Designed complex reports like dynamically driven parameterized reports, reports with sub reports, drill through reports using SQL reporting services 2012.
• Wrote complex T-SQL quires per business requirements.
• Created complex T-SQL Queries, Stored Procedures, Indexes, Functions and Views to support efficient data storage and manipulation.
• Analyzed reports and fixed bugs in stored procedures on the ongoing database operations, as needed, to resolve business problems.
• Created several SSIS packages for extracting data from data bases like SQL, DB2 and load those data into tables in SQL server
• Published Power BI Reports to the APP Workspace and create the APPs for the Users to consume the developed reports.
• Used various transformations such as Lookups, Multicasts, Pivots, Derived Columns, Merge joins, Conditional splits etc. when data transformations process was done.
• Responsible for ETL operation using SQL Server Integration Services (SSIS) and worked with users in training and support.
• Migrated SSIS packages from SQL 2008R2 to SQL 2012.
• Designed SQL SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL Server 2014 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 .
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc.) and loaded the data into target data sources by performing different kinds of transformations like Conditional Split, Derived Column, Data Conversion, Look Up, and Merge Join as required using SQL Server Integration Services (SSIS
• Used ETL to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse
• Setup ETL Framework, best practices around Talend for data integration implementation
• Worked extensively on design, development and deployment of Talend jobs to extract data, filter the data and load them into Datawarehouse
• Created Talend jobs to copy the files from one server to another and utilized Talend FTP components
• Worked with the testing team to resolve bugs related to ETL mappings before production
• Created ETL packages to validate, extract, transform and load data from various data warehouses to databases/data marts .
• Designed and implemented SSAS Tabular Cube & Multidimensional Cubes as the reporting layer and used DAX scripting to access data from Tabular Model and MDX for Multidimensional Cubes
• Created complex SSAS Cubes with multiple fact measure groups and multiple dimension hierarchies based on the OLAP Reporting needs
• Look up transformation was used to check whether data is already in the source table before inserting. SQL task was used to truncate or delete tables before loading data.
• Developed several Linked, Cache and Ad hoc SSRS reports for Underwriting and Sales departments.
• Scheduled jobs to run Daily, Monthly and Quarterly bases.
• Worked on closing several tickets by creating the stored procedures and views for SSRS, Analytical and IBI reports.
• Developed the code behind using VB.NET
• Created several visualizations and featured dashboards using Power BI for Underwriting Team for Fully funded group reports.
• Played the dual role of Analyst and Developer gathering requirements from VP, analyzing the data and developing SSIS packages and SSRS reports.
• Worked on Cube structure optimization for MDX query performance in Analysis Services 2012 (SSAS) for Healthcare Cost, Financial Summary and in-Network and out-Network packages.
• Documented and uploaded the design and development of several SSIS packages and SSRS reports in the share point.
• Configure database replication from on premises to Azure SQL DB
• Used VB script in script components for data transformations and Used ASP.NET Globalization for the application to work for multiple cultures.

Environment: MS-SQL Server 2012/2014, MS-SQL Server Reporting Services, MS-SQL Server Integration Services, Windows Server 2012, VB.NET,ASP.NET,MS-SQL Server Analysis Services, Azure,T- SQL, MDX, Source Safe, Team Foundation Server (2012), Team Foundation Server (2013)

Confidential

SQL BI Developer

Responsibilities:

• Analyzed reports and fixed bugs in stored procedures on the ongoing database operations, as needed, to resolve business problems.
• Created several SSIS packages for extracting data from data bases like SQL, DB2 and load those data into tables in SQL server to create final Roster report.
• Designed DDL and DML for MS SQL Server 2008R2/2012.
• Created Variables, Expressions for Connection String, Project Parameters, Package Configuration, Parent package variables. Worked on Project level deployment in TFS 2013.
• Worked on various mingle tasks for different sprints contributing for hyper loop process and Bullet train.
• Created different SQL jobs and maintained those jobs in the production.
• Wrote custom T-SQL stored procedures and triggers to improve performance, preserve referential integrity, and provide additional application functionality.
• Working experience in BI Solutions (ETL & Reporting) using SSIS and T-SQL Programming using DDL, DML, DCL commands for various business applications
• Worked on the cube deployment and star schema deployment to different data bases.
• Performed tune to optimize SQL queries using SQL profiler and query analyzer.
• Worked on deploying the code and unit testing in different team environments.
• Involved in performance tuning using indexing (Cluster Index, Non Cluster index) tables.
• Created complex Stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL.
• Develop staging tables and created indexes in the destination table in order to make the ETL process faster than expected.
• Used ETL to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse
• Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using tableau desktop & publish them to server
• Developed different kinds of reports/Ad-hoc queries using Siebel Answers and assigned them to application specific dashboards using Tableau desktop
• Created Data marts for Staging and Production databases for Operational Data Stores (ODS).
• Worked on Tabular Data warehouse and DAX operations for SSAS 2012 and 2008 OLAP databases.
• Deploy the packages in production server and schedule the packages according to the requirements.
• Worked on Integration of HLC reports with Tableau.
• With the help of visualizations in Power BI, created various visualization like Pie charts, Bar graphs, Tree maps etc., that will helpful easily to understand the data.
• Wrote MDX queries and KPI’s using SQL server 2008/2012 SSAS.
• Created org Hierarchy for the process of authorization and authentication for accessing Tableau reports by end user.

Environment: MS-SQL Server 2012/2008R2/2012/2014, MS-SQL Server Reporting Services, MS-SQL Server Integration Services, Windows Server 2012, VB.NET, ASP.NET, MS-SQL Server Analysis Services, AZURE, T- SQL, MDX, Source Safe, POWER BI, Team Foundation Server (2012), Team Foundation Server (2013)

Confidential

SQL BI Developer

Responsibilities:

• Designed relational data base in SQL server for Line Management section. Applied data integrity rules, defined relationships between foreign and primary keys in the tables.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules. Implemented different types of constraints on tables for consistency.
• Created stored procedures, Cursors, Joins in T-SQL.
• Used T-SQL in SQL Server 2012 to develop Stored Procedures, Triggers, Clustered & Non-clustered Indexes, Views, Indexed Views, and User-Defined Functions (UDFs).
• Generated Reports using Global Variables, report expressions (including simple VB codes) and Functions. Designed complex reports like dynamically driven parameterized reports, reports with sub reports, drill through reports using SQL reporting services 2008.
• Analyzed reports and fixed bugs in stored procedures on the ongoing database operations, as needed, to resolve business problems.
• Created different Parameterized Reports (SSRS 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.
• Created several SSIS packages for extracting data from data bases like SQL, DB2 and load those data into tables in SQL server
• Used various transformations such as Lookups, Multicasts, Pivots, Derived Columns, Merge joins, Conditional splits etc. when data transformations process was done.
• Responsible for ETL operation using SQL Server Integration Services (SSIS) and worked with users in training and support.
• Designed SQL SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL Server 2014 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 .
• Designed Visual Reports and interactive Dashboards in Tableau
• Designed and implemented SSAS Tabular Cube & Multidimensional Cubes as the reporting layer and used DAX scripting to access data from Tabular Model and MDX for Multidimensional Cubes
• Created complex SSAS Cubes with multiple fact measure groups and multiple dimension hierarchies based on the OLAP Reporting needs
• Look up transformation was used to check whether data is already in the source table before inserting. SQL task was used to truncate or delete tables before loading data.
• Worked in SQL Server Analysis Services (SSAS) OLAP Cubes, and Mining, Involved in Analyzing, Designing, Building and testing of OLAP Cubes using SQL Server Analysis Services (SSAS)
• Added SQL Server Providers for logging to capture information about a package at run time, making it easier to troubleshoot package performance and failure. Performed package, container, and task level logging.
• Experience in working on Cube structure optimization for MDX query performance in Analysis Services 2012/2008 (SSAS)
• Worked on deployment of ROLAP using binding as well as deployment of ETL objects to target schema.
• Reports writing based on tickets submitted from front end people using SQL Server Reporting Services (SSRS) and Crystal Reports 8.0.
• Created Variables, Expressions for Connection String, Project Parameters, Package Configuration, Parent package variables. Worked on Project level deployment in TFS 2012.
• Worked with vb.net developers to create reports which can be accessed by portals.
• Created various SSIS configuration settings including SQL Server and XML configuration files. Implemented Check Points to restart execution of failed packages only from the point of failure instead of re-running the whole package from the start.
• Developed reports like Claim Statements, Fee Bills Transactions and some end request user reports on periodic basis.
• Generated SSRS report form SSAS OLAP Cube.
• Querying and manipulating multidimensional cube data through MDX Scripting in SSAS.
• Documented design and development works for report deployment, uploaded reports into SharePoint site, created new pages and folders and maintained reports in SharePoint site.
• Improved the performance of queries by introducing clustered and non-clustered indexes on tables in the data base. Use SQL profiler to identify long running queries.
• Created different SQL jobs and maintained those jobs in the production.
• Used Ralph Kimball’s Data Modeling concept when designing an OLAP cube for Line Management section. Created dimension and fact tables. Created SSIS packages and stored procedures to load those dimension and facts tables.
• Worked on star schema and snowflakes deployment process coordinating with the DBA’s
• Partitioned the cube for current year and previous years in order to improve the performance.
• Created MDX queries to create custom pivot reports and calculated members in the cube.

Environment: MS-SQL Server 2012/2008R2/2012, MS-SQL Server Reporting Services, MS-SQL Server Integration Services, Windows Server 2012, POWER BI, VB.NET,ASP.NET,MS-SQL Server Analysis Services, T- SQL, MDX, Source Safe, Team Foundation Server (2012)