We provide IT Staff Augmentation Services!

Sql Developer / Power Bi Resume

Dallas, TX

PROFESSIONAL SUMMARY:

  • Over 6+ years of extensive experience in MS Business Intelligence with demonstrated success in Database Design, Development and Deployment of large - scale enterprise applications in various IT domains like Insurance, Airlines, Education and Health Care.
  • Highly proficient in SQL Server 2016/2012/2008 , Business Intelligence tools - SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS).
  • Hands on experience in Installing, Configuring, Managing, Monitoring and Troubleshooting SQL Server (2008R2/2012/2016).
  • Experienced in creating and using Stored Procedures, Views, User Defined Functions, Sub-Queries and Joins for complex queries involving multiple tables and Exception Handlers.
  • Proficient in performing database activities like Data Modeling, Data Staging, Data cleansing, Data scrubbing.
  • Experienced in designing Dashboards with various data Visualizations tools like Microsoft Power BI.
  • Experience in Power BI Designer with Power Pivot for Excel, Power View for data visualization and used DAX for use in Calculated columns for reports and analysis purpose.
  • Experience in Extracting, loading data to/from sources like OLEDB, Excel, Flat files etc. using SSIS.
  • Created SSIS packages with Error handling, notifications and Package configurations.
  • Experience in data migrating between different homogeneous/heterogeneous systems and SQL Server as a part of Data Migration and Data Maintenance.
  • Experience in developing Custom Report and different types of Tabular Reports, Matrix Reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
  • Experience in generating Drill Down and Drill through reports with Drop down menu option, Sorting the data, defining Subtotals in SSRS.
  • Used Microsoft Azure date storage and Azure Data Factory , Data Lake
  • Experience in querying Azure SQL Server and working on Microsoft Dynamic CRM
  • Experienced in Designing, Maintaining and Building Cubes, Dimensions, and Data source views, Data mining Models, Deployment and Processing using SSAS. Proficient in writing MDX queries and use Client tools like Excel and Power BI to provide visualizations on Multidimensional or Tabular model Cube data.
  • Created and scheduled Various SQL Jobs, using SQL Server Agent to perform various Administrative tasks.
  • Experience in MS SQL Server Configuration, Performance tuning, Query optimization, Back-up/recovery, running Database Consistency Checks using DBCC. Extensively worked on system analysis, design, development, testing and implementation of projects (SDLC) and capable of handling responsibilities independently as well as a proactive team member.
  • Skilled at assessing client needs, working in groups, suggesting ideas that enhance efficiency and performance, implementing technology solutions, and training end users.

TECHNICAL SKILLS:

Databases: SQL Server 2008/2012/2014/2016 , Oracle, Tera data, DB2, MS Access

Operating Systems: Win XP/Vista/7/10/Linux

Microsoft Tools: Management Studio (SSMS), Business Intelligence Development Studio (BIDS), Enterprise Manager, Query Analyzer, Profiler, Performance Monitor, Database Tuning WizardProgramming Skills

T: SQL, Java, C#, VB.net HTML

ETL Tools: MS Data Transformation services (DTS), SQL Server Integration Services (SSIS)

Reporting: Microsoft SQL Server Reporting Services (SSRS), Power BI, Performance point

Data Modeling: Star Schema Modeling, FACT, Dimensions Tables, Physical, Logical and Conceptual Data Modeling, Visio, Erwin

Scheduling Tools: Windows scheduler, SQL Server Agent

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

SQL Developer / Power BI

