Summary
Overview
Work History
Education
Skills
Certification
Internship
Timeline
Generic

Venkata Satya Ramgopal J

Hyderabad

Summary

Computer Science Engineer with 9 years of experience in working knowledge with SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) Possess a B. Tech in Computer Science Engineering from KL University. Seeking to pursue a challenging career in a leading and progressive Information Technology organization offering opportunities.

Overview

10
10
years of professional experience
1
1
Certification

Work History

Packaged App Development Team Lead

Accenture
12.2019 - Current
  • Designed SSIS packages to load data from different sources Text files, Excel,
    Oracle, DB2 to staging and staging to Data warehouse.
  • Worked on Bank of America Project for remediating non permitted technologies for successful decommissioning of legacy systems with SQL server
  • Worked on various SSIS Packages Data Transformation to get data from files, database platform to another
  • Good Knowledge on Storage accounts and account management on azure subscriptions
  • Deployed SSIS ETL Project in Azure SQL Server using Lift and Shift
    operation in Azure cloud and Executing from Azure Data Factory and same automated for daily run.
  • Worked on different Activities like, Copy Data, Data Flow, Get metadata, if, for
    each, lookup, etc in Azure Data Factory.
  • Used different Sources and Destination like Azure SQL (Azure SQL Database,
    Azure SQL Managed Instance, Azure Data Lake Gen1, Gen2, Azure Storages
    (BLOB Containers Files Share and Tables), Dedicated SQL DWH and OnPremises SQL Server various sources such as SQL Server, Azure SQL DB, SQL Server Analysis Services (Tabular Model), MS Excel etc.,
  • Developed profit analysis reports and dashboards by products and customers
  • Used different activities like Copy activity, Execute Pipeline, Get Metadata, If
    Condition, Lookup, Set Variable, Filter, For Each, Web, SSIS Execute pipeline
    Activities for On cloud ETL processing.
  • Good experience with different types of Triggers in Azure Data Factory to automate existing developed pipeline
  • Design, implement and maintain database objects (tables, views, indexes, ) and database security
  • Scheduled jobs using autosys
  • Strengthened communication skills through regular interactions with others.

Software Engineer

HCL Technologies
08.2016 - 11.2019
  • Worked as MSBI developer for UBS application called MARS
  • MARS is new strategic Reporting platform with improved reporting capabilities of Market risk data and also provide solution to support regulatory reporting initiative and self- service dashboards
  • Involved in all phased of project development like customer requirements, design development, Application Unit testing, bug fixing, T-sql, ssas deployment and sql server agent job creation
  • Developed OLAP cube and performed detailed analysis by defining data sources views, perspective and partitions
  • Excellent in creating indexes for database optimization and performance
  • Experienced in creating OLAP cubes defining dimensions and relationship between dimensions and measure groups
  • Enhancement and creation of ETL packages and addition of attributes to cubes
  • Involved in release management activities, creating change requests and follow up support teams
  • Worked with end users/customers to understand business requirements
  • Deployment of Package, Creation and scheduling of SQL Jobs
  • Involved in development and deployment of SSIS packages with Business Intelligence Development Studio and hands on with SQL server stored procedures
  • Maintaining Infrastructure and Release Management for project
  • Involved SSAS Cube development as per business requirement
  • Involved in designing numerous DB object like tables constraints (Primary key, Foreign key and Unique)
  • Excellent communication skills bridging client interaction and with team
  • Development of ETL package to load data into flat files,CSV files and archiving files
  • Developed ETL for Tabular cube processing and fact staging from oracle source
  • Resolving support issues and change requests
  • Worked on creating of partitions in cube using C#
  • Involved in setting up new infrastructure for olap cubes and with knowledge on memory Configurations
  • Worked on GIT branching for releases and have knowledge on GIT bash commands
  • Knowledge in Power BI reports and worked on live connectivity cube for reporting
  • Responsible for production release checks and supporting L2 team during release time
  • Extensive ETL experience on sourcing data from using oracle attunity source driver And dynamically get results from query
  • Hands on experience on calculated measures
  • Hands of experience in creating Jobs, Alerts, SQL Mail Agent, Database Mail and Scheduled DTS and SSIS Packages.

Software Engineer

HCL Technologies
11.2014 - 07.2016
  • Worked for Deutsche Bank Application called SPIDER
  • Spiderweb is application used by he non-us entities of TSS
  • This application is used to record, and process transaction related to various debt securities, Medium Term Notes and Euro Commercial Paper where TSS’s role is primarily issuing/principal paying agent.

Education

B.Tech in Computer Science Engineering -

KL University
Guntur
04.2014

Skills

  • MSBI- SQL SERVER INTEGRATION SERVICES ,SQL SERVER ANALYSIS SERVICES, SQL SERVER,Azure Data factory

Certification

Microsoft Certified Azure Fundamentals AZ 900

Internship

Intern, Wipro, Hyderabad, India, UBS, Valuation and Risk of Corporate Bonds, Dec 2013 – May 2014, 



Done my final year internship on “Valuation and Risk of Corporate Bonds”in Investment Banking domain at “Wipro Technologies”, Hyderabad for 6 months to complete academic requirements of my graduation., This application is developed using Java Swing as front end and MS Access 2010 as backend. Using this application, users can compute PV (Present Value) and Interest Rate Risk associated with Corporate Bonds. The inputs to the calculation are Bond parameters like Bond Issuer Details, Coupon, Maturity and Market Data like Yield Curve (Interest Rates vs Time Bucket). Using this application, users can save Yield Curve in the database, enter Bond details and compute Present Value. Users can also compute Risk Scenarios like what is the change in the Present Value of the Bond, if Interest Rates (Yield Curve) moved by 1bp, 10bp, 50bp and 100bop.

Timeline

Packaged App Development Team Lead

Accenture
12.2019 - Current

Software Engineer

HCL Technologies
08.2016 - 11.2019

Software Engineer

HCL Technologies
11.2014 - 07.2016

B.Tech in Computer Science Engineering -

KL University

Similar Profiles

CREATE PROFILE
Venkata Satya Ramgopal J