Badges
Certifications
amitkrmaji has not earned any certificates yet.
Work Experience
Senior IT Specialist
Optimum Solutions• February 2016 - Present
• Managing end-to-end ERM quarterly project release cycles by planning, requirement gathering, designing functional specification, coding, testing and defect tracking for client (UOB) • Developing new ETL procedures or enhancing existing procedures and applying BI logics on flat files and placing it into data warehouse • Handling adhoc requests from end users to extract data from Excel templates and generate the reports in SAS • Planning test strategies by prioritizing the test cases based on business impact and criticality and designing test cases • Executing unit test, SIT, regression and verifying test results by capturing screen-shots of successful test completions • Triggering multiple batch runs with different date slices to perform regression testing and validating the data consistency across all modules • Logging and tracking defects through JIRA till successful closure by code/bug fixing and re-testing • Supporting business clients for UAT test preparation including resolving issues and collecting UAT approval signoffs • Performing root cause analysis and resolving any data discrepancies escalated during UAT phase • Managing version control of codes and deploying the solution into Production using Rocket Aldon or IBM ClearCase • Scheduling and maintaining of the batch job streams using Control-M tool in Test and Production environments • Post implementation support by engaging with the business users to perform data verification and resolve any data discrepancies found in Production
Senior Software Engineer
Seven N Consulting• February 2013 - February 2016
• Designed data flow documents and developed efficient codes in SAS Base/Advance and SAS DI tools for client (Bankdata) • Planned, analyzed and designed complex business problem in conjunction with other technical specialists • Extracted data resided in SQL Server 2008 and applied complex BI logics, used ETL techniques to transform it into SAS datasets and load into the data warehouse • Resolved basic programming defects and errors identified during unit testing and UAT • Deployed codes into Test and Production environments using Infoman, RTC and DCM tools and provided post-production support for data verification • Followed Agile/Scrum project methodology and tracked project time-lines using Version-One tool
Lead Engineer
HCL Technologies• July 2011 - February 2013
• Delivered L2/L3 level IT application support to client (Merck) using Base/Advance SAS and SQL • Provided administration support for SDD (SAS Drug Development) application by setting up new studies, extracting data for different studies, granting and revoking users’ permissions and managing clinical trial groups as per request • Managed efficiently by prioritizing incident/problem tickets requests and resolved using Merckury and Remedy tools • Performed root cause analysis of failed clinical data extraction by analyzing code, investigating error logs and data • Interacted with external vendor (SAS) for any application outages and managed business impacts and escalations • Tested troubleshooting methods, devised innovative solutions, and documented resolutions for inclusion in knowledge base / SOPs for support team use • Mentored a team of 3 members and offered continuous peer support and resolved any issues or conflicts • Performed detail analysis of monthly data trend – SLA, Case aging, MTTR values in Excel • Consolidated and generated - Dashboard, SLA and MTTR reports for monthly meeting with client
Software Engineer
HCL Technologies• October 2009 - June 2011
• Delivered L1 level support to client (Merck) for the SDD (SAS Drug Development) application following ITIL process • Handled incident/problem tickets requests and resolved with minimal business impacts using Merckury tool • Debugged codes and issues in the application and diagnosed failed data extraction of any study and providing fix • Generated and exported randomized codes for CRO as per users’ request
Technical Support Officer
HCL Technologies• November 2006 - September 2009
• Provided L1 level of on-call technical support to client (British Telecom) broadband customers • Helped with installing, configuring and troubleshooting of broadband setup, router, modem, VOIP phone and e-mail • Provided administration support of email password resets after validating security questions from customers
Education
Indira Gandhi National Open University
Computer Information Systems, MCA• January 2003 - December 2005
University of Calcutta
Business Administration, B.Com• July 1998 - June 2001