SUMMARY

• 8+ years of total IT experience in the Data Analysis, Design, Modeling, Testing of Data Warehouse applications and acquired excellent analytical, co - ordination and interpersonal skills for leadership.
• Extensive experience in Master Data Management and Business Intelligence.
• Experience in procedures and standards set by the project for Automated Clearing House framework.
• Extensively used Erwin to design Logical and Physical Data Models, to forward data models and publishing data model to acrobat PDF files.
• Proficient in data manipulation and data preparation wif methods including describe data contents, compute descriptive statistics of data, regex, split and combine, Remap, merge, subset, reindex, melt and reshape.
• Strong experience wif Database performance tuning and optimization, query optimization, index tuning, caching and buffer tuning.
• Extensive experience in relational Data modeling, Dimensional data modeling, logical/Physical Design, ER Diagrams and OLTP and OLAP System Study and Analysis.
• Proficient in Data Manipulation & Data Visualization, Web Scraping and Python.
• Strong experience in DataAnalysis- Datacollection, datatransformation anddataloading thedatausing different ETL systems like SSISand Informatica.
• Experience working wif SDLC methodologies such as Agile Scrum
• Experienced in working wif technologies like SWIFT, IBAN and Automated Clearing House (ACH).
• Knowledge of Equity, Derivatives, Option Pricing Models, Futures, Forwards, Exotics, Swaps and other derivatives.
• Solid Knowledge of implementing the INFOR Enterprise Asset Management (EAM) system for the fleet management.
• Strong experience in Database such as Microsoft Access, Oracle, SQL Server, DB2, Teradata, on Windows platforms and latest.
• Strong Knowledge of tools such as DBT and DataStage
• Experienced in risk management, equity & collateral management, trade confirmation, stock lending.
• Experienced in writing Toad and PL/SQL Stored Procedures, Triggers and Functions.
• Proficient in Generating weekly and daily reports using and Tableau and exporting to Excel and Access reports.
• Experience wifdatamapping, querying the source and target tables in the database using SQL for testing purposes.
• Proficient in various queries using SAS for creating reports according to the Users requirement.
• Experience wif Capturing data and building reports for clients in SSRS and creating stored procedures using T-SQL daily.
• Experience wif Writing T-SQL code for stored procedures, managing tasks and meeting deadlines in response to ad-hoc requests.
• Extensive knowledge in migrating data to/from staging table in SQL from multiple data sources including Oracle, Access, Excel, CSV flat files and other SQL servers.
• Experience in ETL processing using SSIS for design, testing and deployment of packages.
• Good Working knowledge of SQL and VBA.
• Strong Knowledge Advanced excel skills essential including pivot tables, macros and querying external sources.
• Proficient in writing, editing and debugging code using SAS.
• Excellent hands-on experience wif data modeling tool like Erwin and strong knowledge of Relational and Dimensional database modeling concepts wif star schema and snowflake schema’s design.
• Experience using pivot tables and VLOOKUP function for analyzing and generating report
• Worked closely wifDatamodelers and Data Architects extensively onDataModelling andData Migration.
• Proficient in Creating, modifying and executing SSIS packages to load clients’ raw data from Excel to SQL Server.
• Good Working Knowledge ETL/SSIS Imports and Exports that meet provided specifications. SSIS Control Flow, Data Task, SQL Tasks, Data Conversions.
• Strong understanding of the principals of Data warehousing, Fact Tables, Dimension Tables, Star and Snowflake schema modeling.
• Proficient in Perform analysis, design, testing, and debugging of complex reports, ETL scripts and dashboards.
• Strong Knowledge in provided functional details for QA process for programs and reports also provided user test cases.

PROFESSIONAL EXPERIENCE

Confidential, Jersey City, NJ

Sr. Data Analyst

Responsibilities:

