We provide IT Staff Augmentation Services!

Msbi/power Bi Developer Resume

Frisco, TX

PROFESSIONAL SUMMARY:

  • Around 9+ years of IT experience in Data Analysis, Design, Implementation, Administration, and support of Business Intelligence using SQL Server SSIS, SSAS, and SSRS.
  • Strong technical knowledge in MS SQL Server development and experience Microsoft BI Tools.
  • Strong working experience on SQL 2000/2005/2008 R2/2012/2014 including DTS, Performance tuning, Reporting, designing logical/physical databases and Troubleshooting.
  • Experienced in SQL Server 2005/2008/2012/2014 RDBMS database development including T - SQL programming.
  • Experience in SQL Server 2008 OLAP database development including KPIs, Data mining, working with changing dimensions.
  • Solid knowledge of Power BI Desktop & report performance optimization.
  • Very Good Understanding and Experience in SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS).
  • Experience in developing reports on SSRS on SQL Server (2005/2008/2008 R2/2012/2014). Sound Experience and understanding of SSIS & DWH Architecture.
  • Experience in ETL implementation using SQL Server Integration Services (SSIS) in OLTP and Data Warehouse Environment.
  • Knowledge and understanding of SSAS, OLAP and OLTP cube.
  • Good experience in writing complex queries , stored procedures , user defined functions , indexed views , CTE’S (common table expressions) and Triggers using SQL Programming
  • Experience in creating complex DTS Packages in SSIS for Data Migration from Oracle/Access/Excel Sheets to SQL Server 2005/2008/2012/2014 and Transformation.
  • Experience in Designing Dimensions, Data Aggregation and Storage design of Cubes, measures with Star schema and Snow-flake schemas.
  • Expert in performing ETL operations using various tools such as SQL Server Integration Services (SSIS), DTS, Bulk Insert and BCP.
  • Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services.
  • Expert in designing complex reports like reports using Cascading parameters, Parameterized Reports and Report Models and ad-hoc reports, Crystal Reports using SSRS.
  • Experience in defining Queries for generating drill down and drill through reports in SSRS 2008.
  • Developed and maintained multiplee Power BI dashboards/reports and content pack.
  • Responsible for buildingg Power BI Dashboards using Tabular and Multi-Dimensional Models. Design and model data sets with Power BI desktop based on measure and dimension requested by customer and dashboard needs.
  • Created Power BI Visualizations and Dashboards as per the requirements.
  • Experience in Installing, Configuring, Managing and troubleshooting SQL Server 2008/2008 R 2/2005/2000/2012/2014.
  • Able to work with a team or individually with excellent communication skills, and ability to meet deadlines in a fast-paced work environment.

TECHNICAL SKILLS:

SQL Server Tools: SSMS,BIDS, Enterprise Manager, DTS, Profiler, DTA, Upgrade Advisor

ETL & Reporting Tools: SSIS, SSRS, SSAS, BIDS, DTS, Micro strategy 9.3 software, Tableau, Power BI

Databases: SQL Server 2000/20 R2/2012/2014, MS Access, Oracle, Facets

SQL,T: SQL,PL/SQL,VB

Operating System: Windows Server 2000/2003, 2008, 2008 R2, Windows NT 4.0 Windows XP/98/95, MS DOS, Linux.

Scripting: HTML, XML, VBScript, JavaScript,ASP,C#,ASP.NET,VB.NET

Tools: Visual Studio 2005/2008/2010/2012/2014 and Report Builder 1.0/2.0/ 3.0

PROFESSIONAL EXPERIENCE:

Confidential, Frisco, TX

MSBI/Power BI Developer

