We provide IT Staff Augmentation Services!

Ms Sql Server/ Etl Developer (ssis) / Power Bi Report Resume

Whippany, NJ

PROFESSIONAL SUMMARY:

  • Over 7+ years of experience in Database Design, Development and Business Intelligence Tools of Microsoft SQL Server 2017/2016/ 2014/2012/2008 / with various domain such as Finance, Healthcare, Retails, IT System and Engineering Services and Insurance Industry with excellent expatriates on SQL, T - SQL, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analytical Services (SSAS) Involved working with various reporting tools such as SSRS, Power BI.
  • Experience in databases design, development of for business applications in a client/server and data warehouse environments in SQL 2008/2012/2014/2016/2017
  • Expert in all areas of SQL Server including tables, user functions, views, indexes, Stored procedures, functions, triggers, clustering, T-SQL, relational database models, data dictionaries, and data integrity.
  • Well versed in normalization/de-normalization techniques for optimum performance in relational and dimensional database environments and building Referential Integrity Constraints.
  • Good knowledge in RDBMS concepts, Data warehousing concepts, OLTP & OLAP.
  • Experience in MS SQL Server databases with tools like Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for optimal Performance.
  • Proficient in Extract Transform Load (ETL).
  • Strong Experience in Creating, Configuring, Deploying and Testing SSIS Packages.
  • Expertise in Extraction, Transformation, Loading data from DB2, AS400, SQL Server, Access, Excel, Flat Files and XML using SSIS.
  • Great Expertise in creating and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages.
  • Expertise in Debugging, Error logging, Error Handling and Production support for SSIS.
  • Strong ability in creating SQL server Reports using SSRS 2012/2008.
  • Good knowledge in creating Report Models for building Ad hoc reports using SSRS.
  • Proficiency in creating different types of reports such as Crosstabs, Conditional, Pie Chart Reports, Drill down, Top N, Summary and Sub reports and formatting them.
  • Proficient in handling parameterized reports and Cascade Parameterized Reports in SSRS 2012.
  • Knowledge and experience in designing, developing and deploying Reports and Dashboards.
  • Experience in managing Alerts, Operators and Scheduled Jobs through SQL Server Agent.
  • Experience in code optimization and improving efficiency in databases including re-Indexing, updating statistics, Recompiling Stored Procedures and performing other maintenance tasks.
  • Excellent in Developing (power BI) Dashboards Reports connecting to various source like SQL Server, Excel, Flat File, SharePoint.
  • Creating Power BI Reports, Dashboards, Workspace, Apps, Publishing & Sharing with Team And scheduling the report refresh using data Gateway.
  • Used Various Visual including bar, line, area, map, pie chart, tree map, matrix, tables, Funnel etc.

TECHNICAL SKILLS:

BI Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Tools (SSRS), SQL Server Analytical Services (SSAS), (Power BI) Power Point Services.

Relational Databases: SQL Server 2017/2016/ 2014/2012/2008 r2/2008, MS Access, DB2, MS Excel

Tools: SQL Server Management studio, Enterprise Manager, Profiler, SSIS, SSRS, SSAS, Microsoft Visual Source Safe, Crystal Reports9.0, MDX, Visual Studio .Net, ProClarity, DB Pro, Visual Source Team Foundation

Languages: T: SQL, PL/SQL, V.B6.0, MDX, C, C#, VB.Net.

Operating Systems: Windows 2010/2008/2007/2003/2000/ NT 4.0/9x, MS-DOS, UNIX, Linux

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

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

PROFESSIONAL EXPERIENCE:

Confidential, Whippany, NJ

MS SQL Server/ ETL Developer (SSIS) / Power BI Report

Responsibilities:

  • Increasing more prescribed patients and implementation coupons and working with physician data.
  • Utilizing T-SQL to Create Database Objects such as Tables, Indexes, Views, Function, Temp Table, Table variable, Triggers, Store Procedures and Dynamic SQL.
  • Proficient in writing T-SQL Insert, Update, Delete Statement (DDL, DML) and New Features like CTE, Rank & Dense Rank Function, Pivot Function and SQL Server Window Function.
  • Responsible for Query Execution plans and making sure each and every query is using appropriate and useful indexes.
  • Wrote complex SQL Queries using joins and Sub Queries to Retrieve Data from the Database
  • Proficient in Creating ETL Package for data Conversion using various Transformations tasks.
  • Create and Maintain existing Dynamic SSIS Packages to Load Data from SQL Server, Excel files, flat files and CSV Files.
  • Extensive used various SSIS Object such as Dataflow Components, Control Flow Elements, Connections Managers, Runtime Events, Log Providers & Import/ Export Wizard While developing packages.
  • Strong Experience in Creating, Configuring, Error Handling and Testing in SSIS Packages.
  • Used SSIS to create ETL packages (.dtsx files) to validate, Extract Transform and Load data (ETL)
  • To data warehouse databases, data mart databases.
  • Proficient in Developing, Deploying and Monitoring SSIS Packages.
  • Excellent in Developing Dashboards Reports connecting to various source like SQL Server, Excel, Flat File, SharePoint.
  • Used Various Visual including bar, line, area, map, pie chart, tree map, matrix, tables, Funnel etc.
  • Creating Power BI Reports, Dashboards, Workspace, Apps, Publishing & Sharing with Team And scheduling the report refresh using data Gateway.
  • Providing ad-hoc reports on demand, performing data validations.
  • Created calculated Measure and column using various DAX (Data Analysis Expression) function.
  • Implementing Row level security to make reports more secure.

