View Bench List Portal

Similar candidates

• No Matching Candidates Found

Summary:

• Over 15 years of Data Analysis, Data Architecture Design, Data Modeling & Development expertise in high dependable systems, with a proven track record of implementing successful data management solutions.

• Specialized in Logical/Physical Database Design of OLTP systems, Operational Data Stores, Data Warehouses, and Data Marts, ETL Development, Data standardization and Security, Database and Application Performance Tuning & Optimization, Data Conversion and Migration, Data Interfaces and Database Application Development.

• Expert in designing and developing dashboards, scorecards & trending charts usingTABLEAU – Data visualization.

Skills:

Education: Bachelor in Technology (B.Tech), Kakatiya University, Warangal, India

Proficiency:

• Design, development and implementation of Operational databases, Operational data Stores, Data Warehouse and Enterprise Web site applications.

• Expert in designing and developing dashboards, scorecards trending charts using TABLEAU – Data visualization.

• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.

• Develop and lead the effort to collect, compile and analyze data, from various structured and unstructured sources, to perform statistical and usage analyses.

• Developing transactional and dimensional data models using Erwin and E-R studio

• Defining data requirements and designing databases to satisfy client business objectives.

• Participating in design reviews, and assisting with allocation of functionality to specific system components.

• Handling the design, development, unit testing and deployment of data warehouse systems.

• Experience in Erwin Model Mart as centralized data model repository, also working knowledge in Meta data management.

• Designing Reports, analyzing data and profiling data to present issues and working closely with Business Team on requirements and resolving issues.

• Developing data models, implementing databases, and tuning Databases for performances.

• Working closely with the team on Releases and managing and maintaining Release on multiple environments.

• Conducted Business Analysis sessions with the client to understand Legacy system, Conversion rules & objectives.

• Created detailed conversion mapping documents.

• Conducted detailed Data Profiling tests to check data consistency & quality.

• Analyzed the Historical data in the Legacy system to suit the EDW requirements.

• Designing ETL Architecture and Designing with auditing, and exception handling.

• Developed ETL scripts to extract the data from legacy source system and loading into upgraded system.

• Accurate comparison of data between columns of source and target

• Meta data tests

• Review process flow for initial load and periodic loads to identify any process gaps