We provide IT Staff Augmentation Services!

Msbi Developer Resume

Seattle, WA

SUMMARY

  • Over 7+ years of Experience in SQL server databases and Data Loading and Reporting tools with SSIS, SSAS, SSRS, PowerBI.
  • Extensive experience with T - SQLprogramming in developing Stored Procedures, Views, Triggers, User Defined Functions, Cursors, Derived Tables, Common Table Expressions (CTEs) XML and Complex Queries onSQLServer.
  • Created visualization reports and dashboards usingPowerBIdesktop and published them to thePowerBIService
  • Excellent in High Level Design of ETL DTS Packages & SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data, MS Access, DB2,COSMOS) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and union all.
  • Experienced in creating Jobs, Alerts,SQLMail Agent, and scheduling SSIS Packages.
  • Experience in writing Sub Queries, Stored Procedures, Triggers, Cursors, and Functions onSQL withMSSQLServer and PostgreSQL database.
  • Strong technical skills in Oracle,SQL, PL/SQL,MySQL.
  • Excellent knowledge in Data Warehousing, Data Mart & Big Data concepts
  • Cloud platform experience with Azure, Cosmos, Azure Data Factory, Azure Data Lake, AzureSQL.
  • Experience in writing Parameterized Queries for generating Tabular reports, Drill down, Drill through, Cascading, Parameterized, click through, Matrix, Chart, Snap shot reports, Formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, defining data source and subtotals for the reports using SSRS.
  • Experience in Data Warehouse Modeling with SQL Server Analysis Service (SSAS).
  • Exposure in using Team Foundation Server (TFS) as a source control, source repository and project tracking solution.
  • Experience inTableauDesktop for data visualization through various charts such as bar charts, line charts, combination charts, pivot table, scatter plots, pie charts and packed bubbles and use multiple measures for comparison such as Individual Axis and Dual Axis.
  • Excellent communication and interpersonal skills and has ability to handle multiple tasks, can take initiative to handle responsibilities independently as well as a proactive member of a team

TECHNICAL SKILLS

Operating Systems: UNIX, LINUX, Windows, MS-DOS

Programming Language: C, SQL, PL/SQL, MySQL, JAVA, C#

Reporting Tools: SQLServer Reporting Services, Tableau,PowerBI

ETL Tools: SSIS, BIDS, DTS, PDI, Informatica.

Database Tools: SSMS 2008/2012/2014 , Oracle, AWS RDS, TOAD, Teradata, SSAS, Visual Studio, Query Analyzer,SQLProfiler.

Web Technologies: HTML5, XML, JavaScript, Web Services

PROFESSIONAL EXPERIENCE

Confidential, Seattle, WA

MSBI Developer

Responsibilities:

  • Developed SQL Queries to fetch complex data using Inner/Outer joins, sub-queries, CTE, Tally tables accommodating complex filters and database links.
  • Involved in requirements gathering, analysis, design, development,changemanagement, deployment.
  • Optimized the performance of queries in TSQL queries, normalized tables, established joins and created clustered/non-clustered indexes wherever necessary
  • Worked on Type 1 and Type 2 packages for incremental to load data from source to DataMart.
  • Worked on C#, VB.Net in Script task. Script task is primarily to control the flow of SSIS package.
  • Created different visualization inPower BIper the requirements.
  • Generated Monthly, Yearly, Quarterly and daily reports inpowerbi
  • Created measures, calculated columns, conditional column, custom columns inPowerBi
  • Used MicrosoftAzureas the back-end for rendering reports and dashboard for the PowerBI
  • Created many calculated columns and measures using DAX inPOWERBIbased on report requirements
  • Generated ad-hoc reports in Excel,PowerPivot, Power Point and shared them usingPowerBIto the decision makers for strategic planning.
  • Extract and analyze data usingPowerQuery, PivotTables, MS Excel,POWERBIand SSAS
  • Create databases, schemas and tables inAzureSQLServer, migrate database from on-premisesSQLServer intoAzureSQLServer using SSIS ETL packages and complicate T-SQL, clean data, convert data, transfer data from old system to new system.
  • Responsible for deploying the SSIS packages and scheduling the package through jobs in all tiers Including dev, test and production.
  • UsedCosmosscripting in writing queries.
  • Created Stored Procedures that would be used in .Net applications to retrieve information and display on Home page.
  • Created packages with different control flow options and data flow transformations such as Conditional Split, Derived Column, look up, Data Conversion, Merge, Merge Join
  • Used SSIS and SQL Server stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts.
  • Extensively worked on production support that includes Deployment of SSIS Packages into Development, Production Servers, Creating, Scheduling and Managing the SQL Jobs.
  • Extensively worked on Design and development of SSIS (ETL) packages to extract, transform and load data from different Sources to the Data warehouse using different tasks and transformations.
  • Worked on Execution of the paths depending on the success, failure or Completion of other tasks with precedence constraints and expressions to determine the workflow.

Environment: SQL Server 2012/2014/2016 , SSIS, SSRS, C#.Net, Excel, PowerPivot, PowerBIDesktop, PowerBIWeb, TOAD, TFS, Visual Studio 2010/2013, COSMOS, Azure Database, SharePoint.

Confidential, Richfield, MN

Sr SQL /SSAS/SSRS Developer

