Summary
Overview
Work History
Education
Skills
Certification
Personal Information
Projects
Passportexpiry
Disclaimer
Timeline
Generic

Amrita Ranjan

Bangalore

Summary

Being multi faced software professional and having experienced various processes of SDLC for application development including maintenance & support for domain like banking & telecom, seeking a challenging role in data visualization, transformation & analysis to drive organization business processes & strategies.

Overview

11
11
years of professional experience
2
2
Certifications
2
2
Languages

Work History

Team lead

Marlabs Ltd
5 2022 - 2 2024

Team Lead

Nixsol
9 2021 - 5 2022

Deployed for Client Infosys,Bangalore

Birlasoft Ltd
01.2014 - 01.2019

Deployed to Client BA Continum,Gurgaon for duration Jan 2014 to Jan 2015

TechMahindra ltd
08.2010 - 01.2014

CGI
08.2007 - 08.2010

Education

MCA -

Manipal University

BCA - undefined

BIT Mesra

Class 12th -

Dhanbad Public School
Dhanbad, India
03.2001

Class 10th -

Carmel School
Dhanbad, India
03.1999

Skills

PowerBuilder(7, 105,12,2017,2019)

PL/SQL

T-SQL

SQL Server Reporting services (SSRS)

SQL Server Integration services (SSIS)

Oracle 9i

Sybase ASE 16

SQL Server 2000/2008

Rally

JIRA

Certification

Best Team award - Quarter 4 2015(Team Lead) at Birlasoft

Personal Information

  • Passport Number: Z3714753
  • Father's Name: Mr. Priya Ranjan
  • Date of Birth: 06/15/1983
  • Gender: Female
  • Marital Status: Married

Projects

