We provide IT Staff Augmentation Services!

Etl Developer /sr.sql Server Developer Resume

Dallas, TX

PROFESSIONAL SUMMARY:

  • Around 9 years of experience in Database Design, Programming, Development and Implementation of Client - Server Application Database systems using SQL Server 2005/2008R 2/2012/2014/2016.
  • Hands on experience in using Microsoft BI studio products like SSIS, SSAS, SSRS, Power BI and Tableau for implementation of ETL methodology in data extraction, transformation, loading and reporting.
  • Expert in Data Warehouse development starting from inception to implementation and ongoing support, strong understanding of BI application design and development principles.
  • Experienced in whole cycle of DTS/SQL server integration services (SSIS 2005/2008/2012 ) Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing Data transfers and ETL Purposes across different servers.
  • Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
  • Experience in Performance Tuning in SSIS packages by using Row Transformations, Block, Unblock Transformations and by writing optimized T-SQL.
  • Good knowledge of Data Marts, Operational Data Store (ODS), OLAP, Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling for fact and Dimension Tables using Analysis Services.
  • Expert in Data Warehouse development starting from inception to implementation and ongoing support, strong understanding of BI application design and development principles.
  • Strong experience in Creating, Designing and Processing a Multi-Dimensional Analysis Cubes (Configured Cubes, Dimensions, Measures, MDX Queries, DAX Data mining, Data Source, Data Source Views and following Star and Snow Flake schema) using SQL Server 2005/2008/2012 Analysis Services (SSAS).
  • Hands on experience in creating Partitions using table binding, Query binding and dynamic partitions (Daily, Monthly...)
  • Worked with creating Perspectives to improve Cube Performance by hiding unwanted data.
  • Excellent hands on experience in creating groups and measures, KPIs.
  • Experience in creating reports such as Parameterized, Cascading, drill down/ Drill through Reports, Charts and specialized in producing Sub Reports using Relational data warehouse and OLAP Cubes.
  • Experience in developing several Detail, Summary reports including line and pie charts, trend analysis reports and sub-reports per business requirements using SSRS and Power BI.
  • Experience as Report Writer for understanding each client business reporting requirement, designing, creating and maintain of simplex to complex reports.
  • Experience in generating reports for OLTP and OLAP databases.
  • Experience with scheduling and the deployment of the reports and uploading files to a report server catalog from the report manger.
  • Experience in generating on-demand and scheduled reports for business analysis or management decision using SSRS.
  • Strong experience in deploying and configuring packages, Error handling and batch logging, check points and troubleshooting Reports using SSRS.
  • Hands on experience working with Self Service MS BI end user tools such as Excel 2010 (Power pivot), Performance Point Service (PPS), Power view.
  • Developed the SSAS 2012 Multidimensional and Tabular model reports from Data warehouse using SSDT.
  • In-depth knowledge on Tableau Desktop, Tableau Reader and Tableau Server.
  • Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop-down menu option and Parameterized using Tableau.
  • Preparing Dashboards using calculations, parameters in Tableau.
  • Expert in generating on-demand and scheduled reports for business analysis or management decision using SQL Servers Reporting Services (SSRS), Tableau and POWER BI. Periodic reporting is done on a daily, weekly, monthly and quarterly basis which helps the client.
  • Created various types of charts like Heat Maps, Geocoding, Symbol Maps, Pie Charts, Bar Charts, Tree Maps, Gantts, Circle Views, Line Charts, Area Charts, Scatter Plots, Bullet Graphs and Histograms in Table Desktop, Power BI and Excel to provide better data visualization.
  • Expert in generating on-demand and scheduled reports for business analysis or management decision using SQL Servers Reporting Services (SSRS), Tableau and POWER BI.
  • Solid knowledge of Power BI and Tableau Desktop report performance optimization.
  • Experience in creating branches in TFS source control to code check-ins

TECHNICAL SKILLS:

Databases: SQL Server 2014/2012/2008 R2,2005, MS-Access 2000, Oracle 11g/10/9i, DB2/Mango DB (No SQL)

Database Tools: SSMS, BIDS/Visual Studio, SQL Developer

SQL Server Tools: SSMS, Configuration Manager, SQL Server Profiler, DTS, SSIS, SSAS, SSRS, Database Tuning Advisor, Shell Scripting/Power BI

Languages: VB.NET, C#.NET, UNIX, SQL, T-SQL, PL/SQL, MDX, DAX

IDE: Visual Studio 2003/2005/2008 R2/2012

Operating System: Windows 2003 Enterprise, Windows 2000 Datacenter, Windows NT & XP

Other Tools: Erwin/Power Designer (Data Modeling), Visio, Informatica, MS Office suite

Architecture: Relational DBMS, Client: Server Architecture, OLAP, OLTP

Methodologies: Agile, Waterfall, Scrum, SDLC.

WORK EXPERIENCE:

ETL Developer /Sr.SQL Server Developer

Confidential, Dallas, TX

Responsibilities:

  • Working as ETL/SQL Server Developer.
  • Loading the data from application source to stage ODS using SSIS packages.
  • Tuning existing stored procedures to improve performance.
  • Creating SSIS packages to load data from staging systems to ODS systems.
  • Loading data from Restful API’s using script component as transformation.
  • Created Dynamic SSRS reports for application to access the data for end users based on their requirement.
  • Involved in writing T-SQL Programming for implementing Complex Stored Procedures, dynamic SQL and Functions for different tasks and for application.
  • Created and debugged complex stored procedures, views and functions for better performance and flexibility.
  • Created SSIS packages to load data from API’s using SSIS Script Component.
  • Used SQL Profiler for Performance monitor to resolve Dead Locks and Long running queries by checking appropriate changes to Transaction Isolation levels.
  • Created database objects in SQL Server 2016 including complex Stored Procedures, cursors, tables, and views and other SQL joins.
  • Created dashboards to analyze the Market opportunities and Broker summaries for the Account Executives.
  • Worked with various business patterns and business unit leaders to identify business needs and provides solutions.
  • Designed and developed data blending to connect the multiple data sources to visualize multiple data sources in a single view.
  • Created Level of detail Expressions to compute values at the data source level and Visualization level.
  • Worked on Line charts, symbol maps to show property's listing status and volumes.
  • Build custom time frame dashboards to compare any date range of one period with another.
  • Implemented the row level securities to restrict the agents access to see only their production data.
  • Experienced working with large data within Excel and importing data from various data sources.

Environment: SQL Server 2016, Visual Studio 2012/2010/2008/2005 , ASP .Net 3.5/4, C#, SSIS, SQL Server 2012/2008/2005 , JavaScript, jQuery, SSRS, Tableau, HTML, Web Service, CSS, HTML5, XML, Ajax Control Toolkit, TFS

Sr.SQL Server Developer

Confidential, Austin, TX

