ETL ANALYST
Resume:
Rachel Gaddam
Skill Summary:
• Over 9 years of rich experience in Business Development, Relationship Management & Team Management
• Over 2 years of experience as Etl analyst with expertise in Analysis, Design, Development, System Testing, and Quality
Assurance.
• Experience in various SDLC phases with proficiency in methodologies like Waterfall, RUP and Agile.
• Experience in writing Use Case Specifications, Business Requirement Documents (BRDs), High Level Design
Documents (HLDs), Low Level Design Documents (LLDs) and Requirements Traceability Matrices (RTMs).
• Experience in creating use case diagrams, activity diagrams, state diagrams based on UML methodology and business
object modeling flow diagrams using Visio/Rational rose.
• Identify business problems, formulate strategic plans, initiate change and implement new processes in challenging and
diverse environments.
• Excellent facilitation skills in conducting walkthroughs, surveys, questionnaires, interviews, brainstorming and joint
application development (JAD) sessions
• Very good understanding of Data Warehousing concepts, Data Analysis, Data Warehouse
Architecture and Designing.
• Expertise in Business Process Re-engineering, Project Management, object-oriented analysis (OOA), design and
modeling.
• Experience with ETL validation and writing requirements to enhance the ETL process and the validation and integrity of
the migrated data.
• Good experience in designing and implementing SQL simple queries for timely reporting to different subject matter
experts and for data analysis and validation.
• Excellent experience in developing and executing Test Approach Documents, test plans, test scenarios, test procedures,
test cases, test data and test scripts according to Business and Design Specifications.
• Excellent presentation and communication skills combined with a proficiency in problem abstraction, business modeling,
interpersonal, leadership skills, and ability to work in a cross functional team.
Technical Skills:
Objects-Modeling/Software process Agile, Waterfall, RUP, UML, BPM.
Requirement Management Test Director, Rational Requisite Pro, Caliber RM, Rational DOORS, JIRA
Change /Repository Management Rational clear quest, Rational clear case, Quality Center
Data modeling Tools Microsoft Visio, Rational rose.
Languages / Technology SQL
Database tools Enterprise manager, Query analyzer, SQL Server agent, DB2, BCP.
Web Design Adobe Photoshop
Operating Systems Windows NT 4.0, Windows 2000 advanced server/2003 server, Windows 2003
enterprise server, UNIX.
Rachel Gaddam
Professional Experience:
FANNIE MAE, HERNDON, VA 08/2011 – Till Date
Role: ETL Quality Analyst
Description: The requirement is to integrate and upgrade 8 individual sources into one single repository called the (Credit
Data Repository) to enhance overall end users performance by providing accurate data and reports for analysis in the Single
Family mortgage division. The project covered integrating of all the disparate systems into one synchronized Repository
where data can be pulled through various interfaces for Reporting and Analysis.
Responsibilities:
• Analyzed business process workflows and assisted in the development of ETL procedures for moving Data
from source to target systems
• Extensively used SQL programming in backend and front-end functions, procedures, packages to implement
business rules and security
• Written Test procedures, Test plans & Test approach for developing various testing scenarios for data migration
• Worked with ETL groups in understanding the process of data loading for both dimensions and facts.
• Prepared extensive set of validation test cases to verify the data
• Responsible for completion of system test Phase 1 of Lombardi PDW SOURCE into NUC DATA MART
• Proficient in using SQL DEVELOPER /TOAD to perform manual testing & execute tests using Quality Center.
• Proficient in developing SQL queries to extract, manipulate, and/or calculate information to fulfill data and
reporting requirements including identifying the tables and columns from which data is extracted
• Involved in System Testing Analyzed business process workflows and assisted in the development of ETL
procedures for moving
• Mock up required test Data Per requirements.
• Mock Test scenarios covering multiple aspects to carry further Delta runs
• Created the test environment loading the system tables in SIT Schema to create control data from
Multiple sources.
• Used SQL DEVELOPER /TOAD to perform manual testing & execute tests using Quality Center
• Created DBLINKS to query from multiple databases and increase efficiency in the data output.
• Proficient in using Clear quest to submit defect tickets.
• Participate in Defect meetings and discuss/ raise concerns with development teams
• Re-Testing of defects once issues resolved.
• Assist in uploading test plans and test strategies onto SharePoint for Test teams access
• Assist in test case walkthroughs with the Dev teams and PMO Teams
• Ensure Check of data completeness, data transformation, data quality, integration testing, UAT &
Regression testing.
• Run Autosys Jobs after Code Migrations
• Validating in Unix Environment following Control files and recon reports and Job Failure instances.
• Update RTM’s from Test cases in Quality Center to requirement documents Managed in DOORS.
Rachel Gaddam
SANOFI AVENTIS, BRIDGEWATER, NJ 01/2010 –
07/2011
Role: Technical Analyst
Responsibilities:
• Proficient with Remedy Asset Management System (Remedy) V 7.6.03
• Analytical mindset focused on Achieving Quality & Integrity
• Communicate & Train End users Research large company Data XCEL Reports.
• Implement Constant updates regarding policies & responsibilities effecting end users Creating/Modifying change
requests Viewing status history of Change Tickets & Checking for Accuracy of assigned ticket attachments
• Mentor Team members on the Application & understanding of the process
• Major role involved in Migration of GENZYME & R&D Pharms ops Company Merger’s updating & data accuracy
analyzed the system defects and documented the issue resolution by engaging business and solution design teams.
• Created SQL statements to validate the data tables. Created data feeds for migrating data from the old Database to the
new Database.
• Contributed to test plans and test cases; managed the UAT process between Business and IT groups
• Extensive communication, coordination, and documentation experience
• Excellent Customer Relationship Management skills
DISH NETWORK. ELPASO, TX 10/2009 – 01/2010
Role: Call Center Analyst
RESPONSIBILITIES:
• Organized brainstorming sessions, meetings with Subject Matter Experts to define and document the scope of the
project.
• Responsible for understanding the whole application and preparing a feature functionality matrix to scope out the
project in order to aid the offshore team to make an estimate on the effort and time required to build the application.
• Worked with SME’s from 4 different source systems to gather, analyze and document business requirements for the
project
• Collaborated with SMEs to determine member billing calculations/definitions from 3 different source systems to
produce a reconciled view for online members
• Collaborated with QA team on test cases, test scripts, defect resolution and requirements clarification
• Used MS Visio for creating use case scenarios
• Co-ordinate with documented the Business Process and various Business Scenarios and activities of the business
from the conceptual to procedural level.
Rachel Gaddam
• Led client facilitation meetings to gather Interface and Business Process Requirements from Subject Matter Experts
for the personnel planning, capital planning and operating expense modules and converted them into functional
requirements, authored the same in a Software Requirement Specification (SRS) Document in MS Word
Template.
• Worked with users of the application from different groups within AB to gather their suggestions on improving the
current application.
• Provide effective and timely resolution of a range of customer inquiries (Billing & technical)
• Responsible for taking high influx of inbound calls relating to Satellite network
• Conduct ongoing training to stay abreast of product, service and policy changes
• Strike a positive and cooperative tone with both customers and coworkers
• Customer experience by providing information on new products, rate plans, & services through up selling
opportunities.
• Utilized multiple call center support applications to efficiently assist customers &record accurate data. Effectively
resolved problems related to Customers’ requests and build customer satisfaction and loyalty
ARONSON, ROCKVILLE, MD 08/2005 – 09/2009
ROLE: TRAVEL & EXPENSE CO-ORDINATOR / PROCESS ANALYST
RESPONSIBILITIES:
• Study and analyze all of the departmental documents and verify the data within the documents for accuracy in facts
and compliance with law and organizational policies
• Worked with key stakeholders to gather and document business requirements
• Worked extensively with Subject Matter Experts (SME’s) in understanding, extracting the User and Business
Requirements pertaining to clients account information: Account(s) summaries, Account(s) details, Monthly
Statements, Balance Transfers between accounts, accrued interest, Check Ordering.
• Update the organization about the latest methods, practices and technical support for accounts payable tasks.
Analyze the utility of each and suggest the appropriate ones to the organization.
• Contributed to test plans and test cases; managed the UAT process between Business and IT groups
• Document CPE registrations and maintain reports of exchange.
• Analyze software requirements (Sage, Deltek products & Quick books) for sales and procure them.
• Process month end Software sales spreadsheets for profit/loss & tax calculations
• Process and AP/AR month end billings
• Maintain corporate credit cards spreadsheets for further verifications
Rachel Gaddam
• Process legal & Attorney communications.
• Process & handle deposit transactions and verify accuracy.
• Audit & review Travel & expenses of employees in lieu with company & state T&E policies
• Update Budget & Partner related company Applications for Financial Year end partner meetings.
• Analyze the current accounts payable system in practice and evaluate its effectiveness and ability to give desired
results.
GE–GLOBAL EXCHANGE SERVICES (GXS), GAITHERSBURG, MD 06/2001 – 08/2004
Role: Accounts Analyst
Responsibilities:
• Manage A/P for US & Canada
• Process A/R, monthly & quarterly billing
• Audit/Manage Employee Expenses utilizing Concur Expense Management Application.
• Filing for Accounts Payable
• Monitor the procedures for invoice processing and funds disbursement. Suggest ways to make improvements within the
procedures to ensure cost effectiveness and time effectiveness.
• Study the cases of non-payments of the organization and report the reasons for the same. Also, make suggestions to
eliminate those shortcomings within the report.
• Travel and Living Expenses Administrator Assistance (Updating Employee with company policies)
EDUCATION:
BACHELORS DEGREE IN ACCOUNTING – 2001 - OSMANIA UNIVERSTIY, HYDERABAD, INDIA
Contact this candidate