Dinesh Ram Rajan personal email
- Valid
- Valid
•Over 17 years of professional experience in IT industry that includes Architecture, Analysis, Design, Development, Testing, Implementation, Maintenance, Support and Administration of Data Warehousing applications using Teradata and Informatica.•Delivered as Developer, Onsite Coordinator, Technical Lead, Teradata DBA and Architect.•Experience in Capacity planning and space optimization in Teradata database.•Performed regular DBA activities like Creating Database, Users, Tables, Views, macros, Procedures, checking the tables skew, profiles, roles, grant/revoke permissions, space management (spool, temporary, permanent space),compression & troubleshooting the failure jobs.•Strong SQL skills and have handled complex business requirements using efficient queries.•Hands on experience in Informatica and exposure to Datastage.•Proficient in understanding business processes / requirements and translating them into technical requirements.•Worked extensively with Data migration, Extraction, Data Quality, Transformation and Loading of data from Multiple Sources to Data Warehouse.•Extensively worked on Teradata database including Teradata SQL, BTEQ, Multiload, Fastload, Fastexport, View Point, Performance Monitor. Have experience on Teradata XML shredder, TPT, Teradata Stored Procedure, Triggers and hands-on experience in performance tuning of queries.•Hands on exposure to UNIX environment and experience in using third party scheduling tools like Control M, Maestro, Tivoli, WLM Client.•Good understanding on Big data/Hadoop concepts & basic knowledge in Python programming.•Experience in Banking, Retail and Healthcare domains.•Experience in Onshore-Offshore Model.•Experience in leading and mentoring team of various sizes.•Excellent analytical, communication, presentation skills, a very good team player and self-starter with ability to work independently and as part of a team.•Teradata Vantage (16.20) Certified Master•Teradata 12 Certified Master•Teradata Certified Master V2R5•Certified in IBM Mainframe
Standard Chartered Gbs
-
Associate Vice PresidentStandard Chartered Gbs Apr 2020 - PresentChennai, Tamil Nadu
-
Senior Manager - Teradata DbaStandard Chartered Gbs Jun 2017 - Mar 2020Chennai, Tamil Nadu, India
-
Software ArchitectUst Global Aug 2013 - Jun 2017Richmond, Virginia Area• Conduct various meetings with business users to understand the requirement and prepare the requirement and technical response for the same.• Assess the environment and propose solution for the problems.• Work with Data Modellers to design the model for the mart/warehouse.• Perform extensive Data Analysis, Data Profiling and creating Data Mapping specifications for the data-warehouse/data-mart.• Prepare design documents based on the proposed solution and ensure all requirements are delivered.• Interact with the onsite and offshore team on a daily basis for technical/functional suggestions and track the smooth delivery of the projects.• Interact with different vendor teams to follow the process of moving code to higher environments.• Run the code in SIT, UAT and IR and interact with the ITT and UAT Team to handover the environment for performing testing activities.• Manage resources within the timelines.• Report project status to client and internal delivery team.• Work on Process Improvements and Proposals and present them to the client.• Mentor team members and form an Architect Team.• In-Charge for Production Support -
Technical Lead At BestbuyWipro Technologies Apr 2010 - Aug 2013• Capacity planning for the database.• Migrate components to higher environment.• Define standards/best practises for coding and process for migration to different environment.• Refresh data across environments.• User Maintenance includes User Creation, User Deletion, access rights, and connectivity & locked out issue.• Remediate the resource consuming queries & spool out queries.• Create Space reports, performance reports, analyze the performance indicators (PJI, UII, CPU Skew, Impact CPU & I/O Skew) & also take the necessary action.• Provide support to the development team to resolve the Database related issues including long running queries, adhoc-queries & also provide solution to rectify the problems.• Part of design review board where the design of all projects are reviewed.• Work closely with business users on a daily basis to get the requirements and document the same.• Doing impact analysis for requirements.• Providing solution to the team members in Design and Technical part.• Prepare a high level design and low level design document.• Co-ordinate with offshore to resolve any business/technical issues.• Assign work to team members.• Work with QA Team to handover the environment for performing SIT and UAT.• Keep track of the project deadlines.• Prepare the required documents.• Raise RFC (Request For Change) for promoting code to QA and Production.• Warranty Support. -
Systems AnalystSatyam Computer Services Ltd Jun 2006 - Apr 2010• Understanding the complete architecture and internals of the application• Understand the requirement from the requirements document.• Develop the code based on the mapping sheet provided by the modeller.• Co-ordinate with offshore to explain the requirements and assign work.• Perform Unit testing and SIT.• Get UAT sign off from the users.• Implement the work products in production.• Maintaining the necessary quality documents.• Warranty Support. -
Software EngineerDbs Bank Apr 2008 - Dec 2009Singapore• Understanding the complete architecture and internals of the application• Understand the requirement from the requirements document.• Develop the code based on the mapping sheet provided by the modeller.• Co-ordinate with offshore to explain the requirements and assign work.• Perform Unit testing and SIT.• Get UAT sign off from the users.• Implement the work products in production.• Maintaining the necessary quality documents. -
Information AssociateElectronic Data Systems Apr 2004 - Jun 2006Pune Area, India• Handling a complex warehouse environment with approx 3500 jobs of various domains.• Coordinating with different source systems and downstream teams to ensure successful loads and extracts meeting Service Level Agreements. • Handling a Critical Domain (Event Based Marketing) for more than a year.• Resolving Severity 1, 2 & 3 issues with proper documentation detailing the root cause, fix applied and permanent corrective action for the issues.• Performing regular health checks to pro-actively fix issues.• Implementing projects comprising of new business requirements, enhancement of existing applications, decommissioning of obsolete applications.• Reviewing the work done by other team members and documenting them in WPR.• Analyzing and providing solution for ad-hoc requests from the business.• Reviewing the work products/deliverables for the development teams, co-ordinate on weekly minor implementations and monthly major implementations. Provide pre and post implementation support during and after the warranty period.• Supporting monthly hardware outages and monthly Maintenance.
Dinesh Ram Rajan Skills
Dinesh Ram Rajan Education Details
-
Electrical, Electronics And Communications Engineering
Frequently Asked Questions about Dinesh Ram Rajan
What company does Dinesh Ram Rajan work for?
Dinesh Ram Rajan works for Standard Chartered Gbs
What is Dinesh Ram Rajan's role at the current company?
Dinesh Ram Rajan's current role is 7x Azure Certified | AWS Certified Solutions Architect | Teradata Vantage (16.20) Certified Master | Architect | DBA.
What is Dinesh Ram Rajan's email address?
Dinesh Ram Rajan's email address is di****@****ail.com
What schools did Dinesh Ram Rajan attend?
Dinesh Ram Rajan attended Shanmugha Arts, Science, Technology And Research Academy.
What are some of Dinesh Ram Rajan's interests?
Dinesh Ram Rajan has interest in Technology, Sports, Environment, Civil Rights And Social Action.
What skills is Dinesh Ram Rajan known for?
Dinesh Ram Rajan has skills like Teradata, Informatica, Etl, Data Warehousing, Unix Shell Scripting, Solution Architecture, Data Warehouse Architecture, Data Migration, Sdlc, Unix, Requirements Analysis, Data Marts.
Free Chrome Extension
Find emails, phones & company data instantly
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial