PROFESSIONAL SUMMARY:

• 7 Years of professional experience as Data Analyst with extensive experience in Banking domain with Master Data Management (MDM) experience.
• Diverse experience in Anti - Money Laundering (AML) and Know Your Customer (KYC), Client Onboarding - Business As Usual), Banking and Financial Services
• Design and development of Data warehouse for Business Intelligence data marts and reporting.
• Designed Physical Data Model (PDM) using IBM Info sphere Data Architect data modeling tool and ORACLE PL/SQL. 
• Extensive experience in conducting Market Research, Feasibility Studies, Data Analyses, Data Mapping, Data Profiling, Gap Analyses, Risk Identification, Risk Assessment, Risks Analyses, and Risk management.
• Experience in migrating data from DB2 to Netezza using NZload and ELT mappings (Datastage) in Data Integration layer
•  Implemented various Data Mining techniques using various Python packages, SPSS Statistics and SPSS Modeler tools
• Familiar with SOX Compliances and Basel II standards. Worked on data analysis of Mantas - Anti-Money Laundering (AML) Compliance data and supported user requirements.
• Implemented Actimize Anti-Money Laundering (AML) system to monitor suspicious transactions and enhance regulatory compliance.
• Hands-On experience in coding with Java (Map-Reduce), python scripts and php, html, xhtml, xml, pl/sql.
• Strong domain knowledge in the areas of CDD, OFAC, transaction monitoring, Fraud and suspicious activity reporting. 
• Involved in Security testing for different LDAP roles. 
• Created Informatica mappings and workflows for loading data from different sources to Fin Master
• Performed numerous Ad-hoc requests, financial reports involving SQL scripts, UNIX, SAS and Teradata
• Extensive experience with the SAS programming and in data step and with various SAS Procedures in Base SAS and SAS/Stat, including thorough knowledge of SAS Macro.
• Experience in development methodologies like RUP, SDLC, AGILE, SCRUM and Waterfall.
• Expert in TSQL DDL/DML, perform most of the SQL Server Enterprise Manager and Management Studio functionality using T-SQL Scripts and Batches
• Experience in working with Data Management and Data Governance based assignments. 
• Experience with reporting requirements and managing data quality
• Have extensive knowledge in Data flow modeling and Object modeling, case analysis and functional decomposition analysis.
• Deep Understanding and hands on experience on Data Sub setting, Profiling and cloning
• Expertise in Database Administration of Test Environment Databases, Data Pools and identifying the performance issues due to inefficient Database Administration
• Proficient in developing Use Case Model, Analysis Model, Design Model, Implementation Model, Use Case Diagrams, Behavior Diagrams (Sequence diagrams, Collaboration diagrams, State chart diagrams, Activity diagrams), Class Diagrams based on UML using Rational Rose
• Helped with Data Mapping between the data mart and the Source Systems
•  Experience in Business Intelligence (BI) Technologies like Microsoft Business Intelligence (SSIS, SSAS, and SSRS), Informatica, Business Objects, and OBIEE
• Experience in Korn Shell scripting in UNIX.
• Extensive Data Warehousing experience using Informatica as ETL tool on various data bases like Oracle, SQL Server, TeraData, MS Access.
• Strong experience in conducting User Acceptance Testing (UAT) and documentation of Test Cases. Expertise in designing and developing Test Plans and Test Scripts.

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

Sr. Data Analyst

• Lead Business Intelligence reports development efforts by working closely with Microstrategy, Teradata, and ETL team
• Senior level SQL query skills (Oracle and TSQL) in analyzing and validating SSIS ETL database data ware house processes
• Involved in conducting JAD sessions to identify the source systems and data needed by Actimize-SAM (KYC/CIP). . 
• Assisted with FATCA testing using internal software to ensure that proper controls were in place for the new regulation
• Developed report layouts for Suspicious Activity and Pattern analysis under AML regulations 
• Prepared and analysed AS IS and TO BE in the existing architecture and performed Gap Analysis. Created workflow scenarios, designed new process flows and documented the Business Process and various Business Scenarios and activities of the Business from the conceptual to procedural level.
• Analyzed business requirements and employed Unified Modeling Language (UML) to develop high-level and low-level Use Cases, Activity Diagrams, Sequence Diagrams, Class Diagrams, Data-flow Diagrams, Business Workflow Diagrams, Swim Lane Diagrams, using Rational Rose
• Worked with senior developers to implement ad-hoc and standard reports using Informatica, Cognos, MS SSRS and SSAS.
• Thorough understanding of various modules of AML including Watch List Filtering, Suspicious Activity Monitoring, CTR, CDD, and EDD.
• Used SQL Server Management Tool to check the data in the database as compared to the requirement give
• Validated the test data in DB2 tables on Mainframes and on Teradata using SQL queries.
• Identified and documented Functional/Non-Functional and other related business decisions for implementing Actimize-SAM to comply with AML Regulations. 
• Work with region and country AML Compliance leads to support start-up of compliance-led projects at regional and country levels. Including defining the subsequent phases training, UAT, staff to perform test scripts, data migration and the uplift strategy (updating of customer information to bring them to the new KYC standards) review of customer documentation.
• Description of End-to-end development of Actimize models for trading compliance solutions of the the project bank.
•  Automated and scheduled recurring reporting processes using UNIX shell scripting and Teradata utilities such as MLOAD, BTEQ and Fast Load
• Implemented Actimize Anti-Money Laundering (AML) system to monitor suspicious transactions and enhance regulatory compliance.
• Wrote specification to implement application feed for trade-processing lifecycles from pre-trade analysis to post-trade risk management, settlement and regulatory compliance with SunGard's Capital Markets and Investment Banking solution.
• Developed the systems implementation project management plan with milestones and steps from procurement of vendors to project implementation and maintenance.
• Worked with the Enterprise Datawarehouse team and Business Intelligence Architecture team to understand repository objects that support the business requirement and process
• KYC procedures also enable banks to know/understand their customers and their financial dealings better, which in turn help them, manage their risks prudently.
• KYC guidelines is to prevent banks from being used, intentionally or unintentionally, by criminal elements for money laundering activities

