We provide IT Staff Augmentation Services!

Sql / Bi Developer Resume

Burlington, MA

SUMMARY

  • Over all 7 + years of experience in Database Design, and Business Intelligence applications design, development, and Maintenance of Integration Services (SSIS), SQL
  • Server Reporting Services (SSRS), SQL Server Analytical Services (SSAS).
  • Expert in different components of SSIS (Control Flow, Data Flow and Connection Manager) while extensively using different kinds of Containers, Control Flow Tasks and various Transformations under data flow tasks.
  • Skillful in using Power Pivot to provide deep data analysis and using power view to create automatically updated dashboard
  • Ability to deliver comprehensive Business Intelligence through integration of BI suite of products (SSIS, SSRS, SSAS) including MS solutions like MS EXCEL 2007/2010, Microsoft Office.
  • Skilled in Data warehousing tools, Data Mapping, Unit Testing, Migration, Conversions, and Process Documentation.
  • Extracted, transformed and loaded data from various heterogeneous data sources and destinations like Access, Excel, CSV, Oracle, flat files using connectors, tasks and transformations provided by SSIS
  • Experience in various Extracting, Transforming and Loading ETL/SSIS data flow ETL/SSIS using SSIS.
  • Expert in generating reports using SQL Server Reporting Services (SSRS).
  • Expert in creating ad - hoc reports by using Report Builder in SSRS.
  • Proficient in writing the Stored Procedures, Triggers, Functions, Indexed Views.
  • Proficient in Data Warehousing methodologies and concepts, including Star schemas, Snowflake schemas, ETL processes, Dimensional modeling and reporting tools.
  • In-depth knowledge of T-SQL (DDL, DML, DSL, and SQL CMD), MDX and XQUERY ­­­(XML)
  • Experience in using Audit functions and extensively used Exception Handling for catching and reporting errors
  • Highly proficient in report writing using SQL Server Reporting Services like Table report, Matrix report, Chart Report, Pie charts, Drill Down, Cascading, Parameterized, Sub reports.
  • Worked with different types of Replication Models like Transaction, Snapshot, and Merge.
  • Experience working with tools like Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor
  • Skilled in Tableau Desktop for data visualization, Reporting and Analysis; Cross Map, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trails and Density Chart.
  • Implemented complicated transformations to be used in SSIS packages.
  • Actively involved in developing Complex SSRS Reports involving Sub Reports, Matrix/Tabular Reports, Charts, and Graphs
  • Expert in using tools such as Bulk Copy (BCP) and Data Transformation Services (DTS).
  • Well-versed with database installation, configuration, maintenance, monitoring, backups and recoveries, and developing stored procedures and triggers.
  • Have hands on experience in Performance Tuning and Query Optimization. Worked on identifying and resolving blocking and deadlocks
  • Worked with different types of Replication Models like Transaction, Snapshot, and Merge.
  • Strong analytical skills, proven ability to work well in a multi-disciplined team environment, and adept at learning new tools and processes with ease.

TECHNICAL SKILLS

Relational Databases: SQL Server 2016/2014/2012/2008 R 2/2008/2005/2000 , MS Access.

Tools: and Packages: SQL Server Management studio, SSIS, SSRS, SSAS, DTS, Microsoft Visual Source Safe, SQL Query Editor, TFS, Dell Boomi, Salesforce

Languages: T-SQL, HTML, PL/SQL, XML,SQL,C, VB.Net, ASP.Net, JSON, C#

Operating Systems: Windows vista/XP/2003/2000/NT 4.0/9x, MS-DOS

Web Technologies: HTML, XML, XSL, IIS(4.0/5.0/6/0)

Application Packages: MS Office, MS Outlook (Microsoft Office Suite)

BI Tools: SQL Server Reporting Tools (SSRS), SQL Server Integration Services (SSIS), SQL Server Analytical Services (SSAS), Performance Point Server 2007, Dell Boomi

PROFESSIONAL EXPERIENCE

SQL / BI Developer

Confidential, Burlington, MA

