Sql Server/power Bi Developer Resume
Kansas City, MO
SUMMARY
- 8+ years of experience in data modeling, database designing, product support, development and implementation of applications using Microsoft SQL Server suite of products.
- Extensive working experience with Business Intelligence Development Studio (BIDS) which includes SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS).
- Proficient in all areas of SQL Server development such as tables, views, user defined functions, indexes, stored procedures, functions, triggers.
- Expertise in extracting data from multiple tables using T - SQL joins, correlated and non- correlated sub queries.
- Experience in developing interactive data visualization reports, and dashboards using Power BI Desktop.
- Extensive working experience in developing SSRS reports such as tabular, matrix, cascading parameterized, drill down, drill through, custom reports using report builder and report designer.
- Experience in Extracting, Transforming, and Loading (ETL) data from various data sources such as flat files, excel, csv, and oracle to SQL Server database.
- Experience in ETL process using SSIS, DTS, Import and Export utility.
- Implemented event handlers, package configurations, logging, user defined variables, and expressions in SSIS packages.
- Worked on OLTP and OLAP systems. Created Tabular and Multi-dimensional cubesusing SSAS.
- Experience in designing data warehouse using dimensional model schemas like star schema and snow flake schema.
- Expertise in populating dimension, fact tables, and data marts using SSIS packages.
- Experience working in agile environment and have good understanding of Software Development Life Cycle (SDLC) methodologies and principles.
- Worked on designing database models using MS Visio and Erwin.
- Experience in troubleshootingthe database issues and resolve the incidents/tickets as per SLAs.
- Extensively worked on Performance Tuning Analysis, Query optimization, Avoiding deadlocks and Blocking, Backups, Disaster Recovery Planning.
- Created datasets based on MDX queries and implemented performance analysis of the SSRS reports.
- Experience in scheduling jobs using SQL Server Agent and involved in database administration activities such as backup, recovery, and replication of databases.
- Experience in performance tuning, query optimization, and database security by creating users and role based access to data.
- Responsible for coordination and execution of User Acceptance Testing (UAT) for standard and custom implementations.
- Facilitated technical trainings to clients/end users/support team.
- Worked on complex RDBMS table structures and ability to research application issues using SQL or related tools.
- Experience in source code management, reporting, requirements management, and project management using Team Foundation Server (TFS).
TECHNICAL SKILLS
Database: MS SQL Server 2005/08/12/14/16, Oracle 11g, MySQL
SQL Server Suite: SSMS, SSIS, SSRS, SSAS, SQL Profiler, DTS
Reporting Services: SSRS, Power BI, Pivot Tables
Data Modeling Tools: Erwin
Programming Languages: T-SQL, Java, VB Script, MDX
MS Office Suite: MS Word, MS Excel, MS PowerPoint, MS Access, MS Visio, TFS
Ticketing Tool: ServiceNow, First wave
PROFESSIONAL EXPERIENCE
Confidential, Kansas City, MO
SQL Server/Power BI Developer
Responsibilities:
- Working on gathering business requirements from end users, developing and maintaining SSRS reports and MS SQL server database querying and programming. collaborate with cross-functional teams to halp end users navigate the data and reporting to solve business problems.
- Develop SQL scripts to load data into enterprise data warehouse(EDW).
- Basic troubleshooting and fixing the issues within EDW and reporting solutions.
- Work TEMPeffectively with the client management team to identify, estimate, prioritize, and resolve issues.
- Create data marts and load data into dimension and fact tables by creating SSIS packages.
- Work closely with application teams and be responsible for database query design.
- Develop and support SSIS ETL packages to perform data loads from various types of source files to SQL server database.
- Handle incremental data load into staging and ODS databases
- Perform SQL code review on new procedures and report queries created by consulting team.
- Use performance monitor and SQL profiler to optimize the SQL queries and enhance the performance of the database.
Environment: SQL Server 2016, SSRS, SSAS, SSIS, ServiceNow, Visual Studio
Confidential, Cleveland, Ohio
Power BI Developer(SSIS/SSAS/SSRS)
Responsibilities:
- Designed and developed tabular models and multidimensional models usingSSASbased on the insights provided by the business users.
- Designeddimensionsand hierarchies inSSAScubes based on star schema from Data warehouse.
- Interacted with business users and analyzed the user requirements and built reporting solutions such as relational database reports, OLAP reporting, and dashboards.
- Created visualizations and dashboards using Power BI as per the requirements.
- Based on report requirements, me have created the calculated columns and measures using DAX in Power BI.
- Involved in user interface design of reports and layouts that were developed using Power BI.
- Used various Power BI visualizations such as clustered column chart, waterfall chart, gauge, pie chart, tree map, bar chart etc.
- Involved in complete SSIS life cycle in creating SSIS packages, building, deploying, and executing the packages in both the environments (Development and Production).
- Troubleshooted and resolved the issues with existing ETL process.
- Provided documentation for the new SSIS packages and procedures.
Environment: Power BI Desktop, SQL Server 2014, SSAS, SSIS
Confidential, Baltimore, MD
SQL Database Developer (SSIS/SSRS/SSAS)
Responsibilities:
- Automated the execution of SSRS reports using subscriptions and data-driven subscriptions.
- Designed and maintained SSRS Reports using parameters and expressions.
- Designed and implemented parameterizedand cascading parameterized reports using SSRS.
- Build different types of chart reports using SSRS like column chart and pie charts.
- Created sub reports and pass through parameters from main report to the sub reports.
- Generated various report models on views and deployed them on to the production reporting server and generated various report models and ad-hoc reports.
- Created reports from SSAS cube using MDX.
- Hands on experience on Star Schema Modeling, Snow-Flake Modeling, FACT and Dimension tables, Physical and logical data Modeling.
- Improved the performance of the slow running queries by using performance tuning.
- Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple heterogeneous information sources (Oracle & Sybase)
- Created packages in SSIS with error handling.
- Worked with different methods of logging in SSIS.
- Experience in creating complex SSIS packages using proper control and data flow elements.
Environment: SQL Server 2014, SSIS, SSRS, SSAS, Visual Studio
Confidential, Pittsburgh, PA
SQL Database developer(SSIS/SSRS)
Responsibilities:
- Performed data cleansing by creating tables to eliminate the dirty data using SSIS.
- Responsible for deploying and scheduling the SSIS packages through jobs.
- Designed data models using Erwin.
- Developed physical data models and created DDL scripts to create database schema and database objects.
- Worked with T-SQLto create Tables, Views, and triggers and complex stored Procedures.
- Used Script task for Data Flow and Error Handling in SSIS.
- Wrote complexSQLqueries using joins, sub queries and correlated sub queries to retrieve data from the database.
- Created/Updated database objects like tables, views, stored procedures, function, packages.
- Generated Drill down, Drill through, Ad-hoc, Matrix Reports, parameterized reports using SSRS.
- Designed and developed monthly, quarterly, and yearly reports.
- Monitored the overall performance of the database to recommend and initiate actions to improve/optimize Performance.
- UsedSQLServerProfiler to trace the slow running queries and theserveractivity.
- Automated and enhanced daily administrative tasks including database backup and recovery.
- Involved in setting upSQLServerAgent Jobs for periodic backups with backup devices, database maintenance plans and recovery.
Environment: MS SQL Server 2012, SSIS, SSRS, T-SQL, Visual Studio 2012, Erwin, SQL Profiler.
Confidential, Overland Park, KS
SQL Server/SSIS/SSRS/SSAS Developer
Responsibilities:
- Created ETL packages to load transactional data to data warehouse and built analysis services database to provide summarized data for dashboards.
- Created custom measure groups in SSAS cube to implement business logic.
- Created roles and implemented security to restrict users to view the data.
- Migrated data from different heterogeneous sources such as flat files, excel, and SQL Server using SSIS and Bulk Insert.
- Designed and maintained SQL server views to support ongoing reporting and application requirements.
- Worked with team and created the data sets for reporting. Managed and supported the report environment.
- Used SQL server relational database and T-SQL query language to create new database objects as needed, including primarily tables, views, and stored procedures.
- Created reports with SSAS cube as the data source using SQL Server Reporting Services (SSRS).
- Maintained the Business Intelligence Incident Management queue.
- Responsible for trouble shooting, supporting, and enhancing existing production application reports.
- Provided business users the data required for metrics and analysis.
- Performed unit testing on the SSRS reports before deploying them to the production server.
- Provided the production support after designing and deploying the reports to production server.
Environment: SQL Server 2012, SQL Server Data Tools (SSDT), SSIS, SSRS, SSAS, T-SQL, TFS
Confidential
Jr SQL Developer(SSIS/SSRS)
Responsibilities:
- Worked with clients/end-users to determine configuration requirements for new implementations and enhancements for the existing application.
- Implemented and supported the Confidential ’s HR system application and provided the BI Solutions to clients by creating SSRS reports and SSIS packages.
- Migrated data from different heterogeneous sources such as flat files, excel, and SQL Server using SSIS and Bulk Insert.
- Created SSIS packages to load data into data warehouse using various SSIS Tasks like execute SQL task, bulk insert task, data flow task, send email task.
- Designed and maintained SQL Server Views to support ongoing reporting and application requirements.
- Used SQL server relational database and T-SQL query language to create new database objects as needed, including primarily tables, views, and stored procedures.
- Developed SSRS reports such as sub reports, parameterized, drill down, and ad-hoc reports.
- Supported the application users, client support personnel who worked in a 2nd tier support environment.
- Supported internal/external technical and functional users.
- Trained the non-technical users to create the basic SQL queries using views through the application wizard.
- Prepared test cases, performed unit testing, documented the test results, and involved in code reviews.
- Worked with business team and clients to coordinate UAT, maintain Issues and Actions Log, ensure configuration issues are promptly resolved, tested, and signed-off.
- Provided post implementation hyper care, end user training and documentation.
- Managed production support by trouble shooting and resolving the incidents/tickets as per SLAs.
- Participated in weekly status calls with clients, ensure the application is configured and ready to go-live as per schedule, and document lessons learned.
- Participated in weekly 24/7 on call rotation.
Environment: SQL Server 2008, SSIS, SSRS, T-SQL, ServiceNow, Excel, Word, Confidential HR System.
Confidential
Jr SQL Developer/SSAS Developer
Responsibilities:
- Involved in gathering, analyzing, designing of the system specification, and prepared the document for proposed system.
- Involved in designing and creating the database tables and views.
- Created various database objects such as stored procedures, user defined functions, triggers.
- Wrote complex SQL queries using joins and sub queries involving multiple to extract the desired data for reporting.
- Involved in database administrative activities such as database backup and restore.
- Developed various reports using SSRS and MS Excel.
- Worked on SQL Server Import and Export wizard to load the source data to SQL Server database.
Environment: SQL Server 2005/2008, SSRS, T-SQL, Excel.
