We provide IT Staff Augmentation Services!

Msbi/power Bi Developer Resume

Atlanta, GA

SUMMARY

  • Extensive experience of 6 years of Information Technology experience in all phases of Software development life cycle including Database administration, Data Analysis and Business Intelligence.
  • Proficiency in Microsoft Business Intelligence technologies like MS SQL Server Integration Services (SSIS), MS SQL Server Analysis Services (SSAS) and MS SQL Server Reporting Services (SSRS).
  • Experience in creating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types and functions, Cursors and Indexes using T - SQL.
  • Extensively worked with clients to understand business requirements, recommended technical solutions and documented functional requirements.
  • Involved in Data Warehousing Concepts and Data Modeling Techniques like Dimensional Data Modeling, Star
  • Schema Modeling, Data Vault Modeling, Snow-Flake Modeling, FACT and Dimensions Tables.
  • Experience in SDLC (Software Development Life Cycle) involving System analysis, Design Development & Implementation using Waterfall methodology and Agile methodology.
  • Strong experience in design and developing ETL using SQL Server Integration Services (SSIS).
  • Experience in creating SSIS package to load data from Flat Files to SQL Server using various types of transformations like Lookup, Fuzzy Lookup, Multicast, Derived Columns, Condition Split, Term Extraction, Aggregate, for transferred data modifications and data flow tasks, script tasks, for loop container, for each loop, sequence container and Slowly Changing Dimension.
  • Experience in Installing, Managing, Monitoring and Troubleshooting SQL Server.
  • Excellent knowledge in Dimensional Data Modeling and analyzing Data warehouses by building multidimensional cubes using SQL Server Analysis Services (SSAS).
  • Expert in designing Enterprise reports using SQL Server Reporting Services (SSRS) generated Drill down reports, Parameterized reports, Linked reports, Sub reports, Matrix reports and Cascaded reports in SSRS.
  • Extensively worked on Table Design creating Clustered Indexes, Non-Clustered Indexes, Primary key, Foreign
  • Key Relationships, highly complex joins and SQL Scripts for Views and Materialized Views.
  • Developed advanced complexed scalable ETL SSIS solutions utilizing Microsoft Azure Service Bus, Web
  • Services (Rest and Web API), and Microsoft Streaminsight Server Platform.
  • Knowledge in Microsoft enterprise cloud technologies such as Dynamics 365 CRM, Office 365, Microsoft Azure.
  • Expertise in generating reports on-demand and scheduled reports for business analysis or management decisions using SQL Server Reporting Services, Crystal Reports, MS Excel, Power BI and Tableau.
  • Configure database replication from on premises to Azure SQL, data sync and migration of database to and from Premise/Azure DB.
  • Experience in Database Development and Release Management Concepts, Practices and Procedures along with Performance Tuning Database Code in OLTP and OLAP environments.
  • Experience in Data Conversion and Data Migration using SSIS across different databases like Oracle, Excel, CSV, MS access and flat files.
  • Evaluated database performance and performed maintenance duties such as Tuning, Backup, Restoration and Disaster Recovery.
  • Experience with logical and physical data modeling, Fact and Dimensional tables and database design using
  • Data Modeling Tools like Erwin, MS access and Microsoft Visio.
  • Very good Self-motivated, smart working Professional with good organizational leadership.
  • Ability to work in-groups as well as independently with minimal supervision.
  • Good team player, strong interpersonal, analytical and communication skills combined with self-motivation, initiative and the ability to think outside the box.

TECHNICAL SKILLS

Databases: MySQL, MS SQL Server (2008.2008R,2012,2014,2016), Oracle (10g,11g,12c), MS Access, IBM DB2, MongoDB

Languages: SQL, T-SQL, PL/SQL, R, SAS, Python, UML, Java, HTML, CSS

Tools: SQL Server Management Studio (SSMS), MS Visual Studio (2013/2015/2017 ), Eclipse, SQL Server Profiler, Power BI (Desktop, Server, Mobile), MS Excel, MS Word, MS Project, MS Visio 2016, SQL Plus, Tableau (Desktop, Server).

ETL Tools: Data Transformation Services (DTS), MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), MS SQL Server Analysis Services (SSAS) Import Export Data, Alteryx

Methodologies: Waterfall, Agile, Business Analysis, Object-Oriented (Use Case) Analysis, Database Design and Normalization, Data Modeling.

Machine Learning: ANOVA, Regression (Linear, Logistic, Polynomial, Decision Tree, Random Forest, Support Vector), Naïve Bayes, K-NN, Clustering (Hierarchical, K-Means)

Big Data Technologies: Hadoop, Pig, Hive, Oozie, Flume, Impala, Avro, Kafka, Spark

Operating Systems: Windows Server 2003R2/2008R2/2012, Windows (XP,7,10), Unix.

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

MSBI/Power BI developer

