We provide IT Staff Augmentation Services!

Sql Bi / Etl Developer Resume

0/5 (Submit Your Rating)

St Louis, MO

SUMMARY

  • Around 7+ years of IT experience as SQL BI developer in design and development of various applications for Financial, Insurance, Healthcare and Pharmacy domains.
  • Experienced in analyzing, designing, implementing and testing of software applications, creating Design documents and Technical Specification documents.
  • Understanding business processes requirements and translate them into technical requirements.
  • Proficient in creating Index, Views, Complex SQL Stored Procedures, appropriate functions, and effective Triggers to facilitate efficient data manipulation and data consistency in MS SQL Server SQL 2005/2008/2008 R 2/2012/2014.
  • Experience with scripting in T - SQL, tables, joins user functions, views, indexes and user profiles.
  • Experience working on Normalized Databases and designed relational database/tables and the requisite relationships, designed partition tables and clustering architecture.
  • Integration of new modules and new business processes into existing system.
  • Creating Tables by analyzing Requirement and Mockups
  • Planned project sessions with managers and team to analyze business requirement feasibility.
  • Respond to trouble tickets assigned to me and fix any database issues promptly.
  • Specialized in writing Sub queries, Joins, Set Operations, and Stored Procedures extensively.
  • Worked with Stored Procedures, Functions, Table variables, Temp tables efficiently.
  • Created Primary and Foreign Key’s between tables and maintain referential integrity between tables.
  • Expert in Microsoft Business Intelligence technologies like MS SQL Server Integration Services), MS SQL Server Reporting Services (SSRS) of MS SQL server.
  • Expertise in ETL (Extracting, Transforming and Loading) development using DTS and SSIS for migration of data between legacy systems to SQL Server.
  • Proficient in merging data from various Heterogenous Data sources, populating Dimension and Fact Tables in Data warehouses and Data Marts using SSIS(ETL).
  • Experience in providing Logging, Error Handling by using event handlers, query optimization and performance tuning in ETL packages.
  • Worked on data modeling, table partitioning and notification services.
  • Involved in designing and maintaining of SSAS tabular models and Data Marts.
  • Proficient in merging data from various data sources using SSIS (ETL).
  • Good Knowledge in design and implementation processes for deploying, upgrading, managing, archiving and extracting data for reporting using SQL Reporting Services (SSRS).
  • Strong ability in defining query for generating drill through, drill down reports, canned and cache reports with drop down menu option, sorting the data, defining subtotals and handling parameterized reports and creating report layouts using data visualization tools like SSRS, Tableau, Qlikview.
  • Optimizedcode and improved efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.
  • Strong individual with Technical, organizational, analytical and design skills.
  • Problem-solver and Team player, collaborative self-starter with excellent written & oral skills.
  • Expertise in designing and creating various analytical reports and dashboards to help users to identify critical KPIs and facilitate
  • Experience in creating reports through SSRS for accessing and analyzing cubes and dimensions.
  • Experience in developing Custom Report and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS/SSDT).
  • Excellent communicational skills with strong interpersonal and analysis skills.

TECHNICAL SKILLS

RDBMS/DBMS: MS-SQL Server 2014/2012/2008 R2/2008/2005, MS Access 2010/2003/2000/97 , Oracle 9i/10g/11g

Database Technologies/Tools: Microsoft Management Console, SQL, T-SQL, Data Transformation Services (DTS), OLTP, SSIS, SSAS, Pl/SQL, Erwin r9/r7, Microsoft Visio 2007/2010, MS SharePoint, SQL Developer, SSMS

Reporting Tools: Microsoft SQL Server Reporting Services (SSRS), Qlikview, Tableau, Crystal Reports, Power BI

Operating Systems: Windows XP, 2000, NT, 98, 95, Windows 2003, Windows Vista, Windows 7, Windows 8, Windows 10

Programming Languages: T-SQL, SQL, PL/SQL, C, C#, .Net, HTML, XML

DataWarehouse/Business Intelligence Tools: SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Microsoft Visual Studio 2015/2013/2010 , Business Intelligence Development Studio (BIDS), SQL Server Analysis Services(SSAS).

Microsoft Office: MS - Word, Excel, PowerPoint, Outlook

Source Control: Github, VSS, TFS

PROFESSIONAL EXPERIENCE

Confidential, St. Louis MO

SQL BI / ETL Developer

