| 20,000+ Fresh Resumes Monthly | |
|
|
| | Click here or scroll down to respond to this candidateCandidate's Name
PHONE NUMBER AVAILABLE LinkedIn EMAIL AVAILABLEPROFESSIONAL SUMMARYData Analyst with over 3 years of hands-on experience, specializing in optimizing data workflows to drive business value. Proficient in database management, data visualization, and translating complex data into actionable insights. Engaged with cross-functional teams to gather requirements and deliver impactful BI solutions. Seeking to leverage expertise in a challenging role to contribute to organizational success. TECHNICAL SKILLS AND CERTIFICATIONSLanguages: Java, C, Python, JavaScript, Shell Scripting, SQL, PL/SQL. Tools: Informatica PowerCenter, IDMC, Talend, IBM DataStage, Github, JIRA, Jupyter, Power BI, Tableau, putty. Databases: MS SQL, MYSQL, Oracle, Teradata.Others: MS Excel, Microsoft Azure(Data Lake Data Factory, Databricks), AWS (S3, Glue, Lamda, EC2, CloudWatch). Certifications: Android Application Development, UiPath RPA, Tableau, Microsoft Power BI Data Analyst. PROFESSIONAL EXPERIENCEData Analyst PG&E, India, Cognizant July 2020 August 2022 Executed data modeling, transformations, and visualizations to meet business intelligence requirements. created complex SQL queries, functions, views, triggers, and stored procedures utilizing Oracle PL/SQL, Teradata, and MS SQL Server. Assessed Informatica ETL mappings/workflows and SQL that populates data warehouse and data mart Dimension and Fact tables to guarantee accuracy of business requirements. Strong ETL experience of using Informatica 10.5/ 10.4 PowerCenter Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools Informatica Server, Repository Server manager. Built ETL procedures with Informatica PowerCenter to ensure data consistency and integrity across data sources through effective data extraction, transformation, and loading. Leveraged different transformations like Filter, Router, Expression, Lookup, Aggregator, Sequence Generator, Update Strategy, Joiner, Normalizer, Sorter, and Union to develop robust mappings in the Informatica. Designed and developed Power BI visualizations like Dashboards, Standard Reports, Scorecards, and charts. Gave technical support for users in resolving issues related to utilization and billing. Employed JIRA for project management, issue tracking, ensuring seamless communication among development. Mentored 2 data engineer trainees in the team through code reviews and guidance on technical design documents. Proficient in Windows 10 and Linux environments, utilizing tools such as Putty for secure shell access. ETL Developer CleanTech Ventures July 2019 July 2020 Maximized ETL technologies and databases to improve data efficiency by 25% improvement and enhance overall data quality by 15% across diverse systems. Experience in creating high level documents, Source to Target mapping document and detailed design level document. Conducted data profiling, cleansing and data validations for each data source loaded into database using SQL queries. Delivered Unit testing, UAT testing support and deployment support. Resolved and fixed critical issues in workflows by collaborating with team. Debugged through complex Joiner and Router transformation logic comprising 1000+ lines of code. Optimized the existing job scripts and transformations to accommodate upcoming requirements. EDUCATIONUniversity of Texas at Arlington MS in Computer Science August 2022 May2024 KL University BTech in Computer Science and Engineering June 2016 May 2020 PROJECTSBlood Buddy Android Studio, Firebase Database Engineered BloodBuddy (Android), a blood donation management app streamlining user registration (under 2 minutes) and facilitating efficient donor-recipient matching within a 10 km radius. Integrated a real-time notification system keeping users informed of nearby blood donation events or urgent requests aligned with blood type. This system resulted in a 45% increase in blood donation participation. Job Recommender System UIPath, Excel Steamlined a job recommendation system using UiPath Automation, streamlining the process for connecting students with suitable employment opportunities. This technology improved overall placement efficiency and freed up staff members to focus on student aid by cutting down on the amount of time spent on job matching by 40%. |