anish panga

• Developed and maintained ETL processes and/or SQL queries from various source systems using ODI tool.
• Assisted the Data Architect with developing a Dimensional Fact Model (i.e. STAR Schema) and took lead in building the repository with all subject areas for Oracle Analytics.
• Worked on web services to extract data from various source systems and processed complex JSON and XML files which in turn are used to transform and direct the data to our final Data Warehouse.
• Developed and maintained the automation of data flowing in and out of the source systems.
• Participated in an agile environment and completed assigned sprint tasks.
• Maintained development practices in accordance with Data Governance principles and policies and help maintained the Data Dictionary.
• Maintained the code repository and responsible for code migrations to production.
• Worked with BI analysts, functional users, and data scientists to r develop and further enhance data models.
• Modeled Web semantic Oracle and integrated Github to Semantic model.
• Supported a complex Data Integration environment by resolving the existing production issues and thereby stabilizing the Production environment.
• Have set up and maintained the metadata repository in all applications.
• Worked with the Network Operations Center (NOC) to ensure extract jobs are monitored.
• Troubleshoot issues as they arise (e.g. Failed jobs, data errors, etc.).
• Communicated the technical architecture and issues to other teams.
• Determined data sourcing strategies and data validation approaches.
• Lead the developer testing process and build and review test cases.
• Developed and maintained audit and validation processes and worked with other team members to resolve data integrity issues.
• Worked on Integrating BI admin Tool and also Web Semantic with GIT and also implemented MUD process as per the job requirement.
• Worked with SAS DI Studio to create the ETL Mapping and also troubleshooting the Errors.
• Created Data Models and Reports In OTBI for the job development
• Created Report using IBM Cognos Reporting tool and shared to server to pull the report into ODI using XML file.
• Prepared the Analytics platform using OAC where the end users would visually see the data by simple drag and drop features. Modelled the data in RPD which is in turn used by OAC.
• Developed Python scripts to generate network data and load it into database tables. Scheduled these scripts using local cron jobs for automated execution.

• Performs complex and specialized software development support functions, such as troubleshooting, analysis, research, debugging, and problem-solving.
• Consults with clients to review project plans and schedules, secures approval of test results, and discusses problems or concerns.
• Designs complex programs, program modifications, or applications. Develops specifications based on input from the customer and creates complex design documents.
• Reviews and writes complex programs, program modifications, or applications.
• Created Data Models and Worked on various RTF Template, Excel and worked extensively in reports generations
• Creates, maintains, and enhances Business Intelligence components (metadata, reports, metrics, dashboards) and manages the overall BI ecosystem by resolving defects in a timely manner
• Reviews and analyzes software documentation and production results to facilitate problem resolution.
• Tests complex programs, program modifications, or applications.
• Worked on Oracle J-developer, creating new task flows, VO and others.
• Assists with data architecture design. Participates in the evaluation of software products and programming languages to determine their applicability to a specific system or project.
• Assists project leader with developing work plans and time schedules for projects including outlining phases, identifying personnel, and computing equipment requirements.
• Knowledge of word processing and spreadsheet applications. Knowledge of advanced analysis, troubleshooting, problem-solving, client relations skills, requirement assessment and analysis, project management methodology, and proficiency of the Information Technology Interface Library (ITIL).
• Ability to multitask and work cooperatively with others.