SONIA ANTHONY THEKKNEDATH

*** – *** – **** https://www.linkedin.com/in/sonia-thekknedath-22519388 acurue@r.postjobfree.com EDUCATION

Carnegie Mellon University Pittsburgh, PA

Master of Information Systems Management (GPA 3.73) May 2016 Courses: Financial Accounting, Principles of Finance, Business Intelligence & Data Mining, I.T Project Management Visvesvaraya Technological University Bangalore, India Bachelor of Engineering (71.3% - Top 10% in class) June 2011 SKILLS

BI Tools: IBM InfoSphere DataStage, Cognos, Informatica, SPSS Modeler, SAS, Tableau Languages: SQL, Shell Scripting, R Programming, C, Java, Python Databases: IBM DB2, Oracle 11g, Teradata

Operating Systems: UNIX, LINUX, AIX, Windows

Tools: Microsoft Office Suite, SVN, Remedy, Jira, Minitab Functional: SDLC, Agile Methodology, Project Management, Requirement Gathering, Impact Analysis, Business Analysis PROFESSIONAL EXPERIENCE

J.P. Morgan Chase & Co. Mumbai, India

Application Developer May 2014 – April 2015

Led a team of five that developed ETL solutions for customization of transactional data for 250+ commercial clients

Proactively automated the ‘Impact Analysis’ process by designing shell-scripts, reducing the time taken by 80%

Created system usage reports and automated failure alerts thereby improving the client experience while using Cognos

Expedited solutions for run-time code breaks while upgrading an ETL tool; successfully migrated 1000+ DataStage jobs

Collaborated with clients and cross-functional teams, planned and executed production deployments for enterprise releases Tata Consultancy Services (TCS) Mumbai, India

Systems Engineer October 2011 – April 2014

Developed 200+ ETL processes and provided production support for the European division’s enterprise data warehouse of a global manufacturing organization, increasing the revenue by 2%

Spearheaded a ‘Data Quality’ project that validated data across the various layers of the data warehouse; the flexible framework was adopted across various other reconciliation projects in TCS (Best Performer Award)

Mentored new recruits and conducted team-wide training sessions on domain and technical knowledge – SQL and ETL process development, reducing the onboarding time by 30%

Introduced a new tool ‘InfoSphere Fastrack’ to the team that aided in documenting data mapping across various layers of the data warehouse, decreasing UAT defect rate by 65% (Star of the Quarter Award)

Optimized complex SQL queries and implemented ‘Change Data Capture’ to convert Type 2 to Type 1 dimensions that improved the end-to-end process by reducing the daily data load time by 40% (Star of the Quarter Award)

Created and customized reports and dashboards using Report Studio, Analysis Studio and Framework Manager (Cognos)

Production Support: Solved 50+ high priority (SLA 8 hours) and 350+ user issues, monitored data loads, and enhanced codes ACADEMIC PROJECTS

Student Consultant - Aesynt - Customer Support Case Volume Reduction August 2015 – December 2015

Analyzed historical data using SQL and R, and conducted focus group discussions, gap analysis and benchmarking

Provided recommendations to reduce 27% of the customer support cases Project Manager - Daimler Trucks - Analytics Prototyping using SPSS Modeler and R January 2016 – Present

Solving business problems by using data mining techniques such as Regression, K-Means Clustering, and Decision Tree

Creating a failure rate prediction model for the various components in a truck using a Hazard Rate Model ACHIEVEMENTS

Led the “Teach the Teachers” campaign – J.P. Morgan’s CSR Initiative, 2014

IBM Certified Solution Developer – InfoSphere DataStage v8.5 Certification, 2013

Winner of the Mumbai Schools Sports Association Competition – Basketball, 2005 and 2007

Contact this candidate