Software professional with *.* years of experience as a database developer in web application development.
Recent Graduate in Information systems and business analytics with an 8 months of experience as intern in business intelligence and ERP applications. Looking forward to gain and extend my contribution with continual learning in Information Systems and business analytics Industry.
EDUCATION
SASTRA University, Thanjavur, TamilNadu, India May 2010 – May 2014
Bachelor of Technology in Electrical and Electronics Engineering, GPA: 3.7
Florida International University (FIU), Miami, FL Jan 2017- Mar 2018
Master of Science in Information systems and business analytics, GPA: 3.82
SKILLS
Programming Languages
PL/SQL, MS-SQL, SAP Hana SQL, C++,
Business Analytics Tools
Tableau, GE CPS, Crystal Reports, Rapid Miner, Power BI, MS Excel Reporting
Software & development Tools
PL/SQL Developer, Toad for Oracle 11g and 12C, SQL Server Management Studio, SAP Hana studio, SQL Server data tools, SAP Business One, CA Rally, HP Quality center, JIRA, R Studio (For predictive analysis)
Certifications
Oracle PL/SQL Developer Certified Professional
PROFESSIONAL SUMMARY
TATA CONSULTANCY SERVICES, Mumbai, Maharashtra, India
Systems Engineer Jul 2014 – Current
Contributed as web application developer to enhance and develop Cisco e-commerce application.
Debugged and resolved issues in testing and productions environments after every functional requirement for more than 40 different user roles in multiple scenario.
Worked under Waterfall and Scrum simultaneously while moving technology and data from relational database to NO-SQL database. Optimized and tuned the queries for improving the performance
Created Packages, Procedures, Functions, Views, Triggers, Cursors, Ref-Cursor, Types, Triggers, Scheduler Jobs, used SQL loader and wrote automated scripts for updating lookup tables.
Conducted Trainings on PL/SQL programming and performance tuning for more than 100 hours.
Developed and tested the existing functionalities using recent technologies like SAP Hana database and Mongo DB while migrating the application.
Coordination and continuous support is given and taken from on shore development team.
Assisted manager in billing and cost management activities
Member and safety champion of TCS safety first.
Competencies: PL/SQL, ITIL, Agile and scrum methodology, On-shore to Off-shore coordination
INTERNSHIP & ACADEMIC PROJECTS
Florida International University, HW College of Medicine-IT, Miami, Florida
Business Intelligence Analyst Intern Aug 2017 – December 2017
Assisting in identifying data inconsistencies and analyzing data in reports created for HWCOM departments and consultants.
Assisting in running reports with data definitions, which makes the report easy to review by users.
Assisted in researching and implementing new analytical methods.
Worked on SSIS, SSAS, SSRS and Tableau for generating daily reports for providers and office staff
Support new department initiatives and sample instrumentations that drive product decisions.
American Consultare, Miami, Florida
SAP Business One - Support Consultant Intern Jan 2018 – Mar 2018
Support and implemented SAP Business one on client systems on windows platform.
Integrated several add-ons like Outlook, External API from different vendors with SAP Business One.
SAP Business one implementations at different domains like Warehouse management systems, Process manufacturing, production. Also created stored procedures on MS SQL SERVER 2014.
Modelled, Analyzed for ERP systems on SAP Hana studio. Designed crystal reports and integrated with SAP business one. MS Excel reporting for Inventory maintenance.
Developing an application using SAP Fiori UX for web application Business one layer
JIRA is being used to track the activity of different clients and for billing.
Database Management and Warehousing
City of Margate OLTP database is transformed using ETL into OLAP and data warehouse is designed.
Cleaned the data and preprocessed prior reporting.
Tableau reports are generated and analyzed
Analysis resulted to identify that proper validations to OLTP database are not set in the application.
E-commerce and Business Analytics
Designed and developed a website on wix.com for local business
Used funnel model to choose the technology to make it cost effective
Enterprise Information systems
SAP ERP logon is used for experiencing the flow of the application
SAP lumira is used for analytics
Management of IS Function
Royal Caribbean International’s social media data is extracted using python script from twitter.
Proposed a RFID health tracking sensor network for handling emergency situations on ship with in less than 2 minutes of emergency.