We provide IT Staff Augmentation Services!

Data Architect & Sme/sr. Data Lead/sr. Data Scientist Resume

New, YorK

SUMMARY:

Data Lead, Data Scientist, Principal Data Analyst, and Data Conversion Lead/Business Analyst with over 15 years of IT Experience. Diversified background in Information Technology through various levels of Technical Lead/PM, Business Analyst, Data Scientist Data Analyst and Application Development roles with exceptional organizational, analytical, and project management skills. Experienced in developing and implementing solutions for large - scale, high-risk projects that meet business and technological needs for domestic and international business stakeholders. Experienced working with offshore resources and team members from diverse cultures. Adept at leading multiple projects simultaneously and adjusting priorities to meet ongoing business needs. Recognized for ability to build and maintain positive working relationships to ensure successful project completion through solid teamwork and strong customer service focus. Highly motivated to acquire new business knowledge and technical skills, and to achieve lasting, high quality results. Experience includes lead Fraud detection Models, Anti Money Laundering Models, and Trade Surveillance Model implementations, Models Design and development, data warehouse implementations, data warehouse conversions, database design, database developer experience, production support/enhancements, conversions, requirement gathering, analysis and designing and developing solutions to improve operations efficiency, reports generation, process improvement by exercising performance tuning, designing and developing data marts. Recent high profile Fraud detection Lead assignment involved the implementation of a Risk Case Manager and Fraud detection models for large international investment bank throughout their North American, APAC, and EMEA regions. SME for Actimize AIS and Risk Case Management software and Mantas. Education Masters in Engineering (Indian Institute of Technology) IIT Kanpur, India.

TECHNICAL SKILLS:

  • Data Science, Predictive Analytics, Prescriptive Analytics and Descriptive Analytics.
  • Statistical Models: Regression, Rige, Lasso, Classification (Logistic, LDA, QDA), Cross Validation (K-fold, bootstrap), KNN, Decision Trees, PCA, Support Vector machines, Neural Networks
  • Map Reduce, Hadoop, Spark, NLP, Neo4J (Graph Database), Tensor Flow, CNN, MongoDB, Cassandra
  • Mantas, Actimize AIS, Actimize RCM
  • Oracle Database, Data Modeling, Data Mart, Data Warehouse
  • Databases: MS Access, Oracle, Oracle 7.x, Oracle 8.x, Oracle 8i, Oracle 9i, Oracle 10g,Oracle 11g
  • Development/Productivity Tools: PL/SQL, SQL * LOADER, SQL*Plus, Unix Shell scripts, ETL Scripts, Oracle 9i forms, Oracle Reports, Actimize 3.6 and RCM 4.2
  • ERP Oracle Applications: Financials 11i (SYSADMIN, GL, AR, AP, OE)
  • Function Expertise: Enrollment, Renewal, Billing, Payments, Rate Setup, Delinquency Processes (Credit/Collections).
  • SCT Banner (CIS System)
  • ECom Frameworks/Web Technologies: Apache webserver, JSP, Java Beans, Java Servlets, Java Web Server, JavaScript
  • Network/Telecom/RT/Systems Software: Socket Programming, TCP/IP
  • Programming Languages: C/C++/C#, DHTML, Java, SQL, Python
  • Software Engineering Methodologies/Tools/Technologies: OOAD, PVCS, SVN, Rational Rose, UML, ERWIN

PROFESSIONAL EXPERIENCE:

Data Architect & SME/Sr. Data Lead/Sr. Data Scientist (Principal Consultant)

