Mohana Krishna Shyam Nanda Gopal
Chennai,India
Summary
- Accurate Senior Analyst with exceptional teamwork, leadership and communication skills. Over 17 years of experience working on large-scale projects as well handling daily operational requests. Exceptional technical understanding to meet project deadlines.
- Detail-oriented team player with strong organizational skills. Ability to handle multiple projects simultaneously with a high degree of accuracy.
- Vast experience in development, testing, implementation, and production support expertise in Abinitio, Informatica, DataStage, Teradata, SAS, PL/SQL, ORACLE, SQL SERVER, Unix/Linux Shell Scripting and Data warehousing.
- 6 years of Client facing Onsite experience in Jacksonville, Florida, USA.
- Experienced in collaborating with Business representatives, Business users,Technical team and Business analysts for requirements analysis and to define business, technical specifications and functional specifications, gap analysis.
- Experience in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatches.
- Experienced in preparing Test Estimation, Test Strategy, Test Plan, Test Scenarios, Test Cases, Test Execution, Documented Test Results & Test Completion Report and review with a project team member and Business users.
- Experience in using UNIX/LINUX commands and shell scripts for file management.
- Experience validating the ETL and SAS batch jobs scheduled using Autosys and OPC schedulers.
- Experience using HP Quality Centre and ALM as Test Management tools.
- Production batch support, which includes monitoring batch on a rotational basis, user support, on-call support, job failure analysis and Unix system and process management.
- Trouble-shooting day to day issues which comes through service now ticketing tool and providing a root cause and fixing it.
- Ensures Level 2 production support requests, clarify tickets, ad-hoc queries, support to external applications are allocated within team and track its completion/resolution.
- Identify and respond to events that impact production and aid in resolving those issues, including technical resolution and management communication.
- Identify root causes of reoccurring problems and suggest solutions to Development team and track to its completion.
- Participate in COB test planning and monitoring by testing applications on multiple servers to ensure the servers can handle the applications and the applications are mirrored on each servers.
- Represents the team on P1, P2 and P3 calls and strive to resolve the issues and stabilize the application to ensure minimum downtime.
- Handled customer planned activities not limited to Certificate changes, ETL tool version upgrades, NDM upgrades, Teradata version upgrades and ssh key change activities.
- Experience with building SQL scripts and analyzing PL/SQL scripts for report validations, data validations and data analysis in RDBMS likeToad, SQL Developer, Teradata SQL assistant.
- Excellent skills in writing complex SQL on Oracle and Teradata.
- Good experience on MS Access and Excel advanced features such as Excel Macros Charts and Pivot tables.
- Proven strength in problem-solving, coordination and analysis.
- Achievement oriented with excellent people management skills and an ability to manage change with ease.
- Strong communication, interpersonal, learning and organizing skills matched with the ability to manage stress, time and people effectively.
Overview
16
16
years of professional experience
Work History
Data Analytics Senior Analyst
Citibank, NA
06.2022 - Current
- Enhanced team productivity by streamlining workflow processes and implementing time-saving strategies.
- Improved company efficiency with the development of key performance indicators and tracking metrics..
- Collaborated with cross-functional teams to identify areas of improvement, leading to increased operational effectiveness.
- Mentored junior analysts, fostering professional development while enhancing overall team performance.
- Identified and resolved problems through root cause analysis and research.
- Investigated system issues and implemented resolutions to reduce downtime.
- Recommended process improvements to continually identify, analyze and fix constraints and challenges.
- Performed system analysis, documentation, testing, implementation, and user support for platform transitions.
- Validated results and performed quality assurance to assess accuracy of data.
- Queried databases for information needed for report processing.
- Performed budget analysis to control expenditures and predict future budget needs.
- Analyzed data to identify root causes of problems and recommend corrective actions.
- Generated ad-hoc reports to evaluate specific business requirements.
- Provided technical support for troubleshooting analytics and reporting issues.
- Developed complex dashboard and reporting tools to track business performance metrics.
Senior ETL Analyst - Business Intelligence
Tata Consultancy Services
02.2017 - 06.2022
- Manage a team of 10 ETL Tester at Offshore
- Validation of data transformations and perform End-to-End data validation for ETL & BI systems
- Create Test plans and Test scripts which ensure that ETL batch perform the required data transformations and load as specified in the requirement documentation
- Perform in-depth testing covering the Data Quality check, Source to Target validations, Datatype validations and any Data discrepancies
- Perform Regression testing on all the impacted applications for each release, to ensure we do not see any data issue with the existing process
- Perform Automation testing using Fastest Tool and Abinitio GDE Scripts
- Automate Test script preparation using ARD and XLS Macros
- Diagnose the data discrepancies identified and recommend solutions and determine if proposed solution meet requirements
- Participate in the test review meetings, review the SIT/UAT test cases created by the application testing team, and ensure that it meets the project requirements and all possible scenarios covered for the owned application
- Prepare validation plan checklists for the entire SIT/UAT phase, test the application end to end, and ensure that the business requirement is working correctly
- Join the defect meetings / calls and update the test managers with the status of defects, if any
- Provide the timely resolution to UAT/SIT issues on specified SLA, tracked through HP Application Lifecycle Management tool
- Support Sever migration validations and Test environment configuration changes/outages
- Analyse the Production INCs and perform RCA to find the issues due to Testing miss and plan a remediation to avoid from occurring again.
Senior Production Analyst - Business Intelligence
Tata Consultancy Services
04.2012 - 02.2017
- Responsible for research and data analysis for major production issues, client requirements, new initiatives in production
- Working with production external users to identify the top long running jobs and optimize the Abinitio graphs, Datastage transformations, Unix codes and Teradata queries to cut down the execution time by 30%
- Handled migration of 275TB of data in production environment including working with 18 third party companies involved with the server from Solaris 10 environment to Linux Grid Environment
- Optimizing mainframe jobs by saving mips, identifying redundant files, turning off compression during transmission etc
- Designing the continuity of business (COB) environment involving space forecasting, establishing the required connectivity, designing the sync up to production and scheduling jobs
- Responsible for software and hardware production environment management, which includes AbInitio/Datastage version upgrades, server re-boots NDM re-boots, batch job scheduler upgrade and outages
- Responsible for production data security and integrity to avoid data breaches and ensuring CITI business as well third parties have the correct level of permission to production data
- Handled migration of production job scheduler involving migrating around 12K jobs from Maestro (IBM based application) to Autosys
- Responsible for reviewing all the changes that are made in production and collecting all the necessary documents and production hand off documents.
IT Analyst - Business Intelligence
Tata Consultancy Services
02.2011 - 04.2012
- Data Analysis and Data Discovery of the Existing Source systems of EG-IT to come-up with the source to target mapping rules
- Logical & Physical Design of the staging tables which will handle the CDC (Change Data Capture) logic to temporarily cache the data from the source systems
- Documentation of the Data Model Design document, ETL Detailed Design Documents, and Report Design Document
- Acted as an ETL Developer using AbInitio to create graphs and execute it through Unix Shell scripts for extracting the data from various source systems and transform/load the data into the target datamart
- Actively participated in the SIT, and FAT phases while at offshore and always ensured that the issues raised during the testing are closed within the minimal time
- Providing the Warranty Support to resolve the production issues encountered in the project.
Senior Systems Engineer - Business Intelligence
Infosys Technologies
01.2010 - 02.2011
- Data Analysis and Data Discovery of the Existing Source systems of EG-IT to come-up with the source to target mapping rules
- Logical & Physical Design of the staging tables, which will handle the CDC (Change Data Capture) logic to temporarily cache the data from the source systems
- Documentation of the Data Model Design document, ETL Detailed Design Documents, and Report Design Document
- Acted as an ETL Developer using AbInitio to create graphs and execute it through Unix Shell scripts for extracting the data from various source systems and transform/load the data into the target datamart
- Acted as BO Developer by creating various canned and dynamic report scenarios
- Actively participated in the SIT, and FAT phases while at offshore and always ensured that the issues raised during the testing are closed within the minimal time
- Providing the Warranty Support to resolve the production issues encountered in the project.
Systems Engineer - Business Intelligence
Infosys Technologies
01.2008 - 01.2010
- Data Analysis and Data Discovery of the Existing Source systems of EG-IT to come-up with the source to target mapping rules
- Logical & Physical Design of the staging tables which will handle the CDC (Change Data Capture) logic to temporarily cache the data from the source systems
- Documentation of the Data Model Design document, ETL Detailed Design Documents, and Report Design Document
- Acted as an ETL Developer using AbInitio to create graphs and execute it through Unix Shell scripts for extracting the data from various source systems and transform/load the data into the target datamart
- Acted as BO Developer by creating various canned and dynamic report scenarios
- Actively participated in the SIT, and FAT phases while at offshore and always ensured that the issues raised during the testing are closed within the minimal time
- Providing the Warranty Support to resolve the production issues encountered in the project.
Skills
- Client management
- Performance monitoring
- Competitive Analysis
- Report Preparation
- Data Analysis
- Process enhancement
- Root Cause Analysis
- Incident Reporting
- Project Management
- Process Improvements
- KPI Tracking
- Variance Analysis
Education Summary
Anna University, Chennai, Bachelor Of Engineering, B.E. Computer Science and Engineering
Accomplishments
- TCS Gems Award received for "Service & Commitment" on 02/23/16.
- TCS Gems Award received 3 times for various contributions and achievements.
- Appreciation note from Client Manager for recovering the application quickly from Major Migration.
Technical Summary
Methodologies
Waterfall and AGILE Scrum
ETL Tools
Ab Initio, Informatica Power Center, Datastage
QA Tools
HP-Quality Center, ALM, JIRA
DBMS
SQL Developer, TOAD, Teradata SQL Assistant
Scripting
UNIX/LINUX Shell Scrip, SAS
Languages
C, C++, SQL, PL/SQL
Database
Teradata, Oracle 11g/10g, SQL Server 2008/2005/2000,
BI / Reporting Tools
Business Object
Operating Systems
Microsoft Windows 10, 8,7, Visa, XP, 98, 2000
Scheduling Tools
Autosys, OPC
Other Tools
ServiceNow, MS Office Suite (Word, Excel, Power Point, Outlook)
Driving License Details
F/TN/36Z/000560/2006, INDIA, 03/20/26
Personal Information
- Passport Number: R8222746
- Number of Children: 2
- Date of Birth: 03/07/85
- Gender: Male
- Nationality: Indian
- Marital Status: Married
Timeline
Data Analytics Senior Analyst
Citibank, NA
06.2022 - Current
Senior ETL Analyst - Business Intelligence
Tata Consultancy Services
02.2017 - 06.2022
Senior Production Analyst - Business Intelligence
Tata Consultancy Services
04.2012 - 02.2017
IT Analyst - Business Intelligence
Tata Consultancy Services
02.2011 - 04.2012
Senior Systems Engineer - Business Intelligence
Infosys Technologies
01.2010 - 02.2011
Systems Engineer - Business Intelligence
Infosys Technologies
01.2008 - 01.2010
Similar Profiles
Travis MaddenTravis Madden
Compliance Privacy Sr Officer (SVP) at Citibank, NACompliance Privacy Sr Officer (SVP) at Citibank, NA
Tanya JaversTanya Javers
Legal Associate 3 at Citibank, NALegal Associate 3 at Citibank, NA
Lisa LeeLisa Lee
Trans Fraud Special Processing at Citibank, NATrans Fraud Special Processing at Citibank, NA
Lucia Rodriguez PichardoLucia Rodriguez Pichardo
Branch Manager at Citibank, NABranch Manager at Citibank, NA
SHURESHBABU JAYAPRAKASHSHURESHBABU JAYAPRAKASH
Senior Operations Manager / Plant Head at MillerKnollSenior Operations Manager / Plant Head at MillerKnoll