Power Bi / Msbi Developer/ Sql Developer Resume
Mount Laurel, NJ
PROFESSIONAL SUMMARY:
- MS SQL BI developer with 8+ years of experience in designing and developing BI applications. I am a strong team player and I enjoy interfacing with customers. I am flexible and easily adapt to new environments and technologies.
- Experience in designing, developing, and delivering business intelligence solutions using SQL Server Integration Services (SSIS ), Analysis Services (SSAS) , and Reporting Services (SSRS) .
- Technically and logically very sound in T - SQL Programming, SSIS, SSRS, SSAS, Data Cleansing, Data Scrubbing and Data Migration , Data warehousing, Business Intelligence etc.
- Designed SSIS Packages to extract data from various heterogeneous data sources such as Access database, Excel spreadsheet and flat files into SQL Server for further Data Analysis and Reporting by using multiple transformations provided by SSIS.
- Experienced in creating various types of reports such as Complex drill down & drill through reports, Matrix reports, Sub reports and Charts using SQL Server Reporting Services (SSRS) based on Relational and OLAP databases.
- Well versed in Normalization/De-normalization techniques for optimum performance in relational and dimensional database environments.
- Experienced in logical, physical, and dimensional data modeling, data mapping, and data normalization.
- Worked on DAX scripting to access data from Tabular Model and MDX for Multidimensional Cubes.
- Experience in publishing Power BI Desktop reports created in Report view to the Power BI service.
- Used Power Query to acquire data and Power BI desktop for designing rich visuals
- Experience in designing Star, snowflakeschemas for Data Warehousing and OLAP needs
- Experienced in writing Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, Defining Data Source and subtotals for the reports using SSRS.
- Proficient in creating On-demand and Scheduled reports, handling sub reports and defining query for generating drilldown reports using MS SQL Server Reporting Services.
- Experience in migration of Data from Excel, Flat file and Teradata to MS SQL Server by using SSIS packages
- Transformed data from one server to other servers using tools like Bulk Copy Program (BCP) , Bulk Insert, Data Replication, Data Transformation Services (DTS) and SQL Server Integration Services (SSIS).
- Proficient in building Cubes , defining Referenced Relationships and creating Hierarchies in SSAS.
- Used Microsoft Azure platform for the building, managing applications and deploying web applications. Created Azure virtual machines
TECHNICAL SKILLS:
RDBM/Databases: MSSQL Server 2016/2014/2012/2008 R2, Oracle 8i & 9i, MS Access, Microsoft Azure
Programing Languages: T-SQL, PL/SQL, C, MDX, Python, C
Data Modeling: FACT& Dimensions tables, Physical & Logical data modeling, Star & Snowflake schema, Relational, Dimensional and multidimensional modeling and De-Normalization Techniques
BI Tools: Visual Studio (SQL Server Integration Services (SSIS), SQL Server Analytical Services (SSAS), SQL Server Reporting Services (SSRS)), Microsoft Power BI, Power Pivot, Power View, Power Query, Power Map, Tableau.
Tools/ Database Utilities: SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Microsoft Management Console, Business Intelligence Development Studio (BIDS), Crystal Reports 9.0, Visual Studio Team Foundation Server (TFS).
Application Packages: MS Office, Microsoft SharePoint Server (MOSS)
Operating Systems: Windows XP/Vista/7/8 and 10; Windows 2003/2008R2/2012 Servers.
PROFESSIONAL EXPERIENCE:
Confidential, Mount Laurel, NJ
Power BI / MSBI Developer/ SQL Developer
Responsibilities:
- Worked on Performance Reports of employeesin Power BI which was a pilot technology to the company and have been key in helping them introduce the technology.
- Worked on cascaded reports with multiple parameters and cube source.
- Wrote complex T-SQL queries, stored procedures to build specific logics.
- Performed ETL operations to support incremental, historical data loads and transformations using SSIS.
- Implemented advanced features and tools such as script task, lookup, derived columns, condition split, union all, copy column, data conversion as per the business requirements.
- Worked on group atlas travel project which was one of the critical and new domain of Confidential . Have worked from the scratch of the project and built the application based on all the business rules with direct meetings with the clients.
- Developed reports using SSRS on statistical data during migration of data.
- Created analysis and design documents for implementing the client specific requirements.
- Prepared all the documentation for all the projects.
- Generated reports in excel files using SSIS for business reviews
Environment: MS SQL Server 2012/2014/2016, SQL Server Integration Services 2012/2014/2016 (SSIS), SQL Server Analysis Services 2012 (SSAS), T-SQL, Microsoft Visual Studio 2012/2014/2016, Power BI.
Confidential, Richardson, TX
Power BI / MSBI Developer/ SQL Developer
Responsibilities:
- Created SSIS Packages/projects to move data from source to destination programmatic by using Visual Studio 2012 and developed ETL packages to extract and transform data from data sources like MS Access.
- Involved in Data Scrubbing and Data Cleansing using MDS, DQS.
- Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for DBMS.
- Extensively used various SSIS objects such as Control Flow Components, Dataflow Components, Connection managers, Logging, Configuration Files etc.
- Implemented SSAS cubes, Facts and Dimension tables to perform analysis.
- Optimized the SSAS tabular model process speed by properly designing data models and optimizing DAX calculations .
- Developed and designed the different visualization charts like line charts, Pie charts, Maps, Tiles, Cards, Images, Tables, Bubble and Scatter Plots, Key Performance Indicators using Power BI.
- Used Power BI with DAX for developing reports and KPI’s for the organization and departments.
- Involved in requirement gathering for the Power BI dashboards and help end user understand the feasibilities in the reports.
- Provided ongoing support and configuration for JIRA projects, workflow, screens, fields, permissions and other administrative tasks.
Environment: MS SQL Server 2012/2014, SQL Server Integration Services 2012/2014 (SSIS), SQL Server Analysis Services 2012/2014 (SSAS), T-SQL, Microsoft Visual Studio 2012/2014, Import/ Export Tools, MDS, DQS, Power BI, MS Access.
Confidential, Los Angeles, CA
SQL Server Developer
Responsibilities:
- Cedar- Confidential focused,modern, adaptable, innovative and inclusive system. The major responsibility was to create a centralized data warehouse in SQL Server 2012 to match the needs of clients.
- Drew the flow chart of the trigger logic to remove the repetitive pattern in T-SQL to reduce dependencies
- Extensively involved in Data Extraction, Transformation and loading from OLTP to OLAP system in SQL Server 2012 by creating cubes that uses the relational data warehouse as sources to its dimensions and facts.
- Involved in the troubleshooting of several packages related to execution, development and performance.
- Involved in implementation and maintenance of disaster recovery solutions like Replication.
- Transformed ETL rules into SQL Scripts
- Created complex SSAS cubes with multiple fact measure groups and multiple dimension hierarchies based on the OLAP Reporting needs.
- Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS.
- Used SSAS MDX to extract data from cubes and create MDX script for representing cube calculations.
- Involved in creation and deployment of reports using SSRS and configuring the SQL Server Reporting Services.
- Generated database monitoring and data validation reports in SQL Server Reporting services
- Deployed SSRS reports in Microsoft share point portal server.
- Used Power Pivot to develop data analysis prototype and Power Map to visualize reports also created analytical reports and dashboards using Power View.
- Experience in working with Azure SQL Database Import and Export Service, also deploying SQL Databases in cloud(Azure).
Environment: MS SQL SERVER 2012, SQL Server integration services (SSIS), SQL Server Analysis services (SSAS),and SQL Server Reporting services (SSRS), T-SQL, Microsoft Visual Studio 2012, Report builder / Designer, Share Point 2013, MDS, Power View, Microsoft Azure.
Confidential, Charlotte, NC
SSIS/ SSRS/ SSAS Developer
Responsibilities:
- Involved in automating SSIS Packages using SQL Server Agent Jobs. Created an ETL summary report which consists of the summary information for all the loading activities done each day and month.
- Rewriting and optimizing Queries, Preparing Documentation and specification.
- Created SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
- Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Database.
- Created many Complex Stored Procedures/Functions and used them in Reports directly to generate reports on the fly.
- Proficient in designing and developing cubes using SQL Server Analysis Services (SSAS) and leveraging the advanced BI Functionality of SQL Server.
- Expertise in creating Perspectives, partitions and design aggregations in cubes using SSAS.
- Involved in design implementation and modifying the python code and MYSQL database schema on the back end.
- Wrote and executed various MYSQL database queries from Python-MYSQL connector and MYSQL db.Package.
- Provided design, implementation and maintenance for custom reports and quarterly reports as bar charts for the management using different techniques like data filtering, adding interactivity, deploying reports to report server using SSRS.
- Worked on formatting SSRS reports using global variables and expressions.
- Experience in using SQL Profiler, SQL Server Agent and database Engine Tuning Advisor.
- Used SQL Server Profiler to monitor and record database activities of users and applications
Environment: MS SQL SERVER 2008, Python 2.7, T-SQL, Microsoft Visual Studio 2008, SQL Server integration services (SSIS), SQL Server Analysis services (SSAS), SQL Server Reporting services (SSRS), MS Excel, SQL Server Profiler.
Confidential
SQL Developer
Responsibilities:
- Installed and configured SQL Server 2008 for Development Purpose.
- Created DTS packages to transfer the data from Oracle to SQL Server 2008.
- Wrote T-SQL scripts to validate and correct inconsistent data in the staging database before loading data into database.
- Converted various SQL statements into Stored Procedures thereby reducing the number of database accesses (since stored procedures passes the whole block at one time).
- Performed tune to optimize SQL queries using SQL Profiler and Query Analyzer.
- Involved in performance tuning of the database and T-SQL queries using Explain plan.
- Designed and developed MS SQL server stored procedures using T-SQL statements from scratch.
- Developed triggers on views to populate these tables.
- Rigorously tested and debugged the stored procedures and used triggers to test the validity of the data after the insert, update and delete.
- Handling database objects with Enterprise Manager.
- Created SQL-Loader scripts to load legacy data into Oracle staging tables and wrote complex SQLqueries to perform Data Validation and Data Integrity testing. Used TOAD against Database.
- Created new Procedures, Functions, Triggers, Materialized Views, Packages, Simple, Ref & Traditional Cursors, Dynamic SQL, Table functions as part of Project/Application requirements.
- As the project deals with huge amount of usage data, Partitioned tables to enhance the performance, manageability, availability and eliminate the down time on frequently used usage related tables.
- Analyze SQL statements, reorganize database objects and design indexes to improve response of queries.
Environment: MS SQL SERVER 2008,PL/SQL, TOAD, T-SQL, Dynamic SQL, SSMS, SQL Profiler, Query Analyzer, Enterprise Manager, Windows XP.
Confidential
Software Engineer
Responsibilities:
- Created tables, views, indexes, stored procedures, functions, and triggers by T-SQL code in MS SQL Server Management Studio (SSMS) to make data transformation services (DTS) effective.
- Worked with DDL, DML, and DQL in T-SQL using CREATE, ALTER, DROP, INSERT, UPDATE, DELETE, SELECT, FROM, WHERE, ORDER BY, and GROUP BY.
- Created tables, views, indexes, stored procedures, functions, and triggers by T-SQL code in MS SQL Server Management Studio (SSMS) to make data transformation services (DTS) effective.
- Responsible for quick response of SQL statement and connectivity from front application to the database servers.
- Created SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
- Created SSIS packages to populate data from various data sources.
- Developed ETL process using SSIS with Various Control Flow, Data Flow task and Store Procedures for Work Order Validation process.
Environment: MS SQL Server 2008R2/2008, MS SQL Server Management Studio (SSMS), MS SQL Server Integration Services (SSIS), MS Excel, T-SQL.