Swati Attivilli
Business / Data ANALYST
Performance Summary: Proactive, results-driven professional with 9-plus-year solid track record of providing support to maintain and expand existing data collection and data delivery platforms. Well-versed in creating new data collection systems that optimize data management, capturing, delivery and quality. Experienced in acquiring data from different sources and develop data systems that support in analysis and reporting.
Highlights
Real time experience as a BA on preparing Control and Gap assessment report for IHC-FED Audit regulatory reporting and Sarbanes-Oxley (SOX) sec 404 compliance fulfillment.
Hands on experience and understanding of Data warehousing projects using ETL tools like SAS and Informatica.
Currently handling Client Reference data from different external sources for control identification across the lifecycle of client on boarding.
Gap identification and remediation using different tactical and functional methodologies
Working knowledge of Tableau Reporting tool.
Hands on experience in different scheduling tools like Autosys, Cronacle.
Experience in PL/SQL, UNIX, Batch application scheduling.
Programming/analysis experience in SAS on the UNIX and Windows platforms.
Used the Procedures SQL, TABULATE, FREQ, FORMAT, and GRAPH to generate modeling reports.
Experience in performing ad hoc queries and User Acceptance Tests (UAT) for various application and reports on a daily/weekly or monthly basis. Excellent experience in working and dealing with client management Team.
Experience with 3rd party data extraction which is used to build Credit and Risk models, during which actively involved in communication and status reporting between client and vendor. Work with various domain leads, analysts and IT staff to design, develop and enhance data warehouse models, scripts, procedures and metadata for analytic needs.
Analyzed the 3rd party data to compare it with the referential data, to identify exception or in accuracies.
Generated daily, weekly and monthly reports using Proc Report and SQL.
Experience in using SAS to read, write, import and export to another data file formats, including delimited files, Microsoft Excel, PDF and access tables.
Involved extensively in Data Extraction, Transformation, Loading, and Analysis for Banking.
Experience in Creating Process Flow Diagrams and Technical Specification Document Diagrams, BRD etc.
Worked extensively on Oracle, SQL Server, MS Access Database & Creating shell scripts.
Have Experience in delivering the role of a change, escalation accountability, identifying and presenting for new business scopes and team Management.
Have been involved in Production, Migration and Deployment activities.
Working knowledge of Problem Management, Incident management different KPI reporting’s to client like SOX.
Thorough understanding of finance, marketing, production and personnel management.
Talented with the data management policies, procedures and widespread technical tools.
Strong logical, assessment and interpretation skills.
Excellent planning and administrative abilities.
Ability to implement control the executed tasks with the planned activities.
Technical Skills:
Database: Oracle9/10g, MS SQL Server, MS-Access, SQL, PL-SQL.
Languages: Oracle
GUI: Abinitio 8.9, Tableau 4.0
Operating System: UNIX, Linux System
SAS Skills: SAS/BASE, SAS/GRAPH, SAS/MACRO, SAS/SQL, SAS/ACCESS, SAS/ODS, SAS/STAT.
Others: MS Office, MS Project, Power Point, Excel, Outlook, Scheduling tools like Cronacle and Autosys.
Educational background:
B Tech with Specialization in Electronics and telecommunication from BPUT (ORISSA) (2008)
PROFESSIONAL EXPERIENCE
Customer : BNP Paribas
Location : Jersey City, NJ April 2017 – Till date
Project #1: IHC Data Governance
Role: Business/Data quality Analyst
Project description
BNP Paribas announces the creation of an Intermediate Holding Company (IHC), BNP Paribas USA, Inc. (BNP Paribas USA), effective 1 July 2016. This decision signals the bank’s commitment to the US market, its largest market outside Europe and a region that is central to BNP Paribas’ businesses and development plans. As a large Foreign Banking Organization (FBO), BNP Paribas is required by new regulation to place all its controlled US subsidiaries under a US holding company. BNP Paribas USA will hold BNP Paribas’ retail subsidiary ‘Bank West’ and BNP Paribas’ Corporate and Institutional Baking’s (CIB) and asset management subsidiaries in the United States. This project requires adequate resources to cover all the business of IHC across US namely (Finance, CLM, Collateral etc.), to participate and complete the FED audit and SOX Compliance.
Responsibilities
BNP requires publishing information in their annual report concerning the scope and adequacy of the internal control structure and procedures for financial reporting. This statement shall also assess the effectiveness of such internal controls and procedures.
The registered accounting firm shall, in the same report, attest to and report on the assessment on the effectiveness of the internal control structure and procedures for financial reporting.
As a part of Fed Audit, the project requires to determine operational objectives by studying business functions, gathering information, evaluating output requirements and formats. This includes extraction of the history data using various scripts from data warehouse.
The data is collected from the Reporting system as well as the source system to analyze scrub and identify the exceptions in different key defined elements. Microsoft Excel, Pivot tables, lookups and Informatica is used to scrub the collected data.
Once the issues are identified, root cause analysis will define the gaps at control level. Those gaps are presented to the management for remediation.
Maintaining system protocols by writing and updating procedures.
Communicate with customers, competitors, suppliers, professional organizations, or others to stay abreast of industry or business trends. The work includes accessing or presenting different reports, business intelligence information in a timely fashion to user which is carried out using AUTOSYS (Scheduling software).
Collect business intelligence data from available industry reports, public information, field reports, or purchased sources. Different reports and statistics are created and presented according to client requirement using SAS and Tableau.
Investigating Data Control check Points.
Remediation of Control gaps using Tactical and functional or strategic solutions.
Ensure Process improvement to ensure accuracy of information sourced and used in New Client On boarding.
Due diligence checks for clients, maintaining client referential data for regulatory, Risk and compliance reporting.
Tracking Issues across the corporate domain and facilitate resolution processes around fixing inaccuracies in data.
Estimate the level of effort and resource allocation.
Other important job responsibility includes logging of the issues identified throughout the journey of collecting, analyzing and report publishing, using HP-ALM (Application Life Cycle Management).This is an important part to prevent the issues reoccurrence in future.
Contributing to team effort by accomplishing related results as needed.
Operating System AIX, Windows 10
Languages Shell scripting, SQL
Special Software Informatica, SAS, SQL Developer, Autosys, HP-ALM
Customer : CITI Group
Location : Warren, NJ Feb 2015 – Jan 2017
Project #1: OPTIMA Reference data build
Role: BA/Data quality Analyst
Project description
The mission is to create a data warehouse which can be used as unified source for downstream consumption by Finance, Risk, Compliance, Treasury and Regulatory functions. Reference build is one of the primary phases of the project where all the source system data (Securities, Mitigants, Credit ratings, Fx ratings, Pricing values) are transformed and stored to be referred in the downstream processing.
Responsibilities
Project planning for each month end for the RWA calculation with the client.
Supporting OPTIMA process to complete BASEL III reporting as per Operation’s month end calendar.
Collecting/Extracting data from different 3rd party financial sources, applying different data quality logics like Fuzzy match logic in excel, SAS to the collected data.
Comparing it with the referential data to identify the differences and accuracy issues. Accordingly different Adjustment and enrichment logics were applied to transform the data.
Being a data analyst was actively involved behind the root cause analysis of the data discrepancy .
Documentation of the defects those are raised during data extraction.
Involved in Defect prevention, Code Optimization activities and Automation activities.
Data validation & Component validation.
Responsible for in life Operational Assurance and Escalation Accountability.
Investigating any failures happening in OPTIMA production system and find out the root cause of the same. As per the investigation need to modify/enhance the Ab Initio graph accordingly and keep production running.
Analyzing business user’s issues/tickets and provide the resolution of the same with temporary fix while analyzing the permanent fix for the same.
Investigating Data Quality issue raised by users and Operations and fixing the same so that the report is fine as per user/operation requirement.
.
Operating System AIX, Windows XP/7
Languages Shell scripting, SQL
Special Software Abinitio, SAS, SQL Developer, Autosys, HP-QC
ROLE: Data Analyst Jan 2014 – Jan 2015
Customer : CITI Group
Location : Warren, NJ
Project #2: OPTIMA RWA calculation
Project Summary:
Citibank has moved from BASEL II to BASEL III accord for more compliance to the risk management. It created a consolidated contracts and position data warehouse project called OPTIMA to support BASEL III reporting and management reporting. The vision of OPTIMA is to deliver BASEL III and management reporting on-time with quality that enables Citi to meet BASEL III regulatory compliances
Responsibilities
The testing and analyzing of data from BASEL II TO BASEL III .
Supporting OPTIMA process to complete BASEL II reporting as per Operation’s month end calendar as well as utilizing the same for BASEL III until the data is valid and acceptable
Identifying the flaws in the system and providing proactive solutions.
Capacity planning for batch and OLTP servers.
Involved in Defect prevention, Code Optimization activities and Automation activities.
Data validation & Component validation.
Responsible for in life Operational Assurance and Escalation Accountability.
Investigating any failures happening in OPTIMA production system and find out the root cause of the same. As per the investigation need to modify/enhance the Ab Initio graph accordingly and keep production running.
Analyzing business user’s issues/tickets and provide the resolution of the same with temporary fix while analyzing the permanent fix for the same.
Investigating Data Quality issue raised by users and Operations and fixing the same so that the report is fine as per user/operation requirement.
Resolution of Post GO-LIVE issues with top priority.
.
Operating System AIX, Windows XP/7
Languages Shell scripting, SQL
Special Software Abinitio, SQL Developer, Autosys, HP-QC
ROLE: Data Analyst Jan 2012 – Oct 2013
Customer: CITI Group
Location : Kolkata,INDIA
Project #3: OPTIMA Banking Book
Project Summary:
Citibank has created a consolidated contracts and position data warehouse project called OPTIMA to support BASEL II reporting and management reporting. The vision of OPTIMA is to deliver BASEL II and management reporting on-time with quality that enables Citi to meet BASEL II regulatory compliances and replace the existing Strategic Technology for Analysis and Reporting (STAR) platform. The mission is to create a data warehouse which can be used as unified source for downstream consumption by Finance, Risk, Compliance, Treasury and Regulatory functions.
Responsibilities
Gathering User requirements, understanding and analysis of the same for providing solutions to enhance OPTIMA.
Supporting OPTIMA process to complete BASEL II reporting as per Operation’s month end calendar.
Identifying the flaws in the system and providing proactive solutions.
Capacity planning for batch and OLTP servers.
Involved in Defect prevention, Code Optimization activities and Automation activities.
Data validation & Component validation.
Responsible for in life Operational Assurance and Escalation Accountability.
Investigating any failures happening in OPTIMA production system and find out the root cause of the same. As per the investigation need to modify/enhance the Ab Initio graph accordingly and keep production running.
Analyzing business user’s issues/tickets and provide the resolution of the same with temporary fix while analyzing the permanent fix for the same.
Investigating Data Quality issue raised by users and Operations and fixing the same so that the report is fine as per user/operation requirement.
Resolution of Post GO-LIVE issues with top priority.
.
Operating System AIX, Windows XP/7
Languages Shell scripting, SQL
Special Software Abinitio, SQL Developer, Autosys, HP-QC
ROLE: Software Engg July 2008 – Dec 2011
Customer: E-Plus
Location: Kolkata,India
Project: CRM Production Support
Project Summary:
In the three year tenure was able to gain knowledge in different CRM applications as specified below.
Norman and KUBIS
The project handles the customer creation till maintenance of the customer in the database for a giant telecom company in Germany.
DOXIS
The “DOXIS”, is an industry solution for the E-mail management of customers and their partner companies. The administrative part of it is also used for configuration of BPO users in to the system.
CRONACLE (ATOS)
Application Maintenance & Operations using
Description of Project: The “CRONACLE”, is a well renowned scheduling tool by REDWOOD industry solution. CRONACLE can help you increase productivity and make smarter use of your existing resources by actively managing your critical business processes.
Solution Environment UNIX & Oracle
Technologies & Tools Cronacle, PL/SQL, Web logic, Incident management, PR (Problem report), Silk SOX.
Responsibilities
Being a part of CRM the work exposure starts from Order entry till Order Management a customer which includes huge no of Brands .The work responsibilities includes Configuration launch and installation, maintenance and incident solving
I was leading the application of 6 members with responsibility of all maintenance work like analyzing incident, resolving, supporting launch and installation activities along with complete operations like error debugging and providing proactive solution.
Being team lead also participated in all SOX compliance, reporting to client and project development processes. Monitor the application, carrying out scheduling and installation configuration of all the production scripts. SLA/KPI reporting to client and providing consultancy to customer.