We provide IT Staff Augmentation Services!

Sql Bi Developer/ssis/ssrs/ssas/power Bi Resume

Richardson, TX

SUMMARY:

  • Over 8 Years of experience in Business Intelligence lifecycle projects from requirement gathering, documentation, data analysis, modeling, development, testing, production, deployment and support.
  • Involved in all the stages of Software Development Life Cycle including Requirements.
  • Hands on experience in installing, configuring, managing, monitoring SQL Server.
  • Experienced in TSQL (DDL, DML), documenting, coding, programming, modifying and implementing Business Intelligence solutions using SQL Server 2016/ 2014/2012/2008 .
  • Experienced in relational database design, SQL queries, stored procedures, Functions, Triggers, User Defined Functions, clustered and non - clustered indexes, views, joins and Nested queries.
  • Experience in using recursive CTEs, CTE, temp tables, Views, Table Variables and effective DDL/DML Triggers to facilitate efficient data manipulation and data consistency as well as to support the existing application.
  • Involved in Normalization and De - Normalization of existing tables for faster query retrieval / query optimization.
  • Extensive­­ experience in designing, developing, and delivering business intelligence solutions using SQL Server Integration Services ( SSIS ), SQL Server Reporting Services ( SSRS ), SQL Server Analysis Services (SSAS), and Power BI.
  • Wide experience in creating OLAP cubes, identifying dimensions, attributes, hierarchies, calculating measures and dimension members in SQL Server Analysis Services (SSAS) .
  • Experience in creating and configuring Data source and Data source views, Dimensions, Measures, Cubes using SQL Server Analysis Services (SSAS).
  • Created SSIS packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables.
  • Experience in creating and deploying SSIS (ETL process) packages using various Transformations such as Slowly Changing Dimension, Multicast, Merge Join, Lookup, Fuzzy Lookup, Conditional Split, Aggregate, Derived Column, and Data Conversion Transformations.
  • Expert in using the workflow canvas for multiple transformations of data and the use of different features like variables, package configurations, event handlers, error logging and checkpoints to facilitate various complex ETL logics and specifications.
  • Excellent knowledge and experience of creating Jobs, Alerts, SQL Mail Agent, using various Control flow items ( such as Execute package task, Execute Process Task, Script Task, FTP Task, Send Email Task, For Loop Container, for each Loop Container etc .)
  • Designing dashboards with the use of visualization tools like Tableau.
  • Experience in Converting DTS packages into SSIS packages.
  • Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
  • Experienced in Tableau Desktop/Server, creating highly interactive Data Visualization Reports and Dashboards using features such as Data Blending, Calculations, Filters, Actions, Parameters, Context Filters, Sets, groups etc.
  • Experienced in writing Parameterized Queries for generating Tabular reports and Sub reports using Global variables, Expressions, and Functions, Sorting the data, Defining Data sources and Sub totals for the reports using SSRS.
  • Proficient in creating Ad-hoc reports, Scheduled reports, defining query for generating drilldown, drill through reports, MATRIX, tabular reports for different business domains depending on the specifications and requests.
  • Experienced in connecting multiple data sources in Power BI to implement working reports.
  • Having knowledge on maintaining and managing Tableau and Power BI driven reports and dashboards.
  • Used Power BI Power Pivot to develop data analysis prototype and used Power View and Power Map to visualize reports.
  • Experienced in usingTFS (Team foundation server) for deployments of database changes, SSIS packages & SSRS reports.
  • Used Visual Team Foundation server for version control, source control and reporting.
  • Scheduled reports for Daily, Weekly, Monthly reports on sales and marketing information for various categories and regions based on business needs using Reporting services (SSRS).
  • Strong debugging skills and the ability to solve complex problems.
  • Good team player with strong analytical skills.
  • Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team

TECHNICAL SKILLS:

Programming Languages: T-SQL, PL/SQL, C, C++, Objective-C, HTML, C#, ASP.Net

Databases: Microsoft SQL Server 2016/2 R2/2008, MS Access, TFS, Oracle, T-SQL, PL/SQL

Reporting Tools: SQL Server Reporting Service (SSRS), Power BI, Tableau