Responsibilities:

  • Extensively involved in designing the SSRS reports and SSIS packages to export data of flat file source to SQL Server database.
  • Involved in creating SSIS jobs to automate the reports generation, cube refresh packages.
  • Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
  • Extract Transform Load (ETL) development using SQL Server 2008 Integration Services (SSIS).
  • Implemented advanced features in SSAS including translation, role based security, custom actions, SSRS actions & partitions
  • Designed and developed matrix and tabular reports with drill down, drill through and drop down menu and used gauge reports with KPI’s in SSRS.
  • Generated and consolidated monthly reports and budget analysis to drive forecast production plan with SQL report service (SSRS).
  • Designed Dimensional Modeling using SSAS cubes for End-User.
  • Migrated and translate legacy reports into Power BI from SSRS environment.
  • Extract dataset from different data source including SQL Server, excel and flat file prepare datasets for Power BI
  • Involved in writing SQL joins, sub queries, tracing and performance tuning for better running of queries.
  • Pulling the data from T-SQL stored procedure to make the parameterized report.
  • Created multiple data visualization solution for initiall Power BI environment business preview.
  • Involved in creating multiple parameterized stored procedures which were used by the reports to get the data.
  • Created complex Stored Procedures, Triggers, Cursors, Tables, Indexes, Views and SQL Joins and other statements for various applications, maintained referential integrity and implemented complex business logic.
  • Used DTS/SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts and performed action in XML.
  • Performed most of the SQL Server Enterprise Manager and Management Studio functionality using T-SQL Scripts and Batches.
  • Created different schedules for report delivery to e-mails and shared directories; enabled snapshots, subscriptions, caching to improve the response times and reduce traffic to the report server.
  • Designed and Implemented various reports using Crystal Reports and responsible for the migration to SSRS.
  • Experience in creating complex DTS Packages in SSIS for Data Migration from Oracle/Access/Excel Sheets to SQL Server 2005/2008/2012 and Transformation.

Environment: SQL Server 2008/2005 Enterprise Edition, SQL BI Suite (SSAS, SSIS, SSRS), Power BI, VB Script, Enterprise manager, XML, MS PowerPoint, OLAP, OLTP, MDX, Erwin, MOSS 2007, MS Project, MS Access 2008 & Windows Server 2008, Oracle.

Confidential, Dallas, TX

SQL/BI Developer

Responsibilities:

  • Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
  • Transferred data from various OLTP data sources, such as Oracle, MS Access, MS Excel, Flat files, CSV files into SQL Server 2005.
  • Good understanding of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Star Schema Modeling, Snow-Flake Modeling.
  • Responsible for identify and translate business requirements for the Enterprise Data Warehouse into logical and physical data models.
  • Responsible for building Power BI Dashboards using Tabular Model. Design and model data set with Power BI desktop based on measure and dimension requested by customer and dashboard needs.
  • Performed the Power BI report validation against the databases.
  • Involved in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS), DTS, Bulk Insert and BCP.
  • Involved in migration of SQL Server /2012.
  • Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
  • Created tables, matrix, and chart reports as required and deploy those reports into Power BI service.
  • Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups using SSIS tasks.
  • Designed and developed matrix and tabular reports with drill down, drill through and drop down menu and used gauge reports with KPI’s in SSRS.
  • Generated and consolidated monthly reports and budget analysis to drive forecast production plan with SQL report service (SSRS).
  • Designed and build the OLAP cubes using Star schema and Snow Flake Schema using native OLAP Service Manager.
  • Performed maintenance duties like performance tuning and optimization of queries, functions and stored procedures.

Environment: SQL Server 2005/2008 R2/2012, T-SQL, PL/SQL, SQL Profiler, Report Builder, SSIS, SSRS, Power BI, MDX, ASP.NET, C#, Agile, Visual Studio 2005/2008, XML, Crystal Reports, ER-Win, MS Visio.

Confidential, Detroit, MI

SQL/BI Developer/Data Analyst

