Sql Power Bi Developer Resume
St Louis, MO
SUMMARY
- 9+ Years as an experienced MS SQL Server Development experience in Finance, Manufacturing & Distribution, Healthcare/Insurance Industry and Excellent knowledge about health care industry and claims management with expertise in MS SQL Server 2005/2008/2008 R 2/2012/2016/2017 and Microsoft’s suite of products like SSIS, SSAS, and SSRS. With an (MBA), and Finance and Management background, I have a strong analytical approach to business analysis and management.
- Handles multiple assignments simultaneously and successfully identify and coordinate key deliverables with stakeholders in cross - functional groups. Passions include ensuring data quality, scalability, performance, integrity, and security, as well as standards development and process improvement
- Technically and logically very sound in T-SQL Programming, SSIS, SSRS, SSAS, .NET, Data warehousing, Business Intelligence etc.
- StrongSQLServerDeveloperskills including writing triggers, Stored procedures, Views, Query writing.
- Created Backend validations using Insert/ Update and Delete triggers.
- Excellent Knowledge in designing of ETL Packages for integrating data from multiple sources. (Oracle database, Flat files, Excel, CSV, XML)
- Employed Power BI to rapidly prototype/pilot each BI solution, and to enhance business requirements gathering and satisfaction within iterative cycles, before recreating successful Power BI models inSSASTabularfor support of enterprise hybrid Power BI solutions
- UsedXMLand XSD's generated by the application as a data source for the reports.
- Wrote complexSQLstatements using CTE's, joins, sub queries and correlated sub queries.
- Created Power BI Reports using the Tabular SSAS models in Power BI desktop with DAX queries and published them to Power BI Service using star schema.
- Designed, implemented and supported independent, “from scratch” Development, UAT, and ProductionSSASTabularenvironments for the organization throughout my tenure
- Scheduled and maintain packages by daily, weekly and monthly usingSQLServerAgent in SSMS.
- Migrated Mainframe data intoSQLtables using complex logics.
- Troubleshooting issues with TFS environments at various clients.
- Involved in creating different types of reports (Tabular Reports, Matrix, Cross Tabs, Drill Down, Charts, Functions and Maps) by extracting data from tables, store procedures into report builder andSQLserverreporting services. And customizing reports by adding Filters, Calculations, Prompts, Summaries and Functions.
- Worked on T-SQLprogramming, stored procedures, user-defined functions, cursors, views setup and management of linkedserversto Non-SQL-Serverdatabases.
- Expertise in using Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.
- Strong ability in defining query for generating drill through, drill down reports, canned and cache reports with drop down menu option, sorting the data, defining subtotals and handling parameterized reports and creating report layouts using SSRS 2005/2008.
- Efficient ETL specifications forEPICClarityand non-Claritysources based on business requirements through a structure of Land
- Experience in developing Custom Reports and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
- Excellent Power BI skills, Experience in creating solutions for mid-large sized companies with Advanced SQL server relational database and development experience, as well as in Microsoft technologies SSIS, SSRS, SQL server, Power Pivot, Power View, and related technologies
- Sound knowledge of Performance Tuning, Disaster Recovery, Backup and Restore procedures.
- Experience inChange Data Capture(CDC), Change Tracking (CT) in SQL server 2008.
- Reviewed andoptimized SQL queries, CDC,stored procedures, functions, Indexes, views and triggers.
- Experience on Microsoft Technologies Visual Studio 2003/2005, ASP.NET, C#, VB.NET, ASP, VB, IIS5.0/6.0, HTML, Oracle, SQL Server, Sybase IQ 12.5.0.1 and other Web related tools like Microsoft Azure
- Hands-on experien12qce and exposure to different phases of Software Development Life Cycle(SDLC),Agile and Scrum Methodologies,
- Wrote Triggers and Stored Procedures to capture updated and deleted data fromOLTPsystems
- Worked on Normalization and De-Normalization techniques for bothOLTPandOLAPsystems
- IT experience, that includes Client / Server Application Programming,BizTalk Server 2009/2006 R2/2006/2004,HIPAA /EDI, MQ SERIES / XML, ASP.Net, VB.Net, C#
- Used MicrosoftPowerBIPowerQuery to extract data from external sources and modify data to certain format as required in Excel
TECHNICAL SKILLS
RDBM/Databases: MSSQL Server 2000/ 2005/20 /2016/2017 , MS Access 97/2000/2003/2007 , MYSQL. Oracle12c/11g/10g/9i
Programming Languages: T-SQL, PL/SQL, Dynamic SQL, MDX, XML, HTML, DHTML, Shell Scripting, Visual Basic 6.0
Data Modeling: MS Visio, Fact & Dimensions tables, Physical & Logical data modeling, Star & Snowflake schema Relational, Dimensional and multidimensional modeling and De-Normalization Techniques, MS- Access.
ETL-Tools: SQL Server Integration Services (SSIS)
BI Tools: SQL, SQL Server Integration Services (SSIS 2005/2008/2012 ), SQL Server Reporting Services (SSRS 2005/2008/2012 ) SQL Server Analytical Services (SSAS 2005/2008/2012 ), Agile Methodology, Power BI Visual Studio, BIDS.
Tools: /Database Utilities: SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Visual Studio .Net, Microsoft Management Console, Business Intelligence Development Studio (BIDS), Toad, IIS 6.0/7.0, Business Objects, Crystal Reports 9.0, Web Services, XML, SOAP, WSDL, UDDI, Clear Case, Clear Quest, Visual Source Safe 6.0/2005, Visual Studio Team Foundation Server (TFS).
PROFESSIONAL EXPERIENCE
Confidential, St. Louis, MO
SQL Power BI Developer
Responsibilities:
- Provided day-to-day to support of MSSQLServer, Power BI including backup and recovery database utilities, and data replication technologies while supporting the development, test, and production environments.
- Created Power BI Reports using the Tabular SSAS models in Power BI desktop and published them to Power BI Service using star schema.
- Created Power BI Reports Using SQL Server 2017 as a data source worked on databases
- To meet business requirements and to coordinate user testing, worked closely with users.
- Created various reports like Tabular reports, Matrix reports, and Graphical reports, Heat maps, Scatter Charts in Power BI.
- Establish Import connection to store the data source in the Power BI and creating measures using DAX, creating parameters, changing columns name to make them more user-friendly.
- Developed, tested, and took into production end-to-end hybrid Power BI solutions that sat atop an on-premise SSAS Tabular environment.
- Created Dimensions and cubes with star schema using SQL SERVER Analysis Services (SSAS) using SQL SERVER DATA TOOLS 2015.
- Publish Power Bi reports to the Power BI service with client credentials, so it will be accessible to end users.
- Added data sources to Power BI Gateway and map users to the data source and created workspace in Power BI service after that add admins and members. So, everyone can access those Power BI reports in Power BI Service and create dashboards.
- Created various charts like Pie Charts and Line Charts to make easy understanding of the reports.
Environment: SQL Server 2016/2017, SSIS, SSAS, MS Excel, SQL Profiler, T-SQL, Power BI desktop, Power BI Service, Power BI Gateway, Visual Studio.
Confidential, Albany, NY
SQL Power BI Developer
Responsibilities:
- Provided database and day-to-day to support of MSSQLServer databases, including backup and recovery procedures, database utilities, and data replication technologies while supporting the development, test, and production environments.
- Created Power BI Reports and effective Visualizations on Import Connection and published to Power BI Service.
- Created security model usingSSASTabularModel (DAX), using GitHub as source control.
- To meet business requirements and to coordinate user testing, worked closely with users.
- Worked on to Create new database/tables to put in the extracted data and rebuild the relationship.
- Created Tabular model using Facts and Dimension table SQL Server as an Data Source.
- Created Measures in Tabular Model using DAX and multiple hierarches.
- Created various reports like Tabular reports and Matrix reports in Power BI.
- Created Multiple Store Procedures using Dynamic SQL to manipulate the data into the tables.
- Establish Import connection to store the data source in the Power BI and creating measures using DAX, creating parameters, changing columns name to make them more user-friendly.
- And live connection directly from data sources without physically storing them in Power BI and visualized the data in summarized detailed, ad-hoc reports, Pie charts, graphs, drill-through reports, tabular reports with other visualizations and create reports.
- Publish Power Bi reports to the Power BI service with client credentials, so it will be accessible to end users.
- Added data sources to Power BI Gateway and map users to the data source and created workspace in Power BI service after that add admins and members.
- Created various charts like Pie Charts and Line Charts to make easy understanding of the reports.
Environment: SQL Server 2016, MS Excel, SQL Profiler, ETL, T-SQL, Power BI, Power BI Service, Power BI Gateway TableauDesktop, Oracle 9i, PL SQL MS SQL Server Integration Services, MS SQL Server Analysis Services(Tabular), Visual Studio.
Confidential, Atlanta, GA
SQL BI Developer
Responsibilities:
- Created Store Procedures, Tables, Views, cursors and optimizing queries by using execution plan for tuning the database. Implemented different types of constraints on tables
- Creating tables, indexes and designing constraints.
- Created Backend validations using Insert/ Update and Delete triggers.
- Part of Relational Data Warehouse Designs and effectively identified and created Facts and Dimensions tables.
- Review data transformation rules and provide technical suggestions in data transformation logic and pseudo code (PL/SQL).
- Creating Indexes and used Scan and Seeks for performance tuning
- StrongSQLServerDeveloperskills including writing triggers, Stored procedures, Views, Query writing.
- Developed and deployed SSIS packages in Production Server.
- Managed the entire ETL process involving the access, manipulation, analysis, interpretation and presentation of information from both internal and secondary data sources to end users.
- Expertise in using Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.
- Used the report builder in customization of Reports inTFS.
- Strong ability in defining query for generating drill through, drill down reports, canned and cache reports with drop down menu option, sorting the data, defining subtotals and handling parameterized reports and creating report layouts using SSRS 2005/2008.
- Deployed Reports created Report schedules and subscriptions. Managing and securing reports using SSRS Report Manager.
- Worked on Power Bi and created reports and dashboards and published them on service.
- Experienced and Created logs for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS 2012,2014
- Expertise working with SSASTabular model to produce reports in excels files using pivot tables and DAX queries.
- Experience in design of ETL packages for integrating data from heterogeneous sources like (Excel, Flat file, CSV) by using multiple transformations provided by SSIS.
- Experience in creating jobs, SQL Mail, Alerts and schedule SSIS Packages using SQL Server Agent.
- Deployed SSIS packages to different environments.
Environment: SQL Server 2014/2012/2008/2005 , SSRS 2012/2008, SSIS 2012, SSAS, C#, ASP.NET, DB2, Oracle 9i/10g,Agile Methodology, PL SQL. Visual Studio 2012,Microsoft Dynamics AX 2012, XML, Power BI, MS Office and Visual source safe, Business Objects XI 3.1/3.0, XI R1/R2.
Confidential, Richardson, TX
SQL BI Developer
Responsibilities:
- Created Store Procedures, Tables, Views, cursors and optimizing queries by using execution plan for tuning the database. Implemented different types of constraints on tables
- Created Backend validations using Insert/ Update and Delete triggers.
- Configured SSIS Packages using Environment Variables for Dynamic selection of Development and Production Environment.
- Developed highly Complex Stored Procedures, Packages, Functions, Cursors and Materialized Views inPL/SQLDeveloper, Toad inOracle10genvironment.
- Part of Relational Data Warehouse Designs and effectively identified and created Facts and Dimensions tables.
- Creating Indexes and used Scan and Seeks for performance tuning
- Developed and deployed SSIS packages in Production Server.
- Managed the entire ETL process involving the access, manipulation, analysis, interpretation and presentation of information from both internal and secondary data sources to end users.
- EDI820 testing for APTC/ CSR payments from federal exchange (FFM)
- Epic Clarity report in hospital and clinical data analysts and designs/testing.
- Medical Claims experience in process documentation, analysis and implementation in 835/837/834/270/271/277/997 (X12 Standards) processes of Medical Claims Industry from the
- Experienced inTFSWork Items, Queue New Builds, and Work Spaces with Visual Studio 2014.
- Good experience in front end development usingoracleforms/reports6i/9i/10g.
- Analyzed & supported reporting needs, provided data extraction and support for system conversion, modified existingEPICCrystal reports, wrote and optimized SQL queries to Crystal Reports
- Proficient inPL/SQLprogramming - Stored Procedures, Functions, Packages,SQLtuning, and creation ofOracleObjects - Tables, Views, Materialized Views, Triggers, Sequences, Synonyms, Database Links, and User Defined Data Types.
- Exported Requirements, test plans and test cases toTFS.
- Optimized the performance usingPL/SQLby restructuring the extraction and summarization routines.
- Experienced in DynamicSQL,PL/SQLCollections and Exception handling
- For new insurance carrier on boarding’s, create the test suite of sampleEDI834 enrolment files to cover different policy tiers, maintenance files for change transactions
- Developed, tested, and took into production end-to-end hybrid Power BI solutions that sat atop an on-premiseSSASTabularenvironment, while also drawing upon a data mart I designed, containing several diverse enterprise data sources, including SQL Server, Oracle.
- Created report models for ad-hoc reports using SSRS 2012 with Excellent Power BI skills,
- Experience in creating solutions for mid-large sized companies with Advanced SQL server relational database and development experience,as well as in Microsoft technologies SSIS, SSRS, SQL server, Power Pivot, Power View, and related technologies.
- Designed and created Report templates, bar graphs, pie charts based on the financial data.
- Experience in Designing, Creating, Deploying and Processing of Cubes using SSAS.
- Hands-on experience Relational Database Modeling and Dimensional Modeling in combination with SSASto develop OLAP cubes having Star/Snowflake schemas.
- Wrote Triggers and Stored Procedures to capture updated and deleted data fromOLTPsystems
- Developed DTS packages to extract, transform and load into the Campaign database fromOLTP database using of SQL Server Integration Services (SSIS)
- Worked on Normalization and De-Normalization techniques for bothOLTPandOLAPsystems
Environment: SQL Server 2014/2012/2008/2005 , SSRS 2012/2008, SSAS 2014/2016, SSIS 2012, SSAS, C#, ASP.NET, DB2, Oracle 9i/10g, Power BI, Visual Studio 2012, XML, PL SQL, Team Foundation Server 2012(TFS), Microsoft Dynamics AX 2012, XSLT, MS Office and Visual source safe, Agile Methodology Business Objects XI 3.1/3.0, XI R1/R2.
Confidential, Atlanta, GA
SQL BI Developer
Responsibilities:
- Created several SSIS Packages to load data from various data sources including Flat files, MS Excel, MS Access, DB2 etc. to SQL Servers
- Experience in developing Custom Reports and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
- Created Backend validations using Insert/ Update and Delete triggers.
- Managed indexes, statistics and tuned queries by using execution plan for optimizing the performance of the databases.
- Created complex Stored Procedures and Functions to support the front-end application.
- Experienced in Developing Power BI Reports and Dashboards from multiple data sources using Data Blending.
- Created and managed schema objects such as tables, views, indexes, procedures, triggers and maintaining Referential Integrity.
- Experience in creating OLAP cubes, identifying dimensions, attributes, hierarchies and calculating measures and dimensions using SQL Server Analysis Services.
- Created various kinds of reports using Power BI and Tableau, SSRS, Excel, and Power Pivot based on the client's needs.
- Experience in Designing, Creating, Deploying and Processing of Cubes using SSAS.
- Hands-on experience Relational Database Modeling and Dimensional Modeling in combination with SSASto develop OLAP cubes having Star/Snowflake schemas.
- Worked on Power Bi and created reports and dashboards and published them on service.
- Formatted reports using Global variables, Expressions and Functions using SSRS 2012.
- Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report and generated reports using Crystal Reports.
- Building BI capabilities in an organization, with specialized capabilities including Business Intelligence (BI).
- Appliedsecurity featuresof Business Objectslike row level, report level & object level securityin the universe to make the sensitive data secure.
Environment: MS SQL Server 2016/2014, Windows Server 2012, Enterprise manager, Query Analyzer, SSIS, SSAS, SSRS, SQL profiler, Performance Monitor, Query Optimizer, T-SQL, Power BI, Agile, Share Point Portal Server 2007 (MOSS 2007), IIS 6.0, XML, ETL, Microsoft Visio 2003, MS Visual Studio 2012, Composite Studio 6.1,Oracle 11g
Confidential, Milwaukee, WI
SQL BI Developer
Responsibilities:
- Involved in writing scripts for client requirements for reporting purposes.
- Responsible for writing T-SQL code for creating cursor and handling the data validations.
- Developed complex T-SQL code for the application.
- UsedDAXfunctions to generate spreadsheets and pivot tables.
- Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler.
- StrongSQLServerDeveloperskills including writing triggers, Stored procedures, Views, Query writing.
- Monitored Scheduled jobs and alerts. Create new SSIS Packages to export flat files.
- Created and executed SSIS packages to populate data from the various data sources for different data loading operations for many applications.
- Experience in writing Stored Procedures, Views, and Functions in SQL using Oracle SQL Developer for data to SSRS reports.
- Gathered functional and non-functional client requirements to optimize the design of BI deliverables (reports, dashboards, alerts, visualizations).
- Created various complex Reports such as Tabular reports for static columns and matrix report types for dynamic pivot columns using SQL Server Reporting Services 2012
- Created Charts, Tabular and Matrix reports using SSRS, with Drill Down and Dill Through features.
- Deployed Reports created Report schedules and subscriptions. Managing and securing reports using SSRS Report Manager.
- Hands-on experience Relational Database Modeling and Dimensional Modeling in combination with SSASto develop OLAP cubes having Star/Snowflake schemas.
- Experienced and Created logs for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS 2012,2014
- Experience in creating and managing SSAS Tabular models with DAX queries, creating Dimension Tables and Fact Tables
- Designed various types of reports including: Tabular forms, Matrix (cross Tab report) form, List items, Charts and Linked reports, Sub reports, bar charts and matrix reports.
Environment: MS SQL Server 2008R2, MS Analysis Services 2008, Oracle 11g, MS Access, Import & Export Data, Windows 7/8.
Confidential, Fort Worth, TX
SQL BI Developer
Responsibilities:
- Maintained databases, performed software installations and monitored Database Performance.
- Involved in reverse and forward loading of the schema of a database using Erwin.
- Responsible for gathering Business Requirements and System Specification from users.
- Designed and Developed Database Objects like Tables, Stored Procedures, Triggers, Rules, Defaults, user defined data types and functions for this project.
- Worked on all types of report types like tables, matrix, charts, sub reports etc.
- Created Linked reports, Ad-hoc reports and etc. based on the requirement. Linked reports are created in the Report Server to reduce the repetition the reports.
- Designed index, statistics and optimized queries by using execution plan for performance tuning of the database.
- Maintained databases, performed software installations and upgrades, monitored Database Performance.
- Created and scheduled jobs for various tasks and also was responsible for maintaining jobs through SQL Server Agent.
- Experience in the design, development and maintenance of different cubes using SSAS.
- Involved in the post deployment maintenance of canned reports and cubes.
- Experience in designing the reports in ProClarity for SSAS cubes.
- Managed Logins, Users, Roles and User permissions.
- Regular responsibilities for updating staging and dimensional databases as well as rebuilding the dimensions and cubes on Analysis Services(SSAS)
- Used Reporting Services (SSRS) to schedule reports to be generated on predetermined time.
- Developed Cascading Reports for Employee Reports, Ad-hoc Reports using Report Builder, (SSRS) 2008
- Generated on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services (SSRS).
Environment: MS SQL Server 2008, MS SQL Server Reporting service 2008, MS SSIS, T-SQL, Windows
Confidential, Kansas City, KS
SQL Server BI Developer
Responsibilities:
- Gathered end user requirements and developed applications and different audit functionalities depending on the requirements acting both as a system analyst and an application developer.
- Wrote user requirement documents and developed functions, indexes, stored procedures, views and triggers for automation. Converted fast views in to EUP views and validated data.
- Used Team Foundation Server (TFS) as a tool for repository of codes and version control, also maintains test scripts and documentation following the standards.
- Worked on UI Data pop and Meta-data for populating data in EXCEL using SQL macros.
- Developed query for generating drill down and drill through reports in SSRS 2008.
- Uploaded reports on to the report manager and organized them into folders.
- Generated and formatted Reports using Global Variables, Expressions and Functions for the reports. Designed and implemented stylish report layouts.
- Identified and worked with Parameters for parameterized reports in SSRS 2008.
- Experience in Designing, Building the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS) for analyzing purpose.
- Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
Environment: MS SQL Server 2008, T-SQL, DTS, SSAS, SSIS, SSRS, SQL Server Enterprise Manager, SQL Server Query Analyzer, ERWIN, TFS, MDX, SQL Server BIDS, MS- Visual Studio 2008.
Confidential
SQL/SSIS/SSRS Developer
Responsibilities:
- Created complex Stored Procedures and Functions to support the front-end application.
- Participated in developing logical model and implementing requirements on SQL Server 2008/2005.
- Created Indexes, Views, Triggers, Stored Procedures and Packages in T-SQL.
- Created database triggers to implement business requirements.
- Successfully created schema change scripts to existing objects to synchronize with changing business rules.
- Monitored growth of database objects for capacity planning.
- Involved in tuning the database and T-SQL queries using Explain Plan.
- Optimize SQL queries for improved performance and availability.
- Configured and monitored database application.
- Worked with Quality assurance to develop test plans and test cases to conduct system testing.
- Involved in performance tuning of the database and T-SQL queries.
- Preparation of project documentation.
- Preparation of test plans for assembly testing & System Integration testing.
- Developed Reports to generate daily, weekly, monthly, quarterly, yearly Reports using Crystal Reports.
Environment: SQL Server 2008/2005, SSIS, SSRS, DB2, Oracle 9i, ASP, ODBC, VBScript, Windows 2000/XP, IIS5
Confidential
SQL/SSIS/SSRS Developer
Responsibilities:
- Developing T-SQL queries, triggers, functions, cursors and stored procedures.
- Responsible for logical and physical design of SQL Server databases.
- Used DDL and DML for writing triggers, stored procedures, and data manipulation and created views to restrict access to data in a table for security.
- Expert in extracting data using SSIS from OLTP to OLAP.
- Performed Bulk data migration using DTS and SSIS from flat files.
- Designed and optimized all the SSIS packages and exported data from text file to SQL Server Database.
- Identified the Data Source and Datasets for report generation and also included report parameters.
- Implemented full and differential backups and also created and managed DB objects.
- Make recommendations for File Group Creation and Placement.
- Scheduling backups and automating weekend maintenance tasks.
- Created users and roles for login authentication and validating permissions.
- Administering MS- SQL Server, performing day-to-day tasks such as Database tuning by checking indexes.
- Assisted developers in tuning Stored Procedures, Triggers and Functions over performance issues.
Environment: SQL Server 2008/2005, T-SQL, DB Artisan, MS Reporting Services, Management Studio, Query Analyzer, Windows 2003/2000 Server, Oracle 9i.