We provide IT Staff Augmentation Services!

Sql/ssis/ssrs/powerbi Developer Resume

ChicagO

SUMMARY

  • Over 8+years of Experience in Microsoft SQL server and Business Intelligence Development (SSRS, SSIS, SSAS, SQL and Power BI).
  • Expertise experience in design, development and implementation of BI Solutions (ETL & Reporting & Analysis services) using SSIS, SSRS, SSAS, Microsoft SQL Server 2012/ 2008 R2/ 2008/2005, T - SQL, MDX, Power View, Power Pivot, Tableau.
  • Analyze the source map documents and creating packages to move the data from source to destination.
  • Creation of work flows with Data flow Task, Script Task, Execute Sql Task and Containers.
  • Used Transformations like Derived Column, Conditional Split, Aggregates, Sort, Data Conversion, Merge join and Union all. Did error handling while moving the data.
  • Implemented Performance Tuning at various levels.
  • Created Configurations, Checkpoints and Breakpoints in packages for better reusability.
  • Experience in Creating jobs and Scheduling SSIS Packages.
  • Extensive Knowledge on creating Dashboards by using Reports and KPI’s.
  • Created simple and complex reports by customizing look and feel by using various report models and pass the parameters according to business user’s request.
  • As per requirements developed the reports in the form of Table, Matrix and Chart using SQL Server Reporting Services.
  • Involved in Huge data migrations, transfers using utilities like Data Transformation Services (DTS), and SSIS, Bulk Copy Program (BCP) and Bulk Insert
  • Extensive experience on system analysis, design, development, testing and implementation of projects in Software Development Life Cycle (SDLC)
  • Having knowledge in creating cubes and modifying measures and attributes, creating hierarchies and relationships in dimensions.
  • Experience in working with SSAS in creating cubes, data source views, named queries, dimensions and deploying of analysis services projects
  • Excellent T- SQL programming skills in writing complex queries to create and update database objects.
  • Extensive knowledge in writing MDX query.
  • Having good experience in Indexes, Joins, Views, Stored procedures, Functions, Constraints.
  • Experience in creating PowerPivot data models and integrate them with SharePoint and automate refresh.
  • Knowledge in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
  • Robust MS Access and Excel skills with PowerPivot, PivotTable, Pivot Chart, Power View, VLookup functions and formulas.
  • Experience in working with Agile and Sprint methodologies.
  • Strong communication skills when working with stakeholders, developers, project managers, system implementers, and application end-users.
  • Ability to handle multiple tasks and responsibilities independently as well as a proactive team member.

TECHNICAL SKILLS

Relational Databases: SQL Server 2016/2014/2012/2008 R 2/2008/2005/2000 , MS Access.

Tools: and Packages: SQL Server Management studio, SSIS, SSRS, SSAS, DTS, Microsoft Visual Source Safe, SQL Query Editor, MS-Office writer, Team Foundation Server(TFS),Office Writer, Lumira, SAP Predictive Analysis

Languages: PLSQL, HTML, C#, SQL, C, VB.Net, PHP, R-Programming

Operating Systems: Windows 2010/2007/vista/XP/2003/2000/MacOS/Linux & Unix

Application Packages: MS Office, MS Outlook (Microsoft Office Suite),MS VISIO

BI Tools: SQL Server Reporting Tools (SSRS), SQL Server Integration Services(SSIS), SQL Server Analytical Services (SSAS), Power BI, Tableau

PROFESSIONAL EXPERIENCE

Confidential, Chicago

SQL/SSIS/SSRS/PowerBI Developer

Responsibilities:

  • Created dynamic and complex Power BI reports and dashboards as per the need.
  • Independently handled the project and delivered the reports before SLA
  • Designed SQL tables, views and stored procedures required for reporting.
  • Extracted data from the source and loaded into tables using SSIS.
  • Deployed the power BI reports to service, SharePoint and scheduled the automatic data refresh.
  • Implemented role level security and assigned the users as required this way we could restrict the data visibility.
  • Created drill down and drill through report to go to details and child report within power bi based on hierarchy.
  • Wrote complex DAX for calculated measures and columns.
  • Used bookmarks feature which enables the ease to jump to respective report tabs with one click.
  • Imported custom themes and page backgrounds for rich visual effects.
  • Improved the performance of the reports by pushing most of the transformations within power BI to SQL.
  • Created DAX measures to blank out visuals when no slicer is selected.
  • Performed end to end testing on the reports and packages developed to ensure data quality is met.
  • Actively participated in the weekly status meetings to get new requirements and talk on the status of current work in progress.

