We provide IT Staff Augmentation Services!

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.

We'd love your feedback!