Social Media Data

Sayalee Sanjay Pande

**** ** ***** **, ******* WA - 98028 Ph: 425-***-****

E-mail: ************@*****.*** LinkedIn: https://www.linkedin.com/in/sayaleepande EDUCATION

City University of Seattle, Seattle, WA Oct 2017 – Oct 2019 Master of Science Major: Computer Science GPA: 3.9/4.0 Savitribai Phule Pune University, India June 2010 – June 2014 Bachelor of Engineering Major: Information Technology GPA: 3.45/4.0 RELEVANT EXPERIENCE

Capgemini Technology Services India Limited, Pune, India Project: Banking Card Transaction Processing ROLE: Software Engineer Environment and Tools: IBM DB2, SQL, Java, COBOL, CICS, ISPF editor

Developed 40+ Functional Service Applications using SQL, Java and Vision PLUS platform, a financial software application, for Banking Card Transaction Processing in Finance Global Business Unit.

Analyzed business requirements and developed the software by working in Vision PLUS modules like CMS, CDM, FAS, ITS, ASM, LMS

Performed testing to uncover bugs and troubleshoot issues before application launch and reduced open defect tickets by 15%.

Collaborated with cross-functional development team members using Confluence to generate, organize and analyze potential solutions using Agile Scrum and assisted in updating issues onto JIRA

Used Endeavor tool to support the migration of modules into the production environment

Created programming documentation to define the system and its functional requirements ACADEMIC PROJECT

Mining Web Graphs for Recommendations based on the Data Mining (Platform: Java) Built a graph-based recommendation engine which propagates similarities between different graph nodes and generates recommendations. Customer Relationship Management Web Application (Platform: Java/Spring MVC) Developed a Spring MVC and Hibernate web application to help a business to manage and interact with customers and potential customers. Analyzed Manufacturing Company’s Data with Power BI (Platform: Power BI Desktop & Power BI Service) Designed and executed an end-to-end business intelligence solution to analyze a manufacturing company’s data to track KPIs, compare regional performance, analyze production level trends, and identify high-value customers. The process started with connecting and shaping company’s raw data with Power BI Desktop. Built complex relational models. Analyzed data with DAX calculations. Designed dynamic interactive report and dashboard using PBI’s visualization tools. Published Power BI reports to the cloud using Power BI Service. Automated reports and dashboards with gateways and scheduled refresh. Analyzed DVD Rental Company’s Data using SQL (Platform: PostgreSQL) Analyzed a DVD rental company’s data as an analyst. The project attempts to help the company to get a better understanding of their sales and customers rental behavior to improve their performance. As a solution to the same, retrieved, and filtered data from the DVD rental database. Used advanced filter functions for pattern matching. Joined tables and executed subqueries to efficiently perform complicated analysis. Provided the company with a summarized data by performing aggregations and grouping. Migration of Customer Relationship Management from On-premise to a Cloud-based Solution (Research Project) Identified the security and scalability problem associated with existing on-premise Customer Relationship Management (CRM) systems. As a solution to these problems, conducted a comparative study of the Cloud-based CRM solutions like Salesforce, Zoho, Microsoft Dynamics 365. Took various factors into consideration like integrations, target audience, Document Library, Salesforce and Marketing Automation, Landing Page, Social Media features, Dashboard Reporting and Email Integrations. TECHNICAL SKILLS

Programming/Scripting Languages: Python, R, SQL, DAX, Java, Java Script, C++, COBOL, JCL, CICS, Visual Basic

Database Technologies: Oracle, MySQL, PostgreSQL, DB2

Data Visualization BI Tools: Power BI, Tableau

Other Skills: Git, Arduino, Cygwin, MS Word, MS Excel, MS PowerPoint, MS Outlook

Certification: IBM Certified Database Associate DB2 9 Fundamentals

Publication: Published a technical paper “Mining Web Graphs for Recommendations” in International Journal of Electronics Communication and Computer Engineering (IJECCE)

Contact this candidate