Responsibilities:

  • Designed ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse which encompasses server name, database name, accounts, tables and direction of data flow, data dictionary and Metadata using SSIS.
  • Worked on the project using specifically Agile and Scrum methodology with the short-term releases.
  • Created various connection managers (OLE DB connection, flat file connection, ADO.NET connection, Analysis Services connection, Excel connection) available in SSIS to collect data from heterogeneous sources such as Oracle, SQL Server, flat files, excel.
  • Performed Extraction, Transformation and Loading (ETL) data from Flat file, Excel (spread sheet), MS SQL and Oracle to MS SQL Server database by using SSIS services, BCP utility.
  • Used Conditional Split, Data Conversion, Derived Column, Merge Join and Sort All in different SSIS packages based on requirements.
  • Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in different environments. Maintain existing ETL processes and trouble shoot issues as they arise.
  • Created Power BI Visualizations and Dashboards as per the requirements
  • Created effective reports using visualizations such as Bar chart, Clustered Column Chart, Waterfall Chart, Gauge, Pie Chart, Tree map etc. in Power BI.
  • Worked on POC to migrate existing on-premise BI platform to Azure Cloud.
  • Worked on Azure cloud in spinning of new resources under resource group.
  • Worked on Data factory in order to load the data from on premise to Azure Data lake.
  • Configured Integration Runtime (IR) in order to move the data from on premise to cloud.
  • Worked on PowerShell scripts to automate the creation of resources and resource group.
  • Experience working with Azure Data warehouse, created TSQL code to use polybase external tables in order to load data from ADL to ADW.
  • Connecting Power BI to different data sources - SQL databases, Cubes, Web services, Web trends, Excel, Azure
  • Improved Stored Procedures and SQL Queries performance by analyzing execution plans and creating proper Indexes using SQL Profiler and Database Tuning Advisor.
  • Created package configurations for dynamic connection string to enhance the ease of package deployment. Implemented Event Handlers and Error Handling in SSIS packages.
  • Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation.
  • Created and scheduled SSIS Jobs using SQL Scheduler, SQL Server Agent for daily, weekly and monthly loads.
  • Developed stored procedures to transform the data from enterprise data warehouse to Data mart to build dimensions and load data to Fact tables.
  • Generated Sub-Reports, Drilldown reports, Drill through reports and Parameterized reports using SSRS.
  • Involved in Scheduling, creating snapshots and Subscriptions for the reports using SSRS.
  • Modified database structures as directed by developers for test/develop environments and assist with Coding, Design and performance tuning.
  • Worked on all the major SQL-skills like Aggregates, Views, Database objects, stored procedures.

Environment: MS SQL Server 2016/2014, Business Intelligence Development Studio (BIDS), SSIS, SSRS, SSAS, DATA TOOLS, T-SQL, SQL Server Agent, VB.net, C#, Visual Studio 2017/2015 XML, XSLT, MS Office, MS Visual source safe, TFS, MS Excel and MS Visio. Microsoft Visual Studio Tools

Confidential, Houston, TX

SQL Server BI Developer

Responsibilities:

  • C r eat ed a nd Mo di fi e d T ab l es, St or ed Pr oc edu r es, V i e w s, I ndexes, U ser- defi n ed Funct i ons, and T r i gg er s etc.
  • Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
  • Designed and developed SSI S pack a g es ( ET L )t o ext r ac t da t a fr om different da t a sour c es like SQ L Ser v er, F l a t Fi l es, Exc el sour ce f i l es, XML f il e s e t c. and t hen l o ad t he d at a i n t o Dest i na t i on D at a W ar e hous e.
  • Used SSIS transformations such as, For-Each Loop Container, Sequence Container, Expressions, and Execute SQL task.
  • Updated data in tables based on the user requirement using Temp tables and Joins.
  • Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
  • Analyzed the requirements and systematically designed the Data mart for the online Services. Identified the Dimensions, Fact tables and designed the data mart using Star schema.
  • Created complex Stored procedures with parameters and generated Multi Parameterized SSRS reports from them, where the user has a choice to select the parameters.
  • Developed report specifications, created and modified reports using SSRS.
  • De pl o y a nd sc h e dul e Re por t s usi ng S Q L S er ve r R e por ti ng S er vic e s t o ge n era t e a l l da i l y, w ee kl y, m ont hl y, q uar t er l y a nd ra ndom A d - h oc re por t s f o r var i ous bus i ne ss user s.
  • Responsible for detailed analysis and design using Microsoft Technologies for services that will support internal and external clients facilitate and deliver on business needs for Functional and Business mapping.
  • Implemented OLAP Cubes for providing Summarized and Aggregate views of large sets of data. Multi-Dimensional Expression (MDX) to access them.
  • Created Drill down, Drill through, cascading parametric and Sub reports from SSAS cubes that can be browsed on web.
  • Gathered report requirements and determined the best solution to provide the results in either a Reporting Services report or Power BI.
  • Installed and configured Power BI Desktop.
  • Created Power BI Visualizations and Dashboards to showcase metrics on Hotel occupancy forecast.
  • Developed Calculated columns and measures using DAX in Power BI.
  • Used the Tabular model cubes as the source in Power BI to visualize the data.
  • Created Power BI dashboard and generated reports.
  • Performed Power BI Desktop Data modeling, which cleans, transforms, mash up Data from multiple sources.
  • Created multiple transformations and loaded data from multiple sources into the Power BI Dashboard.
  • Created effective reports using visualizations such as Bar chart, Clustered Column Chart, Waterfall Chart, Gauge, Pie Chart, Tree map etc. in Power BI.
  • Troubleshooting performance issues and Fine-tuning queries and Stored procedures.
  • Worked very closely with Business Customers, End Users and resolved any business process related issues.

