We provide IT Staff Augmentation Services!

Msbi Developer Resume

4.00/5 (Submit Your Rating)

Richardson, TX

SUMMARY

  • Having 8+ years of experience in programming as an SQL Developer in Analysis, Design and Implementation of Business Applications.
  • Expertise in Integration Services (SSIS) and SQL Server Reporting Services (SSRS) with Good knowledge in SQL Server Analysis Services (SSAS).
  • Experience in publishing Power BI Desktop reports created in Report view to the Power BI service.
  • Used Power Query to acquire data and Power BI desktop for designing rich visuals
  • Implementation and technical expertise in Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques.
  • Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as Data Transformation Service (DTS), SSIS, SSRS, Bulk Insert.
  • Extensive working experience in usage of SSIS Control Flow items.
  • Good exposure to all phases of the Software Development Life Cycle from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
  • Extensive Experience in Customization of forms and reports and development of Conversions, Interfaces.
  • Development of automated daily, weekly and monthly system maintenance tasks such as database backup, database integrity verification and index updates.
  • Created basic reports using CSV files as source to fetch the data in Power BI
  • Extensive experience in SQL, PL/SQL Developing.
  • Created basic reports using CSV files as source to fetch the data in Power BI
  • Expert in integrating the SSRS reports into web applications using Report viewer control, URL methods and creating data driven subscriptions to different users using Report Manager.
  • Transferred and retrieved data to and from FTP Servers to Oracle Database.
  • Experience with SSRS Report Server, Report Manager and SSRS deployment Process Working Experience in preparing documentation as per organizational standards, designing, implementing, and maintaining complex database applications in financial environments.
  • Worked with stored procedures, triggers and fluency in PL/SQL.
  • Extensive experience in Performance Tuning of SQL queries & Views.
  • Performed unit testing, system testing and UAT testing.
  • Excellent Knowledge in analyzing Data ware house by building cubes using SQL Server Analysis Services (SSAS).
  • Excellent communication, presentation, interpersonal skills, strong troubleshooting and organizational skill.

TECHNICAL SKILLS

Script and Query Languages: T - SQL, PL/SQL, XML, HTML, VBSCRIPT

SQL Tools: SSIS, SSRS, BUSINESS INTEGELLIENCE STUDIO BIDS, SSMS, VISUAL STUDIO, SSDT, SQL SERVER MANAGEMENT STUDIO(SSMS)

Databases design and Data Modelling tools: MS Visio, ERWIN, Star Schema/Snowflake Schema modeling, FACT & Dimensions tables, Physical & logical data modeling and De-normalization techniques.

Operating systems: WINDOWS 7/10, LINUX, UNIX

Databases: Microsoft SQL Server 2014/2012/2008 R2/2008, MySQL, Oracle, DB2, Teradata, MS Access.

Others: MS OFFICE, JIRA, POWER PIVOT, QLIKVIEW, MS ACESS, WATERFALL AND AGILE METHODOLOGY, TFS, GIT

PROFESSIONAL EXPERIENCE

Confidential - Richardson, TX

MSBI Developer

Responsibilities:

  • Requirement gathering and analyzing data sources. Assisted in design and implementation of Database.
  • Experienced in Data Extraction, Transforming and Loading (ETL) using various tools such as Data Transformation Service (DTS), SSIS, SSRS, Bulk Insert.
  • Oversaw installations, upgrades of SQL 2005 to SQL 2008.
  • Involved in Database design, creation and maintenance of Databases.
  • Managing the use of disk space, memory & connections by monitoring.
  • Created tables and views.
  • Created functions, stored procedures, triggers and constraints using T-SQL.
  • Monitoring & tuning SQL scripts by performance monitoring. Creating upgrade scripts for production Database and supporting it.
  • Server & Application fine-tuning & trouble shooting.
  • Wrote maintenance plans and code optimization. Worked on database designing, logical and physical data modeling, worked on large scale data migration using SQL Scripts, stored procedures, triggers, views, etc.
  • Worked on both live and import data to Power BI for creating reports.
  • Worked with Power BI gateway to schedule daily job to refresh data
  • Expertise in publishing Power Bi reports of dashboards in Power BI server and scheduling the dataset to refresh for live data in Power BI server
  • Managed relationship between Power BI using star schema.
  • Used data transformation services (DTS) to populate data from various data sources using the concept of OLE DB.
  • Recovered the backups of SQL Server production databases in test server environment.
  • Refactored poorly performing SQL queries to improve application performance.
  • Monitoring MS SQL Server performance and network issues.
  • Coordinating with peer groups for Network, Infrastructure and Data Center Operations.
  • Performance monitoring and tuning of SQL servers.
  • Used SSIS to load data from multiple SQL Server sources to a denormalized set of tables for analysis.
  • Built SSRS report to support reporting needs.

Environment: Windows 2000 Advanced Server/Server 2003, SQL Server, SQL Server 2012, SSRS 2012, SSIS 2012, Excel, T-SQL, Windows 2008/XP, C#, ASP.NET, Visual studio

Confidential - Piscataway, NJ

Power BI Developer

