Summary
Overview
Work History
Education
Skills
Timeline
Generic

AMARESWARI VEMURU

Princeton,TX

Summary

Having 10+ years of Professional experience as a Power BI Developer working on SQL server, Business Intelligence tools, Database Design, Data Modeling and Data warehousing projects. Worked extensively on SQL server management studio, SQL server 2017/2016 /2014/ 2012/ 2008R2 and BI tools such as SSIS, SSRS, SSAS, Power BI and tabular data modeling including MS solutions like MS EXCEL., DB2, and MS Access Database.

Overview

18
18
years of professional experience

Work History

Professional Achievements

Awards
08.2005 - 09.2023
  • Customer appreciation Award winning in both 2019&2020.
  • Star award for the year 2018 in Athena Technologies.
  • AHM CIO given special appreciation.
  • Received a “Pat on Back” from client AHM in EPAM in 2014.
  • Received a “Valued member of the Data Monitor” in 2010&2009.
  • Data Monitor nominated my creative team representation in “BOOST Your TEAM”.
  • ADOBE Level 4 appreciations on improved Data performance on critical project across multiple tracks.

SENIOR DATA ENGINEER

Covet IT INC
10.2019 - Current
  • Project: Implement and Adopt team for ADOBE.
  • Clients Location: - Adobe Headquarters, San Jose, USA(Hybrid)
  • Technologies Used
  • PowerBI; Jenkins, snap logic, GitHub, MS SQL Server, Perforce, Tidal tools and SQL server 2008 R2,2012, Microsoft Business Intelligence Development Studio (MSBI). [SSIS, SSRS, SSAS]. Azure SQL Data Warehouse. Azure Data factory MS SQL Serve
  • Responsibilities
  • Improved overall decision-making 25% by designing and developing BI reports and providing invaluable insights Implement and Adopt of Enterprise customer journey.
  • Comprehend business requirements in a BI context and developed 15+ data models to convert raw data into actionable insights.
  • Identify 10+ KPIs with outlined objectives and consistently monitor them.
  • Develop 50+ reports by utilizing knowledge of SQL queries, SQL Server Reporting Services (SSRS), and SQL Server Integration Services (SSIS)
  • Collaborated with business users, collected requests, and updated the set of existing BI reports to accommodate business needs.
  • Implemented 3 fully functional data schemes and 10+ data flow optimization processes for reporting performance and enhancements.
  • Generated and delivered quality reports to customers by conducting quality assurance checks and recorded a 65% increase in customer satisfaction.
  • Developed 4 reporting systems that provide accessible information for accurate decision making.
  • Data from Hadoop Views to SQL Server Datasets Using ssis Packages, SSIS Scheduling on Tidal Weekly.
  • Creating the SSAS Tabular Cubes for the Power BI Live Cube Connection.
  • Requirement Gathering analysis with the client and documentation and involved in estimation and planning, development, unit evaluated various Dashboard designs as well as Reports.
  • Engaged as Senior Software Engineer on multiple projects to perform requirement analysis, system/model conceptualization and technical architecture/design documentation.
  • Successfully Delivered the SSAS Tabular Cubes.
  • Writing the Complex SP’s, comfortable in troubleshooting and writing Stored procedure.
  • ETL from EXCEL to SQL DATABASE using SSIS for the Enterprise Targets Loading.
  • Developed Compiles SQL queries using Stored procedures and common table expressions (CTES), Temporary table to support Power BI and SSRS reports.
  • Implemented testing infrastructure and testing tools for the development and deployment of web applications.
  • Works with other team members, including DBA's, Other ETL developers, Technical Architects, QA, Business Analysts & Project Managers
  • Involved in Scrum Planning’s and Scrum meetings on Quality Deliverables.
  • Deploy, configure, maintain compute on Azure cloud.
  • Troubleshoot Azure Related Issues and engage internal teams and vendor for issue resolutions
  • Automate deployment and troubleshoot mechanisms for quick service.
  • Develop and implement new process and document it
  • Migrated data from On-premises to Cloud azure.
  • Working with collaboration tools like Jira and SCRUM as agile methodologies

SENIOR SYSTEM ANALYST

