Business Analyst Associate Consultant

Rajasekhar Adi

Mobile : +1-952-***-****

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

Linked in : https://www.linkedin.com/in/rajasekhar-adi-724544239/

Professional Summary:

• I have 11 years of IT experience in TATA CONSULTANCY SERVICES (TCS), focusing on Data warehousing, Data modeling, Data integration, Data Migration, ETL process.

• Expertise in Informatica ETL and deep understanding of the Data Warehousing SDLC and architecture of ETL and tool.

• Experience in all aspects of analytics/data warehousing solutions (Database issues, Data modeling, Data mapping, ETL Development and data migration) I have been keying in delivering innovative database /data warehousing solutions.

• Strong understanding of Data Modeling (Relational, dimensional, Star and Snowflake Schema), Data analysis, implementations of Data warehousing.

• Extensive experience in developing stored procedures, Views and Complex queries using SQL Server, DB2 and Oracle PL/SQL.

• Experience in tuning of SQL queries for better performance.

• Experience in resolving on-going maintenance issues and bug fixes; as well as performance tuning of mappings and sessions.

• SDLC: 11 years of IT experience in system analysis, design, coding, and testing.

• Superior communication skills, strong decision making and organizational skills along with outstanding analytical and problem-solving skills to undertake challenging jobs. Able to work well independently and in a team by helping to troubleshoot technology and business-related problems.

• During the stay with TCS, multiple times received best team, on the spot and star performer of the quarter awards.

• Received Moody’s CIO award for delivery excellence in data privacy projects. Education:

• Mater Of Computer Applications (MCA) 2008-2011

Jawaharlal Nehru Technological University, Kakinada

• Postgraduate in Artificial Intelligence and Machine Learning 2021-2022 The University of Texas at Austin & McCombs School of Business Technical Skills:

• Informatica PowerCenter, IBM Data stage.

• DB2, Oracle, SQL Server, Sybase, SNOWFLAKE.

• Python, AI & ML concepts.

• ESP scheduler.

Professional Experience:

Client: Thomson Reuters Jul 2018 –Till Date

Role: Associate Consultant

Responsibilities:

• Currently working as a ETL tech lead cum developer, providing end to end application solution, in migrating the products subscription data from legacy system to a new sales force application.

• Working with business users and business analyst for requirements gathering and business analysis.

• Converted business requirement into high level and low-level design.

• Chalk out the effort estimates for development, unit test plan, dependencies in execution, highlight the risks and seek concurrence from the client.

• Working parallel on enhancement projects and new sale projects and end to end deliverables in sprint model.

• Worked on building a new EDW models creation for application support.

• Involved in Design, analysis, Implementation, Testing and support of ETL processes for Stage, ODS and Mart.

• Regular involvement in discussion with business partners on project plan, status, QA/UAT issues and deliverables.

• Coordinating activities with other dev, QA and UAT teams, reporting daily project status and regularly highlighting the project challenges.

• Supporting other ETL developers, providing mentoring, technical assistance, troubleshooting and alternative development solutions.

• Redesign and repointing the workflows from existing EDW to SNOWFLAKE DB. Client: CELCOM May 2016-Jun 2018

Role: IT Analyst

Responsibilities:

• Celcom is the oldest mobile telecommunications provider, worked as a data stage Tech Lead in creating the new common billing system (CBS) by combining the existing prepaid and postpaid billing system models.

• Part of new data model/warehouse design and migrating legacy model from DB2 to Netezza.

• Closely worked with the business partners on the requirement and designing of new system, part of all phases of project deliverables.

• Created stored procedures for interim report generation.

• Worked on creating Data Stage jobs and migrating the existing workflows from informatica to Data stage.

• Participated in gathering requirements, technical discussions and coordinating project tasks and deliverables with higher managements.

• Primary point of contact from offshore for the project in consolidating the deliverables and guiding the team with technical solutions. Client: MOODY’S Corporation Dec 2011- Apr 2016

Role: Asst. System Engineer -Systems Engineer

Responsibilities:

• Moody’s is a credit rating organization, gives credit score& ratings based on the performance of the organizations.

• Worked as developer in enhancement and development teams for implementing new functionalities in Informatica.

• Creating unit test cases and performing unit testing, working with System test teams to assist in the QA process.

• Daily managed service support activities involving incident resolution for various applications involved in the project as well as creating Knowledge Management artifacts to promote knowledge share and assist in the development of co-workers

• Worked on complex ETL mappings and data base stored procedures, part of new data model design for performance improvement and reporting framework.

• Worked on POC for migrating from Informatica to Pentaho ETL tool. PG in Artificial Intelligence and Machine Learning (Sep 2021- Oct 2022):

• Completed multiple hands-on projects using python which includes advanced concepts on CNN, CV, and NLP during the PG program.

• Experience in building AI & ML models and improving the model performance.

• Capstone project on Car model detection using CV and object detection techniques.

• Completed individual hands-on projects on modules: Applied Statistics, Supervised Learning, Ensemble Techniques, Unsupervised Learning, Featurization& Model Selection & Tuning, Recommendation Systems, Neural Networks & Deep Learning, CNN Architecture and Transfer Learning, Advanced Computer Vision - Object Detection and Sequential Natural Language Processing.

Contact this candidate