Etl Developer Resume Profile
MI
Professional Summary:
- 8 years of strong experience with demonstrated success in the Database Design, development of SQL Server 2005/2008/2012.
- Expertise with DDL and DML statements, RDBMS's, data dictionaries and normal forms.
- Involved in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.
- Good understanding and designing of Star and Snow Flake data models Schema used in relational, dimensional and multidimensional data modeling.
- Profound knowledge and ability to write stored procedures, temporary tables, views, indexes, triggers when required and complex queries including correlated queries and queries with complex joins and aggregate functions.
- Experience in Data Modeling Logical and Physical Design of Databases , Normalization and building Referential Integrity Constraints. Designed schemas. Built tables, FKs, PKs, etc. by providing a structure that meets the business needs.
- Extensive experience in administration tasks such as data loading, batch jobs, configuring IIS, data uploading, backup recovery, Database mirroring, Log shipping, user and application table management, upgrades, creating database partitioning, databases/file groups/files/transaction logs.
- Involved in designing, developing and testing of the ETL Extract, Transformation and Load strategy to populate the insurance data from various source systems
- Excellent understanding of data mining algorithms, high performance and optimal algorithms.
- Used multiple transformations in SSIS to meet the business requirements by collecting data from various sources.
- Migrated data in various formats like text based files, Excel spreadsheets, to SQL Server databases using SQL Server Integration Services SSIS to overcome the transformation constraints.
- Experience in providing Logging, Error handling by using Event Handler, and Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
- Experience in creating jobs, SQLMail, Alerts and schedule SSIS Packages using SQL Server Agent.
- Creating SSIS Packages and involved in Package configurations and deployments between Development and QA and Production servers.
- Excellent Knowledge in analyzing Datawarehouse by building cubes using SQL Server Analysis Services SSAS .
- Solid Knowledge in developing cubes using Partitions, KPI's, and Perspectives, slow changing dimensions SCD etc and created various user roles SSAS .
- Good understanding of Microsoft Reporting Service SSRS with Report authoring, Report management, Report delivery and Report security.
- Experienced in working with Star Schema modeling to develop ROLAP/MOLAP Cubes using SQL Server 2005/2008 Analysis Services.
Technical Skills:
SQL Server/BI Tools SQL Profiler, Query Analyzer, BIDS, Export Import DTS , SQL Server Reporting Services SSRS , SQL Server Integrating Services SSIS , SQL Server Analysis Services SSAS
Databases MS SQL Server 2012/2008R2/2008/2005, MS Access, Oracle 8/9/10
Languages C, T-SQL, PL-SQL, Visual Basic 6.0
Tools Visual Studio 2005/2008/2010, Erwin 7.2
Application Packages MS Office, MOSS 2007, PPS 2007
Operating Systems Windows 2000/NT/XP, UNIX, Windows Server 2003
Architecture RDBMS, OLAP, OLTP
Professional Experience:
Confidential
SQL/ETL Developer
Confidential Solutions is a cloud based solutions for auto industry to enhance customer experiences through various modules like mi-marketing, mi-digital, mi-mobile etc. It is used to create and fulfill Email and Dmail campaigns as per the business need that includes promotions, alerts and service remainders with the latest digital and mobile marketing campaign management systems.
Responsibilities:
- Designed and developed data load jobs using SSIS package and scheduled in SQL Agent.
- Created packages with different control flow options and data flow transformations such as Conditional Split, Multicast, Union all and Derived Column etc.
- Created complex Stored Procedures, Triggers, Functions UDF , Indexes, Tables, Views and other T-SQL code and SQL joins for applications following SQL code standards.
- Monitoring Performance of SQL server using SQL Profiler, Query Analyzer, Database Engine Tuning Advisor DTA and Performance monitoring.
- Developed various types of reports like Drill down, Drill through and parameterized reports using SQL Server Reporting Services 2008 R2.
- Inspected the reports and fixed bugs in stored procedures and also tuned Reporting Services to the T-SQL.
- Created SSIS packages for File Transfer from one location to the other using FTP task with Master SSIS Package to run all other packages.
- Designed and built Star and Snowflake dimensionalmodels creating facts, dimensions, measures, cube and established data granularity.
- Worked on multidimensional data modeling.
- Participated in Databases Architecture and data modeling design.
- Worked on Change Management Cases to resolve the production change request issues based on the Specifications provided.
Environment: SQL Server 2008R2 2012 Enterprise Edition, SQL, T-SQL, MS Access, MS Excel, Windows 2003 server, Business Intelligent technologies like SSIS,SSRS.
Confidential
SQL Developer
Confidential is a provider of IT Solutions for Automotive industry from DirectMail to Email with links to dealership, Phone Contact and Text Messaging that works to drive traffic and grow profits, programs of multi-channel communications are steered by the best most current available consumer data.
Responsibilities:
- Installation and configuration of SQL Server 2012.
- Designed and developed packages for data warehouse using Integration services SSIS SQL Server 2005/2008/2012.
- Designed Scalable Enterprise ETL architecture for OLTP to DW/OLAP system requirements.
- Deploy SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
- Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
- Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups using SSIS tasks.
- Experience in developing Database Schemas / Stored Procedures / Data Dictionary.
- Experience and knowledge in designing and developing data visualization strategies.
- Imported data from text files and excel spread sheets into SQL Server 2005 database using SSIS package.
- Data management and data processing solutions using SSIS, this includes Error Handling and Slowly Changing Dimensions.
- Demonstrated experience in utilizing design tools, development tools, code management, regression testing and performance tuning.
- Responsible for Deploying the SSISpackages and scheduling the package through Jobs in all Tiers including Dev, INT, UAT and Production.
- Fundamental knowledge of .NET and application architecture and development principals.
- Worked with T-SQL to create Tables, Views, and triggers and stored Procedures.
- Experienced in Data Marts, Data warehousing, Operational Data Store ODS , OLAP, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables using MS Analysis Services.
- Experience in using XMLA protocol for SQL Server Analysis Services2005 for interaction between client application and instance of Analysis Services.
- Extensive Knowledge in SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
- Experience in creating Tablix Reports, Matrix Reports, Parameterized Reports, and Sub Reports using Sql Server Reporting Services 2008.
- Experience in creating adhoc reports Using Report Builder 1.0 and Report Builder 2.0.
- Involved in Migration of SSRS 2005 to SSRS 2008.
- Used Performance Point Server to create interactive reports with an ability to drill down into details.
Environment: MS SQL Server 2000/2005/2008/2012,Oracle 9i, PL-SQL, T-SQL, MS Access, Windows 2000/2003, VB.NET, ERWIN, XML, SQL Profiler, UNIX and Crystal reports.