Responsibilities:

  • Worked as SQL Performance engineer to improve performance of application by debugging through SQL server profiler.
  • Loading the data for different banks from VCF files using SSIS packages.
  • Encrypting files before loading the data into SQL server for data protection.
  • Implemented SQL server functions to encrypt sensitive data using third party tool.
  • Created Dynamic SSRS reports for application to access the data for end users based on their requirement.
  • Involved in writing T-SQL Programming for implementing Complex Stored Procedures, dynamic SQL and Functions for different tasks and for application.
  • Created and debugged complex stored procedures, views and functions for better performance and flexibility.
  • Involved in fixing production related issues by debugging application front end involved in Angular JS, ASP.net MVC and SQL server.
  • Migrating Data from SQL Server to Teradata using SSIS with third party connectors.
  • Provided On-Call support to Mission Critical Environments and deploying builds on time.
  • Used SQL Profiler for Performance monitor to resolve Dead Locks and Long running queries by checking appropriate changes to Transaction Isolation levels.
  • Involved in fixing IIS related security issues.
  • Designing, developing and maintaining business intelligence solutions
  • Crafting and executing queries upon request for data
  • Presenting information through reports and visualization
  • Used Power BI Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports.
  • Created organizational content packs to share the reports to users across the organization.
  • Used visuals like tables, matrix, bar, card, gauge, waterfall charts, trend visuals and custom visuals like hierarchy slicer, R charts.
  • Involved in performing transformations like Appending, transposing, creating calculated tables, columns, KPIs using DAX language.
  • Used Row level security with Power BI Desktop to restrict the sensitive data access to the users. Users can only see their allotted data.
  • Used on premises data gate ways to refresh the data in reports directly from the services by connecting to the database in order maintain the reports updated.
  • Responsible for creating and changing the visualizations in Power BI reports and Dashboards on client requests.
  • Dealt with power bi auditing to keep a track of what are the actions that are being done by the users, so that we can maintain the security.
  • Implemented on premises data gate ways to sync with data with different banks up to date.
  • Maintaining and supporting the existing reports as per the requirements in the customer support portal. Worked on Maintaining, Generating Reports and Data Migration for various bank Database.
  • Experience in Configuring scheduled refresh of power BI reports and Dashboards.
  • Experience in Excel data source with power query, pivot for Data modeling.
  • Experience in Calculated Measures by using DAX in Power BI Desktop.

Environment: SQL Server 2008 R2/2012, SSIS (2008 R2/2012), SSRS (2008 R2/2012), SSAS (2008R2/2012)Power BI, Teradata

ETL Developer

Confidential

Responsibilities:

  • Analyzing Business rules for Confidential validation, to report trade data to a central trade repository for trades and transactions across multiple product classes and jurisdictions (ACER).
  • Created SSIS package to accept data from multiple sources (Flat file, excel, SQL Server, oracle).
  • Used SSIS MDM Load to Support unique identification of Trade information across heterogeneous data sources through advanced matching and linking.
  • Analyzed business requirements and created SQL Server Stored Procedure/Functions/Views to convert business requirements to technical solutions.
  • Query Optimization, tuned some SP’s/Queries/views for excellent performance upgrades like one Job was taking 6.5 hours reduced it to 15 minutes.
  • Scheduled and maintained routine jobs, tasks, and alerts using SQL Server Agent.
  • Data Transformation Activities using SSIS Import/ Export for transferring data between different databases like Oracle.
  • Created/Modified multiple SSIS packages. SSIS packages were used to bring the application data from SQL Server to oracle and to text files as extracts/reports. Also, used SSIS packages to store data on third party FTP sites.
  • As Report Writer, I Designed and implemented reports with different layouts using SSRS 2012/2008R2 in both RDBMS and Cube databases.
  • Designed and deployed rich Graphic visualizations with Drill Down and Drop-down menu option and Parameterized using Tableau.
  • Prepared Dashboards using calculations, parameters in Tableau.
  • Created data Source and Data Source views while developing cubes and defined the dimensions.
  • Created several calculated members and Key Performance Indicators (KPI) in SQL Server Analysis Services (SSAS).
  • Involved in creating dynamic partitions and perspectives in SSAS cubes
  • Migrated SSIS packages from SQL Server 2008 R2 to SSIS 2012.

Environment: SQL Server 2008 R2/2012, SSIS (2008 R2/2012), SSRS (2008 R2/2012), SSAS (2008R2/2012) Oracle 10/11 PL/SQL, Visual Studio.

Sr. Software Engineer - ETL Developer

Confidential

