Sql Datawarehouse/ssis/ssrs/powerbi Resume
Mason, OH
SUMMARY:
- Over 7+ years of experience in the field of Microsoft BI tools (SSIS/SSRS), Data Warehousing and T SQL using SQL Server (2012/2014/2016 ).
- Expertise in Extraction, Transformation, Loading data from Oracle, DB2,Teradata, SQL Server, Access, Excel, Flat Files and XML using DTS, SSIS packages.
- Hands on experience in all phases of SDLC (software development life cycle) involving Requirement analysis, Software design, development, implementation, testing, maintenance.
- Experience in developing stored procedures, functions, Joins, triggers, views/materialized views, optimizing queries, table n ormalization and demoralization, clustering, T - SQL, SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Checks, and Unique), RDBMS, data dictionaries, and data integrity.
- In-depth experience of Transact-SQL (DDL, DML), Designing and Normalization techniques on the database tables.
- Good knowledge in RDBMS concepts, Data warehousing concepts,& OLAP.
- Experience on data migration from SQL Server and .
- Experience in migration of SSRS reports from 2012 server to 2016.
- Performed data cleaning, data validation, and data analysis using data analysis expressions (DAX), power query and power Pivot.
- Designed, Developed, Tested, Published and maintained PowerBI Functional reports, Dashboards based on user requirements.
- Good experience on creating multiple kind of Power BI Reports and Dashboards.
- Created, Maintained & scheduled various reports in Power BI like Tabular Reports.
- Proficient in designing and scheduling complex SSIS Packages for transferring data from multiple data sources to SQL server.
- Created and deployed new SSIS packages to extract data from legacy to SQL Server Objects. Implemented BCP for bulk inserts.
- Experience is automating the SSIS packages throught TIDAL.
- Extensive knowledge of using package Configuration wizard to configure SSIS packages.
- Expertise in creating Property Expressions, Script Tasks for SSIS packages.
- Strong Experience in Creating, Configuring, Deploying and Testing SSIS Packages.
- Experience in creating Report Models for building Ad hoc reports using SSRS.
- 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.
- Very good experience in writing expressions in SSRS.
- Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
- Experience in modifying existing Tabular SSAS models to satisfy new business requirements.
- Expertise in creating Perspectives, Partitions and Design Aggregations in cubes using SSAS.
- Expertise in working with Version control system (VSS, VS, TFS).
- Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.
TECHNICAL SKILLS:
RDBMS: Microsoft SQL Server 2005/2008/2012/2014, 2016,MSAccess,Teradata
Programming Languages: T-SQL,SQL,PL/SQL,C#
Database Tools: SQL Server Management Studio (SSMS), Business Intelligence Development Studio,SQL Profiler, T-SQL, PL/SQL, OLAP, MOLAP, ROLAP, OLTP, DBCC.
BI Tools: SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS),PowerPivot, Power BI,Informatica 8, OLAP tools,Sharepoint,Performance Point Server 2007, MS Visio
Application Servers: Microsoft IIS 6.0/5.0/4.0, Apache.
WORK EXPERIENCE:
Confidential, Mason, OH
SQL Datawarehouse/SSIS/SSRS/PowerBI
Responsibilities:
- Working in the HealthCare Industry Design and implement custom SSIS Package on a project-by-project basis.
- Strong knowledge of Health Care Insurance, EDI HIPAA transactions.
- I was focused on maintaining, and optimizing the existing databases monitoring database performance and growth, performance tuning, to create reports according to the business requirement using PowerBI and populate data warehouse using SQL Server Integration Service (SSIS).
- Strong knowledge and experience in error handling of SSIS packages using transactions, check points (package restart ability features), break points and error logging procedures.
- Involved in retrieving multi-million records for data loads using SSIS and by querying against Heterogeneous Data Sources like SQL Server, Oracle, Text files and some Legacy systems.
- Used configuration files and variables to deploy SSIS packages across several Environments (Development/Testing).
- Responsible for coding SSIS processes to import data into the Data Warehouse from Excel spreadsheets, Flat Files and OLEDB Sources.
- Designed and developed datawarehouse and ETLs in an Agile working environment.
- Using best practices of ETL, extract entity-based staging database view for transforming data and loading bulk data to dimension and fact in reduce time in SSMS using SSIS and T-SQL.
- Scheduled the SSIS jobs using SQL server agent for daily, weekly and monthly loads.
- Experience in managing and automating Control flow, Data flow, Events and Logging programmatically using Microsoft .NET framework for SSIS packages.
- Worked on SSIS Package,DTS Import/Export for transferring data from Database (Oracle,Teradata(EDW),CRM and Text format data) to SQL Server.
- Used Microsoft PowerBI,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.
- Used PowerBI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports.
- Extensively involved and was part of the team in developing reports in PowerBI .
- Made changes to the existing Power BI Dashboard on a regular basis as per requests from Business.
- Managed relationship between tables in PowerBI using star schema.
- Create PowerPivot models and PowerPivot reports, publish reports onto SharePoint, and deploy models into SQL Server.Create Parameterized SSRS Reports and PowerPivot Workbooks using data of Tabular model and Cube data model to prove the functionality of database.
- Created MDX queries to retrieve data from the cube and also to display SSRS reports.
- Developed Linked, Drill Down, Drill Through and SubReports using SSRS.
- Developed Data Driven Subscription Reports and Ad-Hoc Reports using Report Builder in SSRS.
- Create reports in PowerBI preview portal utilizing the SSAS Tabular via Analysis connector.
- Migrated existing self service reports and Adhoc reports to Power BI.
- Used Team Foundation Server(TFS) and SVN for source control and Sprint Planning.
- Developed automated monthly,weekly,daily SSIS packages to generated Adhoc reports through TIDAL.
Environment: SQL,T-SQL,SQL Server2014, 2016,Visual Studio 2015(SSIS,SSRS,SSAS),PowerBI,MS Excel 2010,.NET Framework, C#,TFS,SVN,Teradata,ServiceNow
Confidential, Dayton, OH
SQL/MSBI/PowerBI Developer
Responsibilities:
- Utilized PowerBI features to build complex dashboards and visualizations with multiple graphs and charts that analyzed the revenues of hospital.
- Worked on PowerBI to create dashboards, and published them for end users.
- Gathering Requirements from the Business Users and developing the work flows.
- Created and Modified T-SQL stored procedures/triggers to validate integrity of the data.
- Created reports to generate them through Email for the administrative using MDX Queries.
- Designed SSIS packages to migrate the data from DB2, flat files, excel documents and CVS files to the Staging Area in SQL Server.
- Expertise in Using different Transformations like Lookups, Derived Column, Merge Join, Fuzzy Lookup, For Loop, For Each Loop, Conditional Split, Union all, Script component etc.
- Expert in Creating, Implementing, Configuring and deploying the SSIS Packages from one server to other.
- Worked on Huge Data Transfers from and to SQL Server Databases using SSIS, and used Configuration Files and Environment Variables for production deployment.
- Developed drill down and drill through reports from multi-dimensional objects like Star and Snow Flake Schema using SSRS and performance point server.
- Involved in Performance tuning of ETL transformations, data validations and stored procedures.
- Used various sources to pull data into Power BI such as SQL Server,Oracle, SQL Azure etc.
- 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.
- Implemented several DAX functions for various fact calculations for efficient data visualization in PowerBI.
- Explore data in a Variety of ways and across multiple visualizations using PowerBI.
- PowerBI/SSRS reports are used for creating Dashboards, drilldown reports, Scorecards.
- Scheduled and monitored SSRS report subscription and deliveries such as Email Delivery and File Share Delivery as required.
- Developed and maintained SSIS packages, SQL jobs and SSRS reports.
- Design views to enable reporting.
- Developed reports using global variables, expressions and functions using SSRS.
- Developed User Interactive Sheets & Reports as per business needs in SSRS.
- Developed and supported SSRS reports for various business units and Optimization of Program Metrics report, Statistical Reports and Demographics reports
- Designed and developed a full-scale BI reporting solution using SSRS.
- Created calculated measures using MDX implementing business requirement
Environment: T-SQL, MS SQL Server 2014/2016, SSDT(SSIS, SSRS,SSAS) 2012/2015,Oracle 11g,VB.Net, C# script, PowerBI.
Confidential, Bloomington, MN
SQL/SSIS/SSRS/Data warehouse Developer
Responsibilities:
- Primary role to provide data modelling duties for the development and maintenance of tables (Fact, Dimension, Reference), views, stored procedures in a dimensional Enterprise Data Warehouse (EDW) and Enterprise Reporting.
- Involved in all phases of Data warehouse development cycle.
- Wrote SQL queries to creating Stored Procedures, triggers, function, tables, and other SQL joins and statements for applications.
- Devleoperd ETL staging area models,define and develop data modeling, data naming,data model management and best practices standards documents.
- Created MDX queries to extract data from the Data Mart.
- Participated in gathering User Requirements and System Specifications.
- Strong knowledge of Star schema, Snow flake schema in dimensional modeling and their usage in different data modeling design.
- Create SSIS Package according to the business requirement to process claims and policy information into database.
- Created SSIS package to find exceptions after loading claims and wins file into SSIS, then email the file to different team member
- Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
- Deploy SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
- Responsible for creating Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints Views, Stored Procedures, Triggers, Rules.
- Created functions and developed procedures to implement application functionality at the database side for performance improvement.
- Created packages and scheduled them in SQL Agent jobs to get data from OLTP.
- Created SSIS package to get data from different sources, consolidate and merge into one single source.
- Created ETL package for data conversion using various transformations tasks.
- Created Cubes from which data can be retrieved rapidly by enterprise information consumers.
- Created dash board to show the business performance.
- Created datasets for reports using T-SQL and stored procedures.
- Responsible for maintaining cubes using SSAS and populate the cubes with the data.
- Responsible for Query optimization and Performance tuning.
Environment: SQL Server 2012,2014.NET Framework, XML, T-SQL,VisualStudio(SSIS,SSRS,SSAS)2012,Windows 2008 Advance Server,ASP,C#, MS Excel,MS Access.
Confidential, Brooklyn, NY
SQL- SSIS/SSRS/SSAS Developer
Responsibilities:
- Designed application that collects client transaction volumes for WSS Custody and Sub-Custody products, applies unit costs, and produces a monthly export to the T&SS Costing system (CIIS).
- Created Volume Automation to enable import and maintain unit costs and other reference data, as well as providing summarized MIS reports for administrative/integrity purposes.
- Developed Stored Procedures, functions and database triggers and maintained referential integrity and implemented complex business logic.
- Created and executed SQL Server Integration Service packages to populate data from the various data sources, created packages for different data loading operations for many applications.
- Created SSIS Packages using SSIS Designer for exporting heterogeneous data from OLE DB Source, Excel Spreadsheet to SQL Server.
- Migrated DTS packages to SSIS packages and modified the packages with new features of SQL SSIS.
- Experience in ETL tools like DTS/SSIS for data flow from one source files like Excel, Tables, and Views to other databases or files with proper data mapping and data cleansing
- Writing DTS / SSIS packages for loading the data (100 million records) from source to target as per the requirement.
- Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
- Converted all the reports form SSRS 2008R2 to SSRS 2012 and maintained all the updated versions in TFS.
- Created reports in SSRS with different type of properties like chart controls, filters, Interactive Sorting, SQL parameters etc.
- Created perspectives in SSAS and configured security levels for the Cubes.
- Designed KPI’s in SSAS and imported them to Excel.
- Built MDX queries and Data Mining Expression (DMX) queries for Analysis Services & Reporting Services.
- Involved in Tabular Data warehouse and DAX operations for SSAS 2012 and 2008 OLAP databases.
- Designed Dimensional Modeling using SSAS cubes for End-User. Created Hierarchies in Dimensional Modeling.
- Backing up, restoring system & other databases as per requirements, and also scheduled those backups.
- Used SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
Environment: SQL Server 2014,SSIS (2012),SSRS (2012),SSAS (2012),Visual Studio 2012, MS Excel 2007.NET Framework VB.Net, ASP.Net,C#
Confidential
SQL Server/BI Developer
Responsibilites:
- Interacted with Team and Analysis, Design and Develop database using ER Diagram, involved in Design, Development and testing of the system.
- Developed SQL Server Stored Procedures, Tuned SQL Queries (using Indexes).
- Created Views to facilitate easy user interface implementation and Triggers on them to facilitate consistent data entry into the database.
- Designed and created SQL Databases, tables, indexes, and views, User Defined Functions, Stored Procedures, and Triggers to support business applications.
- Developed the packages with monitoring features and logging so that audit information of the packages and their execution results are loaded in to the audit table.
- Created SSIS packages to automate the ETL process included meta data on record count,file size and run time.
- Designed SSIS packages to Extract,Transfer,Load (ETL) existing data into SQL server from different environments for the SSAS cubes.
- Wrote and edit SQL Queries for data base testing and report verification.
- Developed SQL Server reports (SSRS) on daily performance of databases using SQL Server Reporting Services.
- Worked on client requirement and wrote Complex SQL Queries to generate Reports.
- Worked with various business groups while developing their applications, assisting in database design, phasing from development to QA and to Production environment.
- Used DDL and DML for writing triggers, stored procedures, and data manipulation.
- Tuned and Optimized SQL Queries using Execution Plan and SQL Profiler.
- Worked on Documentation using MS word.
Environment: : Windows Server, SQL Server 2010, SSIS,SSRS-2008, Query Analyzer, Enterprise Manager, Import and Export, SQL Profiler,MS Excel.