SUMMARY

• Senior Business/Data analyst with over 8+ years of experience in the domain of Banking and financial services with solid understanding of Business Requirement elicitation techniques, Business Requirements Gathering, Business Process Flow and Business Process Modelling.
• Strong understanding of Mortgage banking, Credit Approval System, MBS, SOX and Basel accords and Investment banking (Stock exchange, fixed income, Stocks/bonds, equities, options/futures, trading operations, mutual funds etc.).
• Experience conducting JAD (Joint Application Development) sessions with Stakeholders and Business Partners to resolve issues.
• Expertise in the field of Business Analysis, Risk Analysis, Software Validations in Banking projects, multi - tier, and web based application for various horizontal and vertical industries.
• Excellent skills in Business Analysis, Data Analysis, Rapid Application Development, Requirement Analysis, Business Process Modelling and Use Case Development as well as Activity Diagrams, Class Diagrams and Sequence Diagrams using UML methodology.
• Experience Working on Loan IQ (LIQ), SharePoint and Virtual Board Room systems/ applications.
• Strong experience in Data Centric (analysis, validation), Data Validation, Data Modelling, Data Profiling, Data Verification, Data Mapping, Data Loading, DataWarehousing/ETL testing and BI Reports Testing.
• Excellent knowledge in Corporate Finance, Investment Banking, Asset Management, Interest Rate Risk, Debt and Equity Financing, Wealth Management, Derivative products such as Options and Futures, Swaps and Swap Options involving Credit and Interest rate and other OTC derivatives, Fixed Income, Trade Life Cycle, OMS (Order Management Systems), FIX protocol, Mortgage, Bonds, Section 508, Sarbanes Oxley Act (SOX), GAAP.
• Knowledge of Commercial Lending Systems like Loan IQ. Familiarity with Consumer Lending Processes.
• Strong understanding of all annuities (fixed, indexed, and variable)
• Strong Analysis knowledge of Derivatives Trading Operations, Products and Markets, Capital Management, Portfolio Analysis, Stock Valuation, Project Auditing and Financial Forecasting.
• Extensive experience in working with Risk Management, Mortgage Loan Servicing, and Commercial and Residential mortgage, CMBS, MBS, Mortgage Pre-payment risk, Risk Analytics for MBS, Loan Servicing, Loan Ordination, CMBS, Secondary Mortgage Market.
• Vast experience in working with Capital Markets, Money Markets, Trading Systems, Derivatives (Strong in Options), Equities, Fixed Income, US government Treasury Securities (T-Bills, T-Bonds and T-Notes), Municipal Bonds, Corporate bonds, junk bonds, convertible bonds, Commercial paper, Stocks Trading Cycle, Margin Requirement, Mark to Market, and Hedge Funds.
• Experienced with Mortgage Servicing, Loan Monitoring, LOS and Assets Management.
• In depth knowledge of Trade Settlements process between Loan IQ and IHSMarkit Trade Settlement platforms (ClearPar& Loan Settlement Manager) as well as the communication methods between these applications (Webservices& Message Director)
• Comprehensive knowledge of Anti Money Laundering (AML), Bank Secrecy Act (BSA), BASEL II and III, and Dodd-Frank Act.
• Extensive experience in developing and enhancing applications for financial processes including Hedge Funds Pricing, Trade and Settlements operations.
• Experience with creating of UML diagrams such as Activity, Use Case, Flowcharts, using rational products and MS Visio.
• Proficiency in performing Data Validation and Preparation of TestData in UNIX environment using various UNIX commands and editors.
• Adept in data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Data Transformation Services (DTS), Bulk Copy (BCP), creating Dynamic packages for Incremental Loads and Data Cleansing in Data Ware House.
• Extensive understanding of Software Development Life Cycle (SDLC) including Waterfall, Agile Scrum and Rational Unified Process (RUP).
• Experienced in conducting GAP Analysis, User Acceptance Testing (UAT), Operational Readiness Testing (ORT), SWOT analysis, Cost benefit analysis and ROI analysis.
• Extensive experience in gathering and documenting Business and Functional Requirements (BRD, FRD), User requirements, Use Cases, System Requirement Specs (SRS). Prototyping, Surveys, User Stories, Joint Application Requirement / Design (JAR / JAD) and Brainstorming.

