Aws - Sr. Analyst Resume
Greater Chicago Area, IL
SUMMARY
- History of success providing information technology services and business solutions to a broad range of clients through executing data quality strategies in line with the organization's strategic plan and goals.
- Driving innovation and efficiency through analyzing resource utilization and performance test data to identify variables impacting performance and scalability.
- Excellent knowledge in process optimization and operational efficiency in Banking Industry especially in Debit and Credit Card Domain.
- Expert in Client interfacing, requirements elicitation, data analysis, process modeling, enterprise QA and process improvements with extensive experience in SDLC, business analysis, business processes & project methodologies.
- Recognized for leadership in project planning, scheduling, prioritization, contingency and risk planning, work assignments, and definition of scope for information systems projects.
- Demonstrated ability to focus on high - payoff improvements to achieve immediate bottom-line benefits.
AREAS OF EXPERTISE
- Large-Scale Project Management
- Amazon Web Services
- Data Analysis
- Python
- Operational Reporting
- BI Reports/ Dashboards
- Cassandra/Oracle/DB2
- Mainframe Systems
- Jenkins/Maven/GitHUB
PROFESSIONAL EXPERIENCE
Confidential, Greater Chicago Area, IL
AWS - Sr. Analyst
Responsibilities:
- Development and Maintenance of Confidential Partnerships New Account Onboarding Applications which includes SNAP, CDM, SMG3.
- Developed several Python Scripts to consume, massage and refine data from different data sources before loading into RedShift and Snowflake tables.
- Migration of On Prem FTP into Cloud EFG (Elastic File Gateway).
- Migration of On Prem Data-Warehousing applications into AWS RedShift and Snowflake.
- Experienced in re-hydrating EC2 instances with latest for RMQ and KYC applications.
- Experienced in building infrastructure using AWS Cloud Formation and Python.
- Experienced in creating reports by extracting data from various data sources like RedShift, Cassandra, DynamoDB, Oracle, DB2 tables using Python and SQL queries.
- Analyzed the requirements and estimated the efforts.
- Created Functional Document and Technical Document for impacted modules.
- Executed end to end cycles for System and User testing.
- Created Unit Test scenarios and Test Case Documents for application end to end testing.
- Created adhoc reporting for LOB and stakeholders by fetching data from DB2 / Oracle using SQL queries publishing them using MS excel or Tableau Dashboards.
- Managing team of 2 offshore resources and assigning and tracking their deliverables.
Environment: Amazon Web Services, S3, EC2, ECS, Docker, RedShift, DynamoDB, Cassandra, Python, GitHub, ZOS, Mainframes, COBOL, JCL, DB2, VSAM, Mainframe-SAS, Microsoft office, Google Suite, Microsoft Visio, Oracle, Change man, Rest Services, Tableau, Splunk.
Confidential, Weehawken, NJ
Technical Lead
Responsibilities:
- IB (Internet Banking) and Mobile Banking are UBS’s most critical Applications. This project deals with the enhancing the existing applications with more capabilities and to make these interfaces user friendly.
- Also integrated Zelle payment processing application in Internet banking and Mobile banking applications.
- UBS is also enhancing its IB to One View. This means Customers can view all their accounts, their balances and Reward Status in single client Window. Also integrated Wealth management and trading applications within same one view application using complex micro services and Oracle and DB2 Stored Procedures.
- Customers can even initiate Lost/Stolen request through these applications and can request re-issue or reorder of their Debit or Credit Card.
- Involved in discussions with LOB and Stake Holders to understand their requirements.
- Analyzed the requirements and estimated the efforts.
- Created Functional Document and Technical Document for impacted modules.
- Executed end to end cycles for System and User testing.
- Created Unit Test scenarios and Test Case Documents for application end to end testing.
- Created adhoc reporting for LOB and stakeholders by fetching data from DB2 / Oracle using SQL queries publishing them using MS excel or Tableau Dashboards.
- Managing team of 3 offshore resources and assigning and tracking their deliverables.
Environment: ZOS, Mainframes, COBOL, JCL, DB2, VSAM, Mainframe-SAS, AQT, QC, Windows 7, MQ series, JAVA, MS-Excel, SharePoint, Microsoft office, Microsoft Visio, Oracle, Change man, Rest Services, Tableau.
Confidential, Cincinnati, OH
Technical Lead
Responsibilities:
- Managed and delivered Two different projects at same time with Zero Post Production defects.
- Mainframe application enhanced to process and approve different mode of Credit Card Authorizations like Mobile Transactions, Apple and Samsung Pay, Internet banking and POS. Along with this, bank also introduced two new credit card products (TRIO and Truly Simple).
- Involved in discussions with Stakeholders and LOB to understand their requirements.
- Converted Business and Functional documents into Technical Document and estimated development and unit testing efforts.
- Redesigned entire COBOL DB2 code to parameterize the products and corresponding logic in rewards calculation.
- Involved in doing complete end to end impact analysis for Introducing Master BIN range starting from 2.
- Wrote several Cobol DB2 programs to accommodate the changes and unit tested them.
- Created Unit Test scenarios and Test Case Documents for application end to end testing.
- Validated New Product Codes in output files and Database by executing several complex SQL queries and browsed mainframe file using File Manager and AQT.
- Managing a team of 10 offshore resources and tracking and reviewing their deliverables.
Environment: ZOS, Mainframes, COBOL, DB2, VSAM, JCL, AQT, CICS, HP Quality Center, Mainframe-SAS, MS-Excel, SharePoint, Microsoft office, Microsoft Visio, MQ Series, Changeman.
Confidential, Schaumburg, IL
Technical Lead
Responsibilities:
- This application deals with managing Production environment for Confidential credit card processing.
- Involved in tracking and analyzing P1 defects and route it to respective subsystem POC.
- Arranging and managing P1 bridge calls among all participants and stakeholders.
- Taking ownership of production deployments and tracking deployment status and publishing it to higher management.
- Managing offshore team of 10 resources and distributing and tracking their deliverables.
Environment: Mainframe, JCL, COBOL, Mainframe-SAS, CICS, MQ series, OPC.
Confidential, Cincinnati, OH
Technical lead
Responsibilities:
- This application deal with origination and processing of disputes raised by Vantiv customers. Software Development was in COBOL, JCL, VSAM, DB2, MQ series, JAVA, Oracle, ETL and Tableau.
- Involved in discussions with LOB with respect to requirements inspection.
- Understand the requirements and come up with development efforts.
- Created Functional and Technical requirement documents and get it approved by stakeholders and QA lead.
- Coded the changes and delivered the product with unit testing.
- Participated in QA testing, UAT and Post production testing.
- Production Validation and User Acceptance testing.
- Experience in both Waterfall & Agile based testing.
- Directed and supervised a team of 10 offshore resources and created WSR and MMR for higher management.
Environment: ZOS, Mainframes, COBOL, JCL, DB2, CICS, VSAM, SQL, Oracle, Changeman, MQ series, JAVA, Tableau, AQT.
Confidential
Sr. Software Engineer
Responsibilities:
- Worked in an application which is a corporate customer transaction facility created for the FTB customers to do payments. The Project covered addition of new enhancements to the application like financial transfers, Inter Account Transfers (IAT) and Adding beneficiaries, transferring fund in beneficiaries’ accounts, origination ACH transaction. Software Development was in COBOL, CICS, DB2 and JAVA.
- Involved in discussions with LOB to capture requirements and understand them for testing point of view.
- Involved in discussions with technical teams to gather the challenges faced in their unit testing so that QA can create test data to test those challenges.
- Involved in the Component design, Coding, Unit Testing, Integration Testing, Performance Link Testing, Regression Testing and User Acceptance Testing.
- Testing responsibilities included testing the overall functionality of the system, ensure connectivity between Java Frontend and Mainframe Backend using CICS calls, generation of test scenarios, execution and report generation, interacting with customers through issue tracker database to resolve issues.
- Conducted various management activities by working with the design team to resolve the issues.
- Created Test Data for unit, SIT and UAT testing phases.
Environment: Mainframe, COBOL, JCL, DB2, REXX, TWS, File Manager, SQL, MVS, ISPF, TSO, IDCAMS, CA7, IDCAMS, FILEAID, Oracle, Java, HTML, Internet Explorer.
Confidential
Vision Plus Developer
Responsibilities:
- Built Dev/SIT and UAT test environments for different projects.
- Developed test plans and test scripts on assigned subsystems.
- Create test data and tailor JCLs, control cards, and parameters.
- Responsible for logging test migration documents, from development to test and test to production.
- Monitor activities of test jobs in the Participant Service Environment (PSE) and assist in debugging any problems encountered while running the test daily cycle.
- Report to all testing participants any problems encountered while testing the application.
- Set up test Data.
- Set up job schedule for test jobs in CA-7.
- Run Job Scan Utility to check the Syntax of a modified JCL.
- Participate in Daily DRB meetings.
- Manage and monitor test environment resources.
- Verify NDM and FTP jobs to point to the correct test Nodes and IP Address.
- Verify that the Message Ques are up in the test environment to receive the test Ques.
- Used HP QC to log defects encountered in executing test cycles.
- Provide daily status to all participants involved in the testing.
- Create testing metrics report used for improving the testing process.
- Closely monitored Test Batches and resolved batch abends.
Environment: Mainframe, Vision plus, QC, COBOL, JCL, DB2, TWS, File Manager, CICS, MVS, ISPF, TSO, IDCAMS, CA7, DB2, SQL, COMPAREX, SUPERC, Change Management, COBOL, FTP/NDM, MQ.