We provide IT Staff Augmentation Services!

Msbi Developer Resume

Providence, RI

SUMMARY:

  • Around 8 Years of IT experience in the Analysis, Design, Development, Implementing and Testing Client/server application using Microsoft SQLServer and BIsuite .
  • Hands on experience in installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting SQLServer 2014 .
  • Expertise in SQLServer Integration Services ( SSIS ) and SQLServer Reporting Services ( SSRS ) with good knowledge on SQLServer Analysis Services ( SSAS ).
  • Strong experience in design and developing ETL using MS SQL Server Integration Services (SSIS). Worked with various versions starting 2000, 2005, 2008, 2008 R2 2012 and 2014.
  • Experience in report writing using SQLServer Reporting Services ( SSRS ) and creating various types of reports like drill down, drill through, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports.
  • Experience in developing, monitoring, extracting and transforming data using DTS/SSIS, Import Export Wizard, and Bulk Insert.
  • Experience in report writing using SQLServer Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional Table, Matrix, Chart and Sub Reports.
  • Experience in developing, monitoring, extracting and transforming data using DTS/SSIS, Import Export Wizard, and Bulk Insert.
  • Solid knowledge of Power BI Desktop &report performance optimization.
  • 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) by using multiple transformations provided by SSIS such as Derived column, Conditional Split, Bulk Insert, Merge and union all.
  • Developing SSRS reports on SQL Server, Good understanding of SSAS, OLAP cube and Architecture.
  • Excellent knowledge in creating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, functions, Cursors and Indexes using T - SQL .
  • Worked Extensively on ETL process using SSIS package.
  • Experience in Data Conversion and Data Migration using SSIS and DTS services across different databases like Oracle, MS access and flat files.
  • Good understanding of Data Warehousing concepts and ability to utilize star schema and snow flake schema according to the requirement.
  • Experience in using T-SQL in SQL Server 2000 , 2005and 2008 platforms.
  • Experience in Performance Tuning and Query Optimization.
  • Experience in maintenance and Administration of SSIS by creating Jobs, Alerts, SQLMail Agent, and schedule DTS/SSIS Packages.
  • Transformed data from one server to other servers using tools like Bulk Copy Program ( BCP ), Data Transformation Services (DTS) and SQLServer Integration Services ( SSIS )
  • Expert in generating on-demand and scheduled reports for business analysis or management decision using SQL Servers Reporting Services (SSRS), and Power BI.
  • Excellent analytical, communication and interpersonal skills. Proficient in technical writing and presentations and a good team player.

TECHNICAL SKILLS:

Databases: SQL Server 2000/2005/2008/2012/2014 , SQLServer 2008 R2, MS Access, ORACLE 10g/11g, MySQL, Teradata, DB2.

Database Tools: Business Intelligence Development Studio, SQLServer Integration Service (SSIS), SQLServer Reporting Service (SSRS), SQLServer Analysis Service, SQLServer Management Studio.

ETL Tools: SQL Server Integration Service (SSIS), DTS

Languages: SQL Server, MS Access, MySQL, C/C++, HTML, P.H.P, JavaScript, Unix, C#, .Net, VBScript, ASP.Net.

Reporting Tools: SQL Server Reporting Service (SSRS), Crystal Report, Work day, Power Bi, Tableau.

Office Tools: MS WORD, MS EXCEL, MS VISIO, MS Power Point.

Operating Systems: Windows Server 2000, Windows NT Server, Windows Server 2003, Windows XP, Windows 2008, Windows 7, Windows 8, HTML, XML.

PROFESSIONAL EXPERIENCE:

Confidential, Providence, RI

MSBI Developer

Responsibilities:

  • Enterprise Reporting Management of Microsoft was used to generate the reports for finance and operations which was built on the top of multidimensional cube and migrated into tabular modal.
  • Did different POCs like Process Control Framework POC - To verify multiple worker thread under one PCS master job.
  • Tabular With 500 Million Rows - To test performance and scalability of tabular.
  • PNL Report - To avoid customization like in existing PNL report using tabular cube.
  • Troubleshooting of the burning issues in tabular and multidimensional cubes.
  • Translated the existing Reports from Translational to Dimensional in SQL Server Management Studio.
  • Created complex Stored Procedures , User Defined functions, Triggers, Indexes, Tables, Views, SQL joins and defined roles and privileges to implement business rules and control access to database.
  • Created Database Maintenance Plans for the Performance of SQL Server, which covers Database Integrity
  • Wrote complex stored procedures to process requirement and generating records between front End and back end.
  • Wrote standard & complex T-SQL Queries to perform data validation and graph validation to make sure test results matched back to expected results based on business requirements.
  • Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases
  • Created New Reports by using SSRS& did the performance of SSRS Reports.
  • Established the relationships among the tables in the database by assigning primary keys, foreign keys and established the referential integrity.
  • Involved in Planning, Defining and Designing database depending on business requirements and provided the documentation.
  • Created complex Stored Procedures, User Defined functions, Triggers, Indexes, Tables, Views, SQL joins and defined roles and privileges to implement business rules and control access to database.
  • Extensively involved in the design of SSAS & Tabular storage, partitions and aggregations and developed different calculated members, KPIs, actions by using the MDX & DAX while designing the cube using SSAS
  • Created Tabular Models using DAX queries in analysis services and deployed it.
  • Developed and maintained multiple Power BI dashboards/reports and content packs.
  • Responsible for building Power BI Dashboards using Tabular and Multi-Dimensional Models. Design and model data sets with Power BI desktop based on measure and dimension requested by customer and dashboard needs.
  • Created POWER BI Visualizations and Dashboards as per the requirements.
  • Used various sources to pull data into Power BI such as SQL Server, Excel, Oracle, SQL Azure etc.