TECHNICAL SKILLS:

BI Tools: Tableau, Microstrategy, Cognos, Business Object, Crystal Reports, SAP BI & BW Ms SQL (SSRS)&Qlikview.

IDE Tools: Rational Rose, Rational Clearquest, Rational Clearcase, MS Visio &UML

Testing Tools: HP Quality Center, Relativity, Bugzilla, JIRA, Test Director,Win Runner, Load Runner, Mercury, TestNG Rational functional tester& Rational Clear Quest.

ERP Package: Peoplesoft, Oracle E Business Suite R12 &11i & SAP ECC, Saas

Database/DB Tools: MS SQL, My SQL, SOQL, Access, Toad, Workflow Builder& Oracle PL/SQL

Languages: SQL,C, C++ & Python.

Operating System: Windows, Mac Os, Unix & Linux.

Methodologies: Rational Unified Process, Agile & Waterfall

Modeling: Erwin, Balsamiq, Bizagi, LucidChart& Visio

Tools: /Utilities MS Office, MS Project, Visio, Talend, Collibra, Golden Gate, Servicenow, Innotas, Salesforce, Primavera, Citrix, VB/VBA, Cisco Jabber, Trello, Webex& JIRA&UML.

ECM: Onbase, FileNet, Adobe Experience Manager &Sharepoint

ETL Tool: Informatica, Mulesoft, Ab Initio & SSIS.

PROFESSIONAL EXPERIENCE

Business Analyst

Confidential, McLean,VA

Responsibilities:

• Manage and led the project scope, schedule, financials, risks and quality of the project and help ensure business value is achieved.
• The average project team consists of 10-15 core team members active participate in project planning, delivery, and transition. All of this is handled in a fast paced, dynamic environment.
• Assisted / Trained members of the project team on understanding the Standard Project Life Cycle Framework.
• Extensively worked on Agile Methodology framework.
• Understanding of Test Driven Development (TDD), Behavior Driven Development (BDD) used in test-centric development.
• Used JIRA for User Story requirements management throughout the AgileSprints and development life cycle.
• Competent in risk management and recognize and/or recommend alternative solutions.
• Strived to establish and maintain a trusted advisor relationship
• Maintained document acceptance criteria in User Stories using Behavior Driven Development BDD
• Responsible for creating, analyzing and reviewing business requirements, System specifications and project schedule documentation - Project Plans, Process Flows, Use Cases, BRD, FRD, Technical Design Document.
• Generated a streamline process to understand the various steps in the loan lifecycle and desired functionality of the new system by interacting with users, management, SME (Subject Matter Expert), stakeholders, lenders, underwriters.
• Worked towards continuous improvement of Agile and scrum practices.
• Worked with Project Manager/Leads in creating the work break down structure (WBS) from the client requirement documents or request for proposal (RFP). Assisted in creating schedule, resource planning and artifact template creation activities.
• Worked with IDQ on setting Business Rules and Designed Workflows for Data Validation.
• Conducted benchmarking / competitor analysis to support Equities business managers in developing business plans (short and long term).
• Strong understanding of indexed funds like ETFs.
• Review and approve Business Requirement Documents for customization efforts of the new LOS to ensure all business functions are available in the future state.
• Interacted extensively with customers and UI designers to determine ways to improve the UI feel and the user experiences.
• Documented the gathered business requirements into detailed Business Requirement Documents (BRDs) for BASEL III and its Addendum.
• Gathered business requirements through interviews, surveys, prototyping and worked with team to identify gaps and defects.
• Conducted extensive meetings and JAD Sessions to collect the data requirements and technical specifications to move ahead with the analysis team and business clients to accomplish application enhancement and production.
• Analyzed, prioritized and managed the requirements using Rational Requisite Pro.
• Involved in development of Test Plans & Test Cases and conducting User Acceptance Testing (UAT). Assisted the QA team in different phases of testing such as System testing, Functional testing, Regression testing and Integration testing for Quality Analysis.
• Assisted in modelingUI wireframes, mock-ups and documenting the end-user's workflow and business processes.
• Assisted the Project Manager in setting realistic expectations, in evaluating the impact of changes on the organization and plans accordingly and conducted project related presentations. Coordinated activities with project manager and various other teams using MS Project.

