We provide IT Staff Augmentation Services!

Sql/bi Developer Resume

Lansing, MI

SUMMARY:

  • Around 7 years of experience with SQL and MSBI. Good exposure with all star schemas, snow flake schema, data modeling and work with different data warehouse projects.
  • Proficient in SQL Server, developing complex store procedures, views, efficient triggers , required functions , creating indexes .
  • Good in creating Sub - Queries and Joins for complex queries involving multiple tables and Exception Handlers.
  • Experience across entire MSBI products including SQL, SSIS, SSAS, SSRS and PowerBI.
  • Expert in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS).Extracted, transformed and loaded data from various heterogeneous data sources and destinations like Access, Excel, CSV, Oracle, flat files.
  • Expert in Creating, configuring and Fine-tuning SSIS packages, SSRS reports and T-SQL queries using tools like SQL profiler Monitoring tool.
  • Experience in creating jobs, alerts, SQL mail agent, and schedules for SSIS Packages in SQL Server Agent.
  • Excellent experience in Designing, Maintaining and tuning various RDBMS like T-SQL &MS SQL Server and MS Access databases.
  • Highly proficient in using T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Functions, User profiles, Relational Database Models and data Integrity, SQL joins and query Writing.
  • Strong experience in Database Installation, Capacity Planning, Implementing Backup and Recovery Strategy for application and database.
  • Involved in Query Optimization and Performance Tuning using SQL Profiler.
  • Involved in performing Unit Test, Regression Test, Functional Test, integration Test, Stored Procedure Performance Test, on Test server and preparing combined Developer Training document along with waterfall, Spiral and Agile methods with full SDLC (Software Development Life Cycle).
  • Proficient in creating dynamic packages for Incremental Loads and Data Cleaning in Data Warehouse using SSIS.
  • Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
  • Extensively worked on creating data source and data source views and developed SSAS Cubes , dimensions, Measures, KPI’s and Deployed SSAS objects using SQL Server Analysis Services(SSAS) .
  • Build, published customized interactive reports and dashboards, report scheduling using PowerBI.
  • Created action filters, parameters and calculated sets for preparing dashboards and worksheets in PowerBI.
  • Developed tableau visualizations and dashboards using tableau desktop.
  • Worked on unit testing the reports using Power Pivot in Excel and Visual Studio.
  • Developed tableau workbooks from multiple data sources using data blending.
  • Good exposure with creating reports like Table report, sub report, Matrix report, Chart Report, Pie charts, Drill Down, Drill-through, Ad hoc reports and Cascading reports using SQL server reporting services(SSRS).
  • Worked on ad hoc requests for information from systems and assists with configuration of reports in a timely, efficient, and accurate manner.
  • Developed in-depth understanding of underlying data, data structures, and business uses to ensure reports meet client needs.
  • Worked with DBA’S monitored daily jobs for all environments and resolved the bugs if job fails.
  • Self-motivated and possess ability for critical thinking, analysis, good interpersonal and communication skills. Team-oriented, technically motivated and creative. Result-oriented with a desire to learn client's business requirements.
  • Strong inclination for finishing job before project deadline. Flexible and versatile to adapt to any new environment and work on any project.

TECHNICAL SKILLS:

SQL Server Tools: SQL Server Management Studio, SQL Server Business Intelligence Development Studio

Languages: C/C++, C#. NET, T-SQL, My SQL, HTML, CSS, JAVA Script, XML

Operating Systems: Windows Server 2000, Windows Server 2003, Windows XP, Windows 2008, Unix.

MS: SQL Server, MS Access.

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

Reporting Tools: SSRS, SSAS, Power BI, Crystal Report, Excel reporting

DB Utilities and design tools: SQL Server Management Utility, Query Analyzer, SSAS Cubes, MDX scripting.

Application Software: Visual Studio, MS Office, MS Visio.

Methodologies: Agile, Waterfall

WORK EXPERIENCE:

SQL/BI Developer

Confidential, Lansing, MI