Responsibilities:

  • Involved in requirement gathering, analysis, design, development and deployment.
  • Created stored procedures to load data in different tables and created views to reduce database complexity for end users.
  • Maintained the physical database by monitoring performance using creating and analyzing trace files and optimize SQL queries for maximum efficiency using SQL Profiler, Data Engine Tuning Advisor and index tuning wizard.
  • As a team member, was responsible for database backups, database replication, database encryption and security.
  • Designed and implemented comprehensive backup plans and disaster recovery strategies to ensure high availability of data.
  • Created Subscription of Reports in different formats like pdf, excel to be executed automatically on daily, weekly or monthly basis using MOSS (Microsoft Office SharePoint Server) tool.
  • Used ASP.net for web application development.
  • Created composite data types (records, index by table), sequences, synonyms, functions, packages, cursors.
  • Worked on lots of Shell Scripts.
  • Involved in creation of logical and physical design of data warehouse and operational database store (ODS).
  • Created data warehouse schema to deploy fact and dimensions tables and defined referenced relationship with fact table and measure group.
  • Created, deployed and scheduled SSIS packages for data transfer, to run SQL tasks and scheduled jobs to run these packages at nighttime to feed fresh data to design support system (DSS).
  • Migrated and resolved conversion errors for Performance Point Server reports to SharePoint 2010 Business Intelligence platform.
  • Developing New columns & Measures using Power Query.
  • Refreshing Dashboards and reports in Power BI using Power BI Pro gateway.
  • Developed packages for loading the data from ODS to warehouse and applied transformations such as derived column, SCD etc. for data scrubbing and included data validation checks during staging.
  • Used Event handlers and logging for exception handling in SSIS.
  • Created, deployed cubes and worked on dimensions, measures, generating KPI, partitions, MDX queries using SSAS.

Environment: MS SQL Server 2014, Oracle 10g, MySQL, MS SQL Server Reporting Services SSRS 2012, MS SQL Server Integration Services SSIS 2012, SQL Server Analysis Services SSAS 2012, Microsoft Visual Basic, VB.NET, Team Foundation Server (TFS), XML, Agile.

Power BI Developer

Confidential, New York City, NY

