We provide IT Staff Augmentation Services!

Ssis, Ssrs, Power Bi, Sql Developer Resume

3.00/5 (Submit Your Rating)

CA

SUMMARY

  • Around 4 years of experience in completeMSBI Stackincluding data analysis, database design, data mapping and conversion and data load withSSIS, SSAS and SSRS.
  • More than 2 years of experience in Microsoft Power BI, Power Query, DAX and Power Pivot
  • Experienced in full life cycle ETL development using SSIS.
  • Extensive experience in creating many complex SSIS packages using SQL Server Integration Services 2014/2012/2008 R2.
  • Hands on experience in installing, configuring, managing, upgrading, and migrating, monitoring, and troubleshooting SQL Server 2014/2012/2008 R2.
  • Thorough knowledge of database management concepts like conceptual, logical and physical data modeling and data.
  • Experienced in Power BI Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports.
  • Experience in Extraction and Migration of Data from heterogeneous data sources like flat files, CSV, Excel, MS Access, Oracle, XML & MS SQL Server using SSIS.
  • Experienced in Microsoft Power BI to extract data from external sources and modify data to certain format as required in Excel, and created SSIS packages to load excel data in to database.
  • Experience in creating Data Driven, Drill Through, Drill Down, Tabular, Matrix reports & created charts, graphs using SQL Server Reporting Services 2014/2012/2008 R2.
  • Tuned and optimized queries by altering database design, analyzing different query options and indexing strategies.
  • Well experienced in Published reports and dashboards using Power BI.
  • Created reports in Power BI by importing data, shaped and transformed data for business intelligence (BI), Visualize data, author reports, scheduled automated refresh of reports and created and share dashboards based on reports in Power BI desktop. well experienced working with very large databases and Performance tuning.
  • Experience in Designing reports using Report Designer, Report Builder3.1, Report Manager, creating parameterized reports & managing subscriptions.
  • Worked on Report Manager to subscribe reports, Assign roles, user access with respect to security.
  • Experienced in working in Agile and Scrum Methodology environment.
  • In - depth understanding of all stages of software development life cycle (SDLC).
  • Good knowledge and experience in Data Warehouse design (Kimball Group) of Dimensional Modeling, ETL Design and Dimensional and Facts Maintenance.
  • Experienced in well document the requirements and well known of the change control process.

TECHNICAL SKILLS

OLAP/Reporting Tools: SSRS, SSAS, MDX, Power BI

Relational Databases: SQL Server database 2014/2012/2008 R2, Oracle 11g, SQL Server Azure, MS Access

SQL Server Tools: Microsoft Visual Studio 2010/2013/2015 , SQL server management studio

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

Other Tools: MS Office 2003/2007/2010 and 2013, Power pivot, Power Builder

C, SQL, PL/SQL, T: SQL, JAVA, Batch scripting, R, Python

Data Warehousing & BI: Star Schema, Snowflake schema, Facts and Dimensions tables

Operating Systems: Windows XP/Vista/7/8 and 10; Windows 2003/2008R2/2012 Servers

PROFESSIONAL EXPERIENCE

Confidential, CA

SSIS, SSRS, POWER BI, SQL DEVELOPER

Responsibilities:

  • Involved in requirements gathering, analysis, design, development, change management, deployment.
  • Designed, developed and deployed Business Intelligence solutions using SSRS
  • Created Dax Queries to generated computed columns in Power BI.
  • Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports
  • Developed ETL packages in SSIS and pulling data from different data warehouse databases like Oracle, DB2
  • Developed SSIS packages bringing data from diverse sources such as Excel, SQL server, flat files, Oracle DB for the daily load to create and maintain a centralized data warehouse.
  • Designed and configured SSIS packages to migrate the data from Oracle, legacy System using various transformations.
  • Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients and mobile apps
  • Used Power BI Gateways to keep the dashboards and reports up to date and Installed and Configured Enterprise Gateway and Personal Gateway in Power Bi Services.
  • Scheduled and monitored the SQL Server Agent jobs to run the SSIS packages and stored procedures
  • Analyzed and troubleshoot performance tuning SQL and complex SSIS packages.
  • Designed and deployed reports with Drill Down, Drill Through and Drop-down menu option and Parameterized and Linked reports.
  • Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including status.
  • Created standard report Subscriptions and Data Driven Report Subscriptions.

Environment: SQL Server 2014/2012, MS Office, DAX, SSIS, SSAS, SSRS, SharePoint, Power pivot, Power view, Power BI

Confidential, Dayton,OH

BI Developer

Responsibilities:

  • Created Power BI Dashboards with Tiles and Pins from Reports, Insights and Workbooks
  • Created new reports from Datasets using Power BI Cloud Worked with Edit Interactions
  • Developed SSIS package for transferring the data between MS Excel, Flat Files and SQL Server.
  • Working with Microsoft R Visuals for Data Automation and Forecasts and Running R Scripts
  • Worked with Power BI Report Publish options from Power BI Desktop.
  • Worked on various Power BI Visuals and Visual Properties including Tree Map, Pie Chart, Funnel, Scatter Bar Chart and Column Charts
  • Experience in Error Handling using global variables and logging of the errors into database
  • Created various Tables, Views and Indexes.
  • Created highly complex SSIS packages using various Data transformations like conditional splitting, Fuzzy Lookup, Multi Cast, column conversion, Fuzzy Grouping, Script Components.
  • Wrote complex Stored Procedure, Queries, Triggers, Functions, User-defined functions and Cursors for application.
  • Used SQL Profiler to trace out problems in slower execution plans.
  • Administered Reporting Services by securing Report Server Content by defining roles, role assignments & assigning item level, system level security.
  • Created Filtered reports using report parameters, stored procedures & cascading parameters.
  • Created several report subscriptions to deliver reports to the end users via email.

Environment: SQL Server 2012/2014, Microsoft Visual Studio 2015, MS Office, DAX, SSIS, SSAS, SSRS, SharePoint, Power pivot, Power view, Power BI, Azure SQL

Confidential

SQL Server Developer

Responsibilities:

  • Installation of SQL Server on Development and Production Servers, setting up databases, users, roles and permissions.
  • Responsible for all technical SQL Server database operations, Administration, ongoing development for various in-house databases.
  • Created Indexes to get the high-level performance.
  • Performing the ETL operations to support the data loads and transformations using SSIS.
  • Involved in migration from Oracle to SQL Server 2005 using SSIS.
  • Generation of reports from the cubes by connecting to Analysis server from SSRS.
  • Used SQL Profiler for troubleshooting, Monitoring, Optimizing SQL Server and T-SQL statements from developers and testers.
  • Maintained databases, performed software installations and upgrades, monitored Database Performance.
  • Implemented automated backup and database maintenance / cleanup jobs.
  • Managing Logins, Users, Roles and User permissions.
  • Running Trace from the Profiler to trouble shoot database and running DBCC consistency checks for other database maintenance aspects.
  • Designed numerous ad-hoc and custom reports using SQL Reporting Services.
  • Created various Tabular and Matrix Reports using SSRS.
  • Created and scheduled jobs for various tasks and also was responsible for maintaining jobs.

We'd love your feedback!