We provide IT Staff Augmentation Services!

Bi Developer/ Ssis / Ssrs / Ssas / Power Bi Resume

Stamford, CT

SUMMARY

  • Over 8+ years of experience in Microsoft Database Technologies that includes experience in Database Design and Development in Financial, Retail and Healthcare Domains. Experience in Business intelligence as BI Developer in data modeling, development and maintenance of database applications on SQL Server in OLTP/OLAP/BI environment.
  • Experience in Microsoft T - SQL statements (DDL and DML) including features like Temporary Tables, Raking Functions, Joins, Pivot, For XML path, CTE, While Loops etc.
  • Worked on Power BI and prepared dashboards using Tableau to make it more attractive.
  • Expert in calculating measures and dimension members using Multi-dimensional expression (MDX), mathematical formulas, and user-defined functions.
  • Created hierarchies in Power BI reports using Data visualizations like Bar chart, Line chart, pie charts, forecast charts.
  • Experienced in Creating DAX Expressions create Date to yearly columns and implement partitions in Tabular Models for power BI.
  • Experience on publishing Power BI reports of dashboards in Power BI server and Scheduling the dataset to refresh for upcoming data in power BI server.
  • Experience in generating Drill through and Drill down reports with Drop down menu option, sorting the data, and defining subtotals in Power BI.
  • Responsible for creating and changing the visualizations in Power BI reports and Dashboards per the client Requirements.
  • Experienced on Microsoft Business Intelligence Suite (Power Pivot, Power View, Power Query, Power Maps, Power BI Desktop, Power BI Service, Power BI Mobile App)
  • Experience in creating Tabular Reports, Matrix Reports, Parameterized Reports, and Sub Reports, Global map reports in both Power BI Desktop and Power BI Cloud service.
  • Robust MS Access and excel skills with Power pivot, PivotTable, PivotChart, Power view, VLOOKUP functions and formulas.
  • Excellent TSQL Scripting Skills in developing Efficient Stored Procedures, functions, applying business logic.
  • Used tools like MS SQL Profiler, Index Tuning Wizard, and Windows performance for monitoring and tuning SQL Server performance.
  • Designing, Scheduling and Maintaining ETL Framework for different Processes.
  • Data Mapping Skills, Data Migration Methods and Validations from Legacy Systems.
  • Experience in Developing, Designing and Support inter active Tableau dashboards.
  • Proficient Experienced in dealing with RDBMS including E/R Diagrams, Normalization, Constraints, Joins, Keys and Data Import/Export.
  • Worked in both SSAS Tabular and SSAS Multidimensional Cubes
  • Involved in creating Tabular Models and help build adhoc reports
  • Developed OLAP cubes using SSAS (SQL Server Analysis Services) . and calculate the metrics that were revealed in the functional analysis
  • Data Mapping Skills, Data Migration Methods and Validations from Legacy Systems.
  • Proficient Knowledge in dealing with RDBMS including E/R Diagrams, Normalization, Constraints, Joins, Keys and Data Import/Export.
  • Experienced in Developing Power BI Reports and Dashboards from multiple data sources using Data Blending and managed Database Views available to all BI and DW applications.
  • Designing and creating different SSIS packages using OLE DB connection sources from different sources by making use of multiple transformations provided in SSIS.
  • Providing security by using row level security implementation.
  • Experience in SDLC like Agile (Scrum), Waterfall and V-model.
  • Good and Effective Communication with all levels of business partners with Business Analysts to ensure the requirements are completely analyzed and technical owners to minimize risks.

PROFESSIONAL EXPERIENCE

Confidential, Stamford, CT

BI Developer/ SSIS / SSRS / SSAS / POWER BI

Responsibilities:

  • Analyzed and designed software and database solutions.
  • Developed SSIS Templates which can be used to develop SSIS Packages such a way that they can be dynamically deployed into Dev, Test and Production Environments.
  • Involved in performance tuning using indexing (Cluster Index, Non Cluster index) tables.
  • Performed daily tasks including backup and restore by using SQL Server 2012 tools like SQLServer Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
  • Worked in Agile methodology in order to discuss status of the project twice a week and take further measures which includes scrum meetings daily to discuss product backlog.
  • Designed various cube objects such as KPIs, drill through actions, aggregations, and translations. Implemented key performance indicators, actions, hierarchies, and attribute relationships with added functionalities.
  • Generated MDX scripts for KPIs and calculated members based on business requirements in SSAS.
  • Migrated and recreated existing Dimensions and Cubes using Star schema on 2012 Server to achieve the efficiency of SQL Server Analysis (SSAS)
  • Implemented DAX (Data Analysis Expressions) functions for SSAS tabular models and Excel pivot tables.
  • Understand the business needs and convert into the Data Models using Erwin tools for Data modelling, Table design, DB Objects.
  • Imported data from multiple data sources in to Excel workbook, created relationships between heterogeneous data, created calculated columns and measures using VLOOKUP and formulas, built PivotTables and pivot charts using power pivot skills.
  • Expertise in Configuring and managing data sources, data source views, cubes, dimensions, mining structures, roles and creating hierarchies using SSAS.
  • Configured and managed data sources, data source views, cubes, dimensions, mining structures, roles and creating hierarchies and implemented cell level security in cubes using SSAS.
  • Updated mapping tables related to assigned functional areas as directed by the Business Analysts. Worked with Excel Power Pivot Tables.
  • Used recently introduced Power BI to create self - service BI capabilities and use tabular models.
  • Responsible for building reports in Power BI from the Scratch.
  • Responsible for creating and changing 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.
  • Experience on publishing Power BI reports on dashboards in Power BI server.
  • Created hierarchies in Power BI reports using visualizations like Bar chart, Line chart, etc.
  • Worked with both live and import data in to Power BI for creating reports.
  • Managed relationship between tables in Power BI using star schema.
  • Used different type of slicers available in Power BI for creating reports.
  • Created reports with Analysis Services Cube as the data source using SQL Server 2012 Reporting Services.
  • Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.
  • Experience in creating Tabular Reports, Matrix Reports, Parameterized Reports, and Sub Reports using SQL Server Reporting Services (SSRS)

Environment: MS SQL Server 2012, Tableau, SSAS, Power BI, SQL Azure, SQL Server Reporting Services 2012, SSIS, Front Office 8.3 / 10.2 / 10.3 , Erwin, Windows 8/8.1, MS Office 2007/2010, T-SQL.

Confidential, Salem, MA

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

Responsibilities:

  • Interacting with users to gather Business requirements and Analyzing, Designing and Developing the Data feed and Reporting systems.
  • Developed complex programs in T - SQL, writing Stored Procedures, Triggers and Queries with best execution plan.
  • Extensively worked on Views, cursors, CTE's, schemas, permissions and performance issues with client/server database design.
  • Involved in creating Databases, Tables, Views, Cluster/Non-Cluster Index, Unique/Check Constraints, Rules and Defaults.
  • Defined Check constraints, Business Rules, Indexes, and Views.
  • Worked with Exception handling with error and with Try/catch.
  • Involved in Data Extraction, Transformation and Loading (ETL process) from Source to target systems.
  • Deployed SSIS packages and Scheduled Jobs.
  • Involved in Analyzing and integrating the data.
  • Created views to restrict access to data in a table for security. Expert in extracting data using SSIS from OLTP to OLAP. Performed Bulk data migration using DTS and SSIS from flat files.
  • Worked with integration services for transferring and reviewing data from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data)
  • Developed Incremental Load using Lookup in SSDT visual studio.
  • Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases. Created SSIS packages to Export data from text file to SQL Server Database.
  • Worked on transformations such as Checksum in SSIS where all of the rows in table need to compared for an update.
  • Designed and implemented complex SSIS package to migrate data from multiple data sources for data analyzing.
  • Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis.
  • 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 current status.
  • Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS)
  • Developed various operational, drill-through and drill-down reports using SSRS.
  • Created Developer's Documentation and User's Manual.

