Shaik Mohammed Rafiq

Contact No: +60-111******* E-Mail: adinf8@r.postjobfree.com

With more than 10+ years of experience in Software Industry. Seeking to take a challenging role as a Senior Analyst, providing an efficient & effective solution that will help the organization to accelerate productivity along with business targets in market.

Experienced & qualified Senior Data Analyst with experience in Banking/Financial domain and in-depth knowledge in assessing technology integration and major IT project implementations.

Certified professional as "Teradata FSLDM Certified profession in 2016/2017”.

Good Experience of Informatica Power Centre, Hadoop, Hive, Teradata. And tools like IBM analyser for Data profiling.

Worked in both Waterfall and Agile business model.

Good Experience with Informatica. Working knowledge on preparing and maintaining Data Glossary, business Glossary and Informatica Data Catalogue.

Data Mapping, Data Profiling, Data Cleaning and working with Data Anomalies.

Substantial exposure in Requirements Gathering, Technical Coordination and Design & Data Analysis. Performed Feasibility Analysis, Impact Analysis, Cost/Benefit Analysis, Gap Analysis, Data Analysis and Risk Analysis and Updating Business Glossary based on the requirement.

An accomplished and fluent communicator with strong investigation, problem-solving and decision-making skills, combined with a pragmatic approach and sound business acumen.

Involved in functionality testing, UAT, system testing, integration testing, and regression testing and browser testing.

SKILLSET

Domain Skill: General Banking & Finance and General Insurance.

BI Tools: IBM Data stage 9X/8X, Cognos 10.1/8.5, Informatica 9.1, Hadoop-Hive.

Databases: Teradata 14.10/13.10, Oracle 11i/10G, SQL Server, DB2, MYSQL, PostgreSQL

Defect tools: JIRA, HPQC 10.0 and JTRAC Ticketing.

Hadoop Utilities: Hive, HBase, Spark and PIG scripting.

Document Mgmt.: Office, Share point, Ultra Edit

Platform: Windows, UNIX-AIX, LINUX. Reporting: PAXATA and Tableau 10.2

Tools Used: Hive, Hadoop and Teradata for Data Analysing, Microsoft Visio Studio Professional 2007. Informatica Power Centre.

Title: Maybank Malaysia

Project: REDW (Regional Enterprise Data Warehouse)-DQR (Financial Recon)

Role: Senior Data Analyst Duration: June’ 19 – Till Date

Tools Used: Informatica Power Centre, Oracle ODI, Excel, Teradata FSLDM, Unix, putty, Teradata SQL Assistant14

Overview: Successfully Implementing the DQR project and RSME project. Current existing REDW Teradata platform. This will implement the Recon between EGL, REDW and Source system. Creating a recon entity in Teradata and generating Daily, Monthly Balance sheet and Journal Ledger.

Responsibilities:

Developing Informatica Mappings, Sessions and Workflows for the ETL process.

Maintaining And creating Data Glossary and business glossary.

Working on Teradata source scripts to load data into UDL views for all the Nullable columns.

Doing Analysis for the incorrect data and data validation for the columns in UDL Views.

Loading data into Hive tables by using ODI tools.

Created ODI Mappings and packages to load data from Teradata to Hive tables.

Modifying the existing Teradata UDL Scripts to load the data with some business logic.

Create Sessions and Workflows using the Workflow Manager, Tested the data extracts to check if they confirm to the business rules.

Worked on the Data mapping document for the columns weather they came into Dim and facts based on that users will take to decommission for some of the Applications.

Worked as Teradata Developer and met the critical deadlines by delivering the code on time.

Title: TATA Consultancy Services Malaysia

Client: Standard Chartered Banking Group – SCB-GBS (Global Business Services)

Role: Senior Business Analyst Duration: Sep’ 15 – June-2019

Tools Used: Hadoop, Teradata for Data Analysis. IBM Analyzer for Data Analysis.

And for reporting tools like PAXATA and Tableau 10.2

And Teradata SQL assistant14, Hadoop, Hive, DB visualizer, JIRA, Putty, Excel Reports.

Overview: The project deals with the Preparing Hadoop platform and sourcing the data from different systems like EBBS, Cards, Payment systems and loading to Hadoop platform and this data will profiled, cleansed and mapped based on the requirement and will be used by different consumers across the bank systems.

