Ssis/ssrs/ssas/power Bi Developer Resume
Los, AngeleS
SUMMARY:
- Over 8 years of Database Design and Development experience on SQL server 2016 / 2014 / 2008 & SQL Server 2000 in OLTP and OLAP environment.
- Expertise in generating reports using SQL Server Reporting Services (SSRS) 2014/ 2008/2005 .
- Experience in configuration of report server and report manager scheduling, give permissions to different level of users in SQL Server Reporting Services (SSRS)
- Expert in Ad - hoc reports, drill down and drill through reports, sub reports and cross tab reports.
- Expert in creating Dashboards and using several types of Gauges .
- Expert in creating SSRS reports using Bar charts, Line charts, Pie charts.
- Created reports in Tableau and qlikview.
- Experience in developing and monitoring SSIS Packages and DTS packages.
- Hands on Experience in installing, configuring, managing, monitoring and troubleshooting SQL Server 2012/ 2008/2005
- Experience in implementing Change Data Capture and Table partitioning
- Designed and created OLAP cubes (SSAS) on data warehouse.
- Designed and developed SSIS ETL/ELT Packages (SSIS 2008/2014/2016 ).
- Designed a partitioning strategy to refresh cubes effectively.
- Expertise with T-SQL in writing complex queries, triggers, tables, user functions, views, indexes, user profiles, relational database models, data dictionaries, and maintaining data integrity.
- Experience in using tools like SQL Profiler, Index Tuning Wizard, Windows Performance Monitor for monitoring and tuning MS SQL Server performance
- Experience with the .NET framework including C#, ASP.NET , SharePoint and Web Service.
- Working Experience in designing, implementing, maintaining, and documenting complex database applications, and data warehouse in financial environments
- Extensively used tools like SQL Profiler, Index Tuning Wizard, Windows Performance Monitor for monitoring and tuning MS SQL Server performance.
- Experience in creating Jobs, Alerts, SQL Mail Agent, and schedule DTS Packages.
- Flexible, enthusiastic and project oriented team player with excellent written, verbal communication and leadership skills to develop creative solutions for challenging client needs.
- Highly proficient in packages to extract, transform and load data (ETL) using SSIS, designed packages which are utilized for tasks and transformations Data Conversion and Pivot tables.
- Highly proficient in creating data sources, data source views, dimensions, measures, measure groups, perspectives, partition aggregations. Analysis and Reporting Services, MDX queries, OLAP Cubes, and deployment and processing SSAS objects.
- Expert in all the Latest BI Tools Tableau , Power BI Dashboard Design .
- Experience in Azure PAAS, IAAS
TECHNICAL SKILLS:
RDBMS: MS SQL Server 2016/2014/2012/2008, Oracle 8i/9i, MS Access.
Database Tools: SSIS, SSAS, SSRS, Enterprise Manager, Query Analyzer, SQL Profiler, Management Studio, SharePoint 2007, COGNOS 6.5/7.0, Crystal Reports 9.0/10, Power BI, Tableau Reports
Programming Languages: SQL, TSQL, VB.NET, XML, C++, VB 6.0
Scripts: JavaScript, VBScript, HTML, DHTML and XML
MS: Front Page, Macromedia Suite, IIS, Outlook Express
Applications: Microsoft Office, Visio, and Visual SourceSafe
Operating Systems: Windows 9x/NT/2000/XP. Unix
PROFESSIONAL EXPERIENCE:
Confidential, Los Angeles
SSIS/SSRS/SSAS/Power BI Developer
- Designed and Developed new SSAS Multidimensional Models .
- Worked on MDX Queries to pull the data from the SSAS Cubes for the reporting purposes.
- Create SSAS Tabular Model and SSAS Multidimensional Model and support the existing database components.
- Designed and Developed new SSAS Tabular Models and used DAX expressions/formulas for creating calculated measures and columns.
- Create reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector.
- Developed and published reports and dashboards using Power BI and written effective DAX formulas /expressions.
Confidential, Los Angeles
SSIS/SSRS/SSAS/Power BI Developer
- Worked on creating Stored Procedures for reports and for other applications.
- Worked on performance tuning to optimize stored procs.
- Checking Execution plans and optimizing stored procs.
- Created appropriate indexes to increase the performance of queries and stored procs.
- Designed and developed databases for OLTP and OLAP Applications.
- Gather requirements and design of data warehouse and data mart entities.
- Designed and developed SSIS ETL/ELT processes (SSIS 2008/2014).
- Designed and Developed new SSAS Tabular Models.
- Worked on several types of SSIS control tasks like WMI data task, Script task, Ftp task to upload and download files, worked with several types of connection managers like file connection manager, flat file connection manager, cache connection manager, ftp connection manager and data quality connection services manager. Also, used XML task to validate XML files and XSLT for generating html pages from XML.
Confidential, Orlando, FL
SSIS/SSRS/SSAS/Power BI Developer
- Worked on creating Stored Procedures, Triggers, Functions, Indexes, Tables, Views for applications.
- Gather requirements and design of data warehouse and data mart entities.
- Created dimension and measure objects according to business requirements.
- Designed and developed databases for OLTP and OLAP Applications.
- Implemented ETL process to import Google Analytics data and Google AdWords data into Data warehouse system.
- Implemented ETL process to download files by email attachments and import data into Data warehouse system through SSIS packages.
- Optimized performance of various SQL scripts, stored procedures and triggers by using embedded UDFs, CTEs and System stored procedures.
- Worked on data modeling and ensured proper relationships by supporting all the requirements.
- Worked on several types of SSIS control tasks like WMI data task, Script task, Ftp task to upload and download files, worked with several types of connection managers like file connection manager, flat file connection manager, cache connection manager, ftp connection manager and data quality connection services manager. Also, used XML task to validate XML files and XSLT for generating html pages from XML.
- Worked on various kinds of transformations in SQL Server Integration Services (SSIS) like Term Lookup, Merge, Derived column, Cache transform, DQS cleansing, Term extraction, Aggregate, Character map, Pivot and Un Pivot, for each Loop Container, Execute SQL Task.
- Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports and Dashboards.
- Designed SSRS reports with sub reports, expressions and queries, and prepared Ad-Hoc reports through report builders.
- Implementing SSRS solutions, used dashboards and gauges to enhance for the business users.
- Worked on MDX Queries to pull the data from the SSAS Cubes for the reporting purposes.
- Create SSAS Tabular Model and SSAS Multidimensional Model and support the existing database components.
- Implemented projects using Agile Methodology.
Environment: SQL Server 2008/2014/2016, SSRS 2016/2014/2008, SSIS 2008,2014,2016 SSAS, Power BI, T-SQL, Crystal Reports, SharePoint 2007, T-SQL, ODBC, Excel, Access, Windows 2000/XP
Confidential, Jacksonville, FL
SSIS/SSRS/SSAS/Power BI Developer
Responsibilities:
- Upgraded database tables from 2008 to 2014.
- Worked on creating Stored Procedures, Triggers, Functions, Indexes, Tables, Views for applications.
- Created dimension and measure objects according to business requirements.
- Assisted in data analysis, star schema data modeling and design specific to data warehousing and business intelligence environment.
- Designed and developed databases for OLTP and OLAP Applications.
- Optimized performance of various SQL scripts, stored procedures and triggers by using embedded UDFs, CTEs and System stored procedures.
- Extensively worked on Table Design creating Clustered Indexes, NonClustered Indexes, Primary key Foreign Key Relationships, Highly complex joins and SQL Scripts for Views and Materialized Views.
- Implemented Change Data Capture and Table partitioning on data warehouse and DataMart systems.
- Worked on several types of control tasks of SSIS like WMI data task, Script task, Ftp task to upload and download files, worked with several types of connection managers like file connection manager, flat file connection manager, cache connection manager, ftp connection manager and data quality connection services manager. Also, used XML task to validate XML files and XSLT for generating html pages from XML.
- Worked on various kinds of transformations in SQL Server Integration Services (SSIS) like Term Lookup, Merge, Derived column, Cache transform, DQS cleansing, Term extraction, Aggregate, Character map, Pivot and Un Pivot, foreach Loop Container, Execute SQL Task.
- Designed and developed SSIS ETL/ELT processes (SSIS 2008/2014/2016 ).
- Converted SSIS packages from 2008 to 2014 and 2016.
- Designed and implemented ETL processes for clients based on change tracking for full and incremental data.
- Discuss and finalize requirements from business users for designing efficient ETL processes.
- Extensively worked on Design and development of SSIS (ETL) packages to extract, transform and load data from various sources like Excel files, flat files to the Data warehouse using different tasks and transformations like File System Task, Data Flow Task, Derived Columns, and Execute SQL Task.
- Created package configuration in XML and used to deploy packages into SQL server, Identified the Issues that occur during the package execution by redirecting the rows from source component to error output.
- Designed and Developed new SSAS Tabular Models and used DAX expressions/formulas for creating calculated measures and columns.
- Create reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector.
- Developed and published reports and dashboards using Power BI and written effective DAX formulas /expressions.
- Used Power BI Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports.
- Imported data from various sources like csv, excel and directquery to sql server/analysis database and used good visualizations and industry standards for creating Power BI reports and dashboards. And implemented Row-level security (RLS).
- Configuring Power BI Gateway for SSAS Live connection.
- Used Power BI Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports.
- Developed reports using Tableau and qlikview.
- Developed, scheduled and generated variety of reports like List, Matrix, Drill-Down, Chart and Sub Report and standardize company report by implementing SQL Server Reporting Services.
- Developed reports in Tableau, Crystal and converted Crystal reports in to SSRS reports.
- Experience in strong SQL debugging skills, application level troubleshooting skills.
- Create SSAS Tabular Model and SSAS Multidimensional Model and support the existing database components.
- Write SQL queries in SQL Server databases to validate data entered by service methods and to setup data for testing scenarios.
- Worked on OLAP Data warehouse, Model, Design, and Implementation.
- Designed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measures groups and KPIs to analyze performance of Strategic Business Units as well as corporate centers. Implemented partitioning on measure groups.
- Querying and manipulating multidimensional cube data through MDX Scripting in SSAS .
- Created standard report Subscriptions and Data Driven Report Subscriptions.
- Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
- Implemented projects using Agile Methodology.
Environment: SQL Server 2008/2014/2016, SSRS 2016/2014/2008, SSIS 2008,2014,2016 SSAS, Power BI, T-SQL, Crystal Reports, SharePoint 2007, T-SQL, ODBC, Excel, Access, Windows 2000/XP
Confidential, Cleveland, OH
SSAS/SSIS/SSRS/SQL Developer
Responsibilities:
- Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports and Dashboards.
- Designed SSRS reports with sub reports, expressions and queries, and prepared Ad-Hoc reports through report builders.
- Implementing SSRS solutions, used dashboards and gauges to enhance for the business users.
- Worked on MDX Queries to pull the data from the SSAS Cubes for the reporting purposes
- Worked on Development and implementation of SSRS reports and ran them as per the requirement.
- Created gauges and used gauges as Key Performance Indicators.
- Created complex stored procedures and user defined functions, created many cascaded parameters in the reports using MDX and SQL queries.
- Created efficient, robust SSIS packages for data movement and loading with error checking and well documented code.
- Created SSIS Packages to integrate data coming from Text files and Excel files.
- Created SSIS packages to validate, extract, transform and load data to data warehouse.
- Experience with SSIS performance tuning using counters, error handling, event handling, re-running of failed SSIS packages using checkpoints and scripting with C# and VB.NET in SSIS.
- Extensively worked on the packages created including a variety of transformations, for example Slowly Changing Dimensions, Lookup, Aggregate, Audit, Conditional Split, Merge join, Multi Cast, Pivot, OLE DB Command, Sort, Union All, and Copy Column, Derived Column using SSIS .
- Worked on various kinds of transformations in SQL Server Integration Services (SSIS) like Term Lookup, Merge, Derived column, Cache transform, DQS cleansing, Term extraction, Aggregate, Character map, Pivot and Un Pivot, foreach Loop Container, Execute SQL Task.
- Developed and Optimized Stored Procedures, Views, and User-Defined Functions for the Application.
- Sound Experience and understanding of SSAS, OLAP and OLTP cube, Data mining and Architecture.
- Generated daily, weekly and monthly reports for the managers.
- Developed Multi-Dimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services.
- Designed a partitioning strategy to refresh cubes effectively.
- SSAS cube development in both SQL 2005 and 2008 for financial planning and operational performance metrics.
- Extracted data using SSIS from OLTP to OLAP. Based on the required reports, identified various data sources and established the connections using SSIS and constructed data source view.
- Designed and implemented data access stored procedures and triggers for automating tasks and job scheduling.
- Implemented SSIS data transformation scripts, created maintenance procedures and provided data integrity strategies.
- Implemented Logging and Event Handlers on SSIS packages for trouble shooting application.
- Created several cubes in SSAS and build lot of MDX queries to retrieve data from cubes.
- Involved in writing MDX queries and performance optimization of the SSAS cubes
- Identified and defined Fact relationships. Maintained and deployed OLAP Cubes in SSAS.
Environment: SQL Server 2005/2008/2014, SSRS 2014/2008/2005, SSIS 2005/2008, SSAS, T-SQL, Crystal Reports, T-SQL, Excel, Access, Windows 2000/XP
Confidential, Des Moines, IA
SSAS/SSIS/SSRS/SQL Developer
Responsibilities:
- Upgraded database tables from 2000 to 2005 and 2008.
- Designed and developed databases for OLTP and OLAP Applications.
- Created complex Stored Procedures for data retrieval.
- Created SSIS Packages using Pivot Transformation, Execute SQL Task, Data Flow Task, etc. to import data into the data warehouse.
- Created SSIS packages to transfer data across heterogeneous data sources.
- Developed, scheduled and generated variety of reports like List, Matrix, Drill-Down, Chart and Sub Report and standardize company report by implementing SQL Server Reporting Services.
- Created dashboards and scorecards using Dundas charts.
- Created standard report Subscriptions and Data Driven Report Subscriptions.
- Experience in strong SQL debugging skills, application level troubleshooting skills, Experience with monitoring tools and techniques, good understanding of security Practices.
- Optimized performance of various SQL scripts, stored procedures and triggers by using embedded UDFs, CTEs and System stored procedures.
- Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
- Created several cubes in SSAS and build lot of MDX queries to query cubes.
- Tested the data with complex queries, joins and sub queries.
- Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
- Extensively used SSIS transformations such as Lookup, Derived column, Data Conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
- Created SSIS packages for File Transfer from one location to the other using FTP task.
Environment: SQL Server 2005/2008/2014, SSRS 2008/2005, SSIS 2005/2008, SSAS, T-SQL, Crystal Reports, SharePoint 2007, T-SQL, ODBC, Excel, Access, Windows 2000/XP
Confidential, Pittsburgh, PA
SSAS/SSRS/SSIS/SQL Developer/ DBA
Responsibilities:
- Provided support to 75 database Servers. Support included Production, QA and Development
- Worked on Migration from SQL Server 2000 to 2005
- Installed SQL Server 2000/2005 on Stand Alone and Clustered Environments on Windows 2000/2003
- Wrote complex T-SQL Scripts for generating reports
- Wrote stored procedures and designed triggers
- Scheduled Backups of databases and recovered them periodically to verify integrity of Backups
- Worked in evaluating various high availability technologies such as Log Shipping, Clustering and Database Mirroring.
- Involved in performance tuning issues by running Profiler Trace and analyzing the output
- Ensured Security by defining access control to data
- Generated reports using SSRS
- Designed and developed DTS packages for data import and export
- Configured Linked Servers
- Worked on OLAP and OLTP
- Interacted with development and testing team
- Importing and exporting of Databases using various techniques like BCP, DTS
- Analyzed and Installed Security patches as required.
Environment: SQL Server 2000/2005, .NET Framework, ASP.NET, ADO.NET, WINDOWS 2000/2003
Confidential
SQL Developer
Responsibilities:
- Implemented the database for production and marketing purpose.
- Designed databases for OLTP applications
- Created tables, indexes and constraints.
- Created Triggers, Stored procedures for implementing the business logic.
- Managed Database files, transaction log and estimated space requirements.
- Configured and monitored database application.
- Designed and implemented several complex reports
- Designed VB forms using the forms and crystal reports were made for business reporting purpose.
- Created stored procedures for module integrity and application.
- Wrote database triggers in T-SQL to check the referential integrity of the database
- Managed ongoing activities like importing and exporting, backup and recovery.
Environment: SQL server 2000, Visual Basic 5.0, Win NT.