Roles and Responsibilities:
- Responsible for gathering requirements from Business Analysts and Operational Analysts and identifying the data sources required for the requests. Developed various SQL scripts as part of automation of manual monthly reporting to third party consumer.
- Worked on data profiling, data analysis and validating the reports sent to third party.
- Designed and developed Ad-hoc reports as per business analyst, operation analyst, and project manager data requests.
- Extracted, Analyzed and Presented Data in a Graphical Format using Microsoft Excel, such a way that helped project manager to make Business Decisions.
- Proficient in importing/exporting large amounts of data from Excel files to Oracle and vice versa.
- Used VBA Macro to create Weekly reports.
- Used Joins like Inner Join, Outer join while creating tables from multiple tables.
- Worked on Data Verifications and Validations to evaluate the data generated according to the requirements is appropriate and consistent.
- Designed and developed weekly, monthly reports related to the marketing and financial departments using Oracle SQL.
- Experience in Power Point Presentation (Financial Data, Charts).
- Expertise in generating graphs using MS Excel Pivot tables. Extracted data from existing data source, Developing and executing departmental reports for performance and response purposes by using SQL, MS Excel.
Environment: Oracle,Putty, Tableau ,SQL,Windows XP