ETL Tools: MS SQL Server Integration Services (SSIS), Data Transformation Services (DTS) and T-SQL Stored Procedures

Database Tools: SQL Query Analyzer, SQL Enterprise Manager, Microsoft SQL Server Management Studio, Visual Studio, Analysis Manager, Reporting Server, Power BI, TFS, Git, JIRA, Tableau

Office Tools: MS Word, Power Point, Visio and MS Excel

PROFESSIONAL EXPERIENCE:

Confidential, Richardson, TX

SQL BI Developer/SSIS/SSRS/SSAS/Power BI

Responsibilities:

  • Created Store Procedures, Tables, Views, cursors and optimizing queries by using execution plan for tuning the database. Implemented different types of constraints on tables.
  • Creating tables, indexes and designing constraints.
  • Creating triggers, stored procedures, Views, Query writing.
  • Configured SSIS Packages using Environment Variables for Dynamic selection of Development and Production Environment.
  • Part of Relational Data Warehouse Designs and effectively identified and created Facts and Dimensions tables.
  • Creating Indexes and used Scan and Seeks for performance tuning. Strong SQL Server Developer skills including writing triggers, Stored procedures, Views, Query writing.
  • Developed and deployed SSIS packages in Production Server.
  • Managed the entire ETL process involving the access, manipulation, analysis, interpretation and presentation of information from both internal and secondary data sources to end users.
  • Created SQL SSIS and SSRS infrastructure that pulls data from data sources and provides a sample to use reporting environment.
  • EDI 820 testing for APTC/ CSR payments from federal exchange (FFM).
  • Medical Claims experience in process documentation, analysis and implementation in 835/837/834/270/271/277/997 (X12 Standards) processes of Medical Claims Industry from the Provider/Payer side, Medicaid, & Medicare, Managed and maintained HEDIS files and records
  • Knowledge in the Data Analysis, Design, Development, Implementation and Testing of reports generated in Web Focus.
  • Good experience in front end development using oracle forms/reports6i/9i/10g.
  • Proficient in PL/SQL programming - Stored Procedures, Functions, Packages, SQL tuning, and creation of Oracle Objects - Tables, Views, Materialized Views, Triggers, Sequences, Synonyms, Database Links, and User Defined Data Types.
  • Experienced in Dynamic SQL, PL/SQL Collections and Exception handling.
  • For new insurance carrier onboarding’s, create the test suite of sample EDI 834 enrolment files to cover different policy tiers, maintenance files for change transactions.
  • Expertise in creating Reports, Sub Reports, drill down reports using various features like Charts, filters etc.
  • Created report models for ad-hoc reports using SSRS 2016 with Excellent Power BI skills, Experience in creating solutions for mid-large sized companies with Advanced SQL server relational database and development experience, as well as in Microsoft technologies SSIS, SSRS, SQL server, Power Pivot, Power View, and related technologies.
  • Setup and testing of EDI system for multiple enterprises as per the company standards and requirement of the enterprise
  • Designed a detail test plan for testing the entire EDI data flow for both inbound and outbound flows, sent/received data, performed translation and verification of loops and data.
  • Designed and created Report templates, bar graphs, pie charts based on the financial data.
  • Experience in Designing, Creating, Deploying and Processing of Cubes using SSAS.
  • Hands-on experience Relational Database Modeling and Dimensional Modeling in combination with SSAS to develop OLAP cubes having Star/Snowflake schemas.
  • Good experience in front end development using oracle forms/reports6i/9i/10g.
  • Proficient in PL/SQL programming - Stored Procedures, Functions, Packages, SQL tuning, and creation of Oracle Objects - Tables, Views, Materialized Views, Triggers, Sequences, Synonyms, Database Links, and User Defined Data Types.
  • Expertise in using Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.
  • Strong ability in defining query for generating drill through, drill down reports, canned and cache reports with drop down menu option, sorting the data, defining subtotals and handling parameterized reports and creating report layouts using SSRS 2016.
  • Experience in developing Custom Reports and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).

