Etl Developer Resume
4.50/5 (Submit Your Rating)
SUMMARY:
- 6 years designing, developing and testing software using Sql Server Analysis Server, Sql Server Integration Services and Sql Server Reporting Services, ASP.NET, C#, ADO.NET, SQL, Milstead Procedures,
- 6 years’ experience with Object Oriented Systems Design and UML.
- Knowledge of .Net Framework, CLR, Garbage Collection, and .NET Remoting.
- 6 years of experience in designing and implementing relational database Confidential SQL Server .
- 1+ year of Netsuie and Salesforce
- 1+ year of Jitterbit and Azure Data Factory
PROFESSIONAL EXPERIENCE:
ETL Developer
Confidential
Responsibilities:
- Designing Azure DataWareHouse and using Azure Data Factory
- Write and review stored procedures and make recommendations for optimization+ - • Analyze tables in company database to establish knowledge of data for accurate retrieval and use in reporting
- Develop and maintain tables, indexes, stored procedures, views, triggers and other objects utilizing the latest DML and DDL syntax
- Manage the lifecycle of physical data models and data maps for data warehouse system
- • Develop and maintain SSIS packages using SQL Server 2012/2016 R2 SSMS to integrate with other SQL Servers, .NET web services, flat files, and non-SQL data sources such as legacy systems
- Plan and develop data ETL procedures, and secure data transfer processes
- Confer with end-users, peers or senior management to define business requirements
- Work with business analysts to translate client requirements into development projects
- Encourage dissemination of technical methods to the project team and convey technical procedures as required
- Day to day support activities, resolve system bugs, assist business staff with questions, investigate issues
- Research, relate and recommend technical solutions and relevant software application tools, utilities, environments and languagesExtracted and reviewed data from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) using SQL Server Integration Services (SSIS) from OLTP to OLAP.
- Developed logical and physical data models, designed data access strategies and wrote SQL code to access and manipulate data stored in relational databases.
- Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
BI Developer
Confidential
Responsibilities:
- Developed ETL integration between Sql Server and Salesforce using both Jitterbit
- Developed ETL integration between Salesforce and Netsuite using SSIS
- Participated in the design of our Tabular Model Data warehouse by identifying the dimension and fact tables
- Designed a replication system for moving data from one server to anoter
- Extracted and reviewed data from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) using SQL Server Integration Services (SSIS) from OLTP to OLAP.
- Developed logical and physical data models, designed data access strategies and wrote SQL code to access and manipulate data stored in relational databases.
- Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
BI Developer/SSIS/SSAS/SSRS
Confidential
Responsibilities:
- Created the structure of the model and cube in MS Analysis Services (2008).
- Analyzed and designed software and database solutions.
- Reviewed Cube with End user and changing the cube and documentation according to their requirements.
- Defined relationships between Measure groups and Dimensions.
- Generated automatically grouping attribute members.
- Implemented the calculations to aggregate physical measures.
- Created MDX queries to retrieve data from the cube and also to display SSRS reports.
- Used Caching (Cache Technology) for fast retrieval of data to generate reports against data warehouse.
- Designed Cube partitioning and incremental synchronization for SSAS cubes.
- Modified existing reports according to requirements of the end users.
BI Developer SSAS/SSIS
Confidential
Responsibilities:
- Extracted and reviewed data from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) using SQL Server Integration Services (SSIS) from OLTP to OLAP.
- Developed logical and physical data models, designed data access strategies and wrote SQL code to access and manipulate data stored in relational databases.
- Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
- Used various SSIS tasks such as Data Flow Task with a Conditional Split transformation to perform incremental Load
- Performed Bulk Load into Sql Sever
- Scheduled SSIS Packages as A SQL Server Job
- Used SSIS to populate an Analysis Services Cube
- Reviewed Cube with End user and changing the cube and documentation according to their requirements.
- Defined relationships between Measure groups and Dimensions.
- Implemented MS Analysis Services setup, tuning, cube partitioning, dimension design including hierarchical and slowly changing dimensions.
- Created calculated measures and dimension members using multi dimensional expressions (MDX), mathematical formulas, and user-defined functions.
- Generated reports using SSRS that could be used to send information to different Primary Vendors, Clients, and managers.
Software Design Engineer
Confidential
Responsibilities:
- Responsible for troubleshooting daily documentation builds for all Windows Live Developer Platform documentation teams, including managed reference documentation (created by merging writer comments with the output of an API reflection component) as well as unmanaged code (C#) API reference documents and Web technologies references (REST, JavaScript, etc.).
- Supported Program Managers and Content Publishers in their use of the content management and authoring system.
- Performed daily administrative tasks in the system and daily maintenance / troubleshooting of the build server; troubleshoot xml validation errors; created, executing, and maintaining custom queries; making bulk content edits on behalf of authoring teams; maintained project build support files and enabling on demand access to the build system for all users; created periodic usage statistics reports for Web traffic on Confidential ; and investigated publishing related issues.
- Created periodic usage statistics reports for Web traffic on Confidential and Investigated publishing related issues.
- Managed the tested and released of documentation deliverables
- Wrote test plans, suites, and cases
- Developed, maintained and tested build automation and build testing tools
- Identify and drive resolution of build errors
- Communicate across team boundaries about changes to the build system
- Publish documentation to website and through other offline publishing channels
- Upgraded the environment from SQL server 2000 to SQL server 2005
- Wrote T-SQL queries for reporting and data extraction from SQL Server.
- Perform daily activities, such as adding, modifying and deleting user accounts and profiles; define, and implement procedures and processes for backing-up databases on a regular basis; and troubleshoot and resolve database-related problems.
- Maintained and troubleshoot Windows Server and Windows client, IIS, and content production tools/processes
- Used XSLT to manage content preview and changes for content build
- Created an ASP.NET(C#) website for the LiveServicesUE team for the daily build (\\liveservicesue2/ondemand)