Power Bi Developer Resume
Tulsa, OK
SUMMARY
- Over 5+ years of extensive experience in database design, development, and administration with MS SQL Server versions 2016/2014/2012/2008 R2 using SSIS, SSAS, SSRS in Financial, Retail, Healthcare, Insurance, and Banking industries.
- Experienced with all phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development, and Implementation.
- Strong experience in logical and physical database design and development, Normalization and data modeling using CA Erwin and MS SQL Server Enterprise manager.
- Excellent experience in migration of data from Excel, Flat file, Oracle to Microsoft SQL Server by using SSIS and DTS (Data Transformation Services) utility.
- Experienced in designing high level ETL architecture for overall data transfer from the OLTP - Online Transaction Processing to OLAP - Online Analytical Processing with the help of SSIS.
- Strong experience in designing and developing large number of reports in SSRS using the data from ETL Loads, MS SSAS Cubes and various heterogeneous data sources.
- Worked withT-SQL, DDL,andDMLScripts and established relationships between tables usingPrimary KeysandForeign Keys.
- Expert in designing and scheduling complex SSIS Packages for transferring data manually from multiple data sources to SQL server.
- In depth Knowledge inER ModelingandDimensional modeling(Star and Snowflake Schema) building Dimension, Data marts and Fact tables.
- Expert in creating, configuring and fine-tuning ETL workflows designed in DTS and MS SQL Server Integration Services (SSIS).
- Expert in transforming data from different source (CSV, Flat Files, Excel) to SQL Server databases.
- Experience working with ActiveX data Objects.
- Good Knowledge with VBA Excel.
- Experienced in developing and modifying cubes using SSAS and transform into pivot table.
- Experienced in developing and modifying multi-dimensional cubes using SQL Server Analysis Services (SSAS)
- Good Knowledge on creatingscorecardsanddashboards,KPI'susing POWER BI Dashboard Designer and integrated them with SharePoint Web Services.
- Expert in Creating and Deploying SSRS Reports on the portal for user accessibility.
- Expert in developing Drill through and Drill down reports using Crystal Reports and MS SQL Server Reporting Services (SSRS)
- Highly proficient in the use of T-SQL for developing complex stored procedures, triggers, tables, user functions, user profiles, relational database models and data integrity, SQL joins and query writing.
- Experienced in implementing Key Performance Indicator (KPI) Objects in SSAS 2012.
- Excellent inter personal skills and communication skills and ready to take challenges with proven ability.
TECHNICAL SKILLS
SQL Server/BI Tools: SQL Server Management Studio (SSMS), MS Visual Studio 2010/2008, Business Intelligence development Studio (BIDS), Export & Import (DTS), Query Analyzer, SQL Server Reporting Services (SSRS), SQL Server Integrating Services (SSIS), SQL Server Analysis Services (SSAS), SharePoint 2016,Power BI
Databases: MS SQL Server 2017/ 2016/2014/2012/2008 R 2/2008/2005/2000 , MS Access, Oracle11g/10g/ 9i
Languages: T-SQL, PL/SQL, C#, VB.Net,HTML, CSS, XML, VBA Excel
Operating Systems: MS-DOS, Windows 10/ 7/XP /2008 Server
Database Design Tools and Data Modeling: MS Visio 2008/2011, ERWIN r7/r4/r3.5, Star Schema/Snowflake Schema modeling, FACT & Dimensions tables
Database Tools and Utilities: SQL Server Management Studio, Enterprise Manager Query Analyzer, SQL Profiler, Data Base Engine Tuning Advisor
Version Control Tools: VSS, Sub version, TFS
PROFESSIONAL EXPERIENCE
Confidential, Tulsa OK
Power BI Developer
Responsibilities:
- Perform System and Requirement Analysis, design and writing technical design documents and test plans.
- Design/Build Extract Transform Load procedures in SQL Server Integration Services
- Worked on creating SSIS packages to upgrade SQL Server 2015 to SQL Server 2016.
- Troubleshooting ODBC and OLEDB connection issues in SSIS packages.
- Design and develop mappings, sessions and workflow as per the requirement and Wells Fargo standards
- Design and develop SQL Server 2008 Database, Tables, Indexes, Stored procedures, Views, Triggers.
- Develop the application based on enterprise architecture framework, which includes Understanding and implementing the Enterprise Architecture Best Practices, Guidelines and Standards, ETL framework and Enterprise Scheduling.
- Utilized a combination of stored procedures and Integration Services to enable required data extract, transform and load procedures and packages (ETL).
- Creating reports using SQL Reporting Services (SSRS) for customized and ad-hoc Queries.
- Generated periodic reports based on the statistical analysis of the data from various time frame and division using POWER BI.
- Developed various operational Drill-through and Drill-down reports using SSRS in SSIS and T-SQL (SQL Server).
- Written complexT-SQLqueries and created Stored Procedures, Triggers, Functions and Views using SQL Server 2017, 2016, 2014, 2012
- Review code delivery and manage the version in Team Foundation Server.
- Design/Build Extract Transform Load procedures in SQL Server Integration Services.
- Technical Documentation and Perform reviews, design and data manipulation.
- Production Support and resolving the issues.
Environment: SQL Server 2008 Enterprise Edition, SQL Server Business Intelligence Development Studio (SSAS, SSIS, SSRS),Power BI, Microsoft Office Share Point Server, XML, MS Visual Source Safe and Windows Server 2003.
Confidential
Sr. SQL Developer/BI Developer
Responsibilities:
- Worked with Business Analysts in gathering requirements and translating them to technical specifications.
- Involved in the analysis and profiling of source data, creating prototypes and sample reports to help with requirements and design.
- Using POWER BI delivering enterprise, web-enabled reporting to create reports that draw content from a variety of data sources.
- Created jobs for automatically running stored procedures for day-end operations using SQL Server agent such as index rebuild, data loads and summary reports
- Involved inPerformance Tuningof Code using execution plan and SQL profiler and addedIndexesto improve performance on tables
- Using SQL Server Integration Services (SSIS) to design and maintain ETL Solutions.
- Generated Reports using Global Variables, Expressions and Functions for the reports usingSSRS2010, 2012, 2017.
- Participating in defining ETL strategies, preparing transformation rulesand mappingdatafrom source to target
- Created logging 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.
- Implemented security to restrict the access to users and to allow them to use only certain reports.
- Designed and developed efficientSSISpackages for processing fact and dimension tables with complextransformations.
- Extracted large volumes of data from various data sources and loaded the data into target data sources by performing different kinds of transformations usingSQL Server Integration Services (SSIS).
- CreatedSSISpackages for Uploading of different formats of files (Excel, Access, dbf) and databases (SQL server, Flat files) into the SQL Server data warehouse using SQL Server Integration Services (SSIS).
- Experienced using Visio database design.
- Migrated data from Heterogeneous Data Sources and legacy system (DB2, Access, Excel) to SQL Server databases using SQL Server Integration Services (SSIS) to overcome transformation constraints
- SQL Server Index Maintenance and Performance Tuning for Large Tables
- Rewrote and tuned long-running SQL queries to cut execution time, ease database load and improve scalability.
- Experienced working with Autosys scheduler for reporting and monitoring jobs.
- Experience inETL Data Warehouseenvironment. Created Jobs inSSISand was responsible for ETL job scheduled to run daily.
- Designing and implementing a variety ofSSRSreports such asParameterized,Drilldown, Ad hoc and Sub-reports using Report Designer andReport Builder based on the requirements.
- DesignedSSRSreports withsub reports, dynamic sorting, defining data source and subtotals for the report.
- Developed, monitored and deployedSSISpackages.
- CreatingReportsas per user requirements usingSQL Server Reporting Services 2012.
- Written complexT-SQLqueries and created Stored Procedures, Triggers, Functions and Views using SQL Server 2017, 2016, 2014, 2012.
- Experience in SQL DBA.
Environment: MS SQL Server 2008 R2/2012,2014,2016,2017 Excel 2010, Microsoft Integration Services (SSIS), Microsoft Reporting Services (SSRS), Visual Studio 2010, Windows 7, PowerShell, ASP.Net, C#, UNIX
Confidential, Philadelphia PA
Sr. SQL Server Developer
Responsibilities:
- Worked with Business Analysts in gathering requirements and translating them to technical specifications.
- Involved in the analysis and profiling of source data, creating prototypes and sample reports to help with requirements and design.
- Using SQL Server Reporting Services(SSRS)delivering enterprise, web-enabled reporting to create reports that draw content from a variety of data sources.
- Created jobs for automatically running stored procedures for day-end operations using SQL Server agent such as index rebuild, data loads and summary reports
- Involved inPerformance Tuningof Code using execution plan and SQL profiler and addedIndexesto improve performance on tables
- Generated Reports using Global Variables, Expressions and Functions for the reports usingSSRS2008.
- Participating in defining ETL strategies, preparing transformation rulesand mappingdatafrom source to target
- Created logging 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.
- Implemented security to restrict the access to users and to allow them to use only certain reports.
- Designed and developed efficientSSISpackages for processing fact and dimension tables with complextransformations.
- Extracted large volumes of data from various data sources and loaded the data into target data sources by performing different kinds of transformations usingSQL Server Integration Services (SSIS).
- CreatedSSISpackages for Uploading of different formats of files (Excel, Access, dbf) and databases (SQL server, Flat files) into the SQL Server data warehouse using SQL Server Integration Services (SSIS).
- SQL Server Index Maintenance and Performance Tuning for Large Tables
- Rewrote and tuned long-running SQL queries to cut execution time, ease database load and improve scalability.
- Used Script task to write custom code using C#
- Experience inETL Data Warehouseenvironment. Created Jobs inSSISand was responsible for ETL job scheduled to run daily.
- Designing and implementing a variety ofSSRSreports such asParameterized,Drilldown, Ad hoc and Sub-reports using Report Designer andReport Builder based on the requirements.
- DesignedSSRSreports withsub reports, dynamic sorting, defining data source and subtotals for the report.
- Developed, monitored and deployedSSISpackages.
- CreatingReportsas per user requirements usingSQL Server Reporting Services 2008 R2.
- Created different types of reports such as Cross-Tab, Drill-down, Drill Through, OLAP andSub reports, and formatting them using bothSSRS2008 R2.
- Written complexT-SQLqueries and created Stored Procedures, Triggers, Functions and Views.
- Created data driven subscriptions for different users using Report Manager.
Environment: MS SQL Server 2008 R2/2012, Team Foundation Server, Microsoft SharePoint Server (MOSS 2007), Crystal Reports, SQL Server Integration Services (SSIS), C#, SQL Server Reporting Services (SSRS), Visual Studio 2010, Windows 7,T-, Erwin v8.0, ASP.Net, C#.
