Skills
Big DataOraclePythonSparkData AnalyticsUNIX/LINUSQLServerMySQLSnowflakeTableau InformaticaDescription
- A result-driven software professional with 11 years of progressive experience in Data Analysis, Design Implementation, Administration, and support of Business Intelligence, OLTP( Batch Processing, Online processing) OLAP, ETL, Data warehousing, Data mining, DBMS, and Data modeling primarily in Banking and Financial services and Telecom domains.
- Experience in developing Dashboard Reports, Parameterized Reports, linked reports, and Sub reports by Region, Year, Quarter, Month, and Week.
- Extremely worked with the Clients for requirements gathering and drafting those requirements into design specs and preparing estimations for the project deliverables.
- Expert level skills in Power BI, Snowflake, Java, and Python programming languages to handle immense datasets with Hadoop Ecosystem Map-Reduce/Spark.
- Expert Level Skills in Oracle PL/SQL programming and Performance Tuning for BI activities.
- Experienced in all phases of the Software Development Life Cycle (Analysis, Design, development, Testing, and maintenance) using waterfall and Agile methodologies
- Facilitated project Inception by building product backlog, epics, and consumable user stories in JIRA tool and identified key stakeholders to ensure engagement.
- Groomed and refined user stories by writing acceptance criteria and story points estimation after discussing with development teams for velocity tracking
- Worked with Architect and Development teams to ensure that the proposed design meets requirements and in line with SDLC best practices & the enterprise quality standards.
- Participated in UAT and developed test cases for Unit Testing & Functional Testing based on the user requirement.
- Proven experience in handling customers and development teams and proposing solutions to customers.
- Experience in writing complex SQL Queries using Joins, stored procedures, functions, triggers, packages, and cursors in Oracle.
- Expertise in Oracle performance tuning and Database designing and Troubleshooting in Oracle 11g platform.
- Implemented middleware solutions through Tableau Business Works.
- Developed Unix Shell/Perl/Python scripts and Power BI reports to automate various repetitive tasks and generate reports.