SHRUTI ARYA

Email adbzdu@r.postjobfree.com / Cell 551-***-****

SUMMARY

Business / Data Analyst with 4+ years of IT experience in financial services with projects ranging from SAS AML Implementation, SAS VA Reporting to support AML/KYC/SAR reporting, SAS 9.2 to SAS 9.4 migration, Data warehousing / Data Mart projects, and other product implementations.

Experienced in Integrating data from CRM’s (Customer), Montran (Wire System), FLEXCUBE DDA (Deposits), and SWIFT (MT 101 – Request for transfer, MT103 – Customer transfer, MT 104 – Internal Transfer, MT 200 / 202 – Bank Transfer)

Develop business requirement documentation and work closely with technology partners to translate BRDs into technical specifications and ultimate development, testing and implementation of technology solutions which may be required for specific projects.

Well versed with various methodologies like Waterfall and Agile.

Experienced with facilitating and participating in User Acceptance Testing (UAT)

Good understanding of Data warehouse concepts and building of Meta data Repository.

Strong SQL experience for creating ad hoc queries / reports using joins & aggregate functions.

Knowledge with data warehousing tools like Informatica and Oracle.

Excellent interpersonal, analytical, problem solving and communication skills with ability to interact with individuals at all levels. Understanding and executing resolution while maintaining strong business relationships.

Understanding of compliance rules and regulations as undergoing training/certification for ACAMS.

EDUCATION

Master of Science, (Punjabi University, Patiala -- India) – May 2007

Bachelor of Science, (Punjab University, Chandigarh -- India) - April 2005

TECHNICAL SKILLS

Software: SAS AML, SAS VA, SAS 9.2, SAS 9.4, Jira, Impulse, Informatica, MS Visio, SQL plus, Quality Centre, MS Excel, MS Access, MS Word, BO, and SharePoint.

Languages: SQL and HTML

Operating Systems: Windows XP/7 and UNIX.

Database: SQL Server and Oracle 10g/11g.

BUSINESS / DATA ANALYST, STRATACENT Oct 2014 - Present

Work as Business Analyst at Stratacent, a Data Driven Solution company headquartered at Jersey City, NJ supporting multiple clients within financial services industry.

Worked as AML Analyst on GATS project for SAS AML implementation at Societe Générale.

Société Générale implemented SAS AML & SAS VA platform as part of modernizing and strengthen their AML Compliance technology systems and program. Worked as AML Analyst on GATS project for SAS AML implementation at Société Générale and worked closely with Compliance team to create data/rule mappings to be configured in SAS AML platform and the source systems (Montran (Wires), FlexCube (Deposits), BDR (Customers Data), and SGAS Broker Dealer database). As part of the project created a monthly dashboard of AML statistics reporting in SAS VA platform covering the lifecycle of transactions flowing through AML process from alert generation to SAR reporting.

Responsibilities

Worked with compliance business users to identify all the systems and corresponding data requirements to be integrated with the SAS AML platform.

Worked with the SAS AML project team to map the source system data to SAS AML rules and coordinated the configuration and testing of the rules in the platform.

Integrated data from BDR (Customer), Montran (Wires), FLEXCUBE DDA (Deposits), and SWIFT (MT 101 – Request for transfer, MT103 – Customer transfer, MT 104 – Internal Transfer, MT 200 / 202 – Bank Transfer)

Created a set of data quality rules to be implemented by source systems and SAS Core platform as part of nightly batch process and exception reports control process.

Gathered reporting requirements (Operational and Management) and developed mock up screens to be created in SAS VA platform.

Created & Managed defects in Quality Center database as part of the project.

Executed testing of critical functionality/reports prior to passing the testing to business users. Facilitated UAT with Compliance business team.

Onboarded JIRA platform for Compliance GATS team for the ongoing enhancement and bug tracking post project implementation.

Participated in regular code reviews process to better understand of the dataflow and making sure the business logic and transformation are correctly applied.

Executed SQL queries and performed extensive data analysis in Excel to validate the enhancement of rules are correctly applied in the system and reports.

Worked with cross functional teams in Montreal and US NY for the initial configuration of JIRA systems and the corresponding enhancements needed to support specific AML Compliance group workflows.

Provided a single point of contact to maintain a consolidated list of all issues and enhancements to be reported into weekly management meeting with head of AML Compliance.

Environment/Tools: SAS AML, SAS VA, SAS EG, Jira, Oracle 10g & 11g, MS Excel, MS Word, MS Visio, MS Access, Clear Quest, SQL Plus, SharePoint.

Support multiple project at Freddie Mac in enhancing of Corporate Data Warehouse (CDW), SAS 9.2 upgrade to SAS 9.4, SAS Development/ Enhancement projects.

Responsibilities

Gathered requirements from multiple downstream systems working on multiple releases and critical & time sensitive projects.

Developed Business Requirement Documents, Data Mapping Document, Test Plans, and other required document artifacts required by SDLC.

Created a business Questionnaire with prepopulated information for each SAS application and coordinated meetings to validate the information with each application owner.

Gathered reporting requirements (Operational and Management) and developed mock up screens that were used to create reports in BI platforms.

Created & Managed Problem Reporting tickets in Clear quest for each release and tied it to RTMs.

Created and maintained the Meta Data templates and worked with Data Modeler to ensure all key required attributes & information is captured and provided on a periodic basis.

Participated in regular code reviews process to better understand of the dataflow and making sure the business logic and transformation are correctly applied.

Extensively worked in Toad to create and execute SQL scripts for Data analysis and identifying & fixing gaps if any.

Used MS-Visio to prepare Current State / Future State business processes (Gap Analysis) to highlight the Gap and outline the future capabilities of the products.

Developed Meta Data repository to document the Source to target mapping.

Documented Process flow diagrams for critical projects which involved multiple exchange of information with external systems.

Created and maintained Action/Issue list to resolve critical issues on time.

Environment/Tools: Oracle 10g & 11g, MS Excel, MS Word, MS Visio, MS Access, Clear Quest, SQL Plus, SharePoint, and SAS.

Contact this candidate