ATHENA TECHNOLOGY SOLUTIONS
02.2016 - 10.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]
  • Responsibilities
  • Involved in Technical discussions and decisions for Business requirements, Interaction with Business Analysts, Client team and Development team.
  • Experienced in database design process and data modeling process.
  • Analyzed the Data quality, Data validating, Data Mapping to migrate data to SQL Server database.
  • Designed SQL Server Database and Table Design with Schemas, Constraints and Views.
  • Extracted data from various sources like DB2, VSAM, SQL Server 2014/2012/2008 R2, .CSV, Microsoft Excel and Text file from Client servers.
  • Analyzed business requirements and implemented data mart solutions for data mining and reporting.
  • Created SSIS packages which involved a variety of transformations such as Slowly Changing Dimension, look up, Aggregate, Derived Column, Conditional Split, Multicast, Union All, Merge, Merge Join, and Data Conversion before loading the data into Data Warehouse.
  • Created a report model on SSAS cubes.
  • Designed the data model based on star schema and created the tables and indexes and developed the scripts to load the data mart tables.
  • Identified issue and developed a procedure for correcting the problem which resulted in the improved quality of critical tables by eliminating the possibility of entering duplicate data in a Data Warehouse.
  • Developed, Code Reviewed, fixed bugs, tested and deployed SSIS packages using SQL Server 2014/2012/2008 R2 Business Intelligence Development Studio.
  • Gathered Report Requirements and designed Reports, Matrix, Table Reports with Drilldowns, Map Reports, Dashboards, Gauge and Subscription reports.
  • Strong knowledge of Data Warehousing methodologies, concepts and implementation of star schemas, snowflakes schemas, facts & dimensions.
  • Developed reports with consistent drill-down functionality including Drilldown report and Summary report.
  • Ensured constraints and writing triggers/linked server scripts to apply the business rules. Performance Tuning, Backing Up & Restoring User Databases.
  • Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.
  • Deployed and Tested (UAT) Reports in Multiuser Environment. Created RS Config Files and Ensure Report Security with Keys.
  • Involved in Installation, Configuration and Deployment of Reports using SSRS with Scale-Out topology.
  • Worked closely with QA team and helped them come up with test scenarios.
  • Part of the Agile/Scrum team and participated in Standup, grooming, planning and retrospective meetings.
  • Technologies Used
  • SQL server 2008 R2,2012, Business Intelligence Development Studio (BIDS). SSIS, SSRS, SSAS. Azure SQL Data Warehouse. Azure Data factory, AZURE Data Lake storage gen2.Power BI, Reporting services (SSRS). MS SQL Server

SENIOR CONSULTANT

