Summary
Overview
Work History
Education
Skills
Timeline
Generic

Pushparaji Arunagiri

Westchester

Summary

10+ Years of experience in SQL Server and .Net technologies have strong working knowledge in EDW with SAP integrations. Good working Knowledge in C#.net. Worked Extensively in Client/Server Technologies. Strong working experience in SQL Server constructing tables, joins, views and stored procedures. Extensive experience working closely with both business and technical teams. Capable to research and expand the new technologies. Excellent team facilitator with good communication and interpersonal skills. Strong commitment to delivering quality applications within aggressive project timelines. Strong grasping power and ability to adapt to new technologies easily.

Professional developer with proven track record in delivering high-quality software solutions. Skilled in multiple programming languages, software architecture, and agile methodologies. Strong focus on team collaboration and achieving project goals, adaptable to evolving project requirements. Known for analytical problem-solving and effective communication skills.

Detail-oriented, organized, and meticulous employee. Works at fast pace to meet tight deadlines. Enthusiastic team player ready to contribute to company success.

Overview

20
20
years of professional experience

Work History

Senior Developer

Konica Minolta – Japan
  • Project #4: KMBT-Michigan SAAS Cloud
  • Client: Konica Minolta – Japan
  • Role: Senior Developer
  • Environment: .Net 4.0 C#, ASP.Net, SQL server 2005
  • Team size: 4 Duration: 8 months
  • Background:
  • A study was made on the existing Michigan application migrating it from the intranet to the Internet(Cloud).Konica Minolta Japan decided to provide Michigan as a SAAS system (ie) Software as a Service .For each and every usage of the resource of KM on cloud the customer of KM will be billed. The main area of device communication happens only through Michigan application, this was covered in the scope of the Proof of concept.
  • Responsibilities:
  • Involved in the preparation of high level and low level design documents.
  • Involved in the development of communication layer for establishing device communication.
  • Facilitated team for client demo and deliverables.
  • Supported team in solving critical issues.
  • Provided support to test team in functional and performance testing.
  • Project #4: KMBT-Michigan SAAS Cloud
  • Client: Konica Minolta – Japan
  • Role: Senior Developer
  • Environment: .Net 4.0 C#, ASP.Net, SQL server 2005
  • Team size: 4 Duration: 8 months

Senior Developer

Konica Minolta – Japan
  • Project #5: KMBT - Michigan 2.1
  • Client: Konica Minolta – Japan
  • Role: Senior Developer
  • Environment: .Net 2.0 C#,ASP.Net ,SQL server 2005
  • Team size: 11 Duration: 7 months
  • Background:
  • Michigan is an Enterprise System, used to manage the Multifunctional Peripherals (MFP) devices in the network by targeting Network Device Administrator. In this, you can install the device management functions with plug-in as Web application, like Net Care Device Manager (NC)-Contains Device Management Settings, Account Manager (Ontario) -Contains Accounting/Analysis functionalities by User and Device, Authentication Manager (Erie)-Contains User List and Permission Settings, Panel Manager(Huron)Specifies Panel Settings and manages address book for each user, Server Settings-Server settings for System Administrator for Michigan suite. It is an application used in the intranet where the Michigan Suite communicates with the devices and performs the required functionalities.
  • Responsibilities:
  • Involved in the development and preparation of Low level design document.
  • Involved in Code review and final investigation of code before delivering it to the customers.
  • Team co-coordinator for training and development, involved in preparation of user documents and presentations.
  • Provided support to testing team and actively worked with team members in delivering client deliverable
  • Project #5: KMBT - Michigan 2.1
  • Client: Konica Minolta – Japan
  • Role: Senior Developer
  • Environment: .Net 2.0 C#,ASP.Net ,SQL server 2005
  • Team size: 11 Duration: 7 months

Senior Developer

