We provide IT Staff Augmentation Services!

Sr. Sql Server Bi Developer (ssis/ssrs/power Bi) Resume

0/5 (Submit Your Rating)

Orange, CA

PROFESSIONAL SUMMARY:

  • Around 7years of experience in Database design, data analysis and developing Business Intelligence using Microsoft SQL Server Integration Services, Reporting Services and Analysis Services, Power BI.
  • Experience in full life cycle ETL development using SSIS and writing complex T - SQL queries, Sub-queries, Dynamic SQL queries.
  • Extensive experience in developing several details, summary reports, trend analysis reports, sub reports using SQL Server Reporting Services (SSRS)
  • Thorough knowledge of database management concepts like conceptual, logical, and physical data modeling.
  • Experienced in Power BI, Power Query and Power Pivot to develop data analysis prototype and used Power View and Power Map to visualize reports.
  • Familiarity with Azure/ Cloud Fundamentals, Azure SQL Databases and Azure Data Bricks.
  • Knowledge and work experience in RDBMS concepts, Views, Triggers, Stored Procedures, User defined functions, Indexes, and Constraints.
  • Experience in Data modelling and development of Data Warehouse for both dimension tables and fact tables by initial load/ongoing load process using SCD/Merge/CDC, Parent/Child SSIS packages.
  • Experience with Normalization and De-normalization processes.
  • Expert in TSQL DDL/DML, perform most of the SQL Server Enterprise Manager and Management Studio functionality using T-SQL Scripts and Batches.
  • Experience in working with ETL operations between different sources like Oracle/Access/Excel etc., using SSIS, DTS.
  • Excellent in creating SSIS Packages for integrating data using OLE DB connection from various 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.
  • Excellent hands on managing and automating Control flow, Data flow, Events and Logging programmatically for SSIS packages.
  • Hands on experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
  • Experience in creating the configuration files to deploy the SSIS packages.
  • Worked with report manager for deploying the reports across all the environments and intensively on Microsoft Office SharePoint Server (MOSS).
  • Hands on experience in generating complex reports such as Parameterized, Drilldown, Drill through, Cascaded, Matrix reports using SSRS.
  • Experience in creating Ad-hoc reports, data driven subscription reports by using Report Builder in SSRS.
  • Experienced in Qlik View Server and Publisher maintenance for Creating scheduled jobs for QVD extracts and report reloads.
  • Knowledgeable and in compliance with HIPAA rules to secure PHI data
  • Experience in developing OLAP Cubes by using SQL Server Analysis Services (SSAS), and defined data sources, data source views, Dimensions, Measures, Hierarchies, Attributes, Calculations using multi-dimensional expression (MDX), Perspectives and Roles.
  • Expert in Configuring and managing data sources, data source views, cubes, dimensions, mining structures, roles and creating hierarchies with SSAS.
  • Expertise in creating a Power Pivot data model forextremely fast aggregation and calculation.
  • Performed Technical Documentation for functional and business requirements.
  • Ability to handleMultiple tasks,InitiativeandAdaptable.Self-motivated, organized team player with strong problem solving and analytical skills and total commitment to the organization goals.
  • Adaptability, Good team player, problem solving, communication skills combined with self-motivation and total commitment to the organization goals.

TECHNICAL SKILLS:

Databases: SQL Server 2016/2014/2012/2008 R2, 2005 & 2000/7.0, MS-Access 2000/2003, Oracle 11g/10/9i, DB2, Azure SQL

Cloud Technologies: Microsoft Azure

BI Tools: SQL Server Reporting Tools (SSRS), SQL Server Integration Services (SSIS), SQL Server Analytical Services (SSAS), BIDS, Tableau 6.1, Data Transformation Services (DTS), Visual Studio, OLAP, ETL, Crystal Reports, MS SharePoint Server 2008, QlikView 11.

Tools: /Database Utilities: SQL Server Management Studio, SQL Server Profiler, Import & Export Wizard, Visual Studio .Net, XML, Power Pivot, Microsoft Office, Excel, Business Intelligence Development Studio (BIDS), Power BI Desktop, Excel Data Explorer, Microsoft Office Suite, Visual Source Safe.

Database Design Tools: ERWIN 4.5/4.0, Star Schema/Snowflake Schema modeling, Fact & Dimension tables, De-normalization techniques, Kimball & Inman Methodologies pLanguages: T-SQL, PL/SQL, Dynamic SQL, .NET, HTML C, C++, C#, UNIX, MDX, Visual Basic 6.0, Batch Scripting

PROFESSIONAL EXPERIENCE:

Confidential, Orange, CA

Sr. SQL Server BI Developer (SSIS/SSRS/Power BI)