Responsibilities:

  • Involved in Business requirement gathering, Technical Design Documents, Business use cases and Data mapping.
  • Developing SQL database and BI solutions using T-SQL, SSIS, SSRS, SSAS, MDX, query performance tunings, database development, implementation, support of data, and underlying data models.
  • Created SSIS Packages to perform filtering operations and to import the data on a daily basis from the OLTP system to SQL server.
  • Extensively worked with the SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Lookup.
  • Design and development of Datawarehouse to accommodate upcoming update or incremental data sets.
  • Develop API services in an Agile environment.
  • Experience working with SSIS, for ETL process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions, and package configurations, scheduled the SQL jobs and SSIS Packages using Job Controller (Enterprise Scheduler) and used exceptional Handling and log in SSIS to handle errors and track the package execution.
  • Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2008R2/2012 and in adding calculations using MDX.
  • For customer relationship management (CRM) and enterprise resource planning (ERP) I use Dynamic 365.x
  • Designed SSIS packages to import data from multiple sources to control upstream and downstream of data into SQL Azure database and used Microsoft Azure data storage, Azure Data Factory and Data Lake.
  • Wrote SQL queries on data staging tables and data warehouse tables to validate the data results.
  • Designed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measures groups and
  • KPIs to analyze performance of Strategic Business Units as well as corporate centers.
  • Created Claims and Enrolment OLAP Cubes for various measure groups and dimensions for analysis of Per
  • Member/Per Month cost to meet the business answers for the client needs using SSAS.
  • Developed Tableau and Microsoft Power BI Dashboards to showcase the result of data analysis from the database.
  • Plan solution architecture to create cloud based Azure big data solutions using Azure services and components. Build Big Data Solutions to Acquire, Prepare, Process, Predict, and Visualize Data Insights using services like Azure Data Factory, Azure Storage, Azure Data Lake, Apache Spark Clusters, Azure Databricks, Power BI, Microsoft BI Stack, and Azure Machine Learning using Python.
  • Deployed and uploaded SSRS reports to SharePoint Server for the end users to look at them.
  • Experience in creating DAX expressions, create date to yearly columns and implement partitions in tabular model for Power BI, publishing reports of dashboard in Power BI server, scheduling the dataset to refresh for upcoming data in Power BI server and understood underlying Data and reworked Data Analysis with Power BI.
  • Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
  • Plan, Design, Implement DW environment using Lambda Architecture in the Cloud with Azure Databricks.
  • Build Multi-dimensional Cubes or Tabular Cubes using either STAR sschema or SNOWFLAKE schema based on data volume and provide data at Cube level in Facts, which should be' easily slice-able by Dimensions.
  • Writing T-SQL scripts, dynamic SQL, complex stored procedures, functions, triggers and SQLCMD.
  • Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS, developed and maintained enterprise reporting (SSRS Reporting Service) based on specifications and business needs and modified existing reports as needed.
  • Supported technical teams in community discussions for educating members on API applications functionalities.

Environment: MS SQL Server 2014/2012/2008 , Visual Studio 2010/2012, Tableau, Reporting Services (SSRS), Power BI, Integration Services (SSIS), Analysis Services (SSAS), T-SQL, Microsoft Azure, Excel.

Confidential, Atlanta, GA

SQL/ BI developer

Responsibilities:

  • Designed the functional and technical documents, report templates and reporting standards for the developers to work on the report development.
  • Gather the functional requirements from the client.
  • Created/Updated Stored Procedures, Triggers, Functions, Views, and Indexes with extensive use of T-SQL.
  • Performed Full load & Incremental load with several Data flow tasks and Control Flow Tasks using SSIS
  • Created SSIS Packages to perform filtering operations and to import the data on daily basis from the OLTP system to SQL server.
  • Developed SSIS packages using for each loop in Control Flow to process all excel files within folder, File
  • System Task to move file into Archive after processing and Execute SQL task to insert transaction log data into the SQL table.
  • Written complex sql queries to retrieve data from Dynamic CRM and display in SSRS reports. Created SSIS job to verify accounts and leads from excel file.
  • Used various SSIS tasks such as Conditional Split, Derived Column, Lookup which were used for Data
  • Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse
  • Designed and implemented Data Marts, Facts, Dimensions and OLAP cubes using dimensional modeling standards in SQL server.
  • Developed Power Pivot Reports in Excel 2013 by publishing them to SharePoint 2013 for providing ad-hoc reports according to client need.
  • Implemented SSAS Cubes, Facts and Dimension tables to perform analysis services.
  • Generated various reports with drilldowns, calculated members, dropdowns from the cubes by connecting to the Analysis server from SSRS.
  • Simultaneously maintained the existing ETL and recreated new SSIS packages and created test cases for testing the SSIS packages.
  • Wrote complex SQL queries and stored procedures to create reports using SSRS from the relational database.
  • Used Microsoft Power BI Power Query to extract data from external sources and modify data to certain format as required in Excel, and created SSIS packages to load excel sheets from PC to database
  • Created SSRS Data Model projects using Microsoft Visual Studio and using Report Builder for report server to create reports.
  • Developed and maintained system documentation, diagrams, and flowcharts.
  • Supported technical teams in community discussions for educating members on API applications functionalities.

Environment: SQL Server 2008R2/2012, SSIS, SSRS, SSAS, T-SQL, MS Office (Word, Power point, Excel), ETL, Microsoft Visual Studio, Power BI, TFS, ERWIN, SharePoint.

Hire Now