We provide IT Staff Augmentation Services!

Msbi Developer Resume

Bentonville, AR

SUMMARY:

  • 9+ years of experience as Microsoft BI developer, database developer and data analyst with Microsoft SQL Server 2016/2014/2012/2008 R2/2008/2005, SSIS/SSRS/SSAS, OLTP, OLAP, Tableau (Different environment such as Production, UAT, and development) and Power BI in various domains.
  • Participated actively in all phases of SDLC including Requirement Gathering, Designing Data Models, Development, Testing, go live and Post Go Live Support.
  • Expertise in working on all activities related to the development, implementation, administration and support of ETL processes for large - scale Data Warehouses using Data Transformation Services (DTS) and SSIS with MS SQL
  • Experience in Performance Tuning of SSIS packages by using Row Transformations, Block and Unblock Transformations.
  • Experience in Optimizing long running ETL packages by using different mechanisms.
  • Experience in creating visualizations and dashboards in Power BI and publish them.
  • Worked in creating different types of reports and data models in Power BI.
  • Experience in publishing Power BI Desktop reports created in Report view to the Power BI service.
  • Migrated data in various formats like text files, Excel spreadsheets etc. to SQL Server databases using SQL Server Integration Services (SSIS) to overcome the transformation constraints.
  • Experience working on huge data, millions of records in a table.
  • Sound knowledge of Data Marts, Operational Data Store (ODS), OLAP, dimensional Data Modeling with Star Schema Modeling, Snow-Flake Modeling for FACT and Dimensions Tables using Analysis Services.
  • Expert in creating several types of complex reports using SSRS (SQL server reporting services) such as Drill-Down, Parameterized, Conditional, Matrix, Ad-hoc, Sub-Reports, and Charts.
  • Employed various Tableau functionalities like Tableau Extracts, Parameters, Filters, Contexts, Data Source, Filters, Actions, Functions, Trends, Hierarchies, Sets, Groups, Calculations, Data Blending and Maps etc.
  • Extensive knowledge in Administering, Managing and Troubleshooting Reporting services.
  • Efficient in creating Sub-Queries and Joins for complex queries linking multiple tables and Exception Handlers.
  • Experience in publishing Power BI Desktop reports created in Report view to the Power BI service.
  • Created Calculated Columns and Measures in Power BI and Excel depending on the requirement using DAX queries.
  • Expertise in Debugging, Error logging, Error Handling and Production support for SSIS.
  • Created Calculated Columns and Measures in Power BI and Excel depending on the requirement using DAX queries.
  • Excellent problem solving, multitasking, business analytical and critical thinking with the ability to work on fast based environment.

TECHNICAL SKILLS:

Modeling Tool: MS Visio

Methodologies: SDLC Waterfall, Scrum, Agile methodology

BI Tool: SSIS, SSAS, SSRS, Report Builder, Tableau, Power BI

Database Tools: SQL Server Management studio, Enterprise Manager, Profiler, SQL Server Business Intelligent studio (BIDS)

GUI /Tools: MS Word, MS Excel, MS PowerPoint.

Database & Query Tools: SQL Server 2014/2012/2008/ R2/2005, Oracle, MS Access.

Operating Systems: Windows 98/95/2000, Windows XP, UNIX

PROFESSIONAL EXPERIENCE:

Confidential, Bentonville, AR

MSBI Developer

Responsibilities:

  • Worked as a technical developer for Clarityv13 upgrade changes for PMO Data Warehouse BI solution for Reporting.
  • Involved in full Development Lifecycle of the PMODW Clarityv13 Upgrade Project.
  • Analyzed the Technical Requirements for all the new attributes and changes in financial Plans for Projects from Source System.
  • Developed various SSIS packages for ETL (extract, Transform and Load) operations
  • Performance tuned the SSIS packages for speeding up the loads
  • Guiding and Leading the Team members in Everyday Development activities of the Project.
  • Setting every day standup calls and Code Reviews for Day-to-day activities on the Project.
  • Involved in unit testing and Integrated Testing of the Project.
  • Developed Various Financial reports using SSRS and MS Excel using Excel Pivots/Power Pivots.

Environment: Microsoft SSIS, SSRS, T-SQL, SQL Server 2012, Master Data Services 2012,Clarity PPM 12.1.1, Microsoft Visio, Power Point

Confidential, Los Angeles, CA

Technology Lead