Confidential, Minneapolis, MN

Sr. Data Analyst

Responsibilities:

• Designed and Developed the Business Objects Universes which suit the standard, analytical and ad-hoc reporting requirements of the Business Objects users
• Designed and implemented basic SQL queries for QA Testing and Report / Data Validation.
• Created SAS programs that are used for data validation, statistical report generation and program validation and automated the Edit Check programs using Macros
• Responsible for Master Data management using IBM Info Sphere Web Server 
• Reviewed Stored Procedures for reports and wrote test queries against the source system (SQL Server) to match the results with the actual report against the Data mart (Oracle).
• Wrote BRD, FRD, use cases, test scenarios, test cases for testing the functional and non-functional aspects of both ETL jobs and Reporting jobs
• Created Databases, Tables, Views, and Stored Procedures in Netezza and optimized them
• Developed Functional and Regression Testing scenarios based on XML and XSD schema validations.
• Created use cases to depict the interaction between the various actors and the system and created data flow models, data quality analysis and performed cost/benefit analysis.
• Automated UNIX Shell scripts to pull and load data from operational resources into the Data Staging Area and Data Warehouse for business intelligence reporting..
• Identify customer marketing opportunities by applying data mining models and writing advanced T-SQL stored procedures and queries
• Using Python in data collection programming. 
• Conducted analysis on various tools available at the client to recommend the best possible option for different project, for example Informatica Data Explorer, Informatica Data Quality, Powercenter, Microstrategy, etc
• Prepared and analyzed AS IS and TO BE in the existing architecture and performed Gap Analysis.
• Creation of UML structure and behavior diagrams, Reporting using advanced Word/Excel skills (pivot tables, charting, VBA etc), writing basic SQL scripts.
• Facilitated the User Acceptance Testing (UAT) with Pega System Administrators and Business Users, documented any issues or defects and eventually got sign off from the right parties.

Confidential, San Ramon, CA

Data/ Business Analyst

• Interacted with Cash Management Division and Compliance Office to review the AML (Anti Money Laundering) requirements and provide Positive Pay service to reduce check fraud
• Communicated Project Requirements, Business Issues, Solutions and made recommendations.
• Used Agile life cycle Methodology for Iterative development and Rapid delivery of the product.
• Used SSIS to transform the data and load the data into flat files, Excel, Oracle, Netezza, DB2 and SQL Server Database
• Implemented Scrum as a part of agile methodology for work management and part of The Team in the Framework.
• AML transaction monitoring system implementation, AML remediation and mitigation of process & controls risk.Oversee systems related to BSA, AML, KYC, CIP, OFAC, FinCEN and BSA Risk
• Operating SWIFT messaging service for financial messages, such as letters of credits, payments, and securities transactions, between member banks worldwide. Worked on Data Profiling and Data Quality assessment for Siperian Data Warehouse, ODS and source systems using TOAD and IBM Information Analyzer tools.
• Interacted with Cash Management Division and Compliance Office to review the AML (Anti Money Laundering) requirements and provide Positive Pay service to reduce check fraud
• Data cleansing and creation of layouts and specifications for end-user reports, delivering an end-to-end Metadata Management solution in the process
• Provide metrics on data quality including whether the data conforms to CDD standards 
• Designed and developed Project document templates based on SDLC methodology
• Managed risk-based audits, due diligence and governance of new initiatives and compliance (AML (Anti-Money Laundering), SOX, Basel II, GLBA, PCI) programs to mitigate risks
• Used Microsoft Office suit to develop the documents such as Visio for creating wireframes, Word,Excel and Power Point for creation of Business Requirement documents.
• Performed backend testing using SQL queries and analyzed the server performance on UNIX
• Also Used SnagIt for editing of the Screen shots and in Jad sessions for screen sharing and presentations.
• Developed the front end using swing, DHTML, AJAX, and JSP pages.
• Integrated Requisite pro with clear quest for requirements tracking.
• Prepared the UML Use Cases using Rational Rose.
• Used MS Visio for flow-charting, process model and architectural design of the application.
• Documented business workflows textually as well as in UML diagrams according to Scrum for the stakeholder review.
• Reviewed Test Plans that contains test scripts, test cases, test data and expected results for the User Acceptance testing.