Responsibilities:

  • Developed functional and technical specifications documents such as the Business Scope Document and High Level Design Document.
  • Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables from different databases.
  • Implemented Functions, views, triggers, stored procedures and enforced business rules via checks and constraints. Performed Replication, Backup compression for individual tables and indexes and reducing the disk usage and I/O resources.
  • Created functional/technical specifications based on business requirements.
  • Designed, developed and analyzed SSIS packages, store procedures, configuration files, tables, views, and functions; implement best practices to maintain optimal performance.
  • Implemented complex SQL queries to analyze and manipulate the data to maintain valid data using SQL Server Management Studio(SSMS).
  • Configure the SSIS Package for run time Parameters and Configured files as well as developing the Documents for Logging/Error Handling for SSIS Packages.
  • Used SSIS to create ETL packages to validate, extract, transform and Load data to Data Marts.
  • Designed and created different ETL packages using SSIS from different sources to SQL Server as Destination.
  • Designed data model diagrams and implemented them on relational databases like MS SQL Server.
  • Analyzed existing SSIS packages, prepared checklists for code review and development guidelines.
  • Developed and implemented data warehouse modelling processes in an agile delivery framework.
  • Configured and scheduled packages to be deployed out to a production environment using SQL server Table file configurations in SSIS.
  • Implemented database design model diagrams on relational databases & designed physical layer.
  • Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, execute package task, send mail task, Transfer database task, for loop & for-each loop containers.
  • Created analytical reports/dashboards from multidimensional models to identify critical KPIs utilizing Power BI.
  • Transferred files into destination server folder through SFTP task in SQL Server Integration Services.
  • Created SSIS (ETL) packages using different transformations in SSIS toolbox like aggregate, merge, merge join, Pivot etc.
  • Transformed data from different data sources like Oracle to SQL Server 2008/2005 using ODBC connection providers by creating various SSIS packages. Data is transformed from data warehouse to hub.
  • Created SSAS cubes, data source views, named queries, dimensions and deploying of analysis services project.
  • Configured packages for Testing and Production environments.
  • Designed, created data modeling and data mapping techniques and implemented them.
  • Validated extracts received from upstream systems and determined the validity of the data, and if not finding out the root cause.
  • Working with various business groups while developing their applications, assisting in Database model design.
  • Generated Dynamic reports from Cubes using data visualization tools like Report Builder and SSRS.
  • Designed and generated reports with different layouts using SSRS 2008R2, Qlikview and exported them into Excel, PDF and HTML.
  • Designed and developed various Service Management Reports like Cascading Prompts, Sales Reports, Portfolio Report, sub-reports, charts, and parameterized reports, conditional and dynamic reports.
  • Wrote Parameterized Queries for generating Tabular reports and Sub reports using Global variables, Expressions, Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS.
  • Configured and maintained Report Manager and Report Server for SSRS.
  • Performed Database administration tasks like Restore databases, backup scripts, data and monitoring Jobs.
  • Creating ad hoc queries per business need and tuning existing queries to meet business standards.
  • Created report models for ad hoc reports when the end user wants to see the reports on fly.
  • Experience in working as a Data Warehouse Tester using Quality Center.
  • Coordinated with project managers to setup times and schedules for testing and meeting arrangements, as well as giving any insight as necessary.

Environment: MS SQL Server 2008/2012/2014 , PowerPivot, MS SSRS/SSIS 2012, T-SQL, PL/SQL, Visual studio 2013, SSMS, SSIS, SSRS, BIDS, .Net, Informatica Power center, IBM Netezza, Microsoft Visual studio 2008, Windows server 2003, MS access, Excel.

Confidential, New York

SQL/SSIS Developer

