We provide IT Staff Augmentation Services!

Us Consultant Resume

3.00/5 (Submit Your Rating)

ChicagO

Hire Now

SUMMARY

  • Around 7+ years of experience in Software engineering, ETL / Data warehousing, working in Banking/Insurance Domains.
  • Currently on valid H1 - B Visa, based in Chicago, Illinois, USA.
  • Extensively worked on ETL tool Ab Initio with good knowledge of Data Warehousing Concepts.
  • Good experience in requirement gathering, source system analysis, ETL Design, Support and Maintenance.
  • Sound experience working on multiple databases- Db2, Teradata, Oracle, SQL Server and Unix Scripting.
  • Strong passion for learning new technology and improving on the existing ones.
  • Experience in technologies - Mainframes, SSIS, Informatica, Metadata Hub, Java, Hadoop and Qlikview.
  • Involved in all phases of delivery lifecycle including estimation, build, testing, code migration and live support.
  • Capable of handling complex & critical deliverables within stipulated timelines.

PROFESSIONAL EXPERIENCE

Confidential, Chicago

Consultant

Responsibilities:

  • Enterprise rewards is a critical project for Discover Financial Services where the requirement is to reward the card members based on their credit usage.
  • This work involves implementing various Abinitio ETL Logic/ Business Process changes, catchup in Prod due to additional coverages added etc.
  • Effectively providing workarounds to resolve ad-hoc client issues/requests/patches and other service improvement efforts (automation/process optimisation) by combining business and technical knowledge.
  • Follow agile best practices and well versed with Agile terminologies, feature/increment planning etc.

Confidential, Hartford

Project Lead

Responsibilities:

  • Travelers is the second largest writer of U.S. commercial property casualty and personal insurance.
  • As a member of the Bond warehouse Agile team, worked on implementing various Abinitio graph modifications for field additions, history updates to the Fact and Dimension tables; using Metadata Hub to capture lineage etc.
  • Actively resolving interdependencies due to code / environment contentions and overcoming challenges posed by changing requirements while adhering to established timelines.

Confidential

Consultant

Responsibilities:

  • Built a platform for addressing custom business needs for reconciliation of various financial sources (including host legacy systems), consistent data quality analytics and scheduled/ad-hoc reconciliations. It makes extensive usage of Abinitio Conduct>It plans, scripts and PDL and Express>It BRE rules to reduce overhead for manual reports or balancing checks.
  • Gathered requirements on complex reconciliation scenarios through communication with Business Teams and following it with thorough analysis and feasibility study.
  • Led design meetings to create, manage and optimize the reconciliation framework and implemented the same, in an Agile delivery environment.

TECHNICAL SKILLS

Technologies: Abinitio, SQL Server 2008 Integration Services (SSIS), Express It (BRE), MetadataHub, Informatica, Cognos TM1, Java, Mainframes, QlikView, Hadoop, Conduct It

Databases: DB2, Teradata, SQL Server 2012, Oracle, IMS, MongoDb

Miscellaneous Tools: HP QC, Rally, Autosys, GitHub, Tivoli

Operating Systems: Windows, Unix

Domain Knowledge: Banking/Financial Risk Portfolio, Insuranc

Hire Now
Report an issue

We'd love your feedback!

Privacy Policy
Resume Categories
Client Services
Job Seekers
Visa Sponsorship