We provide IT Staff Augmentation Services!

Sr. Sql/msbi/power Bi Developer Resume

5.00/5 (Submit Your Rating)

Allendale, NJ

SUMMARY

  • Over 8 years of Experience in Database Design, Data modeling, Development, Implementation and Maintenance of SQL Server Databases (2008/2012/2014 ) and Business Intelligence Applications - SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS) and Power BI.
  • Expert in all areas of SQL Server development including tables, user functions, views, Indexes, Stored procedures, functions, triggers, clustering, T-SQL, relational database models, data dictionaries, and data integrity.
  • Expert in Visualizing and Analyzing Data using Power BI.
  • Expert in all areas of SQL Server development including tables, user functions, views, Indexes, Stored procedures, functions, triggers, clustering, T-SQL, relational database models, data dictionaries, and data integrity.
  • Good knowledge in RDBMS concepts, Data warehousing concepts, OLTP and OLAP.
  • Experience in Interacting with Business users to analyze the business process and transforming requirements into screens, performing ETL, documenting and rolling out the deliverables.
  • Expertise in Extract Transform Load (ETL) and Data Transformation Services (DTS).
  • Expertise in configuring and creating SSIS solutions for ETL and Business Intelligence Process for Data Integration and Migration services.
  • Has a very good experience in creating SSIS packages to manage SQL server databases and SQL Server objects between instances of SQL server.
  • Great Expertise in creating and managing Event Handlers, Package Configurations, Logging and User-defined Variables for SSIS Packages.
  • Experience in managing and automating Control flow, Data flow, Events and Logging programmatically using Microsoft .NET framework for SSIS packages.
  • Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
  • Strong ability in defining query for generating drill down reports, handling parameterized reports and creating stylish report layouts in SSRS.
  • Experience in generating Drill through and Drill down reports with Drop down menu option, sorting the data, defining subtotals in SSRS.
  • Generated reports using SSRS, Excel (Pivot) that could be used to send information to diverse group of users.
  • Extensive experience in different type of reports including: Tabular forms, Matrix (cross Tab report) form, Conditional, List items, Charts and Sub reports.
  • Experience in Troubleshooting Report Processing, Subscription, Delivery and Configuration Problems.
  • Proficient in building Cubes, defining Referenced Relationships and creating Hierarchies, Perspectives, Partitions and Designed Aggregations in cubes using SSAS.
  • Expertise in creating Cell Level Security in cubes using SSAS.
  • Expertise in creating Dashboard Reports to support end users using SSAS.
  • Experience with Microsoft Power BI, DAX expressions, Power View and Power Query integrated with share point.
  • Expert in creating Effective Reports using visualizations and Dashboards using Power BI.
  • Experience in creating measures and Calculated columns using DAX in Power BI.
  • Good Experience in Creating and implementingMobile dashboards using Power BI.
  • Expert in implementing Row level security(RLS) for user authentication in Power BI.
  • Experience in using SQL Profiler, Database Engine Tuning Advisor, Performance Monitor and Index Tuning Wizard to improve the performance of queries.
  • Self-motivated and possess ability for critical thinking, analysis, team-oriented, technically motivated and creative, good interpersonal and communication skills. User oriented with a desire to learn client and business requirements.
  • Strong inclination for finishing job before project deadline. Flexible and versatile to adapt to any new environment and work on any project.

TECHNICAL SKILLS

Databases: SQL Server 2014/2012/2008 R2/2005/2000, Teradata, MS Access.

