| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
EMAIL AVAILABLEPHONE NUMBER AVAILABLEPROFESSIONAL SUMMARYData Analyst with over 7+ years of experience in SQL development, data modelling and Business intelligence. Proficient in Integrating data sources, utilizing ETL tools and performing statistical data analysis. Demonstrate a strong understanding of data warehouse development, from inception to implementation, ensuring high-quality data solutions across various industries.Work experience in Finance, Banking, Health and Insurance industries.EMPLOYMENT HISTORYLam ResearchSQL DBA Admin/Production Support August 2022 - Till DateResponsibilities:Configured and maintained database servers, ensuring high performance, availability, and security.Implemented disaster recovery solutions like Always On and mirroring.Provided database access to users and created SOPs for new tasks.Integrated Power BI for data visualization, generating comprehensive reports.Collaborate with cross-functional teams to design effective data models.Optimized data performance through proactive measures, resulting in substantial improvement in query response times and system efficiency.Led migration to Power BI, revolutionizing reporting processes and delivering real-time insights, significantly reducing report generation time.Implemented robust security measures, enhancing database security posture and ensuring compliance with industry standards.Partnered with cross-functional teams to analyze business requirements and design effective data models, fostering data driven decision-making.Implemented disaster recovery solutions like Always On and mirroring, ensuring high availability. Streamlined database access protocols, enhancing overall system reliability.Conducted regular training sessions on Power BI for end-users, enhancing data-driven decision-making.Goldman Sachs Group, IncProduction support Sr. Analyst May 2019 - August 2022Responsibilities:Collected, analyzed, validated, and reported data from various sources.Tested and documented processes, SQL queries, and data analysis methodologies.Extracted and analyzed data to respond to inquiries from different departments.Published regularly scheduled and ad hoc reports using Power BI for visualizations.Provided production support to L1 and L3 teams, ensuring efficient issue resolution.Conducted comprehensive data mining, analysis, and visualization for actionable insights.Maintained detailed logs of all issues and ensured resolutions met quality assurance standards.Leveraged Power BI to proactively analyze data, identifying areas for process improvement.Cardinal Health, UTSQL/Production support Analyst July 2018 - April 2019Responsibilities:Prepare Daily Monitoring report for Production SystemsParticipated in identification of the root cause and provide a Notes for the escalated and critical production tickets.Worked with team for third party tool integration.Responsible for developing Unit test cases and Test harness.Responsible for the client PROD environment and project deployments and provided 24X7 Production support.Worked on Performance Analysis/Tuning like Memory Dumps / Heap Dumps.Worked on Query Tuning and Database Performance Maintenance.Worked on Incident management is an IT service management (ITSM) process area.Worked with analysts, users, and other IT technical professionals to understand requirements.Involved in the Daily maintenance of the database that involved monitoring the daily run of the scripts as well as troubleshooting in the event of any errors in the entire process.Diebold, Hyderabad, IndiaJunior SQL Developer June 2014 - Dec 2017Diebold was updating their website to include an online application and wanted to retain the data collected from the applicants. They also wanted to maintain a database of the applicants who were rejected, including the basis of rejection so they could focus on those criteria for re-application by same applicants.Responsibilities:Generated database monitoring and data validation reports in SQL Server Reporting Service (SSRS).Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.Maintained system monitoring jobs and provided high availability support.Reported all events and requirements through established reporting mechanismsGenerated test data and tested database to meet the functionalities deliverables in the project documentation and specificationsEDUCATION AND CERTIFICATION*MBA, OU, Hyderabad, India, 2007*B.com (computers), OU, Hyderabad, India, 2005.MICROSOFTMicrosoft Certified: Power BI Data Analyst AssociateSKILLSSQL/Azure/Power BI, Excel, Reporting, Database Design, Data Modeling, Client-Server Applications, Business Intelligence, ETL, Data Analysis, Data Visualization, Data Warehouse, BI application design |
