Oracle 9i
Hi, I’m
VADIVELAN SHANMUGACHARI
Delivery Module Lead
Chennai,Tamil Nadu
Summary
A senior SQL Developer with around 14 years of overall IT experience. Thorough SQL Developer with around 11 years of relevant experience in Microsoft SQL Server databases with expert grasp of SQL code generation, analytics, reporting and business intelligence. Conversant in up-to-date and legacy programming languages, standards and tools. Critical thinker, analyst and problem solver known for continuous delivery of quality products across diverse business environments.
Overview
12
years of professional experience
5
years of post-secondary education
9
Certificates
2
Languages
Work History
Tata Consultancy ServicesChennai
Senior SQL Developer
04.2011 - Current
Job overview
- Devised high-quality database solutions ranging in size and complexity, increasing productivity and improving data sharing.
- Created optimal technical solutions to user needs through research and in-depth system analysis.
- Analyzed existing SQL queries to identify opportunities for improvements.
- Extracted and transformed multi-source data, incorporating assets into unified databases while monitoring integration and replication performance.
- Managed workload independently but collaborated with colleagues to complete larger scale tasks in distributed team environment.
- Designed and implemented TSQL queries for reporting and complex solution development.
- Maintained complex T-SQL queries, views and stored procedures in multi-database environment with little supervision.
- Built useful reporting deliverables to properly document analysis results and provide performance improvement feedback.
- Developed, implemented and optimized stored procedures and functions using T-SQL.
- Designed and developed customized extract, transform and load (ETL) applications per client specifications.
- Improved application performance by determining root cause of issues and resolving.
PharmARC Analytics Solutions LimitedWolsters KluweBengaluru, KA
Senior Business Analyst
11.2010 - 04.2011
Job overview
- Wrote SQL code to pull data from WKPS data warehouse for custom analytics of drugs, patients or physician demographics information for various pharmaceutical clients such as Pfizer, Glaxo, Sanofi, etc.
- Graphical representation of analytics data in the form of Bar Charts, Pie Charts, etc and by SAS data sets if data doesn’t fit in spreadsheets.
Education
Jaya Engineering CollegeChennai
Master of Computer Applications from Computer And Information Sciences
08.2003 - 04.2006
Jaya Arts & Science CollegeArakkonam
Bachelor of Computer Applications from Computer And Information Sciences
08.2000 - 04.2003
Skills
T-SQL coding
Accomplishments
- 9840046141
- Base Country:India
- Base Branch:TCS - Chennai
- Depute Country:India
- Depute Branch:TCS - Chennai
- Experience Summary
- Total Experience:13.46 Years, 6
- Resume Tata Consultancy Services
- Education & Learning
- Education
- Competency
- Achievements1
- Worked with team to develop the SQL code to load data from source to ODS which involvesmanual processes during initial phase of the project
- 2
- Involved in automation of manual processes of loading by implementing an AutoETL project
- 3
- Testing and maintenance of AutoETL project by debugging the DB2 & Oracle SQL queriesand format files essential for development
- 4
- Involved in development and deployment of mirroring project which replicates the DB2 or
- Oracle data into ODS environment
- 5
- Single handedly involved in multiple sourcing projects which was successfully deployed inproduction
- 6
- Involved in writing the AutoETL and Development process document which was appreciatedby client
- Qualification Subject Percentage/Grade
- BACHELOR OF COMPUTER, Digital : NOSQL E0 Data Platforms Modern Data Platforms
- Digital : Amazon Web Service(AWS)
- Cloud Computing
- E0 Cloud Computing Cloud Application Services
- Initiative / Proactiveness L1 Results Mindset Execution Excellence
- Digital : Cassandra E0 Data Platforms Modern Data Platforms
- Digital : Microsoft Azure E0 Cloud Computing Cloud Application Services
- Digital : Web Modernization Concepts E0 Web Technologies Web Development
- IT IS_SM_Service Operations E0 Enterprise Service
- Management
- IT Service Management
- Manufacturing - Environment Health &
- Safety
- E0 Manufacturing Environment Health &
- Safety
- Growth and Transformation Concepts &
- Practices
- E0 Enterprise Methodologies Growth and
- Transformation
- Diversity Management L1 Relationship Mindset Interpersonal Effectiveness
- Service Management E0 Enterprise Service
- Management
- IT Service Management
- Digital : BigData and Hadoop Ecosystems E0 Data Platforms Modern Data Platforms
- Digital : BI-Fundamentals of Business
- Analytics using R Programming
- E0 Data Analytics & Insights Business Intelligence
- SQL Server Integration Services 2005(SSIS)
- E1 Data Platforms Data Warehouse
- Digital : BigData and Hadoop Ecosystems E0 Data Platforms Modern Data Platforms
- SQL Server 2008 Development E0 Data Platforms Database Design &
- Development
- Page: 7
- Resume Tata Consultancy Services
- Certification
- Training
- BFS - Investments E1 Banking & Financial
- Services
- Financial Markets
- Foundation : Microsoft SQL Server 2016 E0 Data Platforms Database Administration &
- Management
- BPS : Capital Markets Global Wealth
- Management - Private banking & Wealth
- Structuring
- E1 Banking & Financial
- Services
- Capital Markets
- Digital : Node.js E0 Web Technologies Modern Web Development
- Digital : BFS - Digital Banking E0 Digital Foundation Digital Foundation
- Process : Intellectual Property Rights E0 Enterprise Compliance Mgt Intellectual Property
- Agile Way of Working E1 Enterprise Methodologies Agile
- Innovation & Creativity L1 Customer Centric Mindset Stakeholder Engagement
- Customer Orientation L1 Customer Centric Mindset Stakeholder Engagement
- Software Estimation E0 Enterprise Quality
- Management
- Standard Estimation
- Frameworks
- Digital : Blockchain E0 Blockchain Blockchain Technology
- RiO : Rigor in Operations E0 Enterprise Delivery
- Management
- Rigor in Operations
- SQL Server 2008 Development E2 Data Platforms Database Design &
- Development
- Compliance : Data Privacy E0 Enterprise Compliance Mgt Data Privacy
- BPS : Customer Focus L0 BPS - Behavioral BPS - Behavioral Results
- Process : Lean E0 Enterprise Quality
- Management
- Performance Improvement
- Process Improvement (PI) E0 Enterprise Quality
- Management
- Performance Improvement
- Process : Agile Delivery E0 Enterprise Methodologies Agile
- Cyber Security - Information Security
- Concepts
- E0 Cyber Security Infra & Data Security
- Management
- Digital : HBase E0 Data Platforms Modern Data Platforms
- Certification Name Aquired On Expired On Version
- Growth & Transformation : Awareness E0 Proficiency 11-Feb-2022 1.0
- Process : ITIL Foundation Certification 15-Dec-2017 1.0
- Digital : Web Modernization-BFS Foundation 19-Apr-2017 1.0
- BPS : Environment Health & Safety_Foundation 18-Feb-2020 1.0
- Digital : Big Data and Hadoop-BFS Foundation 25-Jan-2017 1.0
- Digital : Cassandra_Foundation 09-Dec-2016 1.0
- Architecture & Tools : Technical Architect - Behavioral 26-Jan-2017 1.0
- BDA : Certificate in Wealth Management 03-Jan-2019 1
- Foundation : Microsoft SQL Server 2016 Foundation 13-Jan-2019 1.0
- Offering Name Actual
- Duration (In
- Mins)
- Start Date End Date
- Elevate Runway MLT Awareness-Elevate Runway MLT Awareness-
- Elevate Runway MLT Awareness course
Certification
APPLICATION
Additional Information
- Methods Agile and Waterfall Lifecycle model. Domain Banking, Wealth Management and Healthcare. Award Name Award Date Award Category Award SubCategory Service & Commitment Award 27-Apr-2021 Service Awards Service Award Fresco Play Miles 15-Mar-2019 Learning Awards Fresco Play Award (S)miles Award 11-Feb-2019 Beyond Performance Awards Beyond Performance Fresco Play Miles Award 03-Jan-2019 Learning Awards Fresco Play Award Service & Commitment Award 27-Apr-2016 Service Awards Service Award (S)miles 06-May-2015 Beyond Performance Awards Beyond Performance Service & Commitment Award 27-Apr-2014 Service Awards Service Award On The Spot Award 21-Oct-2013 Awards for Excellence On The Spot Awards Passport Number Place of Issue Date of Issue Expiry Date
Software
Netezza
Big Data
Python
Interests
Books reading
Listening to podcast
Watching informational videos
Timeline
Senior SQL Developer
Tata Consultancy Services
04.2011 - Current
Senior Business Analyst
PharmARC Analytics Solutions LimitedWolsters Kluwe
11.2010 - 04.2011
Jaya Engineering College
Master of Computer Applications from Computer And Information Sciences
08.2003 - 04.2006
Jaya Arts & Science College
Bachelor of Computer Applications from Computer And Information Sciences
08.2000 - 04.2003
Similar Profiles
Vrunda ChindhadeVrunda Chindhade
HR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services LimitedHR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services Limited
Sreya BasuSreya Basu
Procare Analyst at Tata Steel(Tata Consultancy Services)Procare Analyst at Tata Steel(Tata Consultancy Services)
Arun VArun V
Program Manager at Tata consultancy services | Financial Ombudsman ServicesProgram Manager at Tata consultancy services | Financial Ombudsman Services
Naimish AgnihotriNaimish Agnihotri
Assistant Delivery Manager at Tata Consultancy Services, Global Shared ServicesAssistant Delivery Manager at Tata Consultancy Services, Global Shared Services
John Sundar RajJohn Sundar Raj
QA Manager at Synaptris Software Pvt. Ltd.QA Manager at Synaptris Software Pvt. Ltd.