Environment: UML, Rational Rose, Rational Requisite Pro, BDD, Agile, MS Word, TDD, MS SharePoint, MS Office, MS Project, Teradata, Teradata Studio.

Business Analyst/Data Analyst

Confidential, Lowell, AR

Responsibilities:

• Worked closely with the senior management to understand the business needs, to drive the requirements.
• Design and develop interactive, real-time BI dashboards using Tableau and Alteryx.
• Write complex SQL queries with multiple joins to automate/manipulate these extracts in Alteryx.
• Used Alteryx to cleanse, prep and blend data from various data sources and output data in various file formats like Excel, Tableau and PDF.
• Perform end to end Data validation to maintain accuracy of dataset
• Automate various reports using Alteryx and plot data in Tableau, thereby, saving several hours of daily manual work and making useful data available to stake holders.
• Analyze data using Excel, Power Pivot, SQL ServerBusiness Intelligence Development Studio and Alteryx.
• Maintain and administer Alteryx and Tableau server instances using Alteryx Designer and Tableau Professional applications.
• Managing user groups and permissions for Specialty AnalyticsTableau Server.
• Create and manage Tableau Landing Page for Specialty Analytics Business Unit and redirection sites.
• Maintain Share point portal, HTML pages corresponding to Tableau dashboards.
• Data extraction, data cleaning, exploratory data analysis, data transformations, data modelling and data visualizations using R, SQL and Tableau
• Adept in writing R scripts while working with Oracle R Enterprise (ORE)
• Performed Ad-hoc reporting/customer profiling, segmentation using R/Python.
• Created a database schema (Oracle) with several tables containing the data related to application details, DB and OS details, Asset configuration details, Server details and developed several queries to obtain encryption readiness results.
• Developed Map Reduce/ Python modules for machine learning & predictive analytics in Hadoop on AWS.
• Created several corresponding ISD (Integration Specific Document) which includes interface list (In-bound/Out-bound), detailed file sizes, production support details (SLA's, servers etc.,)
• Created functional specific document for the Phase3 work including but not limited to Informatica requirements, architectural s, ETL sequence diagrams, data mappings, quality management, use cases and data reconciliation details
• Created wellness check scripts (SQL) to make sure the both stage and production environments are getting the data as intended and addressing all the production related issues
• Worked with various LOB Directors to identify third party hosted applications and prioritized them based on severity of risk, vulnerability and solution availability
• Worked on Cyber Security Questionnaire, requesting responses from all the corresponding Application Managers with in due date for each Phase, based on risk rating ( Critical, High, Medium and Low)
• Coordinated with GTAC ( Global Technology Architecture Committee) and laid out three layer Encryption Strategy Solution aka foundation level, container level and application level
• Reached out to ADM's (Application Development Managers) for data at rest applications to determine the DB and OS types and versions and then created a GTAC supported compatible matrix using Excel to see which applications have a solution and which ones need an upgrade (Software/Hardware)
• Completed the POC (Proof of Concept) to ensure the encryption solution works as intended and to determine the changes required to implement the solution
• Performed S3buckets creation, policies and also on the IAM role based polices and customizing.
• Designed and developed NLP models for sentiment analysis.
• Developed Spark/Scala, Python for regular expression (regex) project in the Hadoop/Hive environment with Linux/Windows for big data resources.
• Experience with dimensional and relational database design, ETL and life cycle development using Informatica Power Center, Repository Manager, Designer, Work flow Manager and Work flow Monitor
• Responsible for handling defects and escalations making sure they are addressed within time by updating corresponding documents (DDL,s, Mappings, Model changes etc.)
• Strong work on Data Mining and responsible for generating reports and dashboards with numbers and graphs to make sure loan processing times and work pipeline is properly routed as needed.

Environment: Benefit Builder, Alteryx, RxCLAIM, eCRD, eCPM, SQL/Server, MS-Office, Informatica, ER Studio, XML, Hive, HDFS, Flume, Sqooq, R connector, Python, R, Tableau.

Business Analyst

Confidential - Detroit, MI

Responsibilities:

• Collaborated with the stakeholder and performed the requirement gathering through conducting workshops, interviews, JAD sessions, research and identified the business process for the implementations.
• Translated the business requirement into the functional and nonfunctional requirement documents and system requirement specification documents.
• Designed and developed Use Cases, Sequence Diagrams, Activity Diagrams, OOD (Object oriented Design) using Rational Rose and MS Visio.
• Designed the Data Warehousing ETL procedures for extracting the data from all source systems to the target system.
• Designs and develops the logical and physical data models to support the Data Marts and the DataWarehouse.
• Involved in business process re-engineering, including gathering and documenting requirements, documenting workflows and developing specifications for the programmers. Liaison with the business and understand technical/functional requirements.
• Performed Data Profiling of the current state of data in the Data Warehouse by doing Data Analysis using SQL Queries and Microsoft Excel, finding Gaps in Data and formulating solutions for the same.
• AnalyzedHIPAA 5010 related to 837(Claim),835(Payment & Remittance), 270,271(Eligibility Enquiry response), 275 (Patient info),276 and 277(Claim Status Enquiry & Response) transactions and performed Gap Analysis between the 4010 and 5010 to improve and implement enterprise solutions to ensure compliance.
• Implemented the entire Rational Unified Process (RUP) Methodology of application development with its various workflows, artifacts, and activities.
• Worked on HIPAA claim master integrated with the Microsoft SQL server utility to process the data from the datawarehouse.
• Experience with advanced analytics utilizing healthcare payor data (health insurance/claims/Medicare).
• Assisted with the implementation and day-to-day administration of the HIPAA privacy compliance program. Good Understanding of clinical practice management, medical and laboratory billing and insurance claim with processing with process flow diagrams.
• Created reports from SAP modules using Business Objects / Crystal Reports based on business requirements.
• Worked with ETL QA team to plan and create complete test cases, test plans, test data, and reporting status to ensure all the business requirements are successfully tested.

Environment: Rational Suite (Rose, Requisite Pro), Rational Unified Process (RUP),HIPAA, ETL, Informatica, Rally, Jira, Agile, Windows XP/2000, Oracle, PL/SQL, MySQL, MS-Project, MS-Office Suite, MS Visio, MS Word, MS Excel.

Business Analyst

Confidential - St. Louis, MO

Responsibilities:

• Gathered business requirements through interviews, surveys with users and Business analysts.
• Involved in preparing Logical Data Models and conducted controlled brain-storming sessions with project focus groups.
• Worked on Conceptual, Logical Modeling and Physical Database design for OLTP and OLAP systems.
• Created a logical design and physical design of the centralized relational database.
• Responsible for logical and physical data modeling, database design, star schema, snow flake schema design, data analysis, documentation, implementation and support.
• Used Star schema methodology in building and designing the Logical data model in the dimensional Models.
• Created data model for the Star Schema using Erwin, created DDL scripts for static dimensions and ETL Mappings using DataStages.
• Widely used Normalization methods and have done different normalizations (3NF).
• Involved in logical and physical designs and transforming logical models into physical implementations.
• Conducted team meetings and JAD sessions.
• Created DMR mapping spreadsheets, Source to Target mapping documents including the transformation rules.
• Involved in business process modeling using UML through Rational Rose.
• Used Rational Requisite Pro to document technical requirements and business user requirements.
• Analyzed business requirements, transformed data, and mapped source data using the Teradata Financial Services Logical Data Model tool, from the source system to the Teradata Physical Data Model.
• Created logical data model from the conceptual model and it's conversion into the physical database design using forward engineering in Erwin 4.0
• Extensively used Star Schema methodologies in building and designing the logical data model into Dimensional Models.
• Designed, Developed and Supported Extraction, Transformation and Load Process (ETL) for data migration using Informatica.
• Worked extensively in documenting the Source to Target Mapping documents with data transformation logic. Create Data Functional Design document.

Environment: Windows Test Technologies (WTT) for Test Case Management, Product Studio for Bug Logging and Tracking, C#.NET,MITA(Microsoft Internal Test Automation), Oracle DB, SQL Server, HTML, AJAX, JIRA, MS Visio.

Data Analyst

Confidential

Responsibilities:

• Worked with several R packages including knitr, dplyr, SparkR, CausalInfer, space-time.
• Perform a proper EDA, Univariateandbi-ariateanalysistounderstandtheintrinsiceffect/combinedeffects.
• Implemented end-to-end systems for Data Analytics, Mahout, Hadoop and MySQL and Tableau.
• Worked with Data governance, Dataquality, data lineage, Data architect to design various models and processes using with Big Data/Hadoop.
• Designed data models and data flow diagrams using Erwin and MSVisio.
• As an Architect implemented MDM hub to provide clean, consistent data for a SOA implementation.
• Developed, Implemented & Maintained the Conceptual, Logical& Physical Data Models using Erwin for Forward Reverse Engineered Databases.
• Established Data architecture strategy, best practices, standards, and roadmaps.
• Worked with Hadoop ecosystem covering HDFS, HBase, YARN and Map Reduce Take pad.
• Worked with BTEQ to submit SQL statements, import and export data, and generate reports in Teradata.
• Interacted with the other departments to understand and identify data needs and requirements and work with other members of the IT organization to deliver data visualization and reporting solutions to address those needs.

Environment: Erwin r9.0, Informatica, ODS, OLTP, Oracle 10g, Hive, OLAP, DB2, Metadata, MS Excel, Mainframes MS Visio, Rational Rose, Requisite Pro, Hadoop, PL/SQL, etc.

Data Analyst

Confidential

Responsibilities:

• Developed and implemented predictive models using Natural Language Processing Techniques and machine learning algorithms such as linear regression, classification, multivariate regression, Naive Bayes, Random Forests, K-means clustering, KNN, PCA and regularization for data analysis.
• Designed and developed Natural Language Processing models for sentiment analysis.
• Applied clustering algorithms i.e. Hierarchical, K-means with help of Scikit and Scipy.
• Developed visualizations and dashboards using ggplot, Tableau.
• Worked on development of data warehouse, DataLake and ETL systems using relational and non-relational tools like SQL, No SQL.
• Built and analysed datasets using R, Matlab and Python (in decreasing order of usage).
• Participated in all phases of data mining; data collection, data cleaning, developing models, validation, visualization and performed Gap analysis.
• Data Manipulation and Aggregation from different source using Nexus, Toad, Business Objects, Power BI and Smart View.
• Implemented Agile Methodology for building an internal application.
• Good knowledge of Hadoop Architecture and various components such as HDFS,JobTracker, Task Tracker, Name Node, Data Node, Secondary Name Node, and Map Reduceconcepts.
• As Architect delivered various complex OLAP databases/cubes, scorecards, dashboards and reports.
• Programmed a utility in Python that used multiple packages (scipy, numpy, pandas).
• Implemented Classification using supervised algorithms like Logistic Regression, Decision trees, KNN, Naive Bayes.
• Used Teradata15 utilities such as Fast Export, MLOAD for handling various tasks data migration/ETL from OLTP Source Systems to OLAP Target Systems
• Maintenance in the testing team for System testing/Integration/UAT.
• Involved in preparation & design of technical documents like Bus Matrix Document, PPDMModel, and LDM & PDM.
• Understanding the client business problems and analysing the data by using appropriate Statistical models to generate insights.

Environment: R, Erwin, Tableau, MDM, QlikView, ML Lib, PL/SQL, HDFS, Teradata, JSON, HADOOP (HDFS), Map Reduce, PIG, Spark, R Studio, MAHOUT, HIVE.