We provide IT Staff Augmentation Services!

Sql Bi Developer (ssis/ssrs) Resume

Chicago, IL

SUMMARY:

  • Around 7 years of IT experience in the field of Data analysis, Data Warehousing, Data Modeling and ETL Development.
  • Experienced in MS SQL Server Developer specializing in database design, development and administration of Business Intelligence Solutions using SSIS (SQL Server Integration Services), Informatica, and Tableau Tools.
  • Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as (SSIS).
  • Extensive experience in developing and deploying SSIS packages.
  • Experience in creating SSIS packages using Activex scripts and with Error Handling.
  • I have experience working with SSIS, SSRS, SQL Server / 2008/2016, Oracle 9i.
  • Good understanding of ETL, Dimensional Data Modeling, Slowly Changing Dimensions (SCD) and DW.
  • Experience in data warehouse development with Analysis services (SSAS) and Reporting Services (SSRS).
  • Highly experienced in handling EDI Production Support.
  • Strong knowledge in database design features including ER Diagrams, normalization, tables, Temporary tables, constraints, keys, data dictionaries, and data integrity.
  • Worked on Scrum(Agile) and Waterfall Methodology of development
  • Have excellent oral & written communication skills & solid interpersonal skills.
  • Database Programming using SQL Server /, SQL, Stored Procedures, and Indexes.
  • In Depth knowledge of analyzing the queries and procedures using query analyzer in SQL server by going through the execution plan.
  • Experience with SQL Server Reporting Services (SSIS) and SQL Server Integration Services (SSIS).
  • Excellent problem solving, analytical and interpersonal skills, strong team player, self - motivated, and mentor to others.
  • Extensive experience in developing complex Stored Procedures, Functions, Triggers, Views, Cursors, Indexes, CTE's, Joins and Sub queries with T-SQL.
  • Responsible for creating SQL datasets, multiple kinds of report.
  • Experience in administering the created reports and assigning permission to the valid users.
  • Experience in developing Custom Reports and different types of Tabular, Matrix, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS).
  • Experience in tuning the reports that includes modifying and testing the required TSQL.
  • Enhancing the Reports visually by adding the visual elements like charts, graphs to SSRS reports.
  • Experience in creating Jobs, Alerts, SQL Mail Agent, and scheduled DTS Packages.

TECHNICAL SKILLS:

SQL Server Business Intelligence Development: SSIS SSAS, SSRS, DTS, MS Visio, Erwin, Crystal Reports 9.0/XI, ProClarity, Performance Point Server, Informatica

RDBMS/DBMS: MS SQL SERVER 2000/05/08, MS Access 2010, Oracle 9i/10g

Operating Systems: Windows server 2003, Windows 2000 advanced server, Windows NT/95/XP/Vista/2003/7/8/10, LINUX, UNIX

Web Technologies: XML,XSL, HTML,CSS

Version Control Tools: Visual Source Safe, TFS

Application Packages: MS Office Suite, MS Outlook, Microsoft Office SharePoint Server (MOSS)

PROFESSIONAL EXPERIENCE:

Confidential - Chicago, IL

SQL BI Developer (SSIS/SSRS)

Responsibilities:

  • Used SSIS to create ETL Packages to validate, extract, transform and load data to data warehouse databases, data mart databases
  • Generated packages using different Transformations like Lookups, Derived Column, Merge Join, Fuzzy Lookup, For Loop, For Each Loop, Conditional Split, Union all, Script component and etc.
  • Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
  • Worked on stored procedures, functions, views in SQL server.
  • Excellent report creation skills using Microsoft Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
  • Developed custom reports and deployed them on server using SQL Server Reporting Services (SSRS)
  • Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS)
  • Created Drill-down, Parameterized and Sub-Reports using RDL.
  • Promoted RDLs to Reporting Service Server (SSRS)
  • Implemented business Intelligence dashboards using MOSS 2007 Report Center and Excel services producing different summary results based on user view and role membership.
  • Created scorecards with executive summary dashboards using MS Office Performance point server 2007 Dashboard designer that display performance monitoring measures.
  • Designed and developed Data-mart using SSAS.
  • Build Cubes on Enterprise Data Warehouse (EDW)
  • Designed packages in SSIS using concepts of lookup transformation, Flat file connections,
  • Control flow task, various types error handling
  • Analyzed and created Multidimensional Cubes in Facts and Dimension Tables using SSAS.
  • Performed DBCC checks and fixing data corruption in Application databases.
  • Scheduled Backups and performed Restore operations for system test data.
  • Performing query plans and making sure each and every query is using appropriate useful Indexes
  • Rebuilding Indexes and Tables as part of performance tuning exercise.
  • Deployed the created SSIS packages in Development and Testing environments.