iSOFT R&D PVT LTD, Chennai
  • Project #6: Lorenzo – Regional Care : Lorenzo (Healthcare Product)
  • Client : UK NHS (National Health Service – Morcambay, Bradford)
  • Role: Senior Developer/Module lead
  • Environment: ASP .Net, C#, Java script & ADO .Net, SQL Server2005
  • Team size: 12 Duration: 18 months
  • Background:
  • Lorenzo is the Vision of Health care Product. Lorenzo is a Health care solution with more than 2000 features which supports Practitioners, hospital staff and patients in easing data retrival and analysis.It is designed with its own blue print platform components. Lorenzo application is the combination of two different application namely sysconfig and main application .It is the Sysconfig through which setting are configured for the main application facilitating different modes of operations for the health care solution.Lorenzo is developed on a Service oriented technology which makes it efficient in integrating with other Health care packages .Thus ensuring timely support, accurate decision making and improved medication to patients.
  • Work package: Requests and Results
  • Environment: ASP .Net, C#, Java script & ADO .Net, SQL Server2005
  • Role: Senior Developer/Module lead
  • Team size: 12 Duration: 18 months
  • Background:
  • The Requests and Results work package automates the process of clinical Lab tests done in the hospitals.Any requests and results can be viewed via Lorenzo.Even documents and reports corresponding to the patient can be attached which in turn is analyzed by the concerned specialist doctor for further medication.
  • Responsibilities:
  • Involved in the development of user interface design,web service and data access layer.
  • Used Java script to implement client side logics.
  • Involved in discussions with the Business analyst in order to acquire clarity of the requirements and change requests.
  • Involved in team discussions with QA in resolving issues.
  • Performed data model and Stored procedure changes.
  • Involved in production support and bug fixes.
  • Work package: Identity Management / Schedule implementation
  • Environment: ASP .Net, C#, Java script, Ajax & ADO .Net , SQL Server2005
  • Role: Senior Developer / Module Lead
  • Team size: 7 Duration: 8 months
  • Background:
  • Identity Management Work Package automates the process of patient registration in the Hospitals .This would enable General practitioner and other staff to know the identity of the patient, demographics thus easing the access of patient details across facilities via Lorenzo.
  • Scheduling functionality in Lorenzo defines the pattern in which the request can be placed for future date This implementation includes hourly, daily, monthly, weekly, yearly and variable patterns.
  • Responsibilities:
  • Involved in the development of user interface design, web service and data access layer.
  • Used javascript to implement client side logics.
  • Involved in team discussions that develops the middle tier components in order to ensure the APIs exposed by then are implemented in the system based on the requirement.
  • Involved in back end activities like Data model and Stored procedure changes.
  • Involved in the development of business logic in the implementation of recurrence pattern.
  • Worked in UI implementation for the different recurrence patterns.
  • Involved in discussions with the Business analyst in order to completely acquire the requirements.
  • Project #6: Lorenzo – Regional Care : Lorenzo (Healthcare Product)
  • Client : UK NHS (National Health Service – Morcambay, Bradford)
  • Role: Senior Developer/Module lead
  • Environment: ASP .Net, C#, Java script & ADO .Net, SQL Server2005
  • Team size: 12 Duration: 18 months

Senior Developer

iSOFT
  • Project #7: iDOC (iSOFT Documentation Tool)
  • Client: iSOFT
  • Role: Senior Developer
  • Environment: SQL Server 2005,ASP.Net, C#.Net, ADO.Net , SQL Server2000
  • Team Size: 2 Duration : 6 months
  • Background:
  • The tool automates the documentation process there by reducing the paper work . The tool enhances the working of three different teams namely development , documentation and Build & Package team . Build related inputs are given by the developer and is taken by the documentation team for the preparation of the release notes ,issue details ,fixes etc
  • Responsibilities:
  • Involved in the design and development of Web forms.
  • Preparation of Unit test cases.
  • Performed unit level testing before releasing it to quality team.
  • Assisted documentation team in the preparation of User guide and Installation guide.
  • Involved in data model changes.
  • Project #7: iDOC (iSOFT Documentation Tool)
  • Client: iSOFT
  • Role: Senior Developer
  • Environment: SQL Server 2005,ASP.Net, C#.Net, ADO.Net , SQL Server2000
  • Team Size: 2 Duration : 6 months

Developer - Software Engineer

UKI and Australian Health Care Services
  • Project # 8: iPM ( iSOFT Patient Manager )
  • Client: UKI and Australian Health Care Services.
  • Role: Developer - Software Engineer
  • Environment: C#, XML, SQL Server 2000.
  • Team Size: 9 Duration : 6 months
  • Background:
  • IPM has been developed with the flexibility to enable specific function to be selected, supporting the precise patient and business management processes of each organization i.Patient Manager – Integrated, Enterprise Wide, Patient Information iPM captures indispensable real time information at the point of patient care. Specialized modules such as order communications, pharmacy, management and booked admissions combine to provide integrated tools to improve information quality..iPM provides a single patient management and administration suite across suite, community and mental health facilities. This is combined with advanced clinical functionality offering results reporting, order management, clinical data capture.
  • Responsibilities:
  • Involved in the Issue fixing
  • Preparation of POC documents
  • Assistance to the documentation team.
  • Project # 8: iPM ( iSOFT Patient Manager )
  • Client: UKI and Australian Health Care Services.
  • Role: Developer - Software Engineer
  • Environment: C#, XML, SQL Server 2000.
  • Team Size: 9 Duration : 6 months

