We provide IT Staff Augmentation Services!

Msbi Developer Resume

NJ

SUMMARY

  • Over 6+ years of IT experience the use and development, design of Microsoft SQL Server 2005/2008r2 database. Development using Microsoft SQL Server MSSQL Server 2000/2005/2008/2012/2014 and SQL server BI suite of products SSIS, SSRS, and SSAS in various domains like Health Care and Insurance as MSBI Developer.
  • Experience in all phases of software development life cycle (SDLC).
  • Knowledge on Tableau visualization and reporting.
  • Expertise in ETL tools like SSIS and reporting tools such as SSRS, Power BI.
  • Developed complex SQL queries using common table expressions (CTEs), temporary table to support Power BI and SSRS reports.
  • Experience in Desktop Application and Web Application Testing.
  • Excellent knowledge of Manual Testing concepts and skills.
  • Experience in the areas of analysis, design and development of Business Intelligence solution using Visual Studio (SSDT) - Power BI.
  • Collaboratively worked with the team from requirements gathering to project development, deployment and production support on various projects.
  • Very good Experience in developing Reports in MS Excel, MS PowerPoint, MS Access and creating different analytical reports.
  • Proficient in Enterprise Data Warehouse. Worked extensively in several projects in both Forward Engineering as well as Reverse Engineering using data modeling tools.
  • Good Understanding and Knowledge with Agile and Waterfall Environments. Highly Proficient in creating SQL Server Reports, handling sub-reports and writing queries to perform Drill through and drill down operations in SSRS.
  • Experience in testing/validating the Source, Stage and Target (End-to-End).
  • Experience in analyzing the error caused to failure of the ETL load with reference to the log file and report them to the corresponding team to get it rectified.
  • Validate EDI Claim Process according to HIPAA compliance. Tested HIPAA regulations.
  • Extensively involved in communicating with the onsite users in resolving the issues and contributing my part of technical support to the team.
  • Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance.
  • Hands on experience with SQL database, MS SQL Server and Oracle SQL.
  • Translate business requirements into ETL and report specifications.
  • Maintained database using backups and refreshing in testing environment.
  • Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing different kinds of transformations using power BI and SSIS.
  • Proficient in performing data extraction, transformation and loading (ETL) between systems using SQL tools such as SSIS.
  • Worked closely with QA team to support Test Planning, Test Preparation, Test Execution and Defects/Bugs Validation through various defect tracking tools.
  • Strong analytical/problem solving with attention to detail, team player with excellent Interpersonal and Organizational skills.

TECHNICAL SKILLS

SQL Server Tools: SQL Server Management Studio

Programming Languages: SQL, PL/SQL

ETL Tools: Data Transformation Services, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS).

Methodologies: Agile, Waterfall

Testing Tools: Test Director 8.0, Quality Center 9.2, HP ALM

Other Tools: MS Office, MS Excel, MS Project, MS PowerPoint and MS Visio

Operating Systems: Windows 10/8/7/XP, UNIX, LINUX.

Reporting Tools: SSRS, SSAS, Power BI, Tableau

PROFESSIONAL EXPERIENCE

Confidential, NJ

MSBI Developer

