Data Developer
Resume:
Contact Information
Houston, TX
*********.*********@*****.***
Work Authorization: USC
Achievements
Documentation
Developed Unit Test monitoring the run time to ensure successful execution of the data loading processes involve in preparing high level documents about mapping details.
Involved in preparing SDD (System Design Document) based on PRD (Project Requirement Document), TRD (Technical Requirement Document) and Market analysis team inputs.
Did error handling and performance tuning in Teradata queries and utilities for the existing complex scripts.
Created Autosys jobs to schedule sessions and workflows on Linux and scheduled various reports using Schedule Management tool/Event Studio
Maintained high level document including source name, target name, number of rows in both target and source, transformation used and session information.
Involved in Technical Architecture Design Process, by gathering high level Business Requirement Document and Technical Specification Document from Technical Architecture and followed the specific conventions.
Involved in Designing the ETL process to Extract translates and load data from OLTP Oracle database system to Teradata data warehouse.
SME
Gather requirements by conducting meetings and brainstorming sessions with senior management of the Research Group and SMEs and document them.
Conducted one on one interviews with Clinicians to understand the process of approving new subject into a Clinical Trial to become a SME on new subject enrollments
ETL
Independently wrote Oracle Store Procedures and functions that calculate penalty at the end of the month.
Created the modified the Teradata utilities BTEQ, MLOAD, FLOAD script to load the data from the various data source and legacy systems into Teradata Test and Production environment.
Used the Teradata EXPLAIN and visual explain to analyze the cost and improve the Query performance.
Created the workflow for Incremental Load and Slowly Change Dimensions (SCD1, SCD2, SCD3) using the Lookup and Aggregator transformation both for real time and Batch Processes.
Worked on file system migration from UNIX to Linux, process of converting ETL to ELT through Wherescape.
Performance tuned the mappings using different techniques like indexes, store procedure, functions, and materialized view to provide maximum efficiency.
Developed complex mappings to convert DB2 stored procedures into ETL mappings using Informatica Power Center to load data into Teradata.
SDLC
Coordinated with developers, infrastructure, QA, instructional designers, and client SMEs to ensure deliverables and milestones were met for client requirements, use cases, software design, development, unit testing, system integration testing (SIT), user acceptance testing (UAT), quality assurance (QA), training, pilot/production readiness, implementation, and closure.
Address Stability and Memory leak issues with Address Validation System Upgrade to troubleshoot any issues reported per Business teams during UAT execution
Developed UNIX shell scripts to move source files to archive directory, maintaining logs and automate processes by using command utilities sed, awk, cut and other Unix command
Project Management
Provided project manager with regular status updates assisting the overall project management initiative.
Wrote all project documentation from project definition, scope and business requirements document including process modeling for "as is" and "to be" states, mockups and wireframes.
Asad Zahid
Sr. Informatica\SQL Developer
Summary
•Over 6 years of experience in Information Technology as an ETL Developer, experience in all phases of life cycle of Requirement Analysis, Functional Analysis, Design, Development, implementation, Testing, Debugging, Productions Support, and Maintenance of various Data Warehousing Applications.
•Heavy experience in Data integration, Migration and ETL processes using Informatica PowerCenter 9.X,8.X/7.X/6.X/5.X, Power Exchange (CDC), Informatica Data Quality both in real time and batch processes.
•Extensively worked on developing Informatica Mappings, Mapplets, Sessions, Workflows and Worklets for data loads from various sources such as Oracle, Flat Files, Teradata, XML, SAP, DB2, SQL Server, Tibco.
•Involved in Technical Architecture Design Process, by gathering high level Business Requirement Document and Technical Specification Document from Technical Architecture and followed the specific conventions.
•Highly motivated team player with excellent Interpersonal and Customer Relational Skills, Proven Communication, Organizational, Analytical, Presentation Skills.
•Experienced in writing SQL statements, PL/SQL code for the database objects such as tables, views, indexes, sequences, procedures, functions, packages, and triggers.
• Perform XML operations for data extracts, data retrieval and data storage
• Hands on experience in writing, maintaining, testing and debugging code in applicable programming languages.
•Work Experience
United Health Group, Minnesota Aug ‘17 – Present.
Sr. ETL \SQLDeveloper
Working with architect, business managers to understand the requirement and source system in order to prepare design documents specifying the various ETL approaches, pros and cons of the different approaches with suggestion of the best approach. Worked extensively on Informatica designer to design a robust end-to-end ETL process involving complex transformation like Source Qualifier, Lookup, Update Strategy, Router, Aggregator, Sequence Generator, Filter, Expression, Stored Procedure, External Procedure, Transactional Control for the efficient extraction, transformation and loading of the data to the staging and then to the Data Mart (Data Warehouse) checking the complex logics for computing the facts.
Responsibilities:
•As a Sr. ETL developer had high-level overview of all required TRD and Mapping Document and reviews them as development prospective to find out what all the development required.
•Involved in the meeting with the Business to discuss the business requirement, ETL specification, calculation of all the metrics, sub metrics and reports that Frontier generate for the business to review.
•As a primary developer in the team, responsible to schedule Team meeting to discuss the Development, changes required, Time Line to meet all the SLA.
•As a part of the development team understanding the business requirement, involved in the code change in the Oracle Store Procedures and Package required for the different metrics that calculates the revenue based on the CLEC usage, Retail, and DUF usage.
•Developed Informatica Workflow using the Informatica PowerCenter 9.1 that was required for the new Order, Trouble, Billing feeds. Using the Informatica PowerCenter/Power Exchange and also was responsible for the Daily Load of over 500 files every day.
•Developed standard and re-usable mapping and mapplets using the various transformations like expression, lookup, joiner that Extract, Transform and Load the data between different environment using relational writer and Fast Export.
•Experience of in SQL Server, retrieving data from databases using T-SQL, Import data from other filesystems.
•Created mappings using Lookup, Aggregator, Joiner, Expression, Filter, Normalizer and De-Normalizer, Maps Transformations.
•Developed reusable Transformation and Job lets.
Created tabular and matrix reports in SSRS .wrote store procedure and function to create SSRS reports.
Involved in the creation and deployment of the reports using SSRS and configuring the SQL server reporting server
Used SSIS tool suite and created mapping using various transformation like OLEDB command/conditional split.
• Hands on experience working with SQL Server Integration Services(SSIS) and SQL Server Reporting Services (SSRS).
Bank of America - Plano, TX May ’17 – Aug ‘17
SR. ETL\SQL Developer
Monitored and cleansed data using Informatica Data Quality (IDQ) - source data profiling using Informatica Analyst and creating mappings in Informatica Developer to apply cleansing and business rules. Developed number of Graphs based on business requirements using various Ab Initio Components such as Partition by Key, Partition by round robin, reformat, rollup, join, scan, normalize, gather, merge etc.
Responsibilities:
•Master Data Management (MDM) process and tool was used to provide data transformation, data consolidation, data governance so that business is supportive to take Decision Support System.
•Categorized Dimension and Fact table by interviewing Oracle functional expert and Business Analyst and evaluated the granularity, Historical consistency and attribute availability.
•Used Informatica Power Exchange with CDC option to capture the inserted, updated, deleted and any changed data and Exchanging data between different partner having their own format and database.
•Designed Mappings using Mapping Designer to load the data from various sources (Flat Files, Sap, Teradata, VSAM) using different transformations like Source Qualifier, Expression, Lookup (Connected and Unconnected), Aggregator, Update Strategy, Joiner, Filter, and Sorter transformations
•Extensively used the capabilities of PowerCenter such as File List, pmcmd, Target Load Order, Concurrent Lookup Caches etc. Created and Monitored Workflows using Workflow Manager and Workflow Monitor
•Extensively worked on Mapping Variables, Mapping Parameters, Workflow Variables, Session Parameters and making Parameter file to pass value through Shell Scripting.
•Expert in all areas of SQL Server development including tables, user functions, views, indexes, Stored procedures, functions, triggers, clustering, T-SQL, relational database models, data dictionaries, and data integrity, Data warehousing concepts.
Banking Data Mart / SG Cowen & Co - NY Apr ’14 – May ’17
ETL \SQL Developer
As a member of ETL Team, responsible for analyzing, designing and developing ETL strategies and processes, writing ETL specifications for developer, ETL and Informatica development, administration and mentoring. Participated in business analysis, ETL requirements gathering, physical and logical data modeling and documentation. Designed the ETL processes using Informatica to load data from Mainframe DB2, Oracle, SQL Server, Flat Files, XML Files and Excel files to target Teradata warehouse database.
Responsibilities:
•Responsible to analyze functional specification and prepared technical specification, development, deploying and testing according to business requirement
•Involved in data profiling process to systematically examine the quality, scope of data source to build a reliable ETL system with minimum transformation and human intervention before load to target table.
•Involved in cleansing process to clean invalid values like zip code format, ensuring consistency across records, removing duplicates and ensure if complex business rules have been enforced.
•Worked on Informatica PowerCenter tools - Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
•Created the modified the Teradata utilities BTEQ, MLOAD, FLOAD script to load the data from the various data source and legacy systems into Teradata Test and Production environment
••Extracted the data from the flat files and Relational databases into staging area and populated into data warehouse using SCD Type 2 logic to maintain the history.
•Developed number of complex Informatica Mappings, Mapplets, and reusable Transformations to implement the business logic and to load the data incrementally.
•Coded complex SQL queries to retrieve data from the database depending on the need.
•Designed and developed data loading processes using PL/Sand UNIX Shell scripts.
Allied Bank - Pakistan June ’12 – Mar ‘14
ETL Developer
The process is being updated by integrating multiple applications like web services to provide better quality of service along with improvements to the existing website in order to enable ease of use for both the business along with the users. The Database is built on DB2 and informatica is used to perform the daily ETL load process. Data loads from various source systems are scheduled to update on a nightly basis. Adhoc functionality is also available for data loads.
Responsibilities:
• Understanding the business needs by gathering information from Business Analyst, Data Modeler and Business user.
• Involved in process of preparing Physical design of input and output by documented record layouts, source, target location, file/table sizing information.
• Extensively explore the physical model of Data Warehouse including all the Dimensions and facts like household, branch, account etc. to better understanding of requirement and meet all the SLA.
• Informatica Designer tools were used to design the source definition, target definition and transformations to build mappings and documented how data will be transformed.
• Supported technical teams involved with ORACLE issues and operations also developed UNIX shell Scripting and PL/SQL Procedure to extract and load data.
Education
Highest Qualification
University
Bs electronic engineering
Sirsyed university of engineering & technology
Tools & Technologies
Documentation
Teradata
MS SQL
ETL Tools
Peoplesoft HCM/HRMS
Databases
Reporting Tools
MS Suite
Contact this candidate