Developer - Software Engineer

iSOFT
  • Project # 9: iDMS (iSOFT Data Migration Services)
  • Client: iSOFT
  • Role: Developer - Software Engineer
  • Environment: SQL Server 2000, C#, ADO.Net
  • Team Size: 12 Duration : 10 months
  • Background:
  • The tool has the potential to Migrate data into various iSOFT Health care products (SQL Server) from a source file (potentially a Flat file with some specification) received from a legacy system. Also, the tool has the ability to migrate data into systems within the data centre that are live at one or more trusts.
  • Responsibilities:
  • Involved in the design and development of windows forms.
  • Preparation of Unit test cases.
  • Performed unit level testing before releasing it to quality team.
  • Assisted documentation team in the preparation of User guide, Schema guide, configuration guide, Installation guide and release notes.
  • Preparation of Impact analysis documents for new enhancements.
  • Involved in build related activities.
  • Project # 9: iDMS (iSOFT Data Migration Services)
  • Client: iSOFT
  • Role: Developer - Software Engineer
  • Environment: SQL Server 2000, C#, ADO.Net
  • Team Size: 12 Duration : 10 months

Developer

iSOFT
  • Project # 10: iDCS (iSOFT DataConsistencyServices)
  • Client: iSOFT
  • Role: Developer
  • Environment: SQL Server 2000, C#, ADO.Net
  • Team Size: 5 Duration : 8 months
  • Background:
  • DCS is a generic tool used to check consistency between data sources like database Table and Excel. It is mainly used to check consistency between various Healthcare domain products of iSOFT.
  • Responsibilities:
  • Involved in the design and development of windows forms.
  • Preparation of Unit test cases.
  • Performed unit level testing before releasing it to QA.
  • Assisted the documentation team in the preparation of User guide, Schema guide, configuration guide, Installation guide, release notes & package creation request.
  • Involved in build related activities.
  • Project # 10: iDCS (iSOFT DataConsistencyServices)
  • Client: iSOFT
  • Role: Developer
  • Environment: SQL Server 2000, C#, ADO.Net
  • Team Size: 5 Duration : 8 months

Business Analyst/EDW Consultant

Solenis
05.2023 - Current
  • Project #1: Project Diamond - Diversey Integration and support
  • Client: Solenis
  • Role: Business Analyst/EDW Consultant (BI Reporting)
  • Environment: SQL Server ,SSMS ,Excel integration ,SAP ,Tableau
  • Application Modules: BEX Integration, Operational Reports , Repzone and EProfitrol
  • Team size: 15 Duration: 17 months
  • Responsibilities:
  • Involved in the Diversey integration requirement gathering through implementing in production.
  • Involved in the preparation of low-level design documents. Wrote SQL queries, Views, Stored procedures to extract and manipulate data for reporting and analysis purpose.
  • Involved in coding and testing.
  • Worked in issue fixes and new CR developments. Interacted with the business team to perform the User acceptance testing.
  • Facilitated and provided business demos and deliverables.
  • Supported team with the process and technical documentation.
  • Project #1: Project Diamond - Diversey Integration and support
  • Client: Solenis
  • Role: Business Analyst/EDW Consultant (BI Reporting)
  • Environment: SQL Server ,SSMS ,Excel integration ,SAP ,Tableau
  • Application Modules: BEX Integration, Operational Reports , Repzone and EProfitrol
  • Team size: 15 Duration: 17 months

Voluntary Teacher

TAGDV, DE
08.2018 - Current
  • Organization – TAGDV, DE
  • Role: Voluntary Teacher
  • Duration: 30 months
  • Responsibilities:
  • Maintained a safe play environment by emphasizing and maintaining cleanliness and organization
  • Organized and engaged in recreational activities such as games and puzzles.
  • Encouraged curiosity, exploration and problem solving appropriate to developmental level of kids.
  • Drafted lesson plans and submitted them for review and feedback in a timely manner
  • Organized small groups of children while transitioning to and from outdoor play.
  • Fostered oral language development and critical thinking skills during literacy discussion.
  • Instructed, supervised children in class and assisted with marking and correcting work.
  • Provided one-on-one help with homework and assignments when needed.
  • Grade homework and keep track of student's performance in class
  • Organization – TAGDV, DE
  • Role: Voluntary Teacher
  • Duration: 30 months