• Leveraged an understanding of multiple data structures and sources wifin data architecture, SAS Server, SAP, etc. to perform complex data manipulation employing data mining, analytical tools and mathematical techniques.
• Used the Agile-Scrum approach, me was responsible for collecting and analyzing all the User stories
• Extensively usedSASprocedures and functions for data manipulation and creating summaries data values
• Created various types of data visualizations using R, C#, python and Tableau/Spotfire also connected Pipeline Pilot wif Spotfire to create more interactive business driven layouts.
• Extracted data from multiple data source, write python (scrapy package, selenium) scripts to scrape data and images websites (web scraping).
• Involved in Dataprofiling and performed DataAnalysis based on the requirements, which halped in catching many Sourcing Issues upfront.
• Provided production support by correcting several data discrepancy utilizing PL/SQL anonymous blocks.
• Demonstrated expertise in MS SQL Server and Microsoft Business Intelligence (MS-BI) tools like SSIS (MS SQL Server Integration Services), SSRS (MS SQL Server Reporting Services), SSAS (MS SQL Server Analysis Services) and T-SQL scripts.
• Involved in Designing system add-ons to satisfy business requirements. Enhanced the site by designing interfaces to AutoTrack DBT
• Applied AGILE/SCRUM (wif Sprints) for Data warehouse development and Integrated operational data store (ODS) development and maintenance.
• Worked Source to Target Mapping for Data Warehouse and ODS for Batch Management and Dealer Management System.
• Effectively worked on analysis, influencing both technical and non-technical stakeholders and management.
• Provided regular progress updates on your analysis, keeping people informed.
• Created the Enterprise Information Group encompassing Business Intelligence Center of Excellence, Data Governance Working Group, Enterprise Data Warehousing and Master Data Management.
• Prepared test plan and test data for assigned work, perform unit/program test and apply fixes as needed for Automated Clearing House framework.
• Extensively used BI for analyzing securities including equity, foreign exchange, bonds, building analysis flow for portfolio rebalancing and monitoring asset class performance.
• Conducted interviews wif traders, Front office support and front office technology to understand the trading of equity derivative products and capturing the impacts on the future state.
• Worked on metadata standards, data governance and stewardship, master data management, ETL, ODS, data warehouse, data marts, reporting, dashboard, analytics, segmentation, and predictive modelling
• Worked on Business Intelligence standardization to create database layers wif user friendly views in Teradata that can be used for development of various Tableau reports/ dashboards.
• Designed conceptual, logical and physical data model wif Erwin.
• Worked on funds transfer application including the messaging system like SWIFT and FIX protocol. CHIPS and FedWire.
• Participated in Infor EAM optimization and customization through review and deep analysis of users' needs and building solutions.
• Worked of migrating of MS Access table data to Oracle & MS SQL Server wif the front end still being in MS Access.
• Involved in customization of IBAN for new countries by applying OSS notes.
• Worked in payment medium workbench to Reformat DME File for IBAN & transition to 1SABIC issues.
• Analyzed the existing business process flows for Equities and Derivatives to gain understanding of the existing system and documented the business process flows.
• Hands on experience on CI/CD pipeline using AzureDevOps, and Jenkins.
• Involved in Advance Excel, VBA, spreadsheet modeling, pivot tables, Lookups, Data Modelling, ETL and manipulating large Data sets.
• Designed Conceptual, Logical and Physical data flow diagrams for file transfers from ERP INFOR.
• Involved in doing Analysis and Design using Joint Application Requirement (JAR), JAD, Work Break Down, Entity Relationship, Data Flow, Structure Chart and Flow Chart documentation.
• Worked in highly pressured technical environment to extract, analyzed, transformation, loading and implement queries using SQL plus, Teradata SQL assistant and Oracle. Research Documentation and analysis.
• Createdfinancial modelsfor securities pricing, including term structure bond pricing, equity pricing through free cash flow, option pricing, Monte Carlo simulation, option on bonds, option on FX.

Confidential, Fairfield, New Jersey

Sr. Data Analyst

Responsibilities:

