SUMMARY

• 8+ years of professional experience as a Data Analyst with excellent understanding, analyzing, and documenting Business Requirements, Functional Specifications, Business Process Flow, Business Process Mapping, data extraction, manipulation, visualization, validation techniques, and Data Modeling.
• Experience in all phases of Software Development Life Cycle (SDLC), Waterfall, and AGILE methodologies.
• Performed various system - related analytical activities within all the phases.
• Expertise in various phases like understanding the User Requirements, Analysis/Design, Testing, Project Management, & Product Development along with end-to-end product delivery across the SDLC & STLC phases.
• Ability to gather and document Business Requirements, experienced in writing Use Cases. Proficiency in SDLC life cycle, understanding the workflow concept, and ability to gather and document.
• Experience in data analysis, data visualization using Tableau/Microsoft Power BI, model building with machine learning algorithms for prediction and forecasting using data (historical or time series with regression techniques), using statistical/econometric tools like SAS and R, data mining using python, SQL, Hadoop, Spark, Hive, etc.
• Strong skills in SQL, data warehouse, data exploration, data extraction, data validation, reporting, and excel.
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
• Developed visualizations using Tableau for a better understanding of data, performed data cleaning, normalization, data transformation
• Extensively used SQL for accessing and manipulating database systems.
• Adept in RDBMS such as Oracle, MS SQL Server, and MS Access &also skilled at writing SQL queries and Stored Procedures.
• User Acceptance Testing (UAT) and Manual testing (Functionality Testing) of UI and Web Applications.
• Extensively worked in creating Test Procedures, Test plans, and Test cases and reviewing them for quality assurance.

TECHNICAL SKILLS

Data modeling Tools: ERwin, PowerDesigner

Project Management: MS Project

Methodologies: SDLC, JAD Sessions, Ralph Kimball Methodologies

Databases: Oracle, MS Access, SQL Server, Teradata

ETL Tools: Informatica PowerCenter

Reporting Tools: BO, OBIEE

PROFESSIONAL EXPERIENCE

Confidential, Philadelphia, PA

Data Analyst

Responsibilities:

• 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 warehouse 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 analyzed 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
• Used SQL Server Management Tool to check the data in the database as compared to the requirement given
• Validated the test data in DB2 tables on Mainframes and 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 the regional and country AML Compliance leads to support the start-up of compliance-led projects at regional and country levels. Including defining the subsequent phases of 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) and review of customer documentation.
• Description of End-to-end development of Actimize models for trading compliance solutions of 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 specifications 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 helps them, manage their risks prudently.
• KYC guidelines are to prevent banks from being used, intentionally or unintentionally, by criminal elements for money laundering activities

Confidential, Providence, Rhode Island

Data Analyst

Responsibilities:

• 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, and 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 credit, 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.
• 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 suite to develop the documents such as Visio for creating wireframes, Word, Excel, and PowerPoint for the creation of Business Requirement documents.
• Performed backend testing using SQL queries and analyzed the server performance on UNIX
• Also Used SnagIt for editing the Screenshots and in Jad sessions for screen sharing and presentations.
• Developed the front end using swing, DHTML, AJAX, and JSP pages.
• Integrated Requisite pro with a 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 contain test scripts, test cases, test data, and expected results for the User Acceptance testing.

Confidential, Buffalo, New York

Data Analyst

Responsibilities:

• 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, and 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 credit, 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
• 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 suite to develop the documents such as Visio for creating wireframes, Word, Excel, and PowerPoint for the creation of Business Requirement documents.
• Performed backend testing using SQL queries and analyzed the server performance on UNIX
• Also Used SnagIt for editing the Screenshots and in Jad sessions for screen sharing and presentations.
• Developed the front end using swing, DHTML, AJAX, and JSP pages.
• Integrated Requisite pro with a clear quest for requirements tracking.
• 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 contain test scripts, test cases, test data, and expected results for the User Acceptance testing.

Confidential, Columbus, Ohio

Data Analyst

Responsibilities:

• Involved in creating different reports based on the business request and ad hoc requirements using Tableau, and Power BI desktop.
• Prepare financial deliverables (quarterly, accrual, and budgetary reports) for funding agencies; as well as proof of concept, and solution mockups.
• Created Dashboards Scorecards, views, pivot tables, and charts, for further data analysis
• Define and communicate project scope, milestones/deliverables, and project requirements from clients.
• Lead pricing meetings with project managers to price out projects, and determine incentive budgets, revenue sharing among teams, and overall profit margins.
• Update high-level divisional directors quarterly with forecasts and revenue for all managed projects.
• Teamed with the application architect to document the process and workflow for various business scenarios.
• Provide recommendations for requirement options.
• Co-ordinate with business partners & functional units like Actuary, Strategic resources, etc.
• Integral part of the team, assigned the task of carrying out the budget planning of the project, thus, obtaining a grasp of the financial concerns of a project.
• Teamed with staff to document requirements as Business Requirement Documents (BRD) and Functional Requirement Documents (FRD).
• Created Source to target data mapping documents identifying key data elements and prepared Data Flow Diagrams

Confidential, Hicksville, New York

Data Analyst

Responsibilities:

• Developed and implemented specific reporting strategies to review various aspects of the loan portfolio, this has led to a large reduction of KER policy exceptions and improved audit reviews.
• Provided analytical insights to highlight trends and to focus attention on issues developing within the education portfolio, resulting in improved monitoring by third-party servicers on data integrity issues.
• Acted as subject matter expert with business partners on issues relating to the portfolio, improved information flow resolved data inconsistencies between internal clients.
• Involved in System Integration Testing (SIT), Regression Testing, GUI Testing, Performance Testing & User Acceptance Testing (UAT).
• Assist in achieving desired data quality by creating and executing appropriate test scenarios during the project lifecycle (system end-to-end testing, unit testing, UAT).
• Performing the quality assurance and testing database in CRM (Salesforce, Veeva) to ensure data integrity
• Used tools like Tableau and Microsoft Excel for data analysis and generating data reports