Business Systems Analyst Resume

TECHNICAL SKILLS

Languages: Python,Py - spark,Kafka,Flume, Hadoop,MVS,TSO,Z/OS,JCL, COBOL/370,VS COBOL II, MF-COBOL,SQL, REXX, CA-EASYTRIEVE PLUS, SAS,NATURAL, WAAPDSUT, VISUALAGE, SMALLTALK, C, C++, UNIX Shell Script, AWK,SAP BW,SAS,R,PL/SQL, SAP BI

Access Methods: VSAM,QSAM,BDAM

DBMS: TERADATA,DB2, IMS/DB, ADABAS, MS-ACCESS, Oracle 9i,SQL SERVER, NETEZZA, SAP HANA

OLTP: CICS

OLAP: Business Objects, Cognos,SSIS,SSRS

ETL: Informatica 6.2,7.X,8.X, Data Stage

Tools: /Utilities: Teradata,FastExport, Fast Load, MLOAD, BTEQ, VISIO PROFESSIONAL, ZEKE,ZENA,VISIO,MS Office, MS Project 2003, SAP Crystal Reports XI, SAP Business Objects XI, Cognos 8, Xcelsius, Tableau,DYL-280, MQ Series, ERWIN, PLATINUM,STROBE,RSD, CA-VIEW, Princeton Data archive, UML, TSO/ISPF, SPUFI, SDFII, ENDEVOR, CHANGEMAN, FILE-AID, SORT, IEBGENR,IEBCOPY, ICETOOL, TOAD,XPEDITOR/TSO, BMC ARC,INTERTEST, SMARTTEST, SAM, CA-7, FTP,SFTP,JIRA,HP QualityCenter,QTP,GIT,GITHUB,R,Sailpoint IIQ,JIRA

PROFESSIONAL EXPERIENCE

Confidential

Business Systems Analyst

Responsibilities:

Identity and Access Management (GTM-MyAccess Mainframe)
Defined and developed SOP and confluence site for Mainframe profile onboarding.
Helped define the onboarding process from Product side. Successfully Onboarded 400+ profiles.
Worked closely with IGA engineering team to run aggregation of profiles in various sysplexes(70) and 120 LPARS.
Worked with MyAccess(Sailpoint IIQ) platform in onboarding Mainframe profiles as IT role.
Worked with IGA adoption team to run onboarding process, Jira metrics, compare process, attestation.
Engaged various LOB partners to profile onboarding. Helped them through office hour sessions.
Developed roles and responsibilities for Profile Owner. Engaged them for attestation of profiles.

Environment: JIRA,ITSM,Sailpoint IIQ, RSAM

Confidential

Data specialist

Responsibilities:

Hands on with python development,Devops CI/CD using Jenkins.
Acquired Python programmer and Data Analyst certification from Datacamp.
Extensively used pandas to load dataframe from csv and performed analysis.
Created Dockerfiles and Docker-compose files for running application in containers.
Researched Apache Airflow to replace Oozie and Cron as scheduling mechanism for Spark and python jobs.
Extensively used Pycharm, intelliJ, Jupyter notebook for python and scala development.
Design and developed data ingestion pattern using kafka and flume.
Created kafka topics, defined producer and consumer configurations.
Created flume agents and created config files to define source, sync and channels.
Created and maintained directory structures in HDFS through HUE as well as command line.
Executed performance test using locust frame work (python based) performance testing.
Worked on various data formats such as JSON,XML,Parquet. Used Pandas for conversion.
Extensively worked with Gitlab, participated in code walk through and approving merge request.
Ran a POC with Sqoop to ingest mainframe data to HDFS.
Monitored Oozie jobs and created a python module with retry logic using tenacity library.
Driven data and test strategies for modernization efforts.
Evaluated BVM(Business Volume metrics) for Ingestion and optimization.
Worked with defining application level security for new multi-tenant cluster.
Ingestion and Optimization of Business event data to Data Lake.
Driven performance test strategies and execution for Life Principle based reserves.
Drafted Business continuity plan and Technical recovery plan.
Performed as a bridge between Mainframe and newer technologies.

Environment: Python,Apache Spark,Kafka,Flume,Hadoop,Hue,Impala,Hive,Postgres,scala,sqoop,docker,DB2,Z/OS,Docker,GitGitlab

Confidential

Data Warehouse specialist

Responsibilities:

Worked on Project plans and status reporting.
Designed, developed and delivered EDW solution for history conversion of TX MOMs government program.
Worked on Tableau data visualization as part of profiling.
Designed handshake mechanism Axway (E-gateway) and Zeke, Zena Scheduling for automation of File pull and subsequently running of developed processes.
Worked with Teradata from both Mainframe and Unix Side.
Helped optimize Queries from the old EDW system.
Worked closely with QA with UAT and SIT using Quality Center.
Designed, developed and delivered Lovelace historical claim conversion.
Mentoring junior staff with technical challenges.
Developed MLOAD, BTEQMAIN, FASTLOAD procedures for Lovelace and NMCC conversion projects.
Helped ODS team with Datastage ETL development.

Environment: IBM S/390,MVS,COBOL 390, CICS, VSAM, DB2, JCL, FILEAID, IEBGENR, IEBCOPY,ICETOOL, ZEKE,INTERTEST,ENDEVOR,VISIO,USS,FTP,SFTP,MS Project, Teradata, MLOAD, BTEQMAIN, FASTLOAD, Datastage, HP QC, RTC

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship