We provide IT Staff Augmentation Services!

Sql Bi Ssas, Ssrs, Ssis Developer Resume

Fort Lauderdale, FL

PROFESSIONAL SUMMARY:

  • Over 6+ years of IT Experience in Database Design, Development and business intelligence of Microsoft SQL Server 2008/ 2012/2014/2016 in Development, Test and Production Environments on various business domains like Financial, Insurance, Software and Manufacturing.
  • Hands on experience in installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting SQL Server 2008/2012/2014/2016.
  • Expertise in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) with good knowledge on SQL Server Analysis Services (SSAS).
  • Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports.
  • Experience in SQL server MDS 2012 features includes hierarchies, granular security, transactions, data versioning, and business rules.
  • Experience in developing, monitoring, extracting and transforming data using DTS/SSIS, Import Export Wizard, and Bulk Insert.
  • Excellent in High Level Design of ETL DTS Packages & SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like (Excel, CSV, SAS,Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and union all.
  • Developing reports on SSRS on SQL Server ( 2008/ 2012/2014/2016 ). Sound Experience and understanding of SSAS, OLAP cube and Architecture.
  • Experience in writing expressions in SSRS and Expert in fine tuning the reports. Created many Drill through and Drill Down reports using SSRS.
  • Experience in working with Web services to handle SQL connections.
  • Strong skills on Deploy and operate large scale cloud infrastructure and application services in our own data centers on Amazon cloud and other Cloud providers
  • Strong knowledge with Host Scripting to automate routine tasks.
  • Used SAS for mine, alter, manage and retrieve data from a variety of sources and perform statistical analysis on it and as a source for SQL.
  • Excellent knowledge in creating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, functions, Cursors and Indexes using T - SQL.
  • Great ability to create and manage various database objects like tables, views.
  • Worked Extensively on ETL process using SSIS package.
  • Experience in Data Conversion and Data Migration using SSIS and DTS services across different databases like Oracle, MS access and flat files.
  • Good Experience in working with APIs to access specific database features.
  • Experience in using T-SQL in SQL Server.
  • Experience in Performance Tuning and Query Optimization.
  • Well versed in Performance Point Server 2007. Designed Dashboards, Scorecards and reports using multiple KPI's, OLAP charts and SSRS Reports with PPS.
  • Experience in maintenance and Administration of SSIS by creating Jobs, Alerts, SQL Mail Agent, and schedule DTS/SSIS Packages.
  • Experience in SQL Server DTS and SSIS (Integration Service) package design, constructing, an d deployment.
  • Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS)
  • Generated Data to support SAP Business Objects Interface for Users to access data from Data Warehouse.
  • Experience in creating packages to transfer data between, DB2, ORACLE, MS ACCESS and FLAT FILES to SQL SERVER using DTS/SSIS.
  • Expert in creating Parameterized Reports.
  • Hands on experience in Creating Star Schema and Snow Flake Schemas.
  • Excellent analytical, communication and interpersonal skills. Proficient in technical writing and presentations and a good team player.
  • Ability to express complex technical concepts effectively, both verbally and written.

TECHNICAL SKILLS:

Databases: SQL Server 2016/2014/2012/2008 , Oracle 11g/8.0i, Microsoft Access 2000/8.0 Teradata14.0, DB2

Languages: C, C++, PL/SQL, TSQL, DB2, MYSQL, DHTML, VB.NET, ASP.NET, .NET Frame Work, C#, JavaScript

Scripting Languages: HTML, XML, Java Scripting, VB Scripting

Web Tools: C#.Net, ASP.Net,VB.Net, Visual Studio.Net, XHTML1.0, JavaScript, VB Script

ETL & Reporting: SSRS 2005/2008/2012/2014 , SSIS 2012/2014/2016

Hardware: IIS 6.0/5.0/4.0

Version & Defect Control: Microsoft TFS, MS VSS, Synergy, HP Quality Center & Jira

Others: AWS,MS Office, Erwin, Crystal Reports XI, Visio, Microsoft Business Intelligence Studio, Service Oriented Architecture (SOA) SQL Server Notification Services, SQL Server Analysis Services (SSAS), Visual web developer, MS FrontPage, Windows Scripting Host, Erwin Data Modeler, MS Visual, SAS/Access, Crystal Reports SAP Business Objects

PROFESSIONAL EXPERIENCE:

Confidential, Fort Lauderdale, FL

SQL BI SSAS, SSRS, SSIS Developer

Responsibilities:

  • Worked on row-level security for better performance/security from hierarchy perspectives.
  • Participated in design discussions with Database architects and Application architects.
  • High Experienced in generating SSIS Packages/projects from various source s to specific destination by using Visual Studio 2012, building and scheduling jobs for ETL process.
  • Developed SSIS packages to pull out, modify and load data from Oracle/SAP and SQL Server databases into Data Warehouse.
  • Good knowledge on the dimension, fact tables and designing the Data-Mart using Star schema.
  • Wrote Stored Procedures , Functions and expressions for better performance and flexibility.
  • Deployed SSIS packages into various Environments (Development, Te s t and PROD) using Deployment Utility.
  • Worked on creating SQL Server jobs and scheduled them to load data over nightly using SQL server Agent.
  • Achieved successful results on performance based on execution plan and creating optimal logic using T -SQ L .
  • Created Joins and sub-queries for complex queries involving multiple tables from different databases Daily support of system wide replication tasks including monitoring, alerting, and problem resolution.
  • Created SQL server MDS 2012 We b App that integrates with Add-in Excel and right Sql Server database.
  • Presented and supported Sales team on implementation of SQL Server MDS 2012 for MDM of Sales team.
  • Strong Applications Development experience with back-end databases such as SQL Server, SQL MDS 2012, Oracle and MS Access using ADO/ADO.NET OLEDB and SQL client.
  • Strong skills in transformation data from DB2 to SQL Server.
  • Data migration from text files, DB2 , excels files to SQL server.
  • Largely used T -SQ L in supporting Finance Team and constructing User defined Functions, Views, Indexes, User Profiles, Relational Database Models, Data Dictionaries, and Data Integrity.
  • Created and Designed Data Source and Data Source V ie ws and also configured OLAP Cubes (Star and Snow flake Schema) using SSAS.
  • Extract Transform and Load (ETL) source data into respective target tables to build the required data marts.
  • Involved in Dimensional Data Modeling and Cube partitioning in SSAS.
  • Had experience on the Reports module of the project as a developer on MS SQL Server 2008 (using SSRS, T -SQ L , scripts, stored procedures and views).
  • Configured Dimensional modeling for End-User from Hierarchy perspectives.

Skills Used: MS SQL Server2012/ 2008, MS SQL Server Master Data Services 2012, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), MS Visual Studio.NET# 2008, SAP Business Objects, BI Extractor, Microsoft Excel, Add-In Excel with Master data.

Confidential, Miami, FL

SQL BI SSAS, SSRS, SSIS Developer

Responsibilities:

  • Defined technical requirements based on the business workshops.
  • Participated in design discussions with Database architects and Application architects.
  • Designed the Data warehouse and done the mappings from Source to the Ta rg et tables.
  • Developed SSIS packages to extract, transform and load data from Oracle and SQL Server databases into Data Warehouse.
  • Identified the dimension, fact tables and designed the Data-Mart using Star schema.
  • Created Indexes for faster data retrieval from the database.
  • Wrote Stored Procedures and Functions for better performance and flexibility.
  • Deployed SSIS packages into various Environments (Development, Te s t and PROD) using Deployment Utility.
  • Coordinated with Users in different testing phases.
  • Created SQL Server jobs and scheduled them to load data periodically using SQL server Agent.
  • Formatted/Generated Data to support SAP Business Objects Interface for Users to access data from Data Warehouse.
  • Strong Applications Development experience with back-end databases such as SQL Server, Oracle and MS Access using ADO/ADO.NET OLEDB and SQL client.
  • Having good hands on experience with C#.NET and VB.NET for downloading files from a remote server.
  • Strong skills in transformation data from DB2 to SQL Server
  • Created and Designed Data Source and Data Source V ie ws and also configured OLAP Cubes (Star and Snow flake Schema) using SSAS.
  • Extract Transform and Load (ETL) source data into respective target tables to build the required data marts.
  • Enhanced the functionality in database and data ware housing concepts ( OLA P , O LT P) Cube by creating KPI, Actions using SSAS.
  • Involved in Dimensional Data Modeling and Cube partitioning in SSAS.
  • Worked on the Reports module of the project as a developer on MS SQL Server 2008 (using SSRS, T -SQ L , scripts, stored procedures and views).
  • Created reports from O L AP, sub reports, bar charts and matrix reports using SSRS Developed Multidimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS).
  • Designed Dimensional modeling using SSAS cubes for End -User. Created Hierarchies in Dimensional Modeling.
  • Developed Aggregations, partitions and calculated members for cube as per business requirements.
  • Defined appropriate measure groups and KPIs and deployed cubes.
  • Created Parameterized reports, Cross-Tab reports, Drill down reports & Summary reports by Using SSRS. Created report snapshots to improve the performance of SSRS.

Skills Used : MS SQL Server2012/ 2008, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), MS Visual Studio.NET# 2008, SAP Business Objects, Microsoft Excel.

Confidential, Oakland, CA

MS SQL BI SSAS Developer

Responsibilities:

  • Being a member of BI Team , involved in gathering requirements from Business users and Perform technical design Development and Testing.
  • Involved in design and creation of data mappings from sources like Flat files, DB2, Excel files, OLEDB and ODBC data sources which contains bulk data.
  • Developed ETL packages to extract, transform and load into Data ware house using of SQL Server Integration Services (SSIS).
  • Constructed an API to access OLAP and information in the database.
  • Experience in Developing and Extending OLAP Cubes, Dimensions and data source v ie w.
  • Assisted in production OLAP cubes, wrote queries to produce reports using SQL Server Analysis Services (SSAS) and Reporting service (SSRS) Editing, upgrading and maintaining AS P . N E T website and IIS Server.
  • Developed GUI front end using web forms in ASP.N ET . Created Modules and Classes in Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS
  • Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder.
  • Involved in migration from SQL Server 2005 to SQL Server 2008.
  • Experience in creating Parameterized reports and Linked reports with thorough knowledge of report serving architecture. (Table, chart and matrix report).
  • Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes.
  • Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2008 and in adding calculations using MDX.
  • Designed and implemented data mart, facts, dimensions and OLAP cubes using dimensional modeling standards in SQL Server that maintained data. Involved in the complete data warehouse development life cycle. Actively supported business users for change requests.
  • Involved in designing, developing, debugging and testing of reports in SQL Server Reporting Services (SSRS). Creating reports using SQL Reporting Services (SSRS) for customized and ad-hoc Queries.
  • Experience in creating Parameterized reports and Linked reports with thorough knowledge of report serving architecture. (Table, chart and matrix report).
  • Worked on Business Objects in order to access reports and to export data.
  • Used SSIS to unite data from existing system and performed transformations on MS SQL 2008.
  • Extract Transform Load (ETL) development Using SQL server, SQL 2008 Integration Service (SSIS) generated several drill down and drill through reports using SSRS.
  • Expert in creating Star schema cubes using SSAS.
  • Extensively worked on OLAP cubes using SSAS.
  • Created and Managed OLAP Cubes using SSAS.
  • Used Performance Point Server to create reports, scorecards and dashboards.
  • Involved in creating calculated members, named set, advanced KPI’S for the SSAS cubes.
  • Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
  • Designed and created the table schema and stored procedures that will be used in Data QC.
  • Designed and developed the Data QC Maintenance website that will be used to maintain the application tables, execution of main Data QC store procedures, and report generation that will be exported to Microsoft Excel file.
  • Used Joins and sub-queries for complex queries involving multiple tables from different databases Daily support of system wide replication tasks including monitoring, alerting, and problem resolution.
  • Responsible for documentation of system related activities.
  • Provides technical documentation of the system
  • Worked on PROCLARITY to create OLAP data sets and queries are created directly from the Unified Dimensional Model.
  • Actively participated in interacted with users, team lead, DBAs and technical manager to fully understand the requirements of the system.

Skills Used: MS SQL Server 2005/2008 R2/ SQL Server 2012, SQL server Reporting Services 2008, SQL Integration Services 2008,SQL server Analysis Services 2008, Microsoft Visual Studio, SQL Server Management Studio, MS Excel, T-SQL,ERWIN.

Hire Now