Responsibilities:

  • Collected business requirements from users and translated them as technical specifications and design documents for development.
  • Created new reports based on requirements.
  • Worked with Internal modeling team for data analysis and profiling.
  • Experience in SQL joins, sub queries, tracing and performance tuning for better running of queries.
  • Strong understanding in the principles of Data ware housing using Fact Tables, Dimension Tables, star schema modeling and snowflake schema modeling, slowly changing dimensions
  • Created Parameterized, Cascaded, Drill-down, and Drill-through reports using SSRS.
  • Created SSIS Packages to import and export from Excel Spreadsheets, Text files and CSV files.
  • Using SSIS, building high performance data integration solutions, including extraction, transformation, and load (ETL) packages for data warehousing
  • Created basic reports using Confidential files as source to fetch the data in Power BI. Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
  • Created tabular reports, matrix reports, list and chart reports, parameterized reports, sub reports, ad hoc reports, drill-down reports and interactive reports according to business requirements in time-restricted environment.
  • Created SSRS report model projects in BI studio and created, modified, and managed various report models with multiple model objects, source fields, and expressions.
  • Worked on building several new SSIS packages and updating existing packages and created related scheduled jobs.
  • Designed and implemented basic SQL queries for testing and report/data validation.
  • Help to Design reporting solutions to meet business requirements.
  • Involved in developing complex reports for various new projects and converted excel reports in to Business objects for ease of use and maintenance.
  • Experience in using SSRS in creating and managing reports for an organization.
  • Involved in performance testing of all the reports, which helped in analyzing its performance before moving into production.
  • Planned, designed, and implemented processes to receive, transform and load valuable data from external sources into local databases.
  • Designed SSIS Packages to load data from different sources like excel, flat file, csv etc.
  • Facilitated UAT (User Acceptance Testing) for all the converted internal systems with business users, management group and team members.
  • Experience in using SSIS in solving complex business problems.
  • Used SSIS, SSRS for solving business problems and creating reports in organization.
  • Involved in interacting with the end-user (client) to gather business requirements.
  • Developed complex mappings to load data from Source System (SQL) and flat files.
  • Created dashboards by extracting data from different sources using parameters, sets, groups and calculations. Involved in creating interactive dashboard and applied actions (filter, highlight and URL) to dashboard. Involved in creating calculated fields, mapping and hierarchies.
  • Involved in creating interactive dashboard and applied actions (filter, highlight and URL) to dashboard.
  • Managed and executed the test process, using Agile Methodology.
  • Worked with Data Completeness, Data Transformation, Data Quality, Integration, UAT testing and Regression testing for ETL and BI group.
  • Involved in extraction, transformation and loading of data directly from different source systems like flat files, Excel.
  • Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories based on business needs

Environment: Data Analysis, Oracle 9i, SQL, PLSQL, Ms Visio, Linux, UNIX, Windows XP, MS Project, MS Access, ALM/Quality Center, MS Word, SSRS, SSIS.

Confidential, MD

SQL Developer

Responsibilities:

  • 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.
  • Experienced in Team Foundation Server which also includes a data warehouse where data from work item tracking, source control, builds, and testing tools are stored.
  • 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.
  • All team projects are stored and managed with Team Foundation Server.
  • Involved in Team Foundation Server which provides a set of collaborative software development tools that integrate with your existing IDE or editor thus enabling your cross-functional team to work effectively on software projects of all sizes.
  • 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 (.dtsx files) 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.
  • Experienced in Dimensional Data Modeling and some of the terms commonly used are Dimension Table, Attributes, Hierarchy, Fact Table, Lookup Table.

Environment: MS SQL Server 2012, SQL Server Integration services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), T-SQL, ORACLE, Microsoft Office 2010, OLAP.

Confidential

SQL Developer

Responsibilities:

  • Worked with various upstream and downstream customers in interfacing various systems and processes for Data extractions, ETL, Analytics and reporting needs.
  • Point of contact for all the Data processes, Data Mappings, Data dictionaries, Data pulls and Reporting solutions.
  • Designed and Developed SSIS Packages to import and export data from MS Excel, XML, SQL Server 2008, Flat files, DB2 and used SSIS Package Configuration, Expressions, passing variables dynamically, logging, Event Handler.
  • Performing Data source investigation, developed source to destination mappings and data cleansing while loading the data into staging/ODS regions.
  • Applied various data transformations like Lookup, Aggregate, Sort, Multicasting, Conditional Split, Derived column etc.
  • Creating SQL Server Agent Jobs to maintain and run various SSIS packages periodically or as scheduled.
  • Responsible for identify and translate business requirements for the Enterprise Data Warehouse into logical and physical data models.
  • Integrated SQL Server 2005 reporting services (SSRS) with Microsoft Office Share point Server to automatically deliver reports to the Share Point portal.
  • Querying, creating stored procedures and writing complex queries and T-SQL Joins to address various reporting operations and also random data requests.
  • Created Drill-through reports, parameterized reports and linked reports using SSRS and were integrated in the Performance point server.
  • Creating and maintaining various subscriptions in the Report Manager for the reports.
  • Developing products by determining what competitors are doing, risk assessments, ratings assessments, pricing and coverage.