Creating Mapping for preparing multiple user reports, using the EDM data and creating Data lake for consumption projects.

Critical reporting to Bank Negara was also automated and these reports are directly pulled from Hadoop directly now. Involved in preparing DRD, Mapping and UAT for these reports.

Responsibilities:

Worked directly with Functional Analysts in understanding the information needs of the business and developing ETL processes to meet these requirements.

Developing Informatica Mappings and Workflows for the ETL process

Analysis of the Source System Data

Responsible for running the Initial and Delta Loads

Involved in writing queries to check data validation

Involved in developing ETL for loading data into Database.

Unit testing of ETL’s for the functionality and performance aspects.

We are using SVN tool for maintain versioning and for managing history code and for package purpose.

Onsite calls handling and Issue Resolution.

Extensively involved in Data Extraction, Transformation and Loading (ETL) from Source to Target systems using Informatica Power Center

Involved in the development of Informatica mappings and tuned for better performance

Developed mappings by extensively using Informatica Transformations like Filter, Expression, Source Qualifier.

Create Sessions and Workflows using the Workflow Manager, Tested the data extracts to check if they confirm to the business rules

Involved in migration of Informatica & Database objects to Production ENV.

Preparation of Unit test cases document and unit test results document. Appreciated for the quality of the work by onshore.

Worked on winscp tool to move scripts from local path to Unix path. And then will execute scripts from unix.

Designed test case documents, Involved in Unit testing and Performance tuning.

Used packages for deployment.

Title: AM General – Integration

Client: AMG, Malaysia

Role: Application Consultant (Business / Data Analyst)

Duration: Jan-2015 To Sep-2016

Overview: Am General is one of the largest motor and leading general insurance companies in Malaysia. Amgeneral is offering variety of products for customer needs. AMG insurance acquired Kurnia Insurance in September 2012. Integration of both systems is happening in multiple phases. As part of initial phase, motor business is being integrated.

As part of customization build new modules like Covernote, CBC blocking, Quotation etc. Enhancing existing applications to fit for integration of both systems.

Contribution goes into integration of motor and fire products. And handling team for new product setup for detariffication.

Was a part of GST changes, In 2015 Malaysian government had implemented 6% GST for all the Goods and Services. A Tax engine was created to calculate the GST and modified the reports and Screen accordingly to add this GST changes.

Responsibilities:

Participate in BRD walkthrough sessions with project team and other stake holders.

Coordinate with DBA support team and make the standby databases available for our load on time.

Monitoring all the Critical applications Daily sales, Weekly sales, instock jobs. Fixing and resolving the issues during the process.

Executing the RITM and CR tickets based on the developers requirement.

Checking the failures of FASTLOADS and fixing it immediately.

Coordinating and supporting all the MEIJER operations.

Communicating the end-users if there any delay in data refresh

Checking the upstream jobs if any delay .so that it will impact our Mainframe jobs and the jobs should complete with in the SLA.

Working with JCL’s,Procs and parmlibs for techdeb work.

24/7 production and process support.

Worked with DBA’s in production for long running jobs as per custom needs

Communicating the end-users if there any delay in data refresh

Understand scope of project and maintain Query sheet if any quires around project and review and do a system study to know area of customization

Identify components/modules which are to be modified And Prepare GAP list with modules and changes required.

Estimate effort that required for customization and Finalize dates for each phase (Development, UAT, implementation) as per priority

Align resources based on projections. Make sure all deliveries are happening on time.

Involve in preparation of functional specification and Work with team on development progress.

Present final FSD to all stake holders, project team and get signoff from them Check/review quality of code and UTR’s prepared by team.

Involve in UAT and make sure addressing all defects raised by testing team

Pre-implementation activities and prepare implementation checklist. Conducting reviews on code and documents. Prepare knowledge sharing documents for new comers. Updating task status in weekly project meetings.

As a Scrum Master, I coached my team of a product owner and six developers on Agile / Scrum framework and deployed scrum practices. I worked very closely with the product owner and helped him in building and prioritising product backlog items.

Ensured team was on track for each bi-weekly delivery and ensured deliveries / documentation met the criteria of “Done”. I facilitated the team in removing impediments, which enhanced the ability of the team to deliver the sprint goals.