Environment: MS SQL Server 2016/2014/2012 , PL/SQL, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Business Intelligence Development Studio (BIDS), SVN (source control), Tableau, Power BI, MS Visual Studio.NET, C #, TFS (SharePoint), Visual Studio 14.0, VB Script and Windows 2012 Server, Query Analyzer.

Confidential , PA

(SQL Server Developer (SSIS/SSRS/SSAS), Tableau)

Responsibilities:

  • Performed Server installation and configuration using SQL Server 2012.
  • Design, Implement and maintain Database Schema, Entity relationship diagrams, Data modeling, Tables, Storedprocedures, Functions and Triggers, Constraints, Indexes, Functions, Views, Rules, Defaults and complex SQL statements.
  • Developed reports, dashboards, and SQL queries using Tableau. Worked on gathering data requirements from different sources and data cleansing.
  • Prepared Tableau reports in various subject areas like Materials Procurement Savings, Bill of Materials, Customer Service Index, Employee Productivity and Employee Safety.
  • Built Complex Reports using advanced reporting functions like with YTD calculations, MTD calculations, percentage differences, sets and groups etc. in Tableau.
  • Maintained the database schema in source code control (MS Team Suite Database Edition preferred).
  • Involved in XML Development and XML File Parsing in SSIS and SSRS.
  • Developed the SQL programs and Involved in optimize stored procedures and queries for faster retrieval and Server efficiency SSIS.
  • Involved in Development and deployment of SSAS cubes and monitor full and incremental loads and support on any issues.
  • Provided operational support to modify existing tabular SSAS models to satisfy new requirements.
  • Used Quality center (Defect tracking tool) for Bug fixing and resolution details.
  • Involved in mock testing and Unit Testing and Integration testing in SSIS.
  • Created automated stored procedures for day end operations using SQL Server agent.
  • Coordinated with front-end for implementing logic in stored procedures and functions.
  • Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard in SSIS.
  • Used multiple transformations in SSIS to meet the business requirements by extracting data from heterogeneous source systems, transform and finally load into the Staging Data base.
  • Extensively worked in ETL and data integration in developing ETL mappings and scripts using SSIS, Worked on Data transfer from a Text file to SQL Server by using bulk insert task in SSIS.
  • Involved in SSIS ETL Transformation for de-normalization of data sources using UNPIVOT and UNION.
  • Created Packages that Transfers Databases from One SQL Server instance to Another Instance and Scheduled the SSIS package for migration of data from old system to MS SQL 2012.
  • Using SSIS, loaded XML data to the Database tables and Extracting Data using SSIS into Excel Files for Marketing purpose.
  • Worked in importing and cleansing of data from various sources like DB2, Oracle, flat files.
  • Worked in Enterprise Manager for job scheduling and batch queries.
  • Monitored performance and optimized SQL queries for maximum efficiency.
  • Implemented fine tuning of database objects and server to ensure efficient data retrieval.
  • Managed and monitored the use of disk space.
  • Planned Backup strategy based on projects requirements.
  • Maintained the consistency of the client’s Database using DBCC.
  • Responsible for testing to optimize the procedures and triggers to be used in production.
  • Involved in project planning also schedule for database module with project managers.

Environment: SQL Server 2012, SSIS, SSAS, SSRS, Erwin, .Net Frame Work, XML, MS Access, Excel, C#, ASP .Net, Crystal Reports, ER Studio, Performance point Server.

Confidential, Pasadena, CA

Sr. SQL SERVER BI/SSIS/SSRS/SSAS/Power BI