Responsibilities:

  • Created different types of reports using SSRS by analyzing the data from centralized SharePoint server.
  • Generated Drill down and Drill through reports using group, filter, and parameterize report using SSRS.
  • Development of functions, triggers, views, tables, and SQL scripts to meet the requirements of the business users and application development.
  • Deploying and scheduling Reports using SSRS to generate all daily and quarterly Reports
  • Used BMC software for scheduling tasks and issue tracking
  • Created sub-queries, SQL Joins and other SQL code to implement business rules.
  • Developed SSIS Packages to import and export data from SharePoint server, MS Excel, SQL Server, Oracle and Flat files.
  • SSIS packages to update tables with daily data and automated it through scheduled jobs for the beginning of every month.
  • Packages were designed to Execute SQL Task, Data Flow Task, Sequence Container, For Each Loop Container, Lookup, Aggregate and Derived Column.
  • Developed packages in SSIS with error handling.
  • Created Package Configurations to deploy packages from development to production server.
  • Successfully managed Extraction, Transformation and Loading (ETL) process by pulling large volume of data from various data sources using BCP in staging database from MS Access, excel.
  • Experience with cloud services like Azure for data storage, predictive modeling and Azure Information protection tool for data classification analysis.
  • Involved in the analysis of existing database structures and creating the new tables and views as per the requirements.
  • Worked with development and QA teams in the design of physical databases, code testing and in modification.

Environment: SharePoint server, SSIS, SSRS, Oracle, AZURE, MSOffice 2010, BMC

Confidential, San Francisco, CA

MSBI/Power BI Developer

Responsibilities:

  • Worked with data models with complex relationships in Power BI and connected different data sources to Power BI desktop.
  • Experienced in working with DAX commands to pull up more calculated data out of the tables.
  • Created different types of visualizations viz., geographical visualizations after slicing and dicing the account operations related data to analyze financial data across different locations of the bank.
  • Exclusively worked in Power BI report creating tabular cube, creating data model for Power BI Report, Validating data quality of the report.
  • Published many reports and visualizations created to the Power BI service and thereby develop dashboards.
  • Experienced in creating many dashboards by pinning many visualizations in the workspace as per the insights provided.
  • Experienced in Data Modeling used to define and analyze data requirements needed to support the business processes within the scope of corresponding information systems in organizations.
  • Generated Drill down, Drill through, Matrix Reports, and Parameterized reports using expressions to calculate, group, filter, and parameterize report using SSRS.
  • Review reporting outputs for transparency, consistency, and accuracy.
  • Developed functions, triggers, stored procedures, views, tables, and SQL scripts to meet the requirements of the business users and application development.
  • Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status
  • Created and analyzed reporting within Tableau based on the business requirement
  • Created and assisted users in Tableau dashboard development.
  • Defined best practices for Tableau report development and effectively used data blending feature in tableau.
  • Developed Stored Procedures for the Datasets to build the reports for the client requirements.
  • Created SQL Joins, sub-queries and other SQL code to implement business rules.
  • Performance tuning, and optimization of procedures and queries.
  • Worked with the use of Data Modeling Standards for all projects requiring a standard means of defining and analyzing data within an organization, to manage data as a resource, for the integration of information systems, for designing Databases/Data Warehouses.
  • Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server, Oracle and Flat files.
  • SSIS packages to update tables with monthly data and automated it through scheduled jobs for the beginning of every month.
  • Created reports using stored procedure. Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS.
  • Designed packages which utilized tasks and transformations such as Execute SQL Task, Data Flow Task, Sequence Container, For Each Loop Container, Lookup, Aggregate and Derived Column.
  • Developed packages in SSIS with error handling.
  • Created Package Configurations to deploy packages from development to production server.
  • Successfully managed Extraction, Transformation and Loading (ETL) process by pulling large volume of data from various data sources using BCP in staging database from MS Access, excel.
  • Experienced in participating meetings with business users to gather the requirements.
  • Involved in the analysis of existing database structures and creating the new tables and views as per the requirements.
  • Worked with development teams in the design of physical databases and in modification.
  • Involved in the process of Data Modeling which includes professional data modelers working closely with business stakeholders, as well as potential users of the information system.
  • Participating to create Star Schema, Snow Flake Schema using the concept of data modeling with Team.

Environment: MS SQL Server 2012, SSIS, SSRS, SSAS, Power BI, Tableau, T-SQL, ORACLE, AZURE, MSOffice 2010

Confidential, Boston, MA

MSBI Developer

