Sql/ssis/ssrs/power Bi Developer Resume
Oakland, CA
SUMMARY:
- Highly motivated MS Business Intelligence Developer and Data Engineer with more than 8 years of experience working with BI applications such as SSMS, SSIS, SSRS, SSAS, Power BI, ADF in Development, Test and Production Environments, visualization tools such as Power BI and Tableau. A solution - driven, well-organized, effective team member with excellent analytical mind, able to quickly acclimatize to the given role and deliver results. Hand-on work experience in different industries such as healthcare, service, leasing and insurance.
TECHNICAL SKILLS:
Databases: SQL Server 2017/16/ R2, Oracle 11g/8.0i, MS Access 2000/8.0
Languages: T-SQL, MDX, DAX, PL/SQL, VB.NET, XML, C#, ASP.NET, .NET Framework
Web Tools: ASP.Net, C#.Net, Visual Studio.Net, VB.Net, JavaScript, XHTML5, VB Script
ETL & Reporting: C#.Net, ASP.Net, VB.Net, Visual Studio.Net, XHTML5, JavaScript, VB ScriptSSDT 2017/16/14/12, BIDS 2008R2/08, SQL Server Integration Services (SSIS 2017/16/ 2014/2012/2008 R2), SQL Server Reporting Services (SSRS 2016/2 R2)Power BI, SQL Server Analysis Services (SSAS)
Others: MS Office, Crystal Reports XI, Visual web developer, SQL Server Notification ServicesWindows Scripting Host, MS FrontPage, MS Visual, SAS/Access, Crystal ReportsSAP Business Objects, Micro Strategy, Microsoft TFS, Microsoft GIT, MS VSSHP Quality Center & Jira
PROFESSIONAL EXPERIENCE:
Confidential, Oakland, CA
SQL/SSIS/SSRS/Power Bi developer
Responsibilities:
- Developing and maintaining SQL objects, stored procedures, Views, UDF’s based on the business requirements
- Developing and maintaining SSIS packages to load datawarehoue using lookup, merge join, SCD, script task etc.. tasks and transformations
- Creating configuration and deploying ssis packages to SSIS server
- Doing Lift and shift SSIS packages to the cloud using self hosted IR
- Maintaining all existing SQL agent and Austosys jobs in UAT & Production
- Creating SSRS reports and adhoc queries for the internal business
- Deployed SSRS reports to share point server and used Excel services in Share point application
- Converting SSRS reports to Power bi reports and publishing some rdl files as paginated reports to the cloud.
- Transforming and cleaning data in power query and creating star and snowflake schema design model in power bi desktop
- Creating power bi reports and dashboards using different types of visual In power bi desktop
- Creating data refresh for power bi reports using REST API and refreshing them up to 48 times a day
- Creating calculated columns and measures using complex DAX functions like calculate, sum, sumx, rankx... etc
- Publishing and sharing power bi reports with business, creating apps and setting up subscriptions
- Migration of On prem SQL db to Azure SQL db and creating external data sources, external tables
- Creating CI/CD process using devops for DDL and ssis packages deployment
Confidential, Los Angeles, CA
(SQL/SSIS/SSRS/Power BI Developer)
Responsibilities:
- Developed T - SQL Scripts to validate the data after the loading process. Modified and tested T-SQL stored procedures
- Written complex SQLs using joins, sub queries and correlated sub queries. Expertise in SQL Queries for cross verification of data.
- Transformer, Lookup, Merge, Join, Aggregator, Sort, Filter and Remove duplicates stages were extensively used to Cleanse/Transform the data extracted into staging.
- Modified and tested T-SQL stored procedures.
- Experience work with cloud systems (Azure): pushing and pulling data from azure blob
- Actively participated in migration of on-premise SQL Server schemas to cloud on Azure SQL Server DB and Azure VM and developed and maintained databases across both on-premise and cloud deployments
- Designed SSIS packages and Azure Data Factory pipelines to Extract, Transfer and Load (ETL) existing data into Data Warehouse from different source environments such as ERP, CRM, Azure, and other systems.
- Experience in supporting Microsoft Azure systems including SQL Server hosted on Azure Virtual Machine (IaaS) and Azure SQL Databases (DBaaS).
- Worked with subject matter experts to prepare sources to target mapping documents for the migration project.
- Worked on bringing on prem SQL data into Snowflake bronze layer using ADF and developed data modeling in silver layer and created pipeline to load data from bronze to silver incrementally.
- Developed data warehouse process models, including sourcing, loading, transformation, and extraction of source data.
- Used SSIS and extract transform loading (ETL) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for application; Making changes to existing ETLs and building some new ETL processes.
- Using C#, visual basic.Net in SSIS script tasks and script components with variables
- Created packages using the various control flow tasks such as Data Flow Task, Execute SQL Task, Execute Package Task, File System Task.
- Develop and deploy SSIS packages, configuration files, and scheduled jobs to run the packages to generate data in CSV files.
- Create log files using providers like XML, text file, SQL server.
- Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
- Developed/Deployed SSIS packages through package installation wizard, Bids Deployment, Management Studio Import to further automate data processes.
- Data Automation Using SSIS to automate data processes for input of information.
- Proficient in developing parameterized reports, chart, graphs, linked reports, drill-down reports using SSRS/Power BI;
- Involved in creating dynamic well-organized, accurate and insightful Power BI reports/dashboards to support strategic decisions.
- Created Parameterized, Crosstab, Drill Down and Summary reports by Using SSRS and created report snapshots to improve the performance of SSRS.
Confidential, San Leandro, CA
BI Developer (SQL\SSIS\SSRS\Power BI )
Responsibilities:
- Worked with Business Users and Business analyst in gathering requirements and preparing the functional and technical documentation.
- Developed complex T - SQL code such as Stored Procedures, functions, triggers, Indexes and views for the application.
- Used Temporary tables, table variables in Stored procedures to simply complex queries
- Optimized queries by analyzing different query options and indexing strategies.
- Developed T-SQL Scripts to validate the data after the loading process. Modified and tested T-SQL stored procedures
- Written complex SQLs using joins, sub queries and correlated sub queries. Expertise in SQL Queries for cross verification of data.
- Employed best practices in creating a complete schema including tables, relationships, stored procedures, views, clustered and non-clustered indexes and triggers, and implemented the import and export of data using SSIS.
- Created ETL packages that reads Product, Vendor, and Order data from an FTP server into a SQL Server database. The solution also validates incoming Data and performs notifications when jobs complete.
- Created SSIS packages to load data from Heterogeneous sources like Flat files, CSV files and Excel.
- Implemented custom logging to keep track of the packages being run automatically. Configured the packages to run on different servers using Package Configurations.
- Created packages in SSIS with error handling using Event handlers.
- Used various transformations in SSIS like Lookup, Derived Column, Union all, Merge to modify the data which is stored in various forms efficiently.
- Using C#, visual basic.Net in SSIS script tasks and script components with variables
- Develop and deploy SSIS packages, configuration files, and scheduled job to run the packages to generate data in CSV files and scheduled SSIS packages using SQL Server Agent, Jams.
- Created SSIS packages to clean and load data to the data warehouse.
- Created SSIS package to transfer data between OLTP and OLAP databases using Incremental Load.
- Created SSIS Packages using Fuzzy Lookup, Derived Columns, Pivot Transformation, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
- Individually authored, installed, deployed and managed reports using SSRS 2017.
- Generated drill through, drill down which projected data as per the user requirements using SSRS.
- Implemented Conditional formatting using Expressions in SSRS 2017.
- Created Parameterized reports using Text and Stored procedures as source in SSRS 2017.
- Deployed SSRS reports to share point server and used Excel services in Share point application.
- Managed subscriptions and data-driven report subscriptions to provide timely reports to the clients and end users, also created snapshots to reduce loading time.
- Converted more than 200 Tableau Maintenance, Finance, Lease reports to SSRS to support business user requirements.
- Created Power BI Visualizations and Dashboards as per the requirements.
- Designed and implemented Dashboards and Scorecards with business KPIs using PerformancePoint Server.
Confidential, Los Angeles, CA
SQL/SSIS/SSRS Developer
Responsibilities:
- Interacted with business users for understanding and gathering business requirements and involved in project planning, creating the database module with project managers using data modeling structures.
- Created various Stored Procedures, triggers, cursors, tables, views, joins and statements for applications. Developed complex T - SQL code for the application.
- Optimized the performance of queries with modifications in T-SQL queries, eliminated redundant data using normalization, and created indexes to get better performance.
- Identified slow running query and optimization of stored procedures and tested applications for performance, data integrity using SQL Profiler.
- Evaluated database performance and performed maintenance duties such as Tuning, Backup, Restoration and Disaster Recovery.
- Identified the dimension, fact tables and designed the Data-Mart using Star schema.
- Wrote Stored Procedures and Functions for better performance and flexibility.
- Used various SSIS tasks such as Conditional Split, Derived Column etc., which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
- Implemented various tasks and transformations for data cleansing and performance tuning of packages by using SSIS.
- Deployed SSIS packages into various Environments (Dev, UAT and Prod) using Deployment Utility.
- Created SQL Server jobs and scheduled them to load data periodically using SQL server Agent.
- Involved in Dimensional Data Modeling and Cube Partitioning in SSAS and enhanced the functionality in database and data ware housing concepts (OLAP, OLTP) Cube by creating KPI, Actions using SSAS.
- Worked on the Reports module of the project as a developer on MS SQL Server 2008 (using SSRS, T-SQL, scripts, stored procedures and views).
- Migrated (import & export/BCP) data from Text to SQL Server.
- Assisted in complete back-up of database and restored the database from Disaster Recovery.
- Coordinating post-implementation events such as testing.
- Environment: SQL Server 2005/2008, DTS, T-SQL, VSS, XHTML, XML, Windows Server.
- Worked on DTS Package, DTS Import/Export for transferring data from heterogeneous database.
- Created reports from OLAP, sub reports, bar charts and matrix reports using SSRS
- Defined appropriate measure groups and KPIs and deployed cubes.
- Created Parameterized, Cross-Tab, Drill Down and Summary reports by Using SSRS and created report snapshots to improve the performance of SSRS.