We provide IT Staff Augmentation Services!

Senior Msbi/sql Developer (ssrs, Ssas, Ssis, Power Bi) Resume

Dfw, TX

SUMMARY

  • Over 71/2 years of experience in SQL server database and Data Loading and Reporting tools with SSIS, SSAS, SSRS, and Power BI.
  • Involved in various phases of Software Development Life Cycle (SDLC) including Analysis, Design, Testing, Implementation and Maintenance.
  • Extensive experience in developing complex Stored Procedures, Functions, Triggers, Views, Cursors, Joins and Sub queries with T - SQL, Database Design including ER diagrams, normalization.
  • Expert in developing T-SQL (DDL, DML) statements, Data Integrity (constraints), SQL Clustering, Rules, Performing Tuning, Query Optimization and Data Validation issues.
  • Created, Built and deployed successfully dynamic SSIS packages into SQL Servers 2014/2012/2008 databases and scheduled them according to teh requirements.
  • Performed Data Quality Services (DQS) to enable a data and to maintain teh quality of teh data and to ensure dat data is suitable for its business usages.
  • Having experience with C#.
  • DQS enables to discover, build and manage knowledge about teh data which are used to perform data cleansing, matching and profiling.
  • Created and Configured Data Source and Views, Dimensions, Cube, Measures, Partitions, KPI’s & MDX Queries using SQL Server Analysis Services and MDX.
  • Proficient in Developing SSIS Package to perform ETL on data into teh Data Warehouse (DWH) from Heterogeneous databases such as Oracle, DB2 and MS Access.
  • Worked with RDBMS implementation using SQL, PL/SQL and MySQL on Oracle Database.
  • Expert in creating teh MDX cubes and dimensions (SSAS).
  • Excellent in High Level Design of ETL SSIS Packages for integrating data using OLE DB connections from heterogeneous sources (Excel, CSV, Oracle, Flat files, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Execute SQL Task, Data Flow Task, SCD, Lookup, Bulk Insert, Merge and union all.
  • Expert in developing Data Warehouse architecture, ETL framework and BI Integration using Reports and Dashboards.
  • Experienced in creating Jobs, Alerts, SQL Mail Agent, and scheduling SSIS Packages.
  • Experience in writing Parameterized Queries for generating stylish Tabular reports, Drill down, Drill through, Cascading, Parameterized, click through, Matrix, Chart, Snap shot reports, Formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting teh data, defining data source and subtotals for teh reports using SSRS.
  • Created Power BI Visualizations and Dashboards as per teh requirements.
  • Experience in working with large databases in SQL, Oracle and Teradata.
  • Involved in SSAS cube maintenance activities including troubleshooting and Data Visualizations using SSRS and Crystal Reports and Power View.
  • Knowledge in Tableau Desktop for data visualization through various charts such as bar charts, line charts, combination charts, pivot tables, scatter plots, pie charts and packed bubbles and use multiple measures for comparison such as Individual Axis, Blended Axis and Dual Axis.
  • Widespread knowledge in using report building tools like PowerBI, Tableau and Qlikview.
  • Worked for production support for multiple projects. Mainly focused on clearing issues in teh ETL packages and SSRS packages.
  • Experience in working at various levels of software development cycles such as Analysis, Designing, Developing and Testing & Implementation of business applications in Client Server/RDBMS for Windows platform.
  • Good knowledge in Normalizing and De-normalizing teh tables and maintain Referential Integrity by using Triggers and Primary and Foreign Keys.
  • An empathetic listener and persuasive speaker with excellent written and verbal skills.

TECHNICAL SKILLS

Languages: T-SQL, PL/SQL, MySQL, MDX, C, C#, Java

Databases: MS SQL Server 2016, 2014, 2012, 2008R2, MS Access

BI Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services(SSRS), SQL Server Analysis Services (SSSAS), Visual Studio

Database Design Tools and Data Modeling: Star Schema/Snowflake Schema modeling, FACT & Dimension Tables, Normalization and De-Normalization Techniques

Reporting Tools and Utilities: SQL Server Management Studio (SSMS), SSRS, Crystal Reports, PowerPivot, Power BI, Tableau

Operating Systems: Windows Family, UNIX

Packages: MS Office, Microsoft Office SharePoint Server 2007

Parsing: JASON AND REST

PROFESSIONAL EXPERIENCE

Senior MSBI/SQL Developer (SSRS, SSAS, SSIS, Power BI)

Confidential, DFW, TX

Responsibilities:

  • Involved in development and implementation of SSIS, SSAS, SSRS application solutions for various business projects across teh organization.
  • Developed Custom Visualization in Power BI such as Liquid Fill Gauge, Bar Charts, etc.,
  • Used Microsoft Power BI Power Query to extract data from external sources and modify data to certain format as required in Excel.
  • Wrote DAX Expressions, Power Query, Functions in Power BI.
  • Used Power BI Power Pivot to develop data analysis prototype and used Power View and Power Map to visualize reports.
  • Created various complex reports, Dashboards and manage those using SQL Server Reporting Services.
  • Created Tabular reports, Matrix reports, List & Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment.
  • Developed SQL Queries for fetching complex data using joins, sub-queries, CTE, Tally tables accommodating complex filters and database links.
  • Worked with database developers in all phases. Having a good knowledge on database design according to teh client specifications and requirements
  • Designed various kinds of reports on given data and some of teh reports like cascade, parameterized and linked reports dat will help to drill-down process in teh report.
  • To load teh data from source to data mart, we used two packages me.e., Type 1 and Type 2 for incremental loading.
  • We written complex SQL Queries for analyzing teh data to design teh reports for various stake holders.
  • With teh help of visualizations in Power BI, created various visualization like Pie charts, Bar graphs, Tree maps etc., dat will helpful easily to understand teh data.
  • Holding teh responsibility for deploying teh SSIS packages and scheduling teh packages through jobs in all phases including development, testing and production.
  • Created different Facts and Dimension tables to increase teh performance of complex SQL queries dat are used in SSRS reporting.
  • Created packages with different control flow options and data flow transformations such as Conditional Split, Derived Column, look up, Data Conversion, Merge Join.
  • Used SSIS and SQL Server stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts.
  • Extensively worked on production support dat includes Deployment of SSIS packages into Development, Production Servers, Creating, Scheduling and Managing teh SQL Jobs.
  • Extensively worked on ETL packages to extract, transform and load data from different sources like Excel, Flat files, Execute SQL Tasks, Data Flow Task, Derived Columns Tasks.
  • Worked on Execution of teh paths depending on teh success, failure or Completion of other tasks with precedence constraints and expressions to determine teh workflow.
  • Generated monthly and quarterly reports as bar charts for teh management using different techniques like data filtering, adding interactivity, deploying reports to Cloud.
  • Shared reports in Power BI service to entire Organization in Office 365.

Environment: SQL Server 2016, T-SQL, PL/SQL, Excel, Power BI Desktop, Power BI Web, Azure Database, Visual Studio 2015, MS Excel.

Senior BI/Power BI Developer

Confidential, St Louis, MO

Responsibilities:

  • Worked as a developer in creating complex stored procedures, triggers, functions, indexes, tables, views and other T-SQL code and SQL joins for applications.
  • Implemented different types of constraints on tables.
  • Created views to facilitate easy user interface implementation, and triggers on them to facilitate.
  • Developed Queries for generating reports in SSRS 2012 for Complex Executive Dashboards and Customer Performance dashboards to analyze teh KPI’s for all global clients.
  • Created database objects like Procedures, Functions, Triggers, Indexes, and Views using T-SQL in SQL Server.
  • Used various transforms in SSIS to load data from accounting software Quick Books in teh form of flat files to teh SQL databases.
  • Worked as a developer in creating complex Stored Procedures, SSIS packages, triggers, cursors, tables and views and other SQL joins for building various applications.
  • Helped our customers with different refresh issues in teh Power BI online service.
  • Responsible for creating SQL datasets for Power BI and Ad-hoc Reports.
  • Utilized Power BI for Office 365 to amplify data visualization with collaboration and data management.
  • Developed multiple dashboards with Power BI depicting differing KPIs for business analyses.
  • Implemented pivot/un-pivot, transpose features of Power BI to load data into excel Power Pivot.
  • Employed bar charts, bubble charts, and Power map to answer business questions with Power BI.
  • Created, maintained & scheduled various reports in Power BI like Tabular Reports, Matrix Reports.
  • Created reports in Power BI preview portal utilizing teh SSAS Tabular via Analysis connector.
  • Studied teh existing OLTP system(s) and interacted with Data Architect regarding facts, dimensions and star schema representation for teh data mart.
  • Involved in recreating teh analytical reports using MS Access Database using SSRS to eliminate any Manual Processing.
  • Involved in integrating SSRS Reports with QR Codes, Micro QR Codes, and Standard barcodes using third party applications to track teh Samples at various levels from receiving to testing.
  • Created Accounting Reports based on Quick Books data for Region wise sales, sales by client, Sales by State, quarterly sales for all teh Global clients.
  • Experienced in using Power-Pivot for analyzing teh raw data and team meetings and during requirements gathering.
  • Created SSRS Report to automatically print teh label for teh Sample Scheduling for teh Analysts, eliminating teh manual process and paper based approach.
  • Involved in both Unit Testing and Integration Testing to ensure all teh software deliverables are following teh end user business and technical requirements.
  • Involved in embedding teh SSRS Reports and Dashboards in teh internal web applications.
  • Worked on teh POC of Creating Monthly Quality Assurance Reports, letters for some of teh exclusive clients and setup subscriptions to deliver these Reports based on a schedule.
  • Involved in generating several Matrix reports, Sub reports and Complex reports with multi value parameters for teh analysis of Performance using SSRS.
  • Worked on caching teh reports to improve teh Report Retrieval Time.
  • Used SVN to manage teh team’s software development lifecycle including deriving product backlog items and conducting sprint review meetings.
  • Actively involved in User Acceptance Test (UAT) for various end-users across teh departments, to explain them teh full functionalities of teh SSRS Reports and Dashboards.
  • Worked with high level end-users, communicating teh progress and developments in a timely manner.

Environment: MS SQL Server 2012, MS Reporting Services 2012, MS Access, Microsoft Visual Studio 2012, SQL Server Integration Services 2012, Tortoise SVN, T-SQL, Micro QR Readers, Windows XP Professional, MS Excel 2013, Power Pivot, Power BI, Power View.

MSBI Developer

Confidential, Trenton, NJ

Responsibilities:

  • Integrated ceding companies claim data, from heterogeneous data sources (flat file, csv) and legacy system (DB2, Access, Excel) into centralized data warehouse using SSIS.
  • Created staging areas for data processing (cleansing, validation, audition) and transformation (aggregation, lookup, filter).
  • Studied teh existing OLTP systems and interacted with Data Architect regarding facts, dimensions and star schema representation for teh data mart.
  • Used Master Data Service (MDS) to manage teh usage of teh data among different groups of similar data. We can organize teh data into models, create rules for updating teh data, and control who updates teh data.
  • Used open queries to fetch data from DB2 source systems.
  • Used Bulk Binds and Records processing to improve teh performance of processing.
  • Created views, Indexed Views, Power pivot to support internal Reporting requirements and modified teh existing reports based on End User Requirements.
  • Used different kinds of SQL Joins to join more number of tables.
  • Extracted data from Oracle, MS SQL databases to create Pivot tables need for teh end users.
  • Involved in Extraction, Transformation and Loading (ETL) of data in teh data warehouse for DB2 database using Informatica and SSIS.
  • Created efficient SSIS packages for processing fact and dimension tables with complex transformations.
  • Participated in teh migration of applications to quality assurance and teh production environment.
  • Performed necessary production support tasks involving on-call responsibilities both during and after work hours.
  • Designed visualizations based on claims, frauds, on teh health care insurance policies to get an idea about teh people who are trying to get teh claims from teh company.
  • Involved in User Acceptance Training (UAT) with user to create reports using Report Builder tool.
  • Generated reports using Global Variables, Expressions and Functions for teh reports.
  • Involved in generating Matrix reports, Sub reports and Complex reports with multi value parameters for teh analysis of Performance using SSRS.
  • Used Microsoft Team Foundation Server (TFS) to manage teh team’s software development lifecycle including deriving product backlog items and conducting sprint review meetings.

Environment: MS SQL Server 2012, MS Reporting Server, Report Builder, Microsoft Visual Studio 2012, SQL Integration Services 2012, T- SQL, Windows XP Professional, MS Excel.

SQL/BI Developer

Confidential, Santa Clara, CA

Responsibilities:

  • Worked on teh Reports module of teh project as a developer on MS SQL Server 2008 R2 (using SSRS, T-SQL, scripts, stored procedures and views).
  • Filtered and cleansed bad data from legacy system using complex Transact - SQL statements in staging area, and implemented various constraints for data consistency.
  • Developed SQL Queries to fetch complex data using Inner/Outer joins, sub-queries, CTE, Tally tables accommodating complex filters and database links.
  • Optimized teh performance of queries in TSQL queries, normalized tables, established joins and created clustered/non-clustered indexes wherever necessary.
  • Build cubes using SSAS and created reports from Analysis Services using MDX query designer.
  • Involved in storage and partitions, and Aggregations, calculation of queries with MDX, developing reports using MDX and SQL.
  • Provide analytical support of global supply chain management strategies, goals, and objectives Serve for various projects and reports and collect and analyze information using SQL Query tools, and make recommendations to teh team.
  • Extensively used BI tools like integration service, Reporting Services and Analysis services in MS SQL Server.
  • Designed different kinds of reports like Linked, cascaded and parameterized reports and worked on Drill Down and Drill-through reports, Tabular, Matrix, etc.
  • Experienced in developing stored procedure driven reports, building custom application on reports, formula writing/editing in reports, Report Administration and performance tuning of reports.
  • Used various SSIS transformations like Conditional Split, Multicast, Fuzzy look up etc., which did Data Scrubbing, including data validation checks during Staging, before loading teh data into Data warehouse.
  • Created customized reports using various chart types like Text Tables, Bar, Pie, Tree Maps, Line Charts, Pivot Tables in Excel and Tableau.
  • Created cubes with Start schema in SSAS and developed SSRS report based on teh cubes.
  • Used performance tools like SQL Profiler, Index Tuning Wizard and Database Engine Tuning Advisor.

Environment: SQL Server 2008 R2, T-SQL, Excel, Microsoft BI, Windows Server 2008, Visual Studio, Query Analyzer, SVN version controlling, Tableau.

SQL Developer

Confidential

Responsibilities:

  • Involved in planning and designing database and coordinate with DBA in creating and managing database objects.
  • Actively involved in Normalization of database.
  • Designed DDL and DML for MS SQL Server 2000.
  • Create rules, defaults, tables, views, clustered & non-clustered index, user defined data types, and user defined functions.
  • Optimize query performance by creating indexes.
  • Involved in writing SQL batch scripts.
  • Write T-SQL statements for retrieval of data and involved in performance tuning of T-SQL.
  • Involved in merging existing databases and designed new data models to meet teh requirements and perform daily database backup & restoration and monitor teh performance of Database Server.
  • Created joins and sub-queries for complex queries involving multiple tables.
  • Use DDL and DML for writing triggers, stored procedures, and data manipulation.
  • Install and configured SQL Server 2000 on development server for designing and testing.

Environment: MS SQL Server, T-SQL, DTS, SQL Server Enterprise Manager, SQL Profiler.

SQL Server Developer

Confidential

Responsibilities:

  • Managing Installation, Configuration and Maintenance of MS SQL Server 2005.
  • Created and manages schema objects such as tables, views, indexes, procedures, triggers and maintaining Referential Integrity.
  • Participated in re-design and development of back-end SQL Server database, wrote queries, triggers and stored procedure.
  • Involved in creating different flow services required for data transformation, creating & validating IS Schema, IS Document types.
  • Involved in teh configuration of JDBC Adapter using different templates like custom adapters using different SQL Queries and Stored Procedures.
  • Installation of replication server, configuration and monitoring teh replication between two sites, implemented Transactional replication.
  • Created and running DTS Packages for Import and Export of Heterogeneous Data.
  • Scheduled teh backups for Databases and Transaction log. Performed restoration operations. Suggested backup strategies.
  • Responsible for unit testing, writing design documents and uploading it to share point server.
  • Creation of schema objects, granting of roles and privileges to teh users, compilation of procedures etc.
  • Used DDL and DML for writing triggers, stored procedures and data manipulation.
  • Created database administrative job of Security, Backup/recovery, ODBC connections etc.,
  • Provided support to teh Application developers on teh application databases.
  • Responsible for creating stored procedures and SSIS packages as part of teh ETL process to populate teh data marts.

Environment: SQL Server, Windows 2000/XP, MS Access, SQL Profiler, DTS, T-SQL, Query Analyzer, MS Excel.

Hire Now