Responsibilities:

  • Created SQL server database objects like user defined tables with primary keys and foreign keys to add data codes for look ups to generate integration with other tables in the database all case related codes and made available to the entire Developer and DBA Teams.
  • Created different Business logic user defined Stored Procedures includes input parameterized, user defined functionalized procedures, Views, providing login id security procedures, navigation levels security procedures, error handling- try/catch block SQL server stored procedures.
  • Created T-SQL stored procedures testing the data that including different SQL server actual and estimated execution plans from SELECT statement with complex SQL joins against huge tables.
  • Created indexes to tuning stored procedures and extensively used Execution plan, Query Analyzer, SQL Profiler.
  • Created validations checks, analysis and performed DML operations to manipulate invalid data and maintain integrity.
  • Designed high level ETL (Extracting Transformation Loading) architecture for overall data transfer from the OLTP and OLAP with the help of SSIS BIDS.
  • Created different SSIS packages for extracting data from flat files, xml, and csv/excel files and transform and load them into the database tables.
  • Responsible for logical and physical data modeling, database design, star schema, data analysis. Programming, documentation and implementation.
  • Implemented Database administration tasks like Scheduling and monitoring the ETL Jobs, Collated customer requirements, coordinated with different stakeholders.
  • Prepared detailed design document for the migration of all SSIS packages and designed jobs.
  • Wrote several scripts such as finding long running queries, blocking sessions, archiving data from production server to archive server and populating reports.
  • Created Complex ETL Strategies to populate the data warehouse facts and dimensions.
  • Analyzed ETL Packages and identify scopes for optimization, consolidations and eliminate ETL objects.
  • Performed reverse engineering on legacy SQL scripts to analyze the root cause and increase the performance.
  • Migrating and restored the SSIS integration services packages with bulk insert task tool from 2005 to SQL Server 2012 and made them running and created a SQL server Agent job and scheduled a one time and nightly bases data load jobs.
  • Created ER diagrams (physical and logical) using Erwin data modeler and implemented data mapping techniques into database objects.
  • Proficient in developing reports and data visualization using SSRS, Tableau, Qlikview tools based on the requirement.
  • Constructed physical layer from logical layer using database design model diagrams.
  • Developed Query for generating drill down reports in SSRS 2008. Prepared AD HOC reports through report builders.
  • FTP task, Master-Child packages, Data conversion from by using SSIS packages and scheduled daily bases SQL Server Agent jobs with on success and on failure email alerts job creation and secure file transferring suing SFTP task.
  • Created the SSRS Reports in 2012 based on the Business Court Users discussions and created the request document Business rules, case plans and create the tasks in the TFS Sprint and trace/tie them with BI logic and build/code the Complex SQL queries, SQL procedures and Datasets.
  • Designed the different types of reports like tabular, matrix, multi-parameterized, cascading, drilldown, drill through, Sub reports, and linked reports.
  • Using SQL server reporting services (SSRS) delivering enterprise, Web-enabled reporting to create reports that draw content from a variety of data sources.
  • Created SSAS cubes with dimensions, perspectives, measure groups, and KPIs to analyze process.
  • Migrated reports from SSRS and ensure them running by adding related data sources and datasets.
  • Maintain reporting server folder structure by using Report Sync tool as from environment and restored report related data sources and make connections with datasets in the SSRS Reporting Server and make them available to the entire users, reporting team with Team Foundation Server.
  • Prepared proper documentation, followed proper coding standards, migration checklists associated with the project.
  • Deploy the reports to the different reporting servers and maintain and make them similar by checking, branching and merging the reports from development to UAT and then Production server.

Environment: C#, ASP.Net, Microsoft SQL Server 2005/2008r2/2012, SSMS, Visual Studio 2012, SSIS 2012, SQL Server Reporting Service (SSRS), T-SQL, PL/SQL, PowerShell, Tableau, Informatica, Qlikview, SSAS.

Confidential, San Mateo, California

SQL Server/ETL Developer

