Data Engineer/Analyst

Sathish Kumar Radhakrishnan

Phone: +1-214-***-****

Email: ***.*******@*****.***

Data Engineer (Technology Manager/Product Owner/Scrum Master/Business Analyst)

Summary:

19+ years of Experience in Banking and Financial domain with Analysis, Design, Development, Testing and implementation of Data warehouse along with expertise in Tableau creating highly interactive Data Visualization workbooks and Dashboards.

Experience with handling multiple projects for Bank of America and Merrill Lynch throughout my career, ensuring alignment with organizational goals and regulatory requirements.

Global professional with extensive experience working across diverse regions, including Mexico, the USA, and India.

Versatile experience as a Technology Manager, Senior Data Engineer, Data Analyst, Scrum Master, Product Owner, and Business Analyst, skilled in defining EPICs, prioritizing stories, and facilitating Agile ceremonies.

Extensive experience in working with IBM Mainframes and in ETL Datastage (Certified).

Proven track record of converting complex COBOL processes into efficient ETL solutions, enhancing operational efficiency and data integrity.

Proficient in building complex ETL data transformations using batch and real-time payloads using Kafka.

Expertise in the concepts of Data Warehousing, Data Marts, ER Modeling, Dimensional Modeling, Fact and Dimensional Tables.

Experience with all the phases of Software Development Life Cycle (SDLC). Hands-on experience with implementing complete Software Development Life Cycle methodologies such as Waterfall, Agile (Scrum).

Certified in SAFe Scrum Master.

Defining EPIC, prioritize stories and facilitate all agile ceremonies.

Performed Sprint planning, Backlog Grooming, performance velocity, stand-ups, resource management.

Experience in writing complex SQL queries involving multiple table joins.

Developed highly interactive Data Visualization Reports and Dashboards using features such as Data Blending, Calculations, Filters, Actions, Parameters, Maps, Extracts, and Context Filters.

Experience in developing multiple dashboards/reports using various charts like Stacked Bar/Pie, Line/Area, Donut, Dual-axis charts, Geo-Maps, Bubble, Scatter and Heat Maps, Gantt chart.

Expertise in designing and creating various analytical reports and Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.

Experienced in System Testing, Regression, UAT and Production checkout.

Proficient in handling version control tools SVN, Endevor, Bitbucket.

Proficient in SQL and PL/SQL coding.

Skilled in developing a framework to facilitate regression tests using python.

Results oriented, self-starter looking for challenges, ability to rapidly learn and good interpersonal skills.

Experience in planning, resource management, allocation or distribution of work, reporting, mentoring and tracking

Certified on snowflake SNOWPRO Core in March 2024.

Education Details - Bachelor of Engineering in Computer Science.

Vellore Institute of Technology, Vellore

Technical Skills

Products/Tools

IBM Mainframes, IIS Data stage 8.5/9.1/11.7, Informatica

Products

IMPACS (Core banking product)

Databases

DB2, Oracle, Kafka, Snowflake (certified)

Languages

JCL, COBOL, PL/SQL, unix scripting, Python

Scheduler

Autosys, CA7

Operating Systems

Windows & Unix

BI Tools

Tableau, Power BI

Others

Agile, Waterfall, JIRA, Remedy

Have knowledge in

Azure Data Factory, Databricks, Pyspark

Professional Certifications

Certified SAFe Scrum Master

Certified in IBM Datastage

Snowflake SnowPro Core Certification

Professional Experience

Employer: Bank of America, India Dec 2015 – June 2024

Role: Technology Manager (B5) / Data Engineer /Product Owner / Scrum Master

Responsibilities:

Responsible for building and leading a team to deliver technology products and services to meet business outcomes.

Performing detailed system analysis and design functions, including the development of data flows and requirements in logical and physical data modeling.

Proficient in data governance, data quality, metadata management, master data management.

Experienced in legacy modernization (Cobol to Datastage) and converting Informatica flows.

Experienced in working with different versions of datastage and regression testing.

Facilitating the mapping requirement meeting to provision the fields to the consuming application.

Gathered Business rules and implemented functional and technical specifications.

Written complex SQL queries using joins, sub queries and correlated sub queries.

Conducting design review meetings with Developers.

Predominantly working on ETL mappings and transformations using Datastage with over 100+ interfaces.

Implementing File and Data Control rules on the incoming data feed to do checks and validations.

Accountable for application performance in production and resiliency.

Contribute to the technology strategy for their technical domain.

Worked on complex SQL Queries, PL/SQL procedures and converted them to ETL tasks.

Experienced in DSODB/DB2 Databases/tables for datastage performance queries.

Worked with PowerShell and UNIX scripts for file transfer, emailing and other file related tasks.

Facilitates program level planning ceremonies against backlog/prioritized work.

Responsible for optimizing the flow of stories and the value delivered by one or more Scrum teams.

Coordinating and facilitating scrum ceremonies, managing dependencies for the team, providing visibility into team delivery plans and progress and enabling continuous improvement within the team.

Created application performance metrics dashboard to analyze the trend and anomalies of the data.

Environment: ETL Datastage, Cobol, Autosys, Kafka, DB2, Oracle, Unix, Tableau, Bitbucket

Client: Bank of America, NC Dec 2012 – Nov 2015

Employer: Tata Consultancy Services

Role: Senior Data Engineer/Mainframe developer for legacy modernization

Responsibilities:

Performing detailed system analysis and design functions, including the development of data flows and requirements in logical and physical data modeling.

Facilitating the mapping requirement meeting to provision the fields to the consuming application.

Converting business related requirements to a technical solution and provisioning of design documents.

Gathered Business rules and implemented functional and technical specifications.

Experienced in legacy modernization working with Mainframe teams and converting them into ETL.

Responsible for legacy modernization of IMPACS and ST payloads to ETL based application.

Worked on complex payloads in EBCDIC format and redefined them in ETL.

Responsible for establishing connectivity between the Mainframe system and Unix server for transmission of data.

Implementing checkpoints and data quality checks while doing transmissions between legacy and midrange applications.

Created multiple frameworks related to data quality checks and Journals.

Worked in creating standards for receiving files from different input sources.

Environment: ETL Datastage, Autosys, DB2, unix, Cobol, Svn

Client: Bank of America, NC April 2008 – Nov 2012

Employer: Tata Consultancy Services

Role: Senior Mainframe Developer/Business Analyst

Responsibilities:

Gather and understand business requirements, analyze them and implement them in the existing system.

Experienced in core banking product – IMPACS and worked on multiple assignments.

Scoping application requirement and creating design artifacts – High level design document and Low level design document

Project discussions to consolidate the current status and requirements

Monitors the status of the deliveries and reports to Supplier management

Participate in the Management Meetings for reporting progress

Onsite and offshore team management and Liaising/ Interacting with offshore and Onsite Management for resolving issues

Experienced in working on implementing functionalities from regulations.

Environment: DB2, IBM Mainframes, Cobol

Client: Merrill Lynch, NJ May 2005 - March 2008

Employer: Tata Consultancy Services

Role: Software Developer/Business Analyst

Responsibilities:

Responsible for identifying and translating business requirements for the Enterprise Data Warehouse Into logical and physical data models.

Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.

Experienced in creating design documents, System diagram, and traceability matrix.

Written complex SQL queries using joins, sub queries and correlated sub queries.

Actively participated in User Acceptance Testing and Debugging of the system.

Coordinates the offshore activities with onsite relationship manager

Environment: DB2, IBM Mainframes, Cobol, Endevor

Contact this candidate