EPAM INDIA PVT LTD (FORMALLY KNOWN AS ALLIANCE GLO
05.2013 - 08.2016
  • Location: - AHM (Advanced Health Media) in Norfolk, VA, USA
  • CLIENTS: -AstraZeneca Canada, AstraZeneca US, Pfizer, Teva, Jazz, Gilead, Novo Nordisk, Merck.
  • Responsibilities
  • Drafting & requirements analytical approach to the client’s request in direct client location and working with minimal Supervision in Client SharePoint Portal. Support and maintain Client Architecture from the Implementation phase to code Deployment in Production.
  • Develop and maintain databases for use in data analysis and tracking and migrating SQL SERVER INTEGRATION SERVICES (SSIS) packages to Oracle data warehouse.
  • Managed complete ETL processes for both on-shore and off-shore support.
  • Involved in automation of Inbound and Outbound Feeds W.R.T the client’s data Requests.
  • Extract and transfer and load (ETL Process) Raw HCP’s, Customer, Speaker data Text files from Client to AHM SQL Data warehouse model.
  • Performance improvements and validating SQL Stored procedures used in Front end all reporting tools Troubleshooting issues and providing the client with a technical solution Sending the Data on high priority requests from legal queries arise by US-Government W.R. T the client.
  • Deal with complex Hcp’s sensitive customer client data to load into AHM SQL Data warehouse model on every month. Involved in Data optimization on complex problems.
  • Production Support to handle the designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.
  • Involved in designing, developing and deploying reports in MS SQL Server environment using SSRS-2008 and SSIS in Business Intelligence Development Studio (BIDS).
  • Used SSRS to develop different kinds of reports like canned, ad-hoc reports for the Healthcare clients. Created parameterized reports, drill down and Drill through reports using SSRS.
  • Deployed and uploaded the SSRS reports to SharePoint Server for the end users and involved in enhancements and modifications.
  • Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
  • Extensively used SSIS transformations such as Lookup, derived column, data conversion, aggregate, conditional split, SQL task, script task and Send Mail task etc.
  • Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
  • Created SSRS report model projects in bi studio and created, modified and managed various report models with multiple model objects, source fields and expressions.
  • Designed OLAP cubes with star schema and multiple partitions using SSAS & complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measures groups
  • Created SSAS Cubes for analysis, Handled SharePoint, data mining and OLAP for online analytical processing create cubes using data from data marts / data warehouse for deeper and faster data analysis.
  • Technologies Used
  • Microsoft SQL Server Management Studio 2005 to 2016, TSQL, Microsoft Business Intelligence in SQL Server Reporting Services(SSRS), SQL Server Analysis Services (SSAS) and SQL Server Integration Services (SSIS), DTS, ASP.NET, Jira Tool, SVN, Clarity, Citrix, C#, MS Azure SQL, SQL Agent, Oracle, Mango DB, Tableau Desktop , power BI.

SENIOR SOFTWARE ENGINEER

EPAM INDIA PVT LTD
08.2011 - 05.2013
  • Project: MDX (Master Data Management)
  • Role: Senior Software Consultant (ETL/SQL Developer /Data Warehouse Developer)
  • CLIENTS:3M, OTSUKA (USA Clients)
  • Responsibilities
  • Perform data cleaning, loading, extraction, processing, storage, and manipulation (ETL Process).
  • Support to client in Production Deployments
  • Main core developed and designed SQL SERVER INTEGRATION SERVICES (SSIS) Packages.
  • Involved in automation to for the extracts (ETL Process).
  • Writing scripts to solve the customer queries.
  • Analyze data with statistical methods, customizing existing Reports using Microsoft SQL Server Reporting Services Report Builder to Tableau and salesforce.
  • Changed the SQL SERVER 2000 existing Business required Stored Procedures to Latest advance high performance running Stored Procedures
  • Managed SharePoint, data mining and OLAP for online analytical processing create cubes using data from data marts / data warehouse for deeper and faster data analysis.
  • Involved in Complete Frontend coding using .net, C#, Asp.net.
  • Worked as Database Programmer with the Data Base Developer.
  • Analyzed the requirement and Database schema designing.
  • Wrote stored procedures, functions and triggers and views using SQL Server 2008 R2.
  • Evaluating the Data and giving the error checks to validate the data.
  • From Salesforce to SQL data loading through SAaS Solutions.
  • Created SSRS report model projects in bi studio and created, modified, and managed various report models with multiple model objects, source fields and expressions.
  • Designed OLAP cubes with star schema and multiple partitions using SSAS & complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measures groups, Created SSAS Cubes for analysis, Handled SharePoint, data mining and OLAP for online analytical processing create cubes using data from data marts / data warehouse for deeper and faster data analysis.
  • Technologies Used:
  • SQL Server 2012, 2008, TSQL, SQL SERVER INTEGRATION SERVICES (SSIS), ASP.NET, Jira Tool, SVN, SQL SERVER REPORTING SERVICES (SSRS), SSAS, Clarity, Citrix, Informatica 9.0, MS Azure SQL, SQL Agent, Oracle. MS SQL Server

SOFTWARE ENGINEER,

EXCELLENCE DATA RESEARCH PVT LTD
11.2006 - 07.2011
  • Project: 1:
  • Different Modules worked for 5 years:
  • 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.
  • Clients Informa, Data Monitor, NASDAQ, Thomas Cook Reports.
  • Project: 2: Global Entity System
  • Clients Dow Jones, NASDAQ, Thomas Cook
  • Project: 3: Data Monitor Financial Deal Authoring Tool
  • Responsibilities
  • Maintaining and Enhancement for new requests.
  • Complete 5 years singly maintaining code and enhancements on client Change Requests.
  • Programming in ADO.Net to handle the databases Data to show on Website.
  • Involved in Code Optimization and Performance Tuning of the Stored Procedures Queries.
  • Involved in system defect tracking, bug fixing and maintenance.
  • Wrote complex Standard Financial deal related stored procedures in SQL server 2005.
  • Given new Object-oriented solutions to resolve the Production unresolved site issues.
  • Alone coded the tree representation of Hierarchy Territory display popup windows.
  • First time implemented the SQL CTE program to resolve the recursive calling data issues.
  • Technologies Used
  • ASP.Net 2.0, C#.net and SQL Server 2008 R2, DTS Packages, Web services, SQL Server 2012,2008, TSQL, SQL SERVER INTEGRATION SERVICES (SSIS), ASP.NET, Jira Tool, SVN, SQL SERVER REPORTING SERVICES (SSRS), Clarity, Citrix, Informatica 9.0, C#, Tableau, MS Azure SQL, SQL Agent, Oracle.

SOFTWARE ENGINEER

CALIBER TECHNOLOGIES PVT LTD
08.2005 - 11.2006
  • Technologies Used
  • .Net 2.0 (C#.net, ADO.NET), SQL Server 2005, Oracle 9I, Vault, Dotnet charting tools and Aspose and SQL Server 2000,2005, DTS Packages, Crystal reports.
  • Location: - Hyderabad, India
  • Project: Caliber LIMS (Laboratory Information Management Systems)
  • CLIENTS: All Healthcare & Pharmaceutical clients From India.
  • Responsibilities
  • Wrote new SQL queries and MS SQL 2000 server stored procedures from scratch.
  • Understanding of LIMS drug development business processes
  • Understand complete Life cycle of client Sample and Certificate of Analysis process.
  • .Net 2.0 website designing and coding in VB.net, C#.
  • Maintaining Visual source safe to get latest code Daily basis.
  • Involved in developing and maintaining applications for Caliber Technologies Pvt Ltd client and recommended functional changes.
  • Independently and successfully implemented web applications developed using ASP.NET, ADO.Net, C#.net.
  • Identified the gaps in business and system requirements thereby bridging the business and technical communities together to ensure end-user objectives.
  • Designed databases, stored procedures, triggers, transactions, tables and other database artifacts for SQL Server building DTS Packages for data cleaning and loading.
  • Translated business requirements and end-user needs into software and database systems design and specifications.
  • Involved in Unit Testing, Integration Testing and Regression testing in a regular basis to improve the performance of the application.
  • Developed reports using crystal reports and Dotnet charting to download from website.

Education

Master of Science - MASTER OF COMUTER APPLICATIONS,

Andhra University
India
05.2005

Bachelor of Science - BACHELOR OF COMUTER APPLICATIONS

Andhra University
India
05.2002

Skills

    Reporting Tools

    Microsoft Power BI, Tableau, SQL Server Reporting Services, Crystal Reports, Excel

    RDBM/Databases

    MSSQL Server 2016/2014/2012/2008 R2, Oracle 12c, MS Access, Microsoft Azure

    Programming Languages

    SQL, C, DAX, Python, T-SQL, PL/SQL, HTML, C#Net, VBNet, C, Java, Java script, CSS, Python, Windows Scripts

    Data Modeling

    FACT& Dimensions tables, Physical & Logical data modeling, Star & Snowflake schema, Relational, Dimensional and multidimensional modeling and De-Normalization Techniques

    Tools/Database Utilities

    SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, SQL Search, Import & Export Wizard, Microsoft Management Console, Business Intelligence Development Studio (BIDS), Microsoft Azure, Azure Data Factory, Azure Databricks, Azure Data Lake, AWS

    Version Control

    Team Foundation Server, Git

    Application Packages

    MS Office, Microsoft SharePoint Server (MOSS)

    Operating Systems

    Windows XP/Vista/7/8 and 10; Windows 2003/2008R2/2012/2016 Servers

    AZURE Cloud

    Azure SQL Database, Azure Data Lake, Azure Data Factory (ADF), Azure SQL Data Warehouse, Azure Service Bus, Azure Analysis Service (AAS), Azure Blob Storage Cache using Pipeline and SSIS, Data Migration Service (DMS), Azure SQL Data

Timeline

SENIOR DATA ENGINEER

Covet IT INC
10.2019 - Current

SENIOR SYSTEM ANALYST

ATHENA TECHNOLOGY SOLUTIONS
02.2016 - 10.2019

SENIOR CONSULTANT

EPAM INDIA PVT LTD (FORMALLY KNOWN AS ALLIANCE GLO
05.2013 - 08.2016

SENIOR SOFTWARE ENGINEER

EPAM INDIA PVT LTD
08.2011 - 05.2013

SOFTWARE ENGINEER,

EXCELLENCE DATA RESEARCH PVT LTD
11.2006 - 07.2011

Professional Achievements

Awards
08.2005 - 09.2023

SOFTWARE ENGINEER

CALIBER TECHNOLOGIES PVT LTD
08.2005 - 11.2006

Master of Science - MASTER OF COMUTER APPLICATIONS,

Andhra University

Bachelor of Science - BACHELOR OF COMUTER APPLICATIONS

Andhra University

Similar Profiles

CREATE PROFILE
AMARESWARI VEMURU