We provide IT Staff Augmentation Services!

Sql Bi Developer Resume

Charlotte, NC

SUMMARY

  • Around 6 years of IT Experience in System Design, Development and Support of Microsoft SQL Server 2014/2012/2008 R2/2008/2005 in Development, Data warehouse, Test and Production Environments on various business domains like Financial, Insurance and Health Care.
  • 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.
  • Experience in OBIEE tool to build Data model based on business requirements and generating reports to business / IT Customers.
  • 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...
  • Set up the OD I connection with Oracle, oracle SQL Server and flat files
  • Extensively worked on developing Data model based on STAR schema concept using OBIEE 11g Administration Tool for current and future reporting requirement .
  • 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.
  • Experienced in Huge data migrations, huge data transfers, ETL processes using SSIS, DTS for Data warehouse implementation Projects involving conversion of data from heterogeneous sources like DB2, and Oracle, Sybase, Teradata.
  • 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.
  • Extensively knowledge on Informatica Designer Components - Source Analyzer, Warehousing Designer, Transformations Developer, Mapplets and Mapping Designer.
  • 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 building Business Intelligence and Corporate Performance Management solutions including Dashboards, Score Cards, Query & Analysis reports and KPI using SharePoint 2010.
  • 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.
  • Involved in migration projects from SQL Server to Hadoop

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

ETL 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, Charlotte, NC

SQL BI Developer

Responsibilities:

  • Delivered high quality, innovative BI solutions in a fast-paced environment.
  • Designed and developed ETL solutions for multiple source systems.
  • Designed, developed and supported BI-related database applications spanning multiple lines of business.
  • Performed complex data analysis to identify trends, patterns, and opportunities.
  • Created SSIS packages to extract, load and transform the data from flat files to database tables, API to database
  • Extensively for the Pre-Prime product team.
  • Strong SQL Server Development skills including writing Transact-SQL (T-SQL) Queries, Stored Procedures, User Defined Functions (UDF), Views, Calculation Views, Indexes, and User Defined Data Types strictly following the Data Integrity using Constrains, Rules and Default.
  • Experience in performance tuning, query optimization, Database Maintenance plans.
  • Performed Unit & IT testing& conducted UAT sessions with end users.
  • Responsible for developing processes automation of maintenance jobs, tuning SQL Server, locks and indexes configurations.
  • Use Cosmos products in developing internal applications and presentations.
  • Experiences in developing Normalization, Stored Procedures, Views, ETL processes, relational database theory and Complex Queries on SQL Server 2016/2014/2012 .
  • Used multiple transformations in SSIS to meet the business requirements by extracting data from transactional source systems, transform and finally load into the Staging Data base.
  • Worked in designing Cubes in OLAP and identifying the Fact and Dimension tables.
  • Used SQL Server Profiler to monitor the performance, Debug Transact-SQL statements and stored procedures in existing application, to identify slow running query etc.
  • Migrated data from DAX system to SQL Server data warehouse and to generate the reports using Cognos for different Cubes.
  • Created Complex calculated columns using DAX to meet the goals of the client.
  • Excellent in creating reports with SQL Server Reporting Services (SSRS) and Power BI
  • Used SSRS and power BI to create reports, Parameterized Reports, Drill down & Drill through Reports, Ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
  • Experience in creating Parameterized Reports using Dynamic SQL i.e. Stored Procedures.
  • Provided reporting and analytic solutions to the organization in the form of Reporting Services reports and Analysis Services cubes.
  • Using the above query results from Cosmos, creating reports in Power BI, Adspulse to show the metrics by server and procedure name, by server etc.
  • Managed complex issues quickly using problem solving techniques such as problem (KT), process and data analysis
  • Developed the T-SQL programs and Involved in performance tuning of SQL queries and stored procedures using SQL techniques and queries for faster retrieval.
  • Involved in performance tuning of SSIS Packages.

