Ramesh R. Email & Phone Number

Developing and implementing an overall organizational data strategy that is in line with business processes. The strategy includes data model designs, database development standards, implementation and management of data warehouses and data analytics systemsCoordinating and collaborating with cross-functional teams, stakeholders, and vendors for the smooth functioning of the enterprise data systemPlanning and execution of big data solutions using technologies such as Snowflake, Matillion , Azure , Power BI, Power Apps, SQL Server, Netsuite, Oracle, Pythonimplement end to end business intelligence solutions focusing on the Snowflake and Power BI.Manage and architect the enterprise data warehouse, combining data from disparate sources.Analyze, translate and develop business requirements into a design of logical and physical data model to build Enterprise Data warehouse to support reports, dashboards, cubes and ad-hoc analysis.

Dallas/Fort Worth Area

Implement end to end business intelligence solutions focusing on the Microsoft BI stack.Manage and architect the global data warehouse, combining data from disparate sources and passing on data to other applications.Analyze, translate and develop business requirements into a design of logical and physical data model to build Enterprise Data warehouse to support reports, dashboards, cubes and ad-hoc analysis.Logical and physical design of OLAP AND OLTP Databases using ErwinDesign and Development of ETL packages using SSIS packagesDesign and development of dashboard reports using POWERBI, SSRS and Qlikview.Design and development of data warehouse based on Kimball Methodology.Design and development of tabular models in SSAS

Oak Brook , Il

Ensuring data governance and data quality Implement end to end business intelligence solutions focusing on the Microsoft BI stack Manage and architect the global data warehouse, combining data from disparate sources and passing on data to other applications Manage security and access for all data warehouse objects Develop bus matrix document by working with customers. This allows for an enterprise approach and requires little re-engineering when new requirements are added. Utilizing the Microsoft 2008 R2 and 2012 BI stack, inclusive of SSAS, SSIS, SSRS and SQL Server for all aspects of projects Develop data models and data warehouse architecture Maintain BI jobs and troubleshoot when necessary

Greater Milwaukee Area

Implement end to end business intelligence solutions focusing on the Microsoft BI stack Working with customers to ensure data integrity and value to allow senior level decisions to be made easier Develop bus matrix document. This allows for an enterprise approach and requires little re-engineering when new requirements are added. SSAS, SSIS, SSRS and SQL Server development for all aspects of projects Develop data models and data warehouse architecture Develop end to end SSIS solutions, utilizing delta loads when possible to ensure fast runtimes Develop SSAS cubes, develop hierarchies, attributes, relationships, etc encompassing all bus matrix requirements Develop SSRS reports using MDX to satisfy report requirements for users which requires accurate and quick resultsImplementation of TIBCO SPOTFIRE and Mobile Metrics visualization tool.Design and development of adhoc reports, dashboard reports, Mobile metrics and various graphical reports using TIBCO SPOTFIRE and SSRS.Database administration work such as providing access to the users, SQL Query Performance, Reviews, replication, QA , Staging and production deployments, SQL Diagnostic, relational/analytical database backup and recovery, and technical support.

Greater Milwaukee Area

Designed, developed, tested, and deployed ETL packages using SQL Server Integration Services (SSIS). Designed and developed framework to process the import files. Designed and developed data marts.Designed and developed reports using SQL Server Reporting Services (SSRS).Development of unit test cases and testing the SSIS packages.Development of complex queries, views and stored procedures.Data integration using Enterprise Data warehouse principles.Involved in end user testing and bug fixing. Studied the exiting data warehouse and Informatica sessions to load the data and prepared the technical specification document to rewrite in SSIS. Supported the existing data warehouse and applications.Created the technical and mapping documentation.Provided the estimations and architecture for the proposals.Development of web applications using C#.Net, ASP.Net, Java Script, and AJAX. Redesign of the SSIS packages for data base migration from SQL Server to Netezza.

Greater Milwaukee Area

Greater Milwaukee Area

Understanding the existing data bases and different sources systems of EDW (Enterprise data ware house) and DTS packages.Created the SSIS templates by implementing the package configurations, auditing, logging, and event handling.Created the custom assemblies using VB.Net for reusability and referenced in SSIS packages.Developed the ETL packages for 64 bit server to replace the existing DTS packages.Involved in data profiling and data cleansing.Responsible for data migration from SQL server 2000 to 64 bit SQL Server 2005.Developed the SSIS packages to extract the data from the databases to transform and load (ETL) the data into data marts.Involved in the development of data marts using RUP-based approach.Developed PPR dashboard reports using SSRS 2005 and SSRS 2008.Developed static and ad-hoc reports on relational and analytical databases.Involved in designing the dimensional modal in Star and Snowflake Schema.Generated cubes out of data marts using SSAS.Involved in database refactoring and application support for moving the database from SQL server 2000 to 64 bit SQL Server 2005.Supported the relational databases, analytical databases, SSIS packages, DTS Packages, and applications.Monitoring the daily, weekly and monthly loading process and provided the support if any job failed.

Greater Milwaukee Area

Development of stored procedures, functions and assemblies in SQL server 2005.Development of various configuration and system behavior reports with charts using SSRS 2005.Development of ETL packages using SSIS.Development of ad-hoc reports.Implemented localization in the reports based on the user’s culture.Integrated reports with Web Forms using ASP.Net and C#.Net.Involved in code walkthrough and query optimization.Involved in reviews and inspections of the code and the documents.

Hyderabad Area, India

Project Lead / Senior Software EngineerInteracted with the business users to collect the requirements and understood the business.Involved in application design, architecture design, database design, coding, and testing.Discharged my responsibilities in maintaining the quality system during the life cycle of the project.Involved in developing the Windows Forms and controls using VB.Net.Involved in MIS reports for all the modules using Crystal Reports and .Net.Development of components and user controls.Involved in designing online and offline model using Web Services.

M. Tech, Computer Science Engineering

M.Sc, Mathematics