PROFESSIONAL EXPERIENCE

Aluru Venkata Rama Manoj

Senior Development Engineer

Pramati Technologies

Mobile: +91-967*******

Email: adhchg@r.postjobfree.com

Experience: 6+ yrs.

PROFESSIONAL SUMMARY

• 6+ Years of relevant experience in the IT industry as MS SQL, Tableau and SSIS Developer.

• Work experience in 24x7 Production environments.

• Strong knowledge of Database management concepts and good programming skills in MS SQL Server (DDL, DML, DCL and T-SQL).

• Extensively used ETL methodologies for supporting data extraction, transformations and loading processing using SSIS.

• Excellent analytical, problem solving, code debugging and business interaction skills.

• Experience in writing database objects (Stored Procedures, Functions, and Triggers).

• Knowledge on SQL Query tuning.

• Knowledge on Data warehousing concepts (Dimensions / Facts).

• Knowledge on Columnar Database Redshift and enterprise level NOSQL database Mark Logic.

• Experience of working on reporting tools like Tableau, Power BI.

• Hands on experience on API calls using Python.

• Worked as Junior Software Engineer at Inrhythm Solutions Jun-2014 to Oct-2016

• Worked as Senior Software Engineer at GGK Technologies Nov-2016 to May-2018.

• Working as Senior Development Engineer at Pramati Technologies Since May-2018. TECHNICAL EXPERTISE

Databases: SQL SERVER 2008R2, 2014, 2017 and 2019. ETL Tools: SQL Server Integration Services (SSIS), ADF. Reporting Tools: Tableau, Power BI

Operating Platforms: Windows XP and above

IDE Tools: SQL Server Management Studio, BIDS, SSDT. Others: Azure Blob, Azure Data Lake, MS-Excel, TFS, GIT, Jira, Confluence, Azure Boards. WORK EXPERIENCE

Project 8: Accelerator Data Platform

Role: ADF, Azure Blob, SQL Server 2019

Duration: Since Jun-2019

Client: Hyperion

Team Size: 5

Description: Onboarding new data sources and Analyze its contribution to Organization. We onboard different data sources which were belonging across the world reporting to an Insurance company. Cleanse the data and check its contribution to the company. Responsibilities: Analyzing/Understanding the forms of data, database development and Pipeline Integration.

Project 7: Accelerator

Role: SSIS, SQL, Tableau Developer

Duration: May-2018 to Jun-2019

Client: Hyperion

Team Size: 15

Description: Onboarding new data sources and Analyze its contribution to Organization. We onboard different data sources which were belonging across the world reporting to an Insurance company. Cleanse the data and check its contribution to the company. Responsibilities: Analyzing/Understanding the forms of data, database development and Integration.

Project 6: Media Data Analyst of Techstyle

Role: Python, Tableau, SQL, SSIS Developer

Duration: Jan-2018 to May-2018

Client: Techstyle / JustFab

Team Size: 15

Description: Analyze the media growth of media customers that flow into JustFab We read the spends that Justfab made on different social networking portals and analyze the profit made by the respective portals on basis of CPA/CPL. Responsibilities: Analyzing/Understanding the forms of data, API calls using python, database development and Tableau reporting.

Project 5: POC on MarkLogic

Role: MarkLogic Developer

Duration: Aug-2017 to Dec-2017

Client: HRMS (Internal)

Team Size: 3

Description: Understanding the capabilities of MarkLogic. This project was done in order to assist HRMS, where different Resumes were loaded into the system and depending on criteria the respective resume were filtered. This is helpful for listing the resumes with the selected criteria.

Responsibilities: MarkLogic Development.

Project 4: Reporting for Ruffalo

Role: SQL, SSIS and Tableau Developer

Duration: Mar-2017 to July-2017

Client: Ruffalo Noel Levitz

Team Size: 3

Description: Reporting of data that would be helpful for business. Ruffalo is an American consultancy firm. Which is associated with admissions of various colleges, conducts surveys etc., we designed dashboards using tableau which helps them to understand where they stand and what percentage of market they acquire. Responsibilities: Client interaction for requirement gathering, Analyzing the requirements, Redshift SQL development and Report development using Tableau. Project 3: BRG Survey data reporting

Role: SQL and Tableau Developer

Duration: Dec-2016 to Jan-2017

Client: Barclays research group

Team Size: 5

Description: Reporting of data submitted through various surveys. BRG conducts various surveys of different formats. This will have different formats of data. Files of those formats will be processed through user interface. Such data was analyzed and reported. Responsibilities: Analyzing, SQL development and Report development using Tableau. Project 2: Data Reporting for AMA

Role: SQL server and Power BI developer

Duration: Nov-2016 to Dec-2016

Client: American Medical Association

Team Size: 3

Description: Reporting of data received by doctors under American Medical Association. AMA gets data from various doctors who were registered with it. Data is stored into a Document database called Mark Logic. Application deals with creating views on Mark Logic and retrieving data from it and dumping it into SQL Server. After processing the data reports were built on top of those data. Responsibilities: SQL development and Report development using Power BI. Project 1: POS SCAN Data

Role: SSIS, VB.Net, SQL Developer

Duration: Jun-2014 to Nov-2016

Client: Altria

Team Size: 15

Description: Analytics of data at a Customer/Retail Transaction level. Application deals with Scan data of Cigarettes generated at store level. Which receives data

(Products/Stores/Sales) from different chains and from Client we receive Mater Products/Stores. We developed a tool which matches Master product/store with chain product/store. If match was not appropriate, then such products undergo manual intervention. After the process a report will be sent to client stating whether product was sold at profit/loss or how business can be improved. Responsibilities: Requirement gathering, Analyzing, SQL development, show casing data in UI and testing the application.

PERSONAL PROFILE

Date of Birth : 26-06-1993

Marital Status : Single

Linguistic Ability : English, Hindi, Telugu.

Hobbies : Dancing, Listening to Music

Contact this candidate