We provide IT Staff Augmentation Services!

Sql Bi (ssis Ssrs)/ Tableau Developer Resume

Jacksonville, FL

PROFESSIONAL SUMMARY:

  • 5+ years of experience in the analysis, design, development, implementation, testing, maintenance, and documentation of Database and Client Server applications.
  • Experience in Logical &Physical Data modeling, data architecture designs.
  • Expert in Data Warehouse development starting from inception to implementation and ongoing support, Strong Understanding of BI application design and development principles
  • Excellent command with MS SQL Server 2016/ 2014/2012/2008 /2005 worked on Integration services (SSIS), Reporting services (SSRS) and Analysis services (SSAS).
  • Experience in ETL from & to SQL Server Databases using utilities / tools like DTS, SSIS, BCP, BULK INSERT also
  • Knowledge on other tools like Data stage and Proficient in data loading using PL/SQL
  • Analyzed the source data, Coordinated with Data Warehouse team in developing Relational Model. Designed and developed logical and physical models to store data retrieved from other sources including legacy systems.
  • Experienced in developing Data Mapping, Performance Tuning and Identifying Bottlenecks of sources, mappings, targets and sessions.
  • Perform tasks using PL/SQL, Data Pump and SQL LOADER.
  • Expert in Microsoft SQL Server 2016, 2014, 2012, 2008 and 2005 backend programming.
  • Designed and developed DS data flows and ETL components.
  • Outstanding skills in using Client/Server architecture in implementing MS SQL Server based applications.
  • Experience with Backup and Recovery of MS SQL 2016/ 2014/2012/2008 /2005 Server Databases.
  • Expert in creating SQL objects like Tables, Complex Stored Procedures, Triggers, Views, Indexes, and User Defined Functions to facilitate efficient data manipulation and consistent data storage.
  • In - depth knowledge of T-SQL (DDL and DML).
  • Experience in Database design, Development, Data Modeling, Administration, ETL packages using DTS / SSIS, Performance Tuning, Stored Procedures for Database applications using MS SQL Server 206/2014, 2012, 2008 R2, 2008, 2005
  • Proficient in implementing all transformations available on the SSIS toolbox.
  • Well experienced in SQL Server Management Studio, SQL Server Business Intelligence Development Studio, SQL Server Enterprise Manager, and SQL Query Analyzer.
  • Created packages using Integration Services (SSIS) for data extraction from Flat Files, Excel
  • Experienced in query optimization & performance tuning. Used SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands.
  • Experienced in SQL Server Management Studio, SQL Server Business Intelligence Development Studio, SQL Server Enterprise Manager, and SQL Query Analyzer.
  • Installed, configured and maintained SSRS server.
  • Experienced in creating ad-hoc reporting in SSRS.
  • Experienced in building Data Integration and Workflow Solutions and Extract, Transform, and Load (ETL) solutions for data warehousing using tools like SSIS import and export and SSIS packages.
  • Excellent in creating reports, dashboards, standardize templates setting up new parameters and implementing the reports in different process with writing observations, insights, recommendations in the reports
  • Expert in Data Visualization development using Tableau to create complex, and innovative dashboards. Notify admin team for changes in user, user groups, and scheduled instances for reports in Tableau reports.
  • Experience in reports validating and modeling data with the purpose of understanding or making conclusions from the data for decision making.
  • Functionality includes CGI Advantage Finance & HCM integrated with Info Advantage reporting, Neogov Recruiting & Applicant Management, and KRONOS Time & Leave.

TECHNICAL SKILLS:

Languages: T-SQL, PL/SQL, Dynamic SQL, MDX

Databases: MS SQL Server 2016/ 2014/2012/2008 R 2/2008/2005/2000

DWH/BI Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Business Intelligence Development Studio (BIDS), Visual studio 2015/2013 2012/2010/2008, Crystal Reports, Tableau 9.0/10.3, Info Advantage Reporting

Database Design Tools and Data Modeling: Star Schema/Snowflake Schema modeling, FACT and Dimensions tables, Physical and logical data modeling and De-normalization techniques, RDBMS, OLTP, OLAP

Packages: MS Office, Microsoft Office SharePoint Server (MOSS) 2007, Microsoft Performance Point Server 2007

