Technical Developer Resume Ashburn, VA - Hire IT People (2024)

SUMMARY

• Technical Developer with 4+ years of overall IT experience, focusing on building and supporting software applications.
• Experience in Ultipro HR/Payroll implementations, converting Legacy systems into SaaS based Ultipro systems.
• Experience in building UltiPro Cognos reports using Cognos V10 and V11 Analytics.
• Built benefit/payroll data analysis tools using Ultipro Cognos.
• Worked on extracting employee master files, Payroll opening balances files using SQL queries and Cognos.
• Testing interfaces, validate the data, format to meet the vendor specifications.
• Possess extensive experience in gathering the requirements, analyzing and optimizing the requirements and building the Interface requirement specification documents.
• Adept at developing Interfaces, creating queries, retrieving the data from database and executing and performing queries on the dataset and get reports.
• Experience in writing SQL queries and optimizing the queries in SQL Server.
• Extensive experience in writing sub queries, SQL, PL/SQL stored procedures, functions and additional Knowledge in Triggers and Cursors.
• Strong business, communications, team building, presentation and time management skills.

TECHNICAL SKILLS

Languages: SQL, PL/SQL, T - SQL.

HR/Payroll Applications: UltiPro Web Portal/Back Office, UltiPro SQL Framework.

Business Intelligence and Analytical Tools: COGNOS, Advanced Excel, Pivot Tables.

Database and Data Mining Software and Tools: MS SQL Server management studio

SDLC Methodologies: Agile/Scrum

PROFESSIONAL EXPERIENCE

Confidential, Ashburn, VA

Technical Developer

Responsibilities:

• Experienced in Agile Methodology, participated in Sprints and daily Scrums to deliver software tasks on-time and with good quality on basis with onsite and offshore teams.
• Generated UltiPro master files, tested and validated the accuracy of master files.
• Involved in Business analysis on various data conversion and interface projects.
• Developed Interface specification requirement documents.
• Tested the Integrations built for the projects.
• Fix the issues arising in the interfaces deployed.
• Worked on Demographic Data, Payroll, Cobra, 834 Format, Benefits Enrollment Interface Projects.
• Developed and worked on data validation tools for master files, it helps to identify data mismatches easily and get through complete validation.
• Developed Payroll Parallel Data Validation Tool, it will compare source earnings, deductions, taxes and net pay with ultipro payroll.
• Converted 28 Tables from Legacy to SaaS based Ultipro systems using stored procedures, functions and cursors.
• Developed queries using Ultipro tables including configuration, employee master data, Job history, Benefits/ payroll deductions and tax tables.
• Developed complex SQL queries against various data sources like SQL server, note pads. Write complex Sub queries, correlated queries and nested queries.
• Write queries and stored procedures in SQL, exports data into excel or csv files, review them for quality and data integrity, and send them to internal clients or external agencies.
• Creating and maintaining reports, dashboards and file feeds using Cognos for internal processes.
• Built Employee head count reports, weekly new hires and quarterly benefit deduction reports using Cognos.

Environment: SQL, PL/SQL, T- SQL, Microsoft Word/Excel, Ultipro Cognos V10, V11, Ultipro Tools.

Confidential

Business Analyst

Responsibilities:

• Gathered and Documented business requirements and processes, gathered technology requirements based on business rules, reviewed systems analyses report to ensure design matches requirements.
• Designed and developed requirements according to client inputs. Created use case diagrams to depict business, technical and non-technical functionalities.
• Created Process flows, Business requirement documents, Functional requirement documents as per user requirement.
• Documented and tracked the changes for functional and business specifications.
• Analysed business procedures and problems to refine data and convert it into programmable form.
• Worked on and supported projects in public Sector with focus on business analysis, requirement gathering, functional documentation and configuration.
• Attended the daily scrum meetings as part of agile methodology.
• Proficient in Business Requirements Documentation, Business Process Flow modelling, Business Analysis.
• Prepared and documented the User Acceptance test (UAT) plan and writing test cases.
• Documented troubleshooting steps and service restoration details.
• Status reporting to the management.
• Developed testing scenarios, test scripts and performed UAT.

Environment: Agile/Scrum, Oracle 11g/12c (SQL, PL/SQL)