Sr. Data Warehouse ETL Developer Resume - Hire IT People (2024)

SUMMARY

• US Citizen 19+ Years of IT experience, objective is to create highly effective, easily maintained, customer focused data warehousing and business intelligence solutions using the most relevant technologies while minimizing cost and maximizing end user satisfaction.
• Experience of several end to end implementations which required end user requirements gathering, Gap analysis, coordinating business requirement discussion with business and technical teams, data modeling, developing, testing, production cutovers, go - lives, and support.
• Experienced Software Development Life Cycle (SDLC), Agile\SCRUM Methodology, Application Lifecycle Management (ALM), Change Management process using Service Now, ITPL and Technology Project Management (TPM) principle/guidelines.
• Expertise in Extraction, Transformation and Loading (ETL) data from various sources into ODS, Data Warehouse (EDW) and Data Marts using WhereScape Red and SSIS on Oracle, SQL Server and Sybase Databases.
• Designed and implemented dimensional star schema model(Target DWH, Qlik Environment), Operational data store(ODS), Design of slowly changing dimension, transaction fact, non-transaction and Snapshot facts using Informatica, SSIS and WhereScape red.
• Expertise in building Operational Data Store (ODS), Data Marts, and Enterprise Data wherehouse Systems using Multidimensional Model (Kimball), Star schema design.
• Expertise in Data Modeling, Multi-Dimensional Modeling and involved in creation of Star Schema using ER studio and Microsoft Visio. Experience with ETL framework standards, including error processing, validation and data reconciliation and scheduling with scheduling tool using UC4, Active Batch and SQL server agent job.
• Extensive experience in developing Stored Procedures, Functions, Views and Triggers, Complex SQL queries using SQL Server, TSQL and Oracle PL/SQL.
• Wherescape administrator experience included installation, configuration, repository and scheduler setup.and restore repository database.
• Denodo administrator experience included Installation (In High Availability Environment), Configurations, import roles from LDAP and assignment, backup and migration one environment to another environment.
• Experience in investigating data quality issue to determine root causes and resolving on-going maintenance issues and bug fixes; monitoring automated ETL scheduled jobs. Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
• Experienced in PowerShell and UNIX shell script.
• Detail oriented with good problem solving, architect, integration, organizational, analysis, highly motivated and adaptive with the ability to grasp things quickly.
• Ability to work effectively and efficiently in a team and individually with excellent interpersonal, technical architect skills.
• Expertise in creating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User define data types, Cursors and Indexes in SQL server, Oracle and Sybase databases using T-SQL and PL/SQL. Good hands-on experience in using all kinds of SQL Server and Oracle Constraints, writing SQL (T-SQL and PL/SQL) Queries & Dynamic-queries.

TECHNICAL SKILLS

ETL: Wherescape Red 6.8.5, SSIS, SSAS, Informatica 10/8.6.1 (Repository Manager, Designer, Workflow Manager, Workflow Monitor), Informatica Developer.

Data Visualization: Qlik Sense 2.0

Data Virtualization: Denodo6.0, Informatica Data integration Service.

BI & Reporting: SSRS, Business Object ( Webi), Crystal Report 10, MS Access, Excel

Database: MS SQL Server 2016/2012/2008 R2//2005, Oracle 11gR2/11g/10g, Sybase 15/12.5, Access /2003.

DB Utilities: SSMS, Query Analyzer, SQL*Plus, SQL Builder, Power Designer, Erwin, PL/SQL Developer, Toad, DBArtisan.

Languages & Platforms: Jira, Service Now, Jive, Visual Studio 2012/2010/2008 , Sharepoint2010, IIS 6/7, ASP.NET MVC, C#, XML, XSLT, XSD ADO.Net, .Net 4.0, PowerBuilder 11.0.02, PowerBuilder Foundation Classes (PFC), JavaScript, HTML, Citrix server, Power Shell Script, Active batch & UC 4 automation tools, UNIX, Shell Scripting, EMC xPression 4.5 (xDesign, xAdmin, xDashBoard)

Change Management Tool: TFS, VSS, PVCS, Clear Case

PROFESSIONAL EXPERIENCE

Confidential

Sr. Data Warehouse ETL Developer

Responsibilities:

• Understanding of business processes and coordinated with business analysts to get specific user requirements.
• Studied the existing data sources with a view to know whether they support the required reporting and generated change data capture request.
• Creating specifications for ETL processes, finalized requirements and prepared specification. Define granularity, aggregation and partition required at target database.
• Documented ETL test plans, test cases, test scripts, and validations based on design specifications for unit testing, system testing, functional testing, regression testing, prepared test data for testing, error handling and analysis.
• Parsed high-level design specification to Create ETL & ELT process.
• Designing and customized data models for supporting data from multiple sources using Erwin and Visio.
• Creating ETL architecture and Source-to- Target mapping to load data into ODS, data warehouse and data mart.
• Building business intelligence and corporate performance management solution including dashboards using qlik sense application, score cards, ad hoc query, and analysis reports with drill up and drill down.
• Created DataMart, Qlik Data Model for Sales( Loan, Deposit, Sales call), LPS(Loss Prevention),Market Activity Dashboard using Qlik sense data visualization tool.
• Educating end users on how to use ODS, Data Warehouse structures and resources.
• Create user documentation, scheduling meeting to discuss key topics and responding to questions from end users.
• Mentor and trained to familiar data environment and ETL tool for developer.
• Administrator denedo included installation configured (Kerberos, SSO, LDAP and load balancing) for Dev, QA and Prod environment. Imported roles, users from LDAP, setup Virtual Data Port Database, create Users, Roles, and assigned privileges. LDAP domain configuration and maintenance. Configured cache databases, VCS,
• Developed of Data Virtualization Views, Base Views, Derived Views, Projection, Selection, Union,
• Minus, Flatten Views, Interface, Associations, Web Services, Usage of Interpolation Variable or Parameterized Query, Procedure, Custom Functions, Packaged Query, Package, Trigger, admin scripts and XQuery Transformations etc.
• Denodo Scheduler - Creating/Configuring/Maintaining projects & jobs, Data Sources, Filter Sequence

