Lead Business Analyst / Data Analyst Resume
2.00/5 (Submit Your Rating)
Columbus, OhiO
SUMMARY:
- 12 years of experience in Information Technology with a strong background in Application Development & Testing, Business/Data Analysis, Data Governance, Production Support.
- Sound knowledge of Banking & Financial Services domain concepts: Customer Information System, Customer Profile & Demographics, Customer - Account relationship profile, Customer Privacy & Compliance, Client List Screening, Know Your Customer / Due Diligence, New Account screening & SSN Contention / resolution, Customer Household & Market Segmentation, Trillium (Customer Name, Address scrub & Matching), TCPA, SCRA.
- Sound Knowledge in Data Cleansing, Data Analysis & Mapping, Transformation & Load. (5+ Years of experience in projects like Bank Mergers & Acquisitions, Re-engineering Legacy Systems)
- Expertise in Mainframes, COBOL, JCL, DB2, CICS, IMS DB/DC, PACBASE, REXX, Easytrieve.
- Experience in Teradata, SQL Assistant, Analyzing AB Initio Graphs
- Interacting with business groups, subject matter experts and cross LOB teams for gathering requirement.
- Proficient in Business analysis, Requirements Gathering & Elicitation, Design, Development & Test Plan preparation, User Acceptance Testing.
- Hands on experience in tuning SQL queries, mappings, identifying and resolving performance bottlenecks.
- Developed mappings to load type 1 and type 2 Slowly Changing Dimensions.
- Good knowledge of Data warehouse concepts and principles (Kimball/Inman) - Star Schema, Snowflake, SCD, Normalization/De normalization.
- Strong analytical and communication skills and an eagerness to learn new technologies.
TECHNICAL SKILLS:
Programming Languages: COBOL, Easytrieve, JCL, REXX, PACBASE, SQL, CICS, IMS DC / MFS Maps
ETL Tools: Ab Initio
Databases / File System: DB2, Teradata, IMS, VSAM
Scheduling: Zeke
Utility Tools: SQL Assistant, SPUFI, File Aid, File Aid for DB2, File Aid for IMS, Xpediter, QMF, Changeman
Operating Systems: Mainframe Z-OS/390, Windows.
Software/Applications: MS Office, ITSM-Change Management, HP-ALM, Blueprint
PROFESSIONAL EXPERIENCE:
Confidential,Columbus,Ohio
Lead Business Analyst / Data Analyst
Responsibilities:- Provide subject matter expertise to the development and business teams.
- Support Legal and Compliance team for various lawsuits.
- Capture possible data quality gaps and provide resolution
- Validate data integrity by performed intensive level of data reconciliation between various data marts.
- Extensive data analysis by fetching data using SQL queries.
- Participate in Business Requirement discussions and JADs during Enterprise releases
- Create Functional Requirement Documents
- Support end-users queries on analytical data
Confidential,Columbus,Ohio
Lead Developer
Responsibilities:- Strong analytical and communication skills and an eagerness to learn new technologies.
- System Analysis, High Level Design, Coding, Testing and Implementation.
Confidential,Columbus,Ohio
Lead Developer
Responsibilities:- On-call Support for Production Issues, On-Call Escalator, Application ticket handling / resolution.
Confidential,Columbus,Ohio
Lead Developer
Responsibilities:- Data analysis & Mapping, Data cleansing, design, coding, testing and implementation.
Confidential,Columbus,Ohio
Programmer Analyst
Responsibilities:- Analyzing / Documenting legacy system functionalities, Strategy discussions, Functional design, Coding, Testing, Implementation.
Confidential
Programmer Analyst
Responsibilities:- Data analysis & Mapping, Data cleansing, design, coding, testing and implementation.