Environment: Microsoft SQL Server 2008R2 / 2016, SSIS, SSRS,T-SQL, MS Excel, MS SQL Server Integration Services (SSIS), MS SQL Server Analysis Services (SSAS), MS SQL Server Reporting Services (SSRS), Microsoft Visual SourceSafe.

Confidential - Troy, Michigan

SQL BI Developer/Analyst

Responsibilities:

  • Worked in Agile environment, Created logical and physical design of database and database objects to fit new business requirement and implemented new design into SQL server.
  • Analyzed requirements and impact by participating in Joint Application Development sessions with business.
  • Created SSIS packages with Flat file, Excel connections, SQL stored procedures implementing logic, used derived column transformation for converting data types.
  • Looped through the files and archivied flat files after the data load to stage tables using SSIS.
  • Created numerous SSIS (ETL) packages involving Control Flow, Containers and Data Flow Tasks, Email alerts.
  • Highly proficient in packages to extract, transform and load data (ETL) using SSIS, designed packages which are utilized for tasks and transformations Data Conversion.
  • Automated the SSIS package execution, Debugging, Error Handling, SQL Stored Procedure and package performance tuning.
  • Monitored EDI systems and communications (VAN/AS2, FTP, SFTP)
  • Reporting and resolving EDI errors in production and testing.
  • Responsible for the implementation of new trading partners for EDI documents
  • Created an EDI mapping for the 3PL and exchange transactions with 3PL providers by using EDI transactions.
  • Efficiently used Data Flow Tasks such as Excel Source, Flat File Source, OLE DB Source, Data Conversion, Lookup, Aggregate, Audit, Multicast, OLE DB Command, Sort, Union All, and Copy Column, Derived Column, Cleaning bad data, Validating data using Derived Column, Row Count, Excel Destination, Flat File Destination, OLE DB Destination, Raw File Destination, SQL Server Destination, Record Set Destination of the integration services (SSIS).
  • Hands-on Deploying reports, creating report schedules and subscriptions. Managing and securing reports and Proficient in MS Office includes MS Excel, creating spreadsheets, graphs and dashboard reports.
  • Experience in transforming unstructured data from various data sources using SSIS like Conditional Split, Lookup, Merge Join and Sort.
  • Sending Email notifications in case of failed recon execution and success execution of each recon.
  • Optimized the performance of SSIS package and SQL stored Procedures for better package execution.
  • Improved T-SQL queries, SQL stored procedure performance by dropping and recreating the Indexes.
  • Lead offshore meetings and tracking the status by Daily.

Environment: Microsoft SQL Server 2008R2 / 2016, SSIS, SSRS,Cognos, T-SQL, MS Excel, MS Access, MS Word, SQL Profiler, Visual Studio

Confidential, Warren, NJ

SQL BI Developer

Responsibilities:

  • Interacted with Business Analysts to identify information needs and business requirements.
  • SQL queries used to validate source data versus data in the data warehouse including identification of duplicate records
  • Involved in the analysis and profiling of source data, creating prototypes and sample reports to help with requirements and design.
  • Written complex T-SQL queries and created Stored Procedures, Triggers, functions and Views.
  • Analyzed requirements and impact by participating in Joint Application Development sessions with business.
  • Created various scripts (using different database objects) and SSIS packages (using different tasks) to Extract, Transform and Load data from various servers to client databases.
  • Optimized Stored Procedures and long running queries using indexing strategies and query optimization techniques.
  • Leveraged dynamic SQL for improving performance and efficiency.
  • Successfully developed and deployed SSIS packages into QA/UAT/Production environments and used package configuration to export various package properties.
  • Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.
  • Created and analyzed complex dashboards in tableau using the various sources of data like Excel sheets, SQL Server.
  • Developed SSRS reports and configured SSRS subscriptions per specifications provided by internal and external clients.
  • Designed and coded application components in an Agile environment utilizing a test driven development approach.
  • Extensively worked on Excel using pivot tables and complex formulas to manipulate large data structures.Designed and developed efficient SSIS packages for processing fact and dimension tables with complex transforms.
  • Extracted large volumes of data from various data sources and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration services (SSIS).
  • Involved in Performance tuning of SSIS Package to reduce overall ETL execution time.
  • Write stored procedures, functions and queries using SQL Server
  • Created SSIS packages for Uploading of different formats of files (Excel, Access, dbf) and databases (SQL server, Flat files) into the SQL Server data warehouse using SQL Server Integration Services (SSIS)
  • Worked with Tabular reports, Matrix reports, Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment using SQL Server Reporting Services(SSRS).
  • Designed and developed SSIS packages for broker feeds using data upload functionality file connection manager.
  • Used Microsoft Visio for data modeling, creating ER diagram and sequence diagrams for the various modules in the audit application
  • Write stored procedures, functions and queries using SQL Server
  • Scheduled execution and delivery of end of the day report using SSRS.
  • Participated in reviews of issues related to SSRS reports and work in troubleshooting those issues, fixing, testing and deploying them