Confidential, New York

  • Responsible for Data Conversion/Data Mapping from Source System to Surveillance Systems
  • Responsible for Design of Data warehouse that is input to AML/Fraud/Trade detection systems, Portals and Reporting tools.
  • Responsible for implementing Predictive Models for Fraud Detection.
  • Data cleansed, transformed, and migrated data warehouse using ORACLE PL/SQL programming, SQL, SQL Server and Batch scripts and UNIX scripts
  • Responsible for leading Anti-Money Laundering, Remote Banking Fraud Solution, Watch List filtering, OFAC, Trade Surveillance compliance related projects.
  • Responsible for Actimize system design, Infrastructure, Installation, Configuration, Interfacing with POE application, data Integration.
  • SME (Subject Matter Expert) and GOTO person for Actimize Implementation (Actimize IFM, Actimize SAM, Actimize CDD and Actimize WLF, Actimize Trade Surveillance)
  • The following technologies were involved in project development phase Actimize AIS, Actimize RCM, Actimize RCM Designer, Actimize Visual Modeler, Oracle PL/SQL, SQL, SQL Server, C#, C++,IBM MQ, JAVA, XSL. Data mining/Data Analytics - Hadoop, R, Python, SAS, WEKA and Rapid Miner. Visualization - Tableau, Actimize Dashboard

Data Architect/Data Conversion Lead

Confidential, New York

  • Responsible for Data Conversion/Data Mapping from Upstream to Actimize System.
  • Responsible for Data Conversion/Data Mapping from RSA Alerts to Actimize System
  • Responsible for Data modeling and Design of Fraud Data warehouse that is input to Fraud detection systems, Portals and Reporting tools such as Business Objects and Tableau
  • Provide solutions to design and develop ETL mappings and related activities
  • Developed scripts/procedures to extract the data from multiple sources using Oracle PL/SQL and SQL
  • Designed and Developed Oracle Tables and Views that are input for Actimize Intelligent Server (AIS-Modeler).
  • Responsible for Implementation of Actimize IFM (Integrated Fraud Management - RB) Suite to detect wire transactions and display in Actimize Case Manager.
  • Responsible for Implementation of Actimize ERCM as Central Case Manager for all alerts/incidents that generated either in Actimize or in other Fraud Systems.
  • Interview business users in order to analyze and develop business requirements.
  • Analyzed Business requirements (BRD) provided by Operations Team and Developed SRS (Software Requirements Specification) for complex project that involves multiple streams.
  • Responsible for Actimize IFM Suite -Mapping, Alert Workflows, Alert Displays, Policy Manager, Business Units, and Entitlements (Roles/Permission).
  • Responsible for Design and integration of Actimize and Portal systems.
  • Responsible for Data Mapping and Wire Frame Design (UI - Design, Axure) for Portal.
  • Responsible for Managing Actimize and Portal development by multiple external vendors and by internal developers.
  • Responsible for Installing the Actimize Code (AIS/RCM) delivered by Vendors in all environments (DEV, QA, UAT, and PROD).
  • The following technologies were involved in project development phase Actimize AIS, Actimize IFM RB, Actimize ERCM, Actimize RCM Designer, Actimize Visual Modeler, Oracle PL/SQL, SQL, SQL Server, Python, C#, C++, Web Portal (.NET), IBM MQ, JAVA, and XSL. Data mining/Data Analytics - Hadoop, R, Python, SAS, WEKA and Rapid Miner. Visualization - Tableau, Actimize Dashboard.

Sr. Trade Surveillance Business Analyst/Sr. Data Analyst

Confidential, New Jersey

  • Responsible for ocean equity migration, CBNA mortgage migration, integration of compliance data warehouse with Mantas/Actimize Trade surveillance, testing and support as both Technical and Project Lead .
  • Interview business users in order to analyze and develop business requirements.
  • Liaison between internal SMEs and external resources based in US, Singapore, UK, and India.
  • Perform business analysis and assist in designing and implementing of business solutions.
  • Lead data mapping from compliance data warehouse to Mantas DIS for all North America source systems.
  • Participate in requirement analysis with Business/Compliance users, create functional specifications (FRD) for compliance models/scenarios, equity migration, and fixed income migration projects.
  • Help business users in user acceptance testing and provide support to business for issues in Production.
  • Perform extensive data analysis on all equities data that ingested into Trades surveillance models for generating alerts.
  • Compare alerts generated in UAT to Production for Equities Migration Project. Analyze the differences, present the root causes and propose the solutions to the business users. Co-ordinate with upstream systems to fix the any data quality issues.
  • Conduct process review, prioritize changes and monitor resolution of issues/risks through analysis.
  • SME for Mantas/Actimize Trade Surveillance scenarios - Best Executions(Price Dis-improvement, Untimely Exec Market, Untimely Exec-Limit), Front Running, Trading through Halts, Cap and Peg, Spoofing, Wash Trades, Unusually Large Order, Marking The Close, Marking the Open, etc.
  • The following technologies were involved in project development phase Mantas, Actimize AIS, Actimize RCM, Data Warehouse, Data Mart, Sybase, Sql, PL/SQL, Oracle 11g, and XSL.

