5 years of experience in Data Analyst. Areas of expertise include Informatica, PL/SQL, Oracle and Teradata. Detail-oriented with project management skills.
5 years of total IT experience which includes Business Requirement Analysis, Implementation, Testing and support of Data Warehousing applications.
Four (4) years of Data Warehousing experience using Informatica PowerCenter, Oracle, UNIX, Autosys, Teradata and SAS.
Extensive experience to extract, Transform and Load data using Informatica Power Center from different data sources like Flat Files and Databases.
Proficient in using Informatica designer, workflow manager, Workflow monitor to create, schedule and control workflows, tasks, and sessions.
Was involved in performance tuning of the Informatica mappings.
Proficient in understanding business requirement and translating them into technical requirements.
Experience in complete life-cycle of Test case design, Test plans, Test execution and Defect Management.
Experience in UNIX Operating Systems and Shell scripting.
Experience in generating reports dashboards using Business Object tool based on key performance indicators to analyse business.
Experience is generating dashboards using excel formulas to analyse data and trend over time.
Good knowledge on data analysis using oracle, Teradata, SAS and Microsoft Excel.
Diverse background with fast learning skills and creative analytical skills.
Worked as a lead for project management activities for team of 500 plus associates.
Key role in managing team's details, access provisioning, billing and revenue management.
Informatica Power Center 9.1
Business Object tool
Unix Shell Scripting
Data analyst February 2012 to February 2016Bank of America
Responsibilities Data analysis and Production Support for anti-money laundering applications.
Project Anti Money laundering application was designed to track any suspicions transactions happening in bank of America.
There were various applications to track transactions through various channels and captured data used to undergo investigation to find out whether it is really a fraud transaction.
If it is proved not be fraud, it is not taken further.
But in case it seems to be fraud transaction, such cases are submitted to government regulatory body to take legal action on involved customer.
Worked on the below applications under AML (Anti Money Laundering).
January 2012Tata Consultancy Services
Group Positive January 2011 to January 2012Operating System Windows - Bangalore, India
Period January 2011 to January 2012Title Inventory Management System
Informatica Power Center 9
Reporting Business Object tool Databases Oracle 11g, Teradata Programming SQL, PL/SQL, Unix Shell Scripting, JAVA, SAS Scheduling Tools Autosys Environment Linux (Fedora),Unix, Windows Other Tools Toad, PL/SQL developer, Putty, Eclipse, iXP, SSH Client,Filezilla Areas/Applications Banking and Financial Services Retail Services.
AARP Application receives alerts from various detection channels and enriches those alerts before processing them to EPNG.
Enrichment is a process of repairing incomplete alerts by approaching customer profile database and other related systems.
EPNG:- This Application receives enriched alerts from AARP and consolidates all related alerts into an event, based on account and party relationship and assigns a risk score to the event.
If the score is above 20, group of such events are consolidated into a case.
All US cases are loaded into MOC and non us cases are loaded into MOCI system.
MOCI:- Management of cases international system receives all cases related to Non-US jurisdictions.
Cases here are analyzed by analysts and if any case is found to have fraud or illegal activity, case will be submitted to Government regulatory to take legal action on related party.
AML CP:- AML Customer Profile scans the Bank of America Customers Profile against the rules defined under KYC norms.
Performed following activities in AML applications: Resolving technical/ application issues.
Analysing user queries and providing them solution.
Analysing production data as per business requirements.
Importing data from various sources using informatica tool ,designing mapping using various transformations as per business requirement and loading transformed data to target tables.
Developed Autosys Scripts to schedule Informatica jobs.
Developed shell scripts to perform data validations.
Extensively worked with *le transfer protocol (FTP), SFTP, etc., clients for data transfer.
Created excel macro to automate multiple manual task in application which was used to generate reports and dashboards to analyse trend.
Worked on user reports using MicroStrategy tool.
Working on RFC (Request for Change) for new implementations.
Preparing technical documentation relevant to application (Playbook, Data Movement SLA etc.) Daily stand-up calls, review meeting with business etc.
Languages UNIX Shell scripting, SQL and SAS scripting Special Software Informatica, SSH Tectia, Oracle toad, Teradata, SAS, microstrategy and Autosys for Job scheduling.
Client Name SR Store
Position Developer and BI System Analyst
Project Inventory management of a retail store where goods are received from a warehouse.
SR store is a small scale retail store where goods are received from various dealers in their warehouse and from there, they supply it to their branch stores.
Performed following activities in Inventory Management Application: Gathering requirements and analysing the data.
Designed web application for store using java/j2ee, HTML and oracle.
Importing the data from various sources (oracle database, flat files etc.) and transforming it as per business requirement using ETL (Informatica) tool and loading transformed data to target tables/database.
Generating reports using transformed data to analyse business with given key performance indicators.
Test business applications from a business perspective to ensure that all client requirements are incorporated into the design.
Operating System Windows Languages UNIX Shell scripting, SQL, Java/J2EE and HTML.
Special Software Eclipse, Informatica and SAP Business Objects Bangalore.