Environment: MS SQL Server 2016/2017 MS Access, |Data Warehousing| Data Integration (ETL) SSIS, Reporting (Power BI) Windows server2010, Oracle, C#, .Net.

Confidential, Manchester , NH

SQL/ BI Developer

Responsibilities:

  • Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source (Oracle), Excel Spreadsheet to SQL Server 2014
  • Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases, data mart databases
  • Used advanced features of SQL Server Integration Service for newest versions.
  • 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 using SQL Server Integration Services (SSIS)
  • Developed, deployed and monitored SSIS Packages including upgrading to (SSIS)
  • Strong Experience in Creating, Configuring, Error Handling and Testing in SSIS Packages.
  • Extensively used joins and sub queries to simplify complex queries involving multiples tables.
  • Wrote complex Stored Procedure, Queries, Triggers, Functions, joins, sub queries, Indexes, User-defined functions and Cursors for application for ETL Packages.
  • Responsible for Query optimization and Performance tuning. Performing query plans and making sure each and every query is using appropriate useful indexes
  • Excellent report creation skills using Microsoft Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder
  • Developed custom reports and deployed them on server using SQL Server Reporting Services (SSRS)
  • Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services.
  • Good knowledge in creating Drill-down, Parameterized and Sub-Reports using RDL.

Environment: MS SQL Server 2008r2/2012/2014, SSRS, MS Access, SSIS, Windows server 2008, Oracle, C#, .Net.

Confidential, Long Island, NY

SQL BI/ ETL/ Report Developer

Responsibilities:

  • Developed complex SQL queries for data retrieval from various database objects including tables and views
  • Responsible for creating Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints Views, Stored Procedures, Triggers, Rules and Defaults
  • Creating and Modifying T-SQL stored procedures/triggers for validating the integrity of the data
  • Responsible for Query optimization and Performance tuning
  • Performing query plans and making sure each and every query is using appropriate useful indexes
  • Good knowledge in creating packages in SSIS
  • Created packages and scheduled it to get data from OLTP
  • Proficient in creating ETL package for data conversion using various transformations tasks
  • Backup and recovery of Master, MSDB and Application databases
  • Rebuilding Indexes and Tables as part of performance tuning exercise
  • Scheduling Jobs and Alerting using SQL Server Agent
  • Developed custom reports using SSRS/SQL Server BI studio
  • Created custom and Ad hoc reports using SSRS
  • Created reports that call Sub reports in SSRS
  • Created datasets for reports using T-SQL and stored procedures
  • Experience in creating different Data Layouts for the Business users depending on the requirement and providing them different Drill Down capabilities

Environment: SQL Server 2008/2008r2/2014 Enterprise Edition, SSIS 2014, SSRS 2014,C#, XML, T-SQL, SQL Server 2014, VisualStudio.NET IDE, Windows 7 Server, ASP, XML, T-SQL, MS Excel, MS Access, Visual Studio 2014

Confidential, Morristown, NJ

SQL BI/ Data Analyst

Responsibilities:

  • Created SSIS Packages according to the requirements
  • Built and load Data marts (Fact and Dimension tables) from transactional databases
  • Extract, Transform and Load (ETL) source data into respective target tables to build the required data marts
  • Communicate to the business analyst, Data Modeler on a regular basis to be informed on changing requirements or data model design alterations
  • Stage (Extract) the source data from files, SQL server, DB2 sources in SSIS
  • Worked with Flat Files Data source connections, ODBC data source connections (to SQL server sources) and DB2 data source connections
  • Used Query, SQL, Merge, Case, Validation transforms to transform the data (as needed) before loading into the warehouse tables
  • Actively involved in Normalization & De-normalization of database
  • Used Date functions, String functions, Database functions to manipulate and format source data as a part of Data cleansing and data profiling process
  • Worked with Date/time manipulations in SQL Server built in functionalities as well as Data Integrator Date functions
  • As a part of optimization Used MAP operations to route UPDATE and INSERT records in warehouse workflows
  • Prepared ETL design documents for implemented workflows and loaded the documents in the project share point site

Environment: SQL Server 2008/2012, Query Analyzer, SSIS 2008, T-SQL, Excel, Microsoft SQL Reporting Services 2008 (SSRS), SSAS 2008,Analysis Services (SSAS), DTS, T-SQL, Windows 2000/2003, XML, MS Excel, MS Access

Confidential, Miami, FL

MS SQL/ SSRS Developer

Responsibilities:

  • Responsible for creating Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints Views, Stored Procedures & Triggers
  • Was involved in writing Triggers and Stored Procedures
  • Actively involved in Normalization & De-normalization of database
  • Was involved in performance tuning of the Database
  • Used SQL Profiler and Data Base Engine Tuning Advisor to performance tune the Database
  • Scheduling Jobs and Alerting using SQL Server Agent
  • Created logins, roles, and groups to the Window NT and MS SQL Server and maintaining proper security procedures
  • Developed custom reports using Microsoft reporting Services
  • Created Drill Through and Various Cross tabbed reports using Microsoft reporting services

Environment: SQL Server 2008/2012, Enterprise Manager, Windows 2003 Server, .NET, C#, ASP.NET,SSIS, SSRS.

Hire Now