Responsibilities:

  • Developed ETL (SSIS) packages to load data from different sources like csv, excel, MSSQL, Oracle.
  • Created scripts to handle automate Loading/Extraction and Transformation (ETL) of data using (SSIS).
  • Extensively worked in data integration in developing ETL mappings and scripts using SSIS
  • Data migration (import & export - BCP) from Text to SQL Server and vice versa.
  • Designed ETL packages dealing with different data sources (SQL Server, Flat Files) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS) and Used MDM concepts when loading data from multiple sources
  • Responsible for coding SSIS processes to import data into the Data Warehouse from Excel spreadsheets, Flat Files and OLEDB Sources.
  • Involved in building and maintaining SSIS Packages to import and export the data from various data sources using BIDS based on the design data models.
  • Created stored procedures, Triggers, User-defined Functions, Views for both Online and Batch requests handling business logic and functionality of various modules.
  • Responsible for Database and Log Backups & Restoration, Backup Strategies and Scheduling Backups.
  • Created Packages, Jobs and Sending Alerts using SQL Mail, database Backup, Recovery and Disaster Recovery procedures.
  • Planned the complete Back-up of various Databases for Disaster recovery scenarios.
  • Knowledge of developing reports from Cubes using the KPI’s for decision making, also debugged data connections, data sources and Data Source Views.
  • Created Business Logic Layer & Data Access Layers to implement the MVC architecture.
  • Developed stored procedures, Views and automated SQL, T-SQL scripts for database maintenance, deployment and installation.
  • Used SSRS to deliver a variety of interactive and printed reports.
  • Creating Ad Hoc and parameterized various Reports using SQL server 2008 Reporting Services.
  • Created various ad-hoc SQL queries for customer reports, executive management reports and types of report types like tables, matrix, sub reports etc.
  • Have used BCP, BULK INSERT to transfer data from and to SQL server database.
  • Implemented security to restrict the access to users and to allow them to use only certain reports.
  • Used Script task for setting the SQL query on fly using C#/VB in SSIS package

Environment: SQL Server 2008, Business Intelligence Development Studio, SSRS 2008 R2, SSIS 2008 R2, MS Visual Studio 2008

Software Engineer

Confidential

Responsibilities:

  • Primary role was SQL Server Developer with SSIS and SSAS.
  • Created and executed SSIS(.dtsx) packages to extract data from the various data sources such as flat file, excel and from other database such as Oracle and by different data loading operations for many applications which is main purpose of ETL development using SSIS 2005/2008.
  • Wrote DTS/SSIS packages to transfer data from heterogeneous database & different files format (Text File, Spread Sheet) to SQL Server.
  • Managed the migration of SQL Server 2000 databases to SQL Server 2005/2008.
  • Created tables for data ware housing applications and populated the tables from the OLTP database using DTS packages.
  • Involved in creating SSIS jobs to automate the reports generation, cube refresh packages.
  • Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
  • Experience in creating complex SSIS packages using proper control and data flow elements with error handling.
  • Enhancing and deploying the SSIS Packages from development server to production server
  • Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
  • Developed cubes by defining data sources and data source views and using SQL server analysis services (SSAS).
  • Involved in defining Referenced Relationships with the measure groups and fact tables.
  • Defined Granularity within a measure group and drill through actions.
  • Implemented the calculations to aggregate physical measures.
  • Using MDX created calculated members for customized calculated measures.
  • Analyzing the Performance of a cube by partitioning it and creating Perspective Cubes.
  • Wrote MDX queries and expressions for use in Front End BI Applications.
  • Created KPI Objects in line with Requirement Docs and Optimized cubes for better query performance.
  • Created reports from cubes by writing MDX queries.
  • Writing various Stored Procedures, Triggers, Functions, and Views based on the functionality requirements for various teams and to load data from the OLTP database.
  • Wrote Triggers (After and Instead of) and stored procedures to capture updated and deleted data from OLTP systems.

Environment: SQL Server 2000/2005/2008 , BIDS 2005/2008, SSAS 2005/2008, SSIS 2005/2008, DTS, MDX, VB, MS Access, Visual Studio, T-SQL, Windows XP

Hire Now