Business Intelligence Data Management
Resume:
Dewan Choudhury ************@*****.***
Objective: Seeking a position as a Business Intelligence Analyst/Data migration Analyst, Data Base Administration, Metadata Data Quality Analyst in a data management practice or data quality initiative for a long-term role preferably a Remote or a Hybrid site present location. Also available for a Remote Position Nationally or Internationally due to Covid-19 epidemic stretch. Can accept a position with relocation expense as well nationally or internationally.
Summary & Qualifications:
30+ Years of amalgamated Government and Banking sector working experience encompassing areas in Sales & Financial Data Management Systems, Securities & Exchange Regulatory, Marketing, Health Care, Actuary, Engineering, Treasury, Foreign Exchange, Funds Transfer, Trade Processing, Valuation & Trade Settlements, Account Opening to Electronic Banking Platform Implementation, Structured Deal Reviewing, Securities Custody & Clearing, EAM/ERM applications, Reference Data/Market Data contents, Dodd-Frank & Basel II Implementation, and Real Estate Systems.
Substantial Hands-On skill set in Banking, Health Care Financial Products and Systems Data Analysis using MICROSOFT EXCEL, ACCESS, POWERPOINT, SHAREPOINT, VISIO, ORACLE SQL Developer, Microsoft SQL SERVER, TERADATA, HUE-IMPALA/HIVE,TABLEAU, CRYSTAL REPORTS that entails preparation of statistical, quantitative and graphical analytics and presentations; supports PMO, SDLC, Tier management, Application Development including End User Support on computer applications and Business Processes, Technical and R&D Tasks.
Technical Skill Profile:
Software Expert Level: Microsoft Excel, Microsoft Access, Microsoft SQL Server, Microsoft Power BI, OBIEE (Oracle Business Intelligence Enterprise Edition), Teradata, Hue-Hive/Impala, Tableau, JIRA, Microsoft Project, Visio.
Intermediate/Expert Level: UNIX, Oracle (SQL*PLUS), Sybase (DB Artisan), SQL Server (SSIS/SSRS), MYSQL, HP Service Manager, Perl, RDBMS (SQL/PL SQL/T-SQL), Business Objects, ORACLE 9i, COGNOS, Crystal Reports, ETL (TOAD) & SAS.
Professional Experience:
FTC, Washington, DC
Global Solution Group Feb 2022 – Current
(Contractor/Consulting) BI Analytics & Senior Data Analyst – BA/DA (Remote)
Working with FTC Technology & Human Resources Team calling HCMO (Human Capital Management Office) and querying OBIEE Data marts for ad hoc requests and also to Build Bi-Weekly FTE (Full Time Equivalent) Reports, identifying and making updates as needed by Stake Holders with other HR (Human Resources) related information dissemination from Dept of Interior (DOI) and other Data sources.
Build, update and maintain some HR Attrition, On-Boarding/Off-Boarding Headcount and Several Workforce Related Analytics & Visualization Dashboards for Managements.
Participating meetings on Cognos Staffing Reporting, Service Now Tickets and FPPS (Federal Payroll Processing Systems) updates, data delivery and coordination.
BANK OF AMERICA, Charlotte, NC
Ettain Group July 2021 – Dec 2021
(Contractor/Consulting) Sr System Analyst – BA/DA (Remote)
Working on DCIM (Data Corruption, Identification & Monitoring) AIT’s (Application Identification Tool) with Technology, Development & Team that built a Tableau Dashboard for various application data on Key failure points of early detection process & remedial measure.
Collaborating to add new AIT’s with team members in the phases of discovery of Data aggregations from TechADS (Oracle Exadata) subset of each AIT data set flowing from big data Teradata/Hadoop data mart schema with ETL & BI rules applied to it.
Communicating with Application owners as stakeholders to understand how their data is leverageable in DCIM to help them KPM where the data is compared for abnormal anomaly detection comparing with ongoing daily and frequency of 15 minutes to an hour time interval difference on issues of corruption for escalations. Ran complex queries in Teradata & Oracle and assisted in coding modifications of pySpark & SQL with Developer teams.
ARVEST BANK, Tulsa, OK
Heithmeyer Consulting May 2021 – July 2021
(Contractor/Consulting) Sr Data & Reporting Analyst (Remote)
Created on queries and stored procedures on SQL Server, SSIS Package updates & Deployment of reports via SSRS report builds.
Supported business teams for report creation and data manipulation, data mapping, scheduling jobs and report runs for month-end, weekly & daily auto runs along with ad-hoc data set.
Communicate directly with the end users and stakeholders to understand their reporting needs on Escrow, Mortgage related payments and related work stream tasks.
NRUCFC, Sterling, VA
Holistic-Parners Inc. January 2021 – April 2021
(Contractor/Consulting) Sr Data Analyst (Remote)
Actively participating Coop Financing Process migrating to Cloud from Legacy systems.
Analyzing Source to Target mapping gaps of various past evolving systems over decades of legacy systems to a modernized Enterprise Data Warehousing projects tasks tracking by Jira.
Attending scrum meetings on sprints to sort out and reconcile data issues that are stake holders desiring to capture systematically and efficiently into placeholders of new Datamart aligned with advanced EDW technology concepts.
DEPARTMENT OF DEFENSE, Army National Guard (ARNG), Arlington, VA
Superlative Technologies dba SuprTEK - July 2018 – October 2020
(Contractor/Consulting) Tririga Application Developer & Systems Reporting Analyst (Remote & Onsite)
Created customization solution, Configuration, testing and deployment of the IBM TRIRIGA ECPs (Engineering Change Protocols) as required by IET (Installation, Environment & Technology) continuous demands and participation on upgrading of releases.
Users Access Implementation & modifications from Nationwide Facilities & Installations of ARNG.
Worked in multiple projects simultaneously and provided status updates to management on a regular basis and commit updates on projects, Project schedules of Sites, Lands, Structure, Linear Structures on SRM, Financial & Depreciations.
Worked collaboratively with other Vendors including IBM with TRIRIGA updates to accomplish project work in an efficient and quality manner
Developed Power BI Interactive reports utilizing SQL server, Power BI, BI Stack, Tableau & SSRS.
Utilized Power BI (Power View) to create various Dashboards that Depicts KPIs such as Government Funding allocations, Real Property Projects quarterly Funding comparisons with slicer and dicers enabling end-user to make filters and on target source data.
Implemented Power BI gateway off of disparate heterogeneous data sources matching business analysis criteria and Modelling for Power Pivot and Power View. Also worked on Tririga compatible report tools such as Crystal and BIRT on canned, custom, and ad-hoc reports.
Data migration tools, Extract Transform Load (ETL) scripts, etc and
TRIRIGA technologies Data Connect, Data Integrator, IWMS system dealing and configuring with Capital Project management, Real Estate Management, Space and Facilities Management, Sustainability and Compliance.
Executed SQL queries and joins using TOAD to validate the data, worked in Relational database administration with some DBA skills,
Basic knowledge in TRIRIGA Platform, application with Modules, Business Objects (BO), BO Transition and Workflows.
Some exposure in application development including IDE or GUI based programming tools.
Experience in and ability to work with multiple internal and external organizations to resolve technical and other customer related problems, multitask, meet deadlines and set priorities.
Experience in Evaluating customer requirements and technical designs to perform development and testing activities.
WELLS FARGO BANK, Charlotte, NC
INT Technologies - March 2018 – June 2018
(Contractor/Consulting) Business Systems/ Database Administration Consultant (Remote)
Partnering with and mentor Wells Fargo (WF)Middleware compliance requirements lead and requirements team.
Planning approach and drive data requirements and definitions for WF Middleware (Apachee HTTPD, JBoss, Weblogic, Wildfly, Tomcat, etc.) Enterprise SDLC adoption with iterative release updates.
Created the Data migration plan with DBA functionality in configuring databases with the release managements, versions, patch management, upgrades and other troubleshooting and defect elimination.
Organizing and overseeing requirements work activities across requirements team, Documents & Approvals (D&A).
Researching and understanding key data requirements, metadata, report delivery and ETL processes for source file receipt.
Extracting technical concepts/ideas and convert into business requirements documents and supporting documentation to be consumable by highly technical development teams.
Partnering with WF resource manager and WF requirements lead to creating sustainable processes to manage requirements ongoing.
DEPARTMENT OF TREASURY – IRS, Lanham, MD
Edgesource - June 2016 – Feb 2018
(Contractor/Consulting) Business Intelligence / Data Migration & Reporting Analyst
Provided Advanced T-SQL queries, stored procedures, and scalar/table valued functions as soft solutions in the IRS MetaData Dictionary (MDD) Migration Project from IBM InfoSphere Version 9.1.2 to version 11.5. MDD data warehousing expansion requiring support on additional Legacy Systems Metadata from its Current System [CADE2] data merging with other systems [e.g. IPM/CDW, W&R/FATCA, CADE2] data. Produced mandatory XML Extract Build and Import Build in order to load into IBM InfoSphere repository loading and updating seamlessly conducting web services testing using standards like XML, SOAP or RESTful services to fully qualified metadata model metadata or as a new set of metadata merging with existing data.
Performed SQL query performance tuning by creating/modifying indexes, setting transaction isolation levels, and changing query structures (use CASE to reduce table scans/seeks, use CTE (Common Table Expressions) and inline calculation to replace subquery involved functions, used temp tables & views to reduce repeat retrieving, etc.) in order to assist in Data mapping, validation and SSPD (SQL Server Preprocessing Database) data Standardizations on IRS MDD projects various aspects of compliance.
Performed SQL Query performance tuning by in iMetasR3 (SQL Server-ETL, SSIS, SSRS and SQL) meetings with Technical Team and MDD Team collaboration on updating Project plans and Ad-Hoc requests involving Query, Stored Procedure, Function updates involving process augments, optimization and efficiency as deemed necessary during current migration and pending future migration tasks of LOB Servers & Devices.
Pulled data across database servers (Oracle, DB2, Server, MS Access etc.) and inline queries (OPENDATASOURCE, OPENROWSE, OPENQUERY etc.). Built and Published the Packages to Cognos 8 and Cognos 10 Server according to user requirements.
Created and produced Statistical Validity Reports, KPI/KPM & Management style report analysis on updates, various Dashboards, Performance Trend Analysis on IRS Project’s (IPM, FATCA, CADE2& several others) internally developed systems.
Worked on framework manager to import metadata from multiple data sources and to create subject matter models, create and publish packages to Cognos 10 server.
WELLS FARGO BANK, Charlotte, NC
Insight Global - September 2015 – May 2016
(Contractor/Consulting) BI Reporting & Data Migration Analyst
Provided active support to management & compliance teams with integrated and up to date compliance status, statistics, and trend reporting as a means of providing compliance transparency and helping efficient use of compliance resource systems in a distributed server environment.
Produced CIOs/CTOs with timely and transparent reporting to facilitate visibility to team leaders for essential policy-based and risk-based compliance to system vulnerabilities, specifically Enterprise Patching process; thus enabling prioritization of work to support stronger risk management, enable early warning and provide sustainability to corrective actions.
Automated Microsoft Excel & Microsoft Access Based tools utilizing VBA, SQL (with ETL, SSIS, SSRS Logic) to curve several reports on OS, Middleware & Applications capturing Monthly, Weekly & Ad-Hoc based progression on Patch and Data Remediation & Sustainment Cycle in distributed client servers of various Line of Businesses.
Built more than 30+ production formatted reports leveraging T-SQL using MERGE JOIN, EXCEPT, CROSS APPLY, OUTPUT statement; with INFORMATIONSCHEMA table.
Produced and participated in submitting different LOB line CIO/CTO’s with Operational and Analytical Dashboard Reports.
DEPARTMENT OF PUBLIC WORKS, City of Baltimore – Mayor’s Office of Technology (MOIT)
Magothy Technology/EMA - December 2014 – August 2015
(Contractor/Consulting) Business Analyst - DQA (Data Quality Assurance) & Reporting Analyst
Worked with Senior Technology Officers & Consultants, Vendors & Engineers involving an Implementation project called ADVANCED METERING INFRASTRUCTURE (AMI) TRANSACTION CENTER in replacing 500K Residential & Commercial Water Meters in the City of Baltimore and surrounding Counties under the City of Baltimore.
Monitored Meter Reading Information and validating Data Quality of MOIT systems that has repository servers (SQL servers) data warehousing information based on the Water Meter Replacement information interfacing the direct capturing of ERT (Electronic Reading Transmission) signals to servers with meter reading information and incremental replacements from current Meters to new meters that are deemed outdated.
Leveraged SQL & SSRS Reporting skills to monitor Work Orders assigned by City for roll out Water Meters by ITRON. Working with ITRON’s FDM Application that shows the detail capture of each water meter and specs including previous history requiring exporting information to Legacy systems of MOIT.
DEPARTMENT OF LABOR, Washington DC
Warbird Consulting Partners - September 2014 to December 2014
(Contractor/Consulting) Application Support& Data Migration Analyst
Developed a Shared Tracking MS Access Database by limited users to Monitor Government Fund disbursement process warehousing various agencies’ requests on specific programs to make intakes based on appropriations and in a designated format. Tracking Database devised to interface with Oracle GL Application to GL Accounts tied to Accounting Line information in order to ensure that information captured, reviewed, processed and approved is appropriate and keeping accurate time pace. Created Application also facilitates proper monitoring of underlying Miscellaneous Obligation, Contract Agreement & Contract Modification information data and enhanced productivity from manual monitoring by one individual and eliminated information mismatch, replication of existing line of records and also speeding actionable items based on priority, aging and exact state each request awaiting at any Point In Time by any user.
CAPITAL GROUP, Irvine, CA
Solugenix - March 2014 to April 2014
(Contractor/Consulting) Business Analyst & Reporting /Data Migration Analyst
Worked on 3 specific projects related to performance measurement and/or portfolio analytics and automated Business Process to create an End User Application. Automated Portfolio Statement Reports for client dissemination in seamless PDF format output. Also created Custom Reports from data aggregation involved various sources of high volume transactional & reference data. Automated Processes utilizing VBA & SQL both in Excel & Access that required to create a tool additionally for Business Users from their current processes.
Extracted data from financial system data marts using SAS/Access, SAS/SQL procedures and created SAS Data Sets
Generated output using SAS/ODS and SAS/Views from Oracle DB tables and used PROC Tabulate, PROC GChart, PROC Report and PROC Summary during generation process.
KAISER PERMANENTE, Burbank, CA
Enclipse Corp. - August 2013 to February 2014
(Contractor/Consulting) Data & Reporting Analyst
Participated in Data Mapping/Data Validation & Data Delivery Model of KPIF (Kaiser Permanente Individual & Family) Financial Systems on all Plan Benefits for ACA & Legacy Data Plans that went live on September 2013. Worked with various templates of Actuarial Rate Data Vs. Marketing (MARCOM) Data that flows into internally built Billing & Proprietary Financial Applications & DW tools (GMT, DST, SMU, AMT) & Vendor Applications (PROPANE & CONNECTURE) Implementing Frontend/Backend data to host internet sites for healthcare KP.Org& others.
Created Workbooks and Dashboards using calculated metrics applying with desired visualization requirements drew upon various range of Tableau platform technologies and designed leveraging advanced BI visual presentation technics and features that offers by Tableau.
Published Dashboard reports embodied with rich graphical presentation enabling consumers to view cumulative data factors with side bars, scatter Plots, Stacked bars, Heat maps as per deliverable specs and captured changes and modifications time to time that came to reflect in SBC (Summary of Benefits) that were sourced from SERFF (System of Electronics Rates & Form Fillings) & HIOS (Health Insurance Oversight System) along with other Key healthcare guideline and regulatory sources.
Created a Plan Comparison Utility in an MS Access Database, MS Excel (Pivot, VLookup, Cross Tab Query for Cube Report) and added Automation of import process from CSV/Excel file data using VBA &SAS/SQL Query that execute codes to run comparison in order to identify data duplications, duplications with differences, missing data points in either tables via global composite IDS, and structural differences of data strings that required Data & Business Logic.
Created various Compliance Reports requiring automating in MS Access Report eliminating manual process to extrapolate Client Trigger Events Summary on Client Participation Activity, Features of Client Trending, and Dashboard like Cube & High Volume Metadata Aggregation Reports. To accomplish that created SQL Server tables to warehouse backend data sourced from TXT, EXCEL files along with MS Access VBA Automation to a GUI Frontend.
Also maintained Project tasks & SharePoint Site contents on Ratings, Actuary, Marketing & IT task progression of various PMO Project administrative aspects including administration, creating SharePoint Sites &updating documents & Business Processes, Change Controls, Defects, Testing &Release information from EMs/PMs (Engagement Managers/Project Managers), participated meetings, SharePoint connected Outlook Calendar tracking, delegating activities of various Project Tasks using MS Project & internally built proprietary applications.
BANK OF AMERICA, Thousand Oaks, CA
Pyramid Consulting - August 2012 to July 2013
(Contractor/Consulting) Reporting & Data Migration
Generally responsible for the creation of daily production and ad-hoc reports with established SQL Server processes.
Responsible for ensuring timely producing and fully validated reports; followed up issues raised by report consumers for HAMP, FHA, DOJ & other programs on Mortgage Refinancing Programs.
Assigned and took ownership of sub-processes for which responsible for maintenance, enhancements, optimization and project oriented activities.
Involved in gathering analyzing user requirements, developed functional and operational specifications using specified techniques and automated tools like ETL for SSIS packages to extract target data and run data via SSRS for reporting.
Was responsible to take existing reports on current (legacy, waterfall style, Aggregation, cube) reporting platforms (Excel, Access, T-SQL, SSIS packages) and migrated to SQL database Reports using SSRS. Also created & modified Stored Procedures on scheduled jobs and modified SQL Query Scripts on statistical & trend analysis report data sets.
Developing detailed functional specifications including data and function models, process flow diagrams, and report and screen layouts. Document algorithms and operational requirements, identify logical system architecture, specify system interfaces, develop test plans and user guides, oversee acceptance testing, provide user training, and support users in the development of work processes.
CAPITAL ONE BANK, McLean, VA
Strategic Staffing Solution - October 2011 to February 2012
(Contractor/Consulting) Project Application Support & Business Analyst (Murex)
Worked with a Derivative Management Systems IT group, Treasury Accounting, Regulatory, Murex Market Data & Trading Systems in a Business System Migration (Reval to Murex) and integrations.
Implemented the Data Governance/ Data Quality program for various source systems that are used for Basel II Capital calculation.
Worked with operations and tech teams in deviation discovery dealing with systems feed data point failure with Dodd-Frank Regulatory Reporting, Basel I/II regulations for transparency of transactions, Monthly, Quarterly, Annual, and other requirements in terms of compliance reporting to various regulatory agencies.
Worked extensively with Murex Market Data Front Office systems in price feeding providers such as MarkIT & Bloomberg.
Worked in development projects as well as various vendor package implementations throughout the Migration.
Participated in Database clean-up activities using SQL & Business Object Reporting Tools on Trades, Market Data and Report purging on retired Reports.
RBS SEMPRA COMMODITIES, STAMFORD, CT
Focus Capital Markets - October 2010 to August 2011
(Contractor/Consulting) Price Desk Application Support Analyst FX, Energy, Crude Oil & Commodities Market
Setting new markets in our trading systems for traders to book trades against them, setup includes setting expiry dates, value dates and delivery periods for a futures contracts.
Reconciling exchange traded spread options and ad hoc calculation and submission of correlations to accurately value the spread options for Oil products.
Operational management of inter-company swaps for correctly valuing and reporting on holidays.
Working with Risk dept. on developing models to ensure reporting of P&L at New York market close which includes accurate FX rates and time adjusting forward marks for European products to New York market close.
Troubleshoot day-to day issues and ensure FX, Crude Oil, Fuel Oil and Energy Products prices (MTM prices/Forward Curves) are correct in the trading system, volumetric and price exposure/risk(s) are correct.
Worked with Middle Office reconciling house outs between JMS/ICTS and Affinity that requires very good understanding of Trade Capture and MTM P/L & Forex trading.
Marking and loading OTC prices for crude and products traders in London, Geneva and Singapore for both out trading systems, JMS and Affinity. Acquired fair knowledge of all JMS/Trade Capture applications such as Trade Entry, Portfolio Manager, Scheduling, P/L report.
Managing daily price loads, including all foreign exchange, interest rate, published and OTC prices for both domestic and international markets in JMS and Automated/Adjusted daily forward price feed procedures, spreadsheets macros and applications with a focus on improving the processes in a dynamically changing environment.
MORGAN STANLEY SMITH BARNEY - Wealth Management, NYC
Network & Co. / Tiger Information Systems - November 2008 to October 2010
(Contractor/Consulting) Application Support Analyst Equities, FID, Retirement & WMG Solutions
Conferred with personnel of relevant organizational units to analyze current operational procedures and identify problems.
Prepared and coordinated Client Side Equities/Fixed Income transactions on finalizing Business Requirements for trade modifications capture on Cancel & Correct (CnC) or Amended trades and structured/nonstructural derivative products.
Analyzed user requirements, procedures, and problems to improve business process and conducted extensive data quality, data cleansing, data remediation and data validation process. Wrote detailed description of user needs, as well as functional and/or technical specifications and reviewing current business process, workflow and scheduling limitations.
Prepared workflow charts and presentation diagrams and coding with Microsoft Access, Visual Basic and Business Objects on the legacy and system interface processes on equities, retirement products, and regulatory reporting.
Fixed Income software supported for customers that consist of banks and institutions, and coordinate, implement, and deploy solutions for customers with different Reference Data Contents (Bloomberg, Reuters EJV/EJM, and Option Metrics) and Trading Strategies.
CITIGROUP, LIC, NYC
Insys Consulting - June 2008 to October 2008
(Contractor/Consulting) Finance Application Support Analyst
Analyzed, updated and installed proprietary gateway components, and provided technical and analytical support to traders, or in-house support for day-to-day fixed income trading on Production and development systems.
Worked with in-house fixed-income CO&T (Corporate Operations & Technology) Support Groups, in order to provide general to complex support for customized gateways, and components residing on the firm Application platform.
Acted as liaison between the BU/OU Customer, sales and developers to provide the most efficient application support on the client live and ongoing development of fixed-income trading platforms.
Updated Organizational (Business Unit)/Organizational Unit of Hierarchy in Hyperion Essbase Database for Month End & Quarterly Close, Actual, Flash and Planned Cost Allocations and roll ups analyzing source data across various Financial Systems for Accounting (Oracle GL Data), Products involving production and number issues that reflects mapped merging data into multi-dimensional reports for higher management.
OGILVY AND MATHER, NYC
Solomon Page Group - January 2008 to May 2008
(Contractor/Consulting) Applications, Data & Systems Analyst
Aided in managing application specific reference data, updated HLC (High Level Concept) documentation for modification of a Globalized Database Datamart Integration Project. Reviewed requirements and created complex Visio diagram of Common Shared Landing Data Repository space interfacing processes for data standardization, data staging, data consolidation for inbound and outbound, single and bi-directional dataflow from source systems, tools, APs, ARs, GLs and Central Database Data mart with technical (i.e. Actuarial, finance, business) and non-technical (i.e. vendors, administration, systems) data.
Analyzed and implementation of data "intensive" functionality, focusing on quality and performance
Organized and managed sets of data verified data attributes and helped created test data and supporting the relevant test scenarios to be used by developers, testers, and business users during every phase of integration.
Maintained liaison and provided support to software developers, data architects, and test managers with regards to BRDs, FRDs and DSDs.
Carried out analysis of web search results for the InvestTool clients of Ogilvy and Mather. Studied downloaded data from Yahoo, Google, Ask and MSN Analytics Modules and carried out search engine keywords, cost factor analysis. Using Analytics Tool queried data and thus arrived at Keyword positioning for various queries that ran on Clients web sites.
Made heavy use of Access/Excel and did relevant Grouping of data and X-Reference Checking.
LEHMAN BROTHERS, NYC
TACWorldwide Companies Inc - July 2006 to December 2007
(Contractor/Consulting) Application Support Analyst/Accounting & Finance Data Control Systems SDLC
Interacted with Traders, Product Controllers, Operations Managers, Risk Managers, Compliance Managers, and Legal Entity Controllers on new requirements and workflows being developed jointly with Enterprise Account Management (EAM) application for Firm Account Opening Workflow and rollout phases launched globally (through the beginning of June 2007 and rollout schedules). Phases supported single account opening requests for Cash business lines, Target Derivative businesses and also addressing multiple accounts on a single request and with the ability to copy from an existing account.
Coordinated with Requesters and Technologists in Trade Capturing source system databases, Data Feeds and Hosts of trading accounts in functionality, workflow, metadata query download (e.g. Proprietary - PathFinder, GQuest, DMS, PALS, SUMMIT, CARRUSO, MUREX, RISC and Intranet ERM, Enterprise Relationship Management and Others) across Lehman Brother Entities for Derivatives & Cash/Credit/FX/Commodities/Energy Trading systems, Front Offices, Equities, Risk Managements in categorizing the Firm Accounts of GL data reporting into downstream P&L Center data structures and data mappings.
Analyzed High Volume AP, AR, GL Data involving Enterprise Accounting Projects in Book Map Accounts and also Post Deal GL Reconciliation, Discovery and troubleshooting from Back Office Systems using SQL queries to extract data questionable for Escalation on various issues to Technologists. Verifying Suspense accounts and P&L Failure/Exception reports which were the keystone via cross reference systems in cleansing Accounts successfully. Analyze heavy Journal Entry data and recommends appropriate course of action proactively identifying areas of risk & exposure and present alternative solutions.
Rationalized and validated deals, account creation, maintenance and closure against the ER Model. Retrieved to examine the books/accounts in reporting discrepancies from repository & host systems and cleansing for PNL, Risk and for other attributes.
Contact this candidate