Highlights:1. Worked for 1 year as Senior SAS Developer in 7N Consulting using SAS, Python, SQL, Power BI, Excel & Agile-Scrum 2. Worked for 4+ years as Senior SAS Developer & IT Support in UOB using Base/Advance SAS, SAS EG, SQL & Excel 3. Worked for 3 years as SAS developer in 7N Consulting using SAS EG, SAS DI, MS-SQL Server & Agile-Scrum 4. Worked for 3+ years as IT Operations & Application Support in HCL Technologies using SQL & Excel 5. Worked for 2+ years as Technical Support Officer in HCL BSERV

Skills:SAS, Pyhton, SQL, Data analysis, Unit Testing, MS-Excel, DWH Management, Spark, MongoDB, Power BI, ETL developer

Goal:I'm looking to explore and learn more on my skill sets as a data Analyst using Python, Base/Advance SAS, SQL, Power BI, Spark, MongoDB and Excel.

Certification:Certified Base SAS Programmer 9

Senior Software Engineer 02/2021 - 02/2022
Seven N Consulting Pvt Ltd, Gurgaon, India
Credit & Risk Management Project Developed client-side/Bankdata codes to derive new Customer Rating based on previous credit history
* Stakeholder management and interaction with onsite team(Bankdata); planned and analyzed complex business problems, designed functional specification documents and ETL mapping artifacts * Applied data modeling techniques to construct ER diagram/relational models, constructed new tables and performed data management as required by the project * Extracted data from MS-SQL Server 2018 and applied complex BI logics to transform it into SAS datasets and loading into the data warehouse / data marts * Created interactive dashboard/reports using Power BI using advance data transformation and cleaning techniques using Power Query and applied data modeling techniques in Power BI Desktop * Worked extensively with Advance analysis using Measure, Calculations, Background images, Maps, Trend Lines, Statistics and table calculations * Wrote SQL queries to create test scenarios which met the business requirements * Followed Scrum framework as a developer and tracked project time-lines using JIRA--
Senior IT Consultant 02/2016 - 12/2020
Optimum Solutions Pte. Ltd., Singapore, Singapore Singapore
Industry: Banking & Finance
Developing and implementing codes in SAS, SQL, Power BI, MS-Excel and ETL to manage the data flow issues in the DWH. Also managing and handling L2/L3 level support to the business units.
* Stakeholder management and coordinated with the BAU team(UOB), managed end-to-end quarterly project releases by planning, designing, coding, testing, defect tracking & deployment * Interacted with BAU team to gather requirements and designed functional specification after analyzing the changes * Extracted data from various data sources as TXT files and applied ETL techniques to transform it into SAS datasets * Planned test strategies by prioritizing the test cases based on critical business impact and designed test cases * Executed unit test, SIT, regression and verified test results by capturing screen-shots of successful test completions * Triggered batch runs to perform regression testing and validated the data consistency across all modules * Logged and tracked defects till successful closure; and re-tested and reviewed the progress of the test cycle * Supported business clients for UAT test preparation including resolving issues and collecting UAT approval sign-offs * Performed root cause analysis and resolved any data discrepancies escalated during UAT phase * Managed version control of codes and deployed the solution into Production using Rocket Aldon or IBM ClearCase * Scheduled and maintained the batch job streams using Control-M tool in Test and Production environments * Prepared Release notes, deployment packages and conducted walk-through of the release document with the Production support team; highlighted business impact & risks involved during project release * Provided post-implementation support by engaging with the BAU users to perform data verification and resolved any data discrepancies found in Production * Designed and maintained dashboard/reports using Power BI as part of the POC * Developed new back-up process for ~600 reports for internal analysis using SAS EG and Excel--
Senior Software Engineer 02/2013 - 02/2016
Seven N Consulting Pvt. Ltd., Gurgaon, Haryana India
Industry: IT Consulting
Credit & Risk Management Project Developed client-side/Bankdata codes to derive new Customer Rating based on previous credit history
* Planned, analyzed and designed complex business problem in conjunction with other technical specialists * Applied data modeling techniques to construct ER diagram/relational model in Visio, constructed new tables and performed data management as required by the project * Extracted data resided in SQL Server 2008 and applied complex BI logics, used ETL techniques to load into the DWH/data marts * Deployed codes into Test and Production environments using Infoman, RTC/IBM ClearCase and DCM tools and provided post-production support for data verification * Created POC using Python and SQL Server to design Credit Risk Engine and push the data into data warehouse * Followed Agile/Scrum framework and tracked project time-lines using Version-One tool--
Lead Engineer 07/2011 - 02/2013
HCL Technologies Ltd., Noida, Uttar Pradesh India
Industry: IT Consulting and Software Development
Delivered L2/L3 level support to Merck for the various clinical applications using Base/Advance SAS and SQL
• 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 5 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 10/2009 - 06/2011
HCL Technologies Ltd., Noida, Uttar Pradesh India
Industry: IT Consulting and Software Development
Delivered L1/L1.5 level support to Merck for clinical application
• Delivered L1/L1.5 level support to client (Merck) for the SDD (SAS Drug Development) application following ITIL processes • 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 • Performed data extraction for critical studies on special request from SPA--
Technical Specialist 11/2006 - 10/2009
HCL Technologies Ltd., Noida, Uttar Pradesh India
Industry: BSERV
Provided L1 level of on-call technical support to British Telecom broadband customers
• 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--

University of Calcutta 07/1998 - 06/2001
Kolkata, West Bengal, India
Degree: Bachelor's Degree
Major:Accounting and Commerce
B.Com Hons.(Bachelor of Commerce)

Amit Kumar Maji CV