Sql Bi/ssis Developer Resume
Des Moines, IowA
SUMMARY
- 9 years of strong IT industry experience as a MS SQL Server 2014/ 2012/ 2008 R2/ 2008/ 2005, Data Warehouse Developer/BI Developer in various domains. Maintained positive communications and working relationship at all levels.
- Worked on automating the SSRSwork flows as per the day to day transactions.
- Experience in developing the applications usingT - SQL Programming (DDL, DML, and DCL).
- Conversant with various phases of Software Development life cycle (SDLC) including development, designing, analysis, coding, testing and implementation.
- Proficient with SQL Analysis Services 2008/2012 such as, building multi-dimensional cubes, Dimensions, fact tables, Hierarchies, levels, roles, performed drill-up, drill-down, and drill-through and applying cube security.
- Wrote Multidimensional Expression (MDX) queries to extract data from cubes.
- Extensive experience in MS SQL Server 2012/2008R 2/2008/2005/2000 , BI tools like SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS).
- Highly Proficient in developing SSIS Packages to Extract, Transform and Load (ETL)/DTS data into the Data warehouse from Heterogeneous data sources such as Oracle, DB2, MS Excel, MS Access, CSV, Oracle, flat file.
- Proficient in creating, configuring and fine-tuning ETL workflows designed in DTS and MS SQL Server Integration Services (SSIS).
- Proficient in assortment of technologies including PowerShell, Windows OS, Mysql.
- Proficient in full life cycle design and development of Business Objects reporting Applications.
- Strong understanding ofdata warehousing concepts, OLTP, OLAP, Visual studio in CSharp, Normalization, Star and Snow Flakedata models.
- Worked on non relational database.
- Environment Windows OS Professional, Visual Studio 2010, 2013 with bundled resources and tools, Team Foundation Server, scripting languages including python &PowerShell.
- Developed OLAP cubes using SSAS (SQL Server Analysis Services) and calculate the metrics that were revealed in the functional analysis.
- Expert in writing parameterized queries for generating tabular reports, formatting report layout, sub-reports using global variables, subtotals, expressions, functions, sorting the data, defining data sources for the reports using SSRS.
- Experience in training developers and advising technical groups on reporting best practices.
- Flexible and versatile to adapt to any new environment with a strong desire to keep pace with latest technologies.
- Created SSRSReport Model Projects in BI studio and created, modified and managed various report models with multiple model objects, source fields and expressions.
- Experience in Visual studio in Csharp db.
- Excellent problem solving, communication, analytical, interpersonal skills and ability to perform independently or as part of a team.
TECHNICAL SKILLS
Languages: SQL, MS SQL, Transact SQL, C, C#, Java, HTML 4.0,CSharp, Embedded SQL, PL/SQL, XML.
Databases: SQL Server 2012/2008 R 2/2008/20005 , Oracle 9i/8.x, DB2 MS Access
Reporting Tools: SQL Server Reporting Service (SSRS), Tableau, Crystal Reports XI/10/9, Non relational database.
ETL Tools: SSIS (SQL Server Integration Services), DTS (Data Transformation Services), Import Export Data, Bulk Copy Program (BCP), Informatica 8.6.1, BIDS.
Other Software: MS Office- 2010/2007, Adobe Professional, Windows OS.
Operating Systems: Windows OS/2003/XP, Agile
Database Tools: SQL Query Analyzer, SQL Enterprise Manager, Management Studio, SQL Server 2008 Query Editor, SQL Server Analysis Services (SSAS), TOAD
Methodologies: Logical and Physical Database Design, non-relational database, Database Design and Normalization, Data Modeling.
PROFESSIONAL EXPERIENCE
Confidential, Des Moines Iowa
SQL BI/SSIS Developer
Responsibilities:
- Designed and developed packages for data warehouse using Integration services (SSIS) in BIDS.
- Hands-on experience on the various facets of the Hyperion Performance Suite.
- Managed the Reports by providing the access permissions to various report users like Admin/Report users/Browser Etc.
- Involved in implementing package configuration in SSIS packages that allowed transferring packages from one environment to other.
- Involved in scheduling SSIS packages to run on routine basis and monitor the error log for any errors.
- Involved in C# coding developing SSIS Packages. Created SQL Scripts for data loads and upgrades for data migrations and data validations.
- Developed and maintained multiple Power BI dashboards/reports and content packs.
- Responsible for building Power BI Dashboards using Tabular and Multi-Dimensional Models. Design and model data sets with Power BI desktop based on measure and dimension requested by customer and dashboard needs.
- Created POWER BI Visualizations and Dashboards as per the requirements.
- Used various sources to pull data into Power BI such as SQL Server, Excel, Oracle, SQL Azure etc.
- Developed and scheduled DTS packages for each system Interface using SQL code in combination with VB ActiveX scripts and built-in DTS transformations.
- Worked on Data Driven Subscription Tables for Quarterly Reports, Monthly Reports as well as Daily Reports.
- Responsible for Hyperion Admin works.
- Created Tvf’s to migrate the data from Hyperion to EDI Reports.
- Created Stored Procedures and Worked with Configuring the SSIS packages using XML & and SQL Server type configurations when the finalized ETL packages are need to be moved onto the Production box.
- Worked with Deploying the SSIS packages using SQL Server package deployment wizard to deploy the packages on the production server.
- Developed the SQL Agent Jobs in order to schedule the ETL packages on a scheduled basis.
- Trained the Line of Business people.
- Designed and developed packages for data warehouse using Integration services (SSIS) in BIDS.
- Planned and developed account migration process for a multi-domain e-mail migration from internal and external AD domains running Exchange 2003/2010 to Google Apps Mail. Migration scripts developed with PowerShell..
- Involved in claim adjudication process of facets application.
- Regular responsibilities for updating and staging the dimensional databases as well as rebuild the Dimensions and cubes in Analysis Services.
- Created SSRSReport Model Projects in BI studio and created, modified and managed various report models with multiple model objects, source fields and expressions.
- Worked on different Tools in MS e.g.Powershell.
- Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
Environment: SQL Server 2014/2012/2008 R2 Enterprise Edition, Hyperion, FACETS, DTS packages, Visual studio 2012/2010, SSAS, SSIS, T-SQL, SSRS, ERWIN, Oracle 9i/10g, Agile.
Confidential, Baltimore, MD
SQL BI Developer
Responsibilities:
- Involved in creating SSRS reports from Different Databases like Oracle, Hyperion and SQL Server.
- Involved in Database modeling, ETL and creation of analytical processes, responsible for translating the Business requirements into technical specifications in business intelligence development studio(BIDS).
- Worked on configuring and deploying SSRS reports onto Microsoft Office SharePoint Server.
- Experience of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables using MS Analysis Services.
- Experience in using XMLA protocol for SQL Server Analysis Services 2008 for interaction between client application and instance of Analysis Services.
- Worked with SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models.
- Designed & Developed multi-threaded SQL CLR SP's Services to execute Data Load Task and basket creation process.
- Update SPs / CUs using PowerShell scripts and troubleshoot Exchange 2010 related issues in server 2012 R2 / 2008 R2 virtualized environment as well as granular level restores when required.
- Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent in BIDS.
- Worked in Agile Scrum Methodology with daily stand up meetings and great knowledge in TFS (Team Foundation Server) 2010.
- Created OLAP models based on Dimensions and Facts for efficient loads of data.
- Enhanced the functionality in database and data warehousing concepts (OLAP, OLTP) Cube by creating KPI, Actions and Perspective using SQL Server Analysis Services 2008(SSAS).
- Worked with T-SQL to create Tables, Views, and triggers and stored Procedures.
- Designed and developed web pages using C#,MVC 3.0 and VS.Net..
Environment: SQL Server 2015/ 2014/2012/2008 R2 Enterprise Edition, DTS packages, Visual studio 2012/2010, SSAS, SSIS, T-SQL, SSRS, Agile.
Confidential - Peachtree, GA
SQL BI Developer
Responsibilities:
- Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports.
- Writing queries to generate reports for analysis of data using SQL Server Reporting Services (SSRS), Report Builder.
- Generated Reports using Global Variables, Expressions and Functions for the reports in SSRS.
- Created SQL Scripts for data loads and upgrades for data migrations and data validations.
- Developed and scheduled DTS packages for each system Interface using SQL code in combination with VB ActiveX scripts and built-in DTS transformations.
- Developed reports by using SSRS and deployed them on web pages using ASP.NET using C#.
- Wrote custom tasks using C# within SSIS to enhance processing of both Excel and flat-files into SQL Server in Business intelligence studio (BIDS).
- Created very complex SSIS Packages with considering all the best practice like error handling, logging, configurations, deployments, and maintenance.
- Created schemas, keys and indexes considering the granularity of the data
- Iteration planning for new features and user stories in Agile Development methodology.
- Deployed SSIS packages and Reports to Production Servers.
- Worked on EIB Templates.
Environment: SQL Server 2012/2008 R2, SSIS, SSRS, DTS packages, Visual studio 2010/2008, Window 7 Professional, Agile.
Confidential - Weehawken, NJ
Database Developer
Responsibilities:
- Developed the SSIS ETL packages, which will take the data from various sources like Oracle 8i, Flat files, Excel and XML files and will perform the appropriate transformations over the data and will load the data onto targeted SQL Server Data mart.
- Worked with Data conversions, Merge Join tasks, and look up transformations, Execute SQL Task, OLEDB Command Task and Sequence containers and for Each Loop containers in the package development.
- Worked with Configuring the SSIS packages using XML & SQL Server type configurations when the finalized ETL packages are need to be moved onto the Production box.
- Worked with Deploying the SSIS packages using SQL Server package deployment wizard to deploy the packages on the production server.
- Developed the SQL Agent Jobs in order to schedule the ETL packages on a scheduled basis.
- Migrated SAP BO Crystal reports 10 to SQL Server Reporting Services 2008 R2
- Developed the SSRS reports by pulling the data from the Data mart by the extensive use of stored procedures and cursors.
- Worked with the parameterized reports and enabled the reports with the Drill-down features by using the matrix and table data viewers.
- Rendered the reports into various formats like PDF, CSV, Excel etc.
- Worked with Configuring the SSRS Report Manager and Report Server and generating the Web URL for the Report Server and creating the Virtual directory for the Report Server where the deployed reports would be stored as a repository.
- Managed the Reports by providing the access permissions to various report users like Admin/Report users/Browser Etc.
Environment: MS SQL Server 2008 R2/2008, Visual studio Management Studio 2008, SSIS, SSRS, T-SQL, MS Access, Windows Server 2008.
Confidential
SQL BI Developer
Responsibilities:
- Participated in gathering Business Requirements and System Specification from system users.
- Created and executed SQL Server Integration Service (SSIS) packages to populate data from the various data sources into the data warehouse
- Created SSIS Packages using SSIS Designer for importing heterogeneous data from OLE DB Source, Excel Spreadsheet, text files into Enterprise Data Warehouse.
- Various ETL Transformation tools were used for Control Flow and Data Flow tasks
- Experienced in creating reports (SSRS) in Drill mode using tables, matrix and charts in SQL SERVER 2008
- Designed and implemented Parameterizedand cascading parameterized reports using SSRS
- Involved in implementing package configuration in SSIS packages that allowed transferring packages from one environment to another environment
- Involved in scheduling SSIS packages to run on routine basis and monitor the error log for any errors.
- Involved in C# coding developing SSIS Packages.
- Involved in writing C# scripts using script task transformation to create multiple reports based on providence Insurance client's information.
- Created SSIS Packages using Script Task and various Shell scripts, C#, VB script in BIDS.
- Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA.
- Backing up, restoring system & other databases as per requirements, and also scheduled those backups.
- Developing stored procedures, triggers, views, and adding/changing tables for data load and transformation, and data extraction.
- Used SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
- Involved in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.
Environment: MS SQL Server 2008 R2/2008, Visul studio Management Studio 2008, SSIS, SSRS, T-SQL, MS Access, Windows Server 2008.