Environment: SQL Server 2016/2014/2012 , OLTP, PL/SQL, OLAP, SSIS, SSRS 2008R2, 2012, 2014, Power Shell, Power BI, Windows Server 2008, VS 2010/2012, Power BI, T-SQL, and Excel.

Confidential, Milpitas, CA

SQL BI Developer

Responsibilities:

  • Created complex Views, Stored Procedures, Triggers, Functions, Indexes, Tables, SQL joins and other T-SQL code to implement business rules for Izenda reports, Tableau reports and SSRS reports. Implemented different types of constraints on tables for consistency.
  • Analyzed reports and fixed bugs in stored procedures on the ongoing database operations, as needed, to resolve business problems.
  • Created shell scripts to kick off Informatica workflows and PL/SQL procedures.
  • 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.
  • Defined Data Warehouse solution and BI solution using OBIEE.
  • Created Variables, Expressions for Connection String, Project Parameters, Package Configuration, Parent package variables. Worked on Project level deployment in TFS 2013.
  • Used VB script in script components for data transformations and Used ASP.NET Globalization for the application to work for multiple cultures.
  • Extensive experience in working with .NET and SQL CLR programming.
  • Documented design and development works for creating views, stored procedures or SSIS packages pertaining to Izenda or Tableau reports deployment, uploaded reports into SharePoint site.
  • 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.
  • Creating Test cases for Unit Test, System Integration Test and UAT to check the data in OBIEE reports and dashboards
  • 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
  • Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Talend Integration Suite.
  • Created Talend mappings using the Transformations.
  • Created Talend jobs to copy the files from one server to another and utilized Talend FTP components
  • Prepared ETL mapping Documents for every mapping and Data Migration document for smooth transfer of project from development to testing environment and then to production environment
  • 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.
  • 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
  • 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
  • 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.
  • Created SSIS packages to extract data from OLTP to OLAP systems and scheduled Jobs to call the packages and Stored Procedures.
  • 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.
  • Developed the code behind using VB.NET
  • Deployed Azure SQL databases and other Azure settings using PowerShell and Json
  • Involved in migration projects from SQL Server to Hadoop

Environment: MS-SQL Server 2012/2008R2/2012/2014, informatica, 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), OBIEE, Team Foundation Server (2013)

Confidential

Sr. SQL BI Developer

Responsibilities:

  • Worked on SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures.
  • Developed SSIS Templates which can be used to develop SSIS Packages such a way that they can be dynamically deployed into Development, Test and Production Environments.
  • Experience in migration of parts from Visual source safe (VSS) 2005 to Team foundation server (TFS) 2010.
  • Designed data models using Erwin. Developed physical data models and created DDL scripts to create database schema and database objects.
  • Involved in performance tuning using indexing (Cluster Index, Non Cluster index) tables.
  • Worked on other packages of the SQL server 2008 Edition SSRS (SQL Server Reporting Services), SSAS (SQL Server Analysis Services).
  • Performed ETL using SSIS by extracting data from various data sources such as MS Access, Excel, Flat files, CVS files and network locations
  • Designed and developed Star and Snow Flake Schema as a data analyst.
  • Involved in Data modeling, designing and building relational databases.
  • Created components, tools, techniques, methods and procedures used in an on On-Line Analytical Processing (OLAP) environment for accessing and translating data into understandable and usable business information using SSAS
  • Migrated and recreated existing Dimensions and Cubes using Star schema on 2008 Server to achieve the efficiency of SQL Server Analysis (SSAS).
  • Performed tune to optimize SQL queries using SQL profiler and query analyzer.
  • Created reports with Analysis Services Cube as the data source using SQL Server 2008/2008R2 Reporting Services.
  • Involved in developing and modifying XML reports for exporting the reports to web application.
  • Used Generics extensively in C# and ASP.NET Menu Controls
  • Involved in providing information to functional segments of the organization using Data marts.

Environment: SSIS, SSRS, SSAS, MS SQL Server 2008 R2,OLAP, ERWIN, Front Office 8.3 / 10.2 / 10.3 , Windows 2008, MS Office 2010, TFS 2010.

Hire Now