Responsibilities:

  • Worked with Stored Procedures, tables, and views and other SQL joins and statements for applications by using T-SQL.
  • Created various kinds of reports using Power BI and Tableau based on the client's needs.
  • Experienced on creating multiple kind of Report in Power BI and present it using Story Points.
  • Expertise in creating Dashboards Scorecards, views, pivot tables, charts, for further data analysis.
  • Migrate existing data into the Power BI.
  • Worked with the application developers and provide necessary SQL Scripts using T-SQL.
  • Created joins and sub-queries for complex queries involving multiple tables.
  • Responsible for creating SQL datasets for Power BI and Ad-hoc Reports.
  • Working directly with stakeholders for requirements gathering and developing various decision-making Dashboards.
  • Hands on experienced developing dashboards and reporting visualization.
  • Expert on creating complex CTE, Sub Queries, Joins, cumulative queries for multiple kind of reports.
  • Investigates problems through to resolution or root cause/raises by pulling Data from multiple Sources and Develop Report.
  • Proven experience developing and managing data integration solutions using Microsoft BI technologies.
  • Designing, constructing, and testing of ETL processes. Created SSIS packages to extract data from the transactional and/or operational databases, transforming the data according to analytical / reporting business needs, and loading the data into a Data Warehouse or Data mart.
  • Responsible for creating datasets using different kind of query language.
  • Expert on creating Score Cards, Metrics, Power View/MAP and Pivot Tables using Office 365.
  • Developed Power Pivot Reports in Excel 2013 by publishing them to SharePoint 2013 for providing ad-hoc reports according to client need.
  • Created, Maintained & scheduled various reports in SSRS like Tabular Reports, Matrix Reports & Parameterized Reports using SQL Server Reporting Services SSRS.
  • Experienced with connecting multiple data sources in Tableau to implement working reports.
  • Created SSIS packages to transfer data, from flat files into SQL server using different SSIS components and used dynamic configuration files and variables for production deployment

Environment: Windows 2000 Advanced Server/Server 2003, SQL Server, Oracle, MS Access, Enterprise Manager, Management Studio, SQL Profiler, SQL Query Analyzer, ETL, MS SQL Server DTS, Upgrade Advisor, DTS Designer Tools.

Confidential - Durham, NC

SQL Developer

Responsibilities:

  • Requirement gathering and analyzing data sources. Assisted in design and implementation of Database.
  • Worked and maintained SQL Stored Procedures, functions, and triggers for updating customer usage information in the database
  • Merge tables and created views to support reporting requests using SQL Server
  • Troubleshoot data and functionality issues related to reports, and SSIS packages
  • Used several transformations in Data Flow including Derived-Column, Script, Lookup, Data Conversion, and Conditional-Split to categorize data for other departments
  • Created complex SSIS packages using proper control and data flow elements with error handling
  • Designed Data flows, Workflows and jobs to load data from source to target
  • Performed Documentation for all kinds of reports and SSIS packages
  • Involved in the analysis and profiling of source data, creating prototypes and sample reports to help with requirements and design (SSRS)
  • Design daily table reports, matrix reports, sub-reports based on business needs using SSRS
  • Created Reports using SSRS. Identified the data source and defined them to build the data source views
  • Created reports in SSRS with properties like chart controls, filters, Interactive Sorting, SQL parameters etc.
  • Designed and created report templates, bar graphs, and pie charts based on financial data for analyzing performance counters using SSRS
  • Created reports using features like drill down, drill through, parameterized reports. Developed yearly, quarterly, monthly sales reports and scheduled the reports to run on daily and weekly basis in report manager and also email them to project manager to review in Excel sheet

Environment: Windows 2000 Advanced Server/Server 2003, SQL Server, MS Access, Enterprise Manager, Management Studio, SQL Server, T-SQL, SSRS, SSAS, SSIS Packages, ETL, ODBC, Excel, Data Integrator, OLAP, OLTP

Confidential

SQL Developer

Responsibilities:

  • Created databases objects using T-SQL scripts, stored procedures, views.
  • Scheduled, conducted meetings with client and work group members to identify requirements documented them in Specification Documents to Identified Priorities.
  • Designed Logical and Physical data models using ERWIN data modeling tool.
  • Created complex Stored Procedures, Functions, DTS packages, Triggers, Cursors, Tables, Views, Indexes and otherSQL joins and statements for applications.
  • Developed Tabular, drill down, parameterized, cascaded and sub-reports using SSRS.
  • Generated Reports using Global Variables, Expressions and Functions based on the requirements.
  • Created Parameterized Reports and Linked Reports and thorough knowledge of report server architecture using SSRS.
  • Created ComplexSQL Queries using Views, Indexes, Triggers, Roles, Stored procedures and User Defined Functions.
  • Created Complex Stored Procedures and automated them usingSQL Server Agent.
  • Experience in implemented Stored Procedures and Triggers for automating tasks.
  • Generated MSSQL Server tasks such as data loading, batch jobs, BCP, DTS, Instances, Linked Servers and Indexes.
  • Worked with Enterprise Manager for job scheduling and batch queries.
  • Compressed data files by removing empty database pages and updating index statistics, managed and monitored the system utilization.

Environment: MSSQL Server Management Studio 2005/2008, Query Analyzer,SQL Profiler, MSSQL Server Integration Services (SSIS), MSSQL Server Reporting Services (SSRS), DB2, Oracle9i, XML, ASP.Net, Windows 2003/2000.

We'd love your feedback!