Responsibilities:

  • Designed Database to integrate centralized SQL Server to manage all the clients’ Personal information and architected in simplified manner and made available to the entire Teams like QA Team, Web Server Team.
  • Developed and executed SSIS packages to populate data from the various data sources like Oracle, created packages for different data loading operations for many applications.
  • Created complex Stored Procedures, Functions, SSIS packages, triggers, cursors, tables, and views and other SQL joins and statements.
  • Extensively worked in ETL and data integration in developing ETL mappings and scripts using SSIS, guided team for the transformations.
  • Created database objects including tables, indexes and applied constraints, maintained referential integrity in the database.
  • Performed different required transformation in the staging Database and make the data ready to load in the data warehouse.
  • Developed and maintained OLAP cubes, dimensions and data source view using Star, snowflake methodologies.
  • Developed Master Child package using variables and Execute Package Task in SSIS, executing with bat files and deployed in different servers.
  • Created different user-defined functions using T-SQL Query for the creating Datasets and Data Adapters to use them in SSRS 2012/2008 and SSIS 2012/2008.
  • Involved in extracting the data from OLTP to OLAP using SSIS.
  • Implemented extraction transformation and Loading (ETL) process by pulling large volume of data from various data sources using SSIS.
  • Organized Error and Event Handling by giving Precedence Constraints, Break Points, Check Points, logging to send the result files to the clients and vendors.
  • Involved in database design process and data modeling process using Microsoft Visio, ERwin.
  • Experienced in creating complex SSIS packages using proper control and data flow elements.
  • Created SSIS Packages using Lookup, Merge, Sort, Derived Columns, Condition Split, SFTP task, Aggregate, Execute SQL Task, and Data Flow Task, Execute Package Task etc., to generate underlying data for the reports and to export cleaned data from Excel, Text file, and MS Access to different data Marts.
  • Experienced in writing T-SQL scripts, dynamic SQL, complex stored procedures, functions, triggers, and maintain XML data.
  • Worked directly with the client to resolve the issues regarding SQL server with ETL transformations and the decision for the package changes will be discussed with the management and start working on the ETL packages.
  • Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
  • Data ETL making changes to existing ETLsand building some new ETL processes.
  • Created different forms of Tablix, dropdown, parameterized reports and integrated with front ends like C#.net and SharePoint.
  • Performed Incremental load with several Dataflow tasks and Control Flow Tasks using SSIS.
  • Scheduled and monitored administration task like Jobs, Backup Scripts, restore databases.
  • Created different type of reports including Cross-tab, Conditional, Drill-down, OLAP and Sub reports using SQL Server Reporting Services (SSRS).
  • Successfully tested all task in staging and stored all versions using team foundation server (TFS).
  • Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports.

Environment: MS SQL Server 2008/2012, Visual studio 2012, SSMS, BIDS, MS access, ASP.NET, VB.NET, Power Center, T-SQL, PL/SQL, Oracle, PowerShell, Windows 2005 Server, SSRS, Qlikview, VSS, MS SQL Server 2008R2, IBM Netezza, SSIS.

Confidential

MS SQL BI Developer

Responsibilities:

  • Experienced in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional workflow of information from source systems to destination systems.
  • Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
  • Expertise in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic
  • Created clustered and non-clustered indexes.
  • Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
  • Created SSIS (ETL) packages to Load data into DWH using various SSIS tasks like Execute SQL task, Bulk insert task, Data flow task.
  • Designed and developedSSIS (ETL) Packagesto import and export data fromMS Excel, SQL Server 2008/2012 and Flat files, CSV files, .dat files.
  • Used Transformations in SSIS Dataflow, Control Flow using for loop Containers and Fuzzy lookups
  • Implemented Event Handlers and Error Handling in SSIS packages.
  • Created SSIS packages to Extract, Transform and load data using different transformations such as Lookup, Derived Columns, Condition Split, Aggregate, Pivot Transformation, and Slowly Changing. Used For-Each Loop Container, Sequence Container, Script task, Expressions, Execute SQL task, Send Mail Task, Package Execution task to achieve business needs.
  • Deployed ETL packages from test to production environment by maintaining multiple package configurations in SSIS and scheduled them using SQL Server Agent.
  • Advanced extensible reporting skills using SQL Server 2008 Reporting Services (SSRS).
  • Designed and created Report templates, bar graphs and pie charts based on the financial data.
  • Developed various types of reports like Drill Down, Drill through, Cross tab reports, Power Pivot.
  • DesignedParameterized Reportsfor generatingAd-Hocreports as per the client requirements.
  • Created Dashboards and Score Cards.
  • Created folders and Configured roles and granting user access to them in Report Manager.
  • Scheduled and created snapshots and subscriptions for the reports using SSRS 2008/2012
  • Coordinated with front-end for implementing logic in stored procedures and functions
  • Configured the loading of data into slowly changing dimensions using Changing Dimension wizard.
  • Involved in upgrading from SQL Server 2005 to SQL Server 2008 and from .
  • Advised optimization of queries by looking at Execution Plan for better tuning of the database.
  • Used SQL Server Agent for scheduling jobs and alerts.
  • Performed Query optimization & Performance Tuning.
  • Optimized queries using SQL Profiler and Database engine tuning advisor.
  • Provided support to the customer in User Acceptance Testing(UAT) and also given Production Support

Environment: SQL server 2005, Windows 2000 Advanced Server, SSMS, Windows 2000 Datacenter, VSS, MS SQL Server 2008R2/2008, SSIS, SSAS, SSRS.

We'd love your feedback!