Responsibilities:

  • Worked in AGILE methodology in development of Database Objects in SQL Server 2012.
  • Developed SQL Queries to fetch complex data using Inner/Outer joins, sub-queries, CTE, Tally tables accommodating complex filters and database links.
  • Built cubes using SSAS and created reports from Analysis Services usingMDXquery designer.
  • Involved in storage and partitions, and Aggregations, calculation of queries withMDX, developing reports usingMDXand SQL.
  • Involved in Migration of SQL server to Amazon Web services cloud (AWSCloud).
  • Created newPostgresGreenplum database components.
  • Understanding of Data pipeline inAWSscheduler.
  • Used TOAD, PL/SQL developer tools for faster application design and developments and Wrote Procedures and Functions using oracle.
  • Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.
  • CreatedC#based .NET utility programs for SharePoint and SSIS tasks.
  • Used Performance tools like SQL Profiler, Index Tuning Wizard and Database Engine Tuning Advisor.
  • Designed, developed, tested, and maintainedTableaufunctional reports based on user requirements
  • Hands on building Groups, hierarchies, sets to create detail level summary reports and Dashboard using KPI's
  • DevelopedTableauworkbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.
  • Creating connections and data extracts for different tableau applications with different database sources including Oracle, Db2,MySQL,SQLserver etc.
  • Created customized reports using various chart types like, Text Tables, Bar, Pie, Tree Maps, Heat Maps, Line Charts, Pivot Tables, Combination Charts in Excel and Tableau.
  • Created action filters, parameters and calculated sets for preparing dashboards and worksheets inTableau.

Environment: SQL Server 2012, T-SQL, MySQL, PL/SQL,Postgres, TOAD, Excel, C#, MS Access, Visual Studio, Query Analyzer, AWS RDS, SQL Server Profiler 2008, JIRA,Tableau 9.0, Tableau Server.

Confidential, Englewood, CO.

SQL BI Developer

Responsibilities:

  • Actively participate in gathering of user requirement and system specification.
  • Increased query performance necessary for statistical reporting by 25% after performance monitoring, tuning and optimizing indexes.
  • Create and MaintainTeradataTables, Views, Macros, Triggers and Stored Procedures
  • Converting existing Oracle/SQL Server data intoTeradata.
  • Excellent knowledge ofHIPAA(Health Insurance Portability and Accountability Act) transaction codes.
  • Experience in integrating Share Point Server withSSRSand deployingSSRSreports on to Share Point Server.
  • Wrote Stored Procedures inSQLand Scripts inPythonfor data loading
  • WrittenJavaScript for different validations.
  • Excellent report creation skills using Confidential SQL Server 2012/2008R2 Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
  • Created procedures and functions using different operators in PL/SQL and used oracle connectors to connect to oracle source from SQL.
  • Involved in writing SQL queries, PL/SQL programming and created new packages and procedures and modified and tuned existing procedure and queries using TOAD.
  • Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
  • Implemented Event Handlers and Error Handling in SSIS packages.
  • Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs
  • Developed OLAP cubes by identifying tables (fact and dimension), Data Source and Data Source Views, attributes and dimension members usingSQLServer Analysis Services (SSAS).
  • Involved inSSASstorage and partitions, and aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX andSQL.
  • Designed and developed Drill down and Drill Through reports with Drop down menu option usingSSRS.
  • Designed and Developed matrix, tabular and parametric Reports usingSSRS.
  • Designed Cubes with Star Schema usingSQLServer Analysis Services.
  • Generated Dynamic Reports from Cubes (SSAS) using SSRS 2012

Environment: SQL Server, Oracle 11g/10g,PL/SQL,Python, T-SQL, Excel, SQL Server Profiler, SQL*Loader, SSIS, SSRS, SSAS, Java Script, TeradataSQL Assistant,My SQL, HP ALM.

Confidential

SQL Server Developer

Responsibilities:

  • Gathered functional requirements, Business requirements and wrote the technical specifications for building the Global Enterprise Data warehouse.
  • Improved the performance ofSSRSreports by tuning the Stored Procedures and TSQL queries using various join conditions; Created XML, PDF, EXCEL files usingSSRS.
  • Designed and maintained a web reporting environment including portal, dashboards, scorecards and presentations using SQL Server 2005 and ASP.Net.
  • Created DDL, DML scripts, stored procedures and triggers per the requirement and designed ad hoc queries on the database tables.
  • Used multiple transformations inSSISto meet the business requirements by collecting data fromSAPBW.
  • Created views/indexed views consisting of computed columns to facilitate easy user interface.
  • Developed multi-dimensional databases (MDDB), OLAP cubes and data marts using SQL Server Analysis Services (SSAS) that stored and maintained the data.
  • Provided technical guidance and support to end-users by developing documentations required.
  • Performed final verification procedure for SQL release to production environment.
  • Documented all database changes, followed and enforced change and release management processes.

Environment: SQL Server 2008/2005, SAP, SSAS, SSRS, Oracle 9i, T-SQL, Excel, MS Access, Advanced Windows 2003 Server, Visual Basic .Net, Query Analyzer, SQL Server Profiler.

Confidential

SQL Server Developer

Responsibilities:

  • Worked with Implementation team and closely moved with end users to implement manufacturing solutions.
  • Maintained the production, test and development databases, tuned the database by improving relations, integrity constraints and written t-SQLprocedures for transactions, created indexes for performance tuning.
  • Developed several database objects such as Tables, Triggers, Views and Stored Procedures.
  • Assisted the Application team in data modeling and T- SQL coding.
  • Completed complexSQLqueries for analyzing purposes and created multiple stored procedures, views and UDFs to implement the business needs.
  • Responsible for debugging and tuning during the test period, creating indexes and security design for database to improve performance.
  • Developed complex T-SQLcode such as Stored Procedures, functions, triggers, Indexes and views for the application.
  • Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables & calculations from different databases.

Environment: SQL Server 2005, SSIS, SSRS, MS-Excel, DTS, Visual Studio 2005, Windows server 2003.

Hire Now