Tools: SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Visual Studio, Microsoft Management Console, Visual Source Safe 6.0, DTS, Business Intelligence Development Studio (BIDS), Crystal Reports, Power Pivot, Microsoft Office, ALM

Operating Systems: Windows 2003/2000/VISTA/XP/7/8, NT & Windows 9x, MS-DOS

PROFESSIONAL EXPERIENCE:

Confidential, Jacksonville, FL

SQL BI (SSIS SSRS)/ Tableau Developer

Responsibilities:

  • Project is designed in two phase's data gathering and reporting, the data gathering part is done using SQL Server Integration Services (SSIS) and the reporting portion is built on SQL Server Reporting Services (SSRS) platforms.
  • Implemented Event Handlers and Error Handling in SSIS packages.
  • Developed SSIS packages to extract data from OLTP to OLAP systems and schedule the same as jobs using SQL.
  • Designed a dashboard for the business user using tableau and SSRS.
  • Included Medicaid and Commercial entities. Projects included claims and enrolment testing as well as NPI and medical coding and ICD-10 EDI testing.
  • Worked on Medicaid and Medicare and creating drilldown and drill through reports, Created SQL server reports using SSRS 2008 for manager, customer support and that can deliver at client's station, Designed different type of reports tabular, matrix (cross tab), conditional, list items, charts and sub reports.
  • Development of business rules and testing to implement HIPAA 5010 (EDI X12 837,834,278,270) in the new System.
  • Creating different reports based on queries and stored procedure, where created or modify stored procedures for reports in Waterfall Environment.
  • Involved in using Tortoise SVN to check in and check out SSRS reports and SSIS packages.
  • Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2012, Oracle and IBM DB2.
  • Ensured best practices are applied and integrity of data is maintained through security and documentation.
  • Implemented medium level complexity tabular and graphical time series and graphical reports.
  • Created packages using different transformations like pivot, condition split, fuzzy lookup, aggregate, merge join, execute SQL flow task, data flow task to extract data from different databases and flat files.
  • Extensively used views for complex joins queries involving multiple tables from different databases.
  • Experience in publishing reports, workbooks, data sources and dashboards to Tableau server in different Formats. Created complex data views manually using multiple measures, also used sort, Filter, group, Create Set functionality.

Environment: SQL Server 2008R2, DB2, TSQL, PL-SQL, HTML, XML, XSL, Tableau 9.0/10.3, MS Share Point, MS Dashboard, Waterfall methodology, SVN, GIT, Rally and Windows 2008 Server.

Confidential, Richmond, VA

SQL BI (SSAS SSIS SSRS) Developer

Responsibilities:

  • Analyzing and Establishing security features in SQL Server Reporting 2016 Environment.
  • Worked on Full life cycle development (SDLC) involving in all stages of development.
  • Involved in system study, analyze the requirements by meeting the client and designing the complete system.
  • Involved in designing technical specifications for building Data Warehouse.
  • Involved in project cycle plan for the data warehouse, analyzing the source data, deciding the exact data extraction, transformation, loading strategy & Dimensional modeling. Backup & recovery.
  • Developing reports using SQL Server Reporting Services in SSRS 2016. Creating various value sections in Parameters list, designing cascading parameters, matrix dynamics and more features in Reporting Service.
  • Used advanced features of T-SQL to design and tune T-SQL to interface with the Database and other applications in the most efficient manner and created stored Procedures for the business logic using T-SQL.
  • Worked on SQL Profiler, Tuning Advisor in SQL 2016 to increase the performance of the reports.
  • Developed SSIS packages to extract data from OLTP to OLAP systems and schedule the same as jobs using SQL
  • Server Agent.
  • Worked with report subscriptions in SSRS 2016 to send the weekly run automated reports to end users.
  • Worked with Report Snapshots
  • Develop complex MDX, Created Database Objects - Schemas, Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, Constraints and Roles.
  • Designed and developed OLAP using MS SQL Server Analysis.
  • Experience in Logical modeling using the Dimensional Modeling techniques such as Star Schema and Snow Flake Schema.
  • Use DAX (Data Analysis Expressions) functions for the creation of calculations and measures in the Tabular Models.
  • Created dimension model for reporting system by identifying required dimensions and facts using ERWIN.
  • Designed and developed data load jobs using SSIS package and scheduled in SQL Agent.
  • Created Grouping, Sorting columns and writing expressions per the business requirements.
  • Extensively worked with SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Lookup.
  • Wrote stored procedures and User Define Scalar Functions (UDFs) to be used in the SSIS packages and SQL scripts.
  • Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
  • Developed tabular queries for efficient analysis of report using PowerPivot/Unpivot in T-SQL.
  • Involved in developing Data Access Components to access the SQL Server Database using ADO.NET.
  • Created Cross-Tab, Drill-down, Drill-through and Sub drill down reports -Report using RDL. Promoted RDLs to Reporting Service Server.
  • Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including status.
  • Used Reporting Services (SSRS) to schedule reports to be generated on predetermined time.
  • Developed Cascading Reports for Employee Reports, Ad-hoc Reports using Report Builder, SQL server Reporting Services (SSRS) 2014/2012/2008
  • Created Database Maintenance plans for Full/Differential/Transactional backup Strategies and involved in database partitioning.
  • Created Data Warehouse Cubes in SQL Server Analysis Service (SSAS).
  • Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS.
  • Involved in Tabular Data warehouse and DAX operations for SSAS 2012 and 2008 OLAP databases.
  • Designed Dimensional Modeling using SSAS packages for End-User. Created Hierarchies in Dimensional Modeling.

