papaiah manam

• 10+ years of experience in IT industry in design, development, testing Business Intelligence projects.
• 6+ years in Banking Domain pertaining to Financial Services and Anti Money Laundering systems and 4+ year in Insurance Domain Pertaining to BI.
• Experience in working on ETL Tool (DataStage 9.1/11.5), DB2, SQL, UNIX, and Hadoop hive.
• Good understanding on the business rules for International Banking, Name scanning and FINTRAC.
• More than 4 years of experience working on Hadoop ecosystem mainly Hive along with DataStage 11.5
• Strong experience in Agile and Waterfall methodologies.
• Constantly tuned parallel jobs for better performance.
• Experience in creating parallel jobs, sequences, parameter sets in DataStage and experience in using most of the processing stages, Db2, ODBC and complex flat file, sequential file, Unstructured data and datasets.
• Extensively involved in determining the data needed to address business user’s analytical requirements and design data models to support this analysis.
• Collaborated with Business Analyst in translating business requirements into Functional Requirements Document and to Detailed Design Document.
• Experience in troubleshooting of jobs and addressing production issues like data issues, ENV issues, performance tuning and enhancements.
• Extensive experience in Unit Testing, Functional testing, System Testing, integration Testing, Regression Testing, User accepting testing (UAT).
• Good knowledge in creating Unix shell scripts and scheduling jobs in Autosys and Tidal tools.
• Effective communicator, with excellent interpersonal and time-management skills and proven ability to manage multiple priorities.
• Reusability analysis for ETL as well as SQL.

Computer Programmer                                                                            2017-2020(From Hyderabad, India)

                                                                                                                                 2020-Present (From Toronto, Canada)

Domain: Banking

Organization: Tech Mahindra

Client: Bank of Nova Scotia

Project Description:

Global Anti-Money Laundering System forms the crucial part of the Anti-Money Laundering Compliance of Scotia bank where we collect the data from all the customer countries and load the data into different tables and then generate extracts to send to downstream systems for suspect scanning and report to enforcement departments.

Responsibilities:

• Designing and developing ETL jobs using the mappings provided by Business analysts on 11.5 on the EDL
• Unit testing ETL jobs.
• Developing Unix scripts to call the DS jobs.
• Coordinating to load masked historical data that is required for TM tuning in FCCM.
• Providing transition to production support for the new code.
• Debugging data issues if any occur.
• Provide support for Business acceptance testing.
• Interaction with business for the clarifications needed on the data feeding.
• Placing Jobs in batch scheduling tool Tidal.
• Share the Best practices to team members.

IT Analyst                                                                                                                         2014-2016

Domain: Insurance 

Organization: Tata Consultancy Services Limited.

Client: United Services Automobile Association

Project Description

The regulatory environment is rapidly evolving in the UK under the Solvency II directive and other accounting regulations. As a result, there is a significant pressure on firms to ensure compliance and to demonstrate a clear audit trail, controls and governance in relation to the underlying data. The objective of this project is to implement the Wolter Kluwer’s Solrep Solvency II Reporting Solution to enable USAA P&C to comply with Pillar 3 financial reporting requirements.

Responsibilities:

• Work with Business Analyst in translating business requirements into Functional Requirements Document and to Detailed Design Documents
• Supporting solution Architect in functional and Solution related queries
• Estimation preparation for any change request using the estimate calculator tool
• Understanding the business requirement and analyze the source data and challenges involved in the various data before processing through transformation logic.
• Had proposed and designed the solution, where the different structured flat file data are being processed using a single reusable set of jobs to the respective staging tables.
• Also involved in designing some other reusable set of jobs for processing the data to the dimension and fact tables, irrespective of changed nature of the same source file in different versions.
• Extensively used DataStage Designer to develop various Parallel jobs to extract, cleanse, transform, integrate and load data into Enterprise Data Warehouse tables.
• Used all parallel stages like Sequential files, Data set, Lookup, Join, Funnel, Filter, Transformer and DB connector stages.

System Engineer                                                                                    2010-2014                   

Domain: Insurance 

Organization: Tata Consultancy Services Limited.

Client: United Services Automobile Association

Project Description

As a part of Data Integration strategy for The Dodd Frank Act implemented in United States to ensure that all the financial institutions should withstand to the recession that may come in future, the data received from various Heterogeneous sources will be loaded into Staging Database for Reports Generation that would be submitted to Federal Reserve Bank.

Responsibilities:

• Implementing Data Validation Option (DVO) tool and MS-Excel frameworks to perform automated validation of
• data in Oracle - staging and target database.
• Participating in code walkthrough to understand the DataStage ETL jobs design.
• Participating in early phases of testing – Unit and Integration Testing.
• Tracking and reporting the defects in ALM
• Attending the daily status meeting with the onsite manager and weekly status meeting with the client manager
• Updating the daily activities in the RTC

Master of Technology           2010                                                                                                            

Jawaharlal Nehru Technological University, India, Accredited by WES