Responsibilities:

  • Worked closely with project stakeholders and staff to understand requirement specifications new applications and redesigning existing applications.
  • Gathered end user’s requirements, and implemented requirements using SQL server 2012.
  • Analysis of functional and non-functional categorized data elements for data profiling and mapping from source to target data environment.
  • Prepared project Progress Report and Status Reports and submitted it to Top management on weekly basis.
  • Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
  • Imported data from different databases (oracle, MS access etc.), build and scheduled packages, and defined integration flow using SSIS (SQL server Integration Services).
  • Created ETL (Extract, Transform, and Load) packages to validate and load data in to data warehouse, database, and data marts.
  • Designed and implemented parameterized, drill-through, drill-down and tabular reports using SSRS.
  • Developed crossed reports, sub-reports and matrix in SSRS.
  • Created complex queries to build the dataset required for developing the SSRS reports.
  • Implemented/Developed parameterized reports using Report Builder and SSRS allowing users to make selections before executing the reports and making it more users friendly.
  • Created different visualizations using Bar, Line and Pie chart, Background Maps, Box plots, Scatter plots, Gantt charts, Bubble charts, Histograms, Trend lines & statistics, Bullets, Heat maps and Highlight tables.
  • Designed, developed and implemented database systems and Stored Procedures based on Client requirements.
  • Built integrated reporting tools (Using Microsoft Power BI) with data from Sales, Marketing, and Finance systems.
  • Experienced in developing different types of reports, maps and visualizations using Power BI to analyze the premiums paid and outstanding in the insurance accounts.
  • Worked in creating Dashboards also as per the requirement in the project to analyze the performance metrics of different branches.
  • Experienced in connecting different data sources to the Power BI desktop to generate reports and geographical visualizations as per the insights provided.
  • Created adhoc reports to users in Tableau by connecting various data sources.
  • Connected Tableau server to publish dashboard to a central location for portal integration.
  • Connected Tableau server with share-point portal and setup auto refresh feature.
  • Maintained Test log and Wrote test Evaluation, Summary Reports.
  • Implemented the project using Agile/SCRUM methodology.

Environment: s: SQL Server 2014/2012, T-SQL, Windows 7, SSRS, SSAS, SSIS, Jira, Power BI, MS Visio, MS Azure SQL, Team Foundation Server (TFS).

Confidential

SSIS/SSRS/SSAS Developer

Responsibilities:

  • Generated Drill down, Drill through, Matrix Reports, and Parameterized reports using expressions to calculate, group, filter, and parameterize report using SSRS.
  • Review reporting outputs for transparency, consistency, and accuracy.
  • Developed functions, triggers, stored procedures, views, tables, and SQL scripts to meet the requirements of the business users and application development.
  • Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status
  • Developed Stored Procedures for the Datasets to build the reports for the client requirements.
  • Created SQL Joins, sub-queries and other SQL code to implement business rules.
  • Performance tuning, and optimization of procedures and queries.
  • Worked with the use of Data Modeling Standards for all projects requiring a standard means of defining and analyzing data within an organization, to manage data as a resource, for the integration of information systems, for designing Databases/Data Warehouses.
  • Designed and developed SSIS Packages (.dtxs files) to import and export data from MS Excel, SQL Server, Oracle and Flat files.

Environment: Microsoft SSIS, SSAS, SSRS, SQL Server 2012, Master Data Services 2012, Microsoft Visio, Power Point

Confidential

SQL Server/BI Developer

Responsibilities:

  • Created scripts to verify and reconcile the migrated data from legacy system to SQL Server.
  • Involved in gathering Business Requirement after interacting with the Manager and development team to build up a solution to implement in SQL Server 2008
  • Filtered and cleansed dirty data from legacy system using complex T- SQL statements in staging area, and implemented various constraints and triggers for data consistency
  • Created SSIS package to load data from Flat File to Flat File and Flat File to SQL Server using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot and Un-pivot Transformation
  • Successfully migrated old data from legacy systems (FoxPro) and external system including excel and oracle into SQL Server 2008 using SSIS Packages
  • Developed interface stored procedure to upload Insurance Record from XML format to Customer Insurance System
  • Developed complex Stored Procedures to process prospective customer information and balanced the processing load between front end and back end
  • Extensively used joins and sub queries to simplify complex queries involving multiple tables.
  • Designed forms, templates & created Reports using SSRS 2008 reporting services.
  • Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
  • Performed Unit testing for the screens and code in SQL Server 2008

Environment: SQL Server 2008, T-SQL, Excel, Access, Report Builder 3.0, Windows Server 2003, Query Analyzer, SQL Server Profiler, Oracle, Erwin 7.3/MS Visio 2007

Confidential

SSIS/SSRS Developer

Responsibilities:

  • Gathered user requirements, draft specifications design and create Database objects for performance tuning.
  • Developed SSIS packages for different tasks like data cleansing and standardizing, sorting, conditional split, back up and involved in scheduling of SSIS packages
  • Worked on Error Handling and Logging in SSIS packages.
  • Created configuration table to set the properties of the objects of SSIS packages at runtime.
  • Implemented best practices for performance tuning of SSIS packages
  • Involved in error handling of SSIS packages by evaluating error logs
  • Created reports using SSRS from OLTP and OLAP data sources and deployed on report server.
  • Created tabular, matrix, chart, drill down reports, parametric, cascaded reports and dashboards and score cards reports (SSRS) according to business requirement.
  • Created reports by dragging data from cube.
  • Used SSIS 2008 to create ETL packages to validate, extract, transform and load data to data warehouse, data mart databases, and process SSAS cubes to store data to OLAP databases.
  • Created Database objects including Tables, Views and Stored Procedures.
  • Developed User defined functions, stored procedures, and indexes.

Environment: SQL Server, MS Access, Enterprise Manager, Management Studio, SQL Server, SSRS, SSIS Packages, ETL, ODBC, Excel, Data Integrator, OLAP, OLTP

Hire Now