AMARESWARI VEMURU
Texas City,TX
Summary
Responsive expert experienced in monitoring database performance, troubleshooting issues and optimizing database environments. Possesses strong analytical skills, excellent problem-solving abilities, and a deep understanding of database technologies and Cloud Engineer with 8 years of experience. Equally confident working independently and collaboratively as needed and utilizing excellent communication skills. Hardworking, highly motivated professional eager to lend combined knowledge and skills to enhance business performance. Operates well in both individual and team capacities, leveraging seasoned work ethic to quickly adapt to different processes and drive company objectives. Resourceful and results-driven with a passion for growth and efficiency to meet company needs and increase service value.
Overview
18
18
years of professional experience
Work History
SENIOR DATA ANALYST
Adobe
10.2019 - Current
- With Employer: CovetIT INC as a Cloud Engineer Continuous Integration, Continuous Deployment and Cloud Implementations
- Expertise in Microsoft Azure Cloud Services ( PaaS & IaaS )
- Developed methodologies for cloud migration, implemented best practices and helped to develop backup and recovery techniques for applications and databases on a virtualization platform
- Expertise in the Design and Development of Interfaces, User Controls and Custom Controls programming using ASP.NET and C#
- Experience in handling various backend data sources like MS SQL Server 2000/2005/2008,2012
- Diverse experience in all phases of the software development life cycle (SDLC) especially in the Analysis, Design, Development, Testing and Deploying of applications
- Manage and Create a Storage Account in Azure Portal
- Code reviews GitHub merge and code handling with team members to distribute work
- Coordinating with Stakeholders to Handle and resolve Clients' Issues immediately
- Worked on GIT to maintain source code in Git and GitHub repositories
- Understand the latest features like (Azure DevOps) introduced by Microsoft Azure and utilise it for existing business applications
- Developed conversion and system implementation plans
- Developed a Cloud-based reporting system for the teams
- Azure Unstructured Data storing in Storage accounts
- Datafactory Trigger with secret codes (keys)
- Azure DataBricks uses Clusters, and Utils like .data,.fs, and .notepad to execute and test the data
- Technologies Used: Azure Dev-ops, Azure SQL Data Warehouse
- Azure Data Factory, BOB storage accounts, Azure Data bricks, MS SQL Server, python, azure GitHub, MS SQL Server, Tidal tools and SQL server 2008 R2,2012, Microsoft Business Intelligence Development Studio (MSBI)
- SSIS, SSRS, SSAS].
DATA ANALYST
ATHENA TECHNOLOGY SOLUTIONS
02.2017 - 07.2019
- Project: MES (Manufacturing Execution system)
- Clients: [Lumentum Optical products manufacturer, Location: Milpitas, CA] Miasole, A Hanergy Company, Location: Santa Clara, CA] Raxium, Semiconductor manufacturer Company, Location: Fremont, CA, US]
- Utilized data visualization tools to effectively communicate business insights
- Participated in requirements meetings to understand business needs
- Extracted and interpreted data patterns to translate findings into actionable outcomes
- Tested data prediction algorithms based on historical data
- Analyzed transactions to build logical business intelligence models for real-time reporting needs
- Create an analysis report identifying issues within the departments and the systems
- Designed and implemented tools to support strategic value chain optimization initiatives.
SENIOR SOFTWARE CONSULTANT
EPAM INDIA PVT LTD (FORMALLY KNOWN AS AGS)
05.2013 - 08.2016
- Location: AHM (Advanced Health Media)
- Clients: AstraZeneca Canada, AstraZeneca US, Pfizer, Teva, Jazz, Gilead, Novo Nordisk, Merck
- Prioritized projects and project tasks depending on key milestones and deadline dates with Agile methodologies
- Developed custom solutions based on the client's strict requirements
- Identified business issues through careful collaboration with key stakeholders
- Troubleshoot issues by understanding issues, diagnosing root causes and developing effective solutions
- Monitored and managed staff performance to attain target metrics both individually and in team units
- Experience in programming and experience with prod problems diagnosis and resolutions in (SQL/ADO).
SENIOR SOFTWARE CONSULTANT
EPAM INDIA PVT LTD
08.2011 - 05.2013
- Project: MDX (Master Data Management)
- Clients: 3M, OTSUKA (USA Clients)
- Provided technical support using knowledge of complex technology to solve problems and support new projects
- Designed intuitive graphical user interfaces to improve user experience
- Worked closely with clients to establish specifications and system designs
- Programming n number of Stored procedures, retrieved and manipulated data for close analysis of database performance
- Performance tunning and problem-solving with minimal supervision.
SOFTWARE CONSULTANT
EXCELLENCE DATA RESEARCH PVT LTD
11.2006 - 07.2011
- Different Modules worked are as follows: Company Strategy
- SWOT Reports, Company Cleantech Project for Sustainable Technologies Investment Market Profiler (STIMP); Company List Builder for ICT (Information and Communication Technology); Company Profile Reports
- Global Entity System Data Monitor Financial Deal Authoring Tool
- Clients: Informa, Data Monitor, NASDAQ, Thomas Cook Reports, Dow Jones, NASDAQ, Thomas Cook
- Aided in software programming implementation for clients in the Financial industry, providing setup and Programming in SSIS Reports
- Sql server programming for the cleaning process
- Executed program modifications and changes and documented results of software research tools and applications and deployments to larger teams on migration
- Prepared system diagrams and flow charts to support problem analysis
- Developed complex solutions to all business problems along with customer engagements by detailed analysis, negotiation and coordination with main decision makers
- Testing and deploying the application singly maintain the large volume of data migrations
- Agile methodologies to take all reporting and managing High-priority tickets for deployment E2E.
SOFTWARE ENGINEER
CALIBER TECHNOLOGIES PVT LTD
08.2005 - 11.2006
- Project: Caliber LIMS (Laboratory Information Management Systems)
- CLIENTS: All Healthcare & Pharmaceutical clients From India
- Worked with software development and testing team members to design and develop robust solutions to meet client requirements for functionality, scalability, and performance
- End-to-end system Waterfall model development Programming in SQL server,.net, C#, Bug fixes, Testing, Deployment
- Updated old code bases to modern development standards, improving function.
Education
Master of Science - MASTER OF COMPUTER APPLICATIONS
Andhra University
05.2005
Bachelor of Science - BACHELOR OF COMPUTER APPLICATIONS
Andhra University
05.2002
Skills
- SQL Expertise,SQL and Databases :T-SQL, PL/SQL,MSSQL Server 2016/2014/2012/2008 R2, Oracle 12c, MS Access, Microsoft Azure SQL
- Windows, SQL, SSIS, SSRS, SSAS, Azure
- Microsoft Power BI, SQL Server Reporting Services, Crystal Reports, Excel
- Risk Assessment
- Systems Analysis
- Data Modeling
- KPI Tracking
- Workflow Analysis
Accomplishments
- Customer Appreciation Award winning in both 2019&2020
- Star award for the year 2018 in Athena Technologies
- AHM CIO was given special appreciation
- Received a “Pat on the Back” from client AHM in EPAM in 2014
Timeline
SENIOR DATA ANALYST
Adobe
10.2019 - Current
DATA ANALYST
ATHENA TECHNOLOGY SOLUTIONS
02.2017 - 07.2019
SENIOR SOFTWARE CONSULTANT
EPAM INDIA PVT LTD (FORMALLY KNOWN AS AGS)
05.2013 - 08.2016
SENIOR SOFTWARE CONSULTANT
EPAM INDIA PVT LTD
08.2011 - 05.2013
SOFTWARE CONSULTANT
EXCELLENCE DATA RESEARCH PVT LTD
11.2006 - 07.2011
SOFTWARE ENGINEER
CALIBER TECHNOLOGIES PVT LTD
08.2005 - 11.2006
Master of Science - MASTER OF COMPUTER APPLICATIONS
Andhra University
Bachelor of Science - BACHELOR OF COMPUTER APPLICATIONS
Andhra University