Responsibilities:

  • Designing logical and physical database structure to facilitate analysis of data from both operational and customer perspectives.
  • Developed highly scalable report automation system utilizing SSIS, T/SQL, stored procedure, cursor, Enterprise Manager, Query Analyzer.
  • Investigated various platform, languages, and database designing tools and suggested the best solution to upper management considering reusability, scalability and maintainability. Using SQL Profiler to estimate the Slow Running queries and performance tuning purpose.
  • Designed SSIS packages to extract, transform and load data to SQL tables from txt and csv file received from various clients.
  • Used to develop the reports by using SSRS and Power Pivot.
  • Developed several scripts to synchronize stored procedures, SSIS to log messages and outputs.
  • Created SSIS tasks to email output and log messages using ActiveX script.
  • Created SQL objects like Tables, Stored Procedures, Functions, and User Defined Data-Types.
  • Created standard tables and mapped columns from various client tables.
  • Designed a master SSIS to execute all synchronized stored procedures, other SSIS.
  • Gathered various business logics and developed numerous reusable stored procedures compatible for all clients.
  • Created SSIS packages to integrated window application to DTS and set control file path and timeout value
  • Generated Tabular reports, Cross Tabs, Drill down, Drill Through, Cascading and Parameterized Cascading Reports, Sub Reports, Summary Reports, Charts, Functions and Maps using SSRS, Tableau reports.
  • Created SSIS package to re-import data to SQL table from output file and mapped column appropriately.
  • Analyzed output files, applied necessary business logics and created stored procedures accordingly.
  • Develop script to set parameters for various clients and schedule SSIS appropriately.
  • Participated in data mining and validation process.
  • Effectively hosted several web meeting and showed many design and code review demonstrations.
  • Completed many Unit and Integration, functional and acceptance testing.

Environment: SQL Server 2005/2008 R2/2012, Query Analyzer, T-SQL, PL/SQL, SQL Profiler, Report Builder, SSIS, SSRS, SSAS, MDX, ASP.NET, C#.NET, Agile, Visual Studio 2005/2008, XML, Crystal Reports, ER-Win, Enterprise Manager, Visual Source Safe, Excel, SharePoint, Unix ODBC, MS Visio 2008.

Confidential

SQL Server Developer/DBA

Responsibilities:

  • Involved in designing of Conceptual Logical Model and Physical Model.
  • Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server.
  • Maintained security by creating users and giving appropriate permissions to users.
  • Scheduled the backups for Databases and Transaction log. Performed restoration operations. Suggested backup strategies.
  • Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
  • Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and maintaining logs.
  • Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications following SQL coding standards.
  • Developed SQL Server Stored Procedures, Tuned SQL Queries (using Indexes and Execution Plan)
  • Developed User Defined Functions and created Views.
  • Created Triggers to maintain the Referential Integrity.
  • Prepared detailed statistical reports in MS Access and MS Excel to track progress of weekly, monthly and quarterly customers and sales growth.
  • Utilized SSIS to develop ETL mechanisms to populate the data from multiple sources including event management, ERP/MRP and discovery components
  • Involved in performance tuning and monitoring of both T-SQL and PL/SQL blocks.
  • Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures.
  • Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs.
  • Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data.
  • Involved in performance tuning using indexing (Cluster Index, Non Cluster index) tables.
  • Responsible for Cleansing up database for Maintenance of the database.
  • Responsible for unit testing, writing design documents and uploading it to share point server.

Environment: SQL Server 2008 R2, C#, SSIS and SSRS, MS Visual Studio, Windows 2007 Server, BI Development Studio, MS Excel.

Confidential

SQL Server Developer

Responsibilities:

  • Installed and configured MS SQL Server and Applied service packs and hot fix.
  • Logically and physically designed database for projects on basis of user requirements using ERWIN.
  • Created complex Stored Procedures.
  • Used Query Analyzer to optimize SQL Queries.
  • Wrote various Stored Procedures for the purpose of application development
  • Converted various SQL statements into Stored Procedures thereby reducing the Number of database accesses.
  • Ensured constraints and writing triggers to apply the business rules. Performance Tuning, Backing Up & Restoring User Databases.
  • Successfully loaded data from an EXCEL, Access into a SQL Server database Table.
  • Distributed Partitioned Views, Debugging / Troubleshooting Stored Procedures, upgrading existing ones
  • Worked closely with the team in meeting the deadlines pertaining to design and development deliverables.
  • Scheduled Backups and performed Restore operations for system test data.

Environment: MS SQL Server 2012, T-SQL, Enterprise Mana ger, Windows Server, MS Office, Erwin.

Hire Now