Ramesh Chinnasamy

About Ramesh Chinnasamy

Over 15 years of experience as an analytical Senior SQL Developer and SSIS ETL…

Experience

1. Lead Software Engineer

   Wells Fargo

   Mar 2020 — Present · Charlotte, NC, US

   The project involves developing a BI solution for strategic analysis by global equities, Funds, Options.Responsibilities:• Provide ongoing performance monitoring and tuning, and automation of production activities related to Data Warehouse, ETL and BI environment• Creating SSIS ETL Packages to load flat file data sources into SQL Server Database. • Works within project team to lead iterative development that delivers a high quality product• Create and maintain detailed documentation for the development and production teams• Supporting the business and technical professionals in process improvement, technical designs, and quality assurance.• Building the Global Aggregation Database application reporting structures using SSIS, TSQL and SQL server.• Designing report with SSRS. • Creating business reports and helping users to create their own reports.• Writes technical specification documents and business requirements documents needed to build and support the data warehouse environment and the applications.• Writing high-level test plans and test cases based on the baseline requirements.

Education

• Little Flower Higher Secondary School, Annamangalam

  HSc, Science

  1991 — 1998

• University of Madras

  Bachelor of Engineering, Computer Science & Engineering

  1998 — 2002

Skills

• Business Intelligence
• Data Migration
• Databases
• Business Objects
• Oracle
• Requirements Analysis
• Data Integration
• Requirements Gathering
• Data Modeling
• Testing
• Informatica
• Db2
• Software Testing
• Microsoft Sql Server
• Sdlc
• Solution Architecture
• Sql
• Software Development Life Cycle (Sdlc)
• Etl
• Pl/Sql
• Software Project Management
• Sap Businessobjects
• Data Warehousing