Responsibilities:

  • Proficient in Data Warehouse concepts, OLTP, OLAP, Star Schema, Snowflake Schema, Fact and Dimension tables.
  • Worked on Key performance Indicators (KPIs), design of star schema and snowflake schema in Analysis Services (SSAS).
  • Proficient in creating joins for queries involving multiple tables.
  • 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).
  • Proficient with T-SQL to create Tables, Views and Stored Procedures.
  • Proficient in Normalization and De-Normalization of existing tables for faster query retrieval.
  • Strong knowledge in Power BI on how to import, shape, and transform data for business intelligence (BI), Visualize data, author reports, schedule automated refresh of reports and create and share dashboards based on reports in Power BI desktop.
  • Experience working with programming languages (SQL, PL/SQL, .NET, VBscript, MDX), programming techniques, Systems Development Life Cycle and system design techniques.
  • Created functions to provide custom functionality and enhanced performance as per the requirements
  • Generated Sub-Reports, Conditional, Drilldown reports, Drill through reports and parameterized reports using SSRS 2012.
  • Extensive experience in Agile environment and have experience with the Agile project management tools like Version one and JIRA.
  • Participated in Maintenance activities of SQL Azure. Writing stored procedures, functions and complex T-SQL queries in SQL AZURE Cloud.
  • Experience working with programming languages (SQL, PL/SQL, .NET, VBscript, MDX), programming techniques, Systems Development Life Cycle and system design techniques.
  • Created functions to provide custom functionality and enhanced performance as per the requirements.
  • Designed, developed and deployed reports, sub-reports, drill down reports, and drill through reports and parameterized reports and adding new features to the reports in MS SQL Server environment using SSRS.
  • Possess technical skills in defining Source and target metadata definitions for Source to Target mapping specification.
  • Used Script component using C#.Net to perform row by row transformations in data flow tasks Designed and developed SSIS packages to extract data from the transactional and/or operational databases, transformed the data according to analytical / reporting business needs, and loaded the data into a data warehouse or data mart.
  • Worked with subject matter experts (SME's) and project team to identify, define, collate, document and communicate the data migration requirements.

Environment: SQL Server 2014, Microsoft Visual Studio 2012, Windows 7, MS Office, Dax, SSIS, SSAS, SSRS, SharePoint, Power pivot, Power view, Power BI, Python.

BI Developer (ETL/Reporting)

Confidential, Daytona Beach, FL

Responsibilities:

  • Working in the Sapphire platform which is an in house Enrollment and Billing system which supports those functions for the over 65 Medicare market.
  • Involved in using existing reporting architecture which utilizes SQL Server 2012, SQL Server 2008 R2, SSIS and SSRS, with the operational data being extracted from an Oracle 10g database.
  • Responsible for the extraction of data and the creation and maintenance of new/existing reports.
  • Performed problem resolution and root cause analysis along with recommending and implementing preventive techniques.
  • Using Power Pivot to create the Pivot table and Pivot chart based on SSAS cube to provide deep data analysis.
  • Created many complex Stored Procedures/Functions and used them in Crystal Reports directly to generate reports on the fly.
  • Scheduled, maintained, and supported the distribution and access to reports through Crystal Server.
  • Manage the SharePoint 2013, edit the pages, add the web part, grant permissions to the users and configure the power pivot, SQL Report Server and cube for further development.
  • Ensure standardization of systems implementation, support techniques, and adherence to formal processes, change control, best practices, and total quality practices in all activities.
  • Accountable for providing production support for reporting, file transmissions, and associated Control M processes.
  • Involved in reviewing the E-commerce application and interacted with business users to understand the report requirements for creating documents like data dictionary and technical specs.
  • Worked in Agile Scrum Methodology with daily stand up meetings and great knowledge in TFS (Team Foundation Server) 2010.
  • Involved in migration of data form SQL SERVER 2008 to SQL SERVER 2012.
  • Worked on Visual Studio 2012 and Synced/loaded projects with TFS 2010.
  • Creating new/modifying existing programs based on technical design, unit testing, and collaborating with system testing organization in response to defects.
  • Used Visual Studio 2008 tool to design web based application and used ADO.NET to link the heterogeneous databases (like Oracle 9i using ODBC, SQL Server using OLEDB) to this application.
  • Working closely with business, regulatory and analysts, ensuring the organization is compliant with industry and government standards.
  • Experience with SQL Server Reporting Services (SSRS) to author, manage, and deliver both paper-based and interactive Web-based reports.
  • Good Understanding of CMS, Center for Medicare and Medicaid Services, procedures and policies.

Environment: SQL Server 2012, MS SQL Server 2008 Visual Studio, TFS, Visual Studio 2012, MS SQL Server 2008 Management Studio, T-SQL, SQL Server Integration Services (SSIS), SSRS, Power Pivot, VB Script, MS Access, Windows 2008/XP, MS Visio, Clear case.

SQL / BI Developer

Confidential, Fredrick, MD

Responsibilities:

  • Designed and Developed SSIS packages to import and export data from MS Excel, XML, SQL Server, Flat files using SSIS Package Configuration, Expressions, Logging, Event Handler.
  • Applied various data transformations like Lookup, Aggregate, Sort, Multicasting, Conditional Split, Derived column, etc.
  • Performance tuning of SQL source queries for data load/usage of stored procedures.
  • Involved in creating SSIS packages and used Analysis Services (SSAS) processing task to update the cube with current data.
  • Created Efficient Stored Procedures, Triggers, Functions, Indexes, Tables, Views, and other T-SQL scripts.
  • Created various parameterized reports from the Fact tables and Summary tables using SSRS.
  • Experienced in creating Ad-hoc reports, sub reports, linked reports, drill-down and drill-through reports.
  • Involved in analyzing slowly running reports and successfully increase the performance of queries.
  • Used different data sets and shared data sets to populate the available and default parameters and the main report.
  • Created various database objects for the ETL process involving the snapshot database and the isolation level.

Environment: MS SQL Server 2008 R2, MS SQL BI Suite (SSIS, SSRS), Query Analyzer, SQL Profiler, ASP.Net, MS Excel, Window XP

SQL BI Developer

Confidential

Responsibilities:

  • Our team had to extract the data from different Sources DB2 (OLTP), Access, Mainframe files to Data warehouse, before load the data in DW we created Staging environment to increase the performance. And this is made to support decision making based on transactional data.
  • Participated in Business Analysis & requirement collection.
  • Involved in designed the template of SSIS packages to approach the business requirement.
  • Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple homogeneous and heterogeneous information sources (CSV, Excel, DB2, SQL 2000, and SQL 2005).
  • Created/updated Stored Procedure, Triggers, User Defined Functions, User defined data type, Scripts and batches.
  • Removed Duplicate records from the source using complex query, analytical functions and ad-hoc scripts.
  • To achieve business requirements, used For-Each Loop Container, Sequence Container, VB Script task, Expressions, Execute SQL task, Variables, Send Mail Task, Package Execution task.
  • Used Look up, Pivot, Merge Join, Union all, Derived Column, Conditional Split, and Aggregate transformation to manipulate data in SSIS package data flow.
  • Provided Dynamic Configuration, Custom Package Logging, Error Handling, and Notification to SSIS template package.
  • Created deployment utility to deploy SSIS Packages.
  • Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
  • Created Historical Load job and Incremental Load job load in Development environment and QA Environment using SQL Agent.
  • Implemented Slowly Changing Dimension Type 1 and Type2 for required Dimensions and participated in performance tuning SSIS package.
  • Tuned queries using Query Optimization techniques.
  • Validated DIM and FACT data using Data Profiling Task to check correct data population.
  • Validated to Cube aggregations and calculations with source table and requested required changes on cube side and did required changes on ETL side.
  • SQL Server Profiler for tuning report queries and improves performance in SQL Server.
  • Worked closely with DBA team to regularly monitor system for bottlenecks and implement appropriate solutions.
  • Run Import/export wizard to load data between TEST and DEV Server, provided CSV and Excel files to mangers for the records they want for different meetings.

Environment: SQL Server 2005, Windows 2000/2003, T-SQL, SQL Server Integration Services, SQL Server Reporting Services, SQL Server Analysis Services, SQL Profiler, MS Excel 2003, Visual Studio 2005, Visual Team Foundation Server, Crystal Reports.

Hire Now