Credit Insurance, Security Finance, 05/01/2022 - 02/01/2024, Window 7, Power Builder 2019, Sybase ASE 16,T-SQL, TFS,Sourcetree, 3, Project is based on Insurance provided on Personal loan at Security finance .This application maintains many reports which is shared to different application and stakeholders. The application also maintains the different insurance and claims made against the insurance., Worked on Project Metrics such as Monthly Status report, Deployment plan., Working on User Stories at Jira for every new change to be implemented, Documentation and coding of the required changes in PowerBuilder and T-SQL, Created code build and used version control tool TFS to deploy code in QA, Worked on Production bugs and deployed the fix. Charlie Migration, Farmersinsurance,Metlife, 09/01/2021 - 05/01/2022, Window 7, Power Builder 2017,SSIS, Sybase,T-SQL, Github,TFS, 5, Project is based on Property and Auto Insurance .This project is Migration project which currently a part of Metlife system and need to be migrated to Farmers insurance system., Worked as Offshore Lead., Worked on Project Metrics such as Weekly Status report,Deployment plan,Integration, Identifying the interfaces for Application and remediating them for Farmers insurance ., Working on User Stories at Rally for every changes to be implemented, Working with Build team for creation of weekly build for application., Documentation and coding of the required changes in PowerBuilder and SSIS Packages UK-RTS, GE Capital, 05/01/2017 - 01/01/2019, Window 7, Power Builder 12.5, SSRS, SSIS, SQL Server 2000,T-SQL, 5, UK RTS supported four main application of Lending Finance for GE Capital. Enterprise, WatchDog,GE Link,Reporting Services are the application which manages Loan Management in GE Capital., Worked as Offshore Lead., Worked on Project Metrics., Resolving tickets and interacting with Client., Working on maintenance activity and application health check., Designing custom and Ad-hoc reports using SSRS., Develop the business logic and analyzed and designed SSIS Packages., Created the stored procedures for the business logic using the T-SQL., Set up ETL Jobs using SQL Server Agent., Documentation and coding of the required artifact in PowerBuilder, Unit Testing and UAT Support, Supporting the application and reports deployment BPIS, Birlasoft, 02/01/2015 - 04/01/2017, Window 7, SSRS, SSIS, SQL server 2008/2008 R2,T-SQL, 4, Talent Summit is initiative that acts as a performance enabler and helps both the individual and organization achieve its core objectives. The concept of Talent Summit was conceived with an objective of moving towards a holistic way of performance assessment for the middle management layer, rewarding good performance and building a culture that is focused on employee development and optimal utilization of potential in both delivery and enabling organization., Understanding the requirement provided by business., Designing an appropriate solution., Documentation of the required Artifacts, Designing custom and Ad-hoc reports using SSRS, Developing ETL packages and jobs using SSIS according to requirement, Created the stored procedures,indexes for the business logic using the T-SQL., Supporting the packages and reports deployment. MSS,OMNI, Bank of America, 01/01/2014 - 01/01/2015, Window 7, PowerBuilder 12.5, IBM DB2, 5, MSS and OMNI are automated application which takes care of non-fraud and fraud transaction for any account., Understanding the requirement provided by business., Designing an appropriate solution., Documentation of the required Artifacts, Coding as per the requirement, Unit Testing, Providing UAT support, Supporting the application deployment LASR_GUI, AT&T, 08/01/2010 - 12/01/2013, Window XP, Window 7, Power Builder 12, IBM DB2, 5, LASR GUI forms the Front End of the LSR processing function of AT&T. LASR GUI allows the representatives to work on the LSR’s (Local service request) that are Drop to Manual by LASR (Local Access Service Request) which is an automated system for LSR processing. Whenever LASR finds any compliance in the LSR or if the information provided in the LSR does not meet the threshold then the system drops it to manual which also means that to process that LSR manual intervention is required. Our job is to Enhance/Maintain the LASR GUI Application as per the requirement of the Representatives/Business., Understanding the requirement provided by business., Designing an appropriate solution., Documentation of the required Artifacts, Coding as per the requirement, Unit Testing, Providing UAT support, Supporting the application deployment, Trainings & Knowledge transfer among team members giving them PowerBuilder technology and application related knowledge, Migrated the application from Powerbuilder 10.5 to Powerbuilder 12 CMS (Channel Management System), Bell Labs, Canada, 04/01/2009 - 07/01/2010, Window XP, Power Builder 7, 10.5, Unix shell scripting,SQL Server 2000, Sybase 12.5, 1, CMS is used by Bell Mobility and BDI to manage its Dealers. It’s the main repository to maintaining Dealer info and access. The Channel Management System (CMS / ProAge) is a corporate application used by both the eastern and western regions to manage dealer and lead related information. CMS/ProAge is a client-server application which contains five distinct modules: Dealer Maintenance, Complaint tracking, Call tracking, IVR Dealer Profile and Reporting Tool. These information is send to external system through CMS Synchronization process which is developed in (Power builder 10).It also contain other Synchronization which connect different sub system through unix jobs., Scripting in Sybase for Back End changes, Scheduling Jobs at SQL Server, Involving in UAT, Handling all technical enhancement for the application, Application Maintenance (CR Request), Handing the application as Application prime, Involving in Test plans (Unit Test, System Test) PROPONIX360, ANZ Banking Group, Bank of Montreal, Union Bank of California, 09/01/2007 - 03/01/2009, Windows 9x, NT, 2000, PowerBuilder 7.0, Oracle 8i, IBM Websphere MQ, PL SQL, Oracle8i, 5, Proponix enables banks to buy Trade Finance technology as a service. The integrated Trade Finance Platform enables banks (and their customers) to utilize. Proponix Suite of trade finance systems to perform both front and back-office transaction processing. This service includes access to a trade portal, workflow and imaging, a back-office trade processing system, and a reporting system. The result is a cohesive, integrated technology platform, not a jumble of mismatched systems, processes and resources., To develop the new functionality according to customer requirement as per the Changing needs of the business., Working on the Change Request (New Functionality development) for the Client., Configuring various servers and EOD built deployment. Also looking the issue in various regions like SIT, UAT and Production, Handling the IBM MQ middleware issues, Scripting in PL SQL for Back End changes

Passportexpiry

05/30/2026

Disclaimer

I hereby certify that the above stated information is true as per my knowledge and belief.

Timeline

Birlasoft Ltd
01.2014 - 01.2019

TechMahindra ltd
08.2010 - 01.2014

CGI
08.2007 - 08.2010

Team lead

Marlabs Ltd
5 2022 - 2 2024

Team Lead

Nixsol
9 2021 - 5 2022

MCA -

Manipal University

BCA - undefined

BIT Mesra

Class 12th -

Dhanbad Public School

Class 10th -

Carmel School

Similar Profiles

CREATE PROFILE
Amrita Ranjan