We provide IT Staff Augmentation Services!

Power Bi / Sql Server Developer Resume

Irving, TX

SUMMARY:

  • 5 years of work experience in developing Business Intelligence applications and data analytics products at various phases of SDLC in the Hospital/Health care, Manufacturing, and Sales/Marketing.
  • Involved in full Software development lifecycle (SDLC) using Agile methodologies and other traditional methods to produce high quality software model. In Power BI using (Power Query, Power Pivot, Power BI Pro, Power BI Desktop) and working with DAX Expressions. Extensive experience in Microsoft stacks of BI solutions SSRS, SSIS and SSAS with MS SQL 2008/2008R 2/2012/2014/2016.
  • Experience in SQL Server Integration Services (SSIS) to build ETL packages right from extracting data from multiple sources like XML, OLE DB, Excel and Flat file source. Scheduled SQL Server Integration Services SSIS packages using SQL Server Agent.
  • Create dashboards by developing Drill through and Drill down reports, parameterized reports, Linked reports, Sub reports, Matrix reports, and Chart reports using MS SQL Server Reporting Services (SSRS).
  • I am a multitasker, a problem solver, consistently meets all deadlines and exceeds expectations. Highly versatile, motivated, and a team player who is passionate about providing innovative top - notch business solutions that meets the desired needs of the client. Strong analytical skills, proven ability to work well in a multi-disciplined team environment, and adept at learning new tools and processes with ease. I aspire to seek a position to utilize my skills and abilities in the organization that offers professional growth and opportunities.

PROFESSIONAL EXPERIENCE:

Confidential, Irving, TX

Power BI / SQL Server Developer

Responsibilities:

  • Working knowledge and/or experience with Power BI (Power Pivot, Power View, Power BI Online, Power BI Desktop)
  • Experience using Microsoft Power BI for the creation of dashboards, standard reports and ad-hoc reports
  • Experience with advanced Power BI topics such as complex calculations, table calculations, parameters, geographic mapping, and performance optimization
  • Experience building graphs and charts to communicate business information. SSRS and Power BI (Desktop, Service, Mobile)experience
  • Work multiple projects concurrently and shift priorities as required to meet business requirements and deadlines
  • Experience with Power BI Desktop, KPIs and DAX scripting language
  • Involved in generating and maintaining SQL scripts
  • Create various Stored Procedures to validate the data from the source and update/insert the records into target tables
  • Designed and develop Dashboards and Reports using SSRS
  • Developed various types of complex reports like Drill Down, Drill Through, Gauges, Pie Chart, Bar Chart, Sub-Reports
  • Troubleshoot slow performing queries by using SQL Profiles
  • Worked on developing Tables, Indexes, Views, Creating complex stored procedures, Triggers, Functions
  • Created SSIS Packages to perform filtering operations and to import the data on daily basis from the OLTP system to SQL server
  • Applied various data transformations like SCD (Slowly Changing Dimension) to maintain the history of the data, aggregate, multicasting, conditional split and derived column
  • Designed OLAP cubes with star schema and multiple partitions using SSAS
  • Involved in creation of fact and dimension tables in the OLAP database and created cubes using MS SQL Server Analysis Services (SSAS)

Confidential, Plano, TX

Power BI / SQL Server Developer

Responsibilities:

  • Business Intelligence experience in Power BI, Development, Client Analysis, Database Design,
  • Reporting and Presentation using SQL Server 2008R2/2012/2014, SSIS, SSAS and SSRS.
  • Developing visual reports, dashboards and KPI scorecards using Power BI desktop.
  • Connecting to data sources, importing data and transforming date for Business Intelligence.
  • Proficient in making DAX queries in Power BI desktop.
  • Database Design Development, ETL Implementation and support of OLAP/OLTP/Data warehouse systems using Microsoft SQL Server 2008/2005 across various SDLC environments.
  • Experience in MS SQL Server 2000, 2005, 2008 and 2012 with Business Intelligence in SQL Server Reporting Services and SQL Server Integration Services.
  • Experienced in creating complex SSIS and DTS packages for ETL purposes. Data Migration, Data Conversions, Data Extraction/ Transformation/Loading (ETL) using DTS and SQL Scripts. Proficient to build end to end data integration and workflow solutions from input source extraction, apply various transformations and data load.
  • Have in depth knowledge of design, development and the implementation of applications in the Business Intelligence and Client / Server technologies Strong experience in using the Microsoft Suite (Management Studio, Business Intelligence
  • Development Studio) (SQL) Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS)

Confidential, Irving, TX

Power BI / SSRS Developer / SQL Server Developer

Responsibilities:

  • Created high quality SSRS reports portraying key KPIs and business logic
  • Support the development, optimization, and enhancement of the BI Reporting Tools.
  • Support the maintenance production BI Reporting Tools.
  • Support the analysis of requirements, design specifications, development, and technical and user documentation of report development through direct interaction with internal customers.
  • Good experience in performance tuning and optimization of SSRS Reports
  • Implementation of security in SSRS report at item level and group level with SSRS roles.
  • End-to-end development experience from gather requirements to deployment of SSRS reports
  • Created SSIS packages to capture the Incremental changes for the data warehouse for report processing.
  • Reporting and Presentation using SQL Server 2008R2/2012/2014, SSIS, SSAS and SSRS.

Hire Now