Environment: SQL Server 2016/2014/2012 , SSAS, Server Integration Services, SQL server Reporting Service, Microsoft Visual Studio, SQL Server Management Studio, IIS, MS Excel, T-SQL, ERWIN 7.2, C#

Confidential, Springfield, IL

Application Developer

Responsibilities:

  • Extensively worked on Data modeling, data analysis, reporting, and SQL development.
  • Developed SQL queries with Multi-table joins, Group functions, Sub queries and T-SQL stored procedures, User defined functions (UDFs) for data analysis.
  • Created and modified the indexes on the tables and views for the improvement in the performance of SQL Stored procedures.
  • Worked on Views, Cursors, CTE’s, Schemas, Permission and performance issues with client/server database design.
  • Involved in all stage of software development life cycle (SDLC) in collaboration with Sr. business analyst and Lead developer.
  • Design and document the Error-handling strategy in the ETL load process using Event handlers. Consistently use this error handling techniques in all the mappings.
  • Developed modular ETL applications which enable the flow of data between data sources using SSIS.
  • Worked on different kinds of Transformations in SSIS like Slowly changing dimension (SCD’s), Lookup, Merge, Derived column, Multicast, Conditional split, Aggregate, Fuzzy lookup, Pivot and Un Pivot as per the client requirement.
  • Worked with SSIS packages involved FTP tasks, Merge, and Merge joining, Sort, Pivot and Unpivot Control Flow Transformations
  • Developed Spreadsheets to Schedule Jobs to automate the SSIS packages.
  • Created SQL Server Reports based on the requirements using SSRS.
  • Generated matrix reports, tabular, drill-down, drill-through, sub reports, chart reports, multi parameterized reports.
  • Rendered the reports to PDF formats as per the requirement and printing all the reports in a batch process for Monthly Statements.
  • Expertise in Configuring and Deploying SSRS reports onto Report Server.
  • Troubleshoot the deployment of reports in the test and production environment using SSRS
  • Created SSIS packages extract, transform and load data to data warehouse databases and process SSAS cubes to store data to OLAP databases.
  • Involved in analysis of Report design requirements and actively participated and interacted with Team Lead, Technical Manager and Lead Business Analyst to understand the Business requirements.
  • Worked for Development in error and bug fixing during testing phase for making the project run successfully.

Environment: MS SQL Server 2012, 2008 R2/2008, SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), T-SQL, SQL Server Agent, Java, C#, DB2, Visual Studio 2008/2005, XML, XSLT, MS Office and Visual source safe, Requisite Pro, TFS, MS Excel, and MS Visio

Confidential, St.Louis, MO

SQL Server BI Developer