Environment: Microsoft SQL Server, SQL Profiler, Index Tuning Wizard, MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS)

Confidential

SQL/SSIS/SSRS Developer

Responsibilities:

  • Develop and maintain stored procedures, functions, views, triggers, SSIS packages, SQL Server Agent jobs, required.
  • Perform Code review of Stored Procedures and prepare for database build steps for weekly change cycle.
  • Extracted data from SQL Server, Flat Files, Excel and XML using SSIS and cleanse the data.
  • Configured the SSIS Packages using Environment Variables for Dynamic selection of Development and Production Environment.
  • Developed ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files) and loaded data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).
  • Created SSIS packages in SQL Server 2016 for sources database for Tableau dashboards.
  • Support and resolve any issues that occur with SSRS and SSIS packages that run daily.
  • Troubleshoot and tune Reporting Stored Procedure (SSRS) performance issues. Troubleshoot blocking issues.
  • Troubleshoot and resolve various database processes impacting production and provide root cause analysis to prevent and/or improve upon daily transactional throughput.
  • Created reporting process (SSRS) for management to get timed reports on various database counters pertaining to resource consumption.
  • Automated KPI metrics reporting using Visual Studio Team Services/Power BI.
  • Adept in clinical and financial healthcare terminology.
  • Exported or Imported data from other data sources like flat files using Import/Export through SSIS.
  • Worked on SQL server tools like enterprise manager and SQL query analyzer.
  • Implemented and managed performance tuning tasks with developers in optimizing the long run queries.
  • Implemented side-by-side migration and in-place upgrade of MS SQL Server.
  • Performed Database Upgrades from 2008R2 to 2012 and .
  • Worked on Analysis services for three different approaches for creating a business intelligence semantic model such as tabular, multidimensional, and Power Pivot.
  • Analysis the metric dashboard reports and identified the formulas and functionality of the dashboard reports and digitizing the metric dashboards with Power BI service.
  • Published the dashboard reports to Power BI service for navigating the developed dashboards in web.
  • Created Customized and interactive dashboards using multiple data sources.
  • Created conditional filters and Action links to filter the data on dashboard with Power BI Desktop.
  • Developed complex SQL queries using stored procedures, common table expressions (CTEs), temporary table to support Power BI and SSRS reports.

Environment: MS SQL Server 2008/2012, SSIS, SSRS, SSAS, Windows 8/8.1, Tableau, MS Office 2007/2010, T-SQL, Stored Procedures, Team Foundation Server (TFS).

Confidential

SQL/MSBI 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.
  • Identified the dimension, fact tables and designed the data warehouse using star schema.
  • Designed and developed reports in SSRS
  • Worked on stored procedures, functions, views in SQL server
  • Created volatile tables and partitioning the tables and Responsible for supporting existing projects.
  • Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non-clustered indexes.
  • Developed and Optimized Stored Procedures, Views, and User-Defined Functions for the Application.
  • Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse and data marts.
  • Created Data-driven Packages in SSIS as part of Referral Process.
  • Identified Data Source and Data Source Views CUSTOM Mappings for ETL.
  • Developed, deployed and monitored SSIS Packages for new ETL Processes.
  • Migrated data from Heterogeneous Data Sources to SQL Server databases using SQL Server Integration Services (SSIS) to overcome transformation constraints.
  • Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS).
  • Developed various operational Drill-through and Drill-down reports using SSRS.
  • Developed different kind of reports such a Sub Reports, Charts, Matrix reports, Linked reports. Used cascaded parameters to generate a report from two different Data Sets.
  • Developed Reports for business end users using Report Builder with updating Statistics.

Environment: SQL Server 2012/2008/2005 Enterprise Edition, SQL Server Data Tools, SQL Server Business Intelligence Development Studio (SSIS, SSRS), T-SQL, XML.

Hire Now