Responsibilities:

  • Installed and configured new SQL Servers.
  • Developed SQL Server Stored procedures and DTS packages to extract data from database.
  • Wrote T-SQL queries, Store Procedures and used them to build packages.
  • Monitored server critical issues including Response Delay, Locking/Blocking and Server Downtime.
  • Creation and Management of Jobs, Schedules and Sending Alerts using SQL Mail
  • Created complex Stored Procedures and Cursors to support applications using T-SQL.
  • Developed detail and summary financial reports, line and pie chart, trend analysis reports and sub reports according to business requirement using Power View /Pivot Table, Report builder and SSRS and Tableau.
  • Developed custom reporting solutions using Tableau.
  • Business Intelligence solution design, development and process documentation to produce required reporting and analytics deliverables using Tableau
  • Employed Filtered Indexes to improve query performance and reduce the storage and maintenance cost.
  • Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS SQL Server 2012.
  • Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
  • Worked on Key performance Indicators (KPIs), design of star schema and snowflake schema in Analysis Services (SSAS).
  • Designed and developed Data Warehouses, Data marts using multi-dimensional models such as Star Schemas and Snow Flake Schema for developing Cubes using MDX.
  • Participated in designing and developing Data Warehouses, Data marts and cubes in Business Intelligence environment using multi-dimensional models such as Star Schema.
  • Implemented data mart, facts, dimensions, star schema and OLAP cubes based on dimensional modeling standards using SQL Server Analysis Services (SSAS).
  • Designed and implemented complex SSIS package to migrate data from multiple data sources for data analyzing.
  • Developed data access queries/programs using SQL Query to run in production on regular basis and assists end users with development of complex Ad Hoc queries.
  • Improved Performance by creating Clustered and Non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler.
  • Responsible for performance tuning, optimizing the queries, removing redundant and inconsistent data, joins from the database tables and normalizing them.
  • Ensured best practices are applied and integrity of data is maintained through security and documentation.
  • Worked on writing C# code for deploying SSIS packages. Worked on troubleshooting issues on ASP.Net Code and modified the code.
  • Worked on Data migration through standard procedure by freezing the applications or dashboards on the front-end, which are affected by the change.
  • Maintained backup copy for any changes like Data Migration or if something changed on the source which may affect the dashboards in daily ETL loads.

Environment: MS SQL Server 2016, SSIS, SSRS, MS Visio, T-SQL, Visual Studio 2012, MS Office, Team Foundation Server (TFS),C# and ASP.Net, tableau.

SQL/BI Developer

Confidential, Quincy, MA

Responsibilities:

  • Used SSIS with special focus on creating Extract Transform Load (ETL) packages that process data into data warehouse and cubes.
  • Created different transformations like data Conversions, lookups, derived column transformations etc, for data cleansing to remove unnecessary columns, eliminate redundant, inconsistent data and unnecessary Data like removing empty rows using SSIS.
  • Created SSIS containers to loop through file collections to load and process customer data and deployed SSIS package to end user.
  • Created SSIS package in which records were loaded daily, also from other data resources such as Excel, Access, flat file, and XML to create and maintain a centralized data warehouse.
  • Migrated data from Oracle, Excel, flat files, MS Access to MS SQL server using DTS and SSIS.
  • Used FTP task, ETL Script task, lookup transformation and Data flow task to load staging databases in SSIS.
  • Created cubes in star and snowflake schemas, applied partitions, aggregations on it, used MDX to retrieve data using SSAS.
  • Designed and implemented data warehouses and data marts, Conformed Facts & Dimensions, Slowly Changing Dimensions, Star Schema, Snowflake Schema, etc.
  • Designed and implemented fact and dimension tables and OLAP cubes using dimensional modeling in SQL server analysis services (SSAS).
  • Created sub report, On-demand, custom Ad-hoc reports using SSRS.
  • Designed and developed report layout including parameterized report, drill down, and drill through reports in SSRS.
  • Created SQL Server Reports for Management using SSRS. Tasks included defining requirements, design, develop, test, implement and maintain reports using SSRS.
  • Design and code high quality database solutions within a fast paced monthly release cycle.
  • Developed several reports with consistent drill-down functionality including Drilldown reports, Summary reports and Master Detail reports.
  • Developed Custom Functions, Manual Running Totals and Complex Formulas for reports.
  • Used breaks, calculations, sorts, filters and sections to enhance data presentation in reports.
  • Strong knowledge of using functions, and expressions in SSRS.
  • Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
  • Created cube structure for the analysis of business condition and for creation of report using SSAS.
  • Created drill down and sub reports from SSAS cubes that can be browsed on web.
  • Worked on with Report Manager, Report Builder and Reporting Security and Reporting Services Configuration manager.
  • Designed and created data extracts, supporting Power BI visualization tools reporting applications.
  • Created reports like Table report, sub report, Matrix report, Chart Report, Pie charts, Drill Down, Drill-through, Ad hoc reports using Power BI.
  • Designed Power BI data visualization data visualization utilizing tabs, map, and scatter plots.
  • Communicate and defend design, requirements, feature set, functionality, usability and limitations of subsystem to team and/or development lead or manager.

Environment: MS SQL Server, SSRS, SSIS, SSAS, T-SQL, MS-Excel, XML, Windows XP/10, powerBI..

SQL/BI Developer

Confidential, Boston, MA

Responsibilities:

  • Gathered requirements from business users and developed SQL stored procedures and SSRS Reports.
  • Created several SSRS reports like drill down, drill through and sub reports.
  • Imported and created relation between different data sources and between multiple tables using Pivot table.
  • Performed Stored Procedures, User Defined Functions, Views, TSQL Scripting for complex business logic.
  • Deployed SSRS reports to the reporting server and assisted in troubleshooting deployment problems as well as managed the subscription of the reports.
  • Extensively used Joins and sub-queries for complex queries involving multiple tables from different Databases.
  • Optimized the database by creating various clustered, non-clustered indexes and indexed views.
  • Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
  • Created logins, users and configuring permissions and assigning roles to users.
  • Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.
  • Used Execution Plan, SQL Server Profiler to trace the slow running queries and tried to Optimize SQL Queries for improved performance and availability.
  • Created and documented the mapping of the database objects from source to target database.
  • Managed very large reports that return a large volume of records and optimized their performance using techniques like cascading parameters and filters.
  • Generated reports using report Builder3.0 that could be used to send information to diverse group of users, clients, and managers.
  • Generated power reports in Excel 2013 for the users to as per user requirements along with BA.