Environment: Windows Server 2003, SQL Server 2008R2, 2014, SSIS, SSRS, ETL tool, T-SQL, Visual Studio 2005/2008, MS Office, SQL.

Confidential, New York, NY

MS SQL Server Developer / SSIS / SSRS

Responsibilities:

  • Developed Queries for generating drill down and drill through reports in SSRS 2008 R2.
  • Uploaded reports on to the report manager and organized them into folders.
  • Generated and formatted Reports using Global Variables, Expressions and Functions for the reports.
  • Designed and implemented stylish report layouts.
  • Identified and worked with Parameters for parameterized reports in SSRS 2008 R2
  • Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
  • Created parameterized, drill down, drill through and aggregation type of reports, charts and dashboards in SSRS.
  • Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MSOLAP/ Analysis server (SSAS)
  • Enhancing performance using optimization techniques - normalization, indexing and Transaction Isolation levels, monitoring logs to ensure the completeness of batch processes, scripts and processes.
  • Worked in agile methodology to discuss status and product backlog in scrum methodology.
  • Created Linked servers to connect OLE DB data sources and providers.
  • Administered the SQL Server by creating user logins, dropping and locking the logins, monitoring the user accounts, creating groups, granting privileges to users and groups.
  • Designed and created MDX queries to retrieve data from cubes using SSIS.
  • Based on the mapping document, with the use of MS Vision have created Dimension and facts for the dimensional modelling in data modelling.
  • Worked with Application Developers to design databases and tables to support development activities and achieve optimal efficiency
  • Designing Logical and Physical Data Model with Erwin tools.
  • Creating and Modifying Tables, Stored Procedures, Views, Indexes, User-defined Functions, and Triggers etc. as required Worked with Installation/Management of MS Team Foundation Server and TFS Migration processes.
  • Generated different types of Tabular Reports, Matrix Reports, Chart and Graphs Reports, Ad-Hoc Reports using MS SQL Reporting Services (SSRS)
  • Designed and deployed reports with Drill Down, Drill Through, Parameterized and Sub-reports using SSRS.
  • Managing security roles in SQL Suite.
  • Created data packages and modelling data integration flows with SSIS from various data sources.
  • Wrote T-SQL queries, Stored Procedures and used them to build packages.
  • Created automated T-SQL scripts to process summary database transactions that run off-hours.
  • Diagnosing and tuning the server optimal performance using SQL Server 2008 SQL Profiler and Database Engine Tuning Wizards.

Environment: SQL Server 2008 R2, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SSRS, Windows Server 2008, T-SQL, SQL Profiler, SQL Server Agent, MS Visio, MS Excel, XSLT, Visual Studio 2010, Asp.NET, T-SQL.

Confidential, Nashville, TN

SQL Server Developer/ SSIS Developer

Responsibilities:

  • Designed, coded, tested and implemented user interfaces, procedures and functions for new and existing software application requirements.
  • Created Business Requirements, Design, Functional Specifications and Flowcharts.
  • Install, tune, maintain and monitor SQL Server for the Production environment
  • Created DTS package to get data from different sources, consolidate and merge into one single source.
  • Created variety of reports for business to provide them with critical information about business status.
  • Actively involved in Normalization & De - normalization of database.
  • Created complex variables, multiple breaks, sorts in the reports.
  • Created database objects like tables, user defined functions and cursors using DDL, DML statements.
  • Developed stored procedures and views for managing efficient data retrieval.
  • Created and Implemented triggers in T - SQL to facilitate consistent data entry into the database.
  • Proper use of Indexes to enhance the performance of individual queries.
  • Created clustered/non-clustered indexes on tables.
  • Created joins and sub-queries for complex queries involving multiple tables.
  • Created generic Measure class for generic measures, and created separate class for conditional objects.
  • Involved in System testing.
  • Decided upon the locking strategy that could be used for various batch Programming structures & Transactions.

Environment: SQL Server 2000, Access 2000 & Windows 2K platform ADO.NET, MS Project