Environment: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS),SQL Server Management Studio 2014, MS Visual Studio.NET# 2012/2015, TFS, GIT, Rally and Windows 2008 Server.

Confidential, Hermitage, PA

SQL Server BI Developer

Responsibilities:

  • Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional work flow of information from source systems to destination systems.
  • Created SSIS packages for Data Conversion using data conversion transformation.
  • Configured the loading of data into slowly changing dimensions using Slowly Changing Dimension wizard.
  • Advanced extensible reporting skills using SQL Server Reporting Services (SSRS) and Crystal Report.
  • Developed various types of reports like Drill Down, Drill through, Crystal Report.
  • Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS 2012.
  • Created Databases, Tables, Cluster/Non-Cluster Index, and Unique/Check Constraints, Views, Stored Procedures, Triggers and functions.
  • Involved in using Team Foundation Server (TFS) to check in and check out SSRS reports and SSIS packages.
  • Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2012 and Flat files.
  • Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
  • Used various Transformations in SSIS Data flow, Control Flow using for loop Containers and Fuzzy Lookups etc.
  • Implemented Event Handlers and Error Handling in SSIS packages.
  • Involved in designing Parameterized Reports for generating Ad-Hoc reports as per the client requirements.
  • Conducted data import and export operations using the DTS wizard.
  • Coordinated with front-end for implementing logic in stored procedures and functions.
  • Experienced in writing complex SQL Queries, Stored Procedures, Views, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non-clustered indexes.
  • Database and Transaction log backups & restoration, backing up user databases and restoring them whenever necessary.
  • Developed T-SQL Queries and Stored Procedures, Triggers, Views and Adding/Changing Tables for data load and transformation, and data extraction for processing business logic in the database.
  • Created User Defined Functions to encapsulate frequently and commonly used business logic making the system more modular, secured and extensible.
  • Maintain referential integrity, domain integrity and column integrity by using the available options.
  • Reviewed many T-SQL issues using management studio for better performance.
  • Involved in requirement gathering, analysis, design, development, change management, deployment and user training.
  • Developed and tested storage strategies and disaster-recovery plan for large manufacturing company's operational database, delivering solution that guaranteed recovery performance and high availability.

Environment: MS SQL Server 2014/2012R2, MS Visual Studio 2012, MS Azure, MS SQL Server Reporting Services (SSRS), MS SQL Server Integration Services (SSIS), XML, T SQL, SQL Profiler, XML, Erwin r7, DTS and TFS, Windows.

Confidential, Charlotte, NC

SQL BI Developer

