Ram K. Email & Phone Number

North Bergen, Nj, Us

Greater New York City Area

Responsible for building complex reports and dashboards in Power BI from scratch- Performing Data cleaning process using Python and SQL- Manage views and queries from multiple databases into Microsoft Power BI- Interpret data, analyze results using analytical techniques and provide ongoing reports- Implemented the use of Python libraries (NumPy and Pandas) in Jupyter notebooks in order to clean, merge and compile data from various data sources- Used Pandas dataframes to address Duplicate and Missing data in large datasets- Design and development of SQL Data Model to satisfy the end user reports by creating different types of Reports and Dashboards in Power BI - Build and maintain SQL scripts and complex queries for data extraction for analysis and preparation of ad-hoc reports- Involved with data model and reporting requirements for Power BI Reports with the Datawarehouse/ETL and Reporting teams- Responsible for Scheduling jobs for weekly, daily data refresh on different Power BI reports- Elicit customer requirements by organizing interviews with internal/external stakeholders and subject matter experts (SMEs)- Defined and documented detailed Business Requirements Document (BRD), Functional Specification Document (FSD) and Use Case Specification- Worked with the Quality Assurance team to create Test Plan and Test Cases and conduct unit, integration, and system testing- Performed and participated in the analysis, design and implementation of the business procedures following appropriate standards.- Conducted User Acceptance Testing (UAT) on a weekly basis with Project Team members and stakeholders to ensure all business requirements are addressed in the application

Fayetteville, Arkansas Area

Involved in manipulating the MDM Architecture and MDM Party Data model.• Have setup and customized IBM InfoSphere MDM 10 with RAD 7.5.• Proper coordination with consumer and their requirement to make the respective changes.• Done Entity Data Additions by creating new tables for attributes that does not fit in Data model.• Done Entity/Data Extensions by extending the existing data model and added required new attributes.• Created and applied various Business Proxy custom services to meet the changing customer environment.• Have done various Behavior Extensions with customized logic which even involved applying external business logic rules custom logic.• Involved in Batch Framework for Initial and Delta load.• Configured the error handling and Logging.• Working with controlM team to create jobs for MDM batch loads and scheduling all related jobs for successful daily/ monthly loads from source to MDM.• Have applied Suspect Duplicate Processing via Deterministic Matching Engines.• Have tested the designed custom services in the development environment using the MDM workbench /self-designed XML tester project.• Dealt with deployment errors by localizing them and applying the solutions in WAS.• Support production releases of new functionality / new source system introduction to MDM

Norwalk Connecticut

Played active role in Software Design, Development, Testing and Production support of the application. • Used HTML Forms and JavaScript to develop user interactive web pages and validate the data. • Developed JSP's to generate dynamic content based on the service requester and their requirements. • Used Servlets to create the GUI • Used Servlets to process the data entered by the client in the search system. • Used JavaScript for validating the data entered by the client. • Working knowledge of Java, Unix & Oracle. • Participating in resolving technical issues that arise during development. • Participate in reviews of design, functional specifications and code developed by other team members. • Designed Database for the application. • Implemented all validations and done testing. • Developing new features and maintaining existing applications. • Communicating and coordinating with members of development team.

Master'S Degree, Computer Science, A

Bachelors, Computer Science, A