Database Tools: SQL Server Integration Services, Data Transformation Services, SQL Server Analysis Services, OLAP (Online Analytical Processing, Multi-dimensional Cubes and Business Intelligence & Development Studio

Languages: VB.Net, VB Script, T-SQL, SSAS, OLAP, HTML, XML, ASP, Java Script, C, C#, DAXand MDX.

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

Reporting Packages: SQL Server Reporting Services, Business Objects 6.5/XI, Crystal reports 9/10/11, MS Excel,Power BI.

Tools: /Methodologies: MS Office 365,MS Visio, Erwin, MS Project, Rational Rose, SQL Profiler, SQL*Loader, Front page,JIRA Walkthrough,Sharepoint.

PROFESSIONAL EXPERIENCE

Confidential, Allendale, NJ

Sr. SQL/MSBI/Power BI Developer

Responsibilities:

  • Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional work flow of information from source systems to destination systems.
  • Involved in development and debugging of complex T-SQLprocedures and functions.
  • Designed and developed SSIS Packages to import data and export data from MS Excel, flat files,SQLServer and transform and load data intoSQLServer database.
  • Implemented SSIS packages to load the Data into Staging, ODS and dimensional model.
  • Designed and developed SSIS packages using various control flow and data flow items to transform and load the data from various databases and into server integrations services (SSIS).
  • Configured package with checkpoints, package logging, error handling and event handling to redirect error rows and fix the error in SSIS.
  • Worked on Data Analysis Expressions (DAX) for accessing data directly fromtabularSSAS database.
  • Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/Analysis server.
  • Created a cube using multiple dimensions and established the Relationship between Measure group and dimension tables usingStar Schema in SSAS.
  • Implemented SSRS solutions, used dashboards and gauges to enhance for the business users.
  • Developed many Tablix Reports, Tabular Reports, Matrix Reports, drill down Reports and Charts using SQL Server Reporting Services (SSRS).
  • Experience in creating Parameterized reports and Linked reports with thorough knowledge of report serving architecture. (Table, chart and matrix report).
  • Deployed and Generated SSRS reports using the Reporting Services, Report Manager and Microsoft SharePoint 2010.
  • CreatedPowerBIVisualizations and Dashboards as per the requirements.
  • Created many calculated columns and measures using DAX in Power BI based on report requirements.
  • Involved in UI Design for Power BI Reports and designed effective layouts.
  • Created effective reports using visualizations such as Bar chart, Clustered Column Chart, Waterfall Chart, Gauge, Pie Chart, Tree map etc. in Power BI.
  • Created Roles and implemented Row level security for user Authentication in Power BI.
  • Created effective Dashboards in Power BI Service and made the reports user friendly and interactive.
  • Worked with Power BI mobile app and created mobile layouts to view reports and dashboards effectively.
  • Installed On premise data gateway and scheduled daily data refresh in Power BI.

Environment: SQL Server 2014/2012, Integration Services (SSIS), Analysis Services (SSAS), Reporting Services (SSRS), PowerBI, T-SQL, MDX, XML, MS Excel, Visual Studio 2012,MS Office 365.

Confidential, Beaverton, OR

Sr. SQL/BI (SSIS/SSRS/SSAS)/Power BI Developer

Responsibilities:

  • Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes whenever necessary.
  • Created Efficient Stored Procedures, Triggers, and Functions, Indexes, Tables, Views and other T-SQL scripts.
  • Involved in Creating Data warehouse based on Star schema and worked with SSIS packages to load the data into the database.
  • Implementing and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables, Check Points and Expressions for SSIS Packages.
  • Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages.
  • Generated Reports using Global Variables, Expressions and Functions for the reports.
  • Created multi valued parameters & cascaded parameters in the reports using MDX and T-SQL.
  • Created MDX queries to retrieve data from the cube and to display SSRS reports.
  • Modified existing reports as per requirements of the end users and improved Report Performance and performed unit testing.
  • Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel formats using Reporting Services (SSRS).
  • Provided MS SSRS 2008 training to clients in order for them to develop their own ad-hoc reports.
  • Created the structure of the model and cube in MS Analysis Services (SSAS 2014).
  • Reviewed Cube with End user and changing the cube and documentation according to their requirements.
  • Defined relationships between Measure groups and Dimensions.
  • Generated automatically grouping attribute members.
  • Designed and implemented Dashboards and Scorecards with business KPIs using Performance Point Server and published them Via Power BI.
  • Built Reports in Power BI from the scratch.
  • Created, Implemented, Modified the visualizations in Power BI reports and Dashboards on client requests.
  • Created Calculated Columns and Measures in Power BI and Excel depending on the requirement using DAX queries.
  • Designed and implemented Dashboards and Scorecards with business KPIs using Performance Point Server and published them Via Power BI.
  • Implemented the calculations to aggregate physical measures.
  • Used Caching (Cache Technology) for fast retrieval of data to generate reports against data warehouse.
  • Created reports to generate them through Email for the administrative using MDX Queries.
  • Designed Cube partitioning and incremental synchronization for SSAS cubes.
  • Implemented Stored Procedures for Automatic Scripting to backup transaction logs, flush/grow/shrink log files, maintain archive of objects.

Environment: SQL Server 2014/2012, Integration Services (SSIS), Analysis Services (SSAS), Reporting Services (SSRS), SQL Server Management Studio, PowerBI, T-SQL, MDX, XML, MS Excel, Visual Studio 2012,MS Office 365.

Confidential, San Jose, CA

SQL/BI (SSIS/SSRS/SSAS) Developer

Responsibilities:

  • Worked extensively on installation, upgrade and configuration of MS SQL Server 2012 databases servers.
  • Developed Use Case Documents and Technical Documentation for some reports to Hand-off to the Offshore Development Team.
  • Worked with business/functional analysts to determine reports and analytical requirements.
  • Created Database Objects - Schemas, Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, Constraints and Roles.
  • Developed complex queries, stored procedures, views, and constraints, triggers using inner and outer joins, unions, and SQL Statements for various applications in different environments.
  • Worked onSQLServer Integration Services (SSIS) to integrate and analyze data from multiple heterogeneous information sources.
  • Extensively worked with SSIS tool suite, designed and created mappings using various SSIS transformations like Conditional Split, Lookup, Aggregator, Multicast and Lookup.
  • Implemented Slowly Changing Dimension to maintain historical data in Data Warehouse.
  • Designed and developed data load jobs using SSIS package and scheduled in SQL Agent.
  • Created Reports with latest features provided by SSRS like dynamic navigation, hyperlinks, different set of graphs in tabular format etc.
  • Documented Report Models and Report Templates for other Team Members.
  • Categorized reports into batch reports and on demand reports and scheduled it according to that.
  • Configured and maintained Report Manager and Report Server for SSRS.
  • Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS.
  • Generated ad-hoc reports using MS Reporting services and Crystal reports.
  • Worked on Database space management, performance monitoring and alert management.
  • Hands on experience with Business Objects life cycle implementations.
  • Created Data warehouse Cubes inSQL Server Analysis Service (SSAS).
  • Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS.
  • Designed and Configured Dimensions, Attributes, Hierarchies, KPIs, Aggregations and Cube Partitions.
  • Involved inTabular Data warehouseandDAXoperations for SSAS 2012 and 2008 OLAP databases.
  • Automated daily Database backups, restores and integrity checks using Management Studio and creating or updating indexes using SQL Profiler.

Environment: MS SQL Server 2012/2008 R2, T-SQL,SSIS, SSRS, SQL Profiler, Visual Studio (2012), Windows 7, MS Office 2013, Team Foundation Server.

Confidential, San Francisco, CA

SQL / BI (SSIS/SSRS/SSAS) Developer

Responsibilities:

  • Conceptualized and Designed Logical and Physical Data Models using ERWIN.
  • Created various Tables and Views and wrote complex Stored Procedure, Queries, Triggers, Functions, Indexes, User-defined functions and Cursors for application.
  • Transformed the complex business logic and calculations into coding.
  • Developed SSIS project for transferring the data.
  • Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source (Oracle), Excel Spreadsheet to SQL Server 2008.
  • Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases.
  • Defined aggregations required and granularity available and required in DW.
  • Install SQL Server Reporting Services (SSRS) and configure the reporting services configuration.
  • Responsible for creating the reports based on the requirements using SSRS.
  • Created Parameterized, Cascaded, Drill-down, Cross-tab, Sub-Reports, Chart Reports, Drill-Down and Drill-through Reports using SSRS.
  • Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
  • Creating, Modifying SSAS Measures, Dimensions Attribute relationships and Hierarchies.
  • Designed SSAS Cubes, Named Calculations for Dimensions.
  • Identified Dimensions and Facts, Used MDX to extract data from cubes and Created MDX script for representing Cube Calculation.
  • Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS.

Environment: MS SQL Server 2008 Enterprise Edition, SSRS, SSIS, SSAS, T-SQL, Visual studio 2008/2012, Windows Server 2008, HTML, IIS, Visio, Visual Source Safe, Erwin 4.1.

Confidential, Iselin, NJ

SQL/BI (SSIS/SSRS) Developer

Responsibilities:

  • Understanding the business requirements, analyzing source system, source files, setting up the goals for implementing the new client.
  • Assisted in complete Life Cycle including Design, Development and Testing.
  • Created Development and Production support documents.
  • Used DDL and DML for writing triggers, stored procedures, and data manipulation.
  • Created tables, views, clustered & non-clustered indexes, user defined data types, user defined functions and CTE's.
  • Created joins and sub-queries for complex queries involving multiple tables.
  • Managed the entire ETL process involving the access, manipulation, analysis, interpretation and presentation of information from both internal and secondary data sources to customers.
  • Created the Logical, Physical model and ETL Mapping Documents based on Business logic.
  • Extracted data from Oracle, DB2, SQL Server, Flat Files, Excel and XML using SSIS and cleanse the data.
  • Configured the SSIS Packages using Environment Variables for Dynamic Selection of Development and Production Environment.
  • Converted data types using Derived Column, Data Conversion Transformation.
  • Created SSIS Packages for Incremental Loading and slowly changing dimensions.
  • Created logging, custom logging and error handling packages.
  • Migrated DTS 2000 packages to SQL Server Integration Services (SSIS) and modified the packages accordingly using the advanced features of SQL Server Integration Service.
  • Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
  • Created SSRS reports using Report Parameters, Drop-Down Parameters, Multi-Valued Parameters Debugging Parameter Issues Matrix Reports and Charts.
  • Created Advanced Reporting Services Programming Using the Reporting Services Web Service.
  • Created Ad-Hoc Reporting with Report Builder and Programming Reporting Services.
  • Monitoring SQL Error Logs, Scheduling Tasks, Database Activity, Eliminating Blocking and Deadlocks.
  • Developed SQL Server Maintenance plan, scheduling of Jobs, Alerts and Troubleshooting.

Environment: SQL Server 2008 R2 Enterprise Edition, Visual Studio 2008, DB2, Microsoft Visual Basic, Excel 2010, VBScript, XML, Microsoft Visio, Windows XP, T-SQL, UNIX, XML, Team Foundation Server.

Confidential

MS SQL / ETL (SSIS) Developer

Responsibilities:

  • Created and managed schema objects such as tables, views, indexes, procedures, triggers and maintaining Referential Integrity.
  • Created complex Stored Procedures and Functions to support the front-end application.
  • Modified current database by adding tables, altering referential integrity and relationships to support online system.
  • Worked on MS SQL Server tasks such as data loading, batch jobs, BCP, DTS, Instances, Linked Servers and Indexes.
  • Created views to reduce apparent database complexity for end users and preventing sensitive columns from being selected.
  • Created the indexes on columns having high selectivity and low density to speed up the execution of data retrieval queries and stored procedures.
  • Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.
  • Responsible for the design, development and implementation of mappings/transformations based on source-to-target specifications, defining ETL (extract, transform, load) and ETL development standards.
  • Developed new mappings using SSIS Look Up/Aggregation transformations to match the needs of the business case.
  • Converted data using Derived Column, Data conversion transformation and Script task.
  • Involved in creating Users and Roles, and managing security and permission of database, managing Jobs and error logs.
  • Involved in database management, performance measurement and performance tuning for new databases and existing databases by using SQL Profiler, SQL Analyzer, and SQL Enterprise Manager.

Environment: SQL Server 2005/2008 Enterprise Edition, Microsoft Visual Basic, XML, Microsoft Visio, Windows XP, MOSS, Visual Source Safe, T-SQL, MS Excel, DTS, SSIS, SQL Server Management Studio.

Confidential

Jr. SQL Developer

Responsibilities:

  • Installed and configured SQL Server 2005 successfully on Windows Server 2003.
  • Responsible for creating Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints Views, Stored Procedures, Triggers, Rules and Defaults.
  • Successfully migrated data between different heterogeneous sources such as flat file, Excel and SQL Server 2005 using BCP and Bulk Insert.
  • Created indexed views, and appropriate indexes to cut the complex query run time.
  • Developed SQL scripts to Insert/Update and Delete data in MS SQL database tables.
  • Maintained Change Control and Release Management process for all database objects like Tables, Views, Procedures and Triggers.
  • Updated the statistics info and managed Clustered and Non-Clustered Indices for improved database performance.
  • Created queries with Inner Join, Outer Join, left join, right join and Co-Related sub-query with Mathematical function, Aggregate function.
  • Extensively used Joins, sub-queries for complex queries involving multiple tables from different databases.
  • Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler and Database Tuning Advisor.
  • Involved in creating maintenance plans in SQL Server Agent to backup/restore the database.

Environment: SQL Server 2005 Enterprise Edition, T-SQL, MS-Access, MS Excel, SQL Server Management Studio, SQL Profiler, Database Tuning Advisor, SQL Server Agent, Windows XP.

We'd love your feedback!