Home

Ranjith Kumar - ETL Developer

[email protected]

Location: Dallas, Texas, USA

Relocation: Yes

Visa: H1B

Ranjith Kumar ETL Developer 8032394659 [email protected] Dallas, TX Yes H1B Professional Summary Highly Motivated, Solutions Driven with 15+ years Experience in Data Warehousing, reporting tools which includes Analysis, Design, Development and Support. Involved in complete Software Development life-cycle (SDLC) of various projects, including Requirements gathering, System Designing, Data modeling, Migration, PoC and Maintenance. Excellent Interpersonal and communication skills with an ability to remain highly focused and self-assured in fast-paced and high-pressure environments. Having 14.6 years of experience in Data ware Housing and Business Intelligence projects in Banking, Finance, Risk Compliance and Insurance industry which includes ETL DataStage, Tableau, Power BI, Talend Big Data, Snowflake, SSRS, SQL Server, Oracle, Teradata, Hadoop, Autosys and Unix in Wells Fargo India Solutions, Wipro Technologies Ltd., India. Extensive ETL tool experience using IBM Infosphere/Websphere DataStage, Tableau, Talend and Reporting tools of Tableau, Power BI, SSRS, Cognos. Evaluating technology stack for building Analytics solutions by doing research and finding right strategies, tools for building end to end analytics solutions and help designing technology roadmap for Data Ingestion, Data lakes, Data processing and Visualization. Developed Tableau reports/Dashboards at enterprise level and Line of Business level. Presented briefly and migrated multiple legacy projects into tableau and Power BI. Lead a group of technical resources and onboarded 9 applications both in support area and development. Strong understanding of the principles of Data Warehousing using fact tables, dimension tables and star/snowflake schema modeling. Worked extensively with Dimensional modeling, Data migration, Data cleansing, ETL Processes for data warehouses. Led a team in Developing new and modifying design approach to automate routine tasks as of the new ETL architecture directions. Used Enterprise Edition/Parallel stages like Datasets, Change Data Capture, Row Generator and many other stages in accomplishing the ETL Coding. Leading the technical design team and performing code peer review and analysis. Microsoft Certified Azure Data Cloud Fundamentals 2022. Created LoB level metrics using Tableau and finished multiple projects smoothly. Excellent team player with problem-solving, Handling conflict issues and trouble-shooting capabilities. Proven ability to quickly learn and apply new technologies, have creativity, innovation, and ability to work in a paced environment. Work effectively with diverse groups of people both as a team member and individual. Trained and practitioner of Agile development methodologies and used tools (Jira, Confluence) in a compliance driven environment Technical Skills DWH/ETL Technologies : DataStage 11.7, 9.5(Designer, Director, Administrator), Tableau Reports, Power BI, SnowFlake, Talend 7.3, Hadoop, Cognos, SSRS, Informatica basics. Databases : MSSQL Server 2018, Oracle 14g, Teradata, Mongo DB Languages : Oracle/T- SQL, SQL, Autosys, Unix Shell Scripts. Other Tools : GitHub, SCM, Jenkins, Jira, Confluence, Agile Monitoring tools : Cloudera Manager, Autosys Operating Systems : Windows, UNIX, AIX, Mac Cloud Technologies : Snowflake Cloud DWH, Azure SQL Data warehouse Reporting Tools : Tableau, Power BI, Cognos Work Experience Client: Wells Fargo | Irving, TX Jan2022 - Till Date Current location: Frisco, TX Role: ETL Architect & Data Engineer Description: Enterprise Risk and Finance Technology is part of EFT Alignment in Wells Fargo which deals with Risk applications related to Third Party, Operational Risk and Finance technologies. Responsibilities: Design and develop ETL integration patterns using Datastage/Talend. Develop framework for converting existing DSX jobs to PySpark(Python and Spark) Jobs. Multiple reporting projects from excel, DB rewrited into Tableau and Power BI. Translate business requirements into maintainable software components and understand impact (Technical and Business) Provide guidance to development team working on Datastage, Tableau Platforms. Lead EFTPM Metrics in Tableau and create sharepoint URL for business usages. Lead the team in ETL tool migration from Datastage to Talend/Pyspark conversion Identify ideas, Prepare PoC, Drive end to end delivery. Drive meetings with BSC, QA and Release management. Project management activities-Quality delivery, Incident tracking, Resolving issues, Codewalkthrough, Code review, Defect prevention management. Technologies/Tools: DataStage v11.7, Tableau, Autosys, Oracle, SQL Server, PySpark, Tableau, SCM, JIRA, Talend, Power BI. Client: Wells Fargo /TX Mar 2016 - Dec 2021 Role: Team Lead and Developer Description: Operation Risk Utilities (1ORU), ORIS, SHRP Applications, as part of the Wells Fargo Enterprise Risk Management, is responsible to support analytics capability and provide the environment to house and maintain TPRM, ILD, CRAS, EIW, SCM data for reporting and analytics purposes for Wells Fargo stake holders like EDA, TRIMS, SHRP, SORP, EIW, CRAS, ILD team. Responsibilities: Lead team in Design, Development, Agile Sprint, Testing and Deployment activities. Lead team in technical and management of ETL tool datastage migration from v9.1 to v11.7 which includes server setup, Environment creation, Testing, Bug fixes/Rewrite. Awarded for the PoC implementation of replacing all modules file delivery through NDM process into single ETL job with NDM script integration. PROD support, Deployment activites for ORU, TRIMS, SHRP and ORIS Applications. Identify ideas, Prepare PoC, Drive end to end delivery. Design Technical docs, prepare test cases and peer review of Code/Scripts. Developing Enterprise, M&E Projects for every quarter of year. Lead activities STAMP forecast, Metrics, Drive meetings with BSC, QA and Release management. Project management activities-Quality delivery, Incident tracking, Resolving issues, Codewalkthrough, Code review, Defect prevention management. Technologies/Tools: DataStage v11.3, SSRS, Autosys, Oracle, SQL Server, Stored Procedures, SCM, Pac2k, NDM scripts, RSA Archer reports. Client: Wells Fargo /TX Aug 2012 - Mar 2016 Role: ETL Design and Developer Description: The Capital Markets Operational Data Store (CMODS) is a ETL and database system that contains consolidated mortgage loan data, including pipeline loans, reverse loans, and loan commitments from rate lock to settlement, using data provided by participating loan origination systems, servicing systems, and other mortgage information systems. Loan information is refreshed daily. CMODS merges the data from multiple loan origination systems into a single unified repository for analysis, and provides data for downstream business line functions. Business line customers include Secondary Markets Accounting & Controls (SMAC), Pipeline/Warehouse Asset Valuation (PWAV) group, Servicing Portfolio Management, Asset Sales, Structured Finance, Investment Analytics, Agency Relations, and the Trade Desk. Responsibilities: Developing Enterprise, M&E Projects for every quarter of year. Lead the team in Abinitio Metadata Capture effort for Validating data in CMODS. Support, Performance analysis and tuning of CMODS application. Prepare Technical docs and lead the project level effort in design, testing and deployment. Guide team members in code test, fixes, code review, support issues and documentation. Make the team and myself SME(Small Module Expertise) in CMODS. New Ideas presentation, coming up with PoC and implementation. Project management activities-Quality delivery, Incident tracking, Resolving issues, Codewalkthrough, Code review, Defect prevention management. Technologies/Tools: DataStage v9.1, Abinitio, Autosys, Teradata 15, UNIX Shell Script. Client: Thames Water UK| India Mar 2012 - Aug 2012 Role: ETL Developer Responsibilities: Understanding the Data Migration and business requirements. Develop Data stage Jobs for data extraction and migration from one server to other server with different source data. DBA Role like Maintenance of Database, Creating Triggers and Stored Procedures at SQL server database. Database migration from Dev to SIT, UAT and deployment in production server. Technologies/Tools: Data Stage 8.5, SQL server 2008, Cordys. Client: Michelin | India Feb 2011 Mar 2012 Role: ETL Developer Responsibilities: Monthly generation of cube with the new monthly data given by business. Cognos server and SQL Server DTS Packages configuration. Develop ETL jobs for new enhancements using talend and few in MSBI DTS Packages. Production support activities and Maintenance. Performance of tuning jobs. Fix data issues and test it before the next month activity. Upgradation of servers and Enhancements in MEMS_OF, PAPERLESS apps. Technologies/Tools: Datastage, Talend, Cognos reporting, MSBI, Crystal reports. Client: General Motors, Detroit | India Dec 2008 Jan 2011 Role: Software Engineer Responsibilities: Develop Datastage Jobs for data extraction from input files, transforming and generate target IW files. Develop sequencers and shell scripts for existing jobs and new business requirements. Project management activities Status tracking. Defect Prevention Management. Run the regular cycle runs with the new data given by business. Production support data issues and find the root cause of the issue. Fix the data issues and test it before the next run. Preparation of the Technical Design Documentation, test cases. Write PLSQL stored procedure for object wise excel report based on requirements. Technologies/Tools: DataStage, Oracle SQL stored procedures, Autosys and UNIX shell scripts. Certifications Microsoft Certified: Azure Fundamentals Since December, 2022 https://www.credly.com/badges/fa04747a-fca0-43b2-96c2-205986268f70/public_url Academic Profile QUALIFICATION BOARD/COLLEGE YEAR OF COMPLETION AGGREGATE Bachelor of Technology (Electronics.Communication.Eng) Affiliated to Acharya Nagarjuna University. V.R.Siddhartha Engineering College, Vijayawada. 2004-08 82% Keywords: quality analyst business intelligence database rlang information technology Texas