SUMMARY

• Over 7 years of experience in Finance, Mortgage, IT and Banking within the Government and Private sectors
• 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 Waterfall, RUP and Agile methodologies
• Knowledgeable in accepted business and management principles with the ability to work cooperatively within and across business units
• Effective interpersonal and communication skills with the ability to identify errors and generate possible solutions
• Ability to work on and meet deadlines without immediate supervision and demonstrate a strong attitude to achieve team goals, always willing to run the extra mile
• Able to understand business goals, objective and strategies of an organization and use the acquired knowledge to help design and implement new business systems
• Expertise in recommendation and implementation of process improvements and share expertise with internal and external customers to ensure that final products are accurate, complete and thorough
• Focus on discovering and addressing the needs of customers and internal partners
• 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

Operating Systems: Proficient in using Confidential Windows (all), UNIX & LINUX based machines, with experience in executing commands in UNIX / LINUX Terminals; Command Line / Command Prompt interfaces

Productivity/Office: Confidential Office Suite incl. Publisher & SharePoint 2010, Google Office, and Adobe

Enterprise: Oracle Business Intelligence Enterprise Edition Applications OBIEE incl. Oracle Federals, Oracle Financial Analytics, Unified Financial Management Systems

Querying: SQL, Oracle PL/SQL, Confidential SQL Server

ETL/Database/Data Warehouse: MS Access, Ab-Initio, Informatica

Quality/Test Management: Confidential Application Lifecycle Management 11.0 - Quality Center Edition, and BMC Remedy Action Request System, IBM Rational Clear Quest, IBM Rational Clear Case, AutoSys, IBM Rational Doors

PROFESSIONAL EXPERIENCE

Confidential, HERNDON, VA 

QA ANALYST/MANUAL TESTER

• Business knowledge of upstream sources QAS, DARTS and TRAX. Proper understanding of data scenarios in these environments
• Analysis of Solution specifications and Source to target mapping document (STTM) and prepared test cases
• Worked with and implemented automation framework approach for NUCDM 1.02 iteration
• Comparison between data requirements and STTM and ensured correctness of documents
• Proper understanding of Dimensional modeling, STAR schema and ability to prepare scripts to test dimension and fact
• Prepared scripts to validate Initial run and Delta run for facts and dimensions
• Understanding of NFRs and prepared test cases which are testable by SIT
• Used AutoSys commands and ability to debug errors by checking the log files and understanding error messages
• Data preparation:
• Mocked up NPI masked data and tested the code.
• Prepared data to test derivations according to solution specs and STTM
• Evaluated various negative scenarios and ensured the quality of data.
• Responsible for completion of system test Phase 1.0 of Lombardi PDW SOURCE into NUC DATA MART
• 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
• Ability to load files into tables and executed scripts on control volume and full volume data.
• Used SQL DEVELOPER /TOAD and SQL*PLUS (for data retrieval.
• Proficient in using Quality Center.
• Created DBLINKS to query from multiple databases and increase efficiency in the data output.
• Proficient in using Rational Clear quest to submit defect tickets.
• Participate in DRB and discuss defects with development and TA team.
• Re-Testing of defects once issues resolved, comfortable with iteration approach. Ability to prepare test cases in parallel for future iterations and validate current iteration.
• Assist in test case walkthroughs with the Dev, TA, UAT and other teams.
• Ensure Check of data completeness, data transformation, data quality, integration testing & Regression testing.
• Proficient in using DOORS:
• Test case linking to all relevant documents to ensure System test coverage
• Generate complete RTM for System test.
• Fixing gaps in RTM
• Validating recons report and reject report. Proficient in using UNIX commands and VI editor

Environment: Confidential Application Lifecycle Management  - Quality Center Edition 11.0, UNIX/Linux Servers, Putty, Ab-initio (ETL), SQL Server 2008, SharePoint, IBM Rational Clear Quest, IBM Rational Clear Case, AutoSys, IBM Rational Doors

Technical Analyst/ QA

• Proficient with Remedy Asset Management System (Remedy) V 7.6.03
• Functional knowledge of BMC ITSM Remedy Software modules supporting Service Management tools
• 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.
• Complete assigned ITSM Remedy Service Online Requests to implement access changes, support group maintenance, and system configuration changes
• Including opening up Remedy incident tickets, familiarity with Remedy work queues, assigning incident tickets to work queues, and updating the work info Tab and other related tasks surrounding incident ticket handling and management.
• Extensive communication, coordination, and documentation experience
• Excellent Customer Relationship Management skills
• Contributed to test plans and test cases; managed the UAT process between Business and IT groups

Application Environment: BMC Remedy - Change control management, incident management, Confidential Quick Test Pro, Confidential Quality Center 9.0, Confidential Application Lifecycle Management 11.0, UNIX, and Business Objects.

Call Center Requirements Analyst

• Capture and prepare draft Meeting Minutes incorporating team input to ensure timely delivery to client
• Review and edit Enterprise Communications Architecture Project documentation developed by team members including Project Deliverables and other related project documentation
• Schedule project overview meetings with clients, system leads and Subject Matter Expert’s to gather requirements on redesigning current state architecture
• 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
• Worked with users of the application from different groups within Billing & Collections 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 & 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

TRAVEL & EXPENSE CO-ORDINATOR / ACCOUNTS PAYABLE SPECIALIST

• Study & analyze all of the departmental documents
• Verify the data within the documents for accuracy in facts & compliance with law & organizational policies
• Worked with key stakeholders to gather & document business requirements
• Worked with Subject Matter Experts (SME’s) in understanding, extracting the User & 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 latest methods, practices & technical support for accounts payable tasks.
• Analyze the utility of each & suggest the appropriate ones to the organization.
• Contributed to test plans & 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 & procure them.
• Process month end Software sales spreadsheets for profit/loss & tax calculations
• Process AP/AR month end billings
• Maintain corporate credit cards spreadsheets for further verifications
• Process legal & Attorney communications.
• Process & handle deposit transactions & 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 & evaluate its effectiveness, ability to give desired results

Environment: STAR FINANCIALS, STAR Time & Expense Management systems, Sage Timberline Products & Software, Mas90 Accounting software, CPE APPLICATIONS

Accounts Analyst /Time & Expense Coordinator

• 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 & funds disbursement.
• Suggest ways to make improvements within the procedures to ensure cost effectiveness & time effectiveness
• Review cases of non-payments of the organization & report the reasons for the same
• Suggest client with various company policed payment plans for timely Credit collections Recovery
• Travel & Living Expenses Administrator Assistance (updating employee with company policies)

Environment: ORACLE FINANCIALS, Concur Time & Expense Management Systems, ADP Accounting Software