• Performed structured application code reviews and walkthroughs for Automated Clearing House framework.
• Performed data analysis for Trading Compliance/Markets Surveillance supporting variety of instruments such as Fixed Income, Equity Cash & Derivatives and Energy/Commodities.
• Prepared business requirement documents for VAR- based independent value calculations for Equity, Credit, Interest Rates and FX swaps.
• Involved in data manipulations and stored the updated data into corresponding data marts inOraclewarehouse.
• Delivered web scraping, sentiment analysis, and product recommendation tool for hyperlocal marketing in FL market.
• Assisted and support the rest of the data and BI team to continually seek to identify and improve MI suites, by assessing historic reporting to create automation of reports and introduce new data sources to improve performance.
• Analyzed Human Capital Management reports using Lawson ERP system by INFOR
• Identified key data risks, proposing mitigation and controls wifin the department.
• Worked in doing Risk Analysis and Risk Management, Impact Analysis and Change Management, Resource Planning, Gantt charts, SWOT and Cost Analysis.
• Created PL/SQL functions to pass and return appropriate parameter values to stored procedures and complex SQL queries.
• Worked on Packaging of daily activities for DBT resources.
• Performed data analysis and data profiling usingT-SQLand data profiling tasks.
• Applied dis knowledge to consolidate structure and summarized relevant data into a single platform
• Maintained the platform to ensure it TEMPhas accurate and timely data
• Produced ad-hoc analysis to test theories so we can better understand our users and their behavior
• Processed, cleansed and verified the integrity of documents using data handling techniques in order to manage risk and improve service.
• Used data analysis and handling techniques to analyze, validate, reconcile and report on legal review data captured by our lawyers.
• Worked on convergence on Infor EAM configuration for implementation
• Scripted basic document data analysis and handling solutions in support of legal work
• Worked in Fixed Income, Equities, Equity Trading Cycle, Portfolio Analysis, Bonds and Bond Trading Cycle, Bond Pricing, Derivatives, Portfolio Management and Wealth Management.
• Used MDM tool to support Master Data Management by removing duplicates, standardizing data (Mass Maintaining), and incorporating rules to eliminate incorrect data and filter data as per requirements.
• Worked on functional requirements for formulating new Dodd-Frank surveillance tools to cover derivatives products.
• Involved in Designing and executing test cases to be used for applications development and implementation of projects.
• Created database physical and logical design, create data modeling, create/modify database structures/object definition re recommending design and structural modifications and enhancements
• Analyzed, designed, code test and maintain Business Intelligence reports and Dashboards using Oracle Business Intelligence Enterprise Edition (OBIEE), Google analytics and Tableau that enables fact-based decision making, analysis, and insight generation
• Designed, maintained and enhanced legal due diligence questionnaires in order to provide a market leading data driven legal review service.
• Consulted wif lawyers and other stakeholders in order to provide technical advice and support, elicit data requirements and create data driven legal review services.
• Continuously analyzed service improvement by applying technology innovatively to a professional services business wif law as its core.
• Created scripts to monitor the environment and notify DevOps team of detached volumes and elastic IPs (EIP).
• Designed for fully automated server build management and monitoring By Using DevOps.
• Used SQL and Access for manipulation of data from data warehouses.
• Created and modified Business Intelligence analytical reports using Tableau.
• Worked wif the data modeling team to create the data models using Erwin
• Worked on Payments processing and SWIFT messaging standards.

Confidential, Jersey City, NJ

Data Analyst

Responsibilities:

• Participated in defining project standards and procedures for Automated Clearing House framework.
• Worked on quantitative models using Excel and SQL to analyze Compliance and Regulatory requirements for trade surveillance of Equity products, equity derivatives and swaps, OTC and listed derivatives, fixed income products.
• Analyzed Credit and Equity OTC Derivatives Trading Life Cycle to improve legacy and proprietary trading process & systems.
• Worked inproducing tables, reports, graphsand listings using various procedures and handlinglarge databases to perform complexdata manipulations.
• Responsible for creating and changing thedata visualizationsin Power BI reports and Dashboards on client requests.
• Worked on DevOps Framework for Confidential Team using XAML.
• Supported resource management wifin the organization through production of telephony and activity data to ensure that SLAs and KPIs are achieved across all teams.
• Identified opportunities to automate existing manual reporting across all business areas.
• Involved Data Science content involvingData ManipulationandVisualization,Web Scraping,Machine Learning,Python programming,SQL,GITandETLforData Extraction.
• Led multiple teams in delivering risk management web applications that enforced data security, streamlined processes, and achieved regulatory compliance.
• Created PL/SQL functions to pass and return appropriate parameter values to stored procedures and complex SQL queries.
• Created and modified variousStored Proceduresused in the application usingT-SQL.
• UtilizedSSISto produce a Data Mapping and Data Mart for reporting worked wif Multi-threading Concepts wif Synchronous and Asynchronous transactions.
• Created logging, custom logging and error handling packages.
• Supported the delivery of intermediary monitoring KPI’s ensuring accurate reports are provided to the field teams.
• Used Python Scriptingin DevOps, to model and manage the entire application fromloadbalancersto adatabase.
• Involved in Business partnering for Business Intelligence and IT including change requests/briefs.
• Supported the delivery of the Commercial Finance board packs to agreed timelines.
• Worked on Project included automating interfacing wif other banks through SWIFT for updating the financial transactions.
• Created Screens using Oracle and backend Oracle database package-based process to load external data into NCS system.
• Actively monitored data quality on a specific data stream, profiling and analyzing the data to identify Data Quality issues on target datasets.
• Prepared artifacts documenting the issue so issue owner TEMPhas information necessary to solve issue.
• Worked closely wif the customer to determine the scope of data stream to be actively monitored - may be limited to certain fields, or certain submitters, etc.
• Defined and executed processes to monitor data governance policies and procedures to ensure data integrity and privacy, establish consistent data definitions, and monitor overall data quality.
• Created and maintained data model/architecture standards, including master data management (MDM)
• Designed business intelligence dashboard using Tableau Desktop and publishing the same on Tableau server, allowing executive management to view current and past performance sales trends, forecast sales, and to track existing customer sales.
• Actively worked as the Database Administrator and handle the database architecture using Erwin
• Developed reports in Access and Excel.