Responsibilities:

  • Involved in gathering Business Requirement after interacting with the Manager and development team to build up a solution to implement in SQL Server 2016.
  • Filtered and cleansed dirty data from legacy system using complex T- SQL statements in staging area and implemented various constraints and triggers for data consistency.
  • Migrated data from Heterogeneous Data Sources and legacy system (DB2, Access, and Excel) to centralized SQL Server databases using SQL Server Integration Services (SSIS) to overcome transformation constraints.
  • Developed DTSX packages to extract, transform and load into the Campaign database from OLTP database using of SQL Server Integration Services (SSIS).
  • Worked with various SSIS control flow tasks and data transformation tasks like Data conversion, Derived Column, Look-up, Fuzzy Look-up, script task, etc. as part of ETL.
  • Involved in performing incremental loads while transferring data from OLTP to data warehouse using different data flow and control flow tasks in Business intelligence studios using SSIS.
  • Debugged SSIS Packages using Data Viewers, Breakpoints. Used various transformations like Derived column, Pivot, Un-pivot, copy column, merge join, union all, Lookup, audit, aggregate etc.
  • Successfully migrated old data from legacy systems and external system including excel and oracle into SQL Server 2016 using SSIS Packages.
  • Created OLAP cubes and dimensions for the analysis of data at various paths and locations using SSAS
  • Used SSAS features to build and configure Hierarchical dimensions, measure groups, created calculated measures, KPI, configured partitions, aggregations and actions.
  • Created scripts to verify and reconcile the migrated data from legacy system to SQL Server.
  • Developed complex Stored Procedures to process prospective customer information and balanced the processing load between frontend and backend.
  • Designed forms, templates & created Reports using SSRS reporting services.
  • Designed and developed multiple reports such as Ad-hoc, Drill Down, Drill Through, Sub-Reports, Linked Reports, including stylish Graphs and Charts.
  • Created Matrix reports for the management to have high level of knowledge on different categories in any specific period.
  • Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel formats using SSRS.
  • Created Data Connections, published on Tableau Server for usage with Operational/Monitoring Dashboards.
  • Administered user, user groups, and scheduled instances for reports in Tableau.
  • Visualized data, author reports, schedule automated refresh of reports and create and share dashboards based on reports in Power BI desktop.
  • Used Microsoft Power BI Power Query to extract data from external sources and modify data to certain format as required in Excel and created SSIS packages to load excel sheets from PC to database. Experienced in Data visualization and Data analyzation using Power BI.
  • Created Relationships, actions, data blending, filters, parameters, hierarchies, calculated fields, sorting, groupings, live connections, and in-memory in both Tableau and excel .
  • Installed On premise data gateway and scheduled daily data refresh in Power BI.
  • Created Calculated Columns and Measures in Power BI and Excel depending on the requirement using DAX queries.
  • Wrote Calculated Columns, DAX Measures, and Queries in Power BI desktop to show good data analysis techniques.
  • Used TFS (Team foundation server) for deployments of database changes, SSIS packages & SSRS reports.
  • Responsible for developing processes, automation of maintenance jobs, tuning SQL Server, locks and indexes configurations, administering SQL Server security, SQL Server automatic e-mail notification and SQL Server backup strategy and automation.
  • Created Store Procedures, Tables, Views, cursors and optimizing queries by using execution plan for tuning the database. Implemented different types of constraints on tables.
  • Performed Unit testing for the screens and code in SQL Server 2016.

Environment: MS SQL Server 2016/2014/2012 , PL/SQL, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Business Intelligence Development Studio (BIDS), SVN (source control), Tableau, Power BI, MS Visual Studio.NET, C #, TFS (SharePoint), Visual Studio 14.0, VB Script and Windows 2012 Server, Query Analyzer.

Confidential, Houston, Texas

(SQL Server Developer (SSIS/SSRS/SSAS))

Responsibilities:

  • Used NT Performance monitor to monitor CPU & Memory usage and SQL Server Profiler to monitor and record database activities of particular users, applications.
  • Responsible for creating Databases, Tables, Clustered/Non-Clustered Indexes, Unique/Check Constraints, Views, Stored Procedures & Triggers.
  • Monitor SQL Error Logs/Schedule Tasks/database activity/eliminate Blocking & deadlocks user counts and connections/locks etc.
  • Scheduling Jobs and Alerting using SQL Server Agent.
  • Developed packages using SSIS and controlled its execution, by implementing the infrastructure that enables execution order, logging, variables, and event handling.
  • Created ETL for data Transfer and Migration.
  • Developed custom reports using SSRS/SQL Server BI Studio.
  • Created Stepped and Blocked reports using SSRS.
  • Created Drill Through and Various Cross tabbed reports using SSRS.
  • Build the cubes using SSAS.
  • Developed a SOA based Stock Brokerage System using Web Services.
  • Login and User Management: Adding logins, roles, groups to the Window NT and MS SQL Server and maintaining proper security procedures.

