Sr Business Info Analyst Resume
LOG IN OR REGISTER TO CONTACT ME
This button will open the login/register page in a new tab. After logging in, come back to this page and refresh your browser.
Resume:
Ketaki Uday Kulkarni
CURRICULUM VITAE
Address.................... N MacArthur Blvd.
Apt # Irving TX .
Phone............... .
Email....................
*Profile
I am an enthusiastic loyal and dedicated individual who wants to succeed in any given situation. I have extensive and varied experience in IT and Banking industry. I am a good learner and like to explore new avenues for myself. I am a strong team player and like to help others. I am seeking a position where I can develop and excel while giving my best to the company.
*Education Bachelor of Electrical Engineering
I graduated in Electrical Engineering with % from VNIT, India. It is one of the finest engineering institutions in India.
* Skill set
Technical Skills
•Operating System: Windows, DOS.
•Hardware Platforms: IBM/OS .
•Mainframe Technologies: SQL, TSO/ISPF, SDSF, MVS, COBOL, JCL, DB, VSAM, CICS, File-Aid, CA- Scheduling, NDM, Expediter, Librarian, Changeman, SPUFI, DCLGEN, IBM utilities.
•RDBMS: DB.
•SAS Technologies: Programming Language Base SAS, SAS Macros, SAS SQL.
Soft skills
•Strong team player •Quick learner •Self motivated
*Work Experience
Jul. Sr. Business Information Analyst at Hong Kong and
Shanghai Banking Corp. (HSBC NA) Chicago, IL.
I worked closely with the RSA (Risk Strategy and Analytics – modeling team) team to support their data requirements. I worked on number of assignments which were oriented towards the portfolio management. This involved maintaining existing reports, creation of new reports, maintaining existing SAS datamarts, developing new SAS datamarts as per the requirements.
Summary of the work •Working on data-driven, analytically framed solutions •Requirement gathering from the business area (SW group) • Writing technical specifications to translate business requirements into system specifications •Developing SAS SQL code for creation of datamart. •Developing Data manipulation code using SAS DATA steps, functions, PROCs, Macros, PROC SQL •Analyzing the data for data discrepancy and working on solutions for removing it •Meeting with the end user (SW group) to improve upon the datamart structure and educating them about its use. •Single handedly created the backfill of the mainframe SAS datamart for years and their copies on UNIX server. •Preparing and maintaining system documentation. •Supervising the work of junior team members as well as guiding them. •Conducting SAS training sessions and mentoring the junior members.
Oct. - May Business Information Analyst at Hong Kong and
Shanghai Banking Corp. (HSBC) India
I worked on number of assignments for the Consumer lending marketing team. The work involved following of different marketing campaigns – DM (Direct Mail), ITA(Invitation to apply), CLI(portfolio credit line increase), LC (Live Check) etc.
We created complex SAS DB datamarts which have important information about the past and present marketing campaigns. This work was utilized for Risk Strategy and Analytics purpose, to find out: Profitability of the campaigns, to determine the cost drivers, to forecast the profitability of future campaigns, to come up with better marketing strategies for the campaigns.
Summary of the work:
•Analysis of the campaign data and generation of detailed reports to help come up with better marketing strategies. •Supporting the data requirements of the marketing team – at times urgent ad hoc requests •data preparation, data validation for critical fields in the SAS datamart. •Developing Data manipulation code using SAS DATA steps, functions, PROCs, Macros, PROC SQL •Supporting and refining the existing marketing reports as well as working on new reports. •Worked closely with Sr. Managers and Director of the marketing team to analyze the existing campaigns and also to suggest improvements. •Involved in code changes and testing. • Involved in productionalization of the modules (SAS and JCLs). •Supervising the work of junior team members as well as guiding them. •Conducting SAS training sessions and mentoring the junior members.
I also performed the role of BISO (Business Information Security officer) for my team, this involved resolving the network issues and making sure that all the team members adhere to the process guidelines.
Apr. – Oct. Software Engineer for Computer Sciences
Corporation (CSC)
I attended training on Umbrella architecture & programming, CIS functional & technical concepts for HOGAN card and merchant system. Thsi project was developed for the client Toshiba Finance (TF) I had a chance to work on various areas like LASS (Loan Accounting), CASS (Card Accounting). I was sent to Tokyo (CSC-JPN) for duration of months. I worked at the client location to do enhancement work related to the online system.
Summary of the work: •Worked on Interface File task which dealt with creation of the interface files needed by Toshiba finance. •Worked on modifications of CIS screens. •Involved in UAT bath runs. I was awarded “Certificate of Achievement”, for completing problem logs in a month. I also received appreciation from the client while working on the interface task.
Jun. – Mar. Associate Consultant for Capgemini
OnDemand, IBM Jan - Mar : Deputy Team lead
This project dealt in customizing an IBM Tool called ONDEMAND for the client HSBC.
Summary of the work: •Wrote COBOL DB programs to extract data from files, spool and to store it in DB tables, did their testing in mock regions and the documentation. •Also got exposure to do managerial tasks like distribution of the work to the team members, getting various issues solved by communicating directly with the client.
Data Architecture Group, Apr. - Dec. : Team Member
This project dealt with the maintenance of the various databases for HSBC NA (formerly known as Household group). I worked on up gradation from Whirl. to Whirl . task.
Summary of the work: •Did analysis of the system in order to find out affected modules like source codes, copybooks, PROCs, JCLs, Control cards. •Involved in modifying of the affected modules as well as writing new codes. •Did testing by conducting batch runs in the mock regions. •Wrote SAS SQL code to create test reports for SAS DB components.
Auto , Sep. – Mar. : Team Member
It was completely a development project, which required us to automate the entire system of Automobile Finance at HSBC NA. It was developed from the scratch and required working on the demographic as well as the loan accounting part.
Summary of the work: •Developed COBOL DB programs to update demographic information of the clients, as per the functional and technical specifications •Involved in the testing of the code in mock regions. •Wrote development JCLs, documentation of the testing. •Review of the codes developed by team members.
* References
Available on request.