Confidential, Englewood Cliffs, NJ

Data Analyst

Responsibilities:

• Identified and acted on application incidents/resolution in support of service level agreements for Automated Clearing House framework.
• Worked on master data management using SAP best practice for designing a global master data for Material, Customer and Vendor master.
• Performed ETL solutions wif Informatica Power center to build the data warehouse to support producing Business Intelligence reports and Web applications for customers in the merchandise retail company.
• Responsible for handling inter-bank communication related to exports through SWIFT messages.
• Worked wif SWIFT to reduce the cost and to apply reusability and standardization.
• Created modules in Monarch to convert text files into Access tables, MS SQL Server tables or Excel worksheets.
• Worked on the Interfaces in SQL, for data calculations and data manipulations.
• Created DataQuality ScriptsusingSQLto validate successful data load and quality of the data. Created various types of data visualizations using Python andTableau.
• Performed financial risk management advisory and audit relating to settled foreclosures, modifications, retention and REO.
• Created PL/SQL anonymous blocks using Cursors, IF/Fetch Statements, Variables and For Loops to manipulate data to support application functionality and business rules.
• Collaborated wif IT on infrastructure, tools, and policies.
• Treaded new ground in terms of analytical tools, methods, and techniques, including identifying new use cases, piloting concepts, and implementing methods for using data to achieve office goals.
• Worked wif challenging stakeholders to effectively identify and clarify the overall scope and requirements of the analytical work.
• Manipulated multiple data-sets to analyze data.
• Performed inErwin data Modelingiterations (Schematic/ Logical/ Physical).
• Queried the databases, wrote test validation scripts and performed the System testing using SQL
• Reviewed loan level system data, as well as file documentation, to ensure compliance wif governmental and investor guidelines.
• Compiled data for each loan reviewed and corrective action needed based on criteria established by clients, government programs or management
• Ensured proper data capture/export for reporting and tracking purposes and identify anomalies and trends
• Worked on SEC additional requirements for Asset classes likeEquity, Fixed Income, Credit, and Rate derivativesto define the requirements for swaps, swaptions, OTC derivatives, reporting party logic, Xpath and FpML.

Confidential, East Brunswick, NJ

Data Analyst

Responsibilities:

• Worked as a Data Analyst in Transforming and Modeling the data in online banking, also worked wif SWIFT and Quick Test Pro.
• Collaborated wif business analysts to clarify application requirements for Automated Clearing House framework.
• Worked on aDodd Frank Regulatory requirement that involves Trade reconstruction and analyzing all swap datarelating to FX, FX Options, Commodities, and Equity, Fixed Income, Credit and Interest rate derivatives.
• Assisted in developed of client centric Master Data Management (MDM) solution.
• Worked wif Data Architects on enterprise level data flows related, participate in physical and logical data modeling using Erwin.
• Performed extensive data cleansing, data manipulations and date transforms and data auditing.
• Worked publishing interactive data visualizations dashboards, reports /workbooks on Tableau andSASVisual Analytics.
• Preformed import into new version of the database using SQL Loader, External tables, UTL File utility of Oracle.
• Reviewed in Troubleshoot and enhanced existing PL/SQL Stored Procedures for client reporting applications in a production environment.
• Migrated into Phases wise, first transferred database into new version and secondly transferred forms and reports.
• Worked on Database application, created tables, relationships, queries, forms and reports.
• Heavy interacted wif users, make them understand the use standard and management reports
• Created analytic reports and dashboards that demonstrate the Office's performance and outcomes for managerial staff using the internal business intelligence platform.
• Responded to internal and external requests for aggregated data and statistics by querying the Office's internal datasets in SQL Server.
• Analyzed data to inform policy projects such as the development of new prosecutorial strategies, diversion programs, or other Office practices
• Worked wif all front office systems in ensuring the smooth implementation of trade processing using SWIFT messaging and other protocols for settlements.
• Automated several internal processes using Oracle PLSQL packages, functions, database Triggers and UNIX scripts.
• Conducted reviews to show historical information, current trends and forecasting based on the information submitted by project or program managers
• Consolidated Change Requests to Master Repository, conducted analysis to ensure consistency, reasonableness and prepared various artifacts for the annual submission of IT financial requirements
• Compiled and halp wif presentation materials for the Non-VA Care operation budget.
• Received and Interpreted Calls for Budget, prepares annual budget formulation documents in final form and ensures that all reconciliations are made as to workload data, accuracy, distribution of programs.