Environment: SSIS/SQL, ERWIN 8 Data modeling tool, XML Schema, FTP, BIDS, Visual Studio.

SQL/BI Developer (SSIS/SSRS)

Confidential, Louisville, KY

Responsibilities:

  • Responsible for Installation, Configuration and Administration of SQL Server
  • Involved in interacting with business analyst for gathering requirements and developed T-SQL code and SSIS Packages accordingly.
  • Translated functional requirements into Technical specifications and Developed Stored Procedures and Complex SQL Queries.
  • Developed SSIS Packages using lookup transformation, file system task, and for each loop container.
  • Applied various data transformations like Aggregate, Sort, Multicasting, Conditional Split, and Derived column, etc.
  • Working knowledge on relational databases like SQL Server 2012/2008 R2/2005, T-SQL.
  • Responsible for timely communication of production issues with the respective stake holders.
  • Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
  • Successfully migrated data between different heterogeneous sources such as flat file, Excel and SQL Server 2008 using SSIS, and Bulk Insert.
  • Used Query Analyzer to optimize SQL Queries.
  • Created reports with Analysis Services Cube as the data source using SQL Server 2008 Reporting Services.
  • Created the automated processes for the activities such as database backup processes and SSIS Packages run sequentially using SQL Server Agent job.
  • Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
  • Assisted in production of OLAP cubes, wrote queries to produce reports using SQL Server 2012/2014 Analysis Services (SSIS) and Reporting service (SSRS).
  • Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.

Environment: SQL Server Data Tools 2014/2012, SQL SERVER 2014/2012, SQL Server Integration Services (SSIS), SQL SERVER Reporting Services (SSRS), Power Pivot in MS Office Excel.

MSBI Developer

Confidential

Responsibilities:

  • Translated functional requirements into Technical specifications and Developed Stored Procedures and Complex SQL Queries.
  • Responsible for timely communication of production issues with the respective stake holders.
  • Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
  • Successfully migrated data between different heterogeneous sources such as flat file, Excel and SQL Server 2008 using SSIS, and Bulk Insert.
  • Generated reports from the cubes by connecting to Analysis server from SSRS.
  • Created Dimensions with the cube wizard and also individually.
  • Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2008.
  • Created reports with Analysis Services Cube as the data source using SQL Server 2005/2008 Reporting Services.
  • Created the automated processes for the activities such as database backup processes and SSIS Packages run sequentially using SQL Server Agent job.
  • Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
  • Created Reports from Web Services and used MDX on Cubes in SSIS to create reports in SSRS.
  • Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.

Environment: SQL Server Data Tools, SQL Server Integration Services (SSIS), SQL SERVER Reporting Services (SSRS).

SQL Developer

Confidential

Responsibilities:

  • Worked with Business Analysts and Data Architects in analyzing business requirements, specifications and business requirement documents in order to define the optimal solution and identify responsibilities for delivering solutions for data loading and maintenance
  • Analyzed the business requirements and database architecture (Erwin), translated them into functional specification and built a Workload Report Application to summarize employees’ workload Upgrade Accounting, Human Resources Databases, Performing tuning activities
  • Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in different environments.
  • Created high level design of SSIS (ETL) Packages for integrating data from heterogeneous sources like flat file, CSV file, XML file by using Multiple Transformations provided by SSIS such as Aggregate, Slowly Changing Dimensions, Sort, Merge, Derived Column, Conditional Split, Lookup, Data Conversion and Union all.
  • Involved in daily, bi-weekly, semi-monthly, monthly, annual batch loads (Full & Incremental) into staging and ODS area, troubleshooting load issues and errors using SSIS.
  • Developed and created new database objects including tables, views, triggers, stored procedures, user defined functions, complex SQL Queries, clustered and non-clustered indexes to implement the business logic.
  • Generated reports using SSRS which were send to different Primary Vendors, Clients, and managers.
  • Created reports using Global Variables, Expressions and Functions using SSRS.
  • Designed and delivered dynamic reporting solutions using SSRS.
  • Extensively created SSRS reports such as Drilldown, Drill through, Matrix, Sub Reports, linked reports, Ad hoc reports as well as interactive reports and automated SSRS reports as per business user requirements and same has been configured in the Production Environment.
  • Designed and created Report templates, bar graphs and pie charts based on the financial data.

Environment: SQL Server 2008 R2, SSRS, T-SQL, MS-Excel, Windows NT/XP, MS SQL Reporting Services

Hire Now