Environment: Wherescape red 6.8.6.,SSIS, Erwin, Visio, Qlik Sense, SSRS, SQL SERVER 2016/2012, BO (Webi), TFS, Oracle 11g, Visual Studio 2012,Jira, Service Now, Jive, Denodo6.0

Confidential

Software Architect/ xPression Administrator

Responsibilities:

• Parsed high-level design specification to simple ETL coding and mapping standards.
• Designed and customized data models for Data warehouse supporting data from multiple sources on real time
• Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
• Created mapping documents to outline data flow from sources to targets.
• Involved in Dimensional modeling (Star Schema) of the Data warehouse and used power designer to design the business process, dimensions and measured facts.
• Performing system analysis, estimating work effort and writing design documents that meet requirements.
• Design and develop ETL using SSIS packages, store procedures, configuration files, tables, views, and functions; implement best practices to maintain optimal performance.
• Train and manage developers, advising other groups in organization on SSIS development, data warehouse development, and ETL development best practices
• Build efficient SSIS packages for processing fact and dimension tables with complex transforms.
• Work with developers, DBAs, and systems support personnel in elevating and automating successful code to production.
• Created XML Schema and xpath definition for XML using XSLT. Converted XML to formatted output using XSLT Transformations.
• Migrated/Re-wrote DTS Package to SSIS Packages using SSIS Server.
• Automated SSIS using Automation tool (Active Batch) and SQL Server tools.
• Created SSIS Package for Automated Check Print and Correspondences letter & kit print from xPression server
• Conducted peer design and code reviews and extensive documentation of standards, best practices, and ETL procedures.
• Created Drilldown, Document level, matrix report using SSRS and IIS server.
• Migrated all crystal report to SSRS report for CLTCAS/NLTCAS System
• Administrator EMC xpression, upgrade xpression 3 to 4 and 4.5, integrated with LDAP .created migration path to prod. Developed insurance correspondence and integration with claim application to print claim check.

Environment: SQL Server 2012/2008, ASP.Net, Crystal Report, SSIS, SSRS, SSAS, Powerbuilder11.2, TFS, PFC, xPression 4.5 (xDesign, xAdmin), Informatica 9.6.1, Visual Studio 2012/2010, Power Designer

Confidential

Sr. Database System Analyst

Responsibilities:

• Involving in Analysis, design, development (new development & enhancements) maintenance and production support. Interacting with the users to discuss business logic and workflow of the new modules
• Responsible for logical and physical design with a significant effort toward application and database tuning.
• Created and maintained stored procedure, trigger and optimize the SQL and stored proc.
• Created Complex query and report using session or temporary table.
• Created or managed table, view, indexes and other database related task.
• Responsible for collecting specifications, technical analysis and technical reviews with client. Involved in Technical design and development of the system.
• Preparing detailed document specifications, Integration & unit Test cases (Test Plans)
• Design and Created touch screen based application point of care (POC) for Assist Living facility

Environment: Sybase15/SQL SERVER 2000, Powerbuilder10.5 & 9, PFC, CDE, DTS

Confidential

Consultant

Responsibilities:

• Involving in analysis, design, development (new development & enhancements) maintenance and production support. Interacting with users to discuss business logic and workflow of new modules.
• Created and maintained stored procedures, triggers and optimized existing SQL and stored procs.
• Responsible for collecting specifications, technical analysis and technical reviews with client. Involved in Technical design and development of the system.

Environment: Oracle8i, Powerbuilder8, HP-UX

Confidential

Consultant

Responsibilities:

• Collected user requirements, analysis, design (GUI & Database) and developed the system. Interacted with the users to discuss business logic and workflow of the all the system. Created technical design document, Integration and unit test cases.
• Designed (GUI & Database) and developed Business Objects using non-visual user object and created new ancestors for data entry validation and template creation. Extensively utilized tree view and tab controls linked to data window.
• Utilized advanced PowerBuilder techniques: multiple inheritance, wizards, non-visual user objects, OLE, drop down and shared data windows, composite data window, nested reports and xml template.
• Created interface with MS active directory using LDAP protocol and used SMTP protocol for sending email to the concern managers.
• Used OLE controls to connect and retrieve data from/to Excel spreadsheet.
• As a database developer, responsible for database schema, writing stored procedures, triggers, business analysis, design and implementation.

Environment: SQL Server 2000, DTS, Powerbuilder10, ASP, JavaScript