| 20,000+ Fresh Resumes Monthly | |
|
|
| | Click here or scroll down to respond to this candidateSvayamprabhaDallas, Texas - Street Address PHONE NUMBER AVAILABLE EMAIL AVAILABLEEDUCATIONUniversity of Texas at Dallas, Dallas, Texas Aug 2023 - May 2025 Master of Science, Information Technology and Management GPA 3.6/4.0 Graduate Deans Scholarship, Graduate Competitive Scholarship Kalinga Institute of Industrial Technology, Bhubaneswar, India Aug 2012 - May 2016 Bachelor of Technology, Electronics and Telecommunication Engineering GPA 7/10 SKILLS Programming Languages and Frameworks: Python, R, Hadoop, Java, COBOL, JCL Databases: IBM DB2, SQL Server, MongoDB Tools and Applications: Tableau, R Studio, Jupyter, Power BI, IBM-BPM, Informatica Power Centre, HP Exstream, VSAM, CICS, Autosys, XPED, File-Aid, Endevor, IBM IDZ, Agile(Kanban JIRA), MS Office, Git, Excel WORK EXPERIENCESenior Software Analyst Principal Global Services India Apr 2020 Aug 2023 Built new table structure in the system database and optimized data loading and transferring for newly built functionality thereby achieving 40% faster task completion and overall user experience. Migrated the calculation of payable commissions to agents from a legacy system to the new event-based architecture thereby increasing the internal free flow capital by 13% on newly sold products. Created complex queries on MySQL, DB2, and MongoDB for deployment impact analysis to ensure application functionality and for any security vulnerabilities in the system. Automated legacy document composition tool to on-premises fully paperless electronic document creator hence saving 1500-5000 business hours spent on manually scanning and indexing. Automated the quarterly production verification by preparing a Python script thereby saving 5 business hours per quarter spent on manual verification and documentation. Coordinated with Product Managers to plan & prioritize tasks using the agile framework demonstrating a good understanding of the Software Development Life Cycle. Constructed SQL queries on the Customer Data Platform for data extraction, reducing processing time by 50%. Associate Consultant Capgemini Technology Services India Limited India May 2016 Apr 2020 Worked directly with clients to identify business problems and provided the best possible solution. Developed ETL pipeline for ingestion and consolidation of data from different sources into one database (IBM DB2), eliminating system dependencies and thereby reducing cost by 10%. Analyzed credit card transactions to identify target customers & optimize marketing campaigns in coordination with clients, increasing customer acquisition by 7%. Performed root cause analysis to identify process improvements & generated ad-hoc reports as requested by stakeholders. Implemented Tableau dashboards to monitor production job runs resulting in a 40% decrease in redundant reports. Mentored and peer-reviewed my teammates to help them grow technically and professionally. ACADEMIC PROJECTSSchool Acceptance Rate Analysis Python, Matplotlib, NumPy, pandas Classified and visualized Ivy League school application distributions for STEM and non-STEM programs based on courses offered, tuition fees, and course ratings using Python (pandas, NumPy, matplotlib). Job Market Analysis and Insights MongoDB, NoSQLAnalyzed job opportunities and salary offerings across diverse geographic regions and industries, leveraging a dataset of over 1 million rows. Provided valuable insights to job seekers through the application of SQL and NoSQL database concepts. Risk Analysis Truck Fleet Data R, Tableau, Hadoop, Hive, Spark Employed Hadoop tools and techniques to scrutinize truck fleet data, pinpointing risk factors based on various parameters such as truck company, abnormal events, and geographical locations. Generated visualizations for a national trucking corporation to proactively mitigate risks.ACCOMPLISHMENTSCertification: IBM DB2 9 Database Associate, AWS Certified Cloud Practitioner, NIAT-accredited Core Java, Embedded and Robotics Basics - HP(Hewlett-Packard) |