Software Engineer Resume
2.00/5 (Submit Your Rating)
SUMMARY:
To secure a challenging position where I can effectively contribute my soft & competent technical skills to meet organization goals, thus enjoying professional & personal success.
TECHNICAL SKILLS:
Worked with ERP Environment: Starnet, Oracle Finance R12, GPS, & Mainframes, Excel (Visual basic) VBA macros and Access (SQL), Access VBA,VB 6.0 and SQL Server 2008, Oracle 11g
PROFESSIONAL EXPERIENCE:
Confidential
Software EngineerResponsibilities:
- Leading the team of 3 members for the Automation area of BRE.
- Involved in developing application by developing Visual Basic scripts and Visual Basic for Applications, deploy same in to the production database and as well as associate desktops.
- Reviewing the VB code for my team and helping them out in all the way of SDLC.
- Support and maintenance of BRE Automation tools & macros.
- Developing new tools using Visual Basic for Application for all modules in BRE.
- Writing and running the SQL queries for validations and retrieving data from DB.
- Preparing and Sharing the reports Daily/Weekly/Monthly basis and making sure the team to bring all the priority tickets to be closure. And reports have been automated using VBA.
- Completed 50 projects till date, highly capable to automate any web based and mainframe based applications.
- Saved more than $ 5 Lakh to the BRE by creating the automation tools in various modules.
- Eliminated 7 FTE in 6 months by automating various types of queues and put them into other business area.
- Completed 3 LEAN projects.
- Publishing Inventory, Production, Target, Accuracy, TAT, Login & Logout, OT, Utilization, Attendance, Unit Cost reports.
- Working on Ad hoc reports for top management.
- Preparing PMO activities for management.
- Preparing Presentations and decks to top management.
- Worked with MOL - IPS as MIS Data Analyst and VBA Developer from December 2011- September 2013:
- Reports are created and viewed in Access and Excel spreadsheets.
- Developed project design, coding, testing and debugging.
- Supporting existing user-created systems, such as spreadsheets, macros, and databases.
- Reengineered Design and Developed several VBA Dashboard programs, for use as an Excel Data storage Workbook.
- Designing, developing, implementing, and maintaining applications in areas that FTT is currently not supporting.
- Application Remediation: Migrating from Windows XP to Windows 7 as well as Excel 97-2003 to Excel 2010.
- MS-office package with Excel VBA
- Ability to create simple but effective database management software using MS-Access
- Simplifying tasks by making use of advanced excel options
- Automating tasks approved by the management by developing VBA -code/macros
- Testing whether the macro is working properly and debugging the issues
- Associating macros with user form objects
- Writing various types of queries through SQL to extract the required data from databases.
- Working with large volumes of data through macros
- Modifying macros based on the suggestions by the client optionally
- Developing User Defined Functions(UDF’s) in VBA to simplify daily routine tasks
- Automating reports by creating efficient and foolproof macros
- Minimizing manual hours by automating the needed tasks
- Hands on experience in passing data from one application to another in MS-office
- Coordinating with IT team for system enhancements and smooth flow of process for above
- Preparing the Daily, Weekly, Monthly and Annual Reports for Overdue.
- Importing unstructured data into structured data, Automating output to other application like word, Excel and power point
- Identifying the process which can be automated and discussing with team Lead and /or Manager
- Automation tasks approved by the management by developing VBA-code
- Vision planner(Comparison between budget and actual of net profit)
- Preparing MIS Outstanding report for 45 countries.
- Preparation of Dynamic reports on weekly basis.
- Preparation of Modification and No Modification reports.
- Preparation of East bound report and west bound report.
- Responsible for all the client related and internal reports (Daily /Weekly/Monthly)