Environment: MS SQL Server 2012/2014, SSIS 2012/2014, SSAS, Power BI, SharePoint.

Confidential, WI

SQL /SSIS/SSAS/SSRS Developer

Responsibilities:

  • Worked as a developer and acquired excellent skill in creating complex Stored Procedures, Functions, and Triggers for automating tasks, Views and complex SQL queries for applications.
  • Managed and resolved design issues during development and production.
  • Cleansed and transferred data from various OLTP data sources, such as Oracle, MS Access, MS Excel, Flat Files, CSV files into SQL Server 2014 by using SSIS packages.
  • Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files) and then loaded the data into destination tables by performing different kinds of transformations using SSIS packages.
  • Experience with Data migration utilities (Import & Export - BCP, Bulk Insert) from flat files to SQL Server.
  • Used DAX (Data Analysis Expressions) functions for the creation of calculations and measures in the Tabular Models.
  • Extensive Knowledge in SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
  • Create Stored Procedures, User Defined Functions, Views, T-SQL scripting for complex business logic.
  • Created Roles for SSAS Tabular Model provide additional Security at the row-level by using row-level filters Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
  • Designed Perspectives and Hierarchies in SSAS Tabular model.
  • Writing T-SQL queries (DDL and DML). Creating SQL Scripts for data loads and Upgrades for data migrations and data validations.
  • Created and maintained logins, roles and permissions on the SQL instances and databases and provided required privileges according to the user's requirements.
  • Involved in development, deployment, scheduling, and troubleshooting SSIS packages.
  • Involved in complex SSIS package development with Microsoft BI standards and Development strategies to pull data from various data sources such as (SQL Server, Excel, and Flat file).
  • Worked extensively with Slowly Changing Dimension and lookup Transformation for implementing Inserts and Updates. Involved in scheduling, creating snapshots and subscriptions for the reports (SSRS 2012).
  • Involved in Report Design and Coding for Standard Tabular type reports, including Drill down and Drill through functionality and Graphical presentations such as Charts.
  • Manage change control based on customer requirements to according to project work flow.
  • Assisted in change/release management and deployed various packages in different lower environments.

Environment: MS SQL Server 2014/2012, SSRS, SSAS, SSIS, SQL Query Analyzer, SQL profiler, Enterprise Manager, Tableau, HTML, MS Access, Crystal Reports.

Confidential, Tx

SQL/SSIS/SSRS/Power Pivot Developer

Responsibilities:

  • Responsible for designing database, creating tables, stored procedures, user defined functions and implementing joins, index using T-SQL.
  • Responsible in monitoring and troubleshooting the production support and ensure that the SLA is met and no business impact.
  • Responsible in creating power pivot reports as per the business requirement
  • Designed dynamic SSIS Packages to transfer data crossing multiple platforms; validated data during transferring and archived data files for multiple DBMS.
  • Designed SSIS packages to migrate the data from SQL Server to the staging area.
  • Filtered bad data from the legacy system utilizing derived columns, lookups, fuzzy lookups, and conditional splits.
  • Incorporated error redirection during ETL loads in SSIS Packages.
  • Monitored and configured SSIS packages for dynamic execution; deployed packages to the testing environment.
  • Generated various Drill-through Reports, Parameterized Reports, Matrix and Tabular Reports.
  • Responsible for publishing and deploying the reports in Web Server and Report Server respectively.
  • Optimizing the long running reports, packages and scripts.
  • Responsible for deploying the objects (Scripts, packages, reports, web apps) into production environment on a weekly basis
  • Monitoring the log shipping, mirroring and replication jobs.
  • Responsible for handing over the support to US partners.
  • Participated in Brown Bag session for Data visualization contest.
  • Contributed in disk space clean up activity and saved 800 GB of SQL server space.

Environment: MS SQL Server 2008 R2, SSIS 2008 R2, SSRS 2008 R2, SharePoint.

Confidential, Great Neck, NJ

SQL/SSIS/SSRS/Power Pivot Developer

