Lokesh S Email and Phone Number

• Involved in design and conversion of business requirements to Conceptual Data Model, Relational Data Model, Dimensional Data Model, logical Data Model and Physical Data Model for subject areas. • Maintained security and data integrity of the database.• Handled performance requirements for databases in OLTP and OLAP models• Used Reverse Engineering and Forward Engineering techniques on databases and created tables and models in data mart, data warehouse and staging. • Worked on data mapping process from source system to target system.• Created a Data Mapping document after each assignment and wrote the transformation rules for each field as applicable. • Data modeling and design of for data warehouse and data marts in star schema methodology with Dimensions and Fact tables.• Involved in all the steps and scope of the project reference data approach to MDM, have created a Data Dictionary and Mapping from Sources to the Target in MDM Data Model.• Involved in several facets of MDM implementations including Data Profiling, Metadata acquisition and data migration.• Experience in Extract Transform and Load (ETL) data from spreadsheets, database tables and other sources.• Created Dashboard Reports using PowerBI.• Wrote SQL queries and optimizing the queries in Oracle, SQL Server and Teradata.• Extensively worked in SQL, SQL Tuning, PL/SQL, SQL Plus, SQL Loader, Query performance tuning, DDL scripts, database objects like Tables, Views Indexes, Synonyms and Sequences.• Analyzed historical data and transform large data sets to consumable format using SQL, Excel.

 Created Test plan & Script, Defect Management Templates; Created Initial test plan and developed test cases and test scripts manually. Tested web based fuel and vehicle management systems used across the globe for reconciliation of fuel bought, sold and used. Created an automated process to validate data received to the central servers from the home sites by SQL scripting. Involved in Testing Operational, Financial and Reporting systems /Automated Data Flows, Exceptional handling following business rules. Involved in testing Web-enabled, Group-scheduling system to push mails attached daily, weekly, monthly transactional/executive reports. Creating and maintaining various dashboards and scorecard in Qlik to track the Business. Used Quality Center to store all testing results, metrics, created Test Cases, and Reporting. Reviewed Business requirements, IT Design documents and prepared Test Plans which involved various Test Cases for all assigned module/projects; Review Test Requirements, Creating Test Plans and Test Strategy documents. Evaluated user problems and issues with software performance. Identified program variances identified through testing. Established and updated software testing programs and procedures. Provided feedback to developers’ vendors and clients. Involved in UAT testing, Regression Testing and Functional testing. Daily updated and managed offshore Team.

• Involved in creation of data Quality/validation rules at column level for the data warehouse and the data mart• Involved in creation of mapping documents from the source ingest file to data warehouse• Deploying ETL packages and reports into Production environment• Ensures deliverables meet Quality standards.• Involved in all stages of the project development starting from analysis to prod support.• Mapping of MDM entities to source tables• Writing unit test plans and execution strategy.• Worked on building Data Marts to support the mission critical Data Warehouse applications.• Created various stored procedures to load the data from multiple source to MDM• Involved in gathering the requirements from the business users to load the data into MDM Application.• Writing MDX Queries to get data for reports from cubes • Procedures to develop and populate Data Warehouse Relational databases, Transform and cleanse data, and Load it into data marts. • Coordinated in Testing, writing and executing test cases, procedures and scripts, creating test scenario.• Creating SSIS Packages by using different data Transformations like Derived Column, Look up, Data Conversion, Conditional Split, merge, merge join, Union all and Execute SQL Task to load data into Database.• Supported Multiple Teams who consume data from MDM Platform in Production Environment.• Worked closely with the data stewards in validating the MDM golden record.

• Understanding the client requirements and project functionalities.• Review of requirement specification. • Involved in writing code for java classes to communicate with database using JDBC.• Involved in writing functions and stored procedures • Design, Create, Review, manage, and execute Test Cases for modules.• Participated in Unit Testing and code review.• Documentation of request submission workflow.