Ashish Limje

Client: Allscripts Healthcare Ltd.

• Migrate Data and Queries: Migrating data from Oracle SQL to SQL Server. Migrating queries, stored procedures, and functions from Oracle SQL to SQL Server.
• Building up of additional stored procedures and functions in SQL using SSMS.
• Developed Reports: Developed over 40+ SSRS reports using visual studio. Developed after migrating them from Oracle forms and achieving 95% accuracy in report results.
• Enhanced Report Interactivity: Developed real time parameter integrated reports for user, improving user engagement and understanding of data. Achieved a 90% improvement in user satisfaction.
• Applied innovative problem-solving strategies to overcome highly complex design and data challenges, implementing creative workarounds that ensured the consistent visual experience for end-users while maintaining the accuracy of the data in the reports.

Client: HUMANA Healthcare

• Backend Developer: Worked on data related task being a part of off-shore team, which includes SQL coding, build and design packages and its server deployment, creating jobs and scheduling, error handling, building and modifying stored procedure.
• SSIS: Worked on integrated services using visual studio for creating packages and to perform ETL tasks. Developed approximately 20+ SSIS packages. Extracting data from source, transforming it into useful data and loading it to required destination.
• Basic hands-on experience in developing reports through SSRS. Basic table structure report designs.
• Worked in agile mode, direct client interaction for requirements and solutions to the queries. Documentations of my developed tasks and unit testing details. Proactively part of all refinement and tech assessment calls

Client: The Football Association.

Domain: Entertainment & Telecommunication.

• As it was my 1st project joined as a programmer analyst and handled all the backend developer responsibilities. All the tasks were performed using my primary skill SQL through SSMS.
• Learned and worked on my 1st BI tool SSIS, created packages, flow tasks, performed ETL process of extraction-transform-load. Learned about jobs and scheduling of jobs.
• Direct client interactions for development requirements and solutions to the queries. Attending all refinement, tech assessment and deployment calls.
• Backend POC for all the SQL code and packages related deployment for each environment: Dev-Preprod-Production on client working hours.
• Confluence page creation and documentation of all the changes done in the project related to SQL and SSIS under my vision.