SUMMARY

• 8+ years of professional experience in the Information Technology (IT) Industry serving as a Data Analyst.
• Experience in Data Analysis, Business Process Analysis/Modeling, Database Design, Data warehousing, Data Mapping, Development of Web Based, and Client/Server Applications with domain of Banking, and Finance.
• Experience on Full life cycle of the project using methodologies like Agile, Waterfall, RUP and hybrid methods.
• Extensive knowledge on Financial Information eXchange (FIX) protocol related to securities transactions, markets and Electronic Trading System. 
• Strong Knowledge in building the AzureCloud Databases and transferring data to Azure using SSIS.
• Experience in analyzing/troubleshooting and providing technical support for Oracle/Unix applications and their interfaces.
• Extensive experience on business intelligence (and BI technologies) tools such as OLAP, Data warehousing, reporting and querying tools, Data mining and Spreadsheets.
• Extensive Risk Management experience conducting fraud and risk investigations for financial institutions and payment processing organizations
• Strong knowledge and experience with trading and analysis of fixed income securities (Bonds, ABS, MBS, CMOs, and CDOs), equities, derivatives (futures, options, forwards, exotic options, swaps, interest rate derivatives and FIX messaging structures, and integration of market data feeds such as Bloomberg and Reuters, understanding trade life cycle and custodial banking
• Experienced in creating documentation, providing production support, development and enhancements on oracle (SQL, PLSQL), UNIX and Cognos/QlikView (BI Tools) projects.
• Extensive experience in Data Analysis and ETL Techniques for loading high volumes of data and smooth structural flow of the data.
• Strong understanding of finance requirements and regulatory compliances, CCAR Regulatory Reporting, Basel II, Dodd Frank Act, Bank Secrecy Act, Customer Identification Program (KYC).
• Adept at writing Data Mapping Documents, Data Transformation Rules and maintaining Data Dictionary and Interface requirements documents.
• Worked on integration and implementation of projects and products, database creations, modeling, calculation of object sizes, table spaces and database sizes.
• Experience with creating reports using Business Objects.
• Experience in testing the complex COGNOS reports developed, supporting the Testing Team, writing the Test cases and creating the Test Data.
• Knowledge on regulatory reporting framework and Reporting domain projects like Basel Reporting, CCAR, and Liquidity Reporting.
• Executed Test Plan, Test Scripts, and Test Cases based on Design document and User Requirement document for testing purposes.
• Extensive experience in the testing environment, which included User Acceptance Testing (UAT), functional testing and system testing and defect tracking using ClearQuest.
• Experience with Star schema modelling and knowledge of Snowflake dimensional modelling.
• Experience with SQL, PL/SQL objects.
• Experience in creating UNIX scripts for file transfer and file manipulation.
• Excellent knowledge in Database Creation and maintenance of physical data models with Oracle, Netezza, DB2 and SQL Server databases.
• Highly proficient in the use of T - SQL for developing complex stored procedures, triggers, tables, user functions, user profiles, relational database models and data integrity, SQL joins and query writing.
• Possess strong Documentation skills and knowledge sharing among team, conducted data modelling review sessions for different user groups, participated in sessions to identify requirement feasibility

PROFESSIONAL EXPERIENCE

Confidential, McLean VA

Sr. Data Analyst

Responsibilities:

• Performed extensive data modelling to differentiate between the OLTP and Data Warehouse data models
• Analyzing and mining business data to identify patterns and correlations among the various data points.
• Working closely with data mapping SME and QA team to understand the business rules for acceptable data quality standards.
• Performed data profiling on datasets with millions of rows on Teradata environment, validating key gen elements, ensuring correctness of codes and identifiers, and recommending mapping changes.
• Wrote complex SQL queries to identify granularity issues and relationships between data sets and created recommended solutions based on analysis of the query results
• Delivered Enterprise Data Governance, Data Quality, Metadata, and ETL Informatica solution
• Maintained Excel workbooks, such as development of pivot tables, exporting data from external SQL databases, producing reports and updating spreadsheet information.
• Performed documentation such as Regulatory Reporting FR Y-14A/Q, FR Y9, FFIEC 041, FFIEC 031 reports and Dodd Frank (Dodd-Frank Act Stress Test).
• Met with stakeholders and users to review / manage expectations and identify opportunities to improve ROI.
• Mapped trade capture reports from existing legacy files to Financial Information eXchange (FIX) Messaging Queue (MQ) in order to be compliant with Depository Trust Clearing Corp (DTCC)/National Securities Clearing Corp (NSCC) standardized format.
• Interfaced with business users to verify business rules and communicated changes to ETL development team.
• Executing SQL queries to perform Data Integrity testing on a Teradata Database to validate and test data using TOAD.
• Worked directly with the Azure Product team in tracking and resolving defects in the beta Azure IaaS offering.
• Worked on the ETL Informatica mappings and other ETL Processes (Data Warehouse)
• Provided multiple demonstrations of Tableau functionalities and efficient data visualizations approaches using Tableau to the senior management at the client as part of the BRD.
• Involved in data validation of the results in Tableau by validating the numbers against the data in the database tables by querying on the database
• Acquire data from primary or secondary data sources like RedShift, FTP, and external or internal files; extract and Analyse
• Created Stored Procedures data to generate reports.
• Worked on Gap analysis (AS-IS) & (TO-BE) by identifying existing processes, technologies, and documenting the enhancements needed to meet the end state requirements.
• Accomplished various tasks in big data environment which involved Microsoft Azure Data Factory, Data Lake, and SQL server.
• Involved in creating logical and physical data modelling with STAR and SNOWFLAKE schema techniques using Erwin in Data warehouse as well as in Data Mart.
• Worked in database objects like tables, views, materialized views, procedures and packages using Oracle tools like Toad, PL/SQL Developer and SQL plus.
• Usedwindows Azure SQL reportingservices to create reports with tables, charts and maps.
• Involved in developing Data Mapping, Data Governance, Transformation and Cleansing rules for the Master Data Management Architecture involving OLTP, ODS and OLAP.
• Performed migration of Confidential SQL server to Azure SQL database.
• Created various transformation procedures by using SAS, ETL and SAS Enterprise guide.
• Involved in Data Modeling of both Logical Design and Physical Design of Data Warehouse and DataMart’s in Star Schema and Snow Flake Schema methodology.
• Involved in Informatica MDM processes including batch based and real-time processing.
• Responsible for reviewing data model, database physical design, ETL design, and Presentation layer design.

Confidential, Boston, MA

Data Analyst

Responsibilities:

• Collaborates with cross-functional team in support of business case development and identifying modelling method(s) to provide business solutions. Determines the appropriate statistical and analytical methodologies to solve business problems within specific areas of expertise.
• Builds models and solves complex business problems where analyses of situations and/or data require in-depth evaluation of variable factors.
• Generating Data Models using Erwin and developed relational database system and involved in Logical modelling using the Dimensional Modeling techniques such as Star Schema and Snow Flake Schema.
• Participate in documenting the data governance framework including processes for governing the identification, collection, and use of data to assure accuracy and validity.
• Participated in Creation of Azure Web Application projects.
• Metrics reporting, data mining and trends in helpdesk environment using Access
• Involved in loading the data from the flat files submitted by vendors into the Oracle12c External tables, extensively used ETL to load data from Oracle database, XML files, and Flat files data and also used import data from IBM Mainframes.
• Involved with ETL team to develop Informatica mappings for data extraction and loading the data from source to MDM Hub Landing tables.
• Involved in MDM Process including data modelling, ETL process, and prepared data mapping documents based on graph requirements.
• Involved in developing pipelines to transform data using activities like U-SQL scripts on Azure Data Lake Analytics.
• Used Pivot tables, VLookups and conditional formatting to verify data uploaded to proprietary database and online reporting.
• Performing data management projects and fulfilling ad-hoc requests according to user specifications by utilizing data management software programs and tools like Perl, MS Access and Excel.
• Coordinated with Data Architects and Data Modelers to create new schemas and view in Netezza for to improve reports execution time, worked on creating optimized Data-Mart reports.
• Worked on the Microsoft Azure environment (blob storage, Data Lake, AZ copy) using Hive as extracting language.
• Evaluate, identify, and solve process and system issues utilizing business analysis, design best practices and recommended enterprise and Tableau solutions.
• Used advanced functions like VLookups, Pivots, graphs, and analytical and statistical tool packs in Excel.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Extensively used SQL Server2014 tools to develop Oracle stored packages, functions and procedures for Oracle database back-end validations and Web application development.
• Perform analyses such as regression analysis, logistic regression, discriminate analysis, cluster analysis using SAS programming.

Confidential, San Antonio, TX

Data Analyst

Responsibilities:

• Facilitated Joint Requirement Planning (JRP) sessions with SME’s in understanding the Requirements pertaining to Loan Origination to Loan Processing
• Senior level SQL query skills (Oracle and TSQL) in analyzing and validating SSIS ETL database data ware house processes.
• Collaborate with front to back business stakeholders to develop test plans and test cases to execute across various scenarios and to ensure a comprehensive F2B testing.
• Worked closely with the Enterprise Data Warehouse team and Business Intelligence Architecture team to understand repository objects that support the business requirement and process.
• Implemented and Used SWIFT messaging system to test the flow of messages from and into the new system and was also involved in ETL process
• Managed the IT Software development of the Treasury & Capital Markets systems, supporting Foreign Currency, Derivatives transactions, fixed income, and payment systems with interfaces to Swift, Chips, and Chaps.
• Documented the Current and Future State Accounting Work flow as part of Online Payments.
• Involved in the creating the User Interface Specification Document and User Training Manual as per project specification with the help of development team.
• Involved in creating Azure SQL database, performed monitoring and restoring of Azure SQL database.
• Assist end users and IT staff in the use of data to satisfy informational and reporting requirements using SQL and DBMS
• Assisted in designing new UI and XML standards using ACOORD standards.
• Developed Test cases for manual testing and automated them using Win Runner, Silk, Load Runner, Silk performer and QTP.
• Made selections on the Wire Frames and User Interface (UI) Designs for the software application.
• Created and managed Project Templates, Use Case Project Templates, Requirement Types and Traceability Relationships in RequisitePro.
• Extensively involved in the modelling and development of Oracle Data Warehousing System.
• Validated and Updated XML files.
• Involved in creating automated Test Scripts representing various Transactions, Documenting the Load Testing Process and Methodology
• Performed extensive data modelling to differentiate between the OLTP and Data Warehouse data models
• Conducted Functional Walkthroughs, User Acceptance Testing (UAT), and supervised the development of User Manuals for customers.
• Developed Use Case diagrams, business flow diagrams, Activity/State diagrams and Sequence diagrams using Rational rose so that developers and other stakeholders can understand the business process.
• Prepared Need Analysis Documents of the requirements gathered through JAD sessions.
• Maintaining SQL Script for creation of Database Objects using VSS (Visual Source Safe).
• Tested the final application for Usability testing to verify whether all the User Requirements were catered to by the application.

Confidential, Bethesda, MD

Data Analyst

Responsibilities:

• Translated business needs into data analysis, business intelligence data sources and reporting solution for different types of Clients and also involved in JAD sessions to identify the flows and processes involved in the content.
• Involved in migration of various objects like, stored procedures, tables, views from various data source to SQL Server.
• Created various weekly and monthly portfolio reports showing detailed information by using SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Checks and Unique) in writing Transact SQL (T-SQL) queries and Dynamic-queries.
• Join tables by employing SQL INNER JOIN, INTERSECT, UNION ALL and UNION syntax
• Created various SQL Schema, Triggers, views, index/keys and stored procedures along with compiling them in SQL server and troubleshoot errors.
• Used complex query statements like, sub queries, correlated queries, and derived tables, CASE functions to insert the data depending.
• Use SSIS to run ETL project where total data size is a little over 1TB. The transformation process is going through different SSIS transformation tools. SSIS package is executing in parallel using TPC-H data generator where they will write in a single database destination and also provided production support to analyse and fix problems-errors on daily basis by modifying those packages and Stored Procedures if necessary.
• Involved in creating ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing transformations using SSIS packages
• Involved in creating SSRS Report Model Projects in MSBI studio and created, modified and managed various;
• Generated Complex reports like reports using Cascading parameters, Snapshot reports Drill-down Reports, Drill-Through Reports, Parameterized Reports;
• Report Models and ad hoc reports using SSRS based on Business Requirement Document and configured them using report server configuration manager along with deploying it on a report server.
• Used Database Mirroring for increasing database availability.
• Involved in developing Mapping of data lineage for each attribute stored in different data warehouses and across several source systems.
• Represented the business requirements in various alternative views such as analysis models, process flow diagrams and user stories.
• Establish documentation for agile methodology for implementation with a very water-fall-centric development team.
• Implemented transformation component of Data Stage to integrate the data and to implement data to implement the business logic
• Implemented data access, storage and validation routines on the database server using Procedural Language/Structured Query Language (PL/SQL).
• Responsibilities include gathering business requirements, developing strategy for data cleansing and data migration, writing functional and technical specifications, creating source to target mapping, designing data profiling and data validation jobs in Data Stage, and creating ETL jobs in Data Stage.

Confidential, Wilmington, DE

Data Analyst

Responsibilities:

• Interacted with Business Users to conduct thorough Requirements Analysis.
• Reviewed and analyzed the business environment and identified process improvements.
• Involved in extensive analysis on security trading cycles; provide consulting on financial disclosure, regulatory and compliance issue.
• Involved in interactions with the Subject Matter Expert, Project Manager, Developers, and the End-Users.
• Coordinated activities with project manager and various other teams using MS Project.
• Interacted with other Business Analysts for designing and implementation of Use Cases and Test Plans.
• Involved in developing Logical and Physical data models that capture current state/future state data elements and data flows using Erwin.
• Involved in reviewing test plans and test cases and ensuring test cases reflect user needs. Also responsible for conducting user training and user acceptance testing to ensure and verify system is designed according to user needs.
• Worked on SDLC, Business analysis, GAP analysis and Quality Assurance of application software in Agile framework.
• Involved in generation and execution of SQL queries.
• Assisted in on-going process improvement efforts to ensure Test Planning, Execution, and Reporting is effective, efficient, standardized, coordinated, and integrated.
• Assisted the Senior Business Analyst in writing Functional Requirement Specifications (FRS) and User Requirement Specification (URS).