Technical Lead

HCL Technologies Limited
07.2010 - 07.2015
  • Organization – HCL Technologies
  • Project #2: EIS Support
  • Client: HCL IBS, BSERVE, NECJV
  • Application: Employee Self service (ESS)
  • Role: Senior Developer /Technical Lead
  • Environment: .Net 3.5 C#, ASP.Net, SQL server 2008, CMMI ,SAP HR ,PI
  • Team size: 6 Duration: 23 months
  • Background:
  • This Project is an automated web-based system that enables HCLT employees, NEC HCL employees and HCLIBS employees to use the Internet to create, view and update personal information like family details ,visa, passport, working location ,Reporting manager etc and view other critical employment information online. Implemented CMMI Process for enhancements. All the data is integrated with SAP.
  • Responsibilities:
  • Leading a team of 5 people.
  • Involved in the preparation of high level and low-level design documents.
  • Involved in the preparation of Estimation, PCI audit and other CMMI process related activities.
  • Held additional responsibilities as PQA and DP in the team, in bringing the PCI score to green.
  • Worked in issue fixes and new CR developments. Interacted with the business team to perform the User acceptance testing.
  • Migration and uploading of data to SAP database, co-ordinated with SAP HCM and PI teams to achieve the functionality.
  • Major Objects include implementation of VPF approval flow and Visa approval flow.
  • Facilitated team for client demo and deliverables.
  • Provided support to test team in performing functional and performance testing.
  • Conducted code and document reviews.
  • Handled remedy tickets and brought about resolution before the SLA.
  • Involved in knowledge management and team building activities.Conducted many knowledge sharing sessions for the team.
  • Project #2: EIS Support
  • Client: HCL IBS, BSERVE, NECJV
  • Application: Employee Self service (ESS)
  • Role: Senior Developer /Technical Lead
  • Environment: .Net 3.5 C#, ASP.Net, SQL server 2008, CMMI ,SAP HR ,PI
  • Team size: 6 Duration: 23 months

Software Engineer

DXC Technology (I SOFT Health)
10.2005 - 07.2010
  • Project #3: EIS Reports
  • Client: HCL
  • Application: Reporting
  • Role: Senior Developer
  • Environment: SQL server 2008 ,SSIS
  • Team size: 6 Duration: 10 months
  • Background:
  • This Project is an automated web-based system that enables the managers to view the data from the application including employee data ,skills and generates reports.
  • Responsibilities:
  • Involved in the preparation of low-level design documents.
  • Involved in coding and testing.
  • Worked in issue fixes and new CR developments. Interacted with the business team to perform the User acceptance testing.
  • Job monitoring and reporting .Involved in bug fixes and build activities.
  • Handled remedy tickets and brought about resolution before the SLA.
  • Project #3: EIS Reports
  • Client: HCL
  • Application: Reporting
  • Role: Senior Developer
  • Environment: SQL server 2008 ,SSIS
  • Team size: 6 Duration: 10 months

Education

MBA -

Annamalai university
01.2008

BE - Honors

Anna University
01.2005

Skills

  • Technical Competency:
  • Programming Languages: C# Net 35, XML, Web Services
  • Web Technology: ASPNet, Java Script & HTML
  • Database: SQL Server 2005,2008,SSIS,SSMS
  • Operating System: Windows 2K / XP ,Windows 10
  • Data visualization tools
  • SQL expertise
  • ETL development

Timeline

Business Analyst/EDW Consultant

Solenis
05.2023 - Current

Voluntary Teacher

TAGDV, DE
08.2018 - Current

Technical Lead

HCL Technologies Limited
07.2010 - 07.2015

Software Engineer

DXC Technology (I SOFT Health)
10.2005 - 07.2010

Senior Developer

Konica Minolta – Japan

Senior Developer

Konica Minolta – Japan

Senior Developer

iSOFT R&D PVT LTD, Chennai

Senior Developer

iSOFT

Developer - Software Engineer

UKI and Australian Health Care Services

Developer - Software Engineer

iSOFT

Developer

iSOFT

BE - Honors

Anna University

MBA -

Annamalai university
Pushparaji Arunagiri