Responsibilities:

  • Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
  • Designed and developed SSI S pack a g es ( ET L )t o ext r ac t da t a fr om different da t a sour c es like SQ L Ser v er, F l a t Fi l es, Exc el sour ce f i l es, XML f il e s e t c. and t hen l o ad t he d at a i n t o Dest i na t i on D at a W ar e hous e.
  • Used SSIS transformations such as, For-Each Loop Container, Sequence Container, Expressions, and Execute SQL task.
  • C r eat ed a nd Mo di fi e d T ab l es, St or ed Pr oc edu r es, V i e w s, I ndexes, U ser- defi n ed Funct i ons, and T r i gg er s etc.
  • Updated data in tables based on the user requirement using Temp tables and Joins.
  • Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
  • Analyzed the requirements and systematically designed the Data mart for the online Services. Identified the Dimensions, Fact tables and designed the data mart using Star schema.
  • Created complex Stored procedures with parameters and generated Multi Parameterized SSRS reports from them, where the user has a choice to select the parameters.
  • Developed report specifications, created and modified reports using SSRS.
  • Designed new dynamic SSIS Packages to transfer data between servers, load data into Database and tuned the existing packages.
  • De pl o y a nd sc h e dul e Re por t s usi ng S Q L S er ve r R e por ti ng S er vic e s t o ge n era t e a l l da i l y, w ee kl y, m ont hl y, q uar t er l y a nd ra ndom A d - h oc re por t s f o r var i ous bus i ne ss user s.
  • Created and scheduled Various SQL Jobs, using SQL Server Agent to perform various Administrative tasks such as data loading, batch jobs.
  • Responsible for detailed analysis and design using Microsoft Technologies for services that will support internal and external clients facilitate and deliver on business needs for Functional and Business mapping.
  • Implemented OLAP Cubes for providing Summarized and Aggregate views of large sets of data. Multi-Dimensional Expression (MDX) to access them.
  • Created Drill down, Drill through, cascading parametric and Sub reports from SSAS cubes that can be browsed on web.
  • Gathered report requirements and determined the best solution to provide the results in either a Reporting Services report or Power BI.
  • Installed and configured Power BI Desktop.
  • Created Power BI Visualizations and Dashboards to showcase metrics on Hotel occupancy forecast.
  • Developed Calculated columns and measures using DAX in Power BI.
  • Used the Tabular model cubes as the source in Power BI to visualize the data.
  • Created Power BI dashboard and generated reports.
  • Performed Power BI Desktop Data modeling, which cleans, transforms, mash up Data from multiple sources.
  • Created multiple transformations and loaded data from multiple sources into the Power BI Dashboard.
  • Created effective reports using visualizations such as Bar chart, Clustered Column Chart, Waterfall Chart, Gauge, Pie Chart, Tree map etc. in Power BI.
  • Troubleshooting performance issues and Fine-tuning queries and Stored procedures.

Environment: SQL Server 2016/2014/2012 , SSAS, Server Integration Services, SQL server Reporting Service, Microsoft Visual Studio, SQL Server Management Studio, IIS, MS Excel, T-SQL, C#

Confidential

SQL Analyst / Developer

Responsibilities:

  • Performed and fine-tuned Stored Procedures and SQL Queries and User Defined Functions for better data retrieval.
  • Used various ETL tools like SSIS for data flow from source files like XML, Excel, Tables and views to other databases or files with proper mapping.
  • De pl o y t h e S S I S pa c ka g e s on di ffere nt env i ronm en ts t o l oa d t he da t a i nt o da t a ware hous e.
  • Managed Package Configurations in XML Files to efficiently Promote Unit Tested Packages to Live Environment from Development Environment.
  • Design, deployment, and maintenance of various SSRS Reports in SQL Server Environment.
  • Created Tabular and Matrix Reports with all aggregate functions and expressions.
  • Designed and developed complex reports using Cascading parameters, Drill-Through Reports, Parameterized Reports and Report Models and Ad-hoc reports using SQL Server Reporting Services (SSRS) based on business requirements.
  • Worked closely with end-user clients to understand their reporting needs and provided necessary solution.
  • Using SQL server reporting services (SSRS) delivering enterprise, Web-enabled reporting so create reports that draw content from a variety of data sources.

Environment : MS SQL Server-2008 Enterprise Edition, SSIS, SSAS, SSRS, T-SQL, DTS, SQL Profiler, Erwin VB.NET, OLAP, OLTP, Erwin, Performance Point Sever, Office-2007, MS Excel, C#. NET, ProClarity Analysis.

Hire Now