Experienced Data Analyst with more than 4 years of expertise in Business Intelligence Analysis, specializing in IBM Cognos, Tableau, Power BI, Python, ETL platforms including Oracle Data Integration and DataStage, OBIEE and optimizing SQL queries in IBM and Accenture. Demonstrated proficiency in understanding client requirements and improving the performance of reports and dashboards. Skilled in utilizing BI Tools for effective security management and for increasing performance.
Technical Documentation: Played a pivotal role in completing comprehensive technical data science documentations, ensuring clear and organized records of critical processes and methodologies, contributing to efficient knowledge sharing. Captured, developed data definitions, business rules, and data quality requirements in the 5 documentations.
Data Automation and Process Improvement: Developed and maintained automated Cognos dashboards, reducing reporting time by 35% and collaborating with cross-functional teams to identify process improvement opportunities.
Database Management and Reporting Expertise: Proficient in designing and optimized 30 stored procedures to enhance database performance. Successfully identified and rectified errors in 15 reports through analysis and troubleshooting, ensuring data accuracy and reliability.
Software Development and Reporting: Proficient in identifying, defining data quality improvements, performing ad-hoc project analysis, software development and financial reporting tools, including Cognos Report Studio for delivering various end-user reports to maintain financial models to promote efficient use of resources. Created nearly 85 Cognos Dashboards, 350 scheduled reports, and generated 10 Event Studio reports.
Error Handling: Identified and resolved 95% of errors in related log files, ensuring the smooth functioning of software applications to conduct comprehensive cost-benefit analysis and set up a collaborative team environment to discuss about the issues to quickly identify the business problems with clear, concise, unambiguous communication skills benefitting 300 users daily which supports investment decisions.
Security Expertise: Implemented robust security measures in software systems, ensuring secure access and management among 500 users based on their level of access and permissions.
Data Confidentiality: Configured software systems with Secure Socket Layer (SSL) to ensure data confidentiality and enhance user trust which avoided malicious user access up to 75%.
Data Integration: Utilized Jupyter Notebooks for data analysis and Oracle Data Integrator (ODI) ETL tool to create and manage data integration jobs and agents for seamless data flow i.e., integrated data from multiple sources i.e., approx. 5 software systems sources to produce requested or required data elements. Extensive expert in providing robust platform and infrastructure support i.e., integrated with OBIEE 12c for efficient data analysis and reporting, and solved the errors in UI by making relevant changes in the backend.
Project Management: Provided accurate time estimates for development work and consistently met deadlines, ensuring timely project delivery, and ensured that the deliverables are met by conducting the analyses and audits for data analysis i.e., ensured compliance and always performed tasks under SLA’s and JIRA deadlines. Completed nearly 300 change and service requests and organized effectively by working in an Agile environment.
Stakeholder discussions: Conducted stakeholder discussions and been a direct contact to make judgment calls i.e., worked independently with nearly 50 users to discuss about the requirements to develop reports and deliverables for management and articulated stories and decisions with all levels of stakeholders and discussed about end-user information portals i.e., UI or resources and delivered multiple projects on time.
BI Tools and Technology Expertise: Hands-on experience in navigating technology landscapes, including adept utilization of platforms like Snowflake, AWS, and Oracle RDS. My proven track record includes leveraging these technologies to enhance data storage, retrieval, and processing capabilities, contributing to the overall efficiency of business intelligence initiatives up to 50%.
Engineered a personalized movie recommendation system using Python, Flask, and advanced machine learning algorithms, achieving a 20% increase in user engagement based on sentiment analysis for precise user review evaluation.
Demonstrated exceptional coding proficiency and expertise in web development (Python, Flask, HTML, CSS) and machine learning, resulting in a 15% improvement in system scalability and reliability, alongside the creation of interactive data exploration dashboards for an enhanced user experience.
Kickstarter Projects Success Prediction Model – Machine Learning Aug 2022 – Dec 2022
Constructed a model to forecast the success of Kickstarter projects utilizing AWS tools such as Athena, Sage Maker, RedShift, Glue, Kinesis, and Quicksight, alongside Python tools including pandas, Scikit-Learn, and NumPy for comprehensive data preprocessing, encompassing, and conducting data analysis, cleaning, and sampling.
Engineered a robust model predicting, attaining an 89% prediction accuracy by leveraging metrics from both Logistic Regression and Random Forest methodologies. This improvement resulted in a 25% enhancement in project selection efficiency, emphasizing a commitment to quantitative data visualization and adherence to stringent business intelligence standards.