Amit Kumar Maji
AKM
Senior IT Specialist-
- (IND) / - (SG)
Alexandra, SG
4+ years experienced Senior IT Specialist and passionate about cutting-edge technology and solving real-world business
challenges. With total experience of 13+ years in software designing, development, testing, interpreting and analysing data;
displayed proven ability to handle complex, high volume, multi-dimensional data using a variety of software tools. Deliver highly
effective and creative solutions to meet the business and technology challenges.
PROFESSIONAL SNAPSHOT
Senior IT Specialist | Optimum Solutions | Changi, SG| Feb '16 – Present
Senior Software Engineer | Seven N Consulting | Gurgaon, IN | Feb '13 – Feb '16
Lead Engineer | HCL Technologies | Noida, IN | Jul '11 – Feb '13
Software Engineer | HCL Technologies | Noida, IN| Oct '09 – Jun '11
Technical Support Officer| HCL Technologies –BSERV | Noida, IN | Nov '06 – Oct '09
TECHNICAL SKILLS
Programming/Scripting: Base/Advance SAS, SAS DI, SQL, Python, UNIX shell script, MS Excel-VBA
Database Application: SQL Server 2008
Visualization Tools: Tableau
KEY SKILLS
Development
Unit Testing, SIT & UAT
L1/L2/L3 Support
Data Analysis
ETL framework
Agile Methodology
EDUCATION
Master in Computer Application| IGNOU | Kolkata, IN | Jan 2003 – Dec 2005
Bachelor in Commerce| Calcutta University | Kolkata, IN | Jul '99 – Aug 2001
PROFESSIONAL EXPERIENCE
Senior IT Specialist
Optimum Solutions Pte. Ltd.
Feb '16 – Present
Changi, SG
Headquarter in Singapore, Optimum provides IT services in 7 countries with 2300+ employees across the globe with annual revenue ~$10 - 50 million
Development & Support Operations
Providing analysis, development, testing and support for data problems, reports and batch enhancements for our client
(UOB)
Handling quarterly CR activities by creating functional specification documents, managing data sources, and developing
ETL logics
Performing in-depth data validation, data management and quality control on data from various sources across the
bank
Developing codes in Base/Advance SAS to create new data extraction logic or enhance the existing logic
Performing root cause analysis and resolving data discrepancies escalated from end users
Handling adhoc requests from end users to extract data from Excel templates and generate the reports
Merging data with existing data sets and take extra care to keep old data sets intact and documenting it for future
reference
Creating test plans, use-case scenarios in test environment for unit testing, SIT and UAT to ensure quality checks before
code deployment
Deploying the solution into Production using Aldon, Clear Case and Clear Quest tool
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
Communicating effectively with project management regarding issues and needs for projects
Providing tutorials on current data management techniques including assisting with analysis and providing technical
recommendations
Process Enhancements
Implemented new optimized file management techniques to minimize the runtime /processing time of the batch
Implemented new back-up process for ~600 reports which helped to minimize risk of data loss and disaster recovery
Senior Software Engineer
Feb '13 – Feb '16
Seven N Consulting Pvt. Ltd.
Gurgaon, IN
Seven N is a Denmark based company with offices in8cities and has delivered cost-effective IT solutions to various clients in European region
ETL & Development Operations
Developed efficient codes in SAS Base/Advance, SAS/SQL using SAS EG and SAS DI tools for client (Bankdata)
Planned, analysed and designed complex business problem in conjunction with other technical specialists
Applied the business rules/logic on data using ETL techniques
Followed Agile/Scrum project methodology and tracked project time-lines using Version-One tool
Created test cases for the solutions, executed test cases and documented the test results
Resolved basic programming defects and errors identified during unit testing
Deployed codes into Test and Production environments using Infoman, RTC and DCM tools
Interacted with Danish counterparts to manage the scope of the projects to meet the project deadlines
Adhere to Best Practices and Standard Operating Procedures of the Process
KEY PROJECT
"Customer Credit Rating Data Preparation" | May '15 – Feb '16
Tech Stack: SAS EG 4.3, SAS DI Studio 4.2, SQL Server 2008
Developed SAS codes to derive new Customer Rating based on previous credit history
Utilized SAS and MS-Excel tools to track and analyse data to draw conclusions
Enhanced the complex BI logic to derive new rating for the customers by verifying the past transaction history
Optimized data collection procedures and generated reports on a weekly, monthly, and quarterly basis
Used advanced MS-Excel to create pivot tables, pivot reporting and VLOOKUP function to generate the reports of
customer’s rating to help identify the risk involved in the business
"Credit & Risk Data Preparation" | Feb '13 – May '15
Tech Stack: SAS EG 4.3, SAS DI Studio 4.2, SQL Server 2008
Cleansed, prepared and loaded modelled and un-modelled Credit Risk data into data warehouse
Extracted data resided in DB2 host and is transformed into SAS datasets using SAS EG and DI tools
Prepared test cases, conducted unit testing and fixed programming bugs in Test environment
Deployed codes/jobs into Production after successful completion of UAT
Provided post-production support for data validation
Lead Engineer
HCL Technologies Ltd.
Jul '11 – Feb '13
Noida, IN
With a presence in 44 cities worldwide, HCL has delivered cost-effective IT solutions and services to a lot of clients across the globe
Clinical Applications Support
Delivered L2 level support to client (Merck) for the various clinical applications using Base/Advance SAS and SQL
Managed and resolved incident/problem tickets efficiently with minimal business impacts and escalations
Analysed code and data to uncover problems and performed root cause analysis of defects
Enhanced codes and performed unit testing, SIT and UAT on the developed codes
Wrote and updated process support documentation
Project Associate | Jul '11 – Feb '13
Handled critical data flow in applications and resolved failed clinical data extraction by investigating error logs
Interacted with the business users and generated dashboard and SLA report for tickets resolution
Software Engineer
Oct '09 – Jun '11
Data & Server Migration
Analysed the risk involved by understanding the requirements of the client
Managed successful migration of critical production and contingency databases with no impact to business
Identified the application owners, the various files systems and UNIX servers and coordinated with them
Scheduled the file systems deletion/up-gradation to a new database version
Retrieved and backed-up the required data before the up-gradation process
Participated in weekly and monthly status meetings
Project Associate | Oct '09 – Jun '11
Facilitated, tracked and completed up-gradation to a new database version with proper back-up of repositories
Technical Specialist
HCL Technologies Ltd. - BSERV
Nov '06–Oct '09
Noida, IN
Technical Support Officer
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
Key Achievements
Achieved the 'Top-Performer Award' in Aug '07, Feb '08 and Apr '08
Played a key role in achieving 1st place as a team for 5 consecutive months from Jan '08 – May '08
CERTIFICATION
Certified Base SAS Programmer 9 | SAS | Mar '15