Data Architect/Data Integration Analyst

Confidential, New York, NY/Wilton, CT

  • Analyzed Business requirements provided by Business analysts from Credit Portfolio Management and Enterprise Risk Management teams.
  • Created and maintained data mapping and specification document for converting multiple sources data into common staging/data mart.
  • Lead data mappings for Exposures/Holdings and Reference Data(Security Master, Agency Ratings - (S&P, Fitch, Moody), Portfolios, Asset Classifications, Legal Entities, Industries, Countries, Regions, Currencies, FX Rates etc.) for both invested assets and insurance assets.
  • Co-ordinated with data governance, credit portfolio management, and ERM and data warehouse teams for data mapping and data validation.
  • Designed data model and Oracle Tables for common staging.
  • Developed scripts/procedures to extract the data from enterprise data warehouse (fact and dimension tables) to common staging using ETL Scripts(Oracle PL/SQL and SQL)
  • Done extensive data analysis, data validation and profiling using SQL queries and MS Excel.

Actimize Lead/Actimize Architect

Confidential, Jersey City, NJ

  • Responsible for implementation of custom Actimize Trade Surveillance models for equities, options, fixed income, and future products as both Technical Lead and Actimize Architect.
  • Led a team of Actimize Developers and Oracle Developers to implement custom Actimize trade surveillance models for all regions.
  • Analyzed Business/Functional requirements provided by Business Analysts, and provided technical solutions and design documents to Actimize/Oracle Developers.
  • Designed and assisted in development and implementation of Trading Surveillance Models for equities, options, futures and fixed income products (e.g. Rule 611/Trades, Outside NBBO, Options Capping and Pegging, Duplicative Orders, TRACE, Spoofing, Wash and Trade, Front running, Advertise Volumes, Trading through Halt, Mark the close (MTC), BEX etc.) using Actimize AIS 3.6, 4.x, RCM/ACM designer tools, Oracle PL/SQL, UNIX, ETL scripts and batch scripts.
  • Developed scripts/procedures to extract the data from multiple sources(fact and dimension tables ) using Oracle PL/SQL, SQL, UNIX or Batch Scripts
  • Designed and Developed Oracle Tables and Views that are input for Actimize Intelligent Server (AIS-Modeler).
  • Created Data Source, Dimensions, Global Functions, Global Constants, XML Templates, Events (For Mapping and Distribution of Alerts), Executions in AIS (Modeler).
  • Created Alert Types, Alert Views, Queries for Drill Outs, and Dart Views in RCM Designer.
  • Created RCM Exclusion/Inclusion Lists, RCM Thresholds, RCM References, AIS Lists and Rules in Actimize Policy Manager.
  • Designed and Developed XSLs for alerts display in web-based Risk Case Manager.
  • Setup Thresholds, References and Lists in RCM.
  • Rolled out models into QA, UAT and Production environments.
  • Enhanced the old models to improve the performance and also supported UAT and Productions Models.

Senior Data Analyst/Senior Oracle Developer