Responsibilities:

  • Created efficient, robust SSIS packages for data movement and loading with error checking and well documented code.
  • Created SSIS Packages to integrate data coming from Text files and Excel files.
  • Created Tables, Stored procedures and defined functions. Modified SQL scripts for tuning and scheduling.
  • Extensively used joins and common Table Expressions to simplify complex queries involving multiple tables
  • Developed complex Stored Procedures and views to generate various Drill through reports, parameterized reports and linked reports using SSRS.
  • Was responsible in redesigning existing ETL ‘s to SSIS packages
  • Took end to end ownership of migrating the SSIS, SQL objects, DB roles, SSRS and Excel Reports from 2008 R2 to SQL 2014.
  • Expert in creating Power pivots, Power views and SSRS reports using Cubes (MDX) and SQL queries.
  • Interactive data visualization products focused on business intelligence such as MICROSOFT Power BI.
  • Developed confidential proprietary analytical tools and reports with Microsoft Excel, and Power Pivot, and Power Point.
  • Experience with software development life cycle (SDLC), Agile, Scrum and Project Management Methodologies.
  • Publishing Power BI reports from Power BI Desktop to Power BI service.
  • Build Tabular, line charts, Graph charts visuals for Marketing KPI's metrics based on fields brought in and transform using Power Query functions and DAX calculated Measures.
  • Generated reports utilizing SSRS and Excel with power pivots; deployed reports within SharePoint integrated mode.
  • Created detailed dashboards utilizing Microsoft BI desktop to improve analysis and decision making with various sources Azure, Sql server, Excels.
  • Managed reports/data sources, schedule report execution, and delivery.
  • Managed team foundation server utilizing source control, check-in, and check-out.
  • Captured the long running jobs and worked on fine tuning the store procedures and tables to improve the performance.

Environment: MS SQL Server 2008 R2/2014, SSIS 2008 R2/2012, SSRS 2008 R2/2012, Power BI, Redgate, Team Foundation Server

Confidential, Boston, MA

SQL/SSIS/SSRS Developer

Responsibilities:

  • Requirement gathering & analysis in Claims, Provider and Medical Management area while interacting with OSCs/Clients
  • Responsible for review of the deliverable from offshore Claims, Provider and Medical Management area.
  • Assist team to understand domain specific requirement in Claims, Provider and Medical Management area.
  • Involved in Design and Development of SSIS Packages using various Control Flow and Data Flow items to Extract, Transform and Load the Data using SQL Server Integration Services (SSIS).
  • Experienced in configuring with Error logging and Event handling to redirect error rows and fix the errors in SSIS Testing - unit testing & integration testing.
  • Worked on HugeData Transfersfrom & to SQL Server Databases using utilities / tools likeDTS, SSIS, BULK INSERTetc and used configuration files and variables for production deployment.
  • Generated multiple Enterprise reports using SSRS from SQL Server Database (OLTP) and included various reporting features such asgroup by, drilldowns, drillthrough, sub-reports, navigation reports (Hyperlink)etc.
  • Created differentParameterized Reports(SSRS 2005) which consist of report Criteria in various reports to make minimize the report execution time and to limit the no of records required.
  • Report parameters includedsingle valued parameters,multi-value parameterswhich also consisted of different parameter types.
  • Worked on all types of report types liketables, matrix, charts, sub reportsetc.
  • Followed sprint methodology for the development activities with daily scrum calls and bi -weekly deployment schedule to ensure the everything was moving to production as per the timelines
  • Scheduled reports to refresh and run on daily, weekly and monthly basis in the report manager.

Environment: MS SQL Server 2008 R2, SSIS 2008 R2, SSRS 2008 R2, Crystal Reports.

Confidential

SQL/SSAS/SSRS Developer

Responsibilities:

  • Responsible for designing database, creating tables, stored procedures, user defined functions and implementing joins, index using T-SQL.
  • Responsible in designing the database from OLTP to OLAP.
  • Responsible in integrating the data from different sources through packages using SSIS, analyzing the data and creating cubes using SSAS.
  • Responsible for designing reports using SSAS cube as a data source in SSRS.
  • Generated various Drill-through Reports, Parameterized Reports, Matrix and Tabular Reports.
  • Responsible for publishing and deploying the reports in Web Server and Report Server respectively.
  • Involved in integrating the modules of the application.

Environment: MS SQL SERVER 2005, SSRS 2005, SSAS 2005.

Hire Now