Badges
Certifications
payal_chirania1 has not earned any certificates yet.
Work Experience
Senior Software Engineer
IBM India Pvt Ltd• September 2010 - April 2016
• Worked on Jaspersoft to develop SMART 2.0 Project. • Worked on SPARK framework to retrieve data. • Leading offshore team that includes managing day to day activity and providing technical/functional support. • Interacting with Non IBM Team (Big Data team / UI team/ Testing team) and providing knowledge/support. • Doing POC/Code Review and provide feedback for the reports developed by team members. • Worked and closing of any UAT/PIV defects and updating the same at share point. • Review of Design document as well as internal documents required by IBM activities. • Worked on C programming and Stored Procedures as per application requirement. • Worked on data testing by writing complex queries and compared it with report data. • Worked on fine tuning the stored procedures to increase the performance. • Worked with UAT Singapore team in completing the testing on time. • Taken interviews at the portfolio level. • Worked on migration of project from DB2 to NETEZZA. • Leading offshore team.
Data Analyst
Palmetto GBA• October 2008 - January 2009
FTP data from a mainframe environment to a UNIX environment. Load data from text files in a UNIX environment into DB2 tables using db2 utilities such as Load, Export, and Import. Writing Korn shell scripts which automates the loading process and other processes. Writing shell scripts to automate the FTP process, to load the data from flat files to database. Execute UNIX/DB2 scripts and monitor their progress. Crontab used to automate the routine process. Perform data quality checks to ensure data is properly loaded. Monitor telephone and e-mail account to perform help desk functions in support of the SADWH. Perform day to day operations of DB2 Statistical Analysis Data Warehouse (SADWH) such as resetting the passwords, deactivating and activating the user accounts. Performing Data quality checks before the users have the access to the data. Performing various daily tasks of Monitoring long running SQL’s and helping the users in resolving the long running Sql. Involved in creating reports and publishing them to Webi.
Software Engineer
Satyam Computers• February 2005 - January 2008
Worked as Oracle DBA for six months. Written shell scripts to automate the process. Analysis of change request forms provided by the client. Making the necessary changes in the code as per the CR. Doing QA and init fix as per the CR. Writing Solution documents with Unit Test cases. Unit testing, writing FTPs, UTPs. Update of bug tracking system (Focus).
Education
Aegis School of Business, Data Science, Cyber Security & Telecommunication
Data Science, Technical Diploma• June 2018 - June 2019
Hands on experience Python, R, Machine Learning, Deep Learning, NLP, Tableau, QlikSense, Apache Spark. I have done project in R, Python, Machine Learning, Tableau and QlikSense during my course curriculum.
G H Raisoni College of Engineering, Nagpur