Confidential, NY

  • Handled multiple projects (Projects related to Benefits - Pension/Health Care Funds & Investment Banks) as Data conversion specialist for V3 Benefits Administration product & Equitrak Fund Administration Product.
  • Worked very closely with the Technical Architect, Account Team, clients and 3rd party vendors on mapping the client legacy systems into Vitech’s system (V3) & Equitrak’s system based on business and technical requirements.
  • Loaded the legacy data into Oracle Staging table using SQL* Loader.
  • Data cleansed, transformed, and migrated to V3 Product data model using ORACLE 10g PL/SQL programming, SQL, SQL Server and Batch scripts and UNIX scripts.
  • Improved the performance of old processes significantly by using bulk binds (BULK COLLECT, Insert FORALL, etc.) in PL/SQL programs.
  • Generated various reports for clients using SQL & PL/SQL programming

Senior Oracle Consultant

Confidential, Skillman, NJ

  • Designed and Developed “GL Integration application” for integrating Pfizer General Ledger (GL) with Confidential & Confidential GL.
  • Involved in entire Software development life cycle (SDLC) of GL integration project (system design, development, testing and production support).
  • Written Oracle Stored Procedures, Triggers, Functions and SQL* Loader scripts and UNIX shell scripts.
  • Automated the entire GL processes using cron jobs and UNIX shell programming.
  • Production support/maintenance of the GL integration application.

Project Lead/Onsite Coordinator

Confidential, Hoboken, NJ

  • Written Oracle Stored Procedures, Triggers, Functions and SQL* Loader scripts.
  • Generated monthly report and Adhoc reports using SQL and PL/SQL programming.
  • Improved the performance of the process by SQL tuning.
  • Onsite and Offshore coordination for MINA ( Confidential Inventory of Name & Address) application which is primarily J2EE based, involving iPlanet Web Server for the web tier, Weblogic 8.1 Application server hosting the EJB components for the business tier, and Oracle 9i for the data tier.
  • Onsite and Offshore coordination for Confidential Financial Application (GL, AP, AR).
  • Data analysis and provide reports to users and subscribing systems.
  • Testing and deployment of offshore deliverables in QA, UAT and Production environments.
  • Development of Technical design document, test cases, Coding and programming
  • Use Open Interface feature of the GL module to convert existing journal data.
  • Written SQL*Loader scripts to migrate the data from the text files and populate the intermediate tables like GL INTERFACE and GL BUDGET INTERFACE.
  • Executed the Journal Import program from GL menu.
  • Utilized Oracle Financials 11i (GL,AP,AR), Forms & Reports 6i, SQL*Loader, PL/SQL, SQL

Systems Consultant

Confidential, Philadelphia, PA

  • Designed and developed application “Guy Carpenter Re-insurance Accounting & Information Leveraging System (GRAIL)”. This application is meant to address the predominantly back office systems and processes, which are involved the reinsurance business.
  • Written shell script to automate batch processes.
  • Involve in design of merging and converting Guy Carpenter’s local applications into central GRAIL application.
  • Utilized UNIX, Oracle 10g, Oracle 9i, PL/SQL, Oracle Forms.

Systems Consultant

Confidential, Atlanta, GA

  • Designed and developed data marts for Finance and Marketing Teams.
  • Designed and developed billing, payment arrangement, renewal, enrollment, and delinquency life cycle reports.
  • Designed and developed customer count, churn analysis, revenue assurance, payment history and consumption history reports
  • Rewritten ETL script for Risk Data Mart that increased performance of risk processes by 5 times.
  • Provided SCT Banner Production Support, which involves processing daily inbound and outbound transactions.
  • Utilized strong analysis, PL/SQL programming, UNIX shells script programming, reports generation and SCT Banner (CIS System) product knowledge.
  • Handled exceptions in transaction processing, report generation, fulfillment and retention processing.
  • Resolved customer concerns regarding their gas accounts, which include - consumption, billing, payments, delinquency, incorrect pricing, cancellations and general account information.
  • Delivered PSC (Public Service Commission) data requests quickly and efficiently
  • Designed, wrote, and debugged stored procedures, shell scripts for data conversion process.
  • Wrote shell scripts to automate batch processes

Hire Now