Project Management Support Engineer
Resume:
Anand Chandrasekaran
Summary:
Extensive experience working as a Production support engineer and technical SME in Banking environment and experience in Project management with a background in Database and Data warehousing. Experienced in people management, application development, support and maintenance, client management and execution of software projects.
Employment History:
Technical SME and Project Manager, Wipro Technologies Ltd, Project: Eworkforce Management 1/22 - Till date
Manage program delivery per the plan by working with project team members to
estimate, plan and deliver projects.
Customer and Wipro internal stake holder management
Responsible for CSAT(customer satisfaction), Customer & Wipro internal Stake Holder
Management, On time delivery, Quality of Deliverables, Overall Program governance and
Team management.
Develop close working relationships with senior level customers.
Manage decisions - manage day-to-day decisions on a project and evaluate decisions
with significant impact on project outcomes.
Monthly, weekly and daily reporting to customer and internal stake holders
Program level communication management, risk management and mitigating it by
seeking help and planning.
Worked extensively as level 3 application support.
Responsible for maintenance of the project and involved in 24/7
Timely Estimation for change requests.
Flexibility to work on project issues as per requirement of the project.
Planning, allocation and monitoring of all HP Open view tickets on time wherever
applicable Monitoring Support mail box.
Worked in various Ad-hoc request and tickets.
Timely Response to customer requests and correctly setting up customer expectations.
Problem solving, ability to work out solutions independently. Guide the team members to
resolve complex issues and ensure resolution of the issues.
Thoroughness of application knowledge, error handling, effective prioritization of tasks,
completeness of tasks performed.
Followed the Development process starting from Requirements Gathering till the Unit
Testing. Involved in the QA Support.
Involved in DR event and Application upgrades.
Snowflake and AWS, Wipro Technologies Ltd, Project: Financial Crime, 8/20 – 12/21
Experience in working in different areas of RDBMS.
Experience in working with AWS S3, data pipelines and Snowflake.
Experience in bulk loading and unloading data into Snowflake tables using COPY command.
Experience in writing complex SQL scripts using Statistical Aggregate functions and Analytical functions to support ETL in snowflake cloud data warehouse.
Working with large data sets like JSON, ORC, PARQUET CSV files from various sources like AWS,
S3.
Expertise on joins, analytical functions for building complex sql queries.
Having good experience in creating views, materialized view for reporting.
Working with our support team to help diagnose and solve problems.
Proficient in SQL Performance tuning. Good exposure on databases like Oracle.
Good communication and interpersonal skills and Strong understanding of ETL best practices.
Ability to work independently and as a team with a sense of responsibility, dedication, commitment and with an urge of learning new technologies.
SQL Support, Wipro Technologies, 09/11 – 6/20
Worked extensively as level 3 application support.
Responsible for maintenance of the project and involved in 24/7.
Timely Estimation for change requests.
Flexibility to work on project issues as per requirement of the project.
Planning, allocation and monitoring of all HP Open view tickets on time wherever applicable Monitoring Support mail box.
Worked in various Ad-hoc request and tickets.
Analysing and evaluating data sources, data volume, and business rules.
Automation, job scheduling, dependencies, monitoring.
Extraction, transformation and load of data using the ETL tools.
Configure/Script Business rules and transformation rules in Informatica.
Design, development of Reports and dashboards.
Understanding the data model, designing the model for EDW, mapping the data and running the ETL jobs.
Ensure appropriate level of Unit Test and System Test of all the deliverables
Defect fixes for System Test, Operational Acceptance Test and Production Preparing status report and discuss with Business and Technical lead in daily status call.
Creating Document related to Designs, Technical Specifications & Unit testing.
Pl/sql Developer, Hexaware Technologies, 01/08 – 05/11
Worked extensively as Pl/SQL developer.
Delivered CR’ independently and have done unit testing for required CR’s and
Prepare quality deliverables.
Estimated the time and effort required to complete developmental tasks.
Responsible for development and maintenance of the project.
24 x 7 Production Support for all the production Jobs.
Responsible for the maintenance of the coding and fixes the bugs.
Worked in various Ad-hoc request and tickets.
Worked on PL/SQL Packages Procedures and Functions for Back End Processes.
Interacted with client to get the requirements for all agencies: NY, NJ, SC, MD, BATA and DRBAY.
Followed the Development process starting from Requirements Gathering till the Unit Testing. Involved in the QA Support.
Wrote and maintained stored procedures for the system.
Involved in BATA VT development and got appreciation from client.
Involved in ATCAS II development.
Took part in major releases and successful implementations. Primarily, BATA (Bay Area Toll Authority) 3.x releases, BATA HOT Lanes Implementation, New Jersey EZPass 2.x major releases, New Jersey EZPass and TSC PCI Implementation, and New Jersey RDB Upgrade.
Contact Details
ad5wxu@r.postjobfree.com
Experience Summary
Wipro Technologies Ltd
(Jun-2011 to till date)
Hexaware Technologies Ltd
(Sep-2007 to Jun-2011)
Technical Skills
Snowflake
SQL
ETL, Informatica Power Centre
Azure Data Factory, Data bricks
Unix SNOWITIL
AWS
Certifications
Snowpro Core Certificate
AWS - Solutions Architect
Education
B.E. E&I,
Kongu Engineering College, India (2003- 2007)
Areas of Interest
Cloud Environment Data warehousing Project Management
Domain Knowledge
Banking
Transportation
Contact this candidate