Sr. Bi Developer - Ssis/ssrs/ssas/power Bi/ Azure Resume
Lansing, MI
SUMMARY:
- Over 9 Years of extensive experience in Microsoft SQL Server and Business Intelligence applications (MSBI, Power BI). Expert in using Microsoft BI studio products like SSIS, SSRS and SSAS With an MS in Computer Science .
- Strong working experience in data analysis, design and development of databases for business applications in a data warehouse environment.
- Hands on experience in data Extraction Transformation Loading (ETL) using Data Transformation Services (DTS) and SQL Server Integration Services (SSIS).
- Well versed in a corporate wide ETL Solution using Informatica PowerCenter/PowerMart 9.0.1/ … Advanced knowledge in ETL and Data warehousing with OLAP technology.
- Experience in data mart life cycle development, performed ETL procedure to load data from different sources into data marts and data warehouse using Informatica PowerCenter Designer, Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Manager and Workflow Monitor.
- Experienced in creating SSIS packages involving ETL process, extracting data from various sources (Flat files, Excel files, Oracle, SAP, and SQL Server) and loading for data warehousing using SQL Server Integration Services.
- Experience on Migrating SQL database to Azure data Lake, Azure data lake Analytics, Azure SQL Database, Data Bricks and Azure SQL Data warehouse and Controlling and granting database access and Migrating On premise databases to Azure Data lake store using Azure Data factory.
- Experience in creating Jobs, and Sending Alerts using SQL Mail, backups, performance issues, connectivity to databases, upgrade strategies, capacity planning.
- Experience in developing management reports by using SSRS (SQL Serving Reporting Tools).
- Extensive experience in developing Oracle PL/SQL Stored Procedures, Functions, Packages, Cursors, Collections (Nested tables and V - arrays), Records, Object types and Database Triggers.
- Strong experience in creating Ad Hoc Reports parameterized Reports, Linked Reports, Snapshot Reports, Drilldown and Drill through reports using SQL SSRS.
- Experience in migrating DTS packages, reports and analysis services projects from SQL Server 2005 to SQL Server 2008R2, 2012 and 2014.
- Extensive experience in different type of reports including: Tabular forms, Matrix (cross Tab report) form, Conditional, List items, Charts and Sub reports. Very good experience in writing expressions in SSRS.
- Create reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector.
- Experience in Power BI, creating interactive visualizations, dashboards, reports based on business requirements.
- Knowledge in Tableau Desktop for data visualization through various charts such as Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualization.
- Wide experience in creating OLAP cubes, identifying dimensions, attributes, hierarchies and calculating measures and dimension members in SQL Server Analysis Services (SSAS).
- Worked on Data Marts, Data Warehousing, Operational Data Store (ODS), OLAP, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables using MS Analysis Services.
- Expert in Tabular Modeling, Multi-Dimensional Cubes, DAX and MDX (SSAS)Experience in working with large databases in SQL, Oracle, and Teradata
- Ability to work independently or as part of a team to accomplish critical business objectives and to make decisions under pressure.
- Worked on GIT, Team Foundation Server, Visual Studio online and the application lifecycle tools associated with it.
TECHNICAL SKILLS:
Programming Languages: T-SQL, PL/SQL, C, C++
Scripting: T-SQL, PL/SQL, Python, R, Dynamic SQL, MDX, DAX, XML, HTML, Visual Basic.
Databases/ RDMS: MS SQL Server 2005/2008/2012/2014/2016, Oracle 9i/10g/11g, Sybase, MS Access
ETL Tools: SQL Server Integration Services (SSIS) Data Transformation Services (DTS) and T-SQL Stored Procedures, Azure Pipelines
Reporting Tools: SQL, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analytical Services (SSAS), Visual Studio, BIDS, Power BI ( Power Query, Power Pivot, Power View, Power Map), Azure, 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), Business Objects, XML, Visual Source Safe Visual Studio Team Foundation Server (TFS)Data Modeling: MS Visio, FACT& Dimensions tables, Physical & Logical data modeling, Star & Snowflake schema Relational, Dimensional and multidimensional modeling and De-Normalization Techniques, MS- Access.
Packages: MS Office, Microsoft Office Suit, Microsoft Office SharePoint Server (MOSS), Microsoft Performance Point Server
PROFESSIONAL EXPERIENCE:
Confidential, Lansing, MI
Sr. BI Developer - SSIS/SSRS/SSAS/Power BI/ Azure
Responsibilities:
- Responsibilities include definition, design, logical modeling, and physical implementation of relational and dimensional databases, primarily using Microsoft SQL Server.
- Development of logical and physical data models for Data Marts and Data Warehouses using best practices.
- Consulting with various Business Stakeholders and participate in requirements elicitation and user story mapping with the business and technical SMEs to understand their data use case and reporting needs.
- Extract Transform and Load data from Sources Systems to Azure Data Storage services using a combination of Azure Data Factory, T-SQL and U-SQL Azure Data Lake Analytics. Data Ingestion to one or more Azure Services - ( Azure Data Lake, Azure Storage, Azure SQL, Azure DW ) and processing the data in In Azure Databricks.
- Data loading to Data lake from different sources using Azure Data Factory.
- Creating Pipelines and Scheduling jobs using Azure Data Factory
- Data Loading to Datamart and other destinations from Data Lake using Data Bricks.
- Monitor Data Warehouse infrastructure and Business Intelligence scheduled processes and identify opportunities to make enhancements and managing SSAS instances that were present on Azure Virtual Machines.
- Analyzing complex data from multiple sources, responsible for detecting problems with the database and suggesting improvements that will have immediate impact.
- Develop enterprise reporting solutions from multiple structured and unstructured data sources including SQL Server, Flat Files and SQL Server Analysis Services using Microsoft SQL Server Data Tools to fulfill enterprise reporting requests with a high degree of analytical approach and operating within established development guidelines.
- Performs analysis activities of current data to provide critical information to our internal and/or external clients to help the business become more efficient, more targeted and more responsive to our clients and/or customers.
- Meet with the Business Users and Analytics team to ensure data quality and integrity across the project.
- Debugging complex stored procedure to process records and resolve load balance issue.
- Create executive level reports which deliver insights, help take decisions about the resources available and how to allocate them, which are needed to effectively run an enterprise by utilizing DrillDown, Drillthrough, Visual interactions and Parameter table features of Power BI.
- Develop, maintain and support reports and dashboards being used by business users and clients with SSAS multidimensional cubes.
- Recommend and implement data quality improvement processes and initiatives.
- Create and maintain technical documentation for various systems, services and business processes including databases and reporting procedures.
Environment: MS SQL Server, Visual Studio2, SSIS, SSRS, MS Office, SQL Profiler, Azure and Power BI, SQL Server Agent, MS Excel, Power Pivot.
Confidential, Santa Ana, CA
Sr. Data Engineer - SSIS/SSRS/SSAS/Power BI Developer
Responsibilities:
- Communicating with business users to deliver reports and other user interfaces that drive business value and efficiently and effectively leverage the use of data.
- Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
- Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision makers for strategic planning.
- Created reports utilizing SSRS, Excel services, Power BI and deployed them on SharePoint Server as per business requirements.
- Creating packages to Extract, Transform and Load data using SQL Server Integration Services (SSIS) into local databases to facilitate reporting operations. Loaded the Fact and Dimension tables.
- Implemented Complex Logging in SSIS Packages.
- Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml task.
- Involved in various Transformation and data cleansing activities using various Control flow and data flow tasks in SSIS packages during data migration.
- Created the automated processes for the activities such as database backup and SSIS Packages to run sequentially using SQL Server Agent job.
- Created SQL Server Profiler traces & used with Database Tuning Advisor (DTA) for optimum performance of queries.
- Made changes to the existing Power BI Dashboard on a regular basis as per requests from Business.
- Converted DTS packages in SQL Server 2008 to SQL Server 2016 using Integration Services (SSIS).
- Generating various Monthly, Quarterly, Bi-Yearly, Yearly and random ad-hoc reports using SQL Server Reporting Services (SSRS) for various business users.
- Generated Sub-Reports, Drill Down reports, Drill through reports and Parameterized reports using SSRS. Deployed all the reports to reporting server, SharePoint, Excel & PDF and provided Documentation support on SSRS 2016 as assigned.
- Created List reports, Cross-Tab reports and different types of charts like Column charts and Bar charts.
- Assigning different access permissions and security levels for the reports in SSRS for various levels of users in the company. Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2016.
- Generated Reports using Global Variables, Expressions and Functions for the reports. Identified and worked with Parameters for parameterized reports in SSRS 2016.
- Having knowledge in Dimensional Data Modeling, Cube development and manipulations in SQL Server Analysis Services (SSAS).
- Well versed in MS-Visio, MS-Project, MS-PowerPoint, MS-Excel, MS-Word and other office Suites for Project Management and Business Analysis.
Environment: MS SQL Server 2016/2008 Visual Studio2012/2010, Windows 7, SSIS, SSRS, Report Builder 3.0, SQL Profiler, Azure and Power BI SQL Server Agent, Google Analytics, MS Excel, Power Pivot.
Confidential
Sr. SQL Server Developer/SSRS/SSIS
Responsibilities:
- Designed and implemented Parameterized and cascading parameterized reports using SSRS.
- Designed and formatted SSRS Reports using Parameters and Expressions for the Reports.
- Automated the execution of SSRS reports using Subscriptions and Data-Driven Subscriptions.
- Build different types of chart reports using SSRS like column chart and Pie charts.
- Created sub reports and pass through parameters from main report to the sub reports.
- Deploying and Scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly reports including current status.
- Generated various Report models on Views and deployed them on to the production reporting server and generated various Report models and ad-hoc reports.
- Worked with T-SQL to create Tables, Views, and triggers and stored Procedures.
- Developed stored procedures and triggers to facilitate consistent data entry into the database.
- Wrote store procedures to generate account statements for different types of accounts.
- Designed and created views for security purposes, implemented rules, defaults, and user defined data types.
- Created packages in SSIS with error handling.
- Worked with different methods of logging in SSIS.
- Experience in creating complex SSIS packages using proper control and data flow elements.
- Created SSIS packages to migrate data from Oracle to SQL Server 2008R2
- Responsible for ETL operation using SQL Server Integration Services (SSIS) and Worked with users in training and support and also have experience in incremental data loading.
Environment: SQL Server 2014, SSIS, SSRS, SSAS, Visual studio, Asp.net, C#.net.
Confidential
SQL Server (SSIS/SSAS/SSRS) BI Developer
Responsibilities:
- Involved in various phases of Software Development Life Cycle (SDLC) and developed use Case diagrams, Object Diagrams, Class Diagrams, and Sequence diagrams to represent the detail design phase using Rational Rose.
- Installation and configuration of SQL Server 2008(R2).
- Analyzed the business requirements and building logical and physical data models.
- Developed new stored procedures and optimize existing ones.
- Developed template scripts for users so they can generate their own daily/weekly/monthly reports.
- Developed and implemented stored procedures and triggers for automation tasks.
- Developed SSIS packages to extract data from OLTP to OLAP systems and schedule the same as jobs using SQL Server Agent.
- Modify the existing SSIS packages to reflect the new business requirements.
- Developed packages to create Error Fallout Reports, send Business and IT mails.
- Apply various transformations like Slowly Changing Dimension(SCD), Multicasting, Union, Derived Column and Data Conversion.
- Used various advanced SSIS functionalities like complex joins, conditional splitting for better performance during package execution.
- Developed Unit test plans for SSIS packages.
- Performed ETL operations to support incremental, historical data loads and transformations using SSIS.
- Set up traces and use profiler to troubleshoot performance issues.
- Created drill-down, drill-through and sub reports using SQL Server Reporting Services 2008R2.
- Developed different chart reports for customers, based on the requirements.
- Deploy the reports to the report manager and maintain the same providing necessary access to the users.
- Created roles for the reports and assign them accordingly.
- Developed UI mockups and ER diagrams using Visio and assisted teams working on Citrix and VMware.
Environment: MS SQL Server 2008(R2), BIDS SSIS, SSRS, MS Visio 2010, Visual Studio 2010, C#.Net 2008 and Window 7.Windows Server 2008 R2.