We provide IT Staff Augmentation Services!

Sql Bi Ssis/ssrs/ssas Developer Resume

Charlotte, NC

SUMMARY

  • Over 8+ years of IT Experience in Database Design, Development and business intelligence of Microsoft SQL Server 2000/2005/2008/2012/2014 in Development, Test and Production Environments on various business domains like Financial, Insurance and manufacturing.
  • Hands on experience in installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting SQL Server 2000/2005/2008 R 2/2012/2014.
  • 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 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, 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.
  • Experienced in Designing, maintaining and building Cubes, Dimensions, and Data source views, data mining Models, Deployment and Processing using SSAS. Proficient in writing MDX queries and use Client tools like Excel to provide visualizations on Multidimensional or Tabular model Cube data.
  • Developing reports on SSRS on SQL Server ( 2000/2005/2008 R2/2012/2014). 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 with the healthcare data inHIPPA ANSI X12, 4010, 5010formats including ICD 10,ICD 9, 997,837,834,835,277,271,270
  • Good Knowledge and experience on SharePoint.
  • 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.
  • Experience in using T-SQL in SQL Server 2000/2005 and 2008 platforms.
  • 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.
  • Worked with version control software like Team Foundation Server(TFS)
  • Experience in SQL Server DTS and SSIS (Integration Service) package design, constructing, and 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)
  • Experience in creating packages to transfer data between 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 work independently or as part of a team to accomplish critical business objectives and to make decisions under pressure.

TECHNICAL SKILLS

SQL Server Tools: Enterprise Manager, SQL Profiler, Query Analyzer, SQL Server Management Studio, DTS, SSIS, SSRS, SSAS

Database: MS SQL Server 2014/2012, 2008 R2, 2005, 2000, SQLCMD, Microsoft Office 2007/2003, MS-Access.

Language: C, C++, HTML, XML, TSQL, MYSQL, DHTML, VB.NET, ASP.NET, C#, JavaScript

Operating System: Windows XP/NT/ 2000/2003/2008 , DOS

Tools: Erwin Data Modeler, MS Visio, SAS/Access, Business Objects, Microsoft office 2003/2007

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

SQL BI SSIS/SSRS/SSAS Developer

Responsibilities:

  • Developed DTSX packages to extract, transform and load into Confidential Insurance Data Warehouse from OLTP database using of SQL Server Integration Services (SSIS).
  • Developed MDX queries for SSRS reports from SSAS Cubes.
  • Creating reports using SQL Reporting Services (SSRS) for customized and ad-hoc Queries.
  • Experience in Developing and Extending OLAP Cubes, Dimensions and data source view.
  • Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
  • Integrated TFS with SQL data tools to manage MSBI stack packages properly in DEV, QA and PROD environments using check in and checkout and have maintained history for every minor change.
  • Experience in creating Parameterized reports and Linked reports with thorough knowledge of report serving architecture. (Table, chart and matrix report).
  • Working on Data Modeling for creation of a data store that would be used various internal Confidential groups for easy retrieval and storage of customer data.
  • Involved in Analyzing, designing, building of OLAP cubes with SSAS 2008/2012 and in adding calculations using MDX.
  • Extensively worked on parsing huge XML files to retrieve business required data from various nodes of the XML using T-SQL and SSIS.
  • Designing Data-Marts, facts, dimensions and OLAP cubes using dimensional modeling standards in SQL Server 2005/2008/2012 that maintain data. Involved in the complete data warehouse development life cycle.
  • Involved in designing, developing, debugging and testing of reports in SQL Server Reporting Services (SSRS).
  • Used SSIS to unite data from existing system and performed transformations on MS SQL 2008.
  • Extract Transform Load (ETL) development Using SQL server 2012, SQL 2012 Integration Services(SSIS)
  • Generated drill down and drill through reports using SSRS.
  • Good Knowledge in creating Star schema cubes using SSAS.
  • Involved in creating calculated members, named set, advanced KPI’S for the SSAS cubes.
  • Deployed reports to Reporting server enabling the users to process and view the reports created.
  • Designed and created the table schema and stored procedures.
  • Actively participated in interacted with users, team lead, DBAs and technical manager to fully understand the requirements of the system.

Environment: T-SQL, MS SQL Server 2005/ 2008/2012 /2014 , SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), MDX, TFS and Windows 2008 Server.

Confidential, NYC, NY

SQL BI SSIS/SSRS Developer