Environment: SQL Server 2012 Enterprise Edition, SSIS, SSAS, SSRS, C#, T-SQL, VisualStudio.net, XML, MS Excel, MS Access, Visual Studio.

Confidential

SQL Server Developer/BI Developer

Responsibilities:

  • Involved in gathering, analyzing and documenting business requirements and functional requirements and data specifications from users and transformed them in to technical specifications.
  • Involved in Planning, defining and designing data based on business requirements and provided documentation.
  • Wrote efficient Stored Procedures for the optimal performance of the system; Created datasets using T-SQL and Stored Procedures.
  • Responsible for Creating and Modifying T-SQL stored procedures/triggers for validating the Integrity of the data.
  • Created indexed views and appropriate indexes to reduce the running time for complex queries.
  • Designed and implemented comprehensive backup plan and disaster recovery strategies to ensure high availability of data.
  • Identified the mapping issues and discusses them with business analyst team.
  • Used basic Script Task for renaming the file names, storing Row Count Values into User Variables.
  • Developed interface stored procedure to upload Insurance Record from XML format to Customer Insurance System.
  • Actively participated in designing the SSIS Package Model for initial load and incremental load for extracting, transforming, and loading data from and to various RDBMS and Non-RDBMS sources and destinations.
  • Worked with several Control Flow Tasks, Data Flow Tasks and Transformations (Look-up, Conditional Split, Merge Join, Multicast, Union All, Derived Column, Data Conversion, For Loop, For Each Loop, Sequence Container, Execute SQL Task, Send Mail Task, and Precedence Constraint) to achieve business requirements.
  • Captivated proper error handing techniques like logging, checkpoints, and event handler to handle errors in the package.
  • Designed and developed several enterprise reports (SSRS/Crystal Reports) using the data from ETL Loads and heterogeneous sources.
  • Created different parameterized reports for operational purposes based on the reporting criteria.
  • Worked on Reporting subscription services such as data driven subscriptions for email and file sharing.
  • Generated reports using different Variables, Expressions and Functions using SSRS 2008 R2.
  • Deployed generated reports each week, month and Quarter into the Report Server allowing users to access reports through browser.

Environment: T-SQL, MS SQL Server 2012 R2, MS SQL Server Integration Services, MS SQL Server Reporting services, Visual Studio, Windows XP, MS Office.

Confidential

SQL Server BI Developer (SSRS/SSIS/T-SQL)

Responsibilities:

  • Generated database monitoring and data validation reports in SQL Server Reporting Service (SSRS).
  • Created partition table for very large database for good performance.
  • Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
  • Created logging, custom logging and error handling packages.
  • Deployed SSIS packages and Reports to Production Servers.
  • Maintained system monitoring jobs and provide high availability support.
  • Worked on Migration of packages from DTS using SQL Server Integration Service (SSIS).
  • Assisted internal and external report needs and designed solutions based on specific requirements using SQL Server Reporting Service (SSRS).
  • Created and developed the stored procedures, triggers, views, and user-defined functions to support application development.
  • Involved in Normalization and De-Normalization of existing tables for faster query retrieval
  • Deployed and configured the reports in the Report Server.
  • Created User Defined Functions to encapsulate frequently and commonly used business logic making the system more modular, secured and extensible.
  • Generated test data and tested database to meet the functionalities deliverables in the project documentation and specifications.
  • Designed and developed MS SQL Server Reporting Services (SSRS) under SQL Server 2008.
  • Worked closely with IT project managers, programmers, and testers. Built a solid reputation for delivering high-quality, cost-efficient technological solutions and tools driving business development and the establishment of key partnerships with organizations by maintaining accounting and client relationships.
  • Managed all aspects of business and project development from initial scoping through strategic and fiscal planning to final testing and delivery.

Environment: SQL Server 2008 Enterprise Edition, SSIS /SSRS 2008R2, C#, T-SQL, VisualStudio.net, XML, MS Excel, MS Access, Visual Studio 2008R2

Hire Now