I was the enforcer of the rules of scrum, chaired key meetings, and challenged the team to improve its process.

Product backlog prioritisation, sprint planning, daily scrum, sprint review and retrospective, definition of “Done”, determining velocity, Burn-down chart, TDD, BDD, pair programming, refactoring, release plan

Title: Nike.com

Client: Nike, US

Organization: Infosys PVT LTD

Role: Senior software Developer.

Duration: Aug-2014 TO Jan-2015

Overview: Developed Nike.com with online shopping experience, by combining different details like warehouse details, pickup from shop, and making online system a lively one. Developed an application which will stock details from the shop. Or direct purchase from warehouse. Tracking both types of orders and keeping the system updated at the real time.

Responsibilities:

Gathering requirements from business user and preparing Design/Estimates.

Program Coding and Testing.

Preparing the Unit/Integration Test Plan, Source log change and Deployment plan

Post deployment support to business user.

Analysing and resolving the production issue raised by user and operation team

Preparing Functional Specifications.

Handled data extraction/data patching requests using SQL Query and Stored process.

Title: Independence Blue Cross.

Client: Independence Blue Cross, US.

Organization: UST Global, Kochi.

Role: Software Developer.

Duration: Mar 2013 TO July 2014

Overview: We use Power MHS application to process the claims in system. Power MHS has the Scalability to Handle Large Business Volumes with Maximum Operational Efficiency and a Low Total Cost of Ownership.

Working with leading health plans across the industry, Power MHS was developed to meet the needs of large healthcare payers and the managed care market. Power MHS automated health plan administration software enables you to lower administrative costs and improve service for your customers and providers.

.

Responsibilities:

As a Team Member, I have been responsible in

Analysing the business requirements.

Preparation of Technical Specification, Estimations & planning, Code changes required.

Running SQL queries to extract/update production data

Analysis of the issues and change/enhancement requests.

Involvement of reviewing the tasks handled by the other team members.

Bug fixing, called Tickets of the application.

Involvement of the Quality Process documentation.

Involvement of Defect Prevention Activities.

Major and Minor Enhancement.

Working with QA team and business users to design test plan and test cases for User

Acceptance Testing.

Participated in defect review meetings with the team members. Worked closely with the project manager to record, track, prioritize and close bugs.

Title: Receipt Statement Maintenance

Client: Bank of America, USA

Role: Software Engineer

Duration: Jan 2010 to Mar 2013

Overview: RSM, or Receipt Statement Maintenance, is a proprietary system that processes closed-end account statements for multiple business brands or individuals. RSM functions as a shared service currently including Financial, Mortgage, and Automobile services. Because the RSM system is flexible and adaptable, it is able to interface with different receivable systems Autopro and Mortgage serv.

The RSM system generates the statements, reports using the data from the different receivable systems and Uses the concepts like Sub file, Data area, Data Queue, single record format. It also uses Physical files, Logical files.

Responsibilities:

Involved in Analysis of new developments and Enhancements.

Involved in Preparing Test cases and Unit testing.

Involved in developing new code

Perform data analysis by using SQL queries.

Communicating between Onsite-Offshore.

Analysing the business requirements.

Analysis of the issues and change/enhancement requests.

Involvement of reviewing the tasks handled by the other team members.

Involvement of the Quality Process documentation.

Involvement of Defect Prevention Activities.

Major and Minor Enhancement.

Developing front end application in MVC architecture.

Interacting with client for clarifications due to lack of clarity in the scope of the project.

Making assumptions while designing view as customers and end-users not engaged during development.

Meeting the project schedule with limited number of resources.

CAREER SCAN

Working as Business/Data Analyst with Tata Consultancy Services SDN Bhd.

Worked as Application Consultant with AMK Technologies for the client CSC sdn bhd from Jan 2015 to Sep 2016

Worked as Senior Software Engineer with Infosys PVT LTD from Aug 2014 to Jan 2015

Worked as Software Engineer/Senior Software Engineer with UST Global from Jan 2010 to Jul 2014

ACADEMICS

2008 Bachelor of Electronics and Communication (ECE) from Jawaharlal Nehru Technological University, Hyderabad

PERSONAL DOSSIER

Date of Birth : 30-May-1986

Language Skills : English, Hindi, Telugu

Passport Number : Z3369777

Contact this candidate