Environment: T-SQL, MS SQL Server 2016, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Power BI, MDX, SQL Server Analysis Services (SSAS), Visual Studio 2016, OLAP.

Confidential, Boston, MA

SQL BI/ Power BI Developer

Responsibilities:

  • Experience in Extract Transform and Load Process/design, source-target mapping, reviewing, writing, tuning Complex ETL jobs - daily and high frequency.
  • Identify and analyze data discrepancies and data quality issues and work to ensure data consistency and integrity.
  • Exposure to complete development life cycle of Enterprise Data Warehouse design and Development.
  • Developed data warehouse in start schema, fully participated in Dimension modeling using Kimball model.
  • Experience working with Medicare Advantage Organizational Health Plan and also strong in SQL/SSIS .
  • Experience in SSIS, SQL Stored procedures development experience dealing with large volume health care data processing and analytics.
  • Involved in performance tuning of the database and T-SQLqueries using Execution Plan.
  • Manage workload to deliver according to business priorities.
  • Created a SQLServer Reporting Services (SSRS) and SSIS Infrastructure that pulls data from different sources and provides a simple to use reporting environment.
  • Created and Published Tableau Dashboards into Tableau Server.
  • Involved in designing and publishing visually rich and intuitive Tableau dashboards for executive decision making.
  • Created Sets, Groups and Data Bins as per user requirements. Created various views in Tableau like Tree maps, Heat Maps, Scatter plots, Geographic maps, Line chart, Pie charts and etc.
  • Provided visual/graphic analysis based on data content.
  • Developed and maintained multiple Power BI dashboards/reports and content packs.
  • Responsible for building Power BI Dashboards using Tabular and Multi-Dimensional Models. Design and model data sets with Power BI desktop based on measure and dimension requested by customer and dashboard needs.
  • Created several ad hoc reports, drill down, drill through, sub, linked, cached and snapshot reports using SSRS and deployed them in Native mode.
  • Monitor database performance and analyze issues, primarily with Microsoft SQLServer 2012/2014.
  • Customized columns and tables utilizing Named calculations and Named queries in SSAS .
  • Developed stored procedures with advanced programming techniques includes minimal logging, accurate execution plans and index seeking methodologies
  • Created Tabular Models using DAX queries in analysis services and deployed it.
  • Wrote database triggers in T-SQLto check the referential integrity of the database.
  • Deployed SSIS packages with package/project deployment models for testing and production.
  • Wrote custom support modules for upgrade implementation using Pl/SQL, Unix Shell Scripts.
  • Involved in physical and logical data modeling using Erwin along with the architects.
  • Prepared daily and weekly status reports and collaborated with other team members.

Environment: T-SQL, MS SQL Server 2012/2014, SQLServer Integration Services (SSIS), SQLServer Reporting Services (SSRS), Power BI, Tableau, SQLServer Analysis Services (SSAS), Visual Studio 2013, OLAP, XLST, XPATH, C#, Tableau.

Confidential, OH

BI Developer

Responsibilities:

  • Developed, deployed and monitored SSIS Packages for new ETL Processes and upgraded the existing DTS packages to SSIS for the on-going ETL Processes.
  • Created new ETL packages to validate, extract, transform and load data into data warehoused databases using SSIS packages.
  • Designed and developed SSIS packages to import and export data from MS Excel, SQLServer and Flat files.
  • Developed packages in SSIS with error handling.
  • Involved in data cleaning to remove unnecessary columns eliminate redundant and inconsistent data by using SSIS transformation.
  • Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers and Fuzzy Lookups etc.
  • Monitored Full/Incremental/Daily Loads and support all scheduled ETL jobs for batch processing.
  • Migration of DTS packages to SSIS packages.
  • Involved in Migration of Databases from SQLServer 2005 to SQLServer 2008 using SSIS .
  • Involved in Technical decisions for Business requirement, Interaction with Business Analysts, Client team, Development team, Capacity planning and Upgradation of System Configuration.
  • Planned, Configured, Installed, Maintained SQL Server in environment of Multi-Node Cluster with Mulch-instances.
  • Configured and Monitored Database Mirroring for Application Development environment
  • Designed Cubes with Star Schema using SQLServer Analysis Services ( SSAS )
  • Involved in Installation, Configuration and Deployment of Reports using SSRS
  • Actively involved in developing complex SSRS Reports involving Sub Reports, Matrix/Tabular Reports, Charts, and Graphs.
  • Involved in SQLServer Configuration, Administration, Implementation and Trouble-shooting for Business work.
  • Controlled, coordinated installations (Security Patches, Service packs) and evaluated the performance before deployment.
  • Involved in daily code drops and archives on the production databases during maintenance windows.
  • Scripted OLAP database backup and scheduled a daily backup using SQLServer agent job.
  • Performed Regular Database Maintenance process, checking the disk Defrag procedures in different environments.
  • Create reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector and also created roles using SSAS to restrict cube properties.
  • Used SQLProfiler for Performance monitor to resolve Dead Locks and Long running queries by checking appropriate changes to Transaction Isolation levels
  • Performed Database consistency checks with DBCC , Defrag, Index tuning and monitored error logs
  • Database Performance of Index tuning with using Database Engine Tuning Advisor to resolve Performance issues
  • Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.
  • Work involvement in performance monitoring of Memory, Processor, Disk I/O and fine tuning.
  • Involved in writing Stored Procedures and Functions, Cursors to handle database automation tasks.

Environment: SQLServer 2014/2012/2008 , Query Analyzer, SSIS 2014, T-SQL, Excel, Microsoft SQLReporting Services 2014 (SSRS), SQLserver 2014/2012/2008 . Analysis Services (SSAS), DTS, T-SQL, Windows Server 2012 R2, XML, MS Excel, MS Access.

Hire Now