Aakrati Gupta
Developer · GSK
Cockeysville , MDIn My Own Words
• 3 years of experience in Analysis, Debugging, Testing and Product support of software applications and products.
• Handled all aspects of Development Lifecycle, evaluation of third party solutions, release, documentation, and support.
• Experience in Banking & Finance domains
• Experience in UNIX and shell scripting, Jira and Jenkins.
• Worked closely with Customers to resolve issues and improve usability.
• Proven characteristics of being highly motivated. Strong problem-solving skills.
• Fixed to problems by own responsibility, and rectifies errors by modifying the system or databases, making use of various Clearing House modules, UNIX and XML.
• Demonstrated ability of innovative thinking evangelizing software development practices and processes.
• Excellent trouble-shooting and reverse engineering skills.
• Experience on handling onshore-offshore business process module.
• Extensive knowledge in various reporting objects like Hierarchies, Filters, calculated fields,
Sets, Groups and Parameters etc., in Tableau.
• Generated Tableau combination charts using Tableau visualization software and developed
Maps manually using custom geo-coding and WMS servers.
• Extensive experience in PL/SQL and SQL and performance tuning SQL queries in TOAD
• Quick learner and strong desire to adapt new technologies.
• Excellent verbal, written, interpersonal and communication skills to lead teams and interact with users and team members to understand and meet their business & functional requirements.
Work Experience
Developer
GSK2016 – 2017
Description: GlaxoSmithKline (GSK) is a world leading research-based pharmaceutical company with a Powerful combination of skills and resources that provides a platform for delivering strong growth in today's rapidly changing healthcare environment. OPAL (Online Product Authorizations & Lifecycle) is an effective and efficient GSK-wide system for the tracking of regulatory applications and product registration details for both investigational and marketed products for all central Pharma and LOCs. It is the authoritative source of product registration information for GSK. It is a one-stop system for answering the question of what Product is registered where, and what the details of each authorization are. Responsibilities:
• Gathering the requirements from the Business users and understanding the functionality & business rules. • Preparing functional design document, requirement document & technical design document for reports. • Developing data model to create reports and dashboards. • Developing worksheets using parameters, calculated fields, groups, sets and hierarchies. • Developing worksheets with different styles like bar, pie, tree map, dual axis, filled maps. • Implementing the reports with best practices to improve the report performance. • Creating rich dashboards using Tableau Dashboard and applying actionable insights. • Implementing user level security to restrict the data by group level and user level. • Publishing dashboards to tableau server and managing the security for users • Preparing deployment documents and involving in production deployments.
Technical analyst
Moodys2015 – 2016
Environment: PTC- Integrity, Jenkins UNIX, XML, Windows 7, HP Quality Center, JIRA. Duration: November 2015 to September 2016
Description: Moodys ranks the creditworthiness of borrowers using a standardized ratings scale which measures expected investor's loss in the event of default. Moodys Investors service rates debt securities in several bond market segments. These include government, municipal and corporate bonds, managed investments such as money market funds and fixed- income funds; financial institutions including banks and non-bank finance companies and asset classes in structured finance. In Moodys investors Service's ratings system, securities are assigned with A being highest quality and C lowest quality.
Responsibilities: • Administration part for PTC Integrity. • Configuring and triggering jobs in Jenkins. • Worked with MAVEN or ANT for building the application, has written MAVEN scripts and shell scripts to automate the build process. • Created the process documents related to the applications supported. • Communicating with Dev, QA, Delivery team related to build and deployment status and concerned issues. • Administration part of Subversion in JIRA and configuring Projects and roles to the projects in JIRA
Project # 3 Title: OPAL Reporting
Technical Analyst
Syntel INC PVT LTD2014 – 2015
RISC Front End Systems - RISCFES Environment: UNIX, XML, Windows 7, HP Quality Center, CA Service Desk, FD POS Management, Merchant Manager Duration: August 2014 to November 2015 Role: Technical Analyst
Description: RISC serves as a middleware layer for a wide variety of front-end systems that interface with Merchants and associations. This involved Production/Development activities related to North Front end switching systems. FDMS/6000 application is a NETX application which uses API calls to interface with NETX line handlers and each of its application modules to request services from the NETX manager/logger and to receive requests from processes outside of NETX. This is the Front-end entry point for any credit/debit/gift card transactions to process its authorizations and settlement. Responsibilities: • Mentor and guide BSAs to improve production analysis process knowledge and skill sets to enhance performance capabilities, broaden the knowledge base, and increase competencies. • Review CA tickets (peer review) to ensure completeness, accuracy, and adherence to quality and work product standards and best practices • Analyzing user requirements and user requests to determine feasibility of issue within time and cost constraints. • Acting as a liaison between all level of users, the Business community and information services including Customer Support and IT to provide technical and business solutions that meet user needs. • Develop and delivers summarized findings of problems through PowerPoint presentations to managers to recommend proposed actions. • Working with the Retail Manager's for Merchant in the requirement gathering, converting the business requirements into technical specifications. • GGR module and Cardinal commerce enhancements • BSM support in creation of CMDB database for AIX Production boxes • Simplifying and creating User stories from Business requirements and use cases • Joining the bridge Call's for the Priority 1 Issue's and analyzing the issue and providing the Resolution with in the ETA. • Provided Post Implementation support by updating the existing application with revised user requirements, enhancement features and defect fixes • Schedule and maintain the Automated Scripts for batch processing in AIX production. • Providing status/ defect report/ progressive reports to higher management • Interface the front end RISC application with the Host data Capture Application to take care of Transaction processing to Association. • Analyze all the Trace data from Production Severs and fix the data issues. • Schedule the Automated scripts to be executed in Cron environment using the scheduler software called approx. • At the end of each release conducting Retrospective to find out lessons learnt/ + and - Project # 2
Education
Bachelor of Engineering in Computer Science
RGPV UniversityBachelor of Engineering in Computer Science