Responsibilities:

  • Created and maintained database objects, complex Stored Procedures, Triggers, Cursors, and Tables, Views and SQL joins and other statements for various applications.
  • Performance tuning of the stored procedures, User defined functions and long running queries.
  • Automated the ETL to import and export data form text/ Excel file, in different format, to SQL Server and vice versa using SSIS.
  • Analyzed and designed business processes as per the business requirements with SSRS reports.
  • Created various dynamic reports using SSRS and Crystal reports.
  • Migrated and recreated existing Dimensions and Cubes using Star schema on 2008 Server to achieve the efficiency of SQL Server Analysis (SSAS) and used the SSAS as source for generating parameterized reports in SSRS.
  • Used ROLAP tools to access the data in a relational database and generate SQL queries to calculate information at the appropriate level when an end user requests it.
  • Created reports and Data access from MDX and OLAP.
  • Created SSIS Packages to pull data from Online Database Server to Data-warehouse Server.
  • Performed administration tasks of Database Mirroring, database backups and restore servers in SQL Server 2008.
  • Enhancing and deploying the SSIS Packages from development server to production server.
  • Created reports in SSRS with different type of properties like chart controls, filters, Interactive Sorting, SQL parameters etc.
  • Extract Transform Load (ETL) development using SQL Server 2008, SQL 2008 Integration Services (SSIS).
  • Used various ETL tools like SSIS/DTS for data flow from source files like XML, Excel, Tables, and Views to other databases or files with proper mapping.
  • Migrating SQL Server 2008 databases into SQL Server 2012.
  • Applied conditional formatting in SSRS to highlight key areas in the report data.
  • Involved in migration of crystal reports to SSRS 2008.
  • Identified the dimension, fact tables and designed the data warehouse using star schema and created complex reports using IREPORTS tool.
  • Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs
  • Troubleshoot system issues, monitored scheduled jobs and set up maintenance plans for proactively monitoring the performance of SQL Server databases.
  • Created calculated measures and dimension members using multi-dimensional expression (MDX).

Environment: MS SQL Server 2012/2008 R2/2005, T-SQL, SSRS, SSAS, ETL, ODBC, Erwin, ASP.Net, Ado.Net, C#.Net, Excel, Business, Business Objects Data Integrator 6.5, SharePoint Server, MDX, ProClarity, OLAP, OLTP, DB2, Access, Windows 2003 Server, IIS 6.0.

Confidential

SQL Server Developer/SSRS

Responsibilities:

  • Involved in Planning, Defining and Designing data based on business requirements and provided documentation.
  • Writing complex queries and generating reports.
  • Extracting queries from multiple databases like Teradata and AS 400
  • Optimized the performance of various SQL scripts, stored procedures and triggers by using embedded UDFs, CTEs and System stored procedures.
  • Worked on troubleshooting and maintaining large (terabyte-size) clustered databases.
  • Created Sub - Reports, Drilldown -Reports, Summary Reports, and Parameterized Reports in SSRS .
  • Generated ad-hoc reports using MS Reporting services and Crystal reports .
  • Debug and analyse VBA code/ SQL stored procedures.
  • Develop and modify stored procedures/ VBA code.
  • Experience with MS Office software (Excel, Access, and Word).
  • Worked on Teradata insert, Update, modify and Dynamic SQL to transform and load Summary tables built on Core Data Warehouse.
  • Extensively worked on Performance Tuning of Teradata SQL using explains plan and understanding Joins and Data distribution.
  • Extensively worked on Maestro to schedule jobs as daily batch.
  • Involved in writing Automation Testing scripts using Shell and Perl to schedule these scripts in DEV
  • Build, test, and execute one-off procedures as needed to support business commitments. Answer business user questions. Investigate and resolve issues or problems that arise. On call for production troubles.
  • Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analysing multi-dimensional reports in SSRS.
  • Created reports using SSRS from OLTP and OLAP data sources and deployed on report server.
  • Designing and implementing a variety of SSRS reports such as Parameterized, Drilldown, Ad hoc and Sub-reports using Report Designer and Report Builder based on the requirements.
  • Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report and deployed SSRS reports.
  • Ensured best practices are applied and integrity of data is maintained through security and documentation.
  • Functionality includes CGI Advantage Finance & HCM integrated with Info Advantage reporting, Neogov Recruiting & Applicant Management, and KRONOS Time & Leave.
  • Create custom reports for a variety of functional areas in infoAdvantage web intelligence software

Environment: MS SQL Server 2008, MS Reporting Services 2008, Info Advantage Reporting, MS-Excel, MS Access, MS Visio, Teradata, AS400, Visual Studio 2008, VBA, PERL, BTEQ.

Hire Now