Environment: MS SQL Server 2008R2, SQL BI Suite (SSAS, SSIS, SSRS), Visual Studio, Team Foundation Server, C#, Visual Source Safe (VSS), Oracle, Pl/SQL, Share Point, MS Project, MS Access 2003/2007

Confidential

MSBI Developer

Responsibilities:

  • Analyzed requirements, designed, developed, deployed and documented software components.
  • Participate in daily agile meeting, weekly and monthly staff meetings and collaborate with various teams to develop and support ongoing analyses.
  • Conduct data accuracy analysis and support stakeholders for decision-making.
  • Performed data cleansing, data validation and mapping as described in the business requirements.
  • Designed and implemented complex SQL queries for QA testing and report/ data validation.
  • Worked extensively in documenting the Source to Target Mapping documents with data transformation logic.
  • Created naming and system standards for lookup, transformation and target tables.
  • Worked on Manual test cases for UAT testing and use SQL for querying and analysis purposes on various source tables and conditions applied.
  • Conducted User Acceptance testing (UAT) and A/B testing worked with users and vendor who build the system.
  • Managed the testing and verification of HIPAA standard transactions, and EDI messages like (837, 835, 834),Validate the date from EDI transaction.
  • Used Power Query to acquire data and Power BI desktop for designing rich visuals.
  • Created basic reports using Confidential files as source to fetch the data in Power BI. Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
  • Worked closely on 834 transaction code for Benefit Enrollment and was involved in Validation of HIPAA for 837, 834 EDI transactions
  • Responsible for defining the functional requirement documents for each source to target interface.
  • Analyzed various source systems to understand the relationship between different source Tables
  • Involved in creating interactive dashboard and applied actions (filter, highlight and URL) to dashboard.
  • Involved in designing the integrated Data Warehouse for the company to store the data from the OLTP systems.
  • Involved in Data analysis for data conversion - included data mapping from source to target database schemas, specification and writing data extract scripts/programming of data conversion, in test and production environments.
  • Developed dashboard, Charts and reports using Power BI.
  • Developed SSIS packages for extract/load/transformation of source data into data warehouse/OLAP cubes as per the functional/technical design and conforming to the data mapping/transforming rules.
  • Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.
  • Designed, Developed and Deployed reports in MS SQL Server environment using SSRS 2008.
  • Worked on formatting SSRS reports using the Global variables and expressions.
  • Created Parameterized reports, Drill down and Drill through reports using SSRS.
  • Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard.
  • Responsible for Monitoring and Tuning Report performance.
  • Used ETL process to Extract, Transform and Load the data into stage area and data warehouse.
  • Developed complex mappings to load data from Source System (SQL) and flat files.
  • Extensively worked with Quality Analyst to make sure that the functionality meets requirements.
  • Worked with GUI team for designing the screens and assisted in developing mockup screens and prototyping of the user interface for usability testing.
  • Prepared system Test Plan and scenarios for Test Scripts.
  • Involved in HIPAA/EDI Medical Claims Analysis, Design, Implementation and Documentation.
  • Worked extensively with the QA team for designing Test Plan and Test Cases for the User Acceptance Testing.

Environment: PL/SQL, SQL Server 2008, Oracle 10g, Windows XP, Power BI, SDLC, Waterfall and Agile methodology, UML Diagrams and Flow Charts, MS Office, MS Access, ALM/Quality Center.

Hire Now