Responsibilities:

  • Responsible for codingSSISprocesses to import large volumes of EDI data into the Data Warehouse from Excel spreadsheets, Flat Files and OLEDB Sources (SQL Server).
  • Designed and developed Data integration process between Provider Contracting, Provider Credentialing and Core application using SQL Server Integration Services and SQL server 2019.
  • Involved in developing Data Exception Handling process which includes capturing and reporting defined exceptions to business users using SSIS.
  • Performed operations like Data extraction and Datareconciliation for Migration of the Contracting and Credentialing Legacy systems to a new hybrid system.
  • Enhanced the existing data model of legacy system to sync with new system data model for migration. Bulk loaded data into the modified data model of legacy system.
  • Created complex stored procedures to perform various tasks including, but not limited to index maintenance, data profiling, metadata searches, and loading of the data mart.
  • Designed and developed repository (Denormalized model) to feed downstream systems like online Provider web portal, Provider Roster Reports and several SSRS Reports.
  • Developed ETL process to feed the denormalized repository on daily basis.
  • Worked on design and development of new Provider contracting system integration with core provider system using SQL, SSIS. The ETL process was dynamically built to either consume a parameter file or use incremental changes as input.
  • Extensively used SQL Server tools like Query Analyzer, Enterprise Manager, Profiler and Management Studio.
  • Developed Provider configuration alert Reports in Power BI.
  • Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.
  • Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources.
  • Implemented cell level security in Power BI to restrict users of one Network seeing data of another Provider Network.
  • Designed and developed large number of reports in SSRS using the data from ETL Loads Generated on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services (SSRS)
  • Developed various operational Drill-through and Drill-down reports using SSRS.
  • Designed and implemented parameterized, cascading parameterized reports, Sub Reports usingSSRS.
  • Scheduled the delivery of various SSRS reports utilizing standard and data-driven subscriptions.
  • Using Team foundation server (TFS) for managing source code changes.
  • Experience in Tableau Administration Tool, Tableau Interactive Dashboards, Tableau suite.
  • Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
  • Created series of signboard and dashboard reports, built for a new process being built in Horizon.
  • Created Expression, Lookup, Filter, Router, Aggregator Transformations were implemented to load the data from source to Target using Designer.
  • Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality during POC .
  • PracticedAgile Principals, Sprint planning, daily standups.
  • Implemented Copy activity, Custom synapse Pipeline Activities.
  • Implemented Self-Hosted/SSIS Integration Runtimes to establish connection with On-premises andexecute SSIs packages
  • Implemented Azure Integration Runtime to establish connection with Azure Data Lake
  • Created Dataflows that copy data Incrementally from On-Premises SQL Server to Azure Datawarehouse
  • Created Datasets in Azure to Process the data using Azure DatabricksImplemented Azure-SSIS Integration for the Lift and Shift of existing SSIS package to Run on Azure Cloud

Environment: SQL Server 2012/2016, SSIS (2012), Power BI Desktop, VB.Net, Visual Studio (2012/2015), C#, DAX, Team Foundation Server 2013, Visual Source Safe, Power BI

Confidential, Fullerton, CA

Sr. SQL Server BI Developer/SSIS/SSRS/Power BI

Responsibilities:

  • Involved in requirements gathering, analysis, design, development, change management, deployment.
  • Designed, developed and deployed Business Intelligence solutions using SSRS
  • Created Dax Queries to generated computed columns in Power BI.
  • Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports
  • Developed ETL packages in SSIS and pulling data from different data warehouse databases like Oracle.
  • Developed SSIS packages bringing data from diverse sources such as Excel, SQL server, flat files, Oracle DB for the daily load to create and maintain a centralized data warehouse.
  • Designed and configured SSIS packages to migrate the data from Oracle, legacy System using various transformations.
  • Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients and mobile apps
  • Used Power BI Gateways to keep the dashboards and reports up to date and Installed and Configured Enterprise Gateway and Personal Gateway in Power Bi Services.
  • Scheduled and monitored the SQL Server Agent jobs to run the SSIS packages and stored procedures
  • Analyzed and troubleshoot performance tuning SQL and complex SSIS packages.
  • Generated customer reports using SQL Server Reporting Services 2012/2015/2017 from the OLTP data sources.
  • Worked on member data sharing p XML files.
  • Designed and deployed reports with Drill Down, Drill Through and Drop-down menu option and Parameterized and Linked reports.
  • Deployed and scheduled Reports using SSRS to generate daily, weekly, monthly and quarterly Reports including status.
  • Developed a robust ETL process to extract data from internal databases, transform it as per the business requirements and load it intoEssette(newly adapted application) database majorly utilizing SQL server BI tools SSIS.
  • Created standard report Subscriptions and Data Driven Report Subscriptions.

Environment: SQL Server 2016/2017, Microsoft Visual Studio 2015/2017, MS Office, DAX, SSIS, SSAS, SSRS, SharePoint, Power pivot, Power view, Power BI

Confidential

SQL Server Developer/SSRS/SSIS/T-SQL

Responsibilities:

  • Used Workforce Central Management 6.1 version tied the SQL Database to the workforce management by using SSMS and verified the created 120 SSRS reports from user perspective to make sure right amount of data is processed.
  • Developed the reports using stored procedures by adding variables such as Language translation and Time zone by considering different scenarios according to business requirement and Executed to get the required output.
  • Worked on RDL’s of the reports and promoted those RDL’S to WFC portal.
  • Responsible for Debugging reports using Stored Procedures.
  • Created Crosstab, Drill-down, Drill-through, Parameterized and Sub-Report using RDL.
  • Promoted RDLs to Reporting Service Server.
  • Generated Reports using Global Variables, Expressions and Functions for the reports.
  • Evaluate current reporting infrastructure to find bottlenecks and recommend improvements.
  • Responsible for creating/migrating undocumented crystal/SSRS reports.
  • Created and modified efficient Stored Procedure and functions which implement necessary business logic to support the frontend application to facilitate pulling data.
  • Developed and optimized stored procedures using input, output, table valued parameters and Query Analyzer.
  • Create new SSIS Packages to export flat file for customer.
  • Created and executed SSIS packages to populate data from the various data sources for different data loading operations for many applications.
  • 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).
  • Created package to transfer data between OLTP and OLAP databases.
  • Assisted front-end C#.NET and ASP.NET developers using Visual Studio 2008 (C#, ASP.NET).

Environment: SQL Server 2008, BIDS, SSIS, SSRS, Crystal Reports XI, Visual Studio, T-SQL, C#.NET, ASP

We'd love your feedback!