PROFESSIONAL SUMMARY

• IT Professional with 11 years of overall experience in Data analysis, design and development and Quality Assurance Analysis in Banking & Financial industry and Wholesale industries. Experience and knowledge across all aspects of Data life cycle (sourcing through analytics).
• Advanced skills in sourcing and analyzing various data in various files formats sourced from a variety on internal affinity groups and external vendors such as TSYS; Bloomberg ( Reference Data); Reuters ( Market Data).
• Understanding of Credit Risk Management, Asset liability Management (ALM) processes, Sarbanes Oxley, Dodd Frank, BASEL and FATCA implementations from a regulatory perspective.
• Extensive industry experience in working with complex, high volume data using various ETL architectures (SAS, IBM Datastage (formerly Accentual) and SSIS on SQL Server, Oracle and DB2 platforms.
• Extensively used SQL queries for data analysis and data validation against SQL Server, Oracle and DB2 databases.
• Advanced skills in data analytics using SAS, SSAS and MS Excel and Business Intelligence reporting using SAS and Cognos.
• Thorough understanding of Data - Warehousing concepts with expert knowledge in Dimensional Data Modeling, Star schema, Snow-Flake schema, and OLAP, OLTP technologies.
• Extensive experience in generating Business Requirement Document (BRD), Use Case specifications and Functional Specifications System Design Specifications (SDS) and System Requirement Specifications (SRS) and Workflows using best in class tools such as Rational Rose, Blue works Live and Lombardi for BPM.
• Acted as a liaison between development teams, testing teams and the project stake-holders and generated source to target mapping documents and formulated processing rules and transformations.
• Performed data quality profiling and implemented cleansing practices into ETL designs.
• Lead a team of production support resources for monitoring business and technical issues with respect to SLA’s, data quality and data exceptions encountered in batch operations and developed strategies to address them.
• Experience in implementing various testing methodologies- Unit, Functional, Integration, Regression, System & performance using HP ALM tools.
• Effective team player with excellent communication skills, problem solving and analytical skills.
• Self-determined individual with ability to work in fast paced environments.
• Development of Utility tools for Data comparison; PDF file comparison and Excel Macro development for screen scrapping.

TECHNICAL SKILLS:

Operating Systems: UNIX, Mainframe, AS/400, Enterprise Linux, Windows

Testing Tools: Quality Center, Remedy, Win runner, Load Runner, QTP

Languages: SAS, Java, C++, SQL, T-SQL, TSL, PL/SQL

Scripting: PERL, UNIX Shell, SED, AWK, VBScript, JavaScript, Python, VBAWeb Dev

languages: J2EE, HTML, XML, Servlets, EJB, JSP 2.0, ASP 3.0/ASP.NET.

Databases/Tools: Oracle,DB2, SQL Server, SQL*Loader, ERWIN, QMF, SQL Navigator, TOAD products, SQL Developer, Exceed, Tectia, TSYS, Tivoli Maestro and Autosys

PROFESSIONAL EXPERIENCE

Confidential, Horsham PA

SAS Data Analyst

Responsibility -

• Recoding of SAS processes which entails data object mapping as well as logic mapping to support code - conversion from Bank’s Core Credit Card platform to TSYS platform.
• Responsible for monitoring Daily, weekly, Monthly projects as part of Strategy fulfillment and execution.
• Responsible for data profiling for different LOBs in Card Services of Consumer Banking for data conversion.
• Responsible for Successful Loading of Data into different targets from various source systems in form of Flat files, EBCDIC files and RDBMS DB tables and excel spread sheets into the Staging area, implementation of business rules after data cleansing; and load data to target DB tables in Data warehouse for analytics.
• Responsible for development and design reports for Product Offering Engine(POE) using SAS Enterprise Guide.
• Responsible for validation of Business requirements against the application code.
• Responsible for supporting UAT team for identification of defects for data conversion migration tests. Comparison.
• Remediation of defects and automation of handy tools for testing purposes.
• Responsible for collecting and classifying business requirement, documenting business rules, functional specifications, project schedules, documentation and test plans, investigated user expectations
• Responsible for root cause analysis for documenting and remediating process failures.
• Analysis of Maestro scripts as well as submission of RN Tickets to provide solution for failed jobs.
• Responsible for automating process for data comparison for migration of data from legacy platform to Vendor’s (TSYS) platform.
• Defect tracking and reporting using HP Quality Center 11.

Environment: - AIX UNIX, DB2, SAS, IBM Tivoli MEASTRO, SharePoint, MS Office Suite, MS Visio, MAXIMO, HP ALM 11, SAS Enterprise Guide.

Confidential, Washington

Business Process Integration Analyst

Responsibility:

• Responsible all initiatives related to integration of Legacy AS/400 system to SAP FICO-GL/AA, HCM modules.
• Leading and mentoring onsite and remote QA resources as SME.
• Responsible for participation in project meeting; reviewing the QA related documents, deliverables and initiatives; presentation of reports on daily and weekly basis.
• Responsible for writing User Stories, identifying features for of SIT and iteration phases under Agile-SCRUM development framework.
• Responsible for analysis of Functional, Business requirement and Detailed design documents and preparation of mapping documents for business requirements as well as environment related subjects.
• Responsible for analyzing technical flow of communication among applications in heterogeneous environment and evolve user stories, test scenarios from the integration point of view.
• Responsible for Analysis of Happy Path workflow, Loopback workflow and Rejection Workflows.
• Responsible for writing SQL statements to query the database for data validation.

Environment: Agile, AS/400, RPG, DB2, Enterprise Linux, SAP FICO & SAP HCM, IBM BPM, Blueworks Live, HP ALM (Quality Center), QTP and RTC.

Confidential, Jersey City, NJ

Business System Analyst

Responsibility:

• Responsible for collecting and classifying business requirements, functional specifications, project schedules, documentation and test plans, investigated user expectations.
• Mapping the source and target data to ensure the database objects accurately exist in both the environment.
• Responsible for Data profiling to examine the data available in an existing data source and collecting statistics and information about that data.
• Analysis of gaps to ensure the product is developed according to the specifications and requirements.
• Development of Excel macro to automate trade transaction data entry process to As/400 screens for testing.
• Develop strategies for analysis of entity relationship among Dimension Tables and Fact Tables for slowly changing dimensions and requirements for pre-aggregating data to satisfy reporting requirements.
• Provided input to data architecture teams for Logical and Physical design of databases.
• Worked with data from flat files and oracle database and excel spreadsheets
• Involved in providing business rules and transformations Extraction, Transformation and Loading (ETL) Process.
• Created necessary Repositories to handle the metadata in the ETL process for data lineage analysis.
• Worked on SQL queries and tuned them to improve performance.

Confidential, NYC, NY

SAS and Perl Developer

Responsibilities:

• Analysis of production scripts; analysis of parent and child scripts; and maintenance of all directory location of these scripts and related data directories in a spreadsheet to create script relationship.
• Analysis of configuration files, executables (binaries) that the scripts call.
• Analyzed MBS, CMBS daily, monthly data sourced from Fannie May, Freddie Mack and Genie May and provide necessary inputs to project stake-holders.
• Analysis of new data disclosure files pool details and documenting data mapping.
• Analyses of New data disclosure file origination detail and documenting data mapping.
• Prepare directories in Perforce workspace to hold the old and new/ modified scripts.
• Development of data directories in development environment.
• Modification of Oracle and Sybase-specific DB scripts to SQL Server DB specific scripts.
• Modification of SAS scripts to make its processes conducive to development environment.
• Manual unit tests of jobs comprising of shell, Perl and SAS scripts; and batch jobs using Autosys job scheduler.
• Tuning SAS scripts for better performance and cost effectiveness.
• Analysis of production scripts; analysis of parent and child scripts; and maintenance of all directory location of these scripts and related data directories in a spreadsheet to create script relationship.

Environment: Sybase 12, SQL Server 2008, Linux, Solaris, SQL Server Management Studio, Perl 5, Non-interactive SAS 9.1.3, Java, Rapid SQL, Perforce, Autosys.

Confidential, Philadelphia, PA

Lead QA Analyst

Responsibility:

• Guiding new QA resources including walkthrough of processes and its workflow. Interaction among the project stakeholders.
• Co-ordinate with Test Automation team to develop QTP Test Framework
• Walkthroughs for test case reviews, defect analysis and remediation; risks assessment.
• Responsible for development of Test Plan, test Strategy.
• Responsible for preparing and reporting to peers about the test progress on daily and weekly basis
• Review of test cases, test scripts for functional testing as well regression of Import LC functions test scripts in System Integration Test environment test cases using Quality Center.
• Develop Security Remediation Validation scripts using JavaScript injections and SQL injections. Security Remediation for online applications. Remediation with regard to XSS, JavaScript injections and SQL injections.
• Development of test cases and test scripts for Integration of Export LC and inbound and outbound SWIFT messages. Development of test cases for MIS in SIT test using Quality Center.
• Upload Test cases from excel spreadsheets to HP Quality Center.
• Extensively developed test data in SIT environment for various test scenarios.
• Providing support to QA resources by processing transactions at the supplementary Mainframe based application EximBills System.

Environment: Oracle, J2EE, AS400, UNIX, DB2, MQ Series, Quality Center, EximBills system.

Confidential, DE

UAT QA Analyst

Responsibility:

• Analyzed various events of credit card transactions and developed scenarios.
• Supported various test groups to help develop events and strategize User Acceptance tests.
• Developed scenarios and test plan and test cases.
• Conditioned transactions of accounts to validate processes of change in terms (CIT), Penalty Pricing, rules of Payment allocation based on cycles and dues, disclosures sets, account statements, pricing performance.
• Modification of Excel macro to automate credit card transaction data entry process to TSYS screens.
• Developed SAS scripts to validate decision rules.
• Extensively worked on TSYS application for test data conditioning.

Environment: AS/ 400, Oracle, J2EE, UNIX, DB2, SAS, SQL Developer & TSYS, Quality Center.

Confidential

Sr. QA Analyst

Responsibilities:

• Supported data modelers during the course of development of metadata in order to ensure that the development conforms to the bank specific Apolo modeling methodology.
• Represented team in daily meeting to participate in project initiatives and progress.
• Involved in creation and implementation of Test Plan and Test Strategy Documents outlining the scope, objectives, timeline and resource. Verified Information Security compliance.
• Translated Business/ Feature requirements into use cases and test cases.
• Verify batch processes to validate the migration of data and application and processes from Solaris to AIX.
• Automate DB processes using UNIX korn shell scripts. Develop Perl scripts to extract and transform data.
• Verified the ETL processes using DataStage tool.
• Worked on different applications like TSYS, Appedit, CCD desktops and Scorex to validate data and process.
• Used Quality Center for Test Management and Defect management.
• Verified Metadata Integration Strategy for the Enterprise Data Standards Initiative including software evaluation and information integration and management method development.
• Queried the Database using SQL statements to validate the accuracy of the data populated at java based web applications.
• Conditioned Java properties in properties files to test integrity of files and locations.

Environment: SQL Server 2005, Oracle, J2EE, Mainframe, UNIX, DB2, Websphere MQ Series, SQL Developer, DataStage, TSYS, SCOREX, App Edit, Control-M job scheduler, Quality Center.

Confidential

Sr QA Analyst

Responsibilities:

• Responsible for coordinating with external clients- Ameriprise Financials and offshore team.
• Responsible for handling all issues related to code merge.
• Reported resolved and outstanding issues logged by offshore QA team using company’s standard matrix in the daily project meeting.
• Walk through Test plan and test cases with Clients, Business Analysts, Project Management and other stake-holders in the projects.
• Reported test progress which included number of test cases created, executed and defects logged using HP Quality Center.
• Mapped requirement documents with the detailed design document to ensure that all requirements are covered in the design approach.
• Prepared data attribute mapping matrix to ensure business logics are met according to the requirements.
• Responsible for conducting Smoke (Sanity) Testing, Functionality Testing, Ad Hoc Testing, Regression Testing and End-to-End System Testing.
• Developed test plan and test cases for web application Trade Blotter application for company's client.
• Verified and validated SOAP-based user authorization & authentication rules as well as messaging processes for the Trade Blotter system.
• Used Quality Center for writing test cases and test scripts and defect reporting, tracking and test management.
• Worked on two integration projects where two different releases were merged into a new release.

Environment: UNIX (IBM AIX), MAINFRAME, J2EE, WebLogic, XML, Oracle 10g, Quality Center, QTP

Confidential

Sr QA Analyst

Responsibility:

• Coordinated as a single point of contact for a group of three QA resources; used Mercury Quality Center for reporting and analysis of overall test progress.
• Responsible for handling all issues related to various applications assigned.
• Actively participated in development activities to identify and mapping QA requirements vis-à-vis to testing related needs for forthcoming and future projects. Helped the team in designing and developing need-based QA process.
• Responsible for verifying applications and content during migration of web applications from Cold Fusion based site to Java Interwoven based site.
• Developed SQL scripts to validate input of the Core batch process and its output.
• Used Quality Center for writing test cases and test scripts and defect reporting, tracking and test management.
• Successfully tested various components of the front end application.
• Utilized FDR application specific ODS query tool to query FDR data.

Environment: UNIX (IBM AIX), MAINFRAME, Oracle 9i, DB2, JAVA Interwoven and WINDOW XP & Macintosh QC 10 and QTP 8.x.

Confidential

Sr QA Analyst

Responsibility:

• Responsible for handling all issues related to various applications assigned to QA team comprising resources.
• Organized meetings with business analysts, end users, apps developers and project managers as and when required.
• Created test plans and test cases for various projects.
• Extensively tested Oracle & UDB databases utilizing complex SQL querying.
• Used Mercury Quality Center for test management including defect management and test progress analysis.
• Wrote shell scripts to generate delimited data files from non-delimited data files on UNIX platform. Hands on experience in UNIX korn shell scripting.
• Worked on TCSF Application (The Collector System Financial). Successfully completed manual testing of various components of this GUI application.
• Validated data using TCL (Terminal Control Language prompt) of the application.
• Worked on TSYS, a proprietary application of Total Solutions. Verified and validated data in a cross-application scenario where data was modified and updated on TSYS

Environment: UNIX (IBM AIX), MAINFRAME, Oracle 10g, IBM UDB, and WINDOW XP.

Confidential

Development Tester/ SAS QA

Responsibilities:

• Responsible for setting up and maintenance of Test environment for various applications assigned to development testing team.
• Organized meetings with business users, developers and project managers as and when required.
• Lead a group of QA resources of development testing team. Coordinated with DBA and System Admin resources for Go Live phase of projects.
• Responsible for reporting test progress of various applications under test which included number and percentage of test cases executed; Test Case execution under progress; and reproduced and outstanding issues logged on day-to-day and weekly basis.
• Hands on experience in writing SQL queries and automating these through shell scripts.
• Developed SAS scripts to extract & load raw data into SAS datasets and DB2 / Oracle tables using DATA steps and Proc SQL.
• Created Lookup, Fact and Dim tables and Identifying the mapping data into specific domains as per the data model using SAS Enterprise Guide by creating the DATA and PROC steps as process tasks.
• Generated SAS datasets, tables, listings, graphs and reports from analysis datasets using SAS tools like BASE, Macros, Graph and STAT.
• Extracted data from Oracle views using various SAS/Access methods including Libname statements and SQL Pass through facility.
• Created and extracted Oracle tables from SAS and within Oracle by using PL/SQL using SAS/ACCESS and SAS/CONNECT.
• Created efficient SAS programs using SAS Macros and validated the same to optimize the resource utilization and faster processing. Documented and maintained libraries and catalogues of SAS programs and formats.
• Actively participated in transition activities and helped mapping legacy MBNA table/file layouts to legacy Confidential DB2 UDB based BACARDI database tables/ file layouts.
• Created Test Plans and Test Cases for various projects.
• Validated and verified earn and burn logics of SRS developed in Oracle CRM applications.

Environment: UNIX (HP-UX, IBM AIX), MAINFRAME, Oracle 10g, SAS 913, UDB DB2, Cognos ReportNet, WINDOWS