Sql/ Power Bi Developer Resume
Atlanta, GA
SUMMARY
- 8 years’ of decent experience in business intelligence Applications Design, development, and maintenance of integration services (SSIS), SQL server reporting services (SSRS).
- SQL development professional with strong verbal and written communication skills
- Strong experience in all areas of SQL server development including tables, user Functions, joins, triggers, views, indexes, store procedures, clustering, T - SQL, SQL server constraints (primary keys, foreign keys, unique, checks and defaults), relational database models, data dictionaries and data integrity.
- Explore data in a variety of ways and across multiple visualizations using power BI.
- Published power BI reports from power BI desktop to power BI service
- Created different visualization in power BI according to the requirements.
- Developed SSIS packages utilizing LOOKUP, merge, sort, derived columns, conditional split, Aggregate, Execute SQL Task, and Execute package Task to produce underlying data for the reports and to transfer cleaned data from Excel, text file, and XML file to different data marts.
- Work knowledge SQL Server security features such as ownership chaining.
- Interacting with the business users for understanding the business requirements and the existing system.
- Setup and configure azure Devos environment
- Translated business needs into data analysis intelligence data sources and reporting solutions for different types of data.
- Worked on data transfer from a text file to SQL server by using bulk insert task in SSIS.
- Create page level filters, Report level filters, visual level filters in power BI according to the requirements.
- Created different visualization (stacked bar chart, clustered bar chart, scatter chart, pie chart, Donut chart, Line & clustered column chart, map, slicer, Time Brush etc.)
TECHNICAL SKILLS
DBMS: SQL Server 2019/ 2016/2014/2012 and 2008
Languages: SQL
Operating Systems: Windows server 2003/XP/NT6.0/98/Vista,7,8,10,16
Development Methodology: Agile/SCRUM
Reporting Tools: Power BI, SQL server 2016/2014/2012/2008
ETL Tools: Power BI, SQL server Integration Services (SSIS) 2016/2014/2012/2008
Data Modeling: Erwin r7.3/7x/4.0, MS Office Visio 2003/2007.
Office Tools: MS Word, PowerPoint, Excel, Visio, One note, MS Operations Manager
PROFESSIONAL EXPERIENCE
Confidential, Atlanta, GA
SQL/ POWER BI Developer
Responsibilities:
- Collaborate with application developers in creating databases and tables to support development activities and drive optimal efficiency.
- Institute complex stored procedures, triggers, functions, indexes, tables, views, SQL joins, and other T-SQL code for business rules implementation.
- Development and maintenance of configuration control policies to identify Hygiene breaks, using SQL Stored Procedures
- Execute performance tuning, queries optimization, and redundant and inconsistent data removal.
- Apply stored procedures for the transformation of data from enterprise data warehouse to data mart to build dimensions and load data to fact tables.
- Experience in SQL & PL/SQL modules such as packages, procedures, functions, and other database objects
- Develop SSIS packages utilizing LOOKUP, Merge, Sort, Derived Columns, Condition Split, Aggregate, Execute SQL Task, and Data Flow Task, and Execute Package Task to produce underlying data for the reports and to transfer cleaned data from Excel, text file, and XML file to different data marts.
- Maintain better running of DTS packages through SQL Joins, sub queries, tracing, and performance tuning.
- Complete incremental load with several Data Flow Task and Control Flow Tasks using SSIS and created and implemented master child package using variables in SSIS.
- Initiate physical database analysis and feasibility requirements encompassing performance, security, archival, maintenance, and recovery requirements.
- Design VB.NET code for script task to perform unavailable functions in the built-in tasks and to enable SSIS transformations.
- Design, Plan and Migrate deployments of customer on-premises data center/applications to Microsoft Azure.
- Improve queries and database performance using Execution Plan and Database Engine Tuning Advisor
- Develop quick small applications using Microsoft PowerApps, Power Automate, SharePoint online and Azure Cognitive services
Confidential, Atlanta, GA
SQL/ POWER BI Developer
Responsibilities:
- Interacted with the business users for understanding the business requirements and the existing system.
- Translated business needs into data analysis, business intelligence data sources and reporting solutions for different types of information consumers.
- Created complex SQL stored procedures, Triggers, Functions, Views, Indexes in SQL Server 2016.
- Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables & calculations from different databases.
- Created many complex Query's and used them in Power BI Reports directly to generate reports on the fly.
- Designed SQL SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL Server 2016 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge, and union all.
- Design, Plan and Migrate deployments of customer on-premises data center/applications to Microsoft Azure.
- Used SSIS Package identified the Up-streams and imported the required tables into intake-database, Store Procedures are created in staging database using the intake-database tables & views.
- Checked the code into TFS (Store Procedures, Views, Tables, Schema) for the deployment process for the production environment.
- Created KPI's, Partitions, Perspectives, and Calculated Measures, used DAX queries, Roles.
- Created reports in Power BI preview portal utilizing the Tabular Model via Analysis connector.
- Created different visualization (Stacked bar Chart, Clustered bar Chart, Scatter Chart, Pie Chart, Donut Chart, Line & Clustered Column Chart, Map, Slicer, Time Brush etc.) in Power BI according to the requirements.
- Created Page Level Filters, Report Level Filters, Visual Level Filters in Power BI according to the requirements.
- Used One Drive for storing different versions of Power BI report.
- Queried Microsoft SQL Server R2 / 2012
- Created Dashboard and the Content Pack for the originations to get the updated Power BI Reports. And added the refresh time for each tile in the dashboard.
Environment: MS SQL Server 2014/2016 T-SQL, MS SQL Integration Services 2014/2016, Power BI.
Confidential, Atlanta, GA
SQL BI/ETLDeveloper (SSIS/SSRS)
Responsibilities:
- Gathered requirements from the business analyst and preparing POC documents for the design & development of BI solutions (ETL/Reporting)
- Used SSIS, loaded XML data to the Database tables and Extracting Data using SSIS into Excel Files for Marketing purpose.
- Designed BI solutions with Microsoft SQL Server R2 / 2012
- Used multiple transformations in SSIS to meet the business requirements by extracting data from heterogeneous source systems, transform and finally load into the Staging Data base.
- Involved in SSIS ETL Transformation for de-normalization of data sources using UNPIVOT and UNION.
- Extensively worked in ETL and data integration in developing ETL mappings and scripts using SSIS.
- Worked on Data transfer from a Text file to SQL Server by using bulk insert task in SSIS.
- Created Crystal Reports with ole object extracting image file from the database and URL links.
- Designed, Implemented and maintained Database Schema, Entity relationship diagrams, Data modeling, Tables, Stored procedures, Functions and Triggers, Constraints, Indexes, Functions, Views Rules, Defaults, and complex SQL statements.
- Written high performing SQL (DML, DDL), triggers, stored procedures, and packages.
- Written complex SQL queries to retrieve data from Dynamic CRM and display in SSRS reports. Created SSIS job to verify accounts and leads from excel file.
- Developed the SQL programs and involved in optimize stored procedures and queries for faster retrieval and server efficiency SSRS and SSIS.
- Performance tuning of SQL queries and stored procedures using server Profiler and Index Tuning Wizard in SSRS and SSIS.
- Worked in importing and cleansing of data from various sources like DB2, Oracle, flat files.
- T-SQL programming, Complex Query writing, Query Optimization and Database Tuning.
- Written T-SQL scripts, dynamic SQL, complex stored procedures, functions, triggers and SQLCMD.
Environment: SQLServer2012, 2008/2008 R2, Business Intelligence Studio (SSIS, SSRS), T SQL, Erwin, TFS, MDX, Oracle 10g, ProClarity, MS Excel.
