Azure Sql (ssis/ssas)/power Bi Developer Resume
San Francisco, CA
PROFESSIONAL SUMMARY:
- Over 8 years of experience in Data modelling, Database Design, Programming, Development, and Implementation of Client Server Applications and Database Systems using MS SQL Server 2012/2014/2016.
- Experience and knowledge of working in various domains such as Retail, Health Care, Telecom, Supply Chain, and Financial.
- Extensive experiences in developing Stored Procedures, Views, Triggers and Complex Queries, T - SQL - Programming, query optimization and performance tuning on SQL Server.
- Data analytics and engineering in multiple Azure platforms such as Azure SQL, Azure SQL Data warehouse, Azure Data Factory, Azure Storage Account etc. for source stream extraction, cleansing, consumption and publishing across multiple user bases.
- Highly proficient in design and development of SQL Server Integration Services ( SSIS ) packages and using various control flow tasks and data flow transformations.
- Used SSIS for (ETL) extraction, transformation and loading data from heterogeneous source systems into target database.
- Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using DTS and SSIS services.
- Experience in using Microsoft BI studio products like SSAS , SSRS and SSIS for implementation of ETL methodology in data extraction, transformation and loading.
- Gathering Requirements from diverse groups, assessing technical needs, creating prototypes.
- Expertise in installing, designing, developing, maintaining and tuning of RDBMS.
- Expert in Tabular Modeling, Multi-Dimensional Cubes, DAX and MDX ( SSAS ).
- Expertise in creating various type of reports such as Complex drill down & drill through reports, parameterized reports, Matrix reports, Cascaded, Sub reports and Charts using SQL Reporting Services ( SSRS ) based on Relational and OLAP databases. Designing, Scheduling and Maintaining ETL Framework for different Processes.
- Integrated Custom Visuals based on business requirements using Power BI desktop.
- Created different visualization in Power BI according to the requirements.
- Explore data in a variety of ways and across multiple visualizations using Power BI.
- Experienced in installing Power BI, developing Power BI Reports and Dashboards from multiple data sources using Data Blending.
- Effective in working independently and collaboratively in team.
TECHNICAL SKILLS:
SQL Server: C#.Net, VB.Net
PROFESSIONAL EXPERIENCE:
Confidential, San Francisco, CA
Azure SQL (SSIS/SSAS)/Power BI Developer
Responsibilities:
- Created Stored Procedures, Triggers, Indexes, User defined Functions, Constraints etc. on various database objects to obtain the required results.
- Experience in Writing Complex T-SQL Queries, sub-queries, Complex joins.
- Designed and developed ETL Mappings to extract data from flat files, MS Excel and Oracle to load the data into the target database.
- Worked with the DW Development team to implement data strategies, build data flows, data modelling and develop conceptual data models.
- Responsible to tune ETL procedures and STAR Schemas to optimize load and query performance.
- Setting up Connection Strings and connecting SQL Server Azure Databases from locally Installed SQL Server Management Studio (SSMS).
- Created SSIS packages for File Transfer from one location to the other using FTP task.
- Used ETL ( SSIS ) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
- Build efficient SSIS packages for processing fact and dimension tables with complex Transforms
- Experience in using C#. net in script component of SSIS .
- Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.
- Designed tabular models with Star Schema using SQL Server Analysis Services ( SSAS ).
- Created several reports and dashboards in Power BI using SQL Server Analysis Services ( SSAS ) as data source.
- Created calculated measures using MDX queries; designed and created aggregations to speed up queries and improve performance in SSAS .
- Designed dimensions and hierarchies in SSAS tabular models based on star schema from Data warehouse.
- Used various sources to pull data into Power BI such as Azure SQL Database, Azure Analysis Services.
- Created paginated reports using Power BI report builder and scheduled jobs and added subscriptions to the report.
- Developed custom calculated measures using DAX in Power BI to satisfy business needs.
- Implemented several DAX functions for various calculations for efficient data visualization in Power BI .
- Integrated Power BI reports into Power Apps and published all the reports and updates to the report using apps.
- Maintained existing Power BI reports and dashboards and made changes onto the same as per new and changing business requirements.
Environment: SQL Server 2014/2016, T-SQL , Azure Data Factory , Integration Services ( SSIS ), Azure SSAS, Power BI, DAX, Power Apps .
Confidential, Parsippany, NJ
SQL (SSIS/SSAS)/Power BI Developer
Responsibilities:
- Created and wrote database objects such as tables, indexes, views, procedures, functions, triggers, T- SQL code with proper grants to all the users and roles.
- Implemented Error Handling and Logging in SQL Server Integration Services ( SSIS ).
- Migrated all DTS packages to SQL Server Integration Services ( SSIS ) and modified the package as per the advanced feature of SQL Server Integration Services.
- Involved in Design, analysis, Implementation, Testing and support of ETL processes for Stage, (Operational Data Source) ODS and Data Mart.
- Extensively used ETL process for address data cleansing.
- Involved in requirement gathering and performed ETL Process.
- Created SSIS package to load data from Flat File to Flat File and Flat File to SQL Server using Lookup, Derived Columns, Condition Split, Aggregate, and Pivot Transformation.
- Developed, deployed and monitored SSIS Packages using visual studio.
- Used containers, Execute SQL task, Execute package task, Script task etc. for transformation of data in the SQL Server Integration Services packages.
- Designed dimensions and hierarchies in SSAS tabular models based on star schema from Data warehouse.
- Developed Tabular Models using SQL Analysis Services ( SSAS ).
- Experience in Designing and Building the Dimensions with star schema using SQL Server Analysis Services ( SSAS ).
- Built cubes and tabular models for production application, Partitioned Cubes to decrease the processing time and increase the performance of the queries running on front end application using Azure SSAS .
- Assisted in production Tabular Models, wrote queries to produce reports using Azure SQL Server Analysis Services ( SSAS ) and Power BI.
- Developed measures and calculated columns using DAX in tabular models and Power BI.
- Used DAX to create user defined relationships between tables in tabular model.
- Used various time related and other DAX functions to create and develop measures and KPI’s.
- Published Power BI reports from Power BI desktop to Power BI service .
- Used Power BI and embedded Power BI reports into ASP.Net applications.
- Creating stored procedures and some complex queries to embed this in SSRS reports.
- Responsible for all the client deliverables.
Environment: SQL Server 2008/2014/2016 , T-SQL , Reporting Services ( SSRS ), Integration Services ( SSIS ), Analysis Service (SSAS) , BI Tool Kit, Power BI, DAX .
Confidential, White Plains, NY
SQL/BI (SSIS/SSAS/SSRS) Developer
Responsibilities:
- Involved in writing complex SQL queries & Stored Procedures, Functions ( T-SQL ) & Performance Tuning.
- Strong experience in T-SQL Query, Stored Procedure development and tuning, C# . NET / VB.NET support and development.
- Implemented Error Handling and Logging in SQL Server Integration Services ( SSIS ).
- Migrated all DTS packages to SQL Server Integration Services ( SSIS ) and modified the package as per the advanced feature of SQL Server Integration Services.
- Used containers, Execute SQL task, Execute package task, Script task etc. for transformation of data in the SQL Server Integration Services packages.
- Created SSIS package to load data from Flat File to Flat File and Flat File to SQL Server 2005 using Lookup, Derived Columns, Condition Split, Aggregate, and Pivot Transformation.
- Migrated DTS packages to SSIS packages using package migration wizard.
- Built tabular models for production application, Partitioned Cubes to decrease the processing time and increase the performance of the queries running on front end application using SSAS .
- Designed and implemented SSAS Tabular model as the reporting layer and used DAX scripting to access data from Tabular Model.
- Advanced extensible reporting skills using SQL Server Reporting Services ( SSRS ).
- Worked on developing Power BI reports and dashboards from multiple sources.
- Created many complexes Query's and used them in Power BI Reports directly to generate reports .
- Responsible for all the client deliverables.
Environment: SQL Server 2005/2008, T-SQL, Data Transformation Services (DTS), Advanced Reporting Services ( SSRS ), Integration Services ( SSIS ), SSAS , BI Tool Kit, Power BI .
Confidential, San Antonio, TX
Sr. SQL/BI (SSIS/POWER BI/SSAS) Developer
Responsibilities:
- Writing T-SQL scripts, dynamic SQL, complex stored procedures, functions, triggers and SQLCMD.
- Developed various T-SQL stored procedures, views, and adding/changing tables for data extraction, data load and transformations.
- Scheduled Jobs for executing the stored SSIS packages which were developed to update the Database on Daily basis.
- Used some data conversion tasks in SSIS to load the data from flat file to SQL Server database.
- Created packages in SSIS with error handling.
- Implemented Complex business logic with User-Defined- Functions, Indexed Views and created User Defined Data type, Clustered & Non-clustered Indexes.
- Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation. Developed, monitored and deployed SSIS packages.
- Experience in Developing and Extending SSAS tabular models, Dimensions and data source views, SSAS-Data Mining Models and Deploying and processing SSAS objects.
- Involved in creating data source views, dimensions, KPIs, Attribute relationships, Calculations, Translations, Perspectives, Actions and Deploying SSAS Cubes.
- Experience in working on Cube structure optimization for MDX query performance in Analysis Services 2012/2014 (SSAS).
- Developed complex Stored Procedures to generate various Drill-through reports, Parameterized reports, Tabular reports, Matrix reports and linked reports using SSRS.
- Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports.
- Designed and documented the entire Architecture of Power BI POC.
- Wrote calculated columns, Measures query’s in Power BI desktop to show good data analysis techniques.
- Managed and viewed the security roles as per the requirement to implement the row level security.
- Used Team Foundation Server (TFS) for version control of the code.
Environment: SQL Server 2012/2014 Enterprise Edition, SSIS, SSRS, SSAS, C#, Visual Studio 2010/2015, MS Visio, Team Foundation Server (TFS), Power BI.
Confidential, Cleveland, OH
MS SQL/SSIS/SSRS Developer
Responsibilities:
- Extensive experience and knowledge in T-SQL, DML, DDL, DCL, Transactions, Joins, Stored Procedures, Triggers and Functions .
- Wrote various stored procedures for application development.
- Performed backup/restore, database objects such as tables, procedures, triggers, constraints, indexes and views.
- Installing, Configuring and Administering SQL server 2008 R2.
- Defined Check constraints, Business Rules, Indexes, and Views.
- Created stored procedures, views, triggers, user defined functions to in corporate the flow of business and called various stored procedures from DTS to make the flow of DTS effective.
- Responsible for creating the reports based on the requirements using SSRS tool.
- Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
- Thorough Software Development life cycle (SDLC) experience including development, designing, analysis, coding, testing and implementation. (i.e. Agile/Scrum, Waterfall)
- Created SSIS process design and architected the flow of data from various sources to target.
- Developed, monitored and deployed SSIS packages.
- Utilized SSIS (SQL Server Integration Services) to produce a Data Mart for reporting.
- Implemented SSIS data transformation scripts, created maintenance procedures and provided data integrity strategies.
- Used multiple join statements to retrieve data from multiple tables.
- Continuously interacted with users to gather business requirements.
- Wrote parameterized queries for generating reports in SSRS .
- Designed and created data extracts, supporting SSRS, POWER BI .
- Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
Environment: SQL Server 2005/2008, T-SQL, Data Transformation Services (DTS), Advanced Reporting Services ( SSRS ), Integration Services ( SSIS ), BCP, SQL Profiler.
Confidential
SQL Server Developer
Responsibilities:
- Installation of SQL Server on Development and Production Servers, setting up databases, users, roles and permissions.
- Responsible for all technical SQL Server database operations, Administration, ongoing development for various in-house databases.
- Designed and Developed Database Objects like Tables, Stored Procedures, Triggers, Rules, Defaults, user defined data types, dynamic scripts and functions for this project.
- Created Indexes to get the high-level performance.
- Performing the ETL operations to support the data loads and transformations using SSIS.
- Maintained databases, performed software installations and upgrades, monitored Database Performance.
- Implemented automated backup and database maintenance / cleanup jobs.
- Managing Logins, Users, Roles and User permissions.
- Running Trace from the Profiler to trouble shoot database and running DBCC consistency checks for other database maintenance aspects.
- Created and scheduled jobs for various tasks and was responsible for maintaining jobs.
- Created data-related documentation (e.g., file descriptions and definitions, entity relationships and attributes, etc.).
Environment: MS SQL Server 2005/2008, Excel, Access, Visual Studio 2005/2008, Database Engine Tuning Advisor, SQL Server Management Studio (SSMS), Business Intelligence Development Studio (BIDS), Windows 2003 Server, Windows XP, SQL Profiler.