Responsibilities:

  • Created various SSIS Packages to extract claims data from Multi formatted flat files, Excel, XML files into various Databases.
  • Created SSIS Packages to read claims status data from Oracle and SQL databases and generated output files that hold the payment information in various file formats like TXT, Excel, .CSV, etc.
  • Responsible for improving the performance of Integration Services packages
  • Created complex reports using SSRS
  • Converted all the reports form SSRS 2008R2 to SSRS 2012 and maintained all the updated versions in TFS.
  • Developed Reports to reflect the rejection reasons for various providers ICD9 - ICD10 claims.
  • Developed SSIS packages with Error Handling
  • Experience in usingSQL Server 2012tools likeSQL Server Management Studio, SQL Server Profiler, SQL Server Visual Studio.
  • Bulk inserted data from huge files to different destination tables in SQL server using SQL Server Integration Services (SSIS)
  • Created POC for parsing the input 837 claims data in XML format to populate in various table in the Database
  • Replaced BizTalk process with SSIS packages, improving the performance of the system.
  • Automated the SSIS packages by scheduling them to run as SQL jobs.
  • Used C# codes in Script task component in SSIS to accomplish various tasks as per requirement.
  • Supported in deploying the SSIS packages in production environment
  • Responsible for documenting all the SSIS packages that were developed by me. Also created operational guides and deployment documents enabling the users to understand the design of the package.
  • Integrate SharePoint environment for SSAS report deployment.
  • Experience in working on Cube structure optimization for MDX query performance in Analysis Services 2008R2 (SSAS)
  • Querying and manipulating multidimensional cube data through MDX Scripting in SSAS.
  • Created Time Dimensions on OLAP Cubes using SSAS.
  • Enhanced and developed UI functionality using ASP.Net and HTML.
  • Wrote many TSQL Stored procedures to perform specific tasks as per the requirements
  • Performed debugging on various Stored Procedures to handle errors.
  • Developed drill through and drill down reports using SSRS.
  • Developed different kind of reports such as charts, matrix, graphs, etc.
  • Generated various sub reports and multi parameterized reports

Environment: MS SQL Server 2008-R2/2012, Micro Soft Visual Studio, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), MDX, Cubes, Biztalk, SQL, SharePoint Server, MS Visual Studio.NET# 2008, ASP.Net, Visual Basic6.0/VB.net, VB Script and Windows 2008 Server.

Confidential, Berkley Heights, NJ

SQL BI SSIS/SSRS/SSAS Developer

Responsibilities:

  • Converted Data Transformation Services (DTS) application to SQL Server Integrated Services (SSIS) as assigned.
  • Creating reports using SQL Reporting Services (SSRS) for customized and ad-hoc Queries.
  • Developed DTSX packages to extract, transform and load into the Campaign database from OLTP database using of SQL Server Integration Services (SSIS).
  • Experience in Developing and Extending OLAP Cubes, Dimensions and data source view.
  • Assisted in production OLAP cubes, wrote queries to produce reports using SQL Server 2005/2008/2012 Analysis Services (SSAS) and Reporting service (SSRS)
  • 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 and 2012.
  • 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/2012 and in adding calculations using MDX.
  • Designed and implemented data mart, facts, dimensions and OLAP cubes using dimensional modeling standards in SQL Server 2005/2008/2012 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).
  • Experience in creating Parameterized reports and Linked reports with thorough knowledge of report serving architecture. (Table, chart and matrix report).
  • Used SSIS to unite data from existing system and performed transformations on MS SQL 2008.
  • Extract Transform Load (ETL) development Using SQL server 2012, SQL 2012 Integration Services(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.
  • Deployed these reports into the SharePoint after developing the reports.
  • 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.
  • 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.

Environment: T-SQL, MS SQL Server 2005/ 2008/2012 , SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), MDX, TFS and Windows 2008 Server.

Confidential, Houston, TX

SQL BI Developer/Report Developer

Responsibilities:

  • Created SQL server Reports using SSRS 2008.Identified the data source and defined them to build the data source views
  • Involved in the analysis and profiling of source data, creating prototypes and sample reports to help with requirements and design (SSRS)
  • Experienced in designing the OLAP systems for data mart applications using SQL Server Analysis Services 2000 & 2005(SSAS)
  • Used scripts and variables, email notifications for ETL process using Data Integrator.
  • Experience in creating complex SSIS packages using proper control and data flow elements with error handling.
  • Designed Data flows, Workflows and jobs to load data from source to target in BO Data Integrator.
  • Enhancing and deploying the SSIS packages from development server to production server.
  • Designed and built OLAP cubes to meet reporting needs.
  • Performed Documentation for all kinds of reports and DTS and SSIS packages.
  • Designed Cubes with Star Schema using SQL Server Analysis Services 2008 (SSAS).. Created several Dashboards and Scorecards with Key Performance Indicators (KPI) in SQL Server 2005 Analysis Services (SSAS).
  • Understanding OLAP process for changing and maintaining the Warehouse, Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
  • Created Packages in SSIS with error handling.
  • 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.
  • Created reports in SSRS with different type of properties like chart controls, filters, Interactive Sorting, SQL parameters etc
  • Created Time Dimensions on OLAP Cubes using SSAS.
  • Developed the SQL Server Integration Services (SSIS) packages to transform data from SQL 2005 to MS SQL 2008 as well as Created interface stored procedures used in SSIS to load/transform data to the database.
  • Extensively used T-SQL in constructing User defined Functions, Views, Indexes, User Profiles, Relational Database Models, Data Dictionaries, and Data Integrity.
  • Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder.
  • Created complex Stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL.
  • Worked with Technical Architects and Database analysts for the Design of Summary tables required for efficient Report Design
  • Experience in configuring and deploying SSRS reports onto Microsoft Office SharePoint Server.
  • Designed the functional and technical documents, report templates and reporting standards for the developers to work on the report development
  • Extensively involved in the SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
  • Created complex SSIS packages using proper Control and Data flow elements.
  • Used System Tables, System Stored Procedure, DBCC commands for Database maintenance.
  • Migrated DTS packages from SQL Server 2005 to SQL Server 2008 as SSIS Packages.
  • Involved in migration from SQL Server 2005 to SQL Server 2008.

Environment: MS SQL Server 2008 and 2005, T-SQL, SSRS, SSAS, SSIS Packages, SSRS, ETL, ODBC, C#.Net, Excel, Business, Business Objects Data Integrator 6.5, MDX, OLAP, OLTP, DB2, Access, Windows 2003 Server, IIS 6.0.

Confidential, Chicago, IL

BI Developer (SSRS/SSIS/SSAS)

Responsibilities:

  • Created SSIS packages and used Analysis Services processing task to update the cube with current data.
  • Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into UL Database and DB2 Billing Systems
  • Extract Transform and Load (ETL) source data into respective target tables to build the required data marts
  • Created SSIS packages to load data from Oracle to Sql Server using various transformations in SSIS.
  • Worked on the Reports module of the project as a developer on MS SQL Server 2005 (using SSRS, T-SQL, scripts, stored procedures and views).
  • Created reports from OLAP, sub reports, bar charts and matrix reports using SSRS
  • Analyzed the existing tool and participated in meetings with the business users to gather
  • Requirements and design goals of data warehouse.
  • Identified the dimension, fact tables and designed the data warehouse using star schema.
  • Developed Multi dimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS).
  • Designed Dimensional Modeling using SSAS packages for End-User. Created Hierarchies in Dimensional Modeling.
  • Used SQLCMD to write Stored Procedures in command line utility and it uses OLEDB to execute T-SQL batches.
  • Developed Aggregations, partitions and calculated members for cube as per business requirements.
  • Defined appropriate measure groups and KPIs & 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.
  • Responsible for managing daily activities of department including compliance initiatives, group practice agreements, managing health care claim strategies and other.
  • Responsible for helping manage the daily operation of the company, meeting with clients and brokers for brokerage, holding employee meetings, resolving conflicts.
  • Created T-SQL Functions, Cursors, views, indexes, stored procedures and triggers.
  • Migrated database from SQL server 2000 to SQL server 2005 using utilities i.e. exp/imp and attach/detach for SQL servers 2005 futures.

Environment: SQL Server 2005, Windows 2000/2003, Microsoft office 2003,XML,T-SQL, SQL Server Integration Services, SQL Server Reporting Services, SQL Server Analysis Services, SQL Profiler, MS Excel 2003, Visual Studio 2005,.NET Frame Work 1.0,SharePoint 2007.

Confidential

SQL Server Developer

Responsibilities:

  • Worked as a developer on databases like MS SQL Server 2000, MS Access.
  • Tested to optimize the Stored Procedures and Triggers to be used in production.
  • Maintained the client relationship by communicating the daily statuses and weekly statuses of the project.
  • Designed and implemented the Logical and Physical model of the database using Erwin.
  • Planed, defined and designed data flow processes for data migration to the Data Warehouse using DTS.
  • Created Database Objects - Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, Constraints and Roles.
  • Developed complex T-SQL code for the application.
  • Worked in Enterprise Manager for job scheduling and batch queries.
  • Installed and maintained MS SQL Server 2000.
  • Monitored performance and optimized SQL queries for maximum efficiency.
  • Implemented fine tuning of database objects and server to ensure efficient data retrieval.
  • Managed and monitored the use of disk space.
  • Planned Backup strategy based on projects requirements.
  • Worked with DTS packages and MSOLAP Services.
  • Maintained the consistency of the client’s Database using DBCC.

Environment: MS SQLServer2000, MS Access, Query Analyzer, DTS